po

po_id

string40

Y

N

The PO identifier.

vend_id

string40

N

Y

The vendor identifier.

seller_id

int32

N

Y

The ID of the seller from whom this order was purchased.

ship_to

int32

N

Y

The ID of the entity at which purchased goods are to be received.

date_issued_utc

tdatetime

N

N

The date when the purchase order was issued, in UTC.

date_issued_local

tdatetime

N

N

The date when the purchase order was issued, in local time.

state_cd

int32

N

N

Holds a value that indicates the state of this purchase order:

0 = open (default)

1 = partially complete

2 = complete

3 = closed

notes

nvarchar(max)

N

Y

Notes about the purchase order.

spare1

string1000

N

Y

Use defined by language term 556.

spare2

string1000

N

Y

Use defined by language term 557.

spare3

string1000

N

Y

Use defined by language term 558.

spare4

string1000

N

Y

Use defined by language term 559.

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.