EO_CCR_IMP_PROD(SQL Table) |
Index Back |
---|---|
CCU Impacted Products |
# | 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
Prompt Table: EO_CURRCNV_RULE |
4 | IMP_PROD_ID | Character(2) | VARCHAR2(2) NOT NULL |
Impacted Product
Prompt Table: EO_PS_PRODUCT |