Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APAPIHIST


                             APAPIHIST FILE

REFERENCED BY

POA3.1    AP00.4    AP01.1    AP125     AP126     AP131
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP21.1    AP212     AP23.1    AP245     AP25.1
AP25.2    AP255     AP26.1    AP27.1    AP270     AP275
AP30.4    AP32.1    AP520     AP91.1    AP93.2    AP93.1
AP96.1    AP96.2    AP96.3    APH1.1    API1.1    API2.1
AR48.3    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    EE20.1    EE20.2    EE20.4    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     POI3.1    POID.1
POII.1    POIJ.1    RQ10.1    RQ10.2    WH20.2    WH20.7
AP10.1    AP251

UPDATED BY

AP115     AP136     AP180     AP181     AP190     AP198
AP28.1    AP28.2    AP300     AP305     AP45.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AH1-COMPANY            Numeric 4                                 AP198   AP300
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

AH1-VENDOR             Alpha 9  (Right Justified)                AP115   AP198
Element: Vendor        The vendor's identification code.         AP300



AH1-INVOICE            Alpha 22                                  AP115   AP198
Element: Invoice       Used to identify the invoice.             AP300

AH1-SUFFIX             Numeric 3                                 AP198   AP300
Element: Suffix        This is the suffix for the invoice.

AH1-CANCEL-SEQ         Numeric 4                                 AP198   AP300
Element: Seq Nbr       An automatically assigned sequence
                       number.

AH1-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AP198
Element: Cancel Date   The cancellation date.

AH1-BATCH-NUM          Numeric 6                                 AP198
Element: Batch Nbr     This identifies the batch the entered
                       invoices, debit memos, and credit memos
                       are a part of.

AH1-BATCH-DATE         Numeric 8  (yyyymmdd)                     AP198
Element: Batch Date

AH1-VOUCHER-NBR        Alpha 10                                  AP198
Element: Voucher Nbr

AH1-AUTH-CODE          Alpha 3                                   AP198
Element: Auth Code     A user-defined code representing a
                       person or department responsible for
                       approving a registered invoice.

AH1-PROC-LEVEL         Alpha 5                                   AP198
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

AH1-ACCR-CODE          Alpha 4                                   AP198
Element: Accr Code     A user-defined code representing a
                       general ledger accrual account.

AH1-INVOICE-TYPE       Alpha 1                                   AP198
Element: Invoice Type  THis field will be filled in from the
                       Invoice based on PO number.  This is a
                       carrier for the field.  The PORECEIVE
                       file will have to be updated with this
                       field.

AH1-INV-CURRENCY       Alpha 5                                   AP198
Element: To Base Curr

AH1-PAY-CURRENCY       Alpha 5                                   AP198
Element: To Base Curr

AH1-INVOICE-DTE        Numeric 8  (yyyymmdd)                     AP198
Element: Invoice Dte

AH1-PURCH-FR-LOC       Alpha 4                                   AP115   AP198
Element: Purch Fr Loc  The vendor's purchase from location.

AH1-PO-NUMBER          Alpha 14  (Right Justified)               AP198
Element: Po Number     This field contains the number
                       representing the purchase order.


AH1-PO-RELEASE         Numeric 4                                 AP198
Element: Po Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).


AH1-PO-CODE            Alpha 4                                   AP198
Element: Po Code       This is the purchase order code.

AH1-DESCRIPTION        Alpha 30  (Lower Case)                    AP198
Element: Description   This field displays the description.

AH1-BASE-INV-AMT       Signed 18.2                               AP198
Element: Intl Amt

AH1-BASE-ACT-AMT       Signed 18.2                               AP198
Element: Intl Amt

AH1-BASE-ND            Numeric 1                                 AP198
Element: Base Nd       The number of decimal positions defined
                       for the company base currency.

AH1-TRAN-INV-AMT       Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-ALOW-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-TXBL-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-TOT-TXBL      Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-ND            Numeric 1                                 AP198
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


AH1-TRAN-TAX-AMT       Signed 18.2                               AP198
Element: Intl Amt

AH1-BASE-DISC-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-DISC-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH1-BASE-TOT-PMT       Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-TOT-PMT       Signed 18.2                               AP198
Element: Intl Amt

AH1-BASE-TOT-DIST      Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-TOT-DIST      Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-TOT-TAX       Signed 18.2                               AP198
Element: Intl Amt

AH1-TRAN-PAID-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH1-ORIG-CNV-RATE      Signed 14.7                               AP198
Element: Acct Rate

