| id |
integer |
Yes |
Yes |
nextval('sales_history_items_id_seq'::regclass) |
|
| invoice_no |
character varying(10) |
No |
No |
|
Invoice number |
| sequence |
smallint |
No |
No |
|
The sequence number |
| whse |
character varying(6) |
No |
No |
|
Warehouse code from where the item was sold |
| part_no |
character varying(34) |
No |
No |
|
The part number of the item sold |
| description |
character varying(80) |
No |
No |
|
The description of the item sold |
| product_code |
character varying(10) |
No |
No |
|
The product code of the item sold |
| uom_purchase |
character varying(10) |
No |
No |
|
The default purchase unit of measure of the item sold |
| uom_inventory |
character varying(10) |
No |
No |
|
The inventory/stocking unit of measure of the item sold |
| uom_sales |
character varying(10) |
No |
No |
|
The sales unit of measure selected for the item sold |
| order_qty |
numeric(15,5) |
No |
No |
|
Quantity that was ordered |
| committed_qty |
numeric(15,5) |
No |
No |
|
Quantity that was shipped |
| backorder_qty |
numeric(15,5) |
No |
No |
|
Quantity that was back ordered |
| serialized_qty |
numeric(11) |
No |
No |
|
Quantity serialized |
| inventory_order_qty |
numeric(15,5) |
No |
No |
|
Quantity ordered applying UOM conversion factor |
| inventory_committed_qty |
numeric(15,5) |
No |
No |
|
Quantity shipped applying UOM conversion factor |
| inventory_backorder_qty |
numeric(15,5) |
No |
No |
|
Quantity back ordered applying UOM conversion factor |
| inventory_serialized_qty |
numeric(11) |
No |
No |
|
Quantity of serialized items applying UOM conversion factor |
| retail_price |
numeric(15,5) |
No |
No |
|
Sell price from customer. |
| unit_price |
numeric(15,5) |
No |
No |
|
Sell price after discount |
| current_cost |
numeric(15,5) |
No |
No |
|
Cusrrent cost of the item at time of invoicing. |
| average_cost |
numeric(15,5) |
No |
No |
|
Average cost of the item at time of invoicing. |
| base_retail_price |
numeric(15,5) |
No |
No |
|
Customers regular price in base currency |
| status |
smallint |
No |
No |
|
Price method used |
| discountable |
boolean |
No |
No |
|
Was the item discountable at time of sale |
| line_disc |
numeric(5,2) |
No |
No |
|
Line discount percentage |
| line_disc_amt |
numeric(15,2) |
No |
No |
|
Line discount amount |
| whse_location |
character varying(20) |
No |
No |
|
Locattion of item in warehouse at time of sale |
| required_date |
date |
No |
No |
|
Line date required |
| shipped_date |
date |
No |
No |
|
Date shipped |
| guid |
character varying(32) |
No |
No |
|
Unique identifier to link to other tables |
| item_type |
smallint |
No |
No |
|
|
| last_invoice_no |
character varying(10) |
No |
No |
|
|
| last_invoice_date |
date |
No |
No |
|
|
| invoice_date |
date |
No |
No |
|
|
| comments |
text |
No |
No |
|
Comment text |
| po_number |
character varying(10) |
No |
No |
|
PO number from requisitions |
| _dbversion |
integer |
No |
No |
|
Program version that invoiced |
| _created |
timestamp without time zone |
No |
No |
|
Date/time the order was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created order |
| _modified |
timestamp without time zone |
No |
No |
|
Date/Time order last edited |
| _modified_by |
character varying(3) |
No |
No |
|
User that lasted edited order |
| employee |
character varying(6) |
No |
No |
|
Employee code assigned to this line from employee table |
| record_type |
character varying(1) |
No |
No |
|
|
| parent_item |
smallint |
No |
No |
|
|
| price_matrix_promo_code |
character varying(25) |
No |
No |
|
Promo (reason) code used from table price_matrix |
| inventory_gl |
character varying(24) |
No |
No |
|
Inventory asset GL account used. From sales dept unless edited before invoicing. |
| revenue_gl |
character varying(24) |
No |
No |
|
Inventory sales GL account used. From sales dept unless edited before invoicing. |
| cost_gl |
character varying(24) |
No |
No |
|
Inventory cost of sales GL account used. From sales dept unless edited before invoicing. |
| generated |
boolean |
No |
No |
|
|
| ref_no |
character varying(20) |
No |
No |
|
Line reference number |
| upc_code |
character varying(40) |
No |
No |
|
UPC code that was scanned or entered for this line |
| job_no |
character varying(10) |
No |
No |
|
Line job number |
| job_acct_no |
character varying(10) |
No |
No |
|
Line job account |
| weight |
numeric(15,5) |
No |
No |
|
Line weight |
| notes |
text |
No |
No |
|
Lines notes or memo |
| tax_applicable |
boolean[] |
Yes |
No |
'{f,f,f,f}'::boolean[] |
Array field containing 4 tax flags t = Yes f = No |
| udf_data |
hstore |
No |
No |
''::hstore |
hstore containing user defined data |
| standard_cost |
numeric(15,5) |
No |
No |
|
Standard cost of the line |
| partial_tax |
boolean |
No |
No |
false |
Partial tax flag TRUE = Yes False = No |