| id |
integer |
Yes |
Yes |
nextval('inventory_lot_transactions_id_seq'::regclass) |
Unique identifier |
| whse |
character varying(6) |
Yes |
No |
|
Warehouse for this record - links to inventory_serial_numbers.whse |
| part_no |
character varying(34) |
Yes |
No |
|
Part number for this record - links to inventory_serial_numbers.part_no |
| number |
character varying(40) |
Yes |
No |
|
Serial/lot number for this record - links to inventory_serial_numbers.number |
| link_type |
character varying(4) |
Yes |
No |
|
Source of this transaction; BORD = Production Order (Committed) BHIST = Posted Production Order (Built) PORD = Purchase Order, Inventory Adjustment SHIS = Posted Invoice SORD = Sales Order (Committed) |
| link_no |
character varying(10) |
Yes |
No |
|
The document number that created transaction; Adjustment numner Invoice number Purchase Order number Production Order number Sales Order number |
| link_guid |
character varying(32) |
No |
No |
|
GUID linking to the line of the Sales, Purchse or Production Order that created this transaction |
| receipt_no |
bigint |
No |
No |
|
Inventory Receipt number when serial/lot was received |
| receipt_date |
date |
No |
No |
|
Receipt date for serial/lot number |
| unit_cost |
numeric(15,5) |
Yes |
No |
|
Cost of serial/lot number |
| recvd_qty |
numeric(15,5) |
Yes |
No |
|
Quantity of serial/lot number received, only 1 and -1 are supported for serial number records |
| sales_qty |
numeric(15,5) |
Yes |
No |
|
Quantity of serial/lot number sold, only 1 and -1 are supported for serial number records |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |