Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POAOCSPRD


                             POAOCSPRD FILE

                           Add On Cost Spread

This file is used internally to document the add on cost spread method used
when entering or invoicing a Lawson Purchase Order.

REFERENCED BY

API5.1    MA540     POI7.1    POIT.1

UPDATED BY

AP115     AP125     AP126     AP131     AP180     AP181
AP190     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP21.1    AP220     AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP28.1    AP28.2    AP30.4    AP300
AP305     AP45.1    API1.1    API2.1    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    MA180     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.7    MA530     MA531     MA60.2    MA60.3    MA60.5
MA61.1    MA66.2    MA66.3    MA67.2    MA67.3    MA68.2
MA68.3    MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1
PD10.1    PD10.2    PD130     PD20.1    PD20.2    PD20.3
PO100     PO101     PO122     PO131     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO24.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    PO32.4    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
POID.1    POII.1    POIJ.1    RQ10.1    RQ10.2    WH20.2
WH20.7    AP198

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSP-COMPANY            Numeric 4                                 AP115   AP180
Element: Company       The company number.                       AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-PO-NUMBER          Alpha 14  (Right Justified)               AP115   AP180
Element: Po Number     This field contains the number            AP181   AP190
                       representing the purchase order.          AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-PO-RELEASE         Numeric 4                                 AP115   AP180
Element: Po Release    Used to identify a purchase order         AP181   AP190
                       release (created from a Blanket or        AP20.1  AP20.2
                       Standing order).                          AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-PO-CODE            Alpha 4                                   AP115   AP180
Element: Po Code       This is the purchase order code.          AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-AOC-CODE           Alpha 2                                   AP115   AP180
Element: Aoc Code      This field contains the identifier for    AP181   AP190
                       the add-on cost associated with this      AP20.1  AP20.2
                       line item.                                AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-INVOICE            Alpha 22                                  AP115   AP180
Element: Invoice       Used to identify the invoice.             AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-AOC-RATE           Percent 7.3  (Percent)                    AP115   AP180
Element: Aoc Rate      Add-on cost percentage rate. If add-on    AP181   AP190
                       cost is spread by rate, this value times  AP20.1  AP20.2
                       the line unit cost is the unit add-on     AP20.3  AP20.4
                       cost for the purchase order line.         AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-ENT-AOC-AMOUNT     Signed 18.2                               AP115   AP180
Element: Intl Amt      The amount, which is to be spread by      AP181   AP190
                       the defined method across the purchase    AP20.1  AP20.2
                       order or invoice.                         AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-CALC-SPRD-AMT      Signed 18.2                               AP115   AP180
Element: Intl Amt      This calculated amount is the             AP181   AP190
                       accumulation of all add-on cost unit      AP20.1  AP20.2
                       costs extended for the purchase order     AP20.3  AP20.4
                       after using the spread feature.           AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA66.2  MA70.1
                                                                 MA75.1  PO21.2
                                                                 PO21.4  PO21.5
                                                                 PO29.1  PO520

PSP-SPREAD-DIFF        Signed 18.2                               AP115   AP180
Element: Intl Amt      The difference between the entered        AP181   AP190
                       spread amount and the accumulated spread  AP20.1  AP20.2
                       amount for the purchase order.            AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA66.2  MA70.1
                                                                 MA75.1  PO21.2
                                                                 PO21.4  PO21.5
                                                                 PO29.1  PO520

PSP-SPREAD-METHOD      Alpha 1                                   AP115   AP180
Element: Spread Method A method of spreading add-on cost         AP181   AP190
                       amounts across the purchase order line    AP20.1  AP20.2
                       level.                                    AP20.3  AP20.4
                       Q = Quantity                              AP20.5  AP20.7
                       W = Weight                                AP21.1  AP220
                       V = Volume                                AP23.1  AP25.2
                       A = Amount                                AP26.1  AP27.1
                       N = No Spread                             AP28.1  AP28.2
                       R = Rate                                  AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-TAX-CODE           Alpha 10                                  AP115   AP180
Element: Tax Code      This field contains a code representing   AP181   AP190
                       specific tax information.  This must be   AP20.1  AP20.2
                       valid Tax Code.                           AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-DST-ACCT-UNIT      Alpha 15                                  AP115   AP180
Element: Acct Unit     The accounting unit is a shorthand        AP181   AP190
                       notation representing the variable level  AP20.1  AP20.2
                       number. When used in the General Ledger   AP20.3  AP20.4
                       Account Master file, the accounting unit  AP20.5  AP20.7
                       must be defined in the General Ledger     AP21.1  AP220
                       Names file as a posting accounting unit.  AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-DST-ACCOUNT        Numeric 6                                 AP115   AP180
Element: Account       This field along with the accounting      AP181   AP190
                       unit and subaccount make up the location  AP20.1  AP20.2
                       (account) where amounts and other         AP20.3  AP20.4
                       account information is stored.            AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-DST-SUB-ACCT       Numeric 4                                 AP115   AP180
Element: Sub Acct      This field contains the subaccount from   AP181   AP190
                       your general ledger chart of accounts     AP20.1  AP20.2
                       that was charged with the amount carried  AP20.3  AP20.4
                       on this record.                           AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-TAXABLE-FLAG       Alpha 1                                   AP115   AP180
Element: Taxable Flag  Defines if taxable.                       AP181   AP190
                       Y = Yes                                   AP20.1  AP20.2
                       N = No                                    AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-ACCRUAL-FL         Alpha 1                                   AP115   AP180
Element: Accrual Fl    I = Invoiced                              AP181   AP190
                       A = Accrued                               AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

