| id |
integer |
Yes |
Yes |
nextval('inventory_lot_numbers_id_seq'::regclass) |
Unique identifier |
| whse |
character varying(6) |
Yes |
No |
|
Warehouse for this item - links to inventory.whse |
| part_no |
character varying(34) |
Yes |
No |
|
Part number for this item - links to inventory.part_no |
| number |
character varying(40) |
Yes |
No |
|
Serial/lot number assigned |
| closed |
boolean |
Yes |
No |
|
Serial/lot number has been consumed by sales or production, or it has been returned to vendor |
| unit_cost |
numeric(15,5) |
Yes |
No |
|
Cost of this serial/lot number |
| last_received_date |
date |
No |
No |
|
Received date of this serial number or the last date an item with this lot number was received |
| expiry_date |
date |
No |
No |
|
Expiry date of this lot number |
| available_qty |
numeric(15,5) |
Yes |
No |
|
Available quantity of this serial/lot number |
| committed_qty |
numeric(15,5) |
Yes |
No |
|
Commited quantity of this serial/lot number |
| temp_qty |
numeric(15,5) |
Yes |
No |
|
Quantity of serial or lot number that is has been selected in a Serial/Lot number dialog but the Sales Order or Production has not been saved yet |
| selling |
numeric(15,5) |
No |
No |
|
Sell price for this serial/lot number |
| hold |
boolean |
Yes |
No |
|
Serial/lot number is On Hold and cannot be selected; FALSE = Not on hold TRUE = On hold |
| _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 |