MACAPDTL

Invoice Distrib Conversion

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

REFERENCED BY
AC191 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 FB45.1 GL100 GL110 GL111 GL120
GL122 GL135 GL146 GL148 GL167 GL190
GL195 GL196 GL197 GL199 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL500 DR100 IC141 IC142 IC222 IC83.1
CU00.1 CU01.1 CU01.2 CU02.1 CU02.2 CU03.1
CU10.1 CU10.2 CU20.1 CU20.2 CU20.3 GL00.2
GL00.3 GL00.6 GL00.7 GL00.9 GL02.1 GL02.2
GL02.3 GL02.6 GL03.6 GL10.1 GL10.2 GL121
GL124 GL125 GL160 GL161 GL20.1 GL20.2
GL20.4 IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA44.1 MA44.2 MA61.1 MAI1.1
ML146 ML167 ML190 ML195 ML196 ML199
ML330 ML40.1 ML40.2 ML40.3 ML40.7 ML40.8
ML44.1 ML45.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1


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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MDASET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
DIST-SEQ-NBR
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 FB45.1
GL100 GL110
GL111 GL120
GL122 GL135
GL146 GL148
GL167 GL190


File created: Thu Jun 09 02:22:42 2016

Home
Contact Us



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