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

AP136     AP198     AP212     AP220     AP237     AP282
AP295     AP700     AP95.1    AP95.2    AP95.3    APCP.1
AP00.4    AP211     AP275     MM280     MM80.1    MM80.2
AP272

UPDATED BY

AP115     AP125     AP126     AP170     AP175     AP177
AP178     AP180     AP181     AP190     AP191     AP193
AP195     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP21.1    AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP28.1    AP28.2    AP30.1    AP30.2    AP30.4
AP300     AP305     AP36.2    AP45.1    AP520     API1.1
API2.1    EE135     EE35.1    EE35.2    EE520     MA41.1
MA41.2    MA41.4    MA41.7    MA43.2    MA61.1    MA66.2
MA70.1    MA75.1    MAI1.1    PD20.1    PD20.2    PD20.3
TX101     AP32.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MA70.1
                                                                 MA75.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-VENDOR             Alpha 9  (Right Justified)                AP115   AP125
Element: Vendor        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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-INVOICE            Alpha 22                                  AP115   AP125
Element: Invoice       The 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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-SUFFIX             Numeric 3                                 AP125   AP126
Element: Suffix        The 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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MA70.1
                                                                 MA75.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-CANCEL-SEQ         Numeric 4                                 AP125   AP126
Element: Seq Nbr       The 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-ORIG-DIST-SEQ      Numeric 6                                 AP180   AP181
Element: Dist Seq Nbr  A unique sequence number.                 AP190   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APD-DIST-SEQ-NBR       Numeric 6                                 AP125   AP126
Element: Dist Seq Nbr  A 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-DIST-TYPE          Alpha 1                                   AP125   AP126
Element: Dist Type     The 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  AP21.1
                       G = Gain/Loss Distribution.               AP23.1  AP25.1
                       R = Tax/Reversal Distribution.            AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-POST-OPTION        Alpha 1                                   AP125   AP126
Element: Post Option   The 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

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  AP21.1
                       P = Prepayment.                           AP23.1  AP25.1
                       Y = Prepayment Credit Memo.               AP25.2  AP26.1
                       A = Employee Advance.                     AP27.1  AP28.1
                       M = Employee Advance Credit Memo.         AP28.2  AP30.2
                       E = Employee Expense.                     AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

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
                       5 = Pending                               AP20.7  AP21.1
                       6 = Approved                              AP23.1  AP25.1
                       7 = Rejected                              AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP36.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MA70.1
                                                                 MA75.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

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

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-CURR-RATE          Signed 14.7                               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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-ORIG-BASE-AMT      Signed 18.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-ORIG-TRAN-AMT      Signed 18.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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-TO-BASE-AMT        Signed 18.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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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

APD-UNT-AMOUNT         Signed 18.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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-DIS-ACCT-UNIT      Alpha 15                                  AP125   AP126
Element: Acct Unit     The 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-DIS-SUB-ACCT       Numeric 4                                 AP125   AP126
Element: Sub Acct      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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MA70.1  MA75.1
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-TAX-INDICATOR      Numeric 1                                 AP125   AP126
Element: Tax Indicator 0                                         AP180   AP181
                       1 = Exempt                                AP190   AP20.1
                       2 = Taxable                               AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-TAX-SEQ-NBR        Numeric 4                                 AP180   AP181
Element: Tax Seq Nbr                                             AP190   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

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 Tax.               AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 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  AP21.1
                                                                 AP23.1  AP25.1
                       A = Accrued. The tax does not increase    AP25.2  AP26.1
                       the invoice amount.                       AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 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  AP21.1
                       account numbers. Must be a valid          AP23.1  AP25.1
                       activity in Project Accounting.           AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

APD-ACCT-CATEGORY      Alpha 5                                   AP125   AP126
Element: Acct Category The 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 Project Accounting.           AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

APD-BILL-CATEGORY      Alpha 32                                  AP125   AP126
Element: Bill Category                                           AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MAI1.1  PD20.1
                                                                 PD20.2  PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.1
                                                                 AP30.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1
                                                                 PD20.1  PD20.2
                                                                 PD20.3

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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 MAI1.1

APD-PO-RELEASE         Numeric 4                                 AP125   AP126
Element: Po Release    The 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 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
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP28.1  AP28.2
                                                                 AP30.4  AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-PO-LINE-NBR        Numeric 6                                 AP125   AP126
Element: Line Nbr      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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 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  AP21.1
                       N = No.                                   AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-GLT-OBJ-ID         Numeric 12                                AP125   AP126
