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 |