Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACPRODINV


                             ACPRODINV FILE

                            Product Invoices

The ACPRODINV file stores data that relates invoices to a contract. Each
invoice created for a contract is listed. This file can be used to find all
the invoices for a customer for use on, for example, Product Invoice
Cancellation (BR56). This file has relations with the ACCNTRACT file.

REFERENCED BY

BR151     BR56.1

UPDATED BY

BRPI.1    BR123

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PDI-CONTRACT           Alpha 10                                  BRPI.1
Element: Contract

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

                         ACPRODINV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PDISET1   CONTRACT                                               BR123   BR151
          OBJ-ID                                                 BR56.1  BRPI.1

                         ACPRODINV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT    Required

                            PDI-CONTRACT    -> CNT-CONTRACT