Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APDRAFTS


                             APDRAFTS FILE

                          AP Bill of Exchange

The Accounts Payable Bill of Exchange file contains bill of exchange payment
records.

REFERENCED BY

AP136     AP213     AP230     AP284     AP250     AP266
AP91.2    AP91.1    AP214

UPDATED BY

AP125     AP126     AP151     AP156     AP166     AP167
AP180     AP181     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP20.8    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP28.1    AP28.2    AP305
AP56.1    AP56.2    AP80.1    CB300     MA41.1    MA41.2
MA41.4    MA41.7    MA43.2    MA61.1    MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APT-PAY-GROUP          Alpha 4                                   AP125   AP126
Element: Pay Group     The pay group associated with the bill    AP151   AP156
                       of exchange payment. A pay group is used  AP180   AP20.1
                       for processing accounts payable           AP20.2  AP20.3
                       payments. Must be a valid record in the   AP20.4  AP20.5
                       Pay Group file.                           AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company associated with the bill of   AP151   AP156
                       exchange payment. Must be a valid record  AP180   AP20.1
                       in the Accounts Payable Company file.     AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-TRANS-IDENT        Numeric 10                                AP125   AP126
Element: Transaction IDA unique system-generated                 AP151   AP156
                       identification value assigned to the      AP180   AP20.1
                       bill of exchange payment transaction to   AP20.2  AP20.3
                       make this record unique.                  AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-VENDOR-GROUP       Alpha 4                                   AP125   AP126
Element: Vendor Group  The vendor group associated with the      AP151   AP156
                       bill of exchange payment. A vendor group  AP180   AP20.1
                       represents a group of vendors that can    AP20.2  AP20.3
                       be shared by one or more companies. Must  AP20.4  AP20.5
                       be a valid record in the Vendor Group     AP20.7  AP20.8
                       file.                                     AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-VENDOR             Alpha 9  (Right Justified)                AP125   AP126
Element: Vendor        The payment vendor number. Must be a      AP151   AP156
                       valid record in the Vendor file.          AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-VENDOR-VNAME       Alpha 30  (Lower Case)                    AP125   AP126
Element: Name          The vendor name or description.           AP151   AP156
                                                                 AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-BANK-INST-CODE     Alpha 3                                   AP125   AP126
Element: Payment Code  The payment code assigned to the bill     AP151   AP156
                       of exchange. Represents the type of bill  AP180   AP20.1
                       of exchange payment. Must be a valid      AP20.2  AP20.3
                       bill of exchange payment transaction      AP20.4  AP20.5
                       code in the Bank Transaction Code file.   AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-DRAFT-NBR          Alpha 10  (Right Justified)               AP125   AP126
Bill of Exchange       The bill of exchange number.              AP151   AP156
Number                                                           AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-SUFFIX             Numeric 3                                 AP125   AP126
Bill of Exchange       The bill of exchange suffix number.       AP151   AP156
Suffix                                                           AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-PROC-LEVEL         Alpha 5                                   AP125   AP126
Element: Process Level The process level associated with the     AP151   AP156
                       bill of exchange. Must be a valid record  AP180   AP20.1
                       in the Accounts Payable Process Level     AP20.2  AP20.3
                       file.                                     AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-REMIT-TO-CODE      Alpha 4                                   AP125   AP126
Element: Remit To Code The remit-to location code associated     AP151   AP156
                       with the bill of exchange. Represents an  AP180   AP20.1
                       alternate remittance location for the     AP20.2  AP20.3
                       vendor. Must be a valid record in the     AP20.4  AP20.5
                       Vendor Location file.                     AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-PMT-DOC-ORIGIN     Alpha 1                                   AP125   AP126
Element: Transaction OrThe bill of exchange payment origin.      AP151   AP156
                       Indicates who created the bill of         AP180   AP20.1
                       exchange document or transaction. Valid   AP20.2  AP20.3
                       values are:                               AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                       P = Accounts Payable                      AP21.1  AP23.1
                       R = Accounts Receivable.                  AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-CASH-CODE          Alpha 4                                   AP125   AP126
Element: Cash Code     The cash code assigned to the bill of     AP151   AP156
                       exchange. Represents the bank account     AP180   AP20.1
                       used to pay the bill of exchange. Must    AP20.2  AP20.3
                       be a valid record in the Cash Code file.  AP20.4  AP20.5
                       If left blank, the cash code assigned to  AP20.7  AP20.8
                       the remit-to location, vendor, vendor     AP21.1  AP23.1
                       class, process level, company, or pay     AP25.1  AP25.2
                       group defaults.                           AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-CURRENCY-CODE      Alpha 5                                   AP125   AP126
