Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APDISTRIB


                             APDISTRIB FILE

                      Invoice Distribution Header

The Invoice Distribution Header file contains invoice distribution records.
The presence of a tax code identifies the record as a tax distribution.
Distribution records that have an asset number or asset template assigned will
also have an associated record in the Asset Detail file.

REFERENCED BY

AP220     AP260     AP282     AP295     AP700     AP95.1
AP95.2    AP95.3    TX226     AP275     MM280     MM80.1
MM80.2

UPDATED BY

AP115     AP125     AP126     AP170     AP175     AP177
AP180     AP181     AP190     AP191     AP193     AP195
AP198     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP23.1    AP25.1    AP25.2    AP26.1    AP27.1
AP28.1    AP28.2    AP30.1    AP30.2    AP30.4    AP300
AP305     AP32.2    AP32.1    AP45.1    AP520     API1.1
API2.1    EE135     EE35.1    EE35.2    EE520     MA41.2
MA41.7    MA43.2    MA61.1    MA66.2    MA70.1    MA75.1
MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APD-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company number. Must be a valid       AP170   AP180
                       record in the Accounts Payable Company    AP181   AP190
                       file.                                     AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-API-OBJ-ID         Numeric 12                                AP125   AP126
Element: API Object ID A unique identifier assigned to this      AP170   AP180
                       file record.                              AP181   AP190
                                                                 AP191   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MA70.1
                                                                 MA75.1  MAI1.1

APD-VENDOR             Alpha 9  (Right Justified)                AP115   AP125
Element: Vendor ID     The vendor number. Must be a valid        AP126   AP170
                       record in the Vendor file.                AP180   AP181
                                                                 AP190   AP191
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-INVOICE            Alpha 22                                  AP115   AP125
Element: Invoice NumberThe invoice number. Represents a unique   AP126   AP170
                       identifier for the invoice. Must be a     AP180   AP181
                       valid record in the Accounts Payable      AP190   AP191
                       Invoice file.                             AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-SUFFIX             Numeric 3                                 AP125   AP126
Element: Invoice SuffixThe invoice suffix number. Represents     AP170   AP180
                       the occurrence value of the invoice. The  AP181   AP190
                       suffix is assigned by the system to       AP191   AP193
                       recurring invoices, employee advances,    AP20.1  AP20.2
                       and prepayment credit memos.              AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MA70.1
                                                                 MA75.1  MAI1.1

APD-CANCEL-SEQ         Numeric 4                                 AP125   AP126
Element: Sequence NumbeThe sequence number assigned upon the     AP170   AP180
                       cancellation of a distributed invoice.    AP181   AP190
                       The first sequence assigned is 9999.      AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-DIST-SEQ-NBR       Numeric 4                                 AP125   AP126
Element: Number of ItemA unique sequence number assigned to      AP170   AP180
                       the distribution record.                  AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DIST-TYPE          Alpha 1                                   AP125   AP126
Element: Distribution TThe distribution type. Valid values are:  AP170   AP180
                                                                 AP181   AP190
                       D = Distribution.                         AP191   AP20.1
                       I = Intercompany Distribution. (Not       AP20.2  AP20.3
                       used for distributions that originate in  AP20.4  AP20.5
                       the Accounts Payable system.)             AP20.7  AP23.1
                       G = Gain/Loss Distribution.               AP25.1  AP25.2
                       R = Tax/Reversal Distribution.            AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-PROC-LEVEL         Alpha 5                                   AP125   AP126
Element: Process Level The process level associated with the     AP170   AP180
                       distribution. Must be a valid record in   AP181   AP190
                       the Accounts Payable Process Level file.  AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-POST-OPTION        Alpha 1                                   AP125   AP126
Element: Posting OptionThe general ledger posting option         AP170   AP180
                       associated with the distribution record.  AP181   AP190
                       Valid values are:                         AP191   AP20.1
                                                                 AP20.2  AP20.3
                       D = Detail.                               AP20.4  AP20.5
                       S = Summary.                              AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-INVOICE-TYPE       Alpha 1                                   AP125   AP126
