Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APINVOICE


                             APINVOICE FILE

                        Accounts Payable Invoice

The Accounts Payable Invoice file contains accounts payable invoice records.
Each record has one or more associated records in the Invoice Payment File.

REFERENCED BY

POA3.1    AP00.4    AP00.5    AP01.1    AP13.2    AP141
AP150     AP151     AP155     AP156     AP160     AP161
AP175     AP176     AP197     AP212     AP213     AP220
AP230     AP237     AP240     AP245     AP250     AP252
AP255     AP270     AP272     AP275     AP282     AP284
AP295     AP40.1    AP56.2    AP90.1    AP90.3    AP90.2
AP90.4    AP91.1    AP92.2    AP92.1    AP95.1    APCP.1
APH1.1    AR48.3    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL820     BL92.1    CB06.2    EE20.1    EE20.2    EE20.4
EE230     EE30.1    EE90.1    EE90.2    IC28.1    MA00.1
MA05.1    MA126     MA180     MA278     MA530     MA531
MA540     MA63.1    MA64.6    MA67.1    MA67.2    MA68.1
MA80.1    MAED.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     PO135     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    PR277     UK277     RQ10.1    RQ10.2
WH20.2    WH20.7    PO58.2    MA236     AP236     AP235
AM115     AM117     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP10.1    AP251     API3.1    API4.1
IC840     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    UK47.1

UPDATED BY

AP101     AP115     AP125     AP126     AP130     AP131
AP170     AP180     AP181     AP190     AP191     AP193
AP195     AP198     AP25.1    AP25.2    AP25.3    AP26.1
AP260     AP27.1    AP28.1    AP28.2    AP30.1    AP30.2
AP30.3    AP30.4    AP300     AP305     AP32.1    AP35.1
AP36.1    AP45.1    AP520     AP55.2    AP700     API1.1
API2.1    EE135     EE35.1    EE35.2    EE520     MA310
MA60.2    MA60.3    MA60.4    MA61.1    MA65.1    MA66.2
MA66.3    MA70.1    MA75.1    MAI1.1    TX101

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

API-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company associated with the           AP150   AP180
                       invoice. Must be a valid record in the    AP181   AP190
                       Accounts Payable Company file.            AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.3
                                                                 AP300   AP32.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-VENDOR             Alpha 9  (Right Justified)                AP115   AP125
Element: Vendor ID     The invoiced vendor number. Must be a     AP126   AP150
                       valid record in the Vendor file.          AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.3  AP300
                                                                 AP32.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-INVOICE            Alpha 22                                  AP115   AP125
Element: Invoice NumberThe invoice number. Must be a unique      AP126   AP150
                       invoice number for the vendor.            AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.3  AP300
                                                                 AP32.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-SUFFIX             Numeric 3                                 AP125   AP126
Element: Invoice SuffixThe invoice suffix number. Represents     AP150   AP170
                       the occurrence value of the invoice.      AP180   AP181
                       Used to identify the recurrence value of  AP190   AP193
                       a recurring invoice and for               AP25.1  AP25.2
                       system-generated credit memos created     AP26.1  AP27.1
                       for prepayments and employee advances.    AP28.1  AP28.2
                                                                 AP30.2  AP30.3
                                                                 AP300   AP32.1
                                                                 AP45.1  AP520
                                                                 API1.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-CANCEL-SEQ         Numeric 4                                 AP125   AP126
Element: Sequence NumbeThe sequence number assigned upon the     AP150   AP180
                       cancellation of a distributed invoice.    AP181   AP190
                       The first sequence assigned is 9999.      AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.3
                                                                 AP30.4  AP300
                                                                 AP32.1  AP45.1
                                                                 API1.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AP180   AP181
Element: Cancel Date   The cancellation date assigned to a       AP190   AP26.1
                       canceled invoice.                         AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  MA70.1
                                                                 MA75.1

API-BATCH-NUM          Numeric 6                                 AP125   AP126
Element: Batch Number  The batch number associated with the      AP180   AP181
                       invoice. Used only if the company has     AP190   AP25.1
                       Yes selected in the Batch Release Option  AP25.2  AP25.3
                       field.                                    AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-BATCH-DATE         Numeric 8  (yyyymmdd)                     AP180   AP181
Element: Batch Date    The batch date assigned to the batch      AP190   AP26.1
                       number. Must be a valid record in the     AP27.1  AP28.1
                       Batch file.                               AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1

API-VOUCHER-NBR        Alpha 10                                  AP125   AP126
Element: Voucher       The voucher number assigned to the        AP180   AP181
                       invoice. Used only if the company has     AP190   AP25.1
                       Yes selected in the Invoice Registration  AP25.2  AP26.1
                       Option field.                             AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-AUTH-CODE          Alpha 3                                   AP125   AP126
Element: Authority CodeThe authority code assigned to the        AP180   AP181
                       invoice. Represents the person or         AP190   AP25.1
                       department responsible for approving a    AP25.2  AP26.1
                       registered invoice and is required        AP27.1  AP28.1
                       before a registered invoice can be        AP28.2  AP36.1
                       released. Used only by a company that     AP45.1  AP520
                       has Yes selected in the Invoice Approval  API1.1  API2.1
                       field and No in the Batch Release field.  EE135   EE35.1
                       Must be a valid record in the Authority   EE35.2  EE520
                       Code file.                                MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-PROC-LEVEL         Alpha 5                                   AP125   AP126
Element: Process Level The process level assigned to the         AP180   AP181
                       invoice. Must be a valid record in the    AP190   AP25.1
                       Accounts Payable Process Level file.      AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-ACCR-CODE          Alpha 4                                   AP125   AP126
Element: Invoice AccruaThe invoice accrual code assigned to      AP180   AP181
                       the invoice. Used to default a general    AP190   AP25.1
                       ledger accrual account to the invoice.    AP25.2  AP26.1
                       Must be a valid record in the Invoice     AP27.1  AP28.1
                       Accrual Code file.                        AP28.2  AP30.1
                                                                 AP32.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-INVOICE-TYPE       Alpha 1                                   AP125   AP126
Element: Invoice Type  Identifies the type of invoice. Valid     AP170   AP180
                       values are:                               AP181   AP190
                                                                 AP25.1  AP25.2
                       Blank = Invoice. Increases the amount     AP26.1  AP27.1
                       owed to the vendor. If the invoice is     AP28.1  AP28.2
                       fully processed, the vendor's purchase    AP45.1  AP520
                       and payment balances will be increased.   API1.1  API2.1
                                                                 EE135   EE35.1
                       C = Credit Memo. Reduces the amount       EE35.2  EE520
                       owed to the vendor. If the invoice is     MA310   MA60.1
                       fully processed, the vendor's purchase    MA60.2  MA60.3
                       and payment balances will be decreased.   MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                       D = Debit Memo. Processed just like an    MA67.1  MA67.2
                       invoice. Increase the vendor's purchase   MA68.1  MA70.1
                       and payment balances.                     MA75.1

                       P = Prepayment. Processed just like an
                       invoice. Used to pay a vendor for goods
                       or services not yet received.

                       Y = Prepayment Credit Memo. Created by
                       AP170 (Payment Closing) to offset a
                       prepayment and are applied to the
                       vendor's invoice after it has been
                       received.

                       A = Employee Advance. Processed just
                       like an invoice. Used to pay an employee
                       for expenses not yet incurred.

                       M = Employee Advance Credit Memo.
                       Created by AP170 (Payment Closing) to
                       offset an employee advance. Can be
                       applied to the employee's expense after
                       it has been received.

                       E =  Employee Expense. Processed just
                       like an invoice.
                       R = Match Prepayment

