| id |
bigint |
Yes |
Yes |
nextval('inventory_receipts_id_seq'::regclass) |
Unique identifier and receipt number |
| receive_date |
date |
No |
No |
|
Date of inventory receipt |
| vendor_no |
character varying(20) |
No |
No |
|
Vendor code item received from- links to vendors.vendor_no |
| whse_location |
character varying(20) |
No |
No |
|
Warehouse physical location at time of receipt |
| qty |
numeric(15,5) |
No |
No |
|
Quantity received |
| cost |
numeric(19,5) |
No |
No |
|
Cost of part number received |
| selling |
numeric(15,5) |
No |
No |
|
Sell price at time of receipt |
| link_no |
character varying(10) |
No |
No |
|
The document number that posted receipt; Adjustment number Production Order number Purchase Order number Sales Order number (customer return) Transfer number |
| remaining_qty |
numeric(15,5) |
No |
No |
|
Remaining quantity available at this cost when using FIFO or LIFO cost |
| ref_no |
character varying(20) |
No |
No |
|
Reference number from the Purchase Order or Inventory Adjustment |
| uom_inventory |
character varying(10) |
No |
No |
|
Inventory or stock unit of measure |
| uom_receive |
character varying(10) |
No |
No |
|
Receipt unit of measure |
| qty_receive_uom |
numeric(15,5) |
No |
No |
|
Quantity received of the purchase unit of measure |
| _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 |
| link_table |
character varying(4) |
No |
No |
|
The module that received the item; BHIS = Production Order PORD = Purchase Order or Adjustment SORD = Sales Order (customer return) |
| inventory_id |
integer |
Yes |
No |
|
Inventory item for this receipt - links to inventory.id |
| link_guid |
character varying(32) |
No |
No |
|
Link to source record; inventory_count_items.guid production_history_items.guid production_order_items.guid purchase_history_items.guid purchase_order_items.guid sales_history_items.guid sales_order_items.guid |
| new_average_cost |
numeric(19,5) |
No |
No |
|
New value written to inventory.average_cost at the time of this receipt |
| new_onhand_qty |
numeric(15,5) |
No |
No |
|
New value written to inventory.onhand_qty at the time of this receipt |