|
|
TAGENLEDGR FILE
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 LP02.1 LP04.2 LP04.3 LP04.4
LP04.5 LP04.6 LP04.7 LP04.8 LP04.9 LP100
LP101 LP180 LP188 LP197 LP198 LP201
LP203 LP31.1 LP80.1 PA100 PA52.4
UPDATED BY
LP03.6 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TGE-COMPANY Numeric 4 LP03.6
Element: Company Hr
TGE-GL-RULE Alpha 10 LP03.6
Element: Ta Rule
TGE-DESCRIPTION Alpha 30 (Lower Case) LP03.6
Element: Ta Description
TGE-HRS-LIA-TYPE Numeric 2 LP03.6
Element: Ta Type 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
TGE-HRS-LIA-METHOD Numeric 2 LP03.6
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Reversing
02 = Non-reversing
TGE-HRS-LIA-TBL Alpha 10 LP03.6
Element: Ta Table
TGE-HRS-ACCR-CO Numeric 4 LP03.6
Element: Company 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.
TGE-HRS-ACCR-UNIT Alpha 15 LP03.6
Element: Acct Unit 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.
TGE-HRS-ACCR-ACCT Numeric 6 LP03.6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
TGE-HRS-ACCR-SUB Numeric 4 LP03.6
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
TGE-HRS-EXP-CO Numeric 4 LP03.6
Element: Company 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.
TGE-HRS-EXP-UNIT Alpha 15 LP03.6
Element: Acct Unit 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.
TGE-HRS-EXP-ACCT Numeric 6 LP03.6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
TGE-HRS-EXP-SUB Numeric 4 LP03.6
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
TGE-HRS-POST-TO-AC Numeric 1 LP03.6
Element: Lp Post To Ac 0 = No
1 = Yes
TGE-HRS-ACTIVITY Alpha 15 LP03.6
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
TGE-HRS-ACCT-CAT Alpha 5 LP03.6
Element: Acct Category 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
TGE-ERN-LIA-TYPE Numeric 2 LP03.6
Element: Ta Type 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
TGE-ERN-LIA-METHOD Numeric 2 LP03.6
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Reversing
02 = Non-reversing
TGE-ERN-LIA-TBL Alpha 10 LP03.6
Element: Ta Table
TGE-ERN-ACCR-CO Numeric 4 LP03.6
Element: Company 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.
TGE-ERN-ACCR-UNIT Alpha 15 LP03.6
Element: Acct Unit 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.
TGE-ERN-ACCR-ACCT Numeric 6 LP03.6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
TGE-ERN-ACCR-SUB Numeric 4 LP03.6
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
TGE-ERN-EXP-CO Numeric 4 LP03.6
Element: Company 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.
TGE-ERN-EXP-UNIT Alpha 15 LP03.6
Element: Acct Unit 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.
TGE-ERN-EXP-ACCT Numeric 6 LP03.6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
TGE-ERN-EXP-SUB Numeric 4 LP03.6
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
TGE-ERN-POST-TO-AC Numeric 1 LP03.6
Element: Lp Post To Ac 0 = No
1 = Yes
TGE-ERN-ACTIVITY Alpha 15 LP03.6
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
TGE-ERN-ACCT-CAT Alpha 5 LP03.6
Element: Acct Category 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
TGE-DATE-STAMP Numeric 8 (yyyymmdd) LP03.6
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TGE-TIME-STAMP Numeric 6 (hhmmss) LP03.6
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TGE-USER-ID Alpha 10 (Lower Case) LP03.6
Element: User
TAGENLEDGR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TGESET1 COMPANY HR00.1 HR01.1
GL-RULE HR11.1 HR511
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 LP180
LP188 LP197
LP198 LP201
LP203 LP31.1
LP80.1 PA100
...
TAGENLEDGR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
And TGE-ERN-ACCR-UNIT != Spaces
And TGE-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
And TGE-ERN-EXP-UNIT != Spaces
And TGE-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
And TGE-HRS-ACCR-UNIT != Spaces
And TGE-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
And TGE-HRS-EXP-UNIT != Spaces
And TGE-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 RELATED
NAME 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
|