Bill of Exchange       The currency of the bill of exchange.     AP151   AP156
Currency               Must be a valid record in the Currency    AP180   AP20.1
                       Code file. If left blank, the company     AP20.2  AP20.3
                       base currency defaults.                   AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-DRAFT-AMOUNT       Signed 18.2                               AP125   AP126
Bill of Exchange       The amount of the bill of exchange        AP151   AP156
Amount                 payment in the currency of the bill of    AP180   AP20.1
                       exchange.                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-APPLIED-AMT        Signed 18.2                               AP125   AP126
Element: Intl Amt      The total invoice amount that is          AP151   AP156
                       applied to the bill of exchange.          AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-TRAN-ND            Numeric 1                                 AP125   AP126
Element: Acct Nd       The number of decimal positions defined   AP151   AP156
                       for the bill of exchange currency.        AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-ORIG-RATE          Signed 14.7                               AP125   AP126
Exchange Rate at       The currency exchange rate used to        AP151   AP156
Creation               convert the bill of exchange amount to    AP180   AP20.1
                       the company base currency at the time     AP20.2  AP20.3
                       the bill of exchange was created.         AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-BASE-ORIG-AMT      Signed 18.2                               AP125   AP126
Base BOE Amount -      The amount of the bill of exchange        AP151   AP156
At Creation            payment in the company base currency.     AP180   AP20.1
                       This amount is based on the currency      AP20.2  AP20.3
                       exchange rate in effect at the time the   AP20.4  AP20.5
                       bill of exchange was created.             AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-BASE-ACT-AMT       Signed 18.2                               AP125   AP126
Base BOE Amount -      The amount of the bill of exchange        AP151   AP156
At Cashing             payment in the company base currency.     AP180   AP20.1
                       This amount is based on the currency      AP20.2  AP20.3
                       exchange rate in effect at the time the   AP20.4  AP20.5
                       bill of exchange is cashed.               AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-BASE-ND            Numeric 1                                 AP125   AP126
Base Currency Nbr      The number of decimal positions defined   AP151   AP156
of Decimals            for the company base currency.            AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-ACT-RATE           Signed 14.7                               AP125   AP126
Exchange Rate at       The currency exchange rate used to        AP151   AP156
Cashing                convert the bill of exchange amount to    AP180   AP20.1
                       the company base currency at the time     AP20.2  AP20.3
                       the bill of exchange is cashed.           AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-DRAFT-DATE         Numeric 8  (yyyymmdd)                     AP125   AP126
Bill of Exchange       The creation date of the bill of          AP151   AP156
Date                   exchange. If left blank, the system date  AP180   AP20.1
                       defaults.                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-MATURITY-DATE      Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Due Date      The date the bill of exchange is due      AP151   AP156
                       for payment. If left blank, the system    AP180   AP20.1
                       date defaults.                            AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-ACCEPT-DATE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Acceptance DatThe date the bill of exchange is          AP151   AP156
                       accepted. If left blank, the system date  AP180   AP20.1
                       defaults.                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-CASH-DATE          Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          The date the bill of exchange was         AP151   AP156
                       cashed by the bank.                       AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-DISHONOR-DATE      Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Dishonor Date The date the bill of exchange was         AP151   AP156
                       dishonored by the bank.                   AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Cancel Date   The date the bill of exchange was         AP151   AP156
                       canceled.                                 AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-CASH-COMPANY       Numeric 4                                 AP125   AP126
Element: Cashing CompanThe company associated with cashing the   AP151   AP156
                       bill of exchange payment. Must be a       AP180   AP20.1
                       valid record in the Accounts Payable      AP20.2  AP20.3
                       Company file.                             AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-REC-STATUS         Numeric 1                                 AP125   AP126
Element: Rec Status    The status of the bill of exchange        AP151   AP156
                       payment. Valid values are:                AP180   AP20.1
                                                                 AP20.2  AP20.3
                       0 = Unreleased.                           AP20.4  AP20.5
                       1 = Released.                             AP20.7  AP20.8
                       2 = Accepted.                             AP21.1  AP23.1
                       3 = Cashed.                               AP25.1  AP25.2
                       4 = Dishonored.                           AP26.1  AP27.1
                       5 = Canceled.                             AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-PRINT-STATUS       Alpha 1                                   AP125   AP126
Element: Print Status  Indicates whether the bill of exchange    AP151   AP156
                       payment has been printed by AP156 (Bill   AP180   AP20.1
                       of Exchange Printing). Valid values are:  AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       N = No.                                   AP20.7  AP20.8
                       Y = Yes.                                  AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-ACPT-ACCT-UNIT     Alpha 15                                  AP125   AP126
