| # |
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_SETID_NONVW
|
| 2 |
TD_FUND_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotions Management Fund Code
Prompt Table:
TD_FUND_MASTER
|
| 3 |
ACCRUAL_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Accrual Name
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
|
| 7 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
|
| 8 |
ACCRUAL_RATE |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
Accrual rate
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: TD_FUND_MASTER.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: TD_SETID_TBL.UNIT_OF_MEASURE
Prompt Table:
UNITS_TBL
|
| 11 |
TD_PRODUCT_OVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Accrual Products
Y/N Table Edit
Default Value: N
|
| 12 |
TD_ACCRUAL_RT_OVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Accrual Rate
Y/N Table Edit
Default Value: N
|
| 13 |
TD_TREE_ID_CUST |
Character(8) |
VARCHAR2(8) NOT NULL |
Customer Tree ID
Default Value: TD_FUND_MASTER.TD_TREE_ID_CUST
Prompt Table:
TD_TREE_CUST_VW
|
| 14 |
TD_TREE_EFFDT_CUST |
Date(10) |
DATE NOT NULL |
Customer Effdt
Default Value: TD_FUND_MASTER.TD_TREE_EFFDT_CUST
Prompt Table:
TD_TREE_CUS_VW1
|
| 15 |
TD_TREE_ID_PROD |
Character(8) |
VARCHAR2(8) NOT NULL |
Product Tree ID
Default Value: TD_FUND_MASTER.TD_TREE_ID_PROD
Prompt Table:
TD_TREE_PROD_VW
|
| 16 |
TD_TREE_EFFDT_PROD |
Date(10) |
DATE NOT NULL |
Product Effdt
Default Value: TD_FUND_MASTER.TD_TREE_EFFDT_PROD
Prompt Table:
TD_TREE_PRD_VW1
|
| 17 |
TD_SHIP_INCLUDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipments to Include: (A) All - (P) Promotional
A=All Shipments
P=Promotional Shipments
Default Value: A
|