| id |
integer |
Yes |
Yes |
nextval('inventory_lot_trace_id_seq'::regclass) |
Unique identifier |
| parent |
integer |
No |
No |
|
Link record for the parent of this record |
| found |
boolean |
No |
No |
|
Found flag; FALSE = Not found TRUE = Found |
| type |
character varying(4) |
No |
No |
|
Trace record type; BORC = Production Order component BHIC = Production History componet PORD = Purchase Order SHIS = Sales History Invoice SORD = Sales Order |
| whse |
character varying(6) |
No |
No |
|
Warehouse for record - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Part number for record - links to inventory.part_no |
| lot_no |
character varying(40) |
No |
No |
|
Lot number for record - links to inventory_serial_numbers.number |
| link_type |
character varying(4) |
No |
No |
|
Lot number found on record type; Trace record type; BORD = Production Order BHIS = Production Histort build PORD = Purchase Order SHIS = Sales History Invoice SORD = Sales Order |
| link_no |
character varying(10) |
No |
No |
|
Lot number found on reference number - Purchase Order number, Sales Order number, Invoice number or Production Order number |
| link_guid |
character varying(32) |
No |
No |
|
GUID for link to reference line |
| receipt_no |
bigint |
No |
No |
|
Link to inventory_receipts.id |
| receipt_date |
date |
No |
No |
|
Receipt date recorded on record |
| unit_cost |
numeric(15,5) |
No |
No |
|
Cost recorded on record |
| received_qty |
numeric(15,5) |
No |
No |
|
Received quantity recorded on record |
| sales_qty |
numeric(15,5) |
No |
No |
|
Sales quantity recorded on record |