GL Drill Around
The GL Consolidation Drill file provides drill around functionality from a
consolidation company balance amount back to the originating company source
transaction that created the amounts.
UPDATED BY
| GL195 | GL500 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| GLD-GLT-OBJ-ID GL Transaction Object ID | Numeric 12 This is a unique internal GL transaction identification number that is used for Drill Around purposes. |
|
||
| GLD-ORIG-COMPANY Element: Original Company | Numeric 4 This field contains the name of the source company that originated the transaction posted to the consolidation company. |
|
||
| GLD-COMPANY Element: Company | Numeric 4 This field contains the name of the consolidation company. |
|
||
| GLD-ACCOUNT Element: Account | Numeric 6 This field contains the account number containing the amounts being queried. |
|
||
| GLD-SUB-ACCOUNT Element: Subaccount | Numeric 4 This field contains the sub-account containing the amounts being queried. |
|
||
| GLD-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Tis field contains the fiscal year of the transaction being queried. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GLDSET1 |
GLT-OBJ-ID |
|
| ||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glamacct | GLAMOUNTS |
| ||||||||||||||||||
| Glamounts | GLAMOUNTS |
|
All trademarks and registered trademarks are the property of their
respective owners.