| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETTD_NONVW
|
| 2 |
TD_CHECKBOOK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotions Management Checkbook ID
|
| 3 |
COLUMNNUM |
Number(3,0) |
SMALLINT NOT NULL |
Column Number
|
| 4 |
TD_COLUMN_HEAD1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Column Heading
|
| 5 |
TD_COLUMN_HEAD2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Column Heading
|
| 6 |
TD_CHECK_COL_CUST |
Character(2) |
VARCHAR2(2) NOT NULL |
Column Value
|
| 7 |
TD_CHECK_COL_FUND |
Character(2) |
VARCHAR2(2) NOT NULL |
Column Value
|
| 8 |
TD_FORMULA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Formula ID
Prompt Table:
%EDITTABLE
|
| 9 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 10 |
TD_DIV_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
On Error Display
B=Blank
E=Error
Z=Zero
Default Value: B
|
| 11 |
TD_PROMO_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Approved
Y/N Table Edit
Default Value: N
|
| 12 |
TD_PROMO_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Cancelled
Y/N Table Edit
Default Value: N
|
| 13 |
TD_PROMO_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Y/N Table Edit
Default Value: N
|
| 14 |
TD_PROMO_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Rejected
Y/N Table Edit
Default Value: N
|
| 15 |
TD_PROMO_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Approved
Y/N Table Edit
Default Value: N
|
| 16 |
TD_PROMO_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Rejected
Y/N Table Edit
Default Value: N
|
| 17 |
TD_PROMO_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Y/N Table Edit
Default Value: N
|
| 18 |
TD_PROMO_STAT_08 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Y/N Table Edit
Default Value: N
|
| 19 |
TD_PROMO_STAT_09 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Y/N Table Edit
Default Value: N
|
| 20 |
TD_PROMO_STAT_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit
Default Value: N
|
| 21 |
TD_ALLOW_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Y/N Table Edit
Default Value: N
|
| 22 |
TD_ALLOW_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit
Default Value: N
|
| 23 |
TD_ALLOW_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Y/N Table Edit
Default Value: N
|
| 24 |
TD_ALLOW_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
Y/N Table Edit
Default Value: N
|
| 25 |
TD_ALLOW_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected
Y/N Table Edit
Default Value: N
|
| 26 |
TD_ALLOW_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Y/N Table Edit
Default Value: N
|
| 27 |
TD_ALLOW_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Y/N Table Edit
Default Value: N
|