API-INV-CURRENCY       Alpha 5                                   AP125   AP126
Element: Invoice CurrenThe currency of the invoice. Must be a    AP180   AP181
                       valid record in the Currency Code file.   AP190   AP25.1
                       If left blank, the vendor currency        AP25.2  AP26.1
                       defaults.                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-PAY-CURRENCY       Alpha 5                                   AP125   AP126
To Company Base        The currency used to pay the invoice.     AP180   AP181
Currency               Must be a valid record in the Currency    AP190   AP25.1
                       Code file.                                AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-INVOICE-DTE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Invoice Date  The date assigned to the invoice. Used    AP170   AP180
                       when updating the vendor's purchase       AP181   AP190
                       balance. If left blank, the system date   AP193   AP25.1
                       defaults.                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-PURCH-FR-LOC       Alpha 4                                   AP115   AP125
Purchase From          The purchase-from location code           AP126   AP180
Location Code          associated with the invoice. Must be a    AP181   AP190
                       valid record in the Vendor Location       AP25.1  AP25.2
                       file.                                     AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-PO-NUMBER          Alpha 14  (Right Justified)               AP125   AP126
Element: PO Number     This field contains the number            AP180   AP181
                       representing the purchase order.          AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-PO-RELEASE         Numeric 4                                 AP125   AP126
Element: PO Release NumThe purchase order release number         AP180   AP181
                       associated with the invoice. Used to      AP190   AP25.1
                       identify a purchase order release         AP25.2  AP26.1
                       created from a blanket or standing        AP27.1  AP28.1
                       order.                                    AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-PO-CODE            Alpha 4                                   AP125   AP126
Element: Purchase OrderPurchase order number code. Used to       AP180   AP181
                       keep purchase orders unique. Can be used  AP190   AP25.1
                       for reporting purposes.                   AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-DESCRIPTION        Alpha 30  (Lower Case)                    AP180   AP181
Element: Description   The invoice description.                  AP190   AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

API-BASE-INV-AMT       Signed 18.2                               AP125   AP126
Element: Base Invoice AThe amount of the invoice in the          AP170   AP180
                       company base currency. This amount is     AP181   AP190
                       calculated based on the currency          AP193   AP25.1
                       exchange rate in effect when the invoice  AP25.2  AP26.1
                       was created or entered.                   AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-BASE-ACT-AMT       Signed 18.2                               AP125   AP126
Revalued Base          The amount of the invoice in the          AP170   AP180
Invoice Amount         company base currency. For non-base       AP181   AP190
                       currency invoices, this amount is         AP191   AP193
                       updated when currency revaluation takes   AP25.1  AP25.2
                       place.                                    AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-BASE-ND            Numeric 1                                 AP125   AP126
Base Number Of         The number of decimal places defined      AP180   AP181
Decimals               for the company base currency.            AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-TRAN-INV-AMT       Signed 18.2                               AP125   AP126
Element: Intl Amt      The amount of the invoice in the          AP180   AP181
                       currency of the invoice.                  AP190   AP25.1
                                                                 AP25.2  AP25.3
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-TRAN-ALOW-AMT      Signed 18.2                               AP125   AP126
Element: Intl Amt      The amount of the invoice available for   AP180   AP181
                       discount in the currency of the invoice.  AP190   AP25.1
                       Used to calculate the discount amount     AP25.2  AP26.1
                       based on the discount rate. If left       AP27.1  AP28.1
                       blank, the invoice amount defaults.       AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-TRAN-TXBL-AMT      Signed 18.2                               AP125   AP126
Element: Intl Amt      The taxable amount of the invoice in      AP180   AP181
                       the currency of the invoice.              AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   AP700
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-TRAN-ND            Numeric 1                                 AP125   AP126
Account Currency       The number of decimal places defined      AP180   AP181
Code                   for the invoice currency.                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-TRAN-TAX-AMT       Signed 18.2                               AP125   AP126
Element: Intl Amt      The tax amount of the invoice in the      AP180   AP181
                       currency of the invoice.                  AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-BASE-DISC-AMT      Signed 18.2                               AP125   AP126
Element: Intl Amt      The discount amount of the invoice in     AP170   AP180
                       the company base currency.                AP181   AP190
                                                                 AP191   AP193
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-TRAN-DISC-AMT      Signed 18.2                               AP125   AP126
Element: Intl Amt      The discount amount of the invoice in     AP180   AP181
                       the currency of the invoice.              AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-BASE-TOT-PMT       Signed 18.2                               AP125   AP126
Base Total Payment     The total payment amount created for      AP170   AP180
Amount                 the invoice in the company base           AP181   AP190
                       currency.                                 AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-TRAN-TOT-PMT       Signed 18.2                               AP125   AP126
Element: Intl Amt      The total payment amount created for      AP170   AP180
                       the invoice in the currency of the        AP181   AP190
                       invoice.                                  AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-BASE-TOT-DIST      Signed 18.2                               AP125   AP126
Base Total             The total distribution amount of the      AP170   AP180
Distribution Amount    invoice in the company base currency.     AP181   AP190
                                                                 AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-TRAN-TOT-DIST      Signed 18.2                               AP125   AP126
Element: Intl Amt      The total distribution amount of the      AP170   AP180
                       invoice in the currency of the invoice.   AP181   AP190
                                                                 AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-TRAN-TOT-TAX       Signed 18.2                               AP125   AP126
Element: Intl Amt      The total tax amount of the invoice in    AP180   AP181
                       the currency of the invoice.              AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-TRAN-TOT-TXBL      Signed 18.2                               AP520   AP700
Element: Intl Amt      The total taxable amount for the invoice  API1.1
                       distributions in currency of invoice.

API-TRAN-PAID-AMT      Signed 18.2                               AP170   AP180
Element: Intl Amt      The total amount of the invoice paid to   AP181   AP190
                       date in the currency of the invoice.      AP193   AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA70.1
                                                                 MA75.1

API-ORIG-CNV-RATE      Signed 14.7                               AP125   AP126
Element: Account Rate  The currency exchange rate used to        AP170   AP180
                       convert the invoice amount to the         AP181   AP190
                       company base currency. This field may be  AP193   AP25.1
                       updated if the invoice is revalued to     AP25.2  AP26.1
                       account for exchange rate fluctuations.   AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-ANTICIPATION       Alpha 1                                   AP180   AP181
Element: Anticipation FIndicates whether anticipation criteria   AP190   AP28.1
                       will be used to calculate the discount    AP28.2  AP45.1
                       amount of the invoice. Valid values are:  AP520   API1.1
                                                                 API2.1  EE135
                       N = No.                                   EE35.1  EE35.2
                       Y = Yes.                                  EE520

