Lawson Insight Technical Documentation |
|
PBBLDEDUCT
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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Wc Rate PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-PAYROLL-YEAR Numeric 4 BN66.1 PR140
Element: Current PayrolContains 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
Element: 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
Element: Tax Category PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-TAX-AUTH-TYPE Alpha 2 BN66.1 PR140
Element: Tax Auth Type PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-ADJUST-PAY Alpha 1 BN66.1 PR140
Element: Adjust Pay PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-DED-AMT Signed 13.2 BN66.1 PR140
Element: Deduction Amount PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-TAX-WAGES Signed 13.2 BN66.1 PR140
Element: Taxable Wages PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-WAGE-AMOUNT Signed 13.2 BN66.1 PR140
Element: 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
Element: Excess PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-BILLABLE-AMT Signed 15.2 BN66.1 PR140
Element: Adj Amt PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-GARN-OBJ-ID Numeric 12 BN66.1 PR140
Element: Garn Obj Id PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-REPORT-ENTITY Alpha 5 BN66.1 PR140
Element: Process Level PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-BUS-NBR-GRP Alpha 4 BN66.1 PR140
Element: Bus Nbr Grp PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-QC-ENT-NBR-GRP Alpha 4 BN66.1 PR140
Element: Qc Ent Nbr Grp PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
PLD-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PLD-CURR-ND Numeric 1
Account Currency
Code
PLD-BN-DED-CODE Alpha 1
Element: 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
|