Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPMHSTHDR


                            ACPMHSTHDR FILE

REFERENCED BY

BR157     BR252     BR52.1    BR56.1    BR55.1

UPDATED BY

BR123     BRIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMH-OBJ-ID             Numeric 12                                BRIP.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

PMH-COMPANY            Numeric 4                                 BRIP.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PMH-CUSTOMER           Alpha 9  (Right Justified)                BRIP.1
Element: Customer      This field contains the number that
                       represents a customer.

PMH-INVOICE            Alpha 22                                  BRIP.1
Element: Invoice       Used to identify the invoice.

PMH-INVOICE-PREFIX     Alpha 2                                   BRIP.1
Element: Invoice Prefix

PMH-INVOICE-NBR        Numeric 8                                 BRIP.1
Element: Invoice Nbr

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

PMH-DUE-DATE           Numeric 8  (yyyymmdd)                     BRIP.1
Element: Date          This field displays the system date
                       when this was created.

PMH-BILL-TO            Numeric 4                                 BRIP.1
Element: Bill To       This field contains the mailing address
                       for the invoice.  Bill to addresses are
                       maintained in the Accounts Receviable
                       Bill To form AR09.4.

PMH-CONTRACT           Alpha 15                                  BRIP.1
Element: Contract      Activity Management contract.

PMH-CONTACT-CODE       Alpha 5                                   BRIP.1
Element: Contact Code

PMH-AR-DETAIL          Alpha 1                                   BRIP.1
Element: Ar Detail     S = Summary
                       D = Detail
                       A = Activity

PMH-INVOICE-TYPE       Alpha 1                                   BRIP.1
Element: Invoice Type  THis field will be filled in from the
                       Invoice based on PO number.  This is a
                       carrier for the field.  The PORECEIVE
                       file will have to be updated with this
                       field.
                       R = Retainer
                       I = Invoice
                       B = Invoice Cancel
                       C = Auto generated retainer credit
                       T = Tax
                       P = Product
                       M = Maintenance

PMH-INVOICE-DATE       Numeric 8  (yyyymmdd)                     BRIP.1
Element: Date          This field displays the system date
                       when this was created.

PMH-POSTING-DATE       Numeric 8  (yyyymmdd)                     BRIP.1
Element: Date          This field displays the system date
                       when this was created.

PMH-REFERENCE          Alpha 10  (Lower Case)                    BRIP.1
Element: Reference     The reference number associated with
                       the transaction.

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

PMH-CURR-ND            Numeric 1                                 BRIP.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


PMH-INVOICE-AMT        Signed 18.2                               BRIP.1
Element: Intl Amt

PMH-UNITS-AMOUNT       Signed 18.2                               BRIP.1
Element: Intl Amt

PMH-CUST-PO-NBR        Alpha 22                                  BRIP.1
Element: Cust Po Nbr

PMH-INVC-OPTIONS       Alpha 1                                   BRIP.1
Element: Invc Options  A = Acct Category
                       B = Acct Category Class
                       C = Attribute
                       D = Resource

PMH-INVC-FORMAT        Alpha 1                                   BRIP.1
Element: Invc Format   S = Standard
                       C = Custom
                       F = Fax with Standard
                       E = EDI with Standard

PMH-RETAIN-ID          Numeric 6                                 BRIP.1
Element: Retain Id

PMH-RETAIN-DESC        Alpha 30                                  BRIP.1
Element: Retain Desc

PMH-CUM-FLAG           Alpha 1                                   BRIP.1
Element: Cum Flag      Y = Yes
                       N = No

PMH-INVC-SUMM-OPT      Alpha 1                                   BRIP.1
Element: Invc Summ Opt D = Detail
                       S = Summary

PMH-INV-OPTION-2       Alpha 1                                   BRIP.1
Element: Invc Option 2 A = Acct Category
                       B = Account Category Class
                       C = Attribute
                       D = Resource

PMH-AC-CUSTOMER-ID     Alpha 5                                   BRIP.1
Element: Ac Customer Id

