| id |
integer |
Yes |
Yes |
nextval('sales_history_items_id_seq'::regclass) |
Unique identifier |
| invoice_no |
character varying(10) |
No |
No |
|
Invoice number - links to sales_history.invoice_no |
| 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 Inventory item or first 80 characters of the comment |
| product_code |
character varying(10) |
No |
No |
|
Product Code of the item - links to inventory_product_codes.product_code |
| uom_inventory |
character varying(10) |
No |
No |
|
Unit of measure used by this item for inventory committed quantity - links to inventory_uoms |
| uom_sales |
character varying(10) |
No |
No |
|
Sales unit of measure - links to inventory_uoms |
| order_qty |
numeric(15,5) |
Yes |
No |
0 |
Quantity that was ordered |
| committed_qty |
numeric(15,5) |
Yes |
No |
0 |
Quantity that was shipped |
| backorder_qty |
numeric(15,5) |
Yes |
No |
0 |
Quantity that was backordered |
| inventory_order_qty |
numeric(15,5) |
Yes |
No |
0 |
Quantity ordered converted to Inventory unit of measure |
| inventory_committed_qty |
numeric(15,5) |
Yes |
No |
0 |
Quantity committed converted to Inventory unit of measure |
| inventory_backorder_qty |
numeric(15,5) |
Yes |
No |
0 |
Quantity backordered converted to Inventory unit of measure |
| serialized_qty |
numeric(11) |
Yes |
No |
0 |
Quantity of serialized/lot numbered items using Inventory unit of measure |
| retail_price |
numeric(15,5) |
Yes |
No |
0 |
Sell price on this line before discount |
| unit_price |
numeric(15,5) |
Yes |
No |
0 |
Sell price after line discount |
| current_cost |
numeric(15,5) |
Yes |
No |
0 |
Current cost of the item at time of Invoicing |
| average_cost |
numeric(15,5) |
Yes |
No |
0 |
Average cost of the item at time of Invoicing |
| status |
smallint |
No |
No |
|
Price method used; 0 = Price from Inventory 2 = Price from Price Matrix 9 = User override price 10 = Copied price from previous Invoice |
| discountable |
boolean |
No |
No |
|
Item discountable flag; FALSE = No TRUE = Yes |
| line_disc |
numeric(5,2) |
Yes |
No |
0 |
Line discount percentage |
| line_disc_amt |
numeric(15,2) |
Yes |
No |
0 |
Line discount amount |
| required_date |
date |
No |
No |
|
Required date for this line |
| guid |
character varying(32) |
No |
No |
|
Unique identifier for linking to other tables; inventory_serial_transactions.link_guid inventory_receipts.link_guid inventory_requisitions_src_guid |
| item_type |
smallint |
Yes |
No |
|
Item type for line; 1 = Inventory item 2 = Non-Inventory 3 = Comment 4 = Job header |
| last_invoice_no |
character varying(10) |
No |
No |
|
Not used |
| last_invoice_date |
date |
No |
No |
|
Not used |
| invoice_date |
date |
No |
No |
|
Invoice date from sales_history |
| comment |
text |
No |
No |
|
Comment text |
| po_number |
character varying(10) |
No |
No |
|
Purchase Order number created by Inventory Requisitions for this record |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record (Invoiced it) |
| _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 |
| employee_no |
character varying(6) |
No |
No |
|
Employee code added by user - links to employees.employee_no |
| parent_item |
smallint |
No |
No |
|
Link to sales_history_items.sequence for the parent of this group, used by kits, accessories and job items |
| price_matrix_promo_code |
character varying(25) |
No |
No |
|
Promotion code from price_matrix record used to set the price |
| inventory_gl |
character varying(24) |
No |
No |
|
General Ledger Inventory asset account used |
| revenue_gl |
character varying(24) |
No |
No |
|
General Ledger Inventory Revenue/Sales account used |
| cost_gl |
character varying(24) |
No |
No |
|
General Ledger Inventory Cost of Goods account used |
| ref_no |
character varying(20) |
No |
No |
|
Reference number user entered on the line |
| upc_code |
character varying(40) |
No |
No |
|
UPC code that was scanned or entered for this line, blank if part number was used to populate the line |
| job_no |
character varying(10) |
No |
No |
|
Job cost number - links to jobs.job_no Blank used sales_history.job_no |
| job_acct_no |
character varying(10) |
No |
No |
|
Job cost account number - links to jobs.account Blank used sales_history.job_account |
| weight |
numeric(15,5) |
No |
No |
|
Weight of item on this line |
| tax_applicable |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Tax 1 - 4 applicable flags |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| standard_cost |
numeric(15,5) |
Yes |
No |
0 |
Standard cost of the item at time of Invoicing |
| partial_tax |
boolean |
No |
No |
false |
Partial tax flag; FALSE = No TRUE = Yes |
| levy_amount |
numeric(9,3) |
Yes |
No |
0 |
Levy amount on the line |
| levy_code |
character varying(3) |
No |
No |
|
Levy code - links to inventory_levy_codes.code |
| levy_tax_applicable |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Tax 1 - 4 applicable to Levy flag |
| price_matrix_id |
integer |
No |
No |
|
Price Matrix record used to set the retail price on the line - links to inventory_price_matrix.id |
| price_matrix_score |
smallint |
No |
No |
|
Value from inventory_price_matrix.score |
| sell_direct_factor |
boolean |
No |
No |
|
|
| uom_sales_factor |
numeric(11,5) |
No |
No |
|
|
| user_cost |
boolean |
No |
No |
|
User edited cost flag; FALSE = No TRUE = Yes |
| vendor_no |
character varying(20) |
No |
No |
|
Vendor number from inventory.preferred_vendor or entered by user |
| suppress |
boolean |
No |
No |
false |
Suppress view/print flag as set by user on kit components; FALSE = No TRUE = Yes |