GLAUTMPDTL

GL AU Template Detail

This file maintains the names and descriptions of the detailed accounting units within an accounting unit template.

REFERENCED BY
GL124 GL216 GL23.1


UPDATED BY
GL14.1 GL14.8 GL14.5 GL14.6 GL14.9 GL123
GL214

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAU-TEMPLATE-NAME
Element: Template Name		Alpha 12
This field contains the name of the accounting unit template.
GL14.1 GL14.8
GAU-ACCT-UNIT
Element: Accounting Unit		Alpha 15
This file contains the name of an accounting unit within the template..
GL14.1 GL14.8
GAU-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field contains the accounting unit description.
GL14.1 GL14.8
GAU-PARENT-AU
Parent Accounting
Unit		Alpha 15
This field contains the name of the accounting unit to which this accounting unit reports.
GL14.1
GAU-LEVEL-DEPTH
Element: Level Depth		Numeric 1
This field contains the depth within the template of the accounting unit.
GL14.1 GL14.8
GAU-LEVEL-DETAIL
Element: Level Detail		Numeric 15
This field contains the address to be assigned at the level depth defined for the accounting unit.
GL14.1 GL14.8
GAU-PERSON-RESP
Element: Person Responsible		Alpha 15 (Lower Case)
This field contains the name of the person responsible for the accounting unit.
GL14.1 GL14.8
GAU-POSTING-FLAG
Element: Posting Flag		Alpha 1
This field indicates whether the posting flag is Posting (P) or Summary (S). Posting accounting units must have a chart of accounts associated with them.
P = Posting
S = Summary
GL14.1 GL14.8
GAU-ACTIVE-STATUS
Element: Active Status		Alpha 1
This field indicates whether the accounting unit is Active (A) or Inactive (I). If Inactive, no posting can be done to the accounting unit.
A = Active
I = Inactive
GL14.1 GL14.8
GAU-CHART-NAME
Element: Chart Name		Alpha 12
This field contains the name of the chart of accounts associated with the accounting unit.
GL14.1 GL14.8
GAU-CHART-SECTION
Element: Chart Section		Alpha 1
This field contains the chart of accounts section associated with the accounting unit. Valid values are: Blank = All 1 = Balance sheet 2 = Income statement
GL14.1 GL14.8
GAU-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the currency code assigned to the accounting unit.
GL14.1 GL14.8
GAU-VAR-LEVEL-DISP
Variable Level
Display		Alpha 34
This field displays the varaible level.
GL14.1


GLAUTMPDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAUSET1 TEMPLATE-NAME
ACCT-UNIT
GL123 GL124
GL14.1 GL14.2
GL14.4 GL14.5
GL14.6 GL14.7
GL14.8 GL214
GL216 GL23.1
GAUSET3 TEMPLATE-NAME
VAR-LEVEL-DISP
ACCT-UNIT
KeyChange
GL123 GL14.9
GL214
GAUSET4 TEMPLATE-NAME
PARENT-AU
ACCT-UNIT
KeyChange
GL14.1
GAUSET5 TEMPLATE-NAME
LEVEL-DEPTH
ACCT-UNIT
GL14.1


GLAUTMPDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glautmphdr GLAUTMPHDR Required
GAU-TEMPLATE-NAME->GAH-TEMPLATE-NAME


GLAUTMPDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glautmpmst GLAUTMPMST
GAU-TEMPLATE-NAME->GTM-TEMPLATE-NAME
GAU-ACCT-UNIT->GTM-ACCT-UNIT
  GTM-ACCOUNT
  GTM-SUB-ACCOUNT
Glautmpmxv GLAUTMPMXV
GAU-TEMPLATE-NAME->GXV-TEMPLATE-NAME
GAU-ACCT-UNIT->GXV-ACCT-UNIT
  GXV-MATRIX-CAT

File created: Wed Jun 08 20:48:38 2016

Home
Contact Us



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