PMH-WBS-INVC-NBR       Numeric 8                                 BRIP.1
Element: Wbs Invc Nbr

PMH-CUST-NAME          Alpha 30  (Lower Case)
Element: Customer Name

PMH-LOCK-BOX           Alpha 2                                   BRIP.1
Element: Lock Box

PMH-XREF-NBR           Alpha 22                                  BRIP.1
Element: Xref Nbr

PMH-BILL-WBS-CODE      Alpha 3                                   BRIP.1
Element: Bill Wbs Code

PMH-EXCEED-OPTION      Alpha 1                                   BRIP.1
Element: Exceed Option I = Include
                       E = Exclude

PMH-REALIZATION-FL     Alpha 1                                   BRIP.1
Element: Realization FlY = Yes
                       N = No

PMH-WBS-XREF-NBR       Alpha 22
Element: Wbs Xref Nbr

PMH-STATUS             Numeric 1                                 BR123   BRIP.1
Element: Status        This field displays the status of the
                       transaction.
                       0 = Unreleased
                       1 = Released
                       2 = Pending Approval
                       3 = Processed
                       4 = Cancelled
                       5 = Invoice Delete

PMH-LAST-LINE-NBR      Numeric 6                                 BRIP.1
Element: Line Nbr      This field contains the line number.

PMH-USER-NAME          Alpha 10  (Lower Case)                    BRIP.1
Element: User

PMH-BILL-TO-GRP        Numeric 4                                 BRIP.1
Element: Bill To Grp   Used to identify a group of AR bill-to
                       addresses used for customer invoicing in
                       the BR system.

PMH-CNT-WBS-CODE       Alpha 3                                   BRIP.1
Element: Cnt Wbs Code

PMH-FEE-EXCEED-OPT     Alpha 1                                   BRIP.1
Element: Fee Exceed OptI = Include
                       E = Exclude

PMH-PRE-ADJUST-AMT     Signed 18.2                               BRIP.1
Element: Intl Amt

PMH-PRE-HOLD-AMT       Signed 18.2                               BRIP.1
Element: Intl Amt

PMH-PRE-BILL-HIST      Signed 18.2                               BRIP.1
Element: Intl Amt

PMH-FINAL-INVC-FL      Alpha 1                                   BRIP.1
Element: Final Invc Fl Y = Yes
                       N = No

PMH-PRE-BIA            Signed 18.2
Element: Intl Amt

PMH-PRE-XFER           Signed 18.2
Element: Intl Amt

PMH-TAX-PRINT          Alpha 1                                   BRIP.1
Element: Tax Print     M = Multiple sum by code
                       S = Single Tax Line

PMH-HIST-FLAG          Alpha 1
Element: Hist Flag

PMH-JURIS-CODE         Alpha 3                                   BRIP.1
Element: Juris Code

PMH-TAX-FLAG           Alpha 1
Element: Tax Flag

PMH-INVC-OPTION-3      Alpha 1                                   BRIP.1
Element: Invc Options  A = Acct Category
                       B = Acct Category Class
                       C = Attribute
                       D = Resource

PMH-INVC-OPTION-4      Alpha 1                                   BRIP.1
Element: Invc Options  A = Acct Category
                       B = Acct Category Class
                       C = Attribute
                       D = Resource

PMH-INVC-OPTION-5      Alpha 1                                   BRIP.1
Element: Invc Options  A = Acct Category
                       B = Acct Category Class
                       C = Attribute
                       D = Resource

PMH-TAX-CALC-FLAG      Alpha 1                                   BRIP.1
Element: Tax Calc Flag This flag determines whether tax will be
                       calculated at a detail level or summary
                       level. If calculated at a detail level,
                       tax amounts will be calculated
                       separately for each invoice line. If
                       calculated at a summary level, taxable
                       amount for a tax code for the whole
                       invoice will be determined, and tax will
                       be calculated on that summarized taxable
                       amount.
                       1 = Detail
                       2 = Summary

PMH-SERVICE-LOC        Numeric 4                                 BRIP.1
Element: Service Loc   A user defined code identifying a
                       customer's service location.

                         ACPMHSTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMHSET1   OBJ-ID                                                 BR123   BR157
                                                                 BR252   BR52.1
                                                                 BR56.1  BRIP.1

