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 |