| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_FS_VW.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
OVERLAP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Overlap Flag
Y/N Table Edit
Default Value: N
|
| 3 |
TD_PROMO_SPAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Span Sales Periods
Y/N Table Edit
Default Value: N
|
| 4 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 5 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BUTDGL_NONVW
|
| 6 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
SP_BUIN_NONVW
|
| 7 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_TD_VW
|
| 8 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 9 |
UOM_PER |
Character(3) |
VARCHAR2(3) NOT NULL |
Per unit uom
Prompt Table:
UNITS_TBL
|
| 10 |
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. "
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 12 |
TD_TREE_ID_CUST |
Character(8) |
VARCHAR2(8) NOT NULL |
Customer Tree ID
Prompt Table:
TD_TREE_CUST_VW
|
| 13 |
TD_TREE_ID_PROD |
Character(8) |
VARCHAR2(8) NOT NULL |
Product Tree ID
Prompt Table:
TD_TREE_PROD_VW
|
| 14 |
TD_AUTH_INCUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Against Authorized Amt
|
| 15 |
TD_AUTH_INCUR_ALW |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Against Authorized Amt
|
| 16 |
BILL_TYPE_ID_CR |
Character(3) |
VARCHAR2(3) NOT NULL |
Credit Bill Type
Prompt Table:
BI_TYPE_EF_VW
|
| 17 |
INVOICE_FORM_ID_CR |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Invoice Form
Prompt Table:
BI_IVC_FORM
|
| 18 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 19 |
BILL_TYPE_ID_DE |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Bill Type
Prompt Table:
BI_TYPE_EF_VW
|
| 20 |
INVOICE_FORM_ID_DE |
Character(10) |
VARCHAR2(10) NOT NULL |
Deduction Invoice Form
Prompt Table:
BI_IVC_FORM
|
| 21 |
TD_VOUCH_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Voucher Prefix
Prompt Table:
TD_VCHR_AUT_VW
|
| 22 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Prompt Table:
ORIGIN_AP
|
| 23 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 24 |
TD_PROD_GRP_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Product Group Prefix
Prompt Table:
TD_PROGSEQ_VW
|
| 25 |
TD_CUS_GRP_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Customer Group Prefix
Prompt Table:
TD_CUSGSEQ_VW
|
| 26 |
TD_PRC_SET_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Price Rule Prefix
Prompt Table:
TD_PPSSEQ_VW
|
| 27 |
TD_PRC_LIST_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Price List Prefix
Prompt Table:
TD_PRCLSEQ_VW
|
| 28 |
PRICE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Price Type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
Default Value: P
|
| 29 |
PRC_BREAK_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Break Date Type
A=Requested Arrival Date
O=Order Date
S=Schedule Ship Date
|
| 30 |
TD_PRC_BRK_DATE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Second Price Date
A=Requested Arrival Date
O=Order Date
S=Schedule Ship Date
|
| 31 |
TD_PRC_BRK_DATE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Third Price Date
A=Requested Arrival Date
O=Order Date
S=Schedule Ship Date
|
| 32 |
RETURN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be returned
Y/N Table Edit
Default Value: N
|
| 33 |
TD_FREE_GOOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Product Add
AN=Any Product
PT=On Product Tree
Default Value: AN
|
| 34 |
TD_LEVEL_FUND |
Character(2) |
VARCHAR2(2) NOT NULL |
Level to Fund Promotions
BH=Both
MR=Merchandising Activity
PM=Promotion
Default Value: BH
|
| 35 |
TD_LEVEL_PROD |
Character(2) |
VARCHAR2(2) NOT NULL |
Level to Promote Products
BH=Both
MR=Merchandising Activity
PM=Promotion
Default Value: BH
|
| 36 |
TD_NATL_METRIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Metrics for Nat'l Allowances
Y/N Table Edit
Default Value: N
|
| 37 |
TD_RETURN_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days to Accept Returns
|
| 38 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=CRM Free Period Promotion
11=CRM Product Add
12=Pricing Base
13=Rollup Only Rule
14=Min/Max Margin
2=Price Override
3=Product Add
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Related Busines Objects
9=Price List Only Condition
99=Standard Discount
Default Value: 1
|
| 39 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
Default Value: 2
|
| 40 |
TD_INCR_LOAD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Incremental Promo Load
Y/N Table Edit
Default Value: N
|
| 41 |
TD_WF_CUST_PROMO |
Character(1) |
VARCHAR2(1) NOT NULL |
For Customer Promotions
Y/N Table Edit
Default Value: N
|
| 42 |
TD_WF_CLAIMS |
Character(1) |
VARCHAR2(1) NOT NULL |
For Claims
Y/N Table Edit
Default Value: N
|
| 43 |
TD_WF_PAYMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
For Payments
Y/N Table Edit
Default Value: N
|
| 44 |
TD_TREE_ID_APPR |
Character(8) |
VARCHAR2(8) NOT NULL |
Active Approval Tree
Prompt Table:
TD_TREE_APPR_VW
|
| 45 |
TD_DATA_SRC |
Character(2) |
VARCHAR2(2) NOT NULL |
Consumption Data Source
AC=A.C. Nielsen
DP=Demand Planning
IR=IRI
OT=Other
US=User Input
|
| 46 |
TD_PRICE_DEFAULT |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing Default Type
FP=Full Pricing Simulation
IN=Inventory Business Unit
PL=Lowest Price List Price
Default Value: PL
|
| 47 |
EOEP_VAR_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing Variable Type
01=Base Price
02=Rollup Quantity
03=Rollup Amount
04=Rollup Weight
05=Rollup Volume
06=Net Price
07=List Price
08=Product Cost
09=Index Start Amount
10=Index Start Value
11=Index End Value
12=Trans Extended Base Price
13=Trans Extended List Price
14=Trans Extended Net Price
15=Trans Extended Product Cost
16=Alternate Product Cost
99=User Variable
|
| 48 |
EOEP_BAUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use with buying agreement.
N=No
Y=Yes
Default Value: N
|
| 49 |
EOEP_COSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use cost.
N=No
Y=Yes
Default Value: N
|
| 50 |
EOEP_ALTCSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to apply to alternate cost base.
N=No
Y=Yes
Default Value: N
|
| 51 |
EOEP_LISTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use list price.
N=No
Y=Yes
Default Value: Y
|
| 52 |
TD_RETURN_FD_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Returns In Fund Accru.
Y/N Table Edit
Default Value: N
|
| 53 |
BILL_TYPE_ID_CH |
Character(3) |
VARCHAR2(3) NOT NULL |
Chargeback Bill Type
Prompt Table:
BI_TYPE_EF_VW
|
| 54 |
INVOICE_FORM_ID_CH |
Character(10) |
VARCHAR2(10) NOT NULL |
Chargeback Invoice Form
Prompt Table:
BI_IVC_FORM
|
| 55 |
TD_DISPLAY_TREES |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 56 |
TD_DISP_TREE_FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 57 |
TD_DISP_TREE_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 58 |
TD_DISP_TREE_FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 59 |
TD_DISP_TREE_FLAG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 60 |
TD_DISP_TREE_FLAG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 61 |
TD_DISP_TREE_FLAG6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Tree
Y/N Table Edit
Default Value: N
|
| 62 |
TD_CUST_TREE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display In Customer Tree
I=Customer ID
N=Customer Name
P=Customer Name (Customer ID)
S=Customer ID (Customer Name)
Default Value: P
|
| 63 |
TD_PROD_TREE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display In Product Tree
I=Prod./Product Group ID
N=Prod./Product Group Name
P=Prod./Product Group Name (ID)
S=Prod./Product Group ID (Name)
Default Value: P
|
| 64 |
TD_SECURE_FUND_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Customer Selection Tree
Y/N Table Edit
Default Value: Y
|
| 65 |
TD_SECURE_FUND_PRO |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Product Selection Tree
Y/N Table Edit
Default Value: Y
|
| 66 |
TD_SECURE_FUND_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Checkbook Values
Y/N Table Edit
Default Value: Y
|
| 67 |
TD_SECURE_CHCK_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Tree Checkbooks
Y/N Table Edit
Default Value: Y
|
| 68 |
TD_SECURE_CHCK_PRO |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Tree Checkbooks
Y/N Table Edit
Default Value: Y
|
| 69 |
TD_SECURE_CHCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Tree Checkbooks
Y/N Table Edit
Default Value: Y
|
| 70 |
TD_SECURE_ALLW_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
NA Customer Selection Tree
Y/N Table Edit
Default Value: Y
|
| 71 |
TD_SECURE_ALLW_PRO |
Character(1) |
VARCHAR2(1) NOT NULL |
NA Product Selection Tree
Y/N Table Edit
Default Value: Y
|
| 72 |
TD_SECURE_PROM_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Promo. Customer Selection Tree
Y/N Table Edit
Default Value: Y
|
| 73 |
TD_SECURE_PROM_PRO |
Character(1) |
VARCHAR2(1) NOT NULL |
Promo. Product Selection Tree
Y/N Table Edit
Default Value: Y
|
| 74 |
TD_NUM_LEVEL_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Expanded Number Of Tree Levels
0=0 - No Levels
1=1 - One Level
2=2 - Two Levels
3=3 - Three Levels
4=4 - Four Levels
5=5 - Five Levels
A=All Levels
Default Value: A
|
| 75 |
TD_RMA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicable to RMA
N=No
Y=Yes
Default Value: Y
|