shipment

cust_id

string40

Y

N

Identify customer

po_id

string40

Y

N

Identify customer PO

so_line_no

int32

Y

N

Identify line in SO

ship_date_utc

tdatetime

Y

N

When shipped in UTC

ship_date_local

tdatetime

N

N

When shipped in local time

ship_via

string80

N

Y

How shipped

ship_by

string40

N

Y

Who shipped it

ship_from

int32

N

Y

From where shipment made

spare1

string80

N

Y

Use defined by language term 564

spare2

string80

N

Y

Use defined by language term 565

spare3

string80

N

Y

Use defined by language term 566

spare4

string80

N

Y

Use defined by language term 567

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