Invoice Distrib Conversion

The Invoice Distribution Conversion/Interface file contains invoice distribution information that has been loaded from an external source.
UPDATED BY

MA54.1

MA54.2

MA540

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MDA-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	MA54.2 MA540
MDA-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor's identification code.	MA54.2 MA540
MDA-EDI-NBR Element: Edi Nbr	Alpha 15 The electronic data interchange (EDI) number assigned to the vendor.	MA54.2 MA540
MDA-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.	MA54.2 MA540
MDA-SUFFIX Element: Suffix	Numeric 3 This is the suffix for the invoice.	MA54.2 MA540
MDA-DIST-SEQ-NBR Element: Dist Seq Nbr	Numeric 6 A unique sequence number.	MA54.2 MA540
MDA-TAXABLE-AMT Element: Intl Amt	Signed 18.2	MA54.2 MA540
MDA-ORIG-TRAN-AMT Element: Intl Amt	Signed 18.2 The amount of the invoice distribution in the currency of the invoice.	MA54.2 MA540
MDA-DIST-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	MA54.2 MA540
MDA-DIS-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	MA54.2 MA540
MDA-DIS-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	MA54.2 MA540
MDA-DIS-SUB-ACCT Element: Sub Acct	Numeric 4 The general ledger distribution subaccount. If you are using subaccounts, this field is required except for an unreleased distribution with a tax code.	MA54.2 MA540
MDA-TAX-INDICATOR Element: Tax Indicator	Numeric 1	MA54.2 MA540
MDA-TAX-CODE Element: Tax Code	Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code.	MA54.2 MA540
MDA-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description of the distribution. If left blank, the vendor number and name default.	MA54.2 MA540
MDA-DST-REFERENCE Element: Cross Ref	Alpha 10 The distribution reference. If left blank, the default reference value defined in AP Company defaults.	MA54.2 MA540
MDA-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	MA54.2 MA540
MDA-ACCT-CATEGORY Element: Acct Category	Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	MA54.2 MA540
MDA-BILL-CATEGORY Element: Bill Category	Alpha 32	MA54.2 MA540
MDA-UNT-AMOUNT Element: Unit Amount	Signed 18.2	MA54.2 MA540
MDA-ASSET-DESC Element: Asset Description	Alpha 30 (Lower Case) A description of the asset if an asset is assigned to the distribution.	MA54.2 MA540
MDA-TAG-NBR Element: Tag Number	Alpha 12 If the distribution contains asset information, this field contains the tag number assigned to the asset. Represents a short name for a part of an asset.	MA54.2 MA540
MDA-ITEM-NBR Element: Item Number	Alpha 32 If the distribution contains asset information, this field contains the item number of an asset that is composed of different elements, but depreciated as a common asset unit.	MA54.2 MA540
MDA-ITEM-QUANTITY Element: Item Quantity	Numeric 8 If the distribution contains asset information, the number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.	MA54.2 MA540
MDA-ITEM-DESC Element: Item Desc	Alpha 30 This field contains the description for stock and non-stock items.	MA54.2 MA540
MDA-VEN-ITEM Element: Item	Alpha 32 This field contains the item identifier.
MDA-ASSET-TEMPLATE Element: Asset Template	Alpha 10 A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a template lets you default many data items associated with a new asset. You can use an asset template to process quick asset additions in AM20.1 (Quick Addition) and to create assets and asset books from Accounts Payable and Activity Management interface information. Asset templates are required if you define new assets as a result of transactions interfaced from the Lawson Purchase Order or Accounts Payable systems.	MA54.2 MA540
MDA-INSRV-DATE Element: Inservice Date	Numeric 8 (yyyymmdd) The book in-service date for the asset. Note: The in-service date can be different for each depreciation book used.	MA54.2 MA540
MDA-PURCHASE-DATE Element: Purchase Date	Numeric 8 (yyyymmdd) The date the asset was purchased. This purchased date can be different from the in-service dates for the depreciation books used.	MA54.2 MA540
MDA-MODEL-NUMBER Element: Model Number	Alpha 30 The model number assigned to the distribution. Used in conjunction with the Asset Template field. If assigned, an asset template must also be assigned to the distribution.	MA54.2 MA540
MDA-SERIAL-NUMBER Element: Serial Number	Alpha 30 This optional field is used for the serial number of the asset.	MA54.2 MA540
MDA-HOLD-AM Element: Hold Asset	Alpha 1 This field indicates whether to hold the asset in the Asset Interface file. Being held keeps items from becoming assets until they are released from hold. Valid values are: N = No. Default. Y = Yes.	MA54.2 MA540
MDA-ASSET Element: Asset	Numeric 10 The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.	MA54.2 MA540
MDA-ITEM-TAX-TRAN Element: Tax Amount	Signed 18.2 The tax amount associated with the asset distribution in the currency of the transaction.	MA54.2 MA540
MDA-ASSET-GROUP Element: Asset Group	Alpha 10 The asset group assigned to the distribution.	MA54.2 MA540
MDA-COMBINE Element: Combine Assets	Alpha 10 This field indicates whether to combine items as one asset.	MA54.2 MA540
MDA-AU-GROUP Element: Au Group	Alpha 10 Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company.	MA54.2 MA540
MDA-TAX-USAGE-CD Element: Tax Usage Cd	Alpha 10 The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.	MA54.2 MA540
MDA-DST-USR-FLD-01 Distribution User Field 1	Alpha 20 Distribution user-defined field number one. This field can only be used for an AP invoice, or invoices where the Match Flag = No.	MA54.2 MA540
MDA-DST-USR-FLD-02 Distribution User Field 2	Alpha 20 Distribution user-defined field number two. This field can only be used for Accounts Payable type invoices, or invoices where the Match Flag = No.	MA54.2 MA540
MDA-DST-USR-FLD-03 Distribution User Field 3	Alpha 20 Distribution user-defined field number three. This field can only be used for Accounts Payable type invoices, or invoices where the Match Flag = No.	MA54.2 MA540
MDA-DST-USR-FLD-04 Distribution User Field 4	Alpha 20 Distribution user-defined field number four. This field can only be used for Accounts Payable type invoices, or invoices where the Match Flag = No.	MA54.2 MA540
MDA-DST-USR-FLD-05 Distribution User Field 5	Alpha 20 Distribution user-defined field number five. This field can only be used for Accounts Payable type invoices, or invoices where the Match Flag = No.	MA54.2 MA540
MDA-PO-AOC-CODE Purchase Order Add On Cost	Alpha 2 Add on code assigned to a purchase order. Add on costs can be extra costs such as freight costs or other miscellaneous costs, or can be allowances such as credits and returns.	MA54.2 MA540
MDA-SEGMENT-BLOCK Element: Segment Block	Alpha 103 This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	MA54.2 MA540
MDA-ICN-CODE Element: Icn Code	Alpha 8	MA54.2 MA540
MDA-WEIGHT Element: Weight	Signed 9.3 This field contains the unit weight of the item based on the stocking UOM.	MA54.2 MA540
MDA-SUPLMNTARY-QTY Element: Quantity	Signed 13.4 This field contains the desired quantity.	MA54.2 MA540
MDA-LINE-TYPE Element: Line Type	Alpha 1 This field contains the type of inventory on this line.	MA54.2 MA540
MDA-CONTRACT-GROUP Element: Enterprise Grp	Alpha 4	MA54.2 MA540
MDA-CM-CONTRACT Element: Cm Contract	Numeric 15	MA54.2 MA540
MDA-REBATE-TYPE Element: Rebate Type	Alpha 25	MA54.2 MA540
MDA-REBATE-DUE-DTE Element: Date	Numeric 8 (yyyymmdd)	MA54.2 MA540
MDA-REBATE-SEQ Element: Seq Number	Numeric 6

MACAPDTL FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.