Invoice Distrib Conversion
The Invoice Distribution Conversion/Interface file contains invoice distribution information that has been loaded from an external source.
REFERENCED 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. |
|
||
MDA-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||
MDA-EDI-NBR Element: Edi Nbr | Alpha 15 The electronic data interchange (EDI) number assigned to the vendor. |
|
||
MDA-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||
MDA-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
MDA-DIST-SEQ-NBR Element: Dist Seq Nbr | Numeric 6 A unique sequence number. |
|
||
MDA-TAXABLE-AMT Element: Intl Amt | Signed 18.2 |
|
||
MDA-ORIG-TRAN-AMT Element: Intl Amt | Signed 18.2 The amount of the invoice distribution in the currency of the invoice. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
MDA-TAX-INDICATOR Element: Tax Indicator | Numeric 1 |
|
||
MDA-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
MDA-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The description of the distribution. If left blank, the vendor number and name default. |
|
||
MDA-DST-REFERENCE Element: Cross Ref | Alpha 10 The distribution reference. If left blank, the default reference value defined in AP Company defaults. |
|
||
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. |
|
||
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 |
|
||
MDA-BILL-CATEGORY Element: Bill Category | Alpha 32 |
|
||
MDA-UNT-AMOUNT Element: Unit Amount | Signed 18.2 |
|
||
MDA-ASSET-DESC Element: Asset Description | Alpha 30 (Lower Case) A description of the asset if an asset is assigned to the distribution. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
MDA-ITEM-DESC Element: Item Desc | Alpha 30 This field contains the description for stock and non-stock items. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
MDA-SERIAL-NUMBER Element: Serial Number | Alpha 30 This optional field is used for the serial number of the asset. |
|
||
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. |
|
||
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. |
|
||
MDA-ITEM-TAX-TRAN Element: Tax Amount | Signed 18.2 The tax amount associated with the asset distribution in the currency of the transaction. |
|
||
MDA-ASSET-GROUP Element: Asset Group | Alpha 10 The asset group assigned to the distribution. |
|
||
MDA-COMBINE Element: Combine Assets | Alpha 10 This field indicates whether to combine items as one asset. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
MDA-ICN-CODE Element: Icn Code | Alpha 8 |
|
||
MDA-WEIGHT Element: Weight | Signed 9.3 This field contains the unit weight of the item based on the stocking UOM. |
|
||
MDA-SUPLMNTARY-QTY Element: Quantity | Signed 13.4 This field contains the desired quantity. |
|
||
MDA-LINE-TYPE Element: Line Type | Alpha 1 This field contains the type of inventory on this line. |
|
||
MDA-CONTRACT-GROUP Element: Enterprise Grp | Alpha 4 |
|
||
MDA-CM-CONTRACT Element: Cm Contract | Numeric 15 |
|
||
MDA-REBATE-TYPE Element: Rebate Type | Alpha 25 |
|
||
MDA-REBATE-DUE-DTE Element: Date | Numeric 8 (yyyymmdd) |
|
||
MDA-REBATE-SEQ Element: Seq Number | Numeric 6 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MDASET1 |
COMPANY VENDOR EDI-NBR INVOICE SUFFIX DIST-SEQ-NBR |
|
|
All trademarks and registered trademarks are the property of their
respective owners.