| id |
bigint |
Yes |
Yes |
nextval('purchase_receipts_id_seq'::regclass) |
Unique identifier |
| order_id |
integer |
No |
No |
|
Refers to the open Purchase Order for this record - links to purchase_orders.id |
| history_id |
integer |
No |
No |
|
Refers to the closed Purchase Order for this record - links to purchase_history.id |
| inventory_id |
integer |
No |
No |
|
Refers to the Inventory item on this record - links to inventory.id |
| inventory_receipt_id |
bigint |
No |
No |
|
Refers to the Inventory Receipt record - links to inventory_receipts.id |
| item_type |
smallint |
No |
No |
|
Item record type for this line; 1 = Inventory item 2 = Non Inventory item 4 = Serial/Lot numbered item 5 = Non Physical item |
| whse |
character varying(6) |
Yes |
No |
|
Inventory warehouse for this record - links to inventory.whse |
| part_no |
character varying(34) |
Yes |
No |
|
Inventory part number for this record - links to inventory.part_no |
| description |
character varying(80) |
No |
No |
|
Description of the item |
| guid |
character varying(32) |
No |
No |
|
GUID of the Purchase Order line that this record was received on |
| receive_date |
date |
No |
No |
|
Date iem was received |
| whse_location |
character varying(20) |
No |
No |
|
Physical location in warehouse for item |
| receive_qty |
numeric(15,5) |
No |
No |
|
Quantity received at this time |
| receive_uom |
character varying(10) |
No |
No |
|
Unit of measure received - links to inventory_uoms |
| receive_cost |
numeric(15,5) |
No |
No |
|
Cost of item received |
| currency |
character varying(3) |
No |
No |
|
Vendor currency; blank = base currency - links to currencies.code |
| currency_rate_method |
character varying(1) |
No |
No |
|
Currency rate conversion method used; / = direct * = indirect |
| currency_rate |
numeric(13,7) |
No |
No |
|
Currency rate used |
| duty |
numeric(15,5) |
No |
No |
|
Duty amount on this line |
| vendor_freight |
numeric(15,5) |
No |
No |
|
Vendor freight allocated to this line |
| freight |
numeric(15,5) |
No |
No |
|
Landed freight on this line |
| weight |
numeric(15,5) |
No |
No |
|
Item weight |
| inventory_qty |
numeric(15,5) |
No |
No |
|
Quantity received converted to Inventory unit of measure |
| inventory_uom |
character varying(10) |
No |
No |
|
Inventory unit of measure - links to inventory_uoms |
| inventory_cost |
numeric(15,5) |
No |
No |
|
Cost converted to Inventory unit of measure |
| sell |
numeric(15,5) |
No |
No |
|
Sell Price 1 |
| ref_no |
character varying(20) |
No |
No |
|
Reference number from the Purchase Order line |
| tax_applicable |
numeric(15,2)[] |
Yes |
No |
'{0,0,0,0}'::numeric[] |
Tax 1 - 4 applicable flags |
| _dbversion |
integer |
No |
No |
|
Program version that last modified 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 |
| _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 |