API-DISCOUNT-RT        Percent 5.3  (Percent)                    AP125   AP126
Element: Discount Rate The discount rate used to calculate the   AP180   AP181
                       discount amount of the invoice.           AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-DISC-DATE          Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          The discount date of the invoice. Used    AP170   AP180
                       to determine whether a discount will be   AP181   AP190
                       taken on an invoice.                      AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.3  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-DUE-DATE           Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Due Date      The invoice due date. Used to schedule    AP170   AP180
                       the invoice for payment.                  AP181   AP190
                                                                 AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.3
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-NBR-SPLIT-PMT      Numeric 3                                 AP180   AP181
Element: Nbr Of Invcs  Used for split payment invoices to        AP190   AP28.1
                       indicate the total number of payments to  AP28.2  AP30.3
                       be made for the invoice.                  AP45.1

API-SPLIT-PMT-SCH      Alpha 1                                   AP180   AP181
Split Payment          Used for split payment invoices to        AP190   AP28.1
Schedule               indicate the frequency of payments to be  AP28.2  AP30.3
                       made for the invoice. The invoice, due,   AP45.1
                       and discount dates are incremented
                       according the schedule selected. Valid
                       values are:

                       W = Weekly.
                       M = Monthly.
                       Q = Quarterly.
                       S = Semiannually.
                       Y = Yearly.
                       Blank = Not a split payment invoice.

API-NBR-RECUR-PMT      Numeric 3                                 AP180   AP181
Element: Nbr Of Invcs  Used for recurring invoices to indicate   AP190   AP193
                       the number of times the invoice will      AP28.1  AP28.2
                       recur.                                    AP30.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1

API-RECUR-FREQ         Alpha 1                                   AP180   AP181
Element: Recurring FreqUsed for recurring invoices to indicate   AP190   AP193
                       how often the invoice should recur.       AP28.1  AP28.2
                       Valid values are:                         AP30.1  AP45.1
                                                                 AP520   API1.1
                       W = Weekly.                               API2.1
                       M = Monthly.
                       Q = Quarterly.
                       S = Semiannually.
                       Y = Yearly.
                       Blank = Not a recurring invoice.
                       E = End of Month

API-REMIT-TO-CODE      Alpha 4                                   AP115   AP180
Remit To Location      The remit-to location code associated     AP181   AP190
Code                   with the invoice. Must be a valid record  AP28.1  AP28.2
                       in the Vendor Location file.              AP30.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-CASH-CODE          Alpha 4                                   AP115   AP180
Element: Cash Code     The cash code assigned to the invoice.    AP181   AP190
                       Represents the bank account the invoice   AP28.1  AP28.2
                       is to be paid from. Must be a valid       AP45.1  AP520
                       record in the Cash Code file.             API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520

API-BANK-INST-CODE     Alpha 3                                   AP115   AP180
Element: Payment Code  The payment code assigned to the          AP181   AP190
                       invoice. Represents the type of cash      AP28.1  AP28.2
                       payment or bill of exchange payment used  AP45.1  AP520
                       to pay the invoice. Must be a valid cash  API1.1  API2.1
                       payment transaction code record in the    EE135   EE35.1
                       Bank Transaction Code file.               EE35.2  EE520

API-CURR-RECALC        Alpha 1                                   AP180   AP181
Currency               Used for non-base currency invoices to    AP190   AP28.1
Recalculation          indicate whether the invoice will be      AP28.2  AP45.1
                       revalued when it is scheduled for         AP520   AP55.2
                       payment to account for currency exchange  API1.1  API2.1
                       rate fluctuations. Valid values are:      EE135   EE35.1
                                                                 EE35.2  EE520
                       N = No.
                       Y = Yes.

API-TAX-CODE           Alpha 10                                  AP125   AP126
Element: Tax Code      The tax code or tax table code applied    AP180   AP181
                       to the invoice. Used to calculate         AP190   AP25.1
                       invoice tax information. Must be a valid  AP25.2  AP26.1
                       record in the Tax Code file.              AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-INCOME-CODE        Alpha 4                                   AP180   AP181
Element: Income Code   The income code associated with the       AP190   AP28.1
                       invoice. Used to track vendor income for  AP28.2  AP45.1
                       the invoice. Must be a valid record in    AP520   API1.1
                       the Income Code file.                     API2.1

API-DIST-CODE          Alpha 9                                   AP180   AP181
Element: Distribution CThe distribution code assigned to the     AP190   AP28.1
                       invoice. Used during invoice entry to     AP28.2  AP45.1
                       automatically create distributions for    AP520
                       the invoice. Must be a valid record in
                       the Distribution Code file.

API-REC-STATUS         Numeric 1                                 AP125   AP126
Element: Record Status The status of the invoice record. Valid   AP170   AP180
                       values are:                               AP181   AP190
                                                                 AP25.1  AP25.2
                       0 = Unreleased. Not available for         AP26.1  AP27.1
                       payment.                                  AP28.1  AP28.2
                       1 = Released. Available for payment.      AP30.4  AP45.1
                       9 = Historical. Paid and closed.          AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA66.2
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

API-CREATE-DATE        Numeric 8  (yyyymmdd)                     AP170   AP180
Element: Creation Date The date the invoice was created in the   AP181   AP190
                       Lawson Accounts Payable system.           AP193   AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Post Date     The date used for posting invoice         AP170   AP180
                       distributions to the general ledger.      AP181   AP190
                                                                 AP193   AP195
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-OPERATOR           Alpha 10                                  AP125   AP126
Element: Operator Code The operator associated with the          AP180   AP181
                       invoice.                                  AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-CREATION-TIME      Numeric 6  (hhmmss)                       AP170   AP180
Element: Creation Time The time the invoice was created in the   AP181   AP190
                       Lawson Accounts Payable system.           AP193   AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-VENDOR-GROUP       Alpha 4                                   AP125   AP126
Element: Vendor Group  The vendor group associated with the      AP180   AP181
                       invoice. Must be a valid record in the    AP190   AP25.1
                       Vendor Group file.                        AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-PAY-VENDOR         Alpha 9  (Right Justified)                AP115   AP180
Element: Pay Vendor    The pay vendor for the invoice.           AP181   AP190
                       Represents the vendor that receives       AP28.1  AP28.2
                       payment for the invoice. Must be a valid  AP30.1  AP45.1
                       record in the Vendor file.                AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-PAY-GROUP          Alpha 4                                   AP101   AP125
Element: Pay Group     The pay group associated with the         AP126   AP180
                       invoice. A pay group is used for          AP181   AP190
                       processing accounts payable payments.     AP25.1  AP25.2
                       Must be a valid record in the Pay Group   AP26.1  AP27.1
                       file.                                     AP28.1  AP28.2
                                                                 AP30.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-INVOICE-GROUP      Alpha 4                                   AP115   AP180
Element: Invoice Group The invoice group assigned to the         AP181   AP190
                       invoice. An invoice group is a            AP28.1  AP28.2
                       user-defined character expression that    AP45.1  AP520
                       can be used to select invoices for        API1.1  API2.1
                       payment. The same invoice group can be    EE135   EE35.1
                       assigned to more than one invoice.        EE35.2  EE520

API-LAST-DIST-SEQ      Numeric 4                                 AP125   AP126
Element: Sequence NumbeUsed by the system to track the number    AP170   AP180
                       of the last distribution line created     AP181   AP190
                       for the invoice.                          AP191   AP193
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA66.2  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-LAST-PMT-SEQ       Numeric 4                                 AP170   AP180
Element: Sequence NumbeUsed by the system to track the last      AP181   AP190
                       payment record number used for the        AP193   AP28.1
                       invoice.                                  AP28.2  AP30.3
                                                                 AP35.1  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-DISCOUNT-CODE      Alpha 10                                  AP125   AP126
