Added in version 7.5.4
The SLXPRICELIST table stores the grouping of commodities and their prices. The table is used for accounting integration functionality.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SLXPRICELISTID |
char(12) |
NOT NULL |
SLXPRICELIST_PRIMARY (AK) |
(One) to (Many) |
|
| (One) to (Many) | QUOTE.PRICELISTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
GLOBALSYNCID |
varchar(36) |
NULLS |
SLXPRICELIST_GLOBALSYNCID (IE) |
(One) to (Many) |
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int |
NULLS |
SLXPRICELIST_TICK (IE) |
|
|
|
ACTIVEFLAG |
char(1) |
NULLS |
|
|
|
|
PRICELISTYPE |
varchar(32) |
NULLS |
|
|
|
|
NAME |
varchar(64) |
NULLS |
|
|
|
|
REFERENCE |
varchar(32) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
CALCULATIONMETHOD |
varchar(64) |
NULLS |
|
|
|
|
CALCULATIONTYPE |
varchar(32) |
NULLS |
|
|
|
|
CALCULATIONAMOUNT |
numeric(17,4) |
NULLS |
|
|
|
|
CALCULATIONPERCENT |
float |
NULLS |
|
|
|
|
ROUNDINGMETHOD |
varchar(16) |
NULLS |
|
|
|
|
PRICEINCLUDESTAX |
varchar(1) |
NULLS |
|
|
|
|
CURRENCY |
varchar(3) |
NULLS |
|
|
|
|
OPERATINGCOMPANYCURRENCY |
varchar(3) |
NULLS |
|
|
|
|
OPERCOMPCURRENCYEXCHANGERATE |
float |
NULLS |
|
|
|
|
OPERCOMPEXCHANGERATEOPER |
char(1) |
NULLS |
|
|
|
|
OPERCOMPEXCHANGERATEDATE |
datetime |
NULLS |
|
|
|
|
STARTDATE |
datetime |
NULLS |
|
|
|
|
ENDDATE |
datetime |
NULLS |
|
|
|
|
ISPRIMARY |
char(1) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
| BACKOFFICEID (FK) | varchar(12) | NULLS | (One) to (Many) | BACKOFFICE.BACKOFFICEID |