po_line

po_id

string40

Y

N

The ID of the purchase order.

po_line_no

int32

Y

N

The number that identifies the line in the purchase order.

item_id

string40

N

N

The ID of the item being ordered.

vendor_item_id

string40

N

Y

The ID used by the vendor 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. Assumed to scale linearly between min_qty and max_qty.

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

string1000

N

Y

Use defined by language term 560.

spare2

string1000

N

Y

Use defined by language term 561.

spare3

string1000

N

Y

Use defined by language term 562.

spare4

string1000

N

Y

Use defined by language term 563.

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

Who last changed this record.

last_edit_at

tdatetime

N

N

When this record was last changed.

row_id

ID 1

N

N

Unique row identifier, for audit trail.