Added in Version 6.2.1
The SALESORDERITEMS table stores the information associated with the items included in a sales order. This table contains information including, but not limited to the product, price, quantity, discount, and product family.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SALESORDERITEMSID (PK) |
char(12) |
NOT NULL |
SALESORDERITEMS_ID_PK (CA) |
(One) to (Many) |
|
| (One) to (Many) | DISCOUNTCHARGEITEM.DISTRIBUTEDTAXSOID | ||||
| (One) to (Many) | ERPSALESORDERITEMSUBITEM.SALESORDERITEMSID | ||||
|
SALESORDERID (FK) |
char(12) |
NOT NULL |
SALESORDERITEMS_SALESORDERID (IE)
|
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
PRODUCT |
varchar(64) |
NULLS |
|
|
|
|
PROGRAM |
varchar(64) |
NULLS |
|
|
|
|
PRICE |
float(8) |
NULLS |
|
|
|
|
QUANTITY |
float(8) |
NULLS |
|
|
|
|
DISCOUNT |
float(8) |
NULLS |
|
|
|
|
FAMILY |
varchar(32) |
NULLS |
|
|
|
|
OPPPRODUCTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
PRODUCTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ACTUALID (FK) |
varchar(64) |
NULLS |
|
(Many) to (One) |
|
|
DESCRIPTION |
text(16) |
NULLS |
|
|
|
|
EXTENDEDPRICE |
float(8) |
NULLS |
|
|
|
|
UNIT |
varchar(64) |
NULLS |
|
|
|
|
CALCULATEDPRICE |
numeric(17,4) |
NULLS |
|
|
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
SALESORDERITEMS_GLOBALSYNCID (IE) |
|
|
|
LINENUMBER |
int |
NULLS |
|
|
|
|
LINETYPE |
varchar(32) |
NULLS |
|
|
|
|
SLXLOCATIONID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
UNITOFMEASUREID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
PRICEDETAILDESCRIPTION |
varchar(256) |
NULLS |
|
|
|
|
PRICEDETAILNOTES |
text |
NULLS |
|
|
|
|
ITEMLOCKED |
varchar(1) |
NULLS |
|
|
|
|
TICK |
int |
NULLS |
|
|
|
|
APPID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
COMMODITYTYPE |
varchar(32) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| ERPACTUALDELIVERYDATE | datetime | NULLS | |||
| ERPSHIPDATE | datetime | NULLS | |||
| ERPPBACKORDERED | varchar(1) | NULLS | |||
| UOMQUANTITY | decimal(17,4) | NULLS | |||
| UOMCODE | varchar(100) | NULLS | |||
| ERPFIXEDPRICEITEM | varchar(1) | NULLS | |||
| ERPUPCID | varchar(12) | NULLS | |||
| ERPLINENUMBER | varchar(12) | NULLS | |||
| ERPOPENQUANTITY | decimal(17,4) | NULLS | |||
| ERPOPENUOM | varchar(100) | NULLS | |||
| ERPPARTIALSHIPALLOWED | varchar(1) | NULLS | |||
| ERPPROMISEDDELIVERYDATE | datetime | NULLS | |||
| ERPPROMISEDSHIPDATE | datetime | NULLS | |||
| ERPPURCHASEORDERREFERENCE | varchar(100) | NULLS | |||
| ERPREQUIREDDELIEVERYDATE | datetime | NULLS | |||
| ERPRUSHREQUEST | varchar(1) | NULLS | |||
| ERPSHIPPEDQUANTITY | decimal(17,4) | NULLS | |||
| ERPSHIPPEDUOM | varchar(100) | NULLS | |||
| ERPSHIPTOID | varchar(12) | NULLS | |||
| ERPSTATUS | varchar(64) | NULLS | |||
| ERPSTATUSDATE | datetime | NULLS | |||
| ERPSUBSTITUTEITEM | varchar(1) | NULLS | |||
| ERPUNITPRICEUOM | varchar(100) | NULLS | |||
| ERPUNITPRICEPERQUANTITYUOM | varchar(100) | NULLS | |||
| ERPUNITPRICEPERQUANTITY | decimal(17,4) | NULLS | |||
| ERPDROPSHIP | varchar(1) | NULLS | |||
| NOTE | varchar(1024) | NULLS | |||
| ERPQUOTENUMBER | varchar(100) | NULLS | |||
| ERPINCOTERM | varchar(100) | NULLS | |||
| ERPQUOTEID | varchar(12) | NULLS | |||
| STATUS | varchar(64) | NULLS | |||
| CARRIERID | varchar(12) | NULLS | |||
| DOCTOTALAMOUNT | float | NULLS | |||
| TOTALAMOUNT | float | NULLS | |||
| DOCCALCULATEDPRICE | decimal(17,4) | NULLS | |||
| DOCEXTENDEDPRICE | deciMal(17,4) | NULLS | |||
| AVAILABLEQUANTITY | float | NULLS | |||
| ATPDATE | datetime | NULLS | |||
|
ERPNOTES |
text |
NULLS |