TAGENLEDGR – LP General Ledger Rule

System: Absence Management (LP)
Prefix: TGE
Primary key: COMPANY, GL-RULE
Fields: 35
Updated by: 11 programs
Referenced by: 21 programs

TAGENLEDGR is the LP General Ledger Rule table in Lawson Absence Management (prefix TGE). It is indexed by COMPANY, GL-RULE (TGESET1). It is related 1:1 to PRSYSTEM, GLMASTER, ACACCTCAT and ACACTIVITY and 1:M to TATABLE. It is updated by HR00.1, HR01.1, LP03.6, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6 and 3 more and referenced by HR11.1, HR511, LP02.1, LP100, LP101, LP102, LP103, LP131 and 13 more. The table has 35 fields, 1 index and 11 documented relations.

About 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.

Fields (35)

Column = COBOL field name without the TGE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TGE-COMPANY` PK COMPANY	Numeric 4	—	LP03.6
`TGE-GL-RULE` PK GL_RULE	Alpha 10	—	LP03.6
`TGE-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP03.6
`TGE-HRS-LIA-TYPE` HRS_LIA_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` HRS_LIA_METHOD	Numeric 2	Contains the units of measure for the summarized totals. `01` Reversing `02` Non-reversing	LP03.6
`TGE-HRS-LIA-TBL` HRS_LIA_TBL	Alpha 10	—	LP03.6
`TGE-HRS-ACCR-CO` HRS_ACCR_CO	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` HRS_ACCR_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` HRS_ACCR_ACCT	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` HRS_ACCR_SUB	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` HRS_EXP_CO	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` HRS_EXP_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` HRS_EXP_ACCT	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` HRS_EXP_SUB	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` HRS_POST_TO_AC	Numeric 1	— `0` No `1` Yes	LP03.6
`TGE-HRS-ACTIVITY` HRS_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` HRS_ACCT_CAT	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` ERN_LIA_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` ERN_LIA_METHOD	Numeric 2	Contains the units of measure for the summarized totals. `01` Reversing `02` Non-reversing	LP03.6
`TGE-ERN-LIA-TBL` ERN_LIA_TBL	Alpha 10	—	LP03.6
`TGE-ERN-ACCR-CO` ERN_ACCR_CO	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` ERN_ACCR_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` ERN_ACCR_ACCT	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` ERN_ACCR_SUB	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` ERN_EXP_CO	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` ERN_EXP_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` ERN_EXP_ACCT	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` ERN_EXP_SUB	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` ERN_POST_TO_AC	Numeric 1	— `0` No `1` Yes	LP03.6
`TGE-ERN-ACTIVITY` ERN_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` ERN_ACCT_CAT	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` 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` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP03.6
`TGE-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP03.6
`TGE-PAY-RATE-CHG` 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

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TGESET1`	`COMPANY`, `GL-RULE`	Primary		HR00.1, HR01.1, HR11.1, HR511, LT101, LT111, LP02.1, LP03.1 +22 more (list truncated in source)

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (11)

HR00.1 Company
HR01.1 Process Level
LP03.6 General Ledger Rule
LP04.2 Cycle Based Accrual Table
LP04.3 Cycle Based Allotment Table
LP04.4 Cycle Based Limit Table
LP04.5 Cycle Based GL Liability Table
LP04.6 Hours Based Accrual Table
LP04.7 Hours Based Allotment Table
LP04.8 Hours Based Limit Table
LP04.9 Hours Based GL Liability Table

Referenced by (21)

HR11.1 Employee
HR511 Employee Conversion
LP02.1 Plan Structure
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP131 Zero Balance Update
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP188 Length of Service Hours Update
LP197 Absence Plan Close
LP198 General Ledger Liability Update
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LP31.1 Employee Absence Plan Master
LP80.1 Employee Absence Plan Transfer
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA52.4 Hire an Applicant