|
SELECT SETID , PPRC_PROMO_CD , CUST_ID , CONTACT_ID , PROMO_GROUP , PRODUCT_ID , STATUS_TD , PROTECT_PROMO , REFERENCE_NUM , BUSINESS_UNIT_GL , GRACE_DAYS , DST_ID , BASE_UNIT_WK , UNIT_OF_MEASURE , SHIP_UNIT_PL , INCR_LIFT_PCT , PARTICIPATION_PCT , SHELF_PRICE , PROMO_PRICE , CURRENCY_CD , RT_TYPE , BASE_CURRENCY , RATE_MULT , RATE_DIV , DISCOUNT_PCT , CALENDAR_ID , PROMO_PERIOD , FIRST_ORDER_DATE , LAST_ORDER_DATE , FIRST_SHIP_DATE , LAST_SHIP_DATE , FIRST_DELIVERY_DT , LAST_DELIVERY_DT , FIRST_PERFORM_DT , LAST_PERFORM_DT , PERFORM_WEEKS , TD_AUTH_INCUR , TD_INT_STATUS , DELETE_FLAG , APPROVED , DESCR254_MIXED , OPRID_ENTERED_BY , ENTERED_DT , OPRID_MODIFIED_BY , LAST_UPDATE_DT FROM PS_TD_PROMO_CUST
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: TD_PROMO_MASTER.SETID
Prompt Table:
SP_SETTD_NONVW
|
| 2 |
TO_PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
To Promotion Code
|
| 3 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
TD_CUST_OPRVW
|
| 4 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
CONTACT
|
| 5 |
PROMO_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotional Group
|
| 6 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
Set Control Field: SETID
|
| 7 |
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
Default Value: PL
|
| 8 |
PROTECT_PROMO |
Character(1) |
VARCHAR2(1) NOT NULL |
Protect Promotion
Y/N Table Edit
Default Value: N
|
| 9 |
REFERENCE_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference
Default Value: PPRC_PROMO_TBL.REFERENCE_NUM
|
| 10 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: PPRC_PROMO_TBL.BUSINESS_UNIT_GL
Prompt Table:
SP_BUTDGL_NONVW
|
| 11 |
GRACE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Grace Days
Default Value: 0
|
| 12 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
Default Value: PPRC_PROMO_TBL.DST_ID
Prompt Table:
DSTCD_DIS_OM_VW
|
| 13 |
BASE_UNIT_WK |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Units Per Week
Default Value: TD_PROMO_MASTER.BASE_UNIT_WK
|
| 14 |
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_PROMO_MASTER.UNIT_OF_MEASURE
Prompt Table:
UNITS_TBL
|
| 15 |
SHIP_UNIT_PL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Planned Ship Qty
Default Value: TD_PROMO_MASTER.SHIP_UNIT_PL
|
| 16 |
INCR_LIFT_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Increased Lift Percentage
Default Value: TD_PROMO_MASTER.INCR_LIFT_PCT
|
| 17 |
PARTICIPATION_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Participation %
Default Value: TD_PROMO_MASTER.PARTICIPATION_PCT
|
| 18 |
SHELF_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Shelf Price
Default Value: TD_PROMO_MASTER.SHELF_PRICE
|
| 19 |
PROMO_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Promotional Price
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PPRC_PROMO_TBL.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 21 |
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
|
| 22 |
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
|
| 23 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: PPRC_PROMO_TBL.RATE_MULT
|
| 24 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: PPRC_PROMO_TBL.RATE_DIV
|
| 25 |
DISCOUNT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Discount Percentage
|
| 26 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Default Value: PPRC_PROMO_TBL.CALENDAR_ID
Prompt Table:
CAL_TD_VW
|
| 27 |
PROMO_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotion Period
Default Value: PPRC_PROMO_TBL.PROMO_PERIOD
Prompt Table:
TD_PROMO_PERIOD
|
| 28 |
FIRST_ORDER_DATE |
Date(10) |
DATE |
First Order Date
Default Value: PPRC_PROMO_TBL.FIRST_ORDER_DATE
|
| 29 |
LAST_ORDER_DATE |
Date(10) |
DATE |
Last Order Date
Default Value: PPRC_PROMO_TBL.LAST_ORDER_DATE
|
| 30 |
FIRST_SHIP_DATE |
Date(10) |
DATE |
First Scheduled Ship Date
Default Value: PPRC_PROMO_TBL.FIRST_SHIP_DATE
|
| 31 |
LAST_SHIP_DATE |
Date(10) |
DATE |
Last Scheduled Ship Date
Default Value: PPRC_PROMO_TBL.LAST_SHIP_DATE
|
| 32 |
FIRST_DELIVERY_DT |
Date(10) |
DATE |
Physical date of position.
Default Value: PPRC_PROMO_TBL.FIRST_DELIVERY_DT
|
| 33 |
LAST_DELIVERY_DT |
Date(10) |
DATE |
Last delivery date for a contract
.
Default Value: PPRC_PROMO_TBL.LAST_DELIVERY_DT
|
| 34 |
FIRST_PERFORM_DT |
Date(10) |
DATE |
First Peformance Date
Default Value: PPRC_PROMO_TBL.FIRST_PERFORM_DT
|
| 35 |
LAST_PERFORM_DT |
Date(10) |
DATE |
Last Performance Date
Default Value: PPRC_PROMO_TBL.LAST_PERFORM_DT
|
| 36 |
PERFORM_WEEKS |
Number(3,0) |
SMALLINT NOT NULL |
Performance weeks
Default Value: PPRC_PROMO_TBL.PERFORM_WEEKS
|
| 37 |
TD_AUTH_INCUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Authorization Required
Y/N Table Edit
Default Value: PPRC_PROMO_TBL.TD_AUTH_INCUR
|
| 38 |
TD_INT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Status
A=Not Applicable
C=Changed
D=Deleted
M=Complete
N=New
Default Value: N
|
| 39 |
DELETE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deletion Flag
Y/N Table Edit
Default Value: Y
|
| 40 |
APPROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
Y/N Table Edit
Default Value: N
|
| 41 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 42 |
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
|
| 43 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 44 |
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.
|
| 45 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|