Acceptance             The general ledger acceptance             AP151   AP156
Accounting Unit        accounting unit assigned to the bill of   AP180   AP20.1
                       exchange payment. Must be a valid         AP20.2  AP20.3
                       accounting unit in the Lawson General     AP20.4  AP20.5
                       Ledger system.                            AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-ACPT-ACCOUNT       Numeric 6                                 AP125   AP126
Acceptance Account     The general ledger acceptance account     AP151   AP156
Number                 number assigned to the bill of exchange   AP180   AP20.1
                       payment. Must be a valid account in the   AP20.2  AP20.3
                       Lawson General Ledger system.             AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-ACPT-SUB-ACCT      Numeric 4                                 AP125   AP126
Acceptance             The general ledger acceptance             AP151   AP156
Subaccount Number      subaccount number assigned to the bill    AP180   AP20.1
                       of exchange payment. Must be a valid      AP20.2  AP20.3
                       subaccount in the Lawson General Ledger   AP20.4  AP20.5
                       system.                                   AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-DRAFT-CODE         Alpha 4                                   AP125   AP126
Bill of Exchange       The bill of exchange accrual code         AP151   AP156
Accrual Code           assigned to the bill of exchange          AP180   AP20.1
                       payment. Used to default an acceptance    AP20.2  AP20.3
                       account to the bill of exchange. Must be  AP20.4  AP20.5
                       a valid record in the Bill of Exchange    AP20.7  AP20.8
                       Accrual Code file.                        AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-GL-UPDATE-FL       Alpha 1                                   AP125   AP126
General Ledger         Indicates whether the cashed or           AP151   AP156
Update Flag            dishonored bill of exchange has been      AP180   AP181
                       updated to the general ledger by AP185    AP20.1  AP20.2
                       (Bill of Exchange Distribution Posting).  AP20.3  AP20.4
                       Valid values are:                         AP20.5  AP20.7
                                                                 AP20.8  AP21.1
                       N = No.                                   AP23.1  AP25.1
                       Y = Yes.                                  AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP56.1
                                                                 AP56.2  AP80.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1

APT-POST-DATE          Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Post Date     The date used for posting the cashed or   AP151   AP156
                       dishonored bill of exchange payment to    AP180   AP20.1
                       the general ledger.                       AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-PAYER-REF          Alpha 10                                  AP125   AP126
Payer Reference        The reference number assigned to the      AP151   AP156
Number                 bill of exchange payment.                 AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-STATEMENT-NBR      Numeric 8                                 AP166   AP167
Element: Statement NumbThe statement number assigned to the
                       bill of exchange payment.

APT-JRNL-BOOK-NBR      Alpha 12                                  AP125   AP126
Element: Jrnl Book Nbr The journal book assigned to the          AP151   AP156
                       transaction.                              AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APT-DERIVED-STATUS     Derived
Bill of Exchange       The status of the bill of exchange
Status                 payment.

APT-VGROUP             Derived
Element: Vendor Group  The vendor group associated with the
                       bill of exchange payment. Must be a
                       valid record in the Vendor Group file.

APT-SHORT-DFT-NAME     Derived
Element: Short Vendor NA short (20-character) name for the
                       vendor associated with the bill of
                       exchange payment.

                         APDRAFTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APTSET1   BANK-INST-CODE                                         AP125   AP126
          TRANS-IDENT                                            AP136   AP151
                                                                 AP156   AP166
                                                                 AP180   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP213
                                                                 AP23.1  AP230
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP284   AP56.1
                                                                 AP56.2  AP80.1
                                                                 CB300   MA41.1
                                                                 ...

APTSET10  CASH-CODE     Subset                                   AP181
          PAY-GROUP     Where (STATEMENT-NBR != Zeroes )
          STATEMENT-NBR
          DRAFT-NBR
          SUFFIX

APTSET2   CASH-CODE     KeyChange                                AP167   AP181
          REC-STATUS
          BANK-INST-CODE
          DRAFT-NBR
          SUFFIX
          TRANS-IDENT
          COMPANY
          VENDOR

APTSET3   PAY-GROUP     KeyChange, Subset                        AP125   AP126
          REC-STATUS    Where REC-STATUS = 1                     AP151   AP156
          DRAFT-DATE    Or    REC-STATUS = 2                     AP180   AP20.1
          BANK-INST-CODE                                         AP20.2  AP20.3
          DRAFT-NBR                                              AP20.4  AP20.5
          SUFFIX                                                 AP20.7  AP20.8
          TRANS-IDENT                                            AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP250   AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP56.1
                                                                 AP56.2  AP80.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 ...

APTSET4   PAY-GROUP     KeyChange                                AP266   AP28.1
          VENDOR                                                 AP28.2
          REC-STATUS
          DRAFT-NBR
          SUFFIX
          BANK-INST-CODE
          TRANS-IDENT

