GLUNITSX

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


UPDATED BY
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.
GL110 GL146
GL167 GL190
GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GUX-DATE
Element: Date
Numeric 8 (yyyymmdd)
The Date field contains the system date this was created. The Date format used is YYYYMMDD.
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
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.
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
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.
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
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.
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GUX-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
GL120 GL146
GL167 GL190
GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
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.
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GUX-DB-UNITS
Element: Auto Debits
Signed 15.2
The Debit Units field contains the number of debit units.
GL110 GL146
GL167 GL190
GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GUX-CR-UNITS
Element: Auto Credits
Signed 15.2
The Credit Units field contains the number of credit units.
GL110 GL146
GL167 GL190
GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
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.
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
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.
GL120 GL146
GL167 GL190
GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
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.
GL120 GL146
GL167 GL190
GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500


GLUNITSX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GUXSET1 COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GL110 GL120
GL146 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLOP.1
GUXSET2 MAINT-DATE
MAINT-TIME
COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
KeyChange
GLOP.1
GUXSET3 COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
KeyChange
GL110
GUXSET4 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
GL120 GL243
GL43.1


File created: Thu Jun 09 02:14:15 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.