PSP-TAX-AMOUNT         Signed 18.5                               AP115   AP180
Element: Intl Cost                                               AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

PSP-AOC-ON-PO          Alpha 1                                   AP115   AP180
Element: Aoc On Po     Indicates if the add-on cost is to        AP181   AP190
                       appear on the Purchase Order document     AP20.1  AP20.2
                       that is issued to the vendor.             AP20.3  AP20.4
                       Y = Yes                                   AP20.5  AP20.7
                       N = No                                    AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-SUMMARY-FLAG       Alpha 1                                   AP115   AP180
Element: Summary Flag  Defines if the add-on cost is printed     AP181   AP190
                       in summary or at a detail level on the    AP20.1  AP20.2
                       purchase order.                           AP20.3  AP20.4
                       N = No                                    AP20.5  AP20.7
                       Y = Yes                                   AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-VENDOR             Alpha 9  (Right Justified)                AP115   AP180
Element: Vendor        The vendor's identification code.         AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-PURCH-FR-LOC       Alpha 4                                   AP115   AP180
Element: Purch Fr Loc  The vendor's purchase from location.      AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO29.1
                                                                 PO520

PSP-SEGMENT-BLOCK      Alpha 103                                 AP115   AP180
Element: Segment Block This field identifies the user analysis   AP181   AP190
                       values included in the transaction.       AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                       You can either type up to four values     AP20.5  AP20.7
                       or use Define (F6) to open the User       AP21.1  AP220
                       Analysis Entry subform. Use this subform  AP23.1  AP25.2
                       to select the user analysis values you    AP26.1  AP27.1
                       want to include in the transaction. If    AP28.1  AP28.2
                       you choose to type values, use commas to  AP30.4  AP305
                       separate them. For example:               AP45.1  API1.1
                       value1,value2,value3,value4               API2.1  MA41.1
                                                                 MA41.2  MA41.4
                       There are three conditions that affect    MA41.7  MA43.2
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

PSP-ACTIVITY           Alpha 15                                  AP115   AP180
Element: Activity      Activities are the processes or           AP181   AP190
                       procedures that produce work. Cost        AP20.1  AP20.2
                       objects (products, services, customers,   AP20.3  AP20.4
                       and so on) are the reasons for            AP20.5  AP20.7
                       performing the activity.                  AP21.1  AP220
                                                                 AP23.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP305
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

PSP-ACCT-CATEGORY      Alpha 5                                   AP115   AP180
Element: Acct Category Account categories are groupings of       AP181   AP190
                       costs, revenues, or a combination of      AP20.1  AP20.2
                       both used for reporting and inquiries     AP20.3  AP20.4
                       for activities in the Activity            AP20.5  AP20.7
                       Management system. All transactions are   AP21.1  AP220
                       posted to an account category within an   AP23.1  AP25.2
                       activity. You can assign a specific       AP26.1  AP27.1
                       General Ledger account or range of        AP28.1  AP28.2
                       accounts (company, accounting unit,       AP30.4  AP305
                       account, and subaccount) that make up     AP45.1  API1.1
                       the transactions posted to an account     API2.1  MA41.1
                       category using AC07.1 (Account            MA41.2  MA41.4
                       Assignment).                              MA41.7  MA43.2

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

PSP-BILL-CATEGORY      Alpha 32                                  AP115   AP20.1
Element: Bill Category                                           AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP220   AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP305   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

                         POAOCSPRD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSPSET1   COMPANY                                                AP125   AP126
          PO-NUMBER                                              AP131   AP20.1
          PO-RELEASE                                             AP20.2  AP20.3
          PO-CODE                                                AP20.4  AP20.5
          AOC-CODE                                               AP20.7  AP21.1
          INVOICE                                                AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  API5.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

PSPSET2   COMPANY       Subset                                   AP125   AP126
          PO-NUMBER     Where INVOICE = Spaces                   AP131   AP20.1
          PO-RELEASE                                             AP20.2  AP20.3
          PO-CODE                                                AP20.4  AP20.5
          AOC-CODE                                               AP20.7  AP21.1
          INVOICE                                                AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  MA180
                                                                 ...

PSPSET3   COMPANY       Subset
          INVOICE       Where INVOICE != Spaces
          AOC-CODE
          PO-NUMBER
          PO-RELEASE
          PO-CODE

PSPSET4   COMPANY       KeyChange, Subset                        AP115   AP125
          VENDOR        Where INVOICE != Spaces                  AP126   AP198
          INVOICE                                                AP20.1  AP20.2
          AOC-CODE                                               AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP220
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP300   AP305
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MA70.1
                                                                 ...

                         POAOCSPRD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Poaocmast      POAOCMAST    Required

                            PSP-COMPANY       -> PAM-COMPANY
                            PSP-AOC-CODE      -> PAM-AOC-CODE

Txtaxcode      TXTAXCODE    Required

                            PSP-COMPANY       -> TAC-COMPANY
                            PSP-TAX-CODE      -> TAC-TAX-CODE

                         POAOCSPRD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Poaudit        POAUDIT

                            PSP-COMPANY       -> PAU-COMPANY
                            PSP-PO-NUMBER     -> PAU-PO-NUMBER
                            PSP-PO-RELEASE    -> PAU-PO-RELEASE
                            PSP-PO-CODE       -> PAU-PO-CODE
                            Zeroes            -> PAU-PO-LINE-NBR
                            PSP-AOC-CODE      -> PAU-AOC-CODE
                                                 PAU-PO-REVISION
                                                 PAU-UPDATE-DATE
                                                 PAU-UPDATE-TIME
                                                 PAU-FLD-NBR
                                                 PAU-AUDIT-TYPE
                                                 PAU-AUDIT-ACTION