Element: Invoice Type  The type of invoice associated with the   AP170   AP180
                       distribution. Valid values are:           AP181   AP190
                                                                 AP191   AP20.1
                       Blank = Invoice.                          AP20.2  AP20.3
                       C = Credit Memo.                          AP20.4  AP20.5
                       D = Debit Memo.                           AP20.7  AP23.1
                       P = Prepayment.                           AP25.1  AP25.2
                       Y = Prepayment Credit Memo.               AP26.1  AP27.1
                       A = Employee Advance.                     AP28.1  AP28.2
                       M = Employee Advance Credit Memo.         AP30.2  AP30.4
                       E = Employee Expense.                     AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-REC-STATUS         Numeric 1                                 AP125   AP126
Element: Record Status The distribution record status.  Valid    AP170   AP175
                       values are:                               AP180   AP181
                                                                 AP190   AP191
                       0 = Unreleased.                           AP193   AP20.1
                       1 = Unposted (released).                  AP20.2  AP20.3
                       9 = Posted by AP175.                      AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

APD-INV-CURRENCY       Alpha 5                                   AP125   AP126
To Company Base        The currency of the invoice. Must be a    AP170   AP180
Currency               valid record in the Currency Code file.   AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TAX-RATE           Percent 7.5  (Percent)                    AP125   AP126
Element: Chrg Rate     The tax rate applied to the invoice.      AP170   AP180
                                                                 AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-CURR-RATE          Signed 13.6                               AP125   AP126
Currency Exchange      The currency exchange rate applied to     AP170   AP180
Rate                   the invoice.                              AP181   AP190
                                                                 AP191   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-ORIG-BASE-AMT      Signed 15.2                               AP125   AP126
Base Distribution      The amount of the distribution in         AP170   AP180
Amount                 company base currency.                    AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-BASE-ND            Numeric 1                                 AP125   AP126
Base Currency Nbr      The number of decimals positions          AP170   AP180
of Decimals            defined for the company base currency.    AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-ORIG-TRAN-AMT      Signed 15.2                               AP125   AP126
Element: Distribution AThe amount of the distribution in the     AP170   AP180
                       currency of the invoice.                  AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TRAN-ND            Numeric 1                                 AP125   AP126
Trans Curr Nbr of      The number of decimals defined for the    AP170   AP180
Decimals               invoice currency.                         AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TO-BASE-AMT        Signed 15.2                               AP125   AP126
Distribution           The amount of the distribution in the     AP170   AP180
Company Base Amt       distribution company's base currency.     AP181   AP190
                                                                 AP191   AP193
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-TO-BASE-ND         Numeric 1                                 AP125   AP126
Dist Company Nbr of    The number of decimal positions defined   AP170   AP180
Decimals               for the distribution company's currency.  AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TAXABLE-AMT        Signed 15.2                               AP125   AP126
Element: Adj Amt       The taxable amount of the distribution.   AP170   AP180
                                                                 AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-UNT-AMOUNT         Signed 15.2                               AP125   AP126
Element: Unit Amount   The total unit amount allocated to the    AP180   AP181
                       expense distribution.                     AP190   AP191
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-DIST-COMPANY       Numeric 4                                 AP125   AP126
Element: Company       The distribution company assigned to      AP170   AP180
                       the distribution. Must be a valid record  AP181   AP190
                       in the General Ledger Company file and a  AP191   AP20.1
                       valid relationship record must exist in   AP20.2  AP20.3
                       the Intercompany Relationship file.       AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DIS-ACCT-UNIT      Alpha 15                                  AP125   AP126
Element: Accounting UniThe general ledger distribution           AP170   AP180
                       accounting unit. Must be a valid record   AP181   AP190
                       in the General Ledger Names file.         AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DIS-ACCOUNT        Numeric 6                                 AP125   AP126
Element: Account       The general ledger distribution account   AP170   AP180
                       number. Must be a valid record in the     AP181   AP190
                       General Ledger Account Master file.       AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DIS-SUB-ACCT       Numeric 4                                 AP125   AP126
Element: Subaccount    The general ledger distribution           AP170   AP180
                       subaccount number. Must be a valid        AP181   AP190
                       record in the General Ledger Account      AP191   AP20.1
                       Master file.                              AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Post Date     The date used for posting the             AP170   AP180
                       distribution to the general ledger.       AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

