Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ERSAOCDTL FILE

                         ERS Add On Cost Detail

This file contains add on cost detail information that is captured at receipt
time for evaluated receipt settlement PO's.

REFERENCED BY

MA530     PO35.1

UPDATED BY

PO30.1    PO30.2    PO38.1    PO530

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ERS-COMPANY          Numeric 4                                   PO30.1  PO30.2
Company              The company number.                         PO38.1  PO530

ERS-REC-NUMBER       Alpha 10  (Right Justified)                 PO30.1  PO30.2
Receiver Number      The receiver number.  Assigned when         PO38.1  PO530
                     this receiving information was added.

ERS-LINE-NBR         Numeric 6                                   PO30.1  PO30.2
Line Number          This field contains the line number.        PO38.1  PO530

ERS-AOC-CODE         Alpha 2                                     PO30.1  PO30.2
Add On Cost Code     This field contains the identifier for      PO38.1  PO530
                     the add-on cost associated with this
                     line item.

ERS-TOTAL-AOC        Signed 15.2                                 PO30.1  PO30.2
Total Add On Cost    The total add-on cost amount can be an      PO38.1  PO530
                     entered amount if entered at this level,
                     or a calculated amount if a unit add-on
                     cost or add-on cost percent is entered.

ERS-AOC-SOURCE       Numeric 1
Aoc Source           0 = AOC From POAOCDTL File
                     1 = AOC From POAOCSPRD File

                         ERSAOCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ERSSET1   COMPANY                                                MA530   PO30.1
          REC-NUMBER                                             PO30.2  PO35.1
          LINE-NBR                                               PO38.1  PO530
          AOC-CODE

                         ERSAOCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Poaocmast      POAOCMAST    Required

                            ERS-COMPANY       -> PAM-COMPANY
                            ERS-AOC-CODE      -> PAM-AOC-CODE

Poreceive      PORECEIVE    Not Required

                            ERS-COMPANY       -> POR-COMPANY
                            ERS-REC-NUMBER    -> POR-REC-NUMBER

Porecline      PORECLINE    Not Required

                            ERS-COMPANY       -> PRL-COMPANY
                            "PO"              -> PRL-DOC-TYPE
                            ERS-REC-NUMBER    -> PRL-DOCUMENT
                            ERS-LINE-NBR      -> PRL-LINE-NBR