C6EXEMPT – No description in the Lawson data dictionary

System: C6 (C6)
Prefix: C6X
Primary key: COMPANY, EMPLOYEE, PAYROLL-YEAR, INV-CODE
Fields: 11
Updated by: 9 programs
Referenced by: 0 programs

C6EXEMPT is a Lawson C6 table (prefix C6X); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PAYROLL-YEAR, INV-CODE (C6XSET1). It is updated by BN66.1, PR140, PR189, PR195, PR197, PR80.1, PR80.4, PR89.1 and 1 more. The table has 11 fields, 1 index and 0 documented relations.

About C6EXEMPT

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the C6X- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`C6X-COMPANY` PK COMPANY	Numeric 4	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-PAYROLL-YEAR` PK PAYROLL_YEAR	Numeric 4	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-INV-CODE` PK INV_CODE	Alpha 10	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-STATUS` STATUS	Numeric 1	— `0` Created `9` Closed	BN66.1, PR140, PR189, PR195, PR197, PR80.1, PR80.4, PR89.1 +1 more
#`C6X-PROJECTED-AMT` PROJECTED_AMT	Signed 13.2 Occurs 12 Times ×12	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-EXEMPTED-AMT` EXEMPTED_AMT	Signed 13.2 Occurs 12 Times ×12	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-YTD-EXEMPT-AMT` YTD_EXEMPT_AMT	Signed 13.2	—	PR197
#`C6X-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#`C6X-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`C6XSET1`	`COMPANY` `EMPLOYEE` `PAYROLL-YEAR` `INV-CODE`	Primary		BN66.1, PR140, PR189, PR195, PR197, PR80.1, PR80.4, PR89.1 +1 more

Programs

Updated by (9)

BN66.1 Estimated Pay Calculation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR80.1 Manual Check
PR80.4 Manual Payment
PR89.1 Payment Modeling
PRAT.1 Alltax connection test

C6EXEMPT – No description in the Lawson data dictionary

About C6EXEMPT

Fields (11) Copy as SQL

Indexes (1)

Programs

Updated by (9)

Fields (11)