APD-TAX-CODE           Alpha 10                                  AP125   AP126
Element: Tax Code      The tax code assigned to the              AP170   AP180
                       distribution. Represents tax              AP181   AP190
                       information. If present, identifies the   AP191   AP20.1
                       distribution as a tax distribution. Must  AP20.2  AP20.3
                       be a valid tax code in the Lawson Tax     AP20.4  AP20.5
                       system.                                   AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TAX-TYPE           Alpha 1                                   AP125   AP126
Element: Tax Type      Indicates the type of tax defined for     AP170   AP180
                       the Tax Code. Valid values are:           AP181   AP190
                                                                 AP191   AP20.1
                       I = Invoiced. Default value. The tax      AP20.2  AP20.3
                       represents an increase to the invoice     AP20.4  AP20.5
                       amount.                                   AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                       A = Accrued. The tax does not increase    AP26.1  AP27.1
                       the invoice amount.                       AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DESCRIPTION        Alpha 30  (Lower Case)                    AP125   AP126
Element: Description   The distribution description.             AP170   AP180
                                                                 AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DST-REFERENCE      Alpha 10                                  AP125   AP126
Element: Cross Ref     The distribution reference.               AP170   AP180
                                                                 AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-ACTIVITY           Alpha 15                                  AP125   AP126
Element: Activity      The activity assigned to the              AP170   AP180
                       distribution, if applicable. Used to      AP181   AP190
                       group expense distribution amounts to     AP191   AP20.1
                       track costs for projects, jobs,           AP20.2  AP20.3
                       construction, and so on, without having   AP20.4  AP20.5
                       to define additional general ledger       AP20.7  AP23.1
                       account numbers. Must be a valid          AP25.1  AP25.2
                       activity in the Lawson Activity           AP26.1  AP27.1
                       Management system.                        AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-ACCT-CATEGORY      Alpha 5                                   AP125   AP126
Element: Account CategoThe account category assigned to the      AP180   AP181
                       distribution, if applicable. Used to      AP190   AP20.1
                       group distributions under an activity.    AP20.2  AP20.3
                       Must be a valid account category for the  AP20.4  AP20.5
                       activity in the Lawson Activity           AP20.7  AP23.1
                       Management system.                        AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-ACCR-CODE          Alpha 4                                   AP125   AP126
Element: Invoice AccruaThe invoice accrual code associated       AP170   AP180
                       with the distribution. Represents a       AP181   AP190
                       general ledger accrual account. Must be   AP191   AP20.1
                       a valid record in the Invoice Accrual     AP20.2  AP20.3
                       Code file.                                AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-PO-NUMBER          Alpha 14  (Right Justified)               AP125   AP126
Element: PO Number     This field contains the number            AP170   AP180
                       representing the purchase order.          AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-PO-RELEASE         Numeric 4                                 AP125   AP126
Element: PO Release NumThe purchase order release number         AP170   AP180
                       associated with the distribution. Used    AP181   AP190
                       to identify a purchase order release      AP191   AP20.1
                       (created from a blanket or standing       AP20.2  AP20.3
                       order).                                   AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-PO-CODE            Alpha 4                                   AP125   AP126
Element: Purchase OrderPurchase order number code. Used to       AP170   AP180
                       keep purchase orders unique. Can also be  AP181   AP190
                       used for reporting purposes.              AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-PO-LINE-NBR        Numeric 6                                 AP125   AP126
Element: Line Number   The purchase order line number            AP170   AP180
                       associated with the distribution.         AP181   AP190
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-PO-AOC-CODE        Alpha 2                                   AP125   AP126
Purchase Order Add     Indicates whether this distribution       AP180   AP181
On Cost                record represents an add-on cost for a    AP190   AP20.1
                       purchase order. Valid values are:         AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       Y = Yes.                                  AP20.7  AP23.1
                       N = No.                                   AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-GLT-OBJ-ID         Numeric 12                                AP125   AP126
GL Interface Object                                              AP170   AP175
ID                                                               AP180   AP181
                                                                 AP190   AP191
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

APD-ATN-OBJ-ID         Numeric 12                                AP125   AP126
Activity Interface     A subsystem activity interface            AP170   AP175
Object ID              identification number. Used for Drill     AP180   AP181
                       Around purposes.                          AP190   AP191
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

