transfer_list

transfer_type

int32

N

N

Enumeration of the type of the transfer:

1 = Pick list

2 = Putaway list

3 = General transfer

4 = Preweigh

cust_id

string40

N

Y

Customer, if picking shipment

order_id

string40

N

Y

Cust. PO, if picking shipment, or PO to be put away

line_no

int32

N

Y

SO line if xfer_type = 1, or PO line if known if xfer_type = 2

date_of_shipment_utc

tdatetime

N

Y

When received or to be shipped in UTC

date_of_shipment_local

tdatetime

N

Y

When received or to be shipped in local time

wo_id

string40

N

Y

Work order ID of job for which transfer occurred; will be null unless transfer_type is 4

oper_id

string40

N

Y

Operation ID of job for which transfer occurred; will be null unless transfer_type is 4

seq_no

int32

N

Y

Sequence number of job for which transfer occurred; will be null unless transfer_type is 4

bom_pos

int32

N

Y

Reference to job_bom row; will be null unless transfer_type is 4

to_ent_id

int32

N

N

To where material is to be stored

item_id

string40

N

N

Item to be stored

lot_no

string40

N

Y

Lot to be stored

sublot_no

string40

N

Y

Sublot to be stored

grade_cd

int32

N

Y

Grade of material to store

status_cd

int32

N

Y

State of material to store

qty_to_store

tfloat

N

N

Quantity to be stored

uom_id_store

int32

N

Y

Unit of measure of qty_to_store

expiry_date_utc

tdatetime20

N

Y

Expiry date and time of the material to store, in UTC

expiry_date_local

tdatetime20

N

Y

Expiry date and time of the material to store, in the local time of the new location

from_ent_id

int32

N

N

From where material is to be picked

from_item_id

string40

N

Y

Item to be picked, if different; must match po_line.item_id if transfer_type = 2. If null assume same as item_id

from_lot_no

string40

N

Y

Lot to be picked, if different; if null assume same as lot_no

from_sublot_no

string40

N

Y

Subot to be picked, if different; if null assume same as sublot_no

from_grade_cd

int32

N

Y

Grade of material to be picked, if different; if null assume same as grade_cd

from_status_cd

int32

N

Y

State of material to be picked, if different; if null assume same as status_cd

qty_to_pick

tfloat

N

Y

Quantity to be picked, if different; if null, assume same as qty_to_store

uom_id_pick

int32

N

Y

Unit of measure of qty_to_pick

from_expiry_date_utc

tdatetime20

N

Y

Expiry date and time of the material being transferred from the old location if different than the expiry date and time of the material at the new location, in UTC. If null, assume it is the same as the expiry date and time of the material at the new location.

from_expiry_date_local

tdatetime20

N

Y

Expiry date and time of the material being transferred from the old location if different than the expiry date and time of the material at the new location, in the local time of the old location. If null, assume it is the same as the expiry date and time of the material at the new location.

trans_id

int32

N

Y

Reference to item_transfer row

spare1

string80

N

Y

Use defined by language term 5209

spare2

string80

N

Y

Use defined by language term 5210

spare3

string80

N

Y

Use defined by language term 5211

spare4

string80

N

Y

Use defined by language term 5212

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

Y

N

Unique row identifier, for audit trail.