AH1-ANTICIPATION       Alpha 1                                   AP198
Element: Anticipation  The anticipation flag.

AH1-DISCOUNT-RT        Percent 5.3  (Percent)                    AP198
Element: Discount Rt

AH1-DISC-DATE          Numeric 8  (yyyymmdd)                     AP198
Element: Date          This field displays the system date
                       when this was created.

AH1-DUE-DATE           Numeric 8  (yyyymmdd)                     AP198
Element: Due Date      The transaction due date.

AH1-NBR-SPLIT-PMT      Numeric 3                                 AP198
Element: Nbr Of Invcs

AH1-SPLIT-PMT-SCH      Alpha 1                                   AP198
Element: Split Pmt Sch

AH1-NBR-RECUR-PMT      Numeric 3                                 AP198
Element: Nbr Of Invcs

AH1-RECUR-FREQ         Alpha 1                                   AP198
Element: Recur Freq

AH1-REMIT-TO-CODE      Alpha 4                                   AP115   AP198
Element: Remit To Code A user-defined code that represents a
                       vendor's remittance address.

AH1-CASH-CODE          Alpha 4                                   AP115   AP198
Element: Cash Code     A cash code represents a bank account.
                       More than one company can use the same
                       cash code.  The cash code must be linked
                       to a bank in the Lawson Cash Ledger
                       system.


AH1-BANK-INST-CODE     Alpha 3                                   AP115   AP198
Element: Bank Inst CodeA transaction code represents a type of
                       cash payment, bill of exchange payment,
                       or bank service transaction.

AH1-CURR-RECALC        Alpha 1                                   AP198
Element: All Flag

AH1-TAX-CODE           Alpha 10                                  AP198
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


AH1-INCOME-CODE        Alpha 4                                   AP198
Element: Income Code   A user-defined code that represents a
                       type of income withholding. Used to
                       track reportable income for reporting or
                       withholding.

AH1-DIST-CODE          Alpha 9                                   AP198
Element: Dist Code     A user-defined code used to
                       automatically create expense
                       distributions or expense distribution
                       "shells" for invoices or to split an
                       invoice distribution into multiple
                       distributions.

AH1-REC-STATUS         Numeric 1                                 AP198
Element: Rec Status    The record status.

AH1-CREATE-DATE        Numeric 8  (yyyymmdd)                     AP198
Element: Create Date   The creation date.

AH1-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP198
Element: Date          This field displays the system date
                       when this was created.

AH1-OPERATOR           Alpha 10                                  AP198
Element: Operator      This field is used to store the login
                       id of the person who entered the record.


AH1-CREATION-TIME      Numeric 6  (hhmmss)                       AP198
Element: Creation Time The creation time.

AH1-VENDOR-GROUP       Alpha 4                                   AP198
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.


AH1-PAY-VENDOR         Alpha 9  (Right Justified)                AP115   AP198
Element: Vendor        The vendor's identification code.



AH1-PAY-GROUP          Alpha 4                                   AP198
Element: Pay Group     A pay group is used for processing
                       accounts payable payments. A pay group
                       lets you create a single payment for a
                       vendor to pay invoices received by all
                       company process levels assigned to the
                       pay group.


AH1-INVOICE-GROUP      Alpha 4                                   AP115   AP198
Element: Invoice Group A user-defined character expression. An
                       invoice group can be assigned to one
                       more invoices. AP150 (Cash Requirements)
                       has an option to select all invoices
                       assigned the same invoice group.

AH1-LAST-DIST-SEQ      Numeric 6                                 AP198
Element: Dist Seq Nbr  A unique sequence number.

AH1-LAST-PMT-SEQ       Numeric 4                                 AP198
Element: Seq Nbr       An automatically assigned sequence
                       number.

AH1-DISCOUNT-CODE      Alpha 10                                  AP198
Element: Discount Code A user-defined code that represents a
                       general ledger discount account.

AH1-INVOICE-SOURCE     Alpha 1                                   AP198
Element: Invoice SourceIndicates the source for creation of the
                       invoice (manual, EDI, evaluated receipts
                       settlement).

AH1-INVC-REF-TYPE      Alpha 2                                   AP198
Element: Invc Ref Type Indicates the type of number the vendor
                       is providing to reference the invoice.

AH1-APPROVED-FLAG      Alpha 1                                   AP198
Element: Approved Flag

