TAGENLEDGR

General Ledger Rules define if liability is posted for balances and accruals, if posting is reversing or non-reversing, if only a portion of a balance or accrual is posted as a liability, and the liability accrual and expense accounts.

REFERENCED BY
HR11.1 HR511 LT101 LP100 LP101 LP102
LP103 LP131 LP180 LP188 LP197 LP198
LP31.1 LP80.1 PA100 PA52.4 LP02.1 LP04.2
LP04.3 LP04.4 LP04.5 LP04.6 LP04.7 LP04.8
LP04.9 LP201 LP203


UPDATED BY
HR00.1 HR01.1 LP03.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TGE-COMPANY
Element: Company Hr
Numeric 4
LP03.6
TGE-GL-RULE
Element: Ta Rule
Alpha 10
LP03.6
TGE-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
LP03.6
TGE-HRS-LIA-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Available only
02 = Available + Reserve
03 = Available + Allotment
04 = Available; Reserve; Allotment
05 = Available; Accrued; Allotment
06 = All balances
LP03.6
TGE-HRS-LIA-METHOD
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Reversing
02 = Non-reversing
LP03.6
TGE-HRS-LIA-TBL
Element: Ta Table
Alpha 10
LP03.6
TGE-HRS-ACCR-CO
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
LP03.6
TGE-HRS-ACCR-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
LP03.6
TGE-HRS-ACCR-ACCT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
LP03.6
TGE-HRS-ACCR-SUB
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
LP03.6
TGE-HRS-EXP-CO
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
LP03.6
TGE-HRS-EXP-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
LP03.6
TGE-HRS-EXP-ACCT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
LP03.6
TGE-HRS-EXP-SUB
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
LP03.6
TGE-HRS-POST-TO-AC
Element: Lp Post To Ac
Numeric 1

0 = No
1 = Yes
LP03.6
TGE-HRS-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
LP03.6
TGE-HRS-ACCT-CAT
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
LP03.6
TGE-ERN-LIA-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Available only
02 = Available + Reserve
03 = Available + Allotment
04 = Available; Reserve; Allotment
05 = Available; Accrued; Allotment
06 = All balances
LP03.6
TGE-ERN-LIA-METHOD
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Reversing
02 = Non-reversing
LP03.6
TGE-ERN-LIA-TBL
Element: Ta Table
Alpha 10
LP03.6
TGE-ERN-ACCR-CO
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
LP03.6
TGE-ERN-ACCR-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
LP03.6
TGE-ERN-ACCR-ACCT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
LP03.6
TGE-ERN-ACCR-SUB
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
LP03.6
TGE-ERN-EXP-CO
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
LP03.6
TGE-ERN-EXP-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
LP03.6
TGE-ERN-EXP-ACCT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
LP03.6
TGE-ERN-EXP-SUB
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
LP03.6
TGE-ERN-POST-TO-AC
Element: Lp Post To Ac
Numeric 1

0 = No
1 = Yes
LP03.6
TGE-ERN-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
LP03.6
TGE-ERN-ACCT-CAT
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
LP03.6
TGE-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP03.6
TGE-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP03.6
TGE-USER-ID
Element: User
Alpha 10 (Lower Case)
LP03.6
TGE-PAY-RATE-CHG
Element: Pay Rate Chg
Numeric 1
This field indicates whether to include or exclude adjustments for changes to the employee rate of pay when computing the liability.
1 = Exclude
2 = Include
LP03.6


TAGENLEDGR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TGESET1 COMPANY
GL-RULE
...
HR00.1 HR01.1
HR11.1 HR511
LT101 LP02.1
LP03.1 LP03.2
LP03.3 LP03.4
LP03.5 LP03.6
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
LP100 LP101
LP102 LP103
LP131 LP180
LP188 LP197
LP198 LP201


TAGENLEDGR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TGE-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Ern Accr Dist GLMASTER Required
When TGE-ERN-ACCR-CO !=Zeroes
AndTGE-ERN-ACCR-UNIT !=Spaces
AndTGE-ERN-ACCR-ACCT !=Zeroes
TGE-ERN-ACCR-CO->GLM-COMPANY
TGE-ERN-ACCR-UNIT->GLM-ACCT-UNIT
TGE-ERN-ACCR-ACCT->GLM-ACCOUNT
TGE-ERN-ACCR-SUB->GLM-SUB-ACCOUNT
Ern Acct Cat ACACCTCAT Required
When (TGE-ERN-ACCT-CAT !=Spaces )
TGE-ERN-ACCT-CAT->AAX-ACCT-CATEGORY
Ern Activity ACACTIVITY Required
When (TGE-ERN-ACTIVITY !=Spaces )
TGE-ERN-ACTIVITY->ACV-ACTIVITY
Ern Exp Dist GLMASTER Required
When TGE-ERN-EXP-CO !=Zeroes
AndTGE-ERN-EXP-UNIT !=Spaces
AndTGE-ERN-EXP-ACCT !=Zeroes
TGE-ERN-EXP-CO->GLM-COMPANY
TGE-ERN-EXP-UNIT->GLM-ACCT-UNIT
TGE-ERN-EXP-ACCT->GLM-ACCOUNT
TGE-ERN-EXP-SUB->GLM-SUB-ACCOUNT
Hrs Accr Dist GLMASTER Required
When TGE-HRS-ACCR-CO !=Zeroes
AndTGE-HRS-ACCR-UNIT !=Spaces
AndTGE-HRS-ACCR-ACCT !=Zeroes
TGE-HRS-ACCR-CO->GLM-COMPANY
TGE-HRS-ACCR-UNIT->GLM-ACCT-UNIT
TGE-HRS-ACCR-ACCT->GLM-ACCOUNT
TGE-HRS-ACCR-SUB->GLM-SUB-ACCOUNT
Hrs Acct Cat ACACCTCAT Required
When (TGE-HRS-ACCT-CAT !=Spaces )
TGE-HRS-ACCT-CAT->AAX-ACCT-CATEGORY
Hrs Activity ACACTIVITY Required
When (TGE-HRS-ACTIVITY !=Spaces )
TGE-HRS-ACTIVITY->ACV-ACTIVITY
Hrs Exp Dist GLMASTER Required
When TGE-HRS-EXP-CO !=Zeroes
AndTGE-HRS-EXP-UNIT !=Spaces
AndTGE-HRS-EXP-ACCT !=Zeroes
TGE-HRS-EXP-CO->GLM-COMPANY
TGE-HRS-EXP-UNIT->GLM-ACCT-UNIT
TGE-HRS-EXP-ACCT->GLM-ACCOUNT
TGE-HRS-EXP-SUB->GLM-SUB-ACCOUNT


TAGENLEDGR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ern Lia Tbl TATABLE
Valid When TGE-ERN-LIA-TBL !=Spaces
TGE-COMPANY->TBL-COMPANY
TGE-ERN-LIA-TBL->TBL-TABLE
  TBL-EFFECTIVE-DATE
Hrs Lia Tbl TATABLE
Valid When TGE-HRS-LIA-TBL !=Spaces
TGE-COMPANY->TBL-COMPANY
TGE-HRS-LIA-TBL->TBL-TABLE
  TBL-EFFECTIVE-DATE


File created: Thu Jun 09 11:19:46 2016

Home
Contact Us



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