Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PBHSTHDR FILE

REFERENCED BY

AR42.2    AR42.7    AR560     BL00.1    BL01.1    BL121
BL123     BL200     BL201     BR11.1    PHI3.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PBK-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.

PBK-PROCESS-LEVEL    Alpha 5
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

PBK-INVOICE          Alpha 22
Invoice Number       Used to identify the invoice.

PBK-INVOICE-PREFIX   Alpha 2
Invoice Prefix

PBK-INVOICE-NBR      Numeric 8
Invoice Nbr

PBK-CUSTOMER         Alpha 9  (Right Justified)
Customer Number      This field contains the number that
                     represents a customer.

PBK-AR-PROCESS-LVL   Alpha 5
Ar Process Lvl

PBK-BILL-TO          Numeric 4
Bill To

PBK-CONTACT          Alpha 20
Primary Contact      This is the name of the main contact.

PBK-POSTING-DATE     Numeric 8  (yyyymmdd)
Posting Date         The date assigned to the journal entry
                     for posting.

PBK-INVOICE-DATE     Numeric 8  (yyyymmdd)
Invoice Date

PBK-CHECK-DATE       Numeric 8  (yyyymmdd)
Payment Date         The payment date.

PBK-PER-END-DATE     Numeric 8  (yyyymmdd)
Period End Date      The period end date of the specified
                     year.

PBK-DATE-STAMP       Numeric 8  (yyyymmdd)
Date Stamp           This field contains the server date
                     (month, date, and year) of the last
                     change to this record.

PBK-TIME-STAMP       Numeric 6  (hhmmss)
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

PBK-BILLABLE-AMT     Signed 15.2
Billable Amt

PBK-TAX-TOTAL        Signed 15.2
Tax Total

PBK-CLIENT-CR-AMT    Signed 15.2
Client Cr Amt

PBK-MISC-FEES        Signed 15.2
Misc Fees

PBK-CURRENCY-CODE    Alpha 5
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

PBK-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         PBHSTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBKSET1   COMPANY
          PROCESS-LEVEL
          INVOICE

PBKSET3   COMPANY
          PER-END-DATE
          PROCESS-LEVEL
          INVOICE

PBKSET4   COMPANY                                                AR42.2  AR42.7
          INVOICE-PREFIX                                         AR560   BL00.1
          PROCESS-LEVEL                                          BL01.1  BL121
          INVOICE                                                BL123   BL200
                                                                 BL201   BR11.1
                                                                 PHI3.1

PBKSET5   COMPANY
          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