AH1-APPRV-OPERATOR     Alpha 10                                  AP198
Element: Operator      This field is used to store the login
                       id of the person who entered the record.


AH1-RETURN-NUMBER      Numeric 10                                AP198
Element: Return Number This is the number assigned to the
                       return for purposes of referencing the
                       return internally and with the customer
                       or vendor.

AH1-JRNL-BOOK-NBR      Alpha 12                                  AP198
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

AH1-TAX-POINT          Alpha 1                                   AP198
Element: Tax Point

AH1-OBJ-ID             Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       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.

AH1-RECON-DATE         Numeric 8  (yyyymmdd)                     AP136   AP198
Element: Recon Date    Represents the date the transaction
                       cleared the bank or was voided.

AH1-POD-PRINTED        Numeric 1                                 AP198
Element: Au Flag

AH1-MATCH-REF-NBR      Alpha 22                                  AP198
Element: Match Ref Nbr

AH1-MATCH-FL           Alpha 1                                   AP198
Element: Match Fl      This field determines whether a
                       transaction is considered to be a match
                       transaction.

AH1-TERMS-CD           Alpha 5                                   AP198
Element: Term Code     A user-defined code representing a
                       method of determining invoice due and
                       discount dates.

AH1-RCPT-INV-DATE      Numeric 8  (yyyymmdd)                     AP198
Element: Date          This field displays the system date
                       when this was created.

AH1-RETAIL-AMT         Signed 18.2                               AP198
Element: Intl Amt

AH1-MATCH-STATUS       Numeric 1                                 AP198
Element: Match Status

AH1-REASON-CODE        Alpha 4                                   AP198
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

AH1-HANDLING-CODE      Alpha 4                                   AP198
Element: Handling Code

AH1-MATCH-AMT          Signed 18.2                               AP198
Element: Intl Amt

AH1-AOC-ALLOW-AMT      Signed 18.2                               AP198
Element: Intl Amt

AH1-LOCATION           Alpha 5                                   AP198
Element: Location      This field contains a valid stocking
                       location within the company inventory.

AH1-MATCH-OBJ-ID       Numeric 12                                AP198
Element: Obj Id        This is the object identifier. It is
                       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.

AH1-CBPRINT-FL         Alpha 1                                   AP198
Element: Cbprint Fl

AH1-MATCH-TABLE        Alpha 10                                  AP198
Element: Match Table

AH1-TAX-CODE-CNTL      Alpha 1                                   AP198
Element: Tax Code Cntl This control field defines the tax code
                       usage in invoicing and approving taxes.

                       For PO Invoices, if set to O (Override)
                       all lines approved for payment will use
                       the tax code defined for the whole
                       invoice.

                       If set to I (Ignore) no PO lines
                       approved for payment will be taxed.

AH1-LAST-MATCH-LN      Numeric 4                                 AP198
Element: Orig Line

AH1-MATCH-LEVEL        Alpha 3                                   AP198
Element: Match Level

AH1-MATCH-DATE         Numeric 8  (yyyymmdd)                     AP198
Element: Date          This field displays the system date
                       when this was created.

AH1-PO-INV-TAX         Signed 18.2                               AP198
Element: Intl Amt

AH1-BYPASS-MATCH       Alpha 1                                   AP198
Element: All Flag

AH1-SERVICE-FL         Alpha 1                                   AP198
Element: Service Fl    This field indicates a transaction is a
                       Service only transaction.

AH1-SERVICE-AMT        Signed 18.2                               AP198
Element: Intl Amt

AH1-NOTC               Alpha 2                                   AP198
Element: Notc          The Nature of Transaction code.  Must
                       be a valid code defined in IN07.1 (NOTC
                       Maintenance).

AH1-STAT-PROC          Alpha 6                                   AP198
Element: Stat Proc     The statistical procedure code applied
                       to the data.  The code must be defined
                       in IN06.1. (Statistical Procedure
                       Maintenance).

AH1-SHIP-VIA           Alpha 12  (Lower Case)                    AP198
Element: Ship Via

AH1-UNLOADING-PORT     Alpha 5                                   AP198
Element: Unloading PortThe prot where the goods are unloaded if
                       required.  Must be defined in IN04.1
                       (Port Maintenance)

AH1-INTRASTAT-NBR      Numeric 12                                AP198
Element: Intrastat Nbr The number assigned by the Intrastat
                       system to a transaction that involves
                       Intrastat reporting after it has been
                       added.

