| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TD_FORMULA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Formula ID
|
| 2 |
COLUMNNUM |
Number(3,0) |
SMALLINT NOT NULL |
Column Number
|
| 3 |
TD_CHECK_COL_CUST |
Character(2) |
VARCHAR2(2) NOT NULL |
Column Value
|
| 4 |
TD_CHECK_COL_FUND |
Character(2) |
VARCHAR2(2) NOT NULL |
Column Value
|
| 5 |
TD_FORMULA_ID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Formula ID
Prompt Table:
%EDITTABLE
|
| 6 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 7 |
TD_PROMO_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Approved
Y/N Table Edit
Default Value: N
|
| 8 |
TD_PROMO_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Cancelled
Y/N Table Edit
Default Value: N
|
| 9 |
TD_PROMO_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Y/N Table Edit
Default Value: N
|
| 10 |
TD_PROMO_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Rejected
Y/N Table Edit
Default Value: N
|
| 11 |
TD_PROMO_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Approved
Y/N Table Edit
Default Value: N
|
| 12 |
TD_PROMO_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Rejected
Y/N Table Edit
Default Value: N
|
| 13 |
TD_PROMO_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Y/N Table Edit
Default Value: N
|
| 14 |
TD_PROMO_STAT_08 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Y/N Table Edit
Default Value: N
|
| 15 |
TD_PROMO_STAT_09 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Y/N Table Edit
Default Value: N
|
| 16 |
TD_PROMO_STAT_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit
Default Value: N
|
| 17 |
TD_ALLOW_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Y/N Table Edit
Default Value: N
|
| 18 |
TD_ALLOW_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit
Default Value: N
|
| 19 |
TD_ALLOW_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Y/N Table Edit
Default Value: N
|
| 20 |
TD_ALLOW_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
Y/N Table Edit
Default Value: N
|
| 21 |
TD_ALLOW_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected
Y/N Table Edit
Default Value: N
|
| 22 |
TD_ALLOW_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Y/N Table Edit
Default Value: N
|
| 23 |
TD_ALLOW_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Y/N Table Edit
Default Value: N
|
| 24 |
TD_OPERATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Mathematical Operator
D=Divided By
M=Minus
P=Plus
T=Multiplied By
Default Value: P
|