| # |
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
Default Value: NEXT
|
| 3 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: I
|
| 4 |
TD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Approved
I=Initial
P=Pending
R=Rejected
Default Value: I
|
| 5 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: TD_SETID_TBL.BUSINESS_UNIT_GL
Prompt Table:
SP_BUTDGL_NONVW
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 8 |
FUND_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Type
D=Discretionary
N=Non-Discretionary
|
| 9 |
FUND_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Funding Method
F=Fixed Accrual
R=Rolling Accrual
T=Top Down
Z=Zero-Based Accrual
|
| 10 |
FUND_USAGE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Fund Usage
Prompt Table:
TD_FUND_USAGE
|
| 11 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_TD.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 13 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 14 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: TD_SETID_TBL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
DISTRIB_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Distributed amount
|
| 16 |
TD_UNITS |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Units
|
| 17 |
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
|
| 18 |
TD_LAST_REFRESH |
DateTime(26) |
TIMESTAMP |
Last Refresh
|
| 19 |
FUND_START_DT |
Date(10) |
DATE NOT NULL |
Start Date
|
| 20 |
FUND_END_DT |
Date(10) |
DATE NOT NULL |
End Date
|
| 21 |
TD_TREE_ID_CUST |
Character(8) |
VARCHAR2(8) NOT NULL |
Customer Tree ID
Default Value: TD_SETID_TBL.TD_TREE_ID_CUST
Prompt Table:
TD_TREE_CUST_VW
|
| 22 |
TD_TREE_EFFDT_CUST |
Date(10) |
DATE NOT NULL |
Customer Effdt
Prompt Table:
TD_TREE_CUS_VW1
|
| 23 |
TD_TREE_ID_PROD |
Character(8) |
VARCHAR2(8) NOT NULL |
Product Tree ID
Default Value: TD_SETID_TBL.TD_TREE_ID_PROD
Prompt Table:
TD_TREE_PROD_VW
|
| 24 |
TD_TREE_EFFDT_PROD |
Date(10) |
DATE NOT NULL |
Product Effdt
Prompt Table:
TD_TREE_PRD_VW1
|
| 25 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 26 |
TD_PROTECT_FUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Protect Fund from FINUP
Y/N Table Edit
Default Value: N
|
| 27 |
TD_RETURN_FD_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Returns In Fund Accru.
Y/N Table Edit
Default Value: N
|