Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBHSTHDR


                             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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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

PBK-INVOICE            Alpha 22                                  PBIP.1
Element: Invoice NumberUsed to identify the invoice.

PBK-INVOICE-PREFIX     Alpha 2                                   PBIP.1
Element: Invoice Prefix

PBK-INVOICE-NBR        Numeric 8                                 PBIP.1
Element: Invoice Nbr

PBK-CUSTOMER           Alpha 9  (Right Justified)                PBIP.1
Element: Customer NumbeThis field contains the number that
                       represents a customer.

PBK-AR-PROCESS-LVL     Alpha 5                                   PBIP.1
Element: Ar Process Lvl

PBK-BILL-TO            Numeric 4                                 PBIP.1
Element: Ship-to Code

PBK-CONTACT            Alpha 20                                  PBIP.1
Element: Primary ContacThis is the name of the main contact.

PBK-POSTING-DATE       Numeric 8  (yyyymmdd)                     PBIP.1
Element: Date

PBK-INVOICE-DATE       Numeric 8  (yyyymmdd)                     PBIP.1
Element: Date

PBK-CHECK-DATE         Numeric 8  (yyyymmdd)                     PBIP.1
Element: Date

PBK-PER-END-DATE       Numeric 8  (yyyymmdd)                     PBIP.1
Element: Date

PBK-DATE-STAMP         Numeric 8  (yyyymmdd)                     PBIP.1
Element: 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
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PBK-BILLABLE-AMT       Signed 15.2                               PBIP.1
Element: Adj Amt

PBK-TAX-TOTAL          Signed 15.2                               PBIP.1
Element: Detail Total

PBK-CLIENT-CR-AMT      Signed 15.2                               PBIP.1
Element: Client Cr Amt

PBK-MISC-FEES          Signed 15.2                               PBIP.1
Element: Misc Fees

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

PBK-CURR-ND            Numeric 1
Account Currency
Code

                         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