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     BR11.1    PHI3.1    WH20.7

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

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      The period end date of the specified
                     year.

PBK-DATE-STAMP       Numeric 8  (yyyymmdd)                       PBIP.1
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)                         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

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                                                PBIP.1
          PROCESS-LEVEL
          INVOICE

PBKSET3   COMPANY                                                PBIP.1
          PER-END-DATE
          PROCESS-LEVEL
          INVOICE

PBKSET4   COMPANY                                                AR42.2  AR42.7
          INVOICE-PREFIX                                         AR560   BR11.1
          PROCESS-LEVEL                                          PHI3.1  WH20.7
          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