AH1-DROPSHIP-FL        Alpha 1                                   AP198
Element: Dropship Fl   This flag indicates whether goods being
                       shipped by the vendor directly to a non
                       standard location need to have the
                       receiving process performed.

AH1-FOB-CODE           Alpha 3                                   AP198
Element: Fob Code      The user defined Free On Board Code.

AH1-TAX-OUT-BAL        Derived
Element: Tax Out Bal

AH1-TXB-OUT-BAL        Derived
Element: Txb Out Bal   Derived field to show difference between
                       header taxable input and total taxable
                       amount from distributions.

AH1-PMT-OUT-BAL        Derived
Element: Pmt Out Bal

AH1-DIST-OUT-BAL       Derived
Element: Dist Out Bal

AH1-OUT-BAL-FLAG       Derived
Element: Out Bal Flag

AH1-INV-STATUS         Derived
Element: Inv Status

AH1-NET-PAYABLE        Derived
Element: Net Payable

AH1-REV-SIGN-AMT       Derived
Element: Rev Sign Amt

AH1-TYPE-SHORT-NME     Derived
Element: Type Short Nme

AH1-PO-RELEASE-3       Derived
Element: Po Release 3  The PO release number converted to a
                       three-character field for purposes of
                       display and printing the shorter field.

AH1-JBK-SEQ-NBR        Numeric 10                                AP198
Element: Jbk Seq Nbr   The journal book sequence number
                       assigned to a journal book transaction
                       when it is added or interfaced to the
                       Lawson system. Used only when  Auto
                       Journal Book Seq Nbr is set to Yes in
                       GL10.1 (Company).


AH1-DIVERSE-CODE       Alpha 5                                   AP115   AP198
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors

AH1-FLEX-FLAG          Alpha 1                                   AP198
Element: Flex Flag

AH1-RULE-GROUP         Alpha 10                                  AP198
Element: Rule Group

AH1-FLOAT-DAYS         Numeric 3                                 AP198
Element: Float Days

AH1-MTCH-PREPAY-FL     Alpha 1                                   AP198
Element: Mtch Prepay Fl

AH1-MTCH-PREPAY-MT     Numeric 1                                 AP198
Element: Mtch Prepay Mt

AH1-PREPAY-DATE        Numeric 8  (yyyymmdd)                     AP198
Element: Prepay Date

AH1-COCO-FL            Numeric 1                                 AP198
Element: Coco Fl       This is the flag when added to the
                       handling code denotes that the invoice
                       will be reviewed for match based on
                       header, line, and Cost components (AOC)

AH1-MATCH-AOC          Signed 18.2                               AP198
Element: Intl Amt

AH1-HASH-QTY           Signed 15.4                               AP198
Element: Hash Qty

AH1-XREF-VENDOR        Alpha 9  (Right Justified)                AP198
Element: Xref Vendor   This is a vendor that is supported on a
                       system outside Lawson.  When records are
                       interfaces we will maintain this vendor
                       on the file but we will use the Lawson
                       vendor while in the lawson application.

AH1-MTCH-ERR-TYPE      Numeric 2                                 AP198
Element: Mtch Err Type This is the reason the match was not
                       successful for Invoice Match.
                       01 = Match Invoice
                       02 = Cost error
                       03 = No receipt information
                       04 = Hash quantity error
                       05 = No AOC on purchase order
                       06 = No AOC cost

AH1-BT-AMT             Signed 18.2                               AP198
Element: Intl Amt

AH1-DISC-POINT         Numeric 1                                 AP198
Element: Disc Point

AH1-BUYER              Alpha 3
Element: Buyer

AH1-FINAL-DST-FLAG     Alpha 1
Element: Final Dst Flag

AH1-PRPY-DISC-CODE     Alpha 10
Element: Prpy Disc Code

AH1-PRPY-REF-NBR       Alpha 22
Element: Prpy Ref Nbr

AH1-PRPY-RTL-AMT       Signed 18.2
Element: Intl Amt

AH1-PRPY-AMT           Signed 18.2
Element: Intl Amt

AH1-PRPY-AOC-AMT       Signed 18.2
Element: Intl Amt

AH1-PRPY-TAX-AMT       Signed 18.2
Element: Intl Amt

AH1-PRPY-SERV-AMT      Signed 18.2
Element: Intl Amt

AH1-TAX-FLAG           Alpha 1
Element: Tax Flag

