While this table does not have a field defined as a primary key, the SLXLOCATIONID field should be unique and considered a primary key.
Added in version 7.5.4
The SLXLOCATION table stores the warehouse or location that a commodity can be shipped from. This table is used for accounting integration functionality.
|
|
While this table does not have a field defined as a primary key, the SLXLOCATIONID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SLXLOCATIONID |
char(12) |
NOT NULL |
SLXLOCATIONID (AK) |
(One) to (Many)
|
|
| (One) to (Many) | ERPSHIPMENT.ERPWAREHOUSEID | ||||
| (Many) to (One) | OPPORTUNITY_PRODUCT.LOCATIONID | ||||
| (One) to (Many) | QUOTEITEM.SLXLOCATIONID | ||||
| (One) to (Many) | RMA.SLXLOCATIONID | ||||
|
GLOBALSYNCID |
varchar(36) |
NULLS |
GLOBALSYNCID (IE) |
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int |
NULLS |
SLXLOCATION_TICK (IE) |
|
|
|
ACTIVEFLAG |
varchar(1) |
NULLS |
|
|
|
|
LOCATIONTYPE |
varchar(64) |
NULLS |
|
|
|
|
NAME |
varchar(64) |
NULLS |
SLXLOCATION_BOE_COMPOSITE (IE) |
|
|
|
DESCRIPTION |
text(64) |
NULLS |
|
|
|
|
ADDRESSID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SALEFLAG |
varchar(1) |
NULLS |
|
|
|
|
TRANSITFLAG |
varchar(1) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
| DESCRIPTION | varchar(255) | NULLS | |||
| ERPEXTID | varchar(100) | NULLS | |||
| ERPACCOUNTINGENTITYID | varchar(22) | NULLS | SLXLOCATION_BOE_COMPOSITE (IE) | ||
| ERPLOGICALID | varchar(255) | NULLS | |||
| ERPVARIATIONID | varchar(22) | NULLS | |||
| ERPSTATUS | varchar(64) | NULLS | |||
| ERPUNIQUEID | varchar(377) | NULLS | SLXLOCATION_ERPUNIQUEID (IE) |