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.
UPDATED BY
GL110 GL120 GL146 GL167 GL190 GL197
GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL500 GLOP.1 GL243 GL43.1

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: Wed Jun 08 20:48:42 2016

Home
Contact Us



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