 |
Lawson Insight Technical Documentation |
|
PRGARNHIST FILE
Contains the history for a particular garnishment (case number and file
number). It is used to link a garnishment to AP payment information. A new
record is created every time payroll is run.
Updated by PR199 (Payroll Close) and used for reporting.
REFERENCED BY
PR139 PR141 PR277 PR226 PR247
UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR198
PR45.1 PR80.1 PR82.1 PR85.1 PR89.1 PR36.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GRH-COMPANY Numeric 4 BN66.1 PR140
Company Contains the company number. PR189 PR195
PR80.1 PR82.1
PR89.1
GRH-EMPLOYEE Numeric 9 BN66.1 PR140
Employee Contains the employee number. PR189 PR195
PR80.1 PR82.1
PR89.1
GRH-CHECK-ID Numeric 12 BN66.1 PR140
Internal Check ID Contains the payment identification PR189 PR195
Number number (unique payment identifier used PR80.1 PR82.1
in tracking payment information). PR85.1 PR89.1
GRH-GARN-OBJ-ID Numeric 12 BN66.1 PR140
Garn Obj Id Assigned when an employee garnishment PR189 PR195
table (PREMPGARN) is added and PR80.1 PR82.1
deductions are created. This ID links PR89.1
the employee deductions to this
garnishment (case number/file number).
If the same deduction is created for
this employee, this ID along with the
sequence number keeps the record unique.
GRH-AP-COMPANY Numeric 4 BN66.1 PR140
Ap Company Contains the AP company. PR189 PR195
PR198 PR80.1
PR82.1 PR89.1
GRH-VENDOR Alpha 9 (Right Justified) BN66.1 PR140
Vendor ID The vendor's identification code. PR189 PR195
PR198 PR80.1
PR82.1 PR89.1
GRH-INVOICE Alpha 22 BN66.1 PR140
Invoice Number Used to identify the invoice. PR189 PR195
PR198 PR80.1
PR82.1 PR89.1
GRH-STATUS Numeric 1 BN66.1 PR140
Status Indicates the payment status. PR189 PR195
PR197 PR80.1
Records are created with a status of PR82.1 PR85.1
zero and are updated to a status of "9" PR89.1
by PR199 (Payroll Close).
0 = Created
9 = Closed
GRH-DISP-INCOME Signed 9.2 BN66.1 PR140
Disp Income Contains the disposable income PR189 PR195
calculated in PR140 (Earnings and PR80.1 PR82.1
Deductions Calculations). PR85.1 PR89.1
GRH-WAGES-EXEMPT Signed 9.2 BN66.1 PR140
Wages Exempt Contains the exempt wages calculated in PR189 PR195
PR140 (Earnings and Deductions PR80.1 PR82.1
Calculations). PR85.1 PR89.1
GRH-MSG-NBR Numeric 3 Occurs 10 Times BN66.1 PR140
Msg Nbr Contains a message number assigned in PR189 PR195
PR140 (Earnings and Deductions PR80.1 PR82.1
Calculations) for garnishment history. PR85.1 PR89.1
Messages are stored in Message
Maintenance (msgmnt) for category PRGAR.
PRGARNPD and PR140 access these
messages.
GRH-CREATE-DATE Numeric 8 (yyyymmdd) BN66.1 PR140
Creation Date Contains the date when PR140 (Earnings PR189 PR195
and Deductions Calculations) are run and PR80.1 PR82.1
records are created. PR89.1
GRH-CREATE-TIME Numeric 6 (hhmmss) BN66.1 PR140
Creation Time Contains the time when PR140 (Earnings PR189 PR195
and Deductions Calculations) is run and PR80.1 PR82.1
records are created. PR89.1
GRH-COURT-FEE Signed 11.2 BN66.1 PR140
Court Fee PR189 PR195
PR80.1 PR89.1
GRH-COURT-ARR-FEE Signed 11.2 BN66.1 PR140
Court Arr Fee PR189 PR195
PR80.1 PR89.1
GRH-CURRENCY-CODE Alpha 5 BN66.1 PR140
Currency Code This field contains the company base PR189 PR195
currency code established in Company PR80.1 PR82.1
(GL10.1 ). PR89.1
GRH-CURR-ND Numeric 1 BN66.1 PR140
Currency Number of Represents the number of decimals PR189 PR195
Decimals defined for the currency of the object. PR80.1 PR82.1
PR89.1
PRGARNHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRHSET1 COMPANY BN66.1 PR139
EMPLOYEE PR140 PR141
CHECK-ID PR189 PR195
GARN-OBJ-ID PR197 PR198
PR36.1 PR45.1
PR80.1 PR82.1
PR85.1 PR89.1
GRHSET2 COMPANY Subset PR277
CREATE-DATE Where STATUS = 9
EMPLOYEE
CHECK-ID
GARN-OBJ-ID
GRHSET3 COMPANY BN66.1 PR139
EMPLOYEE PR140 PR189
GARN-OBJ-ID PR195 PR226
CREATE-DATE PR247 PR277
CHECK-ID PR80.1 PR89.1
PRGARNHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
GRH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
GRH-COMPANY -> EMP-COMPANY
GRH-EMPLOYEE -> EMP-EMPLOYEE
Invoice APINVOICE Not Required
Valid When (GRH-INVOICE != Spaces )
GRH-AP-COMPANY -> API-COMPANY
GRH-VENDOR -> API-VENDOR
GRH-INVOICE -> API-INVOICE
Zeroes -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Paymastr PAYMASTR Required
GRH-COMPANY -> PYM-COMPANY
GRH-EMPLOYEE -> PYM-EMPLOYEE
GRH-CHECK-ID -> PYM-CHECK-ID
|