AH1-STATEMENT          Alpha 22
Element: Invoice       Used to identify the invoice.

                         APAPIHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AH1SET1   COMPANY                                                AP00.4  AP01.1
          VENDOR                                                 AP115   AP125
          INVOICE                                                AP126   AP131
          SUFFIX                                                 AP136   AP180
          CANCEL-SEQ                                             AP181   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.6
                                                                 AP20.7  AP21.1
                                                                 AP212   AP23.1
                                                                 AP245   AP25.1
                                                                 AP25.2  AP255
                                                                 AP26.1  AP27.1
                                                                 AP270   AP275
                                                                 AP28.1  AP28.2
                                                                 ...

AH1SET11  COMPANY       KeyChange, Subset
          VENDOR        Where MATCH-REF-NBR != Spaces
          MATCH-REF-NBR
          OBJ-ID

AH1SET12  COMPANY       Subset                                   AP131
          CBPRINT-FL    Where INVOICE-TYPE = "C"
          VENDOR
          INVOICE-DTE
          INVOICE
          SUFFIX
          CANCEL-SEQ

AH1SET13  COMPANY       KeyChange                                AP131   AP136
          VENDOR
          MATCH-OBJ-ID
          INVOICE
          SUFFIX
          CANCEL-SEQ

AH1SET3   REC-STATUS    KeyChange                                AP136   AP300
          COMPANY
          BATCH-NUM
          AUTH-CODE
          OPERATOR
          CREATE-DATE
          CREATION-TIME
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ

AH1SET4   COMPANY       KeyChange                                AP00.4  AP520
          VOUCHER-NBR                                            AP96.2
          REC-STATUS
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ

AH1SET5   VENDOR-GROUP  KeyChange                                AP10.1  AP115
          VENDOR                                                 AP251   AP91.1
          INVOICE                                                AP93.1
          SUFFIX
          CANCEL-SEQ
          COMPANY

AH1SET6   COMPANY       KeyChange                                AP251   AP300
          VENDOR
          INVOICE-DTE
          INVOICE
          SUFFIX
          CANCEL-SEQ

AH1SET9   COMPANY       KeyChange                                AP96.3
          VENDOR
          PO-NUMBER
          PO-RELEASE
          PO-CODE
          LOCATION
          INVOICE
          SUFFIX
          CANCEL-SEQ

                         APAPIHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            AH1-COMPANY          -> CPY-COMPANY

Apinccode      APINCCODE    Not Required

                            AH1-INCOME-CODE      -> TYP-INCOME-CODE

Appayvenmast   APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            AH1-PAY-VENDOR       -> VEN-VENDOR

Approclev      APPROCLEV    Required

                            AH1-COMPANY          -> APR-COMPANY
                            AH1-PROC-LEVEL       -> APR-PROC-LEVEL

Apvenlocpurch  APVENLOC     Required
                            When AH1-PURCH-FR-LOC != Spaces

                            AH1-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            AH1-VENDOR           -> VLO-VENDOR
                            AH1-PURCH-FR-LOC     -> VLO-LOCATION-CODE

Apvenlocremit  APVENLOC     Required
                            When AH1-REMIT-TO-CODE != Spaces

                            AH1-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            AH1-PAY-VENDOR       -> VLO-VENDOR
                            AH1-REMIT-TO-CODE    -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            AH1-VENDOR           -> VEN-VENDOR

Eeadvance A    EEADVANCE    Required
                            When AH1-INVOICE-TYPE = "A"

                            AH1-COMPANY          -> EEA-COMPANY
                            AH1-VENDOR           -> EEA-VENDOR
                            AH1-INVOICE          -> EEA-ADVANCE-NBR

Eeadvance M    EEADVANCE    Required
                            When AH1-INVOICE-TYPE = "M"

                            AH1-COMPANY          -> EEA-COMPANY
                            AH1-VENDOR           -> EEA-VENDOR
                            AH1-INVOICE          -> EEA-ADVANCE-NBR

Eeexpense      EEEXPENSE    Required
                            When AH1-INVOICE-TYPE = "E"

                            AH1-COMPANY          -> EXP-COMPANY
                            AH1-VENDOR           -> EXP-VENDOR
                            AH1-INVOICE          -> EXP-EXPENSE-NBR

Invusrfld      APISRHIST    Not Required

                            AH1-OBJ-ID           -> AH9-OBJ-ID