GL Interface Object    This is the object identifier. It is      AP170   AP175
ID                     used to relate commitments or posted      AP180   AP181
                       transactions back to the originating      AP190   AP191
                       subsystems. Each subsystem record that    AP193   AP20.1
                       is updated as a commitment or posted      AP20.2  AP20.3
                       transaction is assigned an object         AP20.4  AP20.5
                       identifier. The object identifier is      AP20.7  AP21.1
                       maintained in the subsystem files and in  AP23.1  AP25.1
                       the Activity Commitments Detail and       AP25.2  AP26.1
                       Activity Transaction files. The object    AP27.1  AP28.1
                       identifier is a unique key used to drill  AP28.2  AP30.2
                       back from Activity Management to the      AP30.4  AP45.1
                       subsystems.                               AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP30.4  AP45.1
                                                                 AP520   API1.1
                                                                 API2.1  EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA66.2
                                                                 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  AP21.1
                       Blank = No asset information is defined   AP23.1  AP25.1
                       for the distribution.                     AP25.2  AP26.1
                       Y = Asset or Repair                       AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA66.2  MAI1.1

APD-DIST-CODE          Alpha 9                                   AP125   AP126
Element: Dist Code     The 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  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  AP21.1
                       P = Payment.                              AP23.1  AP25.1
                       G = GL Post Date                          AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  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  AP21.1
                       transactions are sent to the general      AP23.1  AP25.1
                       ledger, this field changes to Yes. Valid  AP25.2  AP26.1
                       values are:                               AP27.1  AP28.1
                                                                 AP28.2  AP45.1
                       N = No.                                   API1.1  API2.1
                       Y = Yes.                                  MA41.1  MA41.2
                                                                 MA41.4  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  AP21.1
                                                                 AP23.1  AP28.1
                                                                 AP28.2  AP30.4
                                                                 AP45.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  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  AP21.1
                       process to determine whether the          AP23.1  AP25.1
                       distribution should be deleted (match     AP25.2  AP26.1
                       distribution) or left untouched           AP27.1  AP28.1
                       (miscellaneous distribution).             AP28.2  AP45.1
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP30.2
                                                                 AP45.1  AP520
                                                                 API1.1  API2.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  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
                                                                 AP21.1  AP23.1
                                                                 AP30.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

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

APD-AC-UPD-STATUS      Numeric 1                                 AP125   AP126
Element: Ac Upd Status AC provides status that the activity      AP175   AP178
                       reflects "cash basis" billing. Status     AP20.1  AP20.2
                       change will reflect AP invoice for        AP20.3  AP20.4
                       distibution has been paid and message of  AP20.5  AP20.7
                       payment has been sent to AC.              AP21.1  AP23.1
                       0 = No payment information impact         AP25.1  AP25.2
                       1 = Requires payment information          AP26.1  AP27.1
                       9 = AP invoice paid. AC updated.          AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-AC-UPD-DATE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Ac Upd Date   Last Ac distribtion record status change  AP175   AP178
                       date.                                     AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-AC-UPD-TIME        Numeric 6  (hhmmss)                       AP125   AP126
Element: Ac Upd Time   Last AC distribution record change time.  AP175   AP178
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MAI1.1

APD-DIVERSE-CODE       Alpha 5                                   AP125   AP126
Element: Diverse Code  Diversity Code for Account Payable        AP25.1  AP25.2
                       Vendors                                   AP26.1  AP27.1
                                                                 AP520   MA61.1
                                                                 MAI1.1

APD-DISTRIB-ADJ        Numeric 1                                 AP30.2
Element: Distrib Adj   Identifies distribution as one that was
                       created from AP30.2 Distribution
                       Adjustments.  If created in AP30.2 form
                       value equal to '1'.  Used to determine
                       source code to send to GLTRANS and
                       ACTRANS.
                       1 = Distribution Adjustment
                       0

APD-DIST-STATUS        Derived
Element: Dist Status   Indicates whether the distribution is
                       posted or unposted.

APD-TAX-FLAG           Alpha 1                                   TX101
Element: All Flag

