item_transfer

wo_id

string40

N

Y

Work order ID of job for which transfer occurred, if recording an allocation; new work order by which inventory was produced, if producing job changed

oper_id

string40

N

Y

Operation ID of job for which transfer occurred, if recording an allocation; new operation by which inventory was produced, if producing job changed

seq_no

int32

N

Y

Sequence number of job for which transfer occurred, if recording an allocation; sequence number of new job by which inventory was produced, if producing job changed

bom_pos

int32

N

Y

Item in BOM for which transfer occurred; used only for allocations

to_ent _id

int32

N

Y

To which storage entity

item_id

string40

N

N

Identify item transferred to new location

lot_no

string40

N

Y

Identify lot transferred to new location

sublot_no

string40

N

Y

Identify sublot transferred to new location

grade_cd

int32

N

Y

Grade of material transferred to new location.

status_cd

int32

N

Y

State of material transferred to new location.

qty_txd

tfloat

N

N

Quantity transferred to new location

uom_id

int32

N

Y

Unit of measure for qty_txd

expiry_date_utc

tdatetime20

N

Y

Expiry date and time of material transferred to the new location, in UTC

expiry_date_local

tdatetime20

N

Y

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

to_spare1

string80

N

Y

Value of item_inv.spare1 after transfer

to_spare2

string80

N

Y

Value of item_inv.spare2 after transfer

to_spare3

string80

N

Y

Value of item_inv.spare3 after transfer

to_spare4

string80

N

Y

Value of item_inv.spare4 after transfer

to_spare5

string80

N

Y

Value of item_inv.spare5 after transfer

to_spare6

string80

N

Y

Value of item_inv.spare6 after transfer

from_wo_id

string40

N

Y

Original work order by which inventory was produced, if producing job changed

from_oper_id

string40

N

Y

Original operation by which inventory was produced, if producing job changed

from_seq_no

int32

N

Y

Sequence number of original job by which inventory was produced, if producing job changed

from_ent_id

int32

N

Y

From which storage entity

from_item_id

string40

N

Y

Item transferred from old location. If null, assume it was the same as item_id.

from_lot_no

string40

N

Y

Lot number transferred from old location. If null, assume it was the same as lot_no.

from_sublot_no

string40

N

Y

Sublot number transferred from old location. If null, assume it was the same as sublot_no.

from_grade_cd

int32

N

Y

Grade of material transferred from old location. If null, assume it was the same as grade_cd.

from_status_cd

int32

N

Y

State of material transferred from old location. If null, assume it was the same as state_cd.

from_qty_txd

tfloat

N

Y

Quantity transferred from old location. If null, assume it was the same as qty_txd.

from_uom_id

int32

N

Y

Unit of measure for from_qty_txd. If null, assume it is the same as uom_id.

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.

from_spare1

string80

N

Y

Value of item_inv.spare1 before transfer

from_spare2

string80

N

Y

Value of item_inv.spare2 before transfer

from_spare3

string80

N

Y

Value of item_inv.spare3 before transfer

from_spare4

string80

N

Y

Value of item_inv.spare4 before transfer

from_spare5

string80

N

Y

Value of item_inv.spare5 before transfer

from_spare6

string80

N

Y

Value of item_inv.spare6 before transfer

qty_txd_erp

tfloat

N

Y

Quantity transferred, as sent to ERP

goods_received

logical

N

N

Were goods received from supplier? Default = No.

goods_shipped

logical

N

N

Were goods shipped to customer? Default = No.

transfer_list_row_id

int32

N

Y

Transfer list record for which this row is a partial or complete fulfillment

Note: This field is currently not used.

comments

string254

N

Y

Optional explanation field for this inventory transfer

Note: This field is currently not used.

transfer_by

string40

N

Y

ID of user who made the transfer

transfer_time_utc

tdatetime

N

N

When transfer occurred in UTC

transfer_time_local

tdatetime

N

N

When transfer occurred in local time

mod_id

timestamp

N

N

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

trans_id

ID 1

Y

N

Unique ID for each transfer (sequence/identity)