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    AP00.5    AP01.1    AP125     AP126
AP131     AP212     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    IC28.1    MA180     MA530     MA531
MA540     MA60.2    MA60.3    MA60.5    MA61.1    MA66.2
MA66.3    MA67.1    MA67.2    MA70.1    MA75.1    MA80.1
MAI1.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    PO100     PO101     PO122
PO131     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POI3.1    POIE.1    POII.1    POIJ.1
RQ10.1    RQ10.2    WH20.2    WH20.7    AP10.1    AP251

UPDATED BY

AP115     AP180     AP181     AP190     AP198     AP260
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 ID     The vendor's identification code.         AP300



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

AH1-SUFFIX             Numeric 3                                 AP198   AP300
Element: Invoice SuffixThis is the suffix for the invoice.

AH1-CANCEL-SEQ         Numeric 4                                 AP198   AP300
Element: Sequence NumbeThe sequence number assigned upon a
                       cancellation of a distributed invoice.
                       The first sequence assigned is 9999.

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

AH1-BATCH-NUM          Numeric 6                                 AP198
Element: Batch Number  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

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

AH1-PROC-LEVEL         Alpha 5                                   AP198
Element: Process Level The process level represents a
                       reporting level below company.

AH1-ACCR-CODE          Alpha 4                                   AP198
Element: Accrual 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
To Company Base
Currency

AH1-PAY-CURRENCY       Alpha 5                                   AP198
To Company Base        The currency the invoices were entered
Currency               in.

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

AH1-PURCH-FR-LOC       Alpha 4                                   AP115   AP198
Purchase From          The vendor's purchase from location.
Location Code

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 NumUsed 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
Base Number Of         The number of decimal positions defined
Decimals               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      The total taxable amount for the invoice
                       distributions in currency of invoice.

AH1-TRAN-ND            Numeric 1                                 AP198
Account Currency       The number of decimal positions defined
Code                   for the transaction currency.

AH1-TRAN-TAX-AMT       Signed 18.2                               AP198
Element: Intl Amt      The amount to be posted to the general
                       ledger for the tax distribution. The
                       transaction amount less the tax amount
                       will be posted to the selected general
                       ledger account.

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: Account Rate  Represents the currency exchange rate
                       the transaction was created with.

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

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

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

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
Split Payment
Schedule

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

AH1-RECUR-FREQ         Alpha 1                                   AP198
Element: Recurring Frequency

AH1-REMIT-TO-CODE      Alpha 4                                   AP115   AP198
Remit To Location      A user-defined code that represents a
Code                   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: Transaction CoA 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: Distribution CA 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: Record Status The record status.

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

AH1-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP198
Element: Date          The date used for posting the
                       transactions to the general ledger.

AH1-OPERATOR           Alpha 10                                  AP198
Element: Operator Code 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 ID

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 4                                 AP198
Element: Sequence NumbeUsed by the system to track the last
                       payment record number used for the
                       invoice.

AH1-LAST-PMT-SEQ       Numeric 4                                 AP198
Element: 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
Invoice Reference      Indicates the type of number the vendor
Type                   is providing to reference the invoice.

AH1-APPROVED-FLAG      Alpha 1                                   AP198
Element: Approved

AH1-APPRV-OPERATOR     Alpha 10                                  AP198
Element: Operator Code

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: Journal Book  The journal book assigned to the
                       transaction.

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

AH1-OBJ-ID             Numeric 12                                AP198
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.

AH1-RECON-DATE         Numeric 8  (yyyymmdd)                     AP198   AP260
Reconciliation or      Represents the date the transaction
Void Date              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: Terms Code

AH1-RCPT-INV-DATE      Numeric 8  (yyyymmdd)                     AP198
Element: Date

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 Code This field contains a valid stocking
                       location within the company inventory.

AH1-MATCH-OBJ-ID       Numeric 12                                AP198
Object
Identification

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 AdjustmentThis 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: Original Line Number

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

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

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 Description

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 Flag 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: Shipping Term The user defined Free On Board Code.

AH1-TAX-OUT-BAL        Derived
Tax Out of Balance
Amount

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
Payment Out Of
Balance Amount

AH1-DIST-OUT-BAL       Derived
Distrib. Out Of
Balance Amount

AH1-OUT-BAL-FLAG       Derived
Out of Balance
Indicator

AH1-INV-STATUS         Derived
Element: Invoice 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
Journal Book           The journal book sequence number
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
Element: Flex Deduction

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

AH1-FLOAT-DAYS         Numeric 3
Element: Float Days

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

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

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

AH1-COCO-FL            Numeric 1
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
Element: Intl Amt

AH1-HASH-QTY           Signed 15.4
Element: Hash Qty

AH1-XREF-VENDOR        Alpha 9  (Right Justified)
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
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
Element: Intl Amt

AH1-DISC-POINT         Numeric 1
Element: Disc Point

                         APAPIHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AH1SET1   COMPANY                                                AP00.4  AP00.5
          VENDOR                                                 AP01.1  AP115
          INVOICE                                                AP125   AP126
          SUFFIX                                                 AP131   AP180
          CANCEL-SEQ                                             AP181   AP190
                                                                 AP212   AP245
                                                                 AP25.1  AP25.2
                                                                 AP255   AP26.1
                                                                 AP260   AP27.1
                                                                 AP270   AP275
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP300
                                                                 AP305   AP32.1
                                                                 AP45.1  AP520
                                                                 AP91.1  AP93.2
                                                                 ...

AH1SET10  COMPANY       KeyChange                                AP260
          RECON-DATE
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ

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
          VENDOR
          MATCH-OBJ-ID
          INVOICE
          SUFFIX
          CANCEL-SEQ

AH1SET3   REC-STATUS    KeyChange                                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