| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
TD_CALENDAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar Type
A=National Allowance
B=Nat'l Allowances & Cust. Promo
P=Customer Promotion
|
| 3 |
TD_NUM_OF_CAL |
Number(1,0) |
SMALLINT NOT NULL |
Number of Calendars To Display
|
| 4 |
TITLE |
Character(35) |
VARCHAR2(35) NOT NULL |
Title
|
| 5 |
TD_DISPLAY_MONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Starting Month
C=Current Month
M=Current Minus x Months
P=Current Plus x Months
U=User Defined
Default Value: C
|
| 6 |
TD_DISPLAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Checkbook
Y/N Table Edit
Default Value: Y
|
| 7 |
NO_OF_MONTHS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Number of Months
Default Value: 1
|
| 8 |
DISPLAY_MONTHS |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of months to display
1=1 Month
2=2 Months
3=3 Months
4=4 Months
5=5 Months
6=6 Months
Default Value: 3
|
| 9 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
Default Value: 01
|
| 10 |
YEAROFDATE |
Number(4,0) |
SMALLINT NOT NULL |
Year of Date
Default Value: 2000
|
| 11 |
TD_FROM_DATE |
Character(2) |
VARCHAR2(2) NOT NULL |
From Date
FA=First Arrival Date
FO=First Order Date
FS=First Ship Date
Default Value: FO
|
| 12 |
TD_THRU_DATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Through Date
LA=Last Arrival Date
LO=Last Order Date
LS=Last Ship Date
Default Value: LO
|
| 13 |
TD_PROMO_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Approved
Default Value: Y
|
| 14 |
TD_PROMO_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Cancelled
Default Value: Y
|
| 15 |
TD_PROMO_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Default Value: Y
|
| 16 |
TD_PROMO_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Rejected
Default Value: Y
|
| 17 |
TD_PROMO_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Approved
Default Value: Y
|
| 18 |
TD_PROMO_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Rejected
Default Value: Y
|
| 19 |
TD_PROMO_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Default Value: Y
|
| 20 |
TD_PROMO_STAT_08 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Default Value: Y
|
| 21 |
TD_PROMO_STAT_09 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Default Value: Y
|
| 22 |
TD_PROMO_STAT_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Default Value: Y
|
| 23 |
TD_ALLOW_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Default Value: Y
|
| 24 |
TD_ALLOW_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Default Value: Y
|
| 25 |
TD_ALLOW_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Default Value: Y
|
| 26 |
TD_ALLOW_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
Default Value: Y
|
| 27 |
TD_ALLOW_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected
Default Value: Y
|
| 28 |
TD_ALLOW_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Default Value: Y
|
| 29 |
TD_ALLOW_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Default Value: Y
|