| id |
integer |
Yes |
Yes |
nextval('purchase_order_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 the 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 |
0 |
Quantity ordered |
| received_qty |
numeric(15,5) |
No |
No |
0 |
Quantity received to date |
| inventory_order_qty |
numeric(15,5) |
No |
No |
0 |
Quantity ordered converted to Inventory unit of measure |
| inventory_received_qty |
numeric(15,5) |
No |
No |
0 |
Quantity received to date converted to Inventory unit of measure |
| last_received_qty |
numeric(15,5) |
No |
No |
0 |
Last received quantity |
| serialized_qty |
numeric(11) |
No |
No |
0 |
Serialized quantity received |
| retail_price |
numeric(15,5) |
No |
No |
0 |
Price before line discount |
| unit_price |
numeric(15,5) |
No |
No |
0 |
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 |
| date |
date |
No |
No |
|
|
| receive_qty |
numeric(11,3) |
No |
No |
0 |
Receive quantity saved on Purchase Order before posting Receipt |
| inventory_receive_qty |
numeric(11,3) |
No |
No |
0 |
Receive quantity saved on Purchase Order converted to Inventory unit of measure, before posting Receipt |
| duty_by_pct |
boolean |
No |
No |
false |
Calculate duty by percent flag; FALSE = No TRUE = Yes |
| duty_rate |
numeric(5,2) |
No |
No |
0 |
Duty percentage |
| duty_amount |
numeric(15,5) |
No |
No |
0 |
Duty amount |
| freight_by_pct |
boolean |
No |
No |
false |
Calculate freight by percent flag; FALSE = No TRUE = Yes |
| freight_rate |
numeric(5,2) |
No |
No |
0 |
Freight percentage |
| freight_amount |
numeric(15,5) |
No |
No |
0 |
Freight amount |
| gl_account |
character varying(24) |
No |
No |
|
General Ledger Inventory Asset account to post receipt to, defaults to sales department but is editable by user with permission |
| sell_price |
numeric(15,5) |
No |
No |
0 |
Inventory Sell price 1 |
| user_sell_price |
boolean |
No |
No |
false |
User edited sell price flag; FALSE = No TRUE = Yes |
| pack_size |
numeric(9,3) |
No |
No |
0 |
Normal pack size |
| requisition_no |
character varying(10) |
No |
No |
|
Requisition number that created this record - links to inventory_requisitions.requisition_no |
| employee |
character varying(6) |
No |
No |
|
Employee code added by user - links to employees.employee_no |
| ship_to |
character varying(20) |
No |
No |
|
Ship to text as entered by user |
| 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 |
| weight |
numeric(15,2) |
No |
No |
0 |
Weight per each of order quantity of the item |
| tax_applicable |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Tax 1 - 4 applicable flags; False = No True = Yes |
| vendor_price_id |
integer |
No |
No |
|
Link to vendor_pricing.id |
| 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 |