While this table does not have a field defined as a primary key, the SALESORDERID field should be unique and considered a primary key.
Added in version 7.5.4
The ERPSALESORDER table is an extension table of the SALESORDER table for storing ERP specific fields. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the SALESORDERID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SALESORDERID (FK) |
char(12) |
NOT NULL |
ERPSALESORDER_PRIMARY (AK) |
(One) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ALLOCATIONSTATUS |
varchar(32) |
NULLS |
|
|
|
|
DELIVERYSTATUS |
varchar(32) |
NULLS |
|
|
|
|
INVOICESTATUS |
varchar(32) |
NULLS |
|
|
|
|
STATUSFLAG |
varchar(1) |
NULLS |
|
|
|
|
STATUSFLAGTEXT |
varchar(32) |
NULLS |
|
|
|
|
CARRIERTRACKING |
varchar(64) |
NULLS |
|
|
|
|
REFERENCE |
varchar(32) |
NULLS |
|
|
|
|
PRICEDETAIL |
text |
NULLS |
|
|
|
|
ERPSTATUS |
varchar(64) |
NULLS |
|
|
|