| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Uniquely identifies a Currency Conversion Process Group
Prompt Table:
EO_CURRCNV_RULE
|
| 2 |
PROD_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
This is an XLAT field listing all PeopleSoft 7.5 Product codes.
AM=Asset Management
AP=Payables
AR=Receivables
BD=Budgets
BI=Billing
CA=Contracts
CE=Cost Management
CP=Product Configurator
DM=Deduction Management
DP=Demand Planning
EN=Manufactuing Bills and Routing
EO=Enterprise Components
EP=Enterprise Planning
EX=Expenses
FG=Federal Government
GF=Global Financials
GL=General Ledger
HP=HRMS Education & Government
IN=Inventory
MG=Manufacturing
OM=Order Management
OP=Order Promising
PC=Projects
PL=Production Planning
PO=Purchasing
QS=Quality
SF=Production Management
TR=Treasury
Prompt Table:
EO_CURRCNV_RULE
|
| 3 |
RULE_INSTNC_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Rule Occurrence Number
|
| 4 |
FLD_INSTNC_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Conversion Field Instance Nbr
|
| 5 |
FIELD_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Category
A=Amount
C=Currency
R=Rate Mult/Div
Default Value: A
|
| 6 |
AMT_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Amount Field Name
Prompt Table:
EO_RECFIELD1_VW
|
| 7 |
CURR_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Field Name
Prompt Table:
EO_RECFIELD6_VW
|
| 8 |
RT_MULT_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Multiplier Field Name
Prompt Table:
EO_RECFIELD1_VW
|
| 9 |
RT_DIV_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Divisor Field Name
Prompt Table:
EO_RECFIELD1_VW
|
| 10 |
CURR_DIRECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Direction
F=FROM Currency Being Converted
T=TO Currency Being Converted
Default Value: F
|
| 11 |
ADDTL_KEY_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Additional Key Field
Prompt Table:
EO_RECFIELD3_VW
|
| 12 |
RECON_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Reconciliation Record Name
Prompt Table:
EO_PSRECDEFN_VW
|
| 13 |
RECON_FLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Reconciliation Field Name
Prompt Table:
EO_RECFIELD7_VW
|
| 14 |
RECON_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reconciliation Method
1=Convert and Adjust
5=Adjust Only
6=Sum-Based Value
7=Sum-Based, Reverse Sign
8=No Reconciliation
Default Value: 8
|
| 15 |
ADJUST_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjustment Method
1=First in Series
2=Last in Series
3=Smallest Amount
4=Largest Amount
5=Smallest Absolute Value
6=Largest Absolute Value
|
| 16 |
FIELD_SQLID |
Character(23) |
VARCHAR2(23) NOT NULL |
Field SQLID
|