Element: Discount Code The discount code assigned to the         AP180   AP181
                       invoice. Represents a general ledger      AP190   AP25.1
                       discount account. Must be a valid record  AP25.2  AP26.1
                       in the Discount Code file.                AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-INVOICE-SOURCE     Alpha 1                                   AP180   AP181
Element: Invoice SourceIndicates the source for creation of      AP190   AP28.1
                       the invoice. Valid values are:            AP28.2  AP45.1
                                                                 AP520   API1.1
                       Blank = Manual entry.                     API2.1
                       E = Electronic Data Interchange (EDI).
                       R = Evaluated Receipts Settlement (ERS).
                       P = Payroll
                       T = Tax
                       G = Garnishment
                       L = Lease
                       C = AR Transfer
                       S = Sub Contractor
                       X = Expense Interface

API-INVC-REF-TYPE      Alpha 2                                   AP180   AP181
Invoice Reference      Indicates the type of number the vendor   AP190   AP28.1
Type                   is providing to reference the invoice.    AP28.2  AP45.1
                       Valid values are:                         AP520   API1.1
                                                                 API2.1
                       BM = Bill of Lading.
                       IN = Invoice.
                       OW = Service Order.
                       PL = Packing List.
                       PO = Purchase Order Number.
                       VN = Vendor Order.
                       WO = Work Order.
                       WP = Warehouse Pick Ticket.
                       ZZ = Mutually Defined.

API-APPROVED-FLAG      Alpha 1                                   AP125   AP126
Element: Approved      Indicates whether the invoice is          AP170   AP180
                       approved for payment. Valid values are:   AP181   AP190
                                                                 AP25.1  AP25.2
                       Y = Yes.                                  AP26.1  AP27.1
                       N = No.                                   AP28.1  AP28.2
                       D = Disapproved                           AP32.1  AP36.1
                       M = Message Exists                        AP45.1  AP520
                       P = Message Pending Action                API1.1  API2.1
                       R = Match Prepayment                      EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA65.1
                                                                 MA66.2  MA66.3
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-APPRV-OPERATOR     Alpha 10                                  AP180   AP181
Element: Operator Code If the invoice required approval, this    AP190   AP28.1
                       field contains the operator that          AP28.2  AP32.1
                       approved the invoice.                     AP36.1  AP45.1
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

API-RETURN-NUMBER      Numeric 10                                AP180   AP181
Element: Return Number If the goods associated with the          AP190   AP28.1
                       invoice were returned, this field         AP28.2  AP45.1
                       contains the optional return number       API1.1  API2.1
                       assigned to the return.

API-JRNL-BOOK-NBR      Alpha 12                                  AP180   AP181
Element: Journal Book  The journal book assigned to the          AP190   AP28.1
                       transaction.                              AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-TAX-POINT          Alpha 1                                   AP180   AP181
Element: Tax Point     Indicates when the tax amount is          AP190   AP28.1
                       calculated for the invoice, if            AP28.2  AP30.2
                       applicable. Valid values are:             AP45.1  AP520
                                                                 API1.1  API2.1
                       I = Invoice.
                       P = Payment.
                       G = GL Post Date

API-OBJ-ID             Numeric 12                                AP125   AP126
Element: Object ID     A subsystem object interface              AP170   AP180
                       identification number. Used to identify   AP181   AP190
                       the Invoice Distribution and Asset        AP193   AP25.1
                       Detail records that are associated with   AP25.2  AP26.1
                       the invoice. Also used for Drill Around   AP27.1  AP28.1
                       purposes.                                 AP28.2  AP32.1
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-RECON-DATE         Numeric 8  (yyyymmdd)                     AP125   AP126
Reconciliation or      Represents the date the transaction       AP180   AP181
Void Date              cleared the bank or was voided.           AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP260   AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  API1.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-POD-PRINTED        Numeric 1                                 AP125   AP126
Proof of Delivery      Indicates is a proof of delivery has      AP130   AP180
Printed                been printed for this invoice.            AP181   AP190
                                                                 AP25.1  AP25.2
                       Valid values are:                         AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                        Y = Yes                                  AP45.1  AP520
                       " " = No                                  API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-MATCH-REF-NBR      Alpha 22                                  AP125   AP126
Match Reference        Matching reference number. This is a      AP180   AP181
Number                 user defined number used for matching.    AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-MATCH-FL           Alpha 1                                   AP125   AP126
Element: Match Invoice Indicates if the invoice is a match       AP180   AP181
                       invoice.                                  AP190   AP25.1
                       A = AOC Invoice                           AP25.2  AP26.1
                       Y = PO Invoice                            AP27.1  AP28.1
                       N = Exp Invoice                           AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-TERMS-CD           Alpha 5                                   AP125   AP126
Element: Terms Code    Invoice payment terms code.               AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-RCPT-INV-DATE      Numeric 8  (yyyymmdd)                     AP125   AP126
Receipt of Invoice     The date the invoice was received. If     AP180   AP181
Date                   left blank, the system date defaults.     AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-RETAIL-AMT         Signed 18.2                               AP125   AP126
Element: Retail Amount The retail amount of the item.            AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-MATCH-STATUS       Numeric 1                                 AP125   AP126
Element: Match Status  Indicates the match status of the         AP180   AP181
                       invoice.                                  AP190   AP25.1
                                                                 AP25.2  AP26.1
                       Valid values are:                         AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                       0 = Unmatched                             AP520   API1.1
                       1 = Out of tolerance                      API2.1  MA310
                       2 = Matched                               MA60.1  MA60.2
                       3 = Matched out of tolerance              MA60.3  MA60.4
                       4 = Matched in tolerance                  MA61.1  MA63.1
                       5 = Matched with auto chargeback          MA65.1  MA66.2
                       6 = Approved No Receipt (MA61)            MA66.3  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-REASON-CODE        Alpha 4                                   AP125   AP126
Element: Reason Code   This field contains the reason code,      AP180   AP181
                       which indicates the cause for credit      AP190   AP25.1
                       memos.                                    AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-HANDLING-CODE      Alpha 4                                   AP125   AP126
Invoice Handling       Invoice handling code. The invoice        AP180   AP181
Code                   handling code contains processing rules   AP190   AP25.1
                       for invoice matching.                     AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-MATCH-AMT          Signed 18.2                               AP125   AP126
Element: Match Amount  Match amount. Represents the goods        AP180   AP181
                       amount on which the invoice will match    AP190   AP25.1
                       to a receipt.                             AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP45.1  AP520
                                                                 API1.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-AOC-ALLOW-AMT      Signed 18.2                               AP125   AP126
Element: Add On Cost AmAdd on cost amount.                       AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-LOCATION           Alpha 5                                   AP125   AP126
Element: Location Code This field contains a valid stocking      AP180   AP181
                       location within the company inventory.    AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-MATCH-OBJ-ID       Numeric 12                                AP125   AP126
Element: Match Object IA system generated matching object        AP180   AP181
                       identifier.                               AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA66.2  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-CBPRINT-FL         Alpha 1                                   AP131   AP180
Element: Print ChargebaIndicates whether to print chargebacks.   AP181   AP190
                       N = No                                    AP28.1  AP28.2
                       Y = Yes                                   AP30.1  AP45.1
                       " " = spaces                              AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520