APD-ASSET-FLAG         Alpha 1                                   AP125   AP126
Element: Asset Exists  Indicates whether an asset or asset       AP170   AP180
                       repair record exists for the              AP181   AP190
                       distribution. Valid values are:           AP191   AP20.1
                                                                 AP20.2  AP20.3
                       A = Asset.                                AP20.4  AP20.5
                       R = Repair Asset.                         AP20.7  AP23.1
                       Blank = No asset information is defined   AP25.1  AP25.2
                       for the distribution.                     AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-DIST-CODE          Alpha 9                                   AP125   AP126
Element: Distribution CThe distribution code assigned to the     AP180   AP181
                       distribution. Used to split an expense    AP190   AP20.1
                       distribution into multiple distribution   AP20.2  AP20.3
                       lines. Must be a valid record in the      AP20.4  AP20.5
                       Distribution Code Header file.            AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-TAX-POINT          Alpha 1                                   AP125   AP126
Element: Tax Point     Indicates when the tax amount is          AP180   AP181
                       calculated for the invoice distribution,  AP190   AP20.1
                       if applicable. Valid values are:          AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       I = Invoice.                              AP20.7  AP23.1
                       P = Payment.                              AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP32.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.2  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-VAT-REVERSE-FL     Alpha 1                                   AP125   AP126
Element: VAT Reversal  Used in AP190 (Invoice Reinstatement)     AP180   AP181
                       to create reversing tax due general       AP190   AP20.1
                       ledger records. This field is No if       AP20.2  AP20.3
                       reversing tax transactions have not been  AP20.4  AP20.5
                       sent to the general ledger. When the      AP20.7  AP23.1
                       transactions are sent to the general      AP25.1  AP25.2
                       ledger, this field changes to Yes. Valid  AP26.1  AP27.1
                       values are:                               AP28.1  AP28.2
                                                                 AP45.1  API1.1
                       N = No.                                   API2.1  MA41.2
                       Y = Yes.                                  MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-DST-OBJ-ID         Numeric 12                                AP180   AP181
Distribution Object    An object identifier to keep the record   AP190   AP20.1
ID                     unique.                                   AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP45.1
                                                                 MA41.2  MA43.2

APD-MA-CREATE-FL       Alpha 1                                   AP125   AP126
Matching Creation      Indicates the distribution was            AP180   AP181
Flag                   generated during matching, as opposed to  AP190   AP20.1
                       entered manually during invoicing.        AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                       Also used during the match reversal       AP20.7  AP23.1
                       process to determine whether the          AP25.1  AP25.2
                       distribution should be deleted (match     AP26.1  AP27.1
                       distribution) or left untouched           AP28.1  AP28.2
                       (miscellaneous distribution).             AP45.1  API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TAX-USAGE-CD       Alpha 10                                  AP125   AP126
Element: Tax Usage Cd  The tax usage coe for the vendor.  This   AP180   AP181
                       filed is required if the AP Company       AP190   AP20.1
                       inidcates that VAT reporting required.    AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.2
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-TRAN-DIST-FLAG     Alpha 1                                   AP20.1  AP20.2
Element: Final Dst Flag                                          AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP30.2
                                                                 MA41.2  MA43.2

APD-PULL-FOR-FR-FL     Alpha 1                                   AP175   AP177
Element: Pull For Fr Fl

APD-DIST-STATUS        Derived
Element: Distribution SIndicates whether the distribution is
                       posted or unposted.

                         APDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APDSET1   API-OBJ-ID    This index is used to access and create  AP115   AP125
          DIST-SEQ-NBR  unique invoice distribution records.     AP126   AP170
                                                                 AP175   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP198
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP260
                                                                 AP27.1  AP282
                                                                 AP295   AP30.1
                                                                 AP30.2  AP30.4
                                                                 ...

APDSET11  COMPANY       Subset                                   AP177
          API-OBJ-ID    Where (PULL-FOR-FR-FL = "Y" )
          DIST-SEQ-NBR

