Lawson Insight Technical Documentation

                             RECAOCDTL FILE

                          Receiving AOC Detail

UPDATED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.4    API1.1    IC28.1    MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    PO100     PO101     PO122     PO131
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POD0.1    POI3.1
POII.1    POIJ.1    RQ10.1    RQ10.2    RQ10.3    RQIE.1
WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

REC-COMPANY            Numeric 4                                 MA531   PO30.1
Element: Company       The company number represents an          PO30.2  PO30.3
                       established company and is entered on     PO35.1  PO38.1
                       all function codes.                       PO52.1

REC-REC-NUMBER         Numeric 10                                MA531   PO30.1
Element: Receiver NumbeThe receiver number.  Assigned when       PO30.2  PO30.3
                       this receiving information was added.     PO35.1  PO38.1
                                                                 PO52.1

REC-LINE-NBR           Numeric 6                                 MA531   PO30.1
Element: Line Number   This field contains the line number.      PO30.2  PO30.3
                                                                 PO35.1  PO38.1
                                                                 PO52.1

REC-AOC-CODE           Alpha 2                                   MA531   PO30.1
Element: Add On Cost CoThis field contains the identifier for    PO30.2  PO30.3
                       the add on cost associated with this      PO35.1  PO38.1
                       line item.                                PO52.1

REC-ORIG-UNIT-CST      Signed 13.5                               MA531   PO30.1
Element: Base Cost                                               PO30.2  PO30.3
                                                                 PO35.1  PO38.1
                                                                 PO52.1

REC-TOTAL-AOC          Signed 15.2                               MA531   PO30.1
Element: Total Add On CThe total add on cost amount can be an    PO30.2  PO30.3
                       entered amount if  entered at this        PO35.1  PO38.1
                       level, or a calculated  amount if a unit  PO52.1
                       add on cost or add on  cost percent is
                       entered.

REC-TAX-CODE           Alpha 10                                  MA531   PO30.1
Element: Tax Code      This field contains a code representing   PO30.2  PO30.3
                       specific tax information.  This must be   PO35.1  PO38.1
                       valid Tax Code.                           PO52.1


REC-TAX-UNIT-CST       Signed 13.5                               MA531   PO30.1
Element: Tax Unit Cst                                            PO30.2  PO30.3
                                                                 PO35.1  PO38.1
                                                                 PO52.1

                         RECAOCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RECSET1   COMPANY                                                AP125   AP126
          REC-NUMBER                                             AP131   AP20.1
          LINE-NBR                                               AP20.2  AP20.3
          AOC-CODE                                               AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 IC28.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.9
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 ...