API-MATCH-TABLE        Alpha 10                                  AP125   AP126
Element: Match Table   Match table. Contains matching and        AP180   AP181
                       match processing rules.                   AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-TAX-CODE-CNTL      Alpha 1                                   AP125   AP126
Element: Tax Code ContrThis control field defines the tax code   AP180   AP181
                       usage in invoicing and approving taxes.   AP190   AP25.1
                                                                 AP25.2  AP26.1
                       For PO Invoices, if set to O (Override)   AP27.1  AP28.1
                       all lines approved for payment will use   AP28.2  AP45.1
                       the tax code defined for the whole        API1.1  API2.1
                       invoice.                                  MA310   MA60.1
                                                                 MA60.2  MA60.3
                       If set to I (Ignore) no PO lines          MA60.4  MA61.1
                       approved for payment will be taxed.       MA63.1  MA65.1
                       0 = No Tax                                MA67.1  MA67.2
                       1 = Override Product Only                 MA68.1  MA70.1
                       2 = Ignore Product Only                   MA75.1
                       3 = Calculate
                       4 = Overide Product and AOC
                       5 = Ignore Product and AOC
                       6 = ignore tax tol ovr goods tax
                       7 = ignore tax tol ovr goods/aoc t

API-LAST-MATCH-LN      Numeric 4                                 AP125   AP126
Element: Last Match LinLast matched line number.                 AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-MATCH-LEVEL        Alpha 3                                   AP180   AP181
Element: Match Level   Indicates whether the invoice was         AP190   AP28.1
                       matched at the invoice or detail level.   AP28.2  AP45.1
                                                                 MA61.1  MA66.2
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-MATCH-DATE         Numeric 8  (yyyymmdd)                     AP180   AP181
Element: Match Date    The date the invoice was matched.         AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 MA61.1  MA66.2
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-PO-INV-TAX         Signed 18.2                               AP125   AP126
Element: Invoiced Tax  The amount of invoiced tax that will be   AP180   AP181
                       generated on the invoice from taxable     AP190   AP25.1
                       add on costs and taxable purchase order   AP25.2  AP26.1
                       receipt lines assigned to the invoice.    AP27.1  AP28.1
                       The resulting value is then used to       AP28.2  AP45.1
                       compute the invoice match amount when no  API1.1  MA310
                       tax code has been assigned to the         MA60.1  MA60.2
                       invoice.                                  MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

API-BYPASS-MATCH       Alpha 1                                   AP125   AP126
Element: All Flag                                                AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-SERVICE-FL         Alpha 1                                   AP125   AP126
Element: Service Fl    This field indicates a transaction is a   AP180   AP181
                       Service only transaction.                 AP190   AP25.1
                       Y = Yes                                   AP25.2  AP26.1
                       N = No                                    AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-SERVICE-AMT        Signed 18.2                               AP125   AP126
Element: Intl Amt                                                AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-BUYER              Alpha 3                                   AP125   AP126
Element: Buyer                                                   AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-FINAL-DST-FLAG     Alpha 1                                   AP30.2
Element: Final Dst Flag

API-NOTC               Alpha 2                                   AP180   AP181
Element: Notc          The Nature of Transaction code.  Must     AP190   AP28.1
                       be a valid code defined in IN07.1 (NOTC   AP28.2  AP45.1
                       Maintenance).                             API1.1

API-STAT-PROC          Alpha 6                                   AP180   AP181
Element: Stat Proc     The statistical procedure code applied    AP190   AP28.1
                       to the data.  The code must be defined    AP28.2  AP45.1
                       in IN06.1. (Statistical Procedure         API1.1
                       Maintenance).

API-SHIP-VIA           Alpha 12  (Lower Case)                    AP180   AP181
Element: Ship Via Description                                    AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1

API-UNLOADING-PORT     Alpha 5                                   AP180   AP181
Element: Unloading PortThe prot where the goods are unloaded if  AP190   AP28.1
                       required.  Must be defined in IN04.1      AP28.2  AP45.1
                       (Port Maintenance)                        API1.1

API-INTRASTAT-NBR      Numeric 12                                AP125   AP126
Element: Intrastat Nbr The number assigned by the Intrastat      AP180   AP181
                       system to a transaction that involves     AP190   AP25.1
                       Intrastat reporting after it has been     AP25.2  AP26.1
                       added.                                    AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1

API-DROPSHIP-FL        Alpha 1                                   AP125   AP126
Element: Dropship Flag This flag indicates whether goods being   AP180   AP181
                       shipped by the vendor directly to a non   AP190   AP25.1
                       standard location need to have the        AP25.2  AP26.1
                       receiving process performed.              AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

API-FOB-CODE           Alpha 3                                   AP180   AP181
Element: Shipping Term The user defined Free On Board Code.      AP190   AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1

API-NET-PAYABLE        Derived
Element: Net Apyable   The net payment amount in the currency
                       of the invoice.

API-JBK-SEQ-NBR        Numeric 10                                AP170   AP180
Journal Book           The journal book sequence number          AP181   AP190
Sequence Number        assigned to a journal book transaction    AP193   AP28.1
                       when it is added or interfaced to the     AP28.2  AP45.1
                       Lawson system. Used only when  Auto       AP520   API1.1
                       Journal Book Seq Nbr is set to Yes in     API2.1  EE135
                       GL10.1 (Company).                         EE35.1  EE35.2
                                                                 EE520

API-DIVERSE-CODE       Alpha 5                                   AP115   AP520
Element: Diverse Code  Diversity Code for Account Payable        API1.1
                       Vendors

API-FLEX-FLAG          Alpha 1                                   AP520
Element: Flex Deduction

API-RULE-GROUP         Alpha 10                                  AP125   AP126
Element: Rule Group                                              AP180   AP181
                                                                 AP190   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1  API2.1
                                                                 MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

API-FLOAT-DAYS         Numeric 3
Element: Float Days    This is a number of days to add to best
                       terms calculation if the vendor will
                       allow a specific number of days for
                       payment to reach them and still receive
                       the discount.

API-MTCH-PREPAY-FL     Alpha 1
Element: Mtch Prepay FlFlag that notes if the invoice will be
                       prepaid.  This is for match invocies.
                       " " = Blank
                       1 = Yes
                       2 = No

API-MTCH-PREPAY-MT     Numeric 1
Element: Mtch Prepay MtFlag denotes the method of match
                       prepayment.
                       0 = No
                       1 = Prepay from Invoice
                       2 = Eligible for Prepayment

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

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

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

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

API-PRPY-AMT           Signed 18.2
Element: Intl Amt

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

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

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

API-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)

API-MATCH-AOC          Signed 18.2
Element: Intl Amt      This is the amount of the AOC that has
                       been matched.

API-HASH-QTY           Signed 15.4
Element: Hash Qty      This is the total qty of the goods on
                       the invoice.  This field will be used to
                       match on qty.

API-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.

API-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

API-BT-AMT             Signed 18.2
Element: Intl Amt      This is the amount of the discount based
                       on best terms

API-DISC-POINT         Numeric 1                                 API2.1
Element: Disc Point    This is the flag that will note if the
                       discounts will be applied to the cost of
                       the goods or the cost of the goods and
                       the AOC.
                       1 = Cost of goods
                       2 = Cost of Goods and AOC

API-TAX-FLAG           Alpha 1                                   TX101
Element: All Flag      " " = Not interfaced
                       I = Interfaced