APDSET2   COMPANY       This index is used to access invoice     AP175   AP195
          REC-STATUS    distribution records used to create
          PROC-LEVEL    general ledger distribution and
          DIS-ACCT-UNIT gain/loss transactions.
          DIS-ACCOUNT   KeyChange
          DIS-SUB-ACCT
          DISTRIB-DATE
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET3   DIST-COMPANY  This index is used to access invoice     AP95.2  AP95.3
          ACTIVITY      distribution records associated with a
          ACCT-CATEGORY specific project.
          DISTRIB-DATE  KeyChange
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET4   DIST-COMPANY  This index is used to access invoice     AP275   AP95.2
          DIS-ACCT-UNIT distribution records by the general      AP95.3
          DIS-ACCOUNT   ledger account number the distributions
          DIS-SUB-ACCT  are being posted to.
          DISTRIB-DATE  KeyChange
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET5   GLT-OBJ-ID    This index is used to access invoice     MM280   MM80.1
          API-OBJ-ID    distribution records that need to        MM80.2
          DIST-SEQ-NBR  revalued by AP191 (Unrealized
                        Gain/Loss).
                        KeyChange, Subset
                        Where GLT-OBJ-ID != Zeroes

APDSET6   DST-OBJ-ID    This index is used to access
                        distribution records that are linked to
                        a recurring journal entry in the Lawson
                        General Ledger System.
                        KeyChange, Subset
                        Where DST-OBJ-ID != Zeroes

APDSET8   COMPANY       This index is used to access invoice     AP20.1  AP20.2
          PO-NUMBER     distribution records associated with a   AP20.3  AP20.4
          PO-RELEASE    specific purchase order's line item.     AP20.5  AP20.7
          PO-CODE       KeyChange, Subset                        AP23.1  MA41.2
          PO-LINE-NBR   Where PO-NUMBER != Spaces                MA43.2
          PO-AOC-CODE
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET9   ATN-OBJ-ID    This index is used to show the
          COMPANY       committed cost in Accounts Payable for
          VENDOR        the Projects system.
          INVOICE       KeyChange, Subset
          SUFFIX        Where ATN-OBJ-ID != Zeroes
          CANCEL-SEQ
          DIST-SEQ-NBR

                         APDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS      Not Required

                            APD-ATN-OBJ-ID       -> ATN-OBJ-ID  (ATNSET12)

Apcompany      APCOMPANY    Required

                            APD-COMPANY          -> CPY-COMPANY

Apdistcompany  GLSYSTEM     Required

                            APD-DIST-COMPANY     -> GLS-COMPANY

Apinvoice      APINVOICE    Required

                            APD-COMPANY          -> API-COMPANY
                            APD-VENDOR           -> API-VENDOR
                            APD-INVOICE          -> API-INVOICE
                            APD-SUFFIX           -> API-SUFFIX
                            APD-CANCEL-SEQ       -> API-CANCEL-SEQ

Approclev      APPROCLEV    Required

                            APD-COMPANY          -> APR-COMPANY
                            APD-PROC-LEVEL       -> APR-PROC-LEVEL

Apuaval        APUAVAL      Not Required

                            "D"                  -> UAV-SEG-TYPE
                            APD-API-OBJ-ID       -> UAV-API-OBJ-ID
                            APD-DIST-SEQ-NBR     -> UAV-DIST-SEQ-NBR

Apvenmast      APVENMAST    Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            APD-VENDOR           -> VEN-VENDOR

Asset          APASTDTL     Not Required

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

Distribproc    APPROCLEV    Required

                            APD-COMPANY          -> APR-COMPANY
                            APD-PROC-LEVEL       -> APR-PROC-LEVEL

Dstusrfld      APDSUSRFLD   Not Required

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

Glmaster       GLMASTER     Required

                            APD-DIST-COMPANY     -> GLM-COMPANY
                            APD-DIS-ACCT-UNIT    -> GLM-ACCT-UNIT
                            APD-DIS-ACCOUNT      -> GLM-ACCOUNT
                            APD-DIS-SUB-ACCT     -> GLM-SUB-ACCOUNT

Glsystem Orig  GLSYSTEM     Required

                            APD-COMPANY          -> GLS-COMPANY

Glsystem To    GLSYSTEM     Required

                            APD-DIST-COMPANY     -> GLS-COMPANY

                         APDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sltrans        SLTRANS

                            APD-GLT-OBJ-ID       -> SLT-GLT-OBJ-ID
                                                    SLT-OBJ-ID