APD-ICN-CODE           Alpha 8                                   AP20.1  AP20.2
Element: Icn Code                                                AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP30.1  AP30.2
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APD-WEIGHT             Signed 9.3                                AP20.1  AP20.2
Element: Weight        This field contains the unit weight of    AP20.3  AP20.4
                       the item based on the stocking UOM.       AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP30.1  AP30.2
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APD-SUPLMNTARY-QTY     Signed 13.4                               AP20.1  AP20.2
Element: Quantity      This field contains the desired           AP20.3  AP20.4
                       quantity.                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP30.1  AP30.2
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APD-LINE-TYPE          Alpha 1                                   AP20.1  AP20.2
Element: Line Type     This field contains the type of           AP20.3  AP20.4
                       inventory on this line.                   AP20.5  AP20.7
                       G = Goods                                 AP21.1  AP23.1
                       S = Service                               AP30.1  AP30.2
                                                                 AP520   API1.1
                                                                 API2.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2

APD-STATEMENT          Alpha 22                                  API1.1  PD20.1
Element: Invoice       Used to identify the invoice.             PD20.2  PD20.3

APD-TXN-NBR            Alpha 22                                  API1.1  PD20.1
Element: Transaction                                             PD20.2  PD20.3

                         APDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APDSET1   API-OBJ-ID                                             AP115   AP125
          DIST-SEQ-NBR                                           AP126   AP136
                                                                 AP170   AP175
                                                                 AP178   AP180
                                                                 AP181   AP190
                                                                 AP191   AP193
                                                                 AP195   AP198
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP212
                                                                 AP220   AP23.1
                                                                 AP237   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP282
                                                                 ...

APDSET10  API-OBJ-ID    KeyChange, Subset                        AP20.1  AP20.2
          ORIG-DIST-SEQ Where (ORIG-DIST-SEQ != Zeroes )         AP20.3  AP20.4
          TAX-SEQ-NBR   And   (TAX-SEQ-NBR   != Zeroes )         AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2

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

APDSET12  COMPANY       Subset
          STATEMENT     Where (PO-NUMBER = Spaces )
          TXN-NBR
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET2   COMPANY       KeyChange                                AP00.4  AP175
          REC-STATUS                                             AP178   AP195
          PROC-LEVEL                                             AP211   TX101
          DIS-ACCT-UNIT
          DIS-ACCOUNT
          DIS-SUB-ACCT
          DISTRIB-DATE
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET3   DIST-COMPANY  KeyChange                                AP95.2  AP95.3
          ACTIVITY
          ACCT-CATEGORY
          DISTRIB-DATE
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET4   DIST-COMPANY  KeyChange                                AP237   AP275
          DIS-ACCT-UNIT                                          AP95.2  AP95.3
          DIS-ACCOUNT
          DIS-SUB-ACCT
          DISTRIB-DATE
          API-OBJ-ID
          DIST-SEQ-NBR

APDSET5   GLT-OBJ-ID    KeyChange, Subset                        MM280   MM80.1
          API-OBJ-ID    Where GLT-OBJ-ID != Zeroes               MM80.2
          DIST-SEQ-NBR

APDSET6   DST-OBJ-ID    KeyChange, Subset
                        Where DST-OBJ-ID != Zeroes

APDSET7   VENDOR                                                 AP272   AP36.2
          API-OBJ-ID                                             TX101
          DIST-SEQ-NBR

APDSET8   COMPANY       KeyChange, Subset                        AP20.1  AP20.2
          PO-NUMBER     Where PO-NUMBER != Spaces                AP20.3  AP20.4
          PO-RELEASE                                             AP20.5  AP20.7
          PO-CODE                                                AP21.1  AP23.1
          PO-LINE-NBR                                            MA41.1  MA41.2
          PO-AOC-CODE                                            MA41.4  MA41.7
          API-OBJ-ID                                             MA43.2
          DIST-SEQ-NBR

APDSET9   ATN-OBJ-ID    KeyChange, Subset
          COMPANY       Where ATN-OBJ-ID != Zeroes
          VENDOR
          INVOICE
          SUFFIX
          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

Apdistrib      APDISTRIB    Delete Cascades

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

Apvendiv       APVENDIV

                            CPY-VENDOR-GROUP     -> VDC-VENDOR-GROUP
                            APD-VENDOR           -> VDC-VENDOR
                            API-LOCATION         -> VDC-LOCATION-CODE
                                                    VDC-DIVERSE-CODE
                                                    VDC-DCERT-DATE

Pdchrgdist     PDCHRGDIST

                            APD-COMPANY          -> PDS-COMPANY
                            APD-STATEMENT        -> PDS-STATEMENT
                            APD-TXN-NBR          -> PDS-TXN-NBR
                            APD-DIST-SEQ-NBR     -> PDS-SEQ-NBR
                                                    PDS-PCARD-PROGRAM

Sltrans        SLTRANS

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