id |
integer |
Yes |
Yes |
nextval('inventory_lot_transactions_id_seq'::regclass) |
|
whse |
character varying(6) |
Yes |
No |
|
Warehouse for serialized item |
part_no |
character varying(34) |
Yes |
No |
|
Part number for serialized item |
number |
character varying(40) |
Yes |
No |
|
Serial number |
link_type |
character varying(4) |
Yes |
No |
|
Where transactrion came from PORD = Purchasae order, Production order or adjustment SHIS = Posted Invoice |
link_no |
character varying(10) |
Yes |
No |
|
The document number that created transaction Adjustment Purchase Order Invoice Production order |
link_guid |
character varying(32) |
No |
No |
|
GUID linking to the line of a sales, purcahse or production order that created this transaction |
receipt_no |
bigint |
No |
No |
|
Receipt number from when serial/lot was received |
receipt_date |
date |
No |
No |
|
Receipt date for serial or lot number |
unit_cost |
numeric(15,5) |
Yes |
No |
|
Cost of serial or lot number |
recvd_qty |
numeric(15,5) |
Yes |
No |
|
Quantity of serial or lot number received. Always 1 or -1 for serial number |
sales_qty |
numeric(15,5) |
Yes |
No |
|
Quantity sold of the serial or lot number. Always 0 or 1 for a serial number. |
_dbversion |
integer |
No |
No |
|
|
_created |
timestamp without time zone |
No |
No |
|
|
_created_by |
character varying(3) |
No |
No |
|
|
_modified |
timestamp without time zone |
No |
No |
|
|
_modified_by |
character varying(3) |
No |
No |
|
|