PMHSET2   CONTRACT      KeyChange                                BR55.1
          COMPANY
          CUSTOMER
          AC-CUSTOMER-ID
          INVOICE
          OBJ-ID

PMHSET3   INVOICE-PREFIXKeyChange
          INVOICE-NBR
          OBJ-ID

                         ACPMHSTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Not Required

                            PMH-CONTRACT         -> CNT-CONTRACT  (CNTSET1)

Acsrvcloc      ACSRVCLOC    Not Required

                            PMH-COMPANY          -> ASV-COMPANY
                            PMH-CUSTOMER         -> ASV-CUSTOMER
                            PMH-SERVICE-LOC      -> ASV-SERVICE-LOC

Arcomp         ARCOMP       Not Required

                            PMH-COMPANY          -> ACO-COMPANY

Arcontacts     ARCONTACTS   Not Required

                            PMH-COMPANY          -> CON-COMPANY
                            PMH-CUSTOMER         -> CON-CUSTOMER
                            PMH-CONTACT-CODE     -> CON-RESP-CODE

Arcustomer     ARCUSTOMER   Not Required

                            PMH-COMPANY          -> ACM-COMPANY
                            PMH-CUSTOMER         -> ACM-CUSTOMER

Aroihdr C      AROIHDR      Not Required

                            PMH-COMPANY          -> ARH-COMPANY
                            "C"                  -> ARH-TRANS-TYPE
                            PMH-INVOICE          -> ARH-INVOICE

Aroihdr D      AROIHDR      Not Required

                            PMH-COMPANY          -> ARH-COMPANY
                            "D"                  -> ARH-TRANS-TYPE
                            PMH-INVOICE          -> ARH-INVOICE

Aroihdr I      AROIHDR      Not Required

                            PMH-COMPANY          -> ARH-COMPANY
                            "I"                  -> ARH-TRANS-TYPE
                            PMH-INVOICE          -> ARH-INVOICE

Aroihdr M      AROIHDR      Not Required

                            PMH-COMPANY          -> ARH-COMPANY
                            "M"                  -> ARH-TRANS-TYPE
                            PMH-INVOICE          -> ARH-INVOICE

Arproclevl     ARPROCLEVL   Not Required

                            PMH-COMPANY          -> APV-COMPANY
                            PMH-PROCESS-LEVEL    -> APV-PROCESS-LEVEL

Billto         BILLTO       Not Required

                            ACO-CUST-GROUP       -> ABS-CUST-GROUP
                            PMH-CUSTOMER         -> ABS-CUSTOMER
                            PMH-BILL-TO          -> ABS-BILL-TO

Custdesc       CUSTDESC     Not Required

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            PMH-CUSTOMER         -> CUD-CUSTOMER

                         ACPMHSTHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acinvaudit     ACINVAUDIT

                            PMH-OBJ-ID           -> IVA-OBJ-ID
                                                    IVA-LINE-NBR
                                                    IVA-TRANS-DATE
                                                    IVA-SEQUENCE-NBR

Acmntsch       ACMNTSCH

                            PMH-OBJ-ID           -> MSC-PMH-OBJ-ID
                                                    MSC-CONTRACT
                                                    MSC-MAINT-SCHEDULE
                                                    MSC-PRODUCT
                                                    MSC-PROD-VERSION
                                                    MSC-OBJ-ID

Acpmhstcsl     ACPMHSTCSL

                            PMH-OBJ-ID           -> PMC-OBJ-ID
                                                    PMC-LINE-NBR

Acpmhstdtl     ACPMHSTDTL

                            PMH-OBJ-ID           -> PML-OBJ-ID
                                                    PML-LINE-NBR

Acprmstnx      ACPRMSTNX

                            PMH-OBJ-ID           -> PMX-PMH-OBJ-ID
                                                    PMX-ACTIVITY
                                                    PMX-MILESTONE-CAT
                                                    PMX-MILESTONE