|
|
PBHSTHDR FILE
PB Invoice History Header
UPDATED BY
PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBK-COMPANY Numeric 4 PBIP.1
Company The company number represents an
established company and is entered on
all function codes.
PBK-PROCESS-LEVEL Alpha 5 PBIP.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PBK-INVOICE Alpha 22 PBIP.1
Invoice Number Used to identify the invoice.
PBK-INVOICE-PREFIX Alpha 2 PBIP.1
Invoice Prefix
PBK-INVOICE-NBR Numeric 8 PBIP.1
Invoice Nbr
PBK-CUSTOMER Alpha 9 (Right Justified) PBIP.1
Customer Number This field contains the number that
represents a customer.
PBK-AR-PROCESS-LVL Alpha 5 PBIP.1
Ar Process Lvl
PBK-BILL-TO Numeric 4 PBIP.1
Bill-To Customer
Number
PBK-CONTACT Alpha 20 PBIP.1
Primary Contact This is the name of the main contact.
PBK-POSTING-DATE Numeric 8 (yyyymmdd) PBIP.1
Posting Date The date assigned to the journal entry
for posting.
PBK-INVOICE-DATE Numeric 8 (yyyymmdd) PBIP.1
Invoice Date
PBK-CHECK-DATE Numeric 8 (yyyymmdd) PBIP.1
Payment Date The payment date.
PBK-PER-END-DATE Numeric 8 (yyyymmdd) PBIP.1
Period End Date
PBK-DATE-STAMP Numeric 8 (yyyymmdd) PBIP.1
Date Stamp Contains the server date (month, date,
and year) of the last change to this
record.
PBK-TIME-STAMP Numeric 6 (hhmmss) PBIP.1
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PBK-BILLABLE-AMT Signed 15.2 PBIP.1
Billable Amt
PBK-TAX-TOTAL Signed 15.2 PBIP.1
Tax Total
PBK-CLIENT-CR-AMT Signed 15.2 PBIP.1
Client Cr Amt
PBK-MISC-FEES Signed 15.2 PBIP.1
Misc Fees
PBHSTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBKSET1 COMPANY PBIP.1
PROCESS-LEVEL
INVOICE
PBKSET3 COMPANY PBIP.1
PER-END-DATE
PROCESS-LEVEL
INVOICE
PBKSET4 COMPANY
INVOICE-PREFIX
PROCESS-LEVEL
INVOICE
PBKSET5 COMPANY PBIP.1
PROCESS-LEVEL
INVOICE-DATE
INVOICE
PBKSET6 COMPANY
PROCESS-LEVEL
CHECK-DATE*
INVOICE
PBHSTHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pbhstdtl PBHSTDTL
PBK-COMPANY -> PBH-COMPANY (PBHSET1)
PBK-PROCESS-LEVEL -> PBH-PROCESS-LEVEL
PBK-INVOICE -> PBH-INVOICE
PBH-LINE-NBR
|