|
|
PBHSTDTL FILE
PB Invoice History Detail
The Pay to Bill Invoice History Detail file
UPDATED BY
PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBH-COMPANY Numeric 4 PBIP.1
Company The company number represents an
established company and is entered on
all function codes.
PBH-PROCESS-LEVEL Alpha 5 PBIP.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PBH-INVOICE Alpha 22 PBIP.1
Invoice Number Used to identify the invoice.
PBH-INVOICE-PREFIX Alpha 2 PBIP.1
Invoice Prefix
PBH-INVOICE-NBR Numeric 8 PBIP.1
Invoice Nbr
PBH-LINE-NBR Numeric 6 PBIP.1
Line Number This field contains the line number.
PBH-RECORD-TYPE Alpha 1 PBIP.1
Record Type This field identifies the type of
record defined.
Valid values are:
S=Summary
D=Detail
D = Deduction Info
F = Fee Info
T = Time Record Info
O = AR Offset Transaction
J = Job Code Fee
B = Benefit Billing
C = Client Credit
PBH-EMPLOYEE Numeric 9 PBIP.1
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PBH-DEDUCT-FEE-CD Alpha 4 PBIP.1
Deduct Fee Cd
PBH-CODE-TYPE Alpha 1 PBIP.1
Code Type
PBH-PROGRAM Alpha 5 PBIP.1
Program This field designates the program this
record was created by
PBH-DESCRIPTION Alpha 30 (Lower Case) PBIP.1
Description This field contains the description.
PBH-TAX-CATEGORY Numeric 2 PBIP.1
Tax Category
PBH-TAX-AUTH-TYPE Alpha 2 PBIP.1
Tax Auth Type
PBH-ADJUST-PAY Alpha 1 PBIP.1
Adjust Pay A
C
S
PBH-WC-STATE Alpha 2 PBIP.1
Wc State
PBH-WC-CODE Alpha 10 PBIP.1
Workers Comp Policy Contains the workers' compensation code.
Code
PBH-WC-CLASS Alpha 4 PBIP.1
Workers Comp Contains the workers' compensation
Classification class.
PBH-WC-RATE Signed 13.4 PBIP.1
Wc Rate
PBH-REG-HOURS Signed 7.2 PBIP.1
Reg Hours
PBH-OT-HOURS Signed 7.2 PBIP.1
Ot Hours
PBH-OTH-HOURS Signed 7.2 PBIP.1
Oth Hours
PBH-REG-RATE Signed 13.4 PBIP.1
Reg Rate
PBH-OT-RATE Signed 13.4 PBIP.1
Ot Rate
PBH-OTH-RATE Signed 13.4 PBIP.1
Oth Rate
PBH-REG-PAY Signed 11.2 PBIP.1
Reg Pay
PBH-OT-PAY Signed 11.2 PBIP.1
Ot Pay
PBH-OTH-PAY Signed 11.2 PBIP.1
Oth Pay
PBH-TIPS-PAY Signed 11.2 PBIP.1
Tips Pay
PBH-GROSS-PAY Signed 11.2 PBIP.1
Gross Pay
PBH-EMPLOYEE-CAFE Signed 11.2 PBIP.1
Employee Cafe
PBH-CREDITS Signed 11.2 PBIP.1
Credits
PBH-BILLABLE-AMT Signed 15.2 PBIP.1
Billable Amt
PBH-BILLABLE-UNIT Signed 15.2 PBIP.1
Billable Unit
PBH-TAXABLE-AMT Signed 15.2 PBIP.1
Taxable Amount The taxable amount.
PBH-CHECK-ID Numeric 12 PBIP.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PBH-DEPARTMENT Alpha 5 PBIP.1
Department Contains the department.
PBH-JOB-CODE Alpha 9 PBIP.1
Job Code Contains a user-defined code that
represents a type of job.
PBH-POSITION Alpha 12 PBIP.1
Position Contains the user-defined code that
represents a position in the company.
PBH-PCD-SEQ-NBR Numeric 4 PBIP.1
Pcd Seq Nbr
PBH-PRD-REC-TYPE Alpha 1 PBIP.1
Prd Rec Type
PBH-PLAN-TYPE Alpha 2 PBIP.1
Type
PBH-PLAN-CODE Alpha 4 PBIP.1
Plan Contains the user-defined code that
represents a benefit plan.
PBH-CALC-TYPE Alpha 1 PBIP.1
Calculation Type This field contains the calculation
type.
PBH-PAY-SUM-GRP Alpha 3 PBIP.1
Payment Summary
Group
PBH-TR-DATE Numeric 8 (yyyymmdd) PBIP.1
Time Record Date
PBH-TIME-SEQ Numeric 12 PBIP.1
Sequence Number
PBH-CLIENT-JOBID Alpha 20 PBIP.1
Client Jobid
PBH-EDM-SEQ-NBR Numeric 4 PBIP.1
Emp Deduction
Sequence Number
PBH-GLT-OBJ-ID Numeric 12
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
PBHSTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBHSET1 COMPANY PBIP.1
PROCESS-LEVEL
INVOICE
LINE-NBR
PBHSET2 COMPANY
EMPLOYEE
CHECK-ID
PROCESS-LEVEL
INVOICE
LINE-NBR
PBHSET3 COMPANY
PROCESS-LEVEL
INVOICE
EMPLOYEE
LINE-NBR
PBHSET4 COMPANY Subset
PROCESS-LEVEL Where WC-CODE != Spaces
WC-CODE
WC-STATE
INVOICE
EMPLOYEE
WC-CLASS
LINE-NBR
PBHSTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Paymastr PAYMASTR Required
PBH-COMPANY -> PYM-COMPANY (PYMSET1)
PBH-EMPLOYEE -> PYM-EMPLOYEE
PBH-CHECK-ID -> PYM-CHECK-ID
Pbhsthdr PBHSTHDR Required
PBH-COMPANY -> PBK-COMPANY
PBH-PROCESS-LEVEL -> PBK-PROCESS-LEVEL
PBH-INVOICE -> PBK-INVOICE
|