receipt_lot
- Last UpdatedNov 20, 2024
- 1 minute read
Note: This table is currently not used.
The receipt_lot table records the lot numbers of incoming material.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
po_id |
string40 |
N |
N |
Identify PO |
|
date_rcvd_utc |
tdatetime |
N |
N |
When received in UTC |
|
date_rcvd_local |
tdatetime |
N |
N |
When received in local time |
|
item_id |
string40 |
N |
N |
What was received |
|
lot_no |
string40 |
N |
Y |
Lot identifier |
|
sublot_no |
string40 |
N |
Y |
Sublot identifier |
|
quantity |
tfloat |
N |
N |
Quantity of lot received |
|
uom_id |
int32 |
N |
Y |
Unit of measure for receipt |
|
trans_id |
int32 |
N |
Y |
Row in item_transfer, if inventory licensed. If not null, date_rcvd, lot_no, and quantity in this table will match transfer_time, to_lot_no, and to_qty_txd in item_transfer. |
|
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 |
FK from po_id, date_rcvd_utc, item_id to receipt. (Cascade delete)
FK from trans_id to item_transfer (Set null)
FK from uom_id to uom. (Set null)
po_id, date_rcvd_utc, item_id, lot_no, sublot_no is UK.