API-TAX-OUT-BAL        Derived
Tax Out of Balance     The amount of the invoice that is
Amount                 out-of-balance due to tax applications
                       made for the invoice.

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

API-PMT-OUT-BAL        Derived
Payment Out Of         The amount of the invoice that is
Balance Amount         out-of-balance due to payment
                       applications made for the invoice.

API-DIST-OUT-BAL       Derived
Distrib. Out Of        The amount of the invoice that is
Balance Amount         out-of-balance due to expense
                       distribution applications made for the
                       invoice.

API-OUT-BAL-FLAG       Derived
Out of Balance         Indicates whether the invoice is
Indicator              out-of-balance. Valid values are:

                       N = No.
                       Y = Yes.

API-INV-STATUS         Derived
Element: Invoice StatusIndicates the status of the invoice.
                       Valid values are:

                       Unreleased.
                       Released.
                       Historical.

API-REV-SIGN-AMT       Derived
Reversed Signed        The invoice amount * -1.
Amount

API-TYPE-SHORT-NME     Derived
Short Invoice Type     The translation of the invoice type.
Name

API-PO-RELEASE-3       Derived
Purchase Order         The purchase order release number
Release Number         associated with the invoice. Used to
                       identify a purchase order release
                       created from a blanket or standing
                       order.

                         APINVOICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APISET1   COMPANY       This index is used to access invoice     AP00.4  AP00.5
          VENDOR        records for a specific vendor and        AP01.1  AP101
          INVOICE       company.                                 AP115   AP125
          SUFFIX                                                 AP126   AP13.2
          CANCEL-SEQ                                             AP131   AP141
                                                                 AP150   AP151
                                                                 AP155   AP156
                                                                 AP160   AP161
                                                                 AP170   AP175
                                                                 AP176   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP197
                                                                 AP198   AP212
                                                                 AP213   AP220
                                                                 ...

APISET11  COMPANY       KeyChange, Subset                        AP125   AP126
          VENDOR        Where MATCH-REF-NBR != Spaces            AP25.1  AP25.2
          MATCH-REF-NBR                                          AP26.1  AP27.1
          OBJ-ID                                                 API1.1  MA310
                                                                 MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

APISET13  COMPANY       KeyChange                                AP125   AP126
          VENDOR                                                 AP131   AP25.1
          MATCH-OBJ-ID                                           AP25.2  AP26.1
          INVOICE                                                AP27.1  AP30.4
          SUFFIX                                                 API1.1  MA310
          CANCEL-SEQ                                             MA60.1  MA60.2
                                                                 MA60.3  MA60.4
                                                                 MA61.1  MA63.1
                                                                 MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1
                                                                 PO58.2

APISET14  COMPANY       KeyChange, Subset                        AP125   AP126
          VENDOR        Where((MATCH-STATUS = Zeroes )           AP130   AP25.1
          DUE-DATE      Or    (MATCH-STATUS = 1 ))               AP25.2  AP26.1
          INVOICE       And   (MATCH-FL     = "Y" )              AP27.1  API1.1
          SUFFIX        And  ((REC-STATUS   = Zeroes )           MA126   MA236
          CANCEL-SEQ    Or    (REC-STATUS   = 1 ))               MA310   MA60.1
                                                                 MA60.2  MA60.3
                                                                 MA60.4  MA61.1
                                                                 MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1

APISET2   COMPANY       This index is used to access unreleased  AP00.4  AP125
          BATCH-NUM     invoice records for a specific batch or  AP126   AP195
          AUTH-CODE     authority code.                          AP220   AP25.1
          VOUCHER-NBR   KeyChange, Subset                        AP25.2  AP25.3
          VENDOR        Where REC-STATUS = Zeroes                AP26.1  AP27.1
          INVOICE
          SUFFIX
          CANCEL-SEQ

APISET3   REC-STATUS    This index is used to access unreleased  AP193   AP195
          COMPANY       invoice records for a specific batch or  AP198   AP236
          BATCH-NUM     authority code in entry order.           AP25.2  AP300
          AUTH-CODE     KeyChange                                AP36.1  AP700
          OPERATOR
          CREATE-DATE
          CREATION-TIME
          VENDOR
          INVOICE
          SUFFIX
          CANCEL-SEQ

APISET4   COMPANY       This index is used to access invoice     AP00.4  AP235
          VOUCHER-NBR   records for a specific voucher number.   AP260   AP30.1
          REC-STATUS    KeyChange                                AP520   AP90.3
          VENDOR                                                 API1.1  API2.1
          INVOICE                                                AR48.3  TX101
          SUFFIX
          CANCEL-SEQ

APISET5   VENDOR-GROUP  This index is used to access invoice     AM115   AM117
          VENDOR        records not on hold for a specific hold  AM15.1  AM15.2
          INVOICE       code.                                    AM15.3  AM15.4
          SUFFIX        KeyChange                                AM20.1  AM20.3
          CANCEL-SEQ                                             AM21.1  AM21.3
          COMPANY                                                AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP10.1  AP115
                                                                 AP251   AP295
                                                                 AP91.1  AP92.1
                                                                 API3.1  API4.1
                                                                 IC840   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  UK47.1

APISET6   COMPANY       This index is used to access invoice     AP251   AP300
          VENDOR        records for a specific vendor in invoice AP90.2
          INVOICE-DTE*  date sequence.
          INVOICE       KeyChange
          SUFFIX
          CANCEL-SEQ

APISET7   COMPANY       This index is used to access invoice     AP125   AP126
          REC-STATUS    records that are out of balance.         AP240   AP25.1
          BATCH-NUM     KeyChange, Subset                        AP25.2  AP26.1
          VENDOR        Where TRAN-TOT-DIST != TRAN-INV-AMT      AP27.1
          INVOICE       Or    TRAN-TOT-PMT  != TRAN-INV-AMT
          SUFFIX        Or    BASE-TOT-PMT  != BASE-INV-AMT
          CANCEL-SEQ    Or    TRAN-TOT-TAX  != TRAN-TAX-AMT

APISET8   COMPANY       This index is used to access invoices    AP125   AP126
          DUE-DATE      for a specific vendor in descending      AP25.1  AP25.2
          VENDOR        invoice date sequence.                   AP252   AP26.1
          INVOICE       KeyChange, Subset                        AP27.1  API1.1
          SUFFIX        Where((MATCH-STATUS = Zeroes )           MA126   MA310
          CANCEL-SEQ    Or    (MATCH-STATUS = 1 ))               MA60.1  MA60.2
                        And   (MATCH-FL     = "Y" )              MA60.3  MA60.4
                        And  ((REC-STATUS   = Zeroes )           MA61.1  MA63.1
                        Or    (REC-STATUS   = 1 ))               MA65.1  MA67.1
                                                                 MA67.2  MA68.1
                                                                 MA70.1  MA75.1

APISET9   COMPANY       This index is used to access invoice     AP125   AP126
          VENDOR        records for a specific purchase order.   AP141   AP25.1
          PO-NUMBER     KeyChange                                AP25.2  AP26.1
          PO-RELEASE                                             AP27.1  AP90.4
          PO-CODE                                                API1.1  MA126
          LOCATION                                               MA310   MA60.1
          INVOICE                                                MA60.2  MA60.3
          SUFFIX                                                 MA60.4  MA61.1
          CANCEL-SEQ                                             MA63.1  MA65.1
                                                                 MA67.1  MA67.2
                                                                 MA68.1  MA70.1
                                                                 MA75.1  MAI1.1

                         APINVOICE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apauthor       APAUTHOR     Required
                            When API-AUTH-CODE > Spaces

                            API-COMPANY          -> ATR-COMPANY
                            API-AUTH-CODE        -> ATR-AUTH-CODE

