| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
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
|
| 7 |
TEMPLATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Promotion 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 |
This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.
|
| 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 |
This field stores the Currency Code value.
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. "
|
| 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.
|
| 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
|
| 23 |
PROMO_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotion 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
|
| 34 |
TD_TREE_ID_CUST |
Character(8) |
VARCHAR2(8) NOT NULL |
Customer Tree ID
|
| 35 |
EFFDT_CUST |
Date(10) |
DATE |
Effective Date
|
| 36 |
TD_TREE_ID_PROD |
Character(8) |
VARCHAR2(8) NOT NULL |
Product Tree ID
|
| 37 |
TD_TREE_EFFDT_PROD |
Date(10) |
DATE |
Product Effective Dt.
|
| 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
|
| 41 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 42 |
OPRID_MODIFIED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Modify
|
| 43 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|