| id |
integer |
Yes |
Yes |
nextval('purchase_history_items_id_seq'::regclass) |
Unique identifier |
| po_number |
character varying(10) |
No |
No |
|
Purchase Order number |
| sequence |
smallint |
No |
No |
|
Sequential number for order line |
| whse |
character varying(6) |
No |
No |
|
Inventory warehouse for this record - links to inventory.whse |
| part_no |
character varying(34) |
No |
No |
|
Inventory part number for this record - links to inventory.part_no |
| description |
character varying(80) |
No |
No |
|
Description of item |
| product_code |
character varying(10) |
No |
No |
|
Product Code assigned to the item - links to inventory_product_codes.product_code |
| uom_purchase |
character varying(10) |
No |
No |
|
Purchase unit of measure - links to inventory_uoms |
| uom_inventory |
character varying(10) |
No |
No |
|
Inventory unit of measure - links to inventory_uoms |
| uom_sales |
character varying(10) |
No |
No |
|
Sales unit of measure - links to inventory_uoms |
| order_qty |
numeric(15,5) |
No |
No |
|
Quantity ordered |
| received_qty |
numeric(15,5) |
No |
No |
|
Quantity received |
| inventory_order_qty |
numeric(15,5) |
No |
No |
|
Quantity ordered converted to Inventory unit of measure |
| inventory_received_qty |
numeric(15,5) |
No |
No |
|
Quantity received converted to Inventory unit of measure |
| last_received_qty |
numeric(15,5) |
No |
No |
|
Last received quantity |
| serialized_qty |
numeric(11) |
No |
No |
|
Serialized quantity received |
| retail_price |
numeric(15,5) |
No |
No |
|
Price before line discount |
| unit_price |
numeric(15,5) |
No |
No |
|
Price after line discount |
| status |
smallint |
No |
No |
|
Pricing status; 0 = price taken from Inventory current cost 5 = Vendor Price used 9 = user typed price |
| whse_location |
character varying(20) |
No |
No |
|
Physical location in warehouse for item |
| vendor_part_no |
character varying(34) |
No |
No |
|
Vendor part number from Vendor Price table |
| guid |
character varying(32) |
No |
No |
|
Unique identifier for linking to other tables; inventory_serial_transactions.link_guid inventory_receipts.link_guid inventory_requisitions_targ_guid purchase_receipts.guid |
| item_type |
smallint |
No |
No |
|
Item record type for this line; 1 = Inventory item 2 = Non Inventory item 3 = Comment 4 = Serial/Lot numbered item 5 = Non Physical item |
| last_received_date |
date |
No |
No |
|
Date Purchase Order line was last received |
| required_date |
date |
No |
No |
|
Required date for this item |
| comment |
text |
No |
No |
|
Comment on line |
| _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 |
| reference |
character varying(20) |
No |
No |
|
Reference number on the line |
| src_type |
character varying(4) |
No |
No |
|
Source type from Requisition; INV = Inventory SORD = Sales Order BORD = Production Order |
| src_no |
character varying(40) |
No |
No |
|
Source Sales Order number or Production Order number from Requisition |
| src_cust_no |
character varying(20) |
No |
No |
|
Source Customer number from Requisition |
| employee |
character varying(6) |
No |
No |
|
Employee code added by user - links to employees.employee_no |
| weight |
numeric(15,2) |
No |
No |
0 |
Weight per each of order quantity of the item |
| job_no |
character varying(10) |
No |
No |
|
Job cost number - links to jobs.job_no |
| job_acct |
character varying(10) |
No |
No |
|
Job cost account number - links to jobs.account |
| template_no |
character varying(10) |
No |
No |
|
Not used |
| template_guid |
character varying(32) |
No |
No |
|
Not used |
| revision |
character varying(8) |
No |
No |
|
Not used |
| tax_applicable |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Tax 1 - 4 applicable flags; False = No True = Yes |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| discountable |
boolean |
No |
No |
|
Discountable flag; FALSE = No TRUE = Yes |
| line_disc |
numeric(5,2) |
Yes |
No |
|
Line discount percentage |
| line_disc_amt |
numeric(15,2) |
Yes |
No |
|
Line discount amount |