 |
Lawson Insight Technical Documentation |
|
PBBLDEDUCT FILE
UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR80.1
PR85.1 PR89.1 PR36.1 PR45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLD-COMPANY Numeric 4 BN66.1 PR140
Company The company number represents an PR189 PR195
established company and is entered on PR197 PR80.1
all function codes. PR85.1 PR89.1
PLD-EMPLOYEE Numeric 9 BN66.1 PR140
Employee Contains the employee number. Each PR189 PR195
person employed by the company is PR197 PR80.1
assigned a unique number. The system PR85.1 PR89.1
uses the employee number to correlate
all of the information related to that
person.
PLD-CHECK-ID Numeric 12 BN66.1 PR140
Internal Check ID Contains the payment identification PR189 PR195
Number number (unique payment identifier used PR197 PR80.1
in tracking payment information). PR85.1 PR89.1
PLD-DED-CODE Alpha 4 BN66.1 PR140
Deduction Code PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-EDM-SEQ-NBR Numeric 4 BN66.1 PR140
Emp Deduction PR189 PR195
Sequence Number PR197 PR80.1
PR85.1 PR89.1
PLD-PROCESS-LEVEL Alpha 5 BN66.1 PR140
Process Level This field contains the process level, PR189 PR195
which is the reporting hierarchy below PR197 PR80.1
company. PR85.1 PR89.1
PLD-WORK-STATE Alpha 2 BN66.1 PR140
Work State Identifies the state in which the PR189 PR195
workers' compensation plan is affective. PR197 PR80.1
PR85.1 PR89.1
PLD-WC-STATE Alpha 2 BN66.1 PR140
Wc State PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-WC-CODE Alpha 10 BN66.1 PR140
Workers Comp Policy Contains the workers' compensation code. PR189 PR195
Code PR197 PR80.1
PR85.1 PR89.1
PLD-WC-CLASS Alpha 4 BN66.1 PR140
Workers Comp Contains the workers' compensation PR189 PR195
Classification class. PR197 PR80.1
PR85.1 PR89.1
PLD-WC-RATE Signed 13.4 BN66.1 PR140
Wc Rate PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-PAYROLL-YEAR Numeric 4 BN66.1 PR140
Current Payroll Year Contains the payroll year in which the PR189 PR195
allocation was taken. PR197 PR80.1
PR85.1 PR89.1
PLD-QUARTER Numeric 1 BN66.1 PR140
Quarter Contains the fiscal quarter for the PR189 PR195
data stored in this record. PR197 PR80.1
PR85.1 PR89.1
PLD-TAX-CATEGORY Numeric 2 BN66.1 PR140
Tax Category PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-TAX-AUTH-TYPE Alpha 2 BN66.1 PR140
Tax Auth Type PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-ADJUST-PAY Alpha 1 BN66.1 PR140
Adjust Pay PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-DED-AMT Signed 13.2 BN66.1 PR140
Deduction Amount PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-TAX-WAGES Signed 13.2 BN66.1 PR140
Taxable Wages PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-WAGE-AMOUNT Signed 13.2 BN66.1 PR140
Wage Amount Contains the sum of all wage amounts PR189 PR195
from the time records for pay codes tied PR197 PR80.1
to this pay summary group. PR85.1 PR89.1
PLD-EXCESS Signed 13.2 BN66.1 PR140
Excess PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-BILLABLE-AMT Signed 15.2 BN66.1 PR140
Billable Amt PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-GARN-OBJ-ID Numeric 12 BN66.1 PR140
Garn Obj Id PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-REPORT-ENTITY Alpha 5 BN66.1 PR140
Report Entity PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-BUS-NBR-GRP Alpha 4 BN66.1 PR140
Bus Nbr Grp PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-QC-ENT-NBR-GRP Alpha 4 BN66.1 PR140
Qc Ent Nbr Grp PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PLD-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PLD-BN-DED-CODE Alpha 1
Bn Ded Code
PBBLDEDUCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLDSET1 COMPANY BN66.1 PR140
EMPLOYEE PR189 PR195
CHECK-ID PR197 PR36.1
DED-CODE PR45.1 PR80.1
EDM-SEQ-NBR PR85.1 PR89.1
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PLDSET3 COMPANY
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
CHECK-ID
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PBBLDEDUCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Paydeduct PAYDEDUCTN Required
PLD-COMPANY -> PYD-COMPANY (PYDSET1)
PLD-EMPLOYEE -> PYD-EMPLOYEE
PLD-CHECK-ID -> PYD-CHECK-ID
PLD-DED-CODE -> PYD-DED-CODE
PLD-EDM-SEQ-NBR -> PYD-EDM-SEQ-NBR
Spaces -> PYD-REPORT-ENTITY
Spaces -> PYD-BUS-NBR-GRP
Spaces -> PYD-QC-ENT-NBR-GRP
PLD-PROCESS-LEVEL -> PYD-PROCESS-LEVEL
PLD-WORK-STATE -> PYD-WORK-STATE
|