| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 5 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 6 |
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.
|
| 7 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 9 |
BASE_UNIT_WK |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Units Per Week
|
| 10 |
PRICE_SET_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Price Set Type
99=Standard Discount
A=Price Override
F=Cascading
S=Summed Adjustments
Z=Giveaway
|
| 11 |
PRICE_SET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Set ID
|
| 12 |
INCR_LIFT_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Increased Lift Percentage
|
| 13 |
PARTICIPATION_PCT |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Participation %
|
| 14 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 15 |
PROMO_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotional Group
|
| 16 |
PROMO_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Promotional Price
|
| 17 |
SHELF_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Shelf Price
|
| 18 |
SHIP_UNIT_PL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Planned Ship Qty
|
| 19 |
TD_PROMO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Promo Type
1=Promo Group
2=Promo Product
|
| 20 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 21 |
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
|
| 22 |
PPRC_ADJUST_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing adjustment type
AC=Bill Back
OI=Off-Invoice
|
| 23 |
PROMO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Promotion Type
A=National Allowance
P=Promotion Event
|
| 24 |
PCT_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent/Amount Type
A=Amount
C=New Price
P=Percent
|
| 25 |
DISCOUNT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 26 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
|
| 27 |
CAP_UNITS |
Number(11,0) |
DECIMAL(11) NOT NULL |
Capped Units
|
| 28 |
BREAK_QTY_HIGH |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Upper Quantity/Amount
|
| 29 |
TD_PAY_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Basis
1=Capped
2=Not Capped
|
| 30 |
TD_PTD |
Character(1) |
VARCHAR2(1) NOT NULL |
Period To Date Totals Only
|
| 31 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 32 |
TD_SEND_PRICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Send To Pricing
|
| 33 |
TD_WEIGHTING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Weighting
|
| 34 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 35 |
TD_FUND_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotions Management Fund Code
|
| 36 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 37 |
LUMPSUM_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Lump Sum Cost
|
| 38 |
MERCH_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Merchandising Cost
|
| 39 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 40 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 41 |
DISCOUNT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Discount Percentage
|
| 42 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 43 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 44 |
COUNTER3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 3
|
| 45 |
COUNTER4 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 4
|
| 46 |
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.
|
| 47 |
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. "
|
| 48 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 49 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 50 |
PAYMENT_METHOD_PL |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Payment Method
1=Deduction
2=Check
3=Field Draft
4=Credit Memo
6=Chargeback
|
| 51 |
EOEP_ADJST_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjustment Flag
01=Amount
02=Percentage
03=Price
04=External Class
05=Math Expression
06=Quantity
07=BOGO Factor
08=Quantity with Price
09=BOGO with Price
10=Quantity Expression
11=Amount And Math Expression
12=Percentage And Math Expression
13=Price And Math Expression
|
| 52 |
TD_PCT_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent/Amount Type
A=Amount
P=Percent
|
| 53 |
EOEP_COSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use cost.
N=No
Y=Yes
|
| 54 |
EOEP_ALTCSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to apply to alternate cost base.
N=No
Y=Yes
|
| 55 |
EOEP_LISTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use list price.
N=No
Y=Yes
|
| 56 |
EOEP_ADJUST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back
AMT=Amount
OI=Off-Invoice
OVR=Price Override
PCT=Percent
|
| 57 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 58 |
SHIPPING_QTY |
Number(17,4) |
DECIMAL(16,4) NOT NULL |
Shipping Quantity
|
| 59 |
TD_WEIGHTING_TOTAL |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
Weighting Total
|
| 60 |
TD_SEQNO |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Sequence Number
|
| 61 |
TD_SEQNO_ORG |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Sequence Number
|
| 62 |
TD_NODE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Node ID
|
| 63 |
TD_TREE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Tree ID
|
| 64 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 65 |
TD_NODE_PARENT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Node ID
|
| 66 |
ORIG_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original Amount
|