Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             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