General Ledger Units-Daily
The General Ledger Units - Daily file contains debit and credit unit balance information by accounting unit, account, and subaccount for the date specified.
REFERENCED BY
GLOP.1 | GL243 | GL43.1 |
GL110 | GL120 | GL146 | GL167 | GL190 | GL197 |
GL326 | GL40.1 | GL40.2 | GL40.3 | GL40.7 | GL40.8 |
GL44.1 | GL45.1 | GL500 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GUX-COMPANY Element: Company | Numeric 4 The Company field contains the company number that is used in the Organization dimension. |
|
||||||||||||||
GUX-DATE Element: Date | Numeric 8 (yyyymmdd) The Date field contains the system date this was created. The Date format used is YYYYMMDD. |
|
||||||||||||||
GUX-ACCT-UNIT Element: Acct Unit | Alpha 15 The Accounting Unit field contains the name of the accounting unit that is used 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. |
|
||||||||||||||
GUX-ACCOUNT Element: Account | Numeric 6 This field, along with the accounting unit and subaccount, make up the location (account) where units and other account information are stored. |
|
||||||||||||||
GUX-SUB-ACCOUNT Element: Sub Acct | Numeric 4 This field along with the accounting unit and subaccount make up the location (account) where units and other account information is stored. |
|
||||||||||||||
GUX-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||
GUX-CHART-NAME Element: Chart Name | Alpha 12 The Chart of Accounts Name field contains the name of the chart of accounts that is used by the Organization dimension. This name can contain up to 12 alphabetic characters. |
|
||||||||||||||
GUX-DB-UNITS Element: Auto Debits | Signed 15.2 The Debit Units field contains the number of debit units. |
|
||||||||||||||
GUX-CR-UNITS Element: Auto Credits | Signed 15.2 The Credit Units field contains the number of credit units. |
|
||||||||||||||
GUX-FISCAL-YEAR Element: Year | Numeric 4 The Fiscal Year field contains the numeric fiscal year. This field can contain up to four numeric characters. |
|
||||||||||||||
GUX-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The Maintenance Date field contains the date that this file was last updated. The date format used is YYYYMMDD. |
|
||||||||||||||
GUX-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) The Maintenance Time field contains the time that this file was last updated. The time format used is HHMMSS. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GUXSET1 |
COMPANY DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||
GUXSET2 |
MAINT-DATE MAINT-TIME COMPANY DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||
GUXSET3 |
COMPANY FISCAL-YEAR ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE |
|
| ||||||||||||||||||||||
GUXSET4 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE |
|
|
All trademarks and registered trademarks are the property of their
respective owners.