APTSET5   CASH-CODE     KeyChange, Subset                        AP180   AP80.1
          MATURITY-DATE Where GL-UPDATE-FL = "N"
          PAY-GROUP     And   REC-STATUS   > 1
          BANK-INST-CODEAnd   REC-STATUS   < 5
          DRAFT-NBR
          SUFFIX
          TRANS-IDENT

APTSET6   BANK-INST-CODEKeyChange, Subset                        AP125   AP126
          DRAFT-NBR     Where REC-STATUS != 5                    AP151   AP156
          SUFFIX                                                 AP180   AP20.1
          VENDOR                                                 AP20.2  AP20.3
          PAY-GROUP                                              AP20.4  AP20.5
                                                                 AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP56.1  AP56.2
                                                                 AP80.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APTSET7   PAY-GROUP     KeyChange                                AP125   AP126
          BANK-INST-CODE                                         AP151   AP156
          VENDOR                                                 AP180   AP20.1
          DRAFT-NBR                                              AP20.2  AP20.3
          SUFFIX                                                 AP20.4  AP20.5
          TRANS-IDENT                                            AP20.7  AP20.8
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP305   AP56.1
                                                                 AP56.2  AP80.1
                                                                 AP91.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 ...

APTSET8   VENDOR-GROUP  KeyChange                                AP214   AP91.1
          VENDOR
          COMPANY
          BANK-INST-CODE
          TRANS-IDENT

                         APDRAFTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required

                            APT-COMPANY           -> CPY-COMPANY

Appaygroup     APPAYGROUP   Required

                            APT-PAY-GROUP         -> PAY-PAY-GROUP

Approclev      APPROCLEV    Not Required

                            APT-COMPANY           -> APR-COMPANY
                            APT-PROC-LEVEL        -> APR-PROC-LEVEL

Apvenbal       APVENBAL     Required

                            CPY-VENDOR-GROUP      -> VBA-VENDOR-GROUP
                            APT-COMPANY           -> VBA-COMPANY
                            APT-VENDOR            -> VBA-VENDOR
                            APT-REMIT-TO-CODE     -> VBA-LOCATION-CODE

Apvenclass     APVENMAST    Not Required

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            APT-VENDOR            -> VEN-VENDOR

Apvenloc       APVENLOC     Not Required

                            CPY-VENDOR-GROUP      -> VLO-VENDOR-GROUP
                            APT-VENDOR            -> VLO-VENDOR
                            APT-REMIT-TO-CODE     -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Not Required

                            CPY-VENDOR-GROUP      -> VEN-VENDOR-GROUP
                            APT-VENDOR            -> VEN-VENDOR

Cbbankent      CBBANKENT    Required

                            CBC-BANK-ENTITY       -> CBE-BANK-ENTITY

Cbbankinst     CBBANKINST   Required

                            APT-BANK-INST-CODE    -> CBI-BANK-INST-CODE

Cbcashcode     CBCASHCODE   Required

                            APT-CASH-CODE         -> CBC-CASH-CODE

Cbcpycash      CBCPYCASH    Not Required

                            APT-COMPANY           -> CBY-COMPANY
                            APT-CASH-CODE         -> CBY-CASH-CODE

Cbtrans        CBTRANS      Not Required

                            APT-BANK-INST-CODE    -> CBT-BANK-INST-CODE
                            APT-TRANS-IDENT       -> CBT-TRANS-IDENT

                         APDRAFTS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapphist      APAPPHIST

                            APT-PAY-GROUP         -> AH3-PAY-GROUP
                            APT-BANK-INST-CODE    -> AH3-BANK-INST-CODE
                            APT-TRANS-IDENT       -> AH3-TRANS-IDENT
                                                     AH3-VENDOR
                                                     AH3-INVOICE
                                                     AH3-SUFFIX
                                                     AH3-CANCEL-SEQ
                                                     AH3-SEQ-NBR
                                                     AH3-VOID-SEQ
                                                     AH3-COMPANY

Apdrftdist     APDRFTDIST

                            APT-BANK-INST-CODE    -> DDT-BANK-INST-CODE
                            APT-TRANS-IDENT       -> DDT-TRANS-IDENT
                                                     DDT-SEQ-NBR

Appayment      APPAYMENT

                            APT-PAY-GROUP         -> APP-PAY-GROUP
                            APT-BANK-INST-CODE    -> APP-BANK-INST-CODE
                            APT-TRANS-IDENT       -> APP-TRANS-IDENT
                                                     APP-VENDOR
                                                     APP-INVOICE
                                                     APP-SUFFIX
                                                     APP-CANCEL-SEQ
                                                     APP-SEQ-NBR
                                                     APP-VOID-SEQ
                                                     APP-COMPANY