Added in Version 6.2
The PRODUCTPROGRAM table is a child table of the PRODUCT table and stores the default pricing info for a particular product.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
PRODUCTPROGRAMID (PK) |
char(12) |
NOT NULL |
PRODUCTPROGRAM_PRODUCTPROGRAMID_PK (AK) |
||
|
PRODUCTID (FK) |
char(12) |
NOT NULL |
|
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
PROGRAM |
varchar(32) |
NULLS |
|
|
|
|
PRICE |
decimal(17,4) |
NULLS |
|
|
|
|
DEFAULTPROGRAM |
char(1) |
NULLS |
|
|
|