Apbatch        APBATCH      Required
                            When API-BATCH-NUM != Zeroes

                            API-COMPANY          -> APB-COMPANY
                            API-BATCH-NUM        -> APB-BATCH-NUM

Apcompany      APCOMPANY    Required

                            API-COMPANY          -> CPY-COMPANY

Apinccode      APINCCODE    Not Required

                            API-INCOME-CODE      -> TYP-INCOME-CODE

Appayvenaddr   APVENADDR    Not Required

                            CPY-VENDOR-GROUP     -> VDR-VENDOR-GROUP
                            API-PAY-VENDOR       -> VDR-VENDOR
                            Spaces               -> VDR-LOCATION-CODE
                            Spaces               -> VDR-RESP-CODE
                            Zeroes               -> VDR-CONTACT-LVL
                            "Y"                  -> VDR-CUR-ADDR

Appayvenmast   APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            API-PAY-VENDOR       -> VEN-VENDOR

Approclev      APPROCLEV    Required

                            API-COMPANY          -> APR-COMPANY
                            API-PROC-LEVEL       -> APR-PROC-LEVEL

Apuaval        APUAVAL      Not Required

                            "I"                  -> UAV-SEG-TYPE
                            API-OBJ-ID           -> UAV-API-OBJ-ID
                            Zeroes               -> UAV-DIST-SEQ-NBR

Apvenlocaddr   APVENADDR    Not Required

                            CPY-VENDOR-GROUP     -> VDR-VENDOR-GROUP
                            API-PAY-VENDOR       -> VDR-VENDOR
                            API-REMIT-TO-CODE    -> VDR-LOCATION-CODE
                            Spaces               -> VDR-RESP-CODE
                            Zeroes               -> VDR-CONTACT-LVL
                            "Y"                  -> VDR-CUR-ADDR

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

                            CPY-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            API-VENDOR           -> VLO-VENDOR
                            API-PURCH-FR-LOC     -> VLO-LOCATION-CODE

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

                            CPY-VENDOR-GROUP     -> VLO-VENDOR-GROUP
                            API-PAY-VENDOR       -> VLO-VENDOR
                            API-REMIT-TO-CODE    -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            API-VENDOR           -> VEN-VENDOR

Cbcashcode     CBCASHCODE   Required

                            API-CASH-CODE        -> CBC-CASH-CODE

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

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

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

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

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

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

Invusrfld      APINUSRFLD   Not Required

                            API-OBJ-ID           -> ISR-OBJ-ID

Macompany      MACOMPANY    Not Required

                            API-COMPANY          -> MAY-COMPANY

Mainvhand      MAINVHAND    Required

                            API-COMPANY          -> MAH-COMPANY
                            API-HANDLING-CODE    -> MAH-HANDLING-CODE

Mamtchrule     MAMTCHRULE   Required

                            API-RULE-GROUP       -> MAU-MATCH-RULE

Mapool3        MAPOOLCNT    Not Required
                            Valid When  (VEN-POOL-OPTION = 3 )
                                  Or   ((VEN-POOL-OPTION = Zeroes )
                                  And   (MAY-POOL-OPTION = 3 ))

                            API-COMPANY          -> MAC-COMPANY
                            API-VENDOR           -> MAC-VENDOR
                            API-PO-NUMBER        -> MAC-PO-NUMBER
                            API-PO-RELEASE       -> MAC-PO-RELEASE
                            API-PO-CODE          -> MAC-PO-CODE
                            API-LOCATION         -> MAC-LOCATION

Pocompany      POCOMPANY    Not Required

                            API-COMPANY          -> PCY-COMPANY

Poreceive      PORECEIVE    Not Required

                            API-COMPANY          -> POR-COMPANY
                            API-VENDOR           -> POR-VENDOR
                            API-INVOICE          -> POR-INVOICE

Poreturnhd     PORETURNHD   Not Required

                            API-COMPANY          -> PTH-COMPANY
                            API-RETURN-NUMBER    -> PTH-RETURN-NUMBER

Povagrmthd     POVAGRMTHD   Not Required
                            Valid When (PVH- = API-)

                            PCY-PROCURE-GROUP    -> PVH-PROCURE-GROUP
                            API-VENDOR           -> PVH-VENDOR
                            API-PO-NUMBER        -> PVH-PO-NUMBER

Purchorder     PURCHORDER   Not Required

                            API-COMPANY          -> PCR-COMPANY
                            API-PO-CODE          -> PCR-PO-CODE
                            API-PO-NUMBER        -> PCR-PO-NUMBER
                            API-PO-RELEASE       -> PCR-PO-RELEASE

Reasoncd       MAREASONCD   Not Required

                            API-REASON-CODE      -> MAR-REASON-CODE

Taxcode        TXTAXCODE    Not Required

                            API-COMPANY          -> TAC-COMPANY
                            API-TAX-CODE         -> TAC-TAX-CODE

Txcompany      TXCOMPANY    Not Required

                            API-COMPANY          -> TXC-COMPANY

                         APINVOICE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apaudit        APAUDIT

                            CPY-VENDOR-GROUP     -> APA-VENDOR-GROUP
                            API-COMPANY          -> APA-COMPANY
                            API-PROC-LEVEL       -> APA-PROC-LEVEL
                            API-VENDOR           -> APA-VENDOR
                            API-INVOICE          -> APA-INVOICE
                            API-SUFFIX           -> APA-SUFFIX
                            API-CANCEL-SEQ       -> APA-CANCEL-SEQ
                                                    APA-SEQ-NBR
                                                    APA-TRANS-DATE
                                                    APA-TRANS-TIME

Apcrmemo       APCRMEMO

                            API-COMPANY          -> CRM-COMPANY
                            API-VENDOR           -> CRM-VENDOR
                            API-INVOICE          -> CRM-INVOICE
                            API-SUFFIX           -> CRM-SUFFIX
                                                    CRM-SEQ-NBR
                                                    CRM-CR-MEMO-NBR
                                                    CRM-CR-MEMO-SUFFIX
                                                    CRM-CR-SEQ-NBR

Apcrmemo2      APCRMEMO

                            API-COMPANY          -> CRM-COMPANY
                            API-VENDOR           -> CRM-VENDOR
                            API-INVOICE          -> CRM-CR-MEMO-NBR
                            API-SUFFIX           -> CRM-CR-MEMO-SUFFIX
                                                    CRM-CR-SEQ-NBR
                                                    CRM-INVOICE
                                                    CRM-SUFFIX
                                                    CRM-SEQ-NBR

Apdiscacc      APDISCACC

                            API-COMPANY          -> DSK-COMPANY
                            API-VENDOR           -> DSK-VENDOR
                            API-INVOICE          -> DSK-INVOICE
                            API-SUFFIX           -> DSK-SUFFIX
                            API-CANCEL-SEQ       -> DSK-CANCEL-SEQ
                                                    DSK-SEQ-NBR
                                                    DSK-VOID-SEQ
                                                    DSK-DISC-TYPE

