EO_PROCGRP_EXCP(SQL Table) |
Index Back |
---|---|
Process Group Excpeption Proc |
# | 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_PROC_GROUP |
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=HCM 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_PS_PRODUCT |
3 | EXCP_PROC_NAME | Character(8) | VARCHAR2(8) NOT NULL |
Exception Process Name
Prompt Table: EO_CURRCNV_EXCP |
4 | PROCGRP_TIMING_CD | Character(1) | VARCHAR2(1) NOT NULL |
Exception Timing
1=Before Process Group 2=After Process Group 3=In Place Of Process Group |
5 | PROCESSING_SEQ | Number(5,0) | INTEGER NOT NULL | Processing Sequence |
6 | BYPASS_DTL_AUDIT | Character(1) | VARCHAR2(1) NOT NULL |
Used by the Currency Conversion Utility. Any exceptions process that has been coded to write before and after images to the audit table should check this flag before writing to the audit table. Note: Use this flag in conjuntion with the flag on the run control (see Run Control for the Currency Conversion Utility). This flas has been added to the state record.
Y/N Table Edit Default Value: N |
7 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |