| # |
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 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
Default Value: NEXT
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: PPRC_PROMO_TBL.DESCR
|
| 6 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
CONTACT_TD
|
| 7 |
TEMPLATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Promotion Template
P=Promotion
T=Template
|
| 8 |
REFERENCE_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference
|
| 9 |
STATUS_TD |
Character(2) |
VARCHAR2(2) NOT NULL |
Promotion Status
CA=Customer Approved
CE=Customer Cancelled
CL=Closed
CR=Customer Rejected
MA=Management Approved
MR=Management Rejected
PA=Pending Approval
PL=Planned
RE=Recalled
RL=Released
|
| 10 |
ALLOW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allowance Status
1=Planned
2=Released
3=Pending Approval
4=Approved
5=Rejected
6=Closed
7=Recalled
|
| 11 |
PROMO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Promotion Type
A=National Allowance
P=Promotion Event
Default Value: P
|
| 12 |
PLAN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned status
P=Planned
U=Unplanned
Default Value: P
|
| 13 |
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
|
| 14 |
GRACE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Grace Days
Default Value: 0
|
| 15 |
TD_STOP_SEARCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Stop Applying Discounts
Y/N Table Edit
Default Value: N
|
| 16 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 18 |
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
|
| 19 |
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.
Default Value: TD_SETID_TBL.RT_TYPE
|
| 20 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1
|
| 21 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 22 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Default Value: TD_SETID_TBL.CALENDAR_ID
Prompt Table:
CAL_TD_VW
|
| 23 |
PROMO_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotion Period
Prompt Table:
TD_PROMO_PERIOD
|
| 24 |
FIRST_ORDER_DATE |
Date(10) |
DATE |
First Order Date
|
| 25 |
LAST_ORDER_DATE |
Date(10) |
DATE |
Last Order Date
|
| 26 |
FIRST_SHIP_DATE |
Date(10) |
DATE |
First Scheduled Ship Date
|
| 27 |
LAST_SHIP_DATE |
Date(10) |
DATE |
Last Scheduled Ship Date
|
| 28 |
FIRST_DELIVERY_DT |
Date(10) |
DATE |
Physical date of position.
|
| 29 |
LAST_DELIVERY_DT |
Date(10) |
DATE |
Last delivery date for a contract
.
|
| 30 |
FIRST_PERFORM_DT |
Date(10) |
DATE |
First Peformance Date
|
| 31 |
LAST_PERFORM_DT |
Date(10) |
DATE |
Last Performance Date
|
| 32 |
PERFORM_WEEKS |
Number(3,0) |
SMALLINT NOT NULL |
Performance weeks
|
| 33 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
Prompt Table:
DSTCD_DIS_OM_VW
Set Control Field: SETID
|
| 34 |
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
Set Control Field: SETID
|
| 35 |
EFFDT_CUST |
Date(10) |
DATE |
Effective Date
Prompt Table:
TD_TREE_CUS_VW1
|
| 36 |
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
Set Control Field: SETID
|
| 37 |
TD_TREE_EFFDT_PROD |
Date(10) |
DATE |
Product Effective Dt.
Prompt Table:
TD_TREE_PRD_VW1
|
| 38 |
TD_AUTH_INCUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Authorization Required
Y/N Table Edit
|
| 39 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 40 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 41 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 42 |
OPRID_MODIFIED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Modify
Entered By
07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
|
| 43 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|