Apdistcode     APDISTCODE

                            API-COMPANY          -> DTC-COMPANY
                            API-DIST-CODE        -> DTC-DIST-CODE
                                                    DTC-SEQ-NBR

Apdistrib      APDISTRIB    Delete Cascades

                            API-OBJ-ID           -> APD-API-OBJ-ID
                                                    APD-DIST-SEQ-NBR

Appayment      APPAYMENT    Delete Cascades

                            API-COMPANY          -> APP-COMPANY
                            API-VENDOR           -> APP-VENDOR
                            API-INVOICE          -> APP-INVOICE
                            API-SUFFIX           -> APP-SUFFIX
                            API-CANCEL-SEQ       -> APP-CANCEL-SEQ
                                                    APP-SEQ-NBR
                                                    APP-VOID-SEQ

Apvencomments2 APCOMMENTS

                            "V"                  -> APC-REC-TYPE
                            CPY-VENDOR-GROUP     -> APC-VENDOR-GROUP
                            API-VENDOR           -> APC-VENDOR
                            Spaces               -> APC-LOCATION-CODE
                            API-COMPANY          -> APC-COMPANY
                                                    APC-SEQ-NBR

Maaocdtl       MAAOCDTL

                            API-COMPANY          -> MAA-COMPANY
                            API-VENDOR           -> MAA-VENDOR
                            API-INVOICE          -> MAA-INVOICE
                            API-SUFFIX           -> MAA-SUFFIX
                            API-PO-NUMBER        -> MAA-PO-NUMBER
                            API-PO-RELEASE       -> MAA-PO-RELEASE
                            API-PO-CODE          -> MAA-PO-CODE
                                                    MAA-LINE-NBR
                                                    MAA-AOC-CODE
                                                    MAA-SEQ-NBR

Maaocdtl 2     MAAOCDTL

                            API-COMPANY          -> MAA-COMPANY
                            API-VENDOR           -> MAA-VENDOR
                            API-INVOICE          -> MAA-INVOICE
                            API-SUFFIX           -> MAA-SUFFIX
                                                    MAA-PO-NUMBER
                                                    MAA-PO-RELEASE
                                                    MAA-PO-CODE
                                                    MAA-LINE-NBR
                                                    MAA-AOC-CODE
                                                    MAA-SEQ-NBR

Mainvdtl       MAINVDTL

                            API-COMPANY          -> MAD-COMPANY
                            API-VENDOR           -> MAD-VENDOR
                            API-INVOICE          -> MAD-INVOICE
                            API-SUFFIX           -> MAD-SUFFIX
                            API-PO-NUMBER        -> MAD-PO-NUMBER
                            API-PO-RELEASE       -> MAD-PO-RELEASE
                            API-PO-CODE          -> MAD-PO-CODE
                                                    MAD-LINE-NBR
                                                    MAD-SEQ-NBR

Mainvdtl 2     MAINVDTL

                            API-COMPANY          -> MAD-COMPANY
                            API-VENDOR           -> MAD-VENDOR
                            API-INVOICE          -> MAD-INVOICE
                            API-SUFFIX           -> MAD-SUFFIX
                                                    MAD-PO-NUMBER
                                                    MAD-PO-RELEASE
                                                    MAD-PO-CODE
                                                    MAD-LINE-NBR
                                                    MAD-SEQ-NBR

Mainvmsg       MAINVMSG

                            API-COMPANY          -> MAG-COMPANY
                            API-VENDOR           -> MAG-VENDOR
                            API-INVOICE          -> MAG-INVOICE
                            API-SUFFIX           -> MAG-SUFFIX
                            API-CANCEL-SEQ       -> MAG-CANCEL-SEQ
                                                    MAG-MAD-SEQ-NBR
                                                    MAG-SEQ-NBR

Mapoinv        MAPOINV      Delete Restricted

                            API-COMPANY          -> AOI-COMPANY
                            API-VENDOR           -> AOI-VENDOR
                            API-INVOICE          -> AOI-INVOICE
                            API-SUFFIX           -> AOI-SUFFIX
                                                    AOI-PO-NUMBER
                                                    AOI-PO-RELEASE
                                                    AOI-PO-CODE

Mapool1        MAPOOLCNT
                            Valid When  VEN-POOL-OPTION = 1
                                  Or   (VEN-POOL-OPTION = Zeroes
                                  And   MAY-POOL-OPTION = 1 )

                            API-COMPANY          -> MAC-COMPANY
                            API-VENDOR           -> MAC-VENDOR
                                                    MAC-PO-NUMBER
                                                    MAC-PO-RELEASE
                                                    MAC-PO-CODE
                                                    MAC-LOCATION

Mapool2        MAPOOLCNT
                            Valid When  (VEN-POOL-OPTION = 2 )
                                  Or   ((VEN-POOL-OPTION = Zeroes )
                                  And   (MAY-POOL-OPTION = 2 ))

                            API-COMPANY          -> MAC-COMPANY
                            API-VENDOR           -> MAC-VENDOR
                            API-PO-NUMBER        -> MAC-PO-NUMBER
                            API-PO-RELEASE       -> MAC-PO-RELEASE
                            API-PO-CODE          -> MAC-PO-CODE
                                                    MAC-LOCATION

Match Trans    APINVOICE

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

Pomessage      POMESSAGE

                            API-COMPANY          -> POM-COMPANY
                            API-BATCH-NUM        -> POM-BATCH-NBR
                            API-VENDOR           -> POM-VENDOR
                            API-INVOICE          -> POM-INVOICE
                            API-SUFFIX           -> POM-SUFFIX
                                                    POM-PO-NUMBER
                                                    POM-PO-RELEASE
                                                    POM-LINE-NBR

Por Match Ref  PORECEIVE

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

Porecline      PORECLINE

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

Poreset9 Ven   PORECEIVE

                            API-COMPANY          -> POR-COMPANY
                            API-VENDOR           -> POR-VENDOR
                            API-PO-CODE          -> POR-PO-CODE
                            API-PO-NUMBER        -> POR-PO-NUMBER
                            API-PO-RELEASE       -> POR-PO-RELEASE
                                                    POR-LOCATION
                                                    POR-REC-NUMBER

Porset3        PORECEIVE

                            API-AOC-ALLOW-AMT    -> POR-COMPANY
                            API-PO-CODE          -> POR-PO-CODE
                            API-PO-NUMBER        -> POR-PO-NUMBER
                            API-PO-RELEASE       -> POR-PO-RELEASE
                                                    POR-PO-LOCATION
                                                    POR-REC-NUMBER

Porset9        PORECEIVE

                            API-COMPANY          -> POR-COMPANY
                            API-VENDOR           -> POR-VENDOR
                            API-PO-CODE          -> POR-PO-CODE
                            API-PO-NUMBER        -> POR-PO-NUMBER
                            API-PO-RELEASE       -> POR-PO-RELEASE
                                                    POR-LOCATION
                                                    POR-REC-NUMBER

Porset9 Ven    PORECEIVE

                            API-COMPANY          -> POR-COMPANY
                            API-VENDOR           -> POR-VENDOR
                                                    POR-PO-CODE
                                                    POR-PO-NUMBER
                                                    POR-PO-RELEASE
                                                    POR-LOCATION
                                                    POR-REC-NUMBER