While this table does not have a field defined as a primary key, the SLXPRICEID field should be unique and considered a primary key.
Added in version 7.5.4
The SLXPRICE table stores price for each combination of commodity, price list, unit of measure, and currency. The table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the SLXPRICEID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SLXPRICEID |
char(12) |
NOT NULL |
SLXPRICE_PRIMARY (AK) |
|
|
|
SLXPRICELISTID |
char(12) |
NULLS |
SLXPRICE_SLXPRICELISTID (IE) |
(Many) to (One) |
|
|
PRODUCTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
UNITOFMEASUREID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
SLXPRICE_GLOBALSYNCID (IE) |
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int |
NULLS |
SLXPRICE_TICK (IE) |
|
|
|
ACTIVEFLAG |
char(1) |
NULLS |
|
|
|
|
REFERENCE |
varchar(32) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
CUSTOMERSUPPLIERFLAG |
varchar(1) |
NULLS |
|
|
|
|
CURRENCY |
varchar(3) |
NULLS |
|
|
|
|
OPERCOMPCURRENCY |
varchar(3) |
NULLS |
|
|
|
|
OPERCOMPEXCHANGERATE |
float |
NULLS |
|
|
|
|
OPERCOMPEXCHANGERATEOPER |
char(1) |
NULLS |
|
|
|
|
OPERCOMPEXCHANGERATEDATE |
datetime |
NULLS |
|
|
|
|
DECIMALPLACES |
float |
NULLS |
|
|
|
|
PRICE |
numeric(17) |
NULLS |
|
|
|
|
INCLUDESTAX |
char(1) |
NULLS |
|
|
|
|
STARTDATE |
datetime |
NULLS |
|
|
|
|
ENDDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|