| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 4 |
UID20 |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
ADJUSTMENT_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Adjustment Percent
|
| 7 |
EOEP_FORM_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Formula Break
|
| 8 |
EOEP_DATE_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Date Break
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 10 |
PRICE_OVERRIDE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Price Override
|
| 11 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 12 |
PRICE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
|
| 13 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=Free Period Promotion
11=Product Add
12=Price Base
13=Rollup Only Rule
14=Min/Max Margin
15=Recurring Discount/Surcharge
2=Price Override
3=Giveaway / 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
|
| 14 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
|
| 15 |
EOEP_ADJST_AMT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment Amount
|
| 16 |
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
|
| 17 |
EOEP_ADJUSTMENT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment
|
| 18 |
EOEP_FORMULA_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pricing Formula ID
|
| 19 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 20 |
EOEP_CHAR |
Character(254) |
VARCHAR2(254) NOT NULL |
Long field
|
| 21 |
RECUR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies if a revenue flow is one of a set of recurring.
N=Non-Recuring Revenue
Y=Recurring Revenue
Default Value: N
|
| 22 |
EOEP_RECURRENCE |
Number(2,0) |
SMALLINT NOT NULL |
Recurrence of Discount, etc
|
| 23 |
PPRC_RECUR_FREQ |
Character(2) |
VARCHAR2(2) NOT NULL |
Field used to store the recurring frequency.
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually
|
| 24 |
RECUR_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Recurring Price
|
| 25 |
PRORATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Proration flag - indicates if order adjustments are prorated to the lines
0=Do Not Prorate Adjustments
1=Prorate Order Adjustments
|
| 26 |
EOEP_TEXT_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Text Value
|
| 27 |
EOEP_ONETIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
One-Time Flag
1=No
2=Per Customer
3=Per Rule
|
| 28 |
EOEP_MEPR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mutually Exclusive Pricing Rule
N=No
Y=Yes
|
| 29 |
PRICE_ADJST_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Adjustment Reason
|
| 30 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 31 |
RO_ADJST_AMT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Price adjustment amount, percent or override
|
| 32 |
RO_ADJST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price adjustments flag.
1=Percent
2=Amount
3=Override
|
| 33 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 34 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 35 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 36 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 37 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 38 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|