ACREVENUEX FILE Activity Revenue Detail This file contains detailed revenue recognition information from AC14.1 (Activity Revenue). REFERENCED BY AC170 AC214 AC04.1 UPDATED BY AC10.1 AC110 AC14.1 AC300 AC310 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ARX-ACTIVITY Alpha 15 AC110 AC14.1 Activity This is the activity for the revenue recognition parameters. ARX-ACCT-CATEGORY Alpha 5 AC110 AC14.1 Account Category This is the account category for the revenue recognition parameters. ARX-REVENUE-GL-CD Alpha 4 AC110 AC14.1 Revenue GL Code This is the general ledger (GL) code for revenue. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-REV-ACCT-CAT Alpha 5 AC110 AC14.1 Revenue Account This is the revenue account category. Category There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-REV-ACCT Numeric 6 AC110 AC14.1 Revenue Account This is the general ledger account for revenue. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-REV-SUB-ACCT Numeric 4 AC110 AC14.1 Revenue Subaccount This is the general ledger subaccount for revenue. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-LOSS-GL-CD Alpha 4 AC110 AC14.1 Loss GL Code This is the general ledger (GL) code for loss. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-LOSS-ACCT-CAT Alpha 5 AC110 AC14.1 Loss Account This is the account category for loss. Category There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-LOSS-ACCT Numeric 6 AC110 LOss Account This is the general ledger account for loss. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-LOSS-SUB-ACCT Numeric 4 AC110 Loss Subaccount This is the general ledger subaccount for loss. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-RSRV-LSS-GL-CD Alpha 4 AC110 AC14.1 Reserve for Loss GL This is the general ledger (GL) code Code for reserve for loss. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-R-LSS-ACCT Numeric 6 AC110 Reserve for Loss This is the general ledger reserve for Account loss account. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ARX-R-LSS-SUB-ACCT Numeric 4 AC110 Reserve for Loss This is the general ledger reserve for Subaccount loss subaccount. There are two approaches; you can define either general ledger accounts and subaccounts or Activity Management account categories and general ledger (GL) codes, but not both. ACREVENUEX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ARXSET1 ACTIVITY AC10.1 AC110 ACCT-CATEGORY AC14.1 AC170 AC214 AC300 AC310 ARXSET2 REVENUE-GL-CD KeyChange AC04.1 ACTIVITY ACCT-CATEGORY ARXSET3 LOSS-GL-CD KeyChange AC04.1 ACTIVITY ACCT-CATEGORY ARXSET4 RSRV-LSS-GL-CDKeyChange AC04.1 ACTIVITY ACCT-CATEGORY ACREVENUEX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acacctcat ACACCTCAT Not Required ARX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY Acactivity ACACTIVITY Required ARX-ACTIVITY -> ACV-ACTIVITY Acrevenue ACREVENUE Required ARX-ACTIVITY -> ARV-ACTIVITY Loss Acacctcat ACACCTCAT Not Required ARX-LOSS-ACCT-CAT -> AAX-ACCT-CATEGORY Loss Acglcode ACGLCODE Not Required ARX-LOSS-GL-CD -> AGC-AC-GL-CODE Rev Acacctcat ACACCTCAT Required ARX-REV-ACCT-CAT -> AAX-ACCT-CATEGORY Rev Acglcode ACGLCODE Not Required ARX-REVENUE-GL-CD -> AGC-AC-GL-CODE Rloss Acglcode ACGLCODE Not Required ARX-RSRV-LSS-GL-CD -> AGC-AC-GL-CODE ACREVENUEX FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acacctcatx ACACCTCATX ACV-ACTIVITY-GRP -> AXX-ACTIVITY-GRP ARX-ACTIVITY -> AXX-ACTIVITY AXX-ACCT-CATEGORY |