so_line

cust_id

string40

Y

N

The customer ID.

po_id

string40

Y

N

The ID of the customer's PO.

so_line_no

int32

Y

N

The number that identifies the line in the sales order.

item_id

string40

N

N

The ID of the item being ordered.

customer_item_id

string40

N

Y

The ID used by the customer to identify the item being ordered.

quantity

tfloat

N

N

The nominal quantity of the item being ordered.

uom_id

int32

N

Y

The ID of the unit of measure for the item being ordered.

min_qty

tfloat

N

N

The minimum quantity that, once shipped, will allow the order to be completed. If a value is supplied, it must be less than or equal to the quantity field value. If a value is not supplied, defaults to the quantity field value.

max_qty

tfloat

N

Y

The maximum quantity that can be shipped against this line item. If null is supplied, there is no limit. If a value is supplied, it must be greater than or equal to the quantity field value. The default is null.

line_price

tfloat

N

Y

The total price for this line item.

reqd_by_utc

tdatetime

N

Y

The date by when goods for this line item are required, in UTC.

reqd_by_local

tdatetime

N

Y

The date by when goods for this line item are required, in local time.

spare1

string80

N

Y

Use defined by language term 4346.

spare2

string80

N

Y

Use defined by language term 4347.

spare3

string80

N

Y

Use defined by language term 4348.

spare4

string80

N

Y

Use defined by language term 4349.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record.

last_edit_at

tdatetime

N

N

When this record was last changed.

mod_id

timestamp

N

N

A binary number that increments each time the row is modified.

row_id

ID 1

N

N

Unique row identifier, for audit trail.