Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPMHSTTAX


                            ACPMHSTTAX FILE

The ACPMHSTTAX file contains tax information from a product invoice. This file
is primarily updated by Product Invoicing (BR151). This file has relations
with ACPMHSTHDR and ACPMHSTDTL.

UPDATED BY

BRPI.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PHT-OBJ-ID             Numeric 12                                BRPI.1
Object                 This is the object identifier. It is
Identification         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                                 BRPI.1
Element: Line Number

PHT-SEQ-NBR            Numeric 4                                 BRPI.1
Element: Sequence NumbeAn automatically assigned sequence
                       number.

PHT-TAX-CODE           Alpha 10                                  BRPI.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)                    BRPI.1
Element: Description   This field displays the description.

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

PHT-TAX-AMT            Signed 15.2                               BRPI.1
Element: Adj Amt

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

                         ACPMHSTTAX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHTSET1   OBJ-ID                                                 BRPI.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