Reasoncd       MAREASONCD   Not Required

                            AH1-REASON-CODE      -> MAR-REASON-CODE

                         APAPIHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapdhist      APAPDHIST    Delete Cascades

                            AH1-OBJ-ID           -> AH2-API-OBJ-ID
                                                    AH2-DIST-SEQ-NBR

Apapphist      APAPPHIST    Delete Cascades

                            AH1-COMPANY          -> AH3-COMPANY
                            AH1-VENDOR           -> AH3-VENDOR
                            AH1-INVOICE          -> AH3-INVOICE
                            AH1-SUFFIX           -> AH3-SUFFIX
                            AH1-CANCEL-SEQ       -> AH3-CANCEL-SEQ
                                                    AH3-SEQ-NBR
                                                    AH3-VOID-SEQ

Maaoihist      MAAOIHIST    Delete Restricted

                            AH1-COMPANY          -> MH2-COMPANY
                            AH1-VENDOR           -> MH2-VENDOR
                            AH1-INVOICE          -> MH2-INVOICE
                            AH1-SUFFIX           -> MH2-SUFFIX
                                                    MH2-PO-NUMBER
                                                    MH2-PO-RELEASE
                                                    MH2-PO-CODE

Mamaahist      MAMAAHIST

                            AH1-COMPANY          -> MMH-COMPANY
                            AH1-VENDOR           -> MMH-VENDOR
                            AH1-INVOICE          -> MMH-INVOICE
                            AH1-SUFFIX           -> MMH-SUFFIX
                            AH1-PO-NUMBER        -> MMH-PO-NUMBER
                            AH1-PO-RELEASE       -> MMH-PO-RELEASE
                            AH1-PO-CODE          -> MMH-PO-CODE
                                                    MMH-LINE-NBR
                                                    MMH-AOC-CODE
                                                    MMH-SEQ-NBR

Mamaahist 2    MAMAAHIST

                            AH1-COMPANY          -> MMH-COMPANY
                            AH1-VENDOR           -> MMH-VENDOR
                            AH1-INVOICE          -> MMH-INVOICE
                            AH1-SUFFIX           -> MMH-SUFFIX
                                                    MMH-PO-NUMBER
                                                    MMH-PO-RELEASE
                                                    MMH-PO-CODE
                                                    MMH-LINE-NBR
                                                    MMH-AOC-CODE
                                                    MMH-SEQ-NBR

Mamadhist      MAMADHIST

                            AH1-COMPANY          -> MH1-COMPANY
                            AH1-VENDOR           -> MH1-VENDOR
                            AH1-INVOICE          -> MH1-INVOICE
                            AH1-SUFFIX           -> MH1-SUFFIX
                            AH1-PO-NUMBER        -> MH1-PO-NUMBER
                            AH1-PO-RELEASE       -> MH1-PO-RELEASE
                            AH1-PO-CODE          -> MH1-PO-CODE
                                                    MH1-LINE-NBR
                                                    MH1-AOC-CODE
                                                    MH1-SEQ-NBR

Mamadhist 2    MAMADHIST

                            AH1-COMPANY          -> MH1-COMPANY
                            AH1-VENDOR           -> MH1-VENDOR
                            AH1-INVOICE          -> MH1-INVOICE
                            AH1-SUFFIX           -> MH1-SUFFIX
                                                    MH1-PO-NUMBER
                                                    MH1-PO-RELEASE
                                                    MH1-PO-CODE
                                                    MH1-LINE-NBR
                                                    MH1-AOC-CODE
                                                    MH1-SEQ-NBR

Match Trans    APAPIHIST

                            AH1-COMPANY          -> AH1-COMPANY
                            AH1-VENDOR           -> AH1-VENDOR
                            AH1-MATCH-OBJ-ID     -> AH1-MATCH-OBJ-ID
                                                    AH1-INVOICE
                                                    AH1-SUFFIX
                                                    AH1-CANCEL-SEQ

Por Match Ref  PORECEIVE

                            AH1-COMPANY          -> POR-COMPANY
                            AH1-VENDOR           -> POR-VENDOR
                            AH1-MATCH-REF-NBR    -> POR-MATCH-REF-NBR
                                                    POR-REC-NUMBER

Porecline      PORECLINE

                            AH1-COMPANY          -> PRL-COMPANY
                            AH1-MATCH-OBJ-ID     -> PRL-MATCH-OBJ-ID
                                                    PRL-MATCH-SEQ-NBR
                                                    PRL-REC-NUMBER
                                                    PRL-LINE-NBR