Lawson Insight Technical Documentation |
|
PRGARNHIST
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 UK141 PR277 UK277 PR226
PR247
UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR198
PR300 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
Element: Company Contains the company number. PR189 PR195
PR80.1 PR82.1
PR89.1
GRH-EMPLOYEE Numeric 9 BN66.1 PR140
Element: 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
Element: 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
Element: Ap Company Contains the AP company. PR189 PR195
PR198 PR80.1
PR82.1 PR89.1
GRH-VENDOR Alpha 9 (Right Justified) BN66.1 PR140
Element: Vendor ID The vendor's identification code. PR189 PR195
PR198 PR80.1
PR82.1 PR89.1
GRH-INVOICE Alpha 22 BN66.1 PR140
Element: Invoice NumberUsed to identify the invoice. PR189 PR195
PR198 PR80.1
PR82.1 PR89.1
GRH-STATUS Numeric 1 BN66.1 PR140
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Sys 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
Element: Court Fee PR189 PR195
PR80.1 PR89.1
GRH-COURT-ARR-FEE Signed 11.2 BN66.1 PR140
Element: Court Arr Fee PR189 PR195
PR80.1 PR89.1
GRH-CURRENCY-CODE Alpha 5 BN66.1 PR140
Element: 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
Account Currency PR189 PR195
Code PR80.1 PR82.1
PR89.1
GRH-REMIT-TO-CODE Alpha 4 PR198
Purchase From
Location Code
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
PR300 PR36.1
PR45.1 PR80.1
PR82.1 PR85.1
PR89.1 UK141
GRHSET2 COMPANY Subset PR277 UK277
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
UK277
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
|