| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
|
|
|
|
|
| NAME |
varchar |
41 |
|
|
|
|
|
| DESCRIPTION |
blob sub_type 1 |
0 |
√ |
|
null |
|
|
| ISACTIVE |
smallint |
5 |
√ |
|
1 |
|
|
| PRODUCTINCLTYPEID |
smallint |
5 |
|
|
|
|
|
| PRODUCTINCLID |
integer |
10 |
√ |
|
0 |
|
|
| PAAPPLIES |
smallint |
5 |
√ |
|
1 |
|
|
| PATYPEID |
smallint |
5 |
√ |
|
1 |
|
|
| PABASEAMOUNTTYPEID |
smallint |
5 |
√ |
|
3 |
|
|
| RNDAPPLIES |
smallint |
5 |
√ |
|
0 |
|
|
| RNDTYPEID |
smallint |
5 |
√ |
|
2 |
|
|
| RNDISMINUS |
smallint |
5 |
√ |
|
1 |
|
|
| CUSTOMERINCLTYPEID |
smallint |
5 |
|
|
|
|
|
| CUSTOMERINCLID |
integer |
10 |
√ |
|
0 |
|
|
| DATEAPPLIES |
smallint |
5 |
√ |
|
0 |
|
|
| DATEBEGIN |
timestamp |
19 |
√ |
|
null |
|
|
| DATEEND |
timestamp |
19 |
√ |
|
null |
|
|
| QTYAPPLIES |
smallint |
5 |
√ |
|
0 |
|
|
| SPCAPPLIES |
smallint |
5 |
√ |
|
0 |
|
|
| SPCBUYX |
integer |
10 |
√ |
|
0 |
|
|
| SPCGETYFREE |
integer |
10 |
√ |
|
0 |
|
|
| ISAUTOAPPLY |
smallint |
5 |
√ |
|
1 |
|
|
| ISTIER2 |
smallint |
5 |
√ |
|
0 |
|
|
| DATECREATED |
timestamp |
19 |
√ |
|
'NOW' |
|
|
| DATELASTMODIFIED |
timestamp |
19 |
√ |
|
'NOW' |
|
|
| USERID |
integer |
10 |
|
|
1 |
|
|
| QTYMIN |
double precision |
15 |
√ |
|
0 |
|
|
| QTYMAX |
double precision |
15 |
√ |
|
0 |
|
|
| PAPERCENT |
double precision |
15 |
√ |
|
0 |
|
|
| PAAMOUNT |
double precision |
15 |
√ |
|
0 |
|
|
| RNDTOAMOUNT |
double precision |
15 |
√ |
|
0 |
|
|
| RNDPMAMOUNT |
double precision |
15 |
√ |
|
0 |
|
|
Analyzed at Mon Jul 01 09:44 PDT 2013
|
