The PRODUCT table has many related tables that include product associations, product costs, product prices, product sites, substitute products, and product units.
The Product table stores general information about products your company sells. The information includes product name and description, product family, price, product group, status, stock volume, weight, item number, if a pricing program is associated to the product, supplier or vendor, location of the product, general ledger accounting numbers associated to a product and other general details.
|
|
The PRODUCT table has many related tables that include product associations, product costs, product prices, product sites, substitute products, and product units. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
PRODUCTID (PK) |
STANDARDID(12) |
NOT NULL |
PRODUCT_PRODUCTID_PK (CA) PRODUCT_PRODIDMODUSER(IE) PRODUCT_PRODNAMEPRODID (IE) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPINVOICEITEM.PRODUCTID | ||||
| (One) to (Many) | ERPPRODUCTCLASSIFICATION.PRODUCTID | ||||
| (One) to (Many) | ERPRECEIVABLEITEM.PRODUCTID | ||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
NAME |
varchar(64) |
NULLS |
PRODUCT_PRODNAMEPRODID (IE) |
|
|
|
DESCRIPTION |
TEXTBLOB(16) |
NULLS |
|
|
|
|
ACTUALID |
varchar(64) |
NULLS |
|
|
|
|
FAMILY |
varchar(64) |
NULLS |
|
|
|
|
PRICE |
decimal(17,4) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
PRODUCT_PRODIDMODUSER(IE) |
(Many) to (One) |
|
|
PRODUCTGROUP |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|
|
UNIT |
varchar(64) |
NULLS |
|
|
|
|
STOCKVOLUME |
real(4) |
NULLS |
|
|
|
|
STOCKWEIGHT |
real(4) |
NULLS |
|
|
|
|
STOCKITEM |
BOOLEAN(1) |
NULLS |
|
|
|
|
PROGRAM |
varchar(64) |
NULLS |
|
|
|
|
SUPPLIER |
varchar(128) |
NULLS |
|
|
|
|
VENDOR |
varchar(128) |
NULLS |
|
|
|
|
SITEID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
WAREHOUSELOCATION |
varchar(10) |
NULLS |
|
|
|
|
COMMISSIONABLE |
BOOLEAN(1) |
NULLS |
|
|
|
|
TAXABLE |
BOOLEAN(1) |
NULLS |
|
|
|
|
ACCOUNTINGPERIOD |
varchar(6) |
NULLS |
|
|
|
|
GLACCOUNTNUMBER |
varchar(10) |
NULLS |
|
|
|
|
GLSUBACCOUNTNUMBER |
varchar(24) |
NULLS |
|
|
|
|
DATAOWNER |
varchar(2)
|
NULLS
|
|
|
|
|
TYPE
|
varchar(64)
|
NULLS
|
|
|
|
|
FIXEDCOST |
decimal(17,4) |
NULLS |
|
|
|
|
GLOBALSYNCID |
varchar(36) |
NULLS |
PRODUCT_GLOBALSYNCID (IE) |
|
|
|
APPID (FK) |
varchar(12) |
NULLS |
|
(Many) to (One) |
|
|
TICK |
int(4) |
NULLS |
|
|
|
|
COMMODITYGROUPID (FK) |
char(12) |
NULLS |
|
(Many) to (One |
|
|
ACTIVEFLAG |
varchar(1) |
NULLS |
|
|
|
|
SELLINGALLOWEDFLAG |
varchar(1) |
NULLS |
|
|
|
|
UNITOFMEASUREID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SELLINGUOMID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SELLINGUOMNUMBER |
float |
NULLS |
|
|
|
|
CLASSIFICATION |
varchar(64) |
NULLS |
|
|
|
|
COMMODITYTYPE |
varchar(32) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|
| ERPEXTID | varchar(100) |
NULLS |
PRODUCT_ERPEXTID (IE) | ||
| ERPLOGICALID | varchar(255) |
NULLS |
|||
| ERPACCOUNTINGENTITYID | varchar(22) |
NULLS |
|||
| ERPCONFIGUREDITEM | varchar(1) |
NULLS |
|||
| ERPLEADTIME | varchar(20) |
NULLS |
|||
| ERPUPCID | varchar(26) |
NULLS |
|||
| ERPSERVICEPRODUCT | varchar(1) |
NULLS |
|||
| ERPSTATUSDATE | datetime(8) |
NULLS |
|||
| ERPLOTCONTROLLED | varchar(1) |
NULLS |
|||
| ERPSERIALCONTROLLED | varchar(1) |
NULLS |
|||
| ERPSHELFLIFE | varchar(20) |
NULLS |
|||
| ERPSTORAGEUOM | varchar (100) |
NULLS |
|||
| ERPUNIQUEID | varchar(355) |
NULLS |
PRODUCT_ERPUNIQUEID (IE) | ||
| ERPLASTREFRESH | datetime(8) |
NULLS |
|||
| ERPCOSTMETHOD | varchar(100) |
NULLS |
|||
| ERPCOST | float |
NULLS |
|||
| ERPPERQUANTITY | int |
NULLS |
|||
| ERPPERQUANTITYUOM | varchar(100) |
NULLS |
|||
| ERPVARIATIONID | varchar(22) |
NULLS |
|||
| ERPSTATUS | varchar(64) |
NULLS |
|||
| CURRENCYCODE | varchar(64) |
NULLS |
|||
| INTEGRATIONCONFIGGROUPID | varchar(12) |
NULLS |
(One) to (Many) |
INTEGRATIONCONFIGGROUP.INTEGRATIONCONFIGGROUPID | |
| APPLICATIONID | nvarchar(64) | NULLS | |||
| NAMESPACE | nvarchar(64) | NULLS | |||
| DERIVEDFROMITEM | nvarchar(64) | NULLS | |||
| CUSTOMIZED | nchar(1) | NULLS | |||
| RULESET | nvarchar(100) | NULLS | |||
| APPLICATIONNAME | nvarchar(64) | NULLS | |||
| PRODUCTVARIANT | nvarchar(256) | NULLS |