GLAMOUNTSX FILE General Ledger Amounts-Daily The General Ledger Amounts-Daily file contains daily account balances by accounting unit, account, and subaccount for the date specified. REFERENCED BY GLOP.1 GL243 GL43.1 UPDATED BY GL110 GL120 GL146 GL167 GL190 GL300 GL326 GL45.1 GL500 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY GAX-COMPANY Numeric 4 GL110 GL146 Company The Company field contains the company GL167 GL190 number this is used in the Organization GL326 GL45.1 dimension. GAX-DATE Numeric 8 (yyyymmdd) GL146 GL167 Date The Date field contains the system date GL190 GL326 this was created. The Date format used GL45.1 is YYYYMMDD. GAX-ACCT-UNIT Alpha 15 GL146 GL167 Accounting Unit The Accounting Unit field contains the GL190 GL326 name of the accounting unit that is used GL45.1 in the Organization dimension. If this field is blank, all accounting units are included as members in the dimension outline. This name can contain up to 15 alphabetic characters. GAX-ACCOUNT Numeric 6 GL146 GL167 Account This field along with the accounting GL190 GL326 unit and subaccount make up the location GL45.1 (account) where amounts and other account information is stored. GAX-SUB-ACCOUNT Numeric 4 GL146 GL167 Subaccount This field along with the accounting GL190 GL326 unit and subaccount make up the location GL45.1 (account) where amounts and other account information is stored. GAX-VAR-LEVELS Alpha 30 GL120 GL146 Variable Levels A level that represents the location of GL167 GL190 an accounting unit in an organization's GL326 GL45.1 level structure. GAX-CHART-NAME Alpha 12 GL146 GL167 Chart of Accounts The Chart of Accounts Name field GL190 GL326 Name contains the name of the chart of GL45.1 accounts that is used by the Organization dimension. This name can contain up to 12 alphabetic characters. GAX-DB-AMOUNT Currency 15.2 GL110 GL146 Debit Amount The Debit Amount field contains the GL167 GL190 debit amount. GL326 GL45.1 GAX-CR-AMOUNT Currency 15.2 GL110 GL146 Credit Amount The Credit Amount field contains the GL167 GL190 credit amount. GL326 GL45.1 GAX-FISCAL-YEAR Numeric 4 GL146 GL167 Fiscal Year The Fiscal Year field contains the GL190 GL326 numeric fiscal year. This field can GL45.1 GL500 contain up to four numeric characters. GAX-ACCT-PERIOD Numeric 2 GL146 GL167 Accounting Period This is the current accounting period. GL190 GL326 This field is updated by GL199 (Period GL45.1 Closing). GAX-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146 Maintenance Date The Maintenance Date field contains the GL167 GL190 date that this file was last updated. GL326 GL45.1 The date format used is YYYYMMDD. GL500 GAX-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146 Maintenance Time The Maintenance Time field contains the GL167 GL190 time that this file was last updated. GL326 GL45.1 The time format used is HHMMSS. GL500 GAX-NET-AMOUNT Derived Net Amount The net daily base amount. This amount is the debit amount added to the credit amount. GLAMOUNTSX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN GAXSET1 COMPANY GL146 GL167 DATE GL190 GL326 ACCT-UNIT GL45.1 GL500 ACCOUNT GLOP.1 SUB-ACCOUNT GAXSET2 MAINT-DATE KeyChange GLOP.1 MAINT-TIME COMPANY DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT GAXSET3 COMPANY KeyChange GL110 GL300 FISCAL-YEAR ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE GAXSET4 COMPANY GL120 GL243 ACCT-UNIT GL43.1 ACCOUNT SUB-ACCOUNT DATE GLAMOUNTSX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Glamountsx GLAMOUNTSX Required GAX-COMPANY -> GAX-COMPANY GAX-DATE -> GAX-DATE GAX-ACCT-UNIT -> GAX-ACCT-UNIT GAX-ACCOUNT -> GAX-ACCOUNT GAX-SUB-ACCOUNT -> GAX-SUB-ACCOUNT GLAMOUNTSX FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Glamounts GLAMOUNTS GAX-COMPANY -> GAM-COMPANY GAX-FISCAL-YEAR -> GAM-FISCAL-YEAR GAX-ACCT-UNIT -> GAM-ACCT-UNIT GAX-SUB-ACCOUNT -> GAM-ACCOUNT GAM-SUB-ACCOUNT Gltrans GLTRANS GAX-COMPANY -> GLT-TO-COMPANY GAX-ACCOUNT -> GLT-ACCOUNT GAX-SUB-ACCOUNT -> GLT-SUB-ACCOUNT GAX-ACCT-UNIT -> GLT-ACCT-UNIT GAX-FISCAL-YEAR -> GLT-FISCAL-YEAR GLT-ACCT-PERIOD GLT-SYSTEM GLT-CONTROL-GROUP GLT-JE-TYPE GLT-JE-SEQUENCE GLT-LINE-NBR GLT-COMPANY |