C6PRDDTL – No description in the Lawson data dictionary
- System
- C6 (C6)
- Prefix
C6D- Primary key
COMPANY,PAYROLL-YEAR,PAY-PRD-DEF,START-DATE- Fields
- 10
- Updated by
- 6 programs
- Referenced by
- 44 programs
C6PRDDTL is a Lawson C6 table (prefix C6D); no description in the lawson data dictionary. It is indexed by COMPANY, PAYROLL-YEAR, PAY-PRD-DEF, START-DATE (C6DSET1); alternate indexes: C6DSET2 and C6DSET3. It is updated by PR140, PR197, PR560, PR80.1, PR80.4 and PR999 and referenced by BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 and 36 more. The table has 10 fields, 3 indexes and 0 documented relations.
About C6PRDDTL
No description in the Lawson data dictionary.
Fields (10)
Column = COBOL field name without the C6D- 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 |
|---|---|---|---|
#C6D-COMPANY PKCOMPANY | Numeric 4 | — | — |
#C6D-PAYROLL-YEAR PKPAYROLL_YEAR | Numeric 4 | — | PR999 |
#C6D-PAY-PRD-DEF PKPAY_PRD_DEF | Alpha 4 | — | — |
#C6D-PAY-FREQUENCYPAY_FREQUENCY | Numeric 1 | — | — |
#C6D-START-DATE PKSTART_DATE | Numeric 8 (yyyymmdd) | — | PR999 |
#C6D-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | — | PR999 |
#C6D-NBR-OF-DAYSNBR_OF_DAYS | Numeric 2 | — | PR999 |
#C6D-NBR-OF-HOURSNBR_OF_HOURS | Numeric 5 | — | — |
#C6D-PERIOD-STATUSPERIOD_STATUS | Alpha 1 | —
| PR999 |
#C6D-REMAIN-CYCLESREMAIN_CYCLES | Numeric 2 | — | — |
Indexes (3)
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 |
|---|---|---|---|---|
C6DSET1 |
| Primary | BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source) | |
C6DSET2 |
| Subset | Where PERIOD-STATUS = "0" | BN66.1, PR139, PR140, PR141, PR189, PR195, PR80.1, PR80.4 +2 more |
C6DSET3 |
| BN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source) |
Programs
Updated by (6)
- PR140 Earnings and Deductions Calculation
- PR197 Payroll Close
- PR560 Payroll History Load CSV
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR999 Payroll Year End Close
Referenced by (44)
- BN150 Life Insurance Reportable Income
- BN66.1 Estimated Pay Calculation
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- LP130 Absence Plan Payout
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR138 Percent of Earnings Calculation
- PR139 Arrears Automation
- PR141 Payroll Register
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR582 Mass Adjustment Load
- PR82.1 Adjustment
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update