Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPMHSTTAX


                            ACPMHSTTAX FILE

UPDATED BY

BRIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PHT-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.

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

PHT-SEQ-NBR            Numeric 4                                 BRIP.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

PHT-TAX-CODE           Alpha 10                                  BRIP.1
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


PHT-DESCRIPTION        Alpha 30  (Lower Case)                    BRIP.1
Element: Description   This field displays the description.

PHT-TAX-RATE           Percent 7.5  (Percent)                    BRIP.1
Element: Tax Rate      The tax rate defined for the tax code.

PHT-TAX-AMT            Signed 18.2                               BRIP.1
Element: Intl Amt

PHT-TAX-LEVEL          Alpha 1                                   BRIP.1
Element: Tax Level

                         ACPMHSTTAX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHTSET1   OBJ-ID                                                 BRIP.1
          PML-LINE-NBR
          SEQ-NBR

                         ACPMHSTTAX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acpmhstdtl     ACPMHSTDTL   Not Required

                            PHT-OBJ-ID          -> PML-OBJ-ID
                            PHT-PML-LINE-NBR    -> PML-LINE-NBR

Acpmhsthdr     ACPMHSTHDR   Required

                            PHT-OBJ-ID          -> PMH-OBJ-ID