MACAPDTL – Invoice Distrib Conversion
- System
- Matching (MA)
- Prefix
MDA- Primary key
COMPANY,VENDOR,EDI-NBR,INVOICE,SUFFIX,DIST-SEQ-NBR- Fields
- 54
- Updated by
- 3 programs
- Referenced by
- 113 programs
MACAPDTL is the Invoice Distrib Conversion table in Lawson Matching (prefix MDA). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBR (MDASET1). It is updated by MA54.1, MA54.2 and MA540 and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 105 more. The table has 54 fields, 1 index and 0 documented relations.
About MACAPDTL
The Invoice Distribution Conversion/Interface file contains invoice distribution information that has been loaded from an external source.
Fields (54)
Column = COBOL field name without the MDA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#MDA-COMPANY PKCOMPANY | 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 PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | MA54.2, MA540 |
#MDA-EDI-NBR PKEDI_NBR | Alpha 15 | The electronic data interchange (EDI) number assigned to the vendor. | MA54.2, MA540 |
#MDA-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | MA54.2, MA540 |
#MDA-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | MA54.2, MA540 |
#MDA-DIST-SEQ-NBR PKDIST_SEQ_NBR | Numeric 6 | A unique sequence number. | MA54.2, MA540 |
#MDA-TAXABLE-AMTTAXABLE_AMT | Signed 18.2 | — | MA54.2, MA540 |
#MDA-ORIG-TRAN-AMTORIG_TRAN_AMT | Signed 18.2 | The amount of the invoice distribution in the currency of the invoice. | MA54.2, MA540 |
#MDA-DIST-COMPANYDIST_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-UNITDIS_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-ACCOUNTDIS_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-ACCTDIS_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-INDICATORTAX_INDICATOR | Numeric 1 | — | MA54.2, MA540 |
#MDA-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | MA54.2, MA540 |
#MDA-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the distribution. If left blank, the vendor number and name default. | MA54.2, MA540 |
#MDA-DST-REFERENCEDST_REFERENCE | Alpha 10 | The distribution reference. If left blank, the default reference value defined in AP Company defaults. | MA54.2, MA540 |
#MDA-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-CATEGORYBILL_CATEGORY | Alpha 32 | — | MA54.2, MA540 |
#MDA-UNT-AMOUNTUNT_AMOUNT | Signed 18.2 | — | MA54.2, MA540 |
#MDA-ASSET-DESCASSET_DESC | Alpha 30 (Lower Case) | A description of the asset if an asset is assigned to the distribution. | MA54.2, MA540 |
#MDA-TAG-NBRTAG_NBR | 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-NBRITEM_NBR | 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-QUANTITYITEM_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-DESCITEM_DESC | Alpha 30 | This field contains the description for stock and non-stock items. | MA54.2, MA540 |
#MDA-VEN-ITEMVEN_ITEM | Alpha 32 | This field contains the item identifier. | — |
#MDA-ASSET-TEMPLATEASSET_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-DATEINSRV_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-DATEPURCHASE_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-NUMBERMODEL_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-NUMBERSERIAL_NUMBER | Alpha 30 | This optional field is used for the serial number of the asset. | MA54.2, MA540 |
#MDA-HOLD-AMHOLD_AM | 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:
| MA54.2, MA540 |
#MDA-ASSETASSET | 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-TRANITEM_TAX_TRAN | Signed 18.2 | The tax amount associated with the asset distribution in the currency of the transaction. | MA54.2, MA540 |
#MDA-ASSET-GROUPASSET_GROUP | Alpha 10 | The asset group assigned to the distribution. | MA54.2, MA540 |
#MDA-COMBINECOMBINE | Alpha 10 | This field indicates whether to combine items as one asset. | MA54.2, MA540 |
#MDA-AU-GROUPAU_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-CDTAX_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-01DST_USR_FLD_01 | Alpha 20 | Distribution user-defined field number one. This field can only be used for an AP invoice, or invoices where the Match
| MA54.2, MA540 |
#MDA-DST-USR-FLD-02DST_USR_FLD_02 | 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-03DST_USR_FLD_03 | 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-04DST_USR_FLD_04 | 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-05DST_USR_FLD_05 | 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-CODEPO_AOC_CODE | 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-BLOCKSEGMENT_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-CODEICN_CODE | Alpha 8 | — | MA54.2, MA540 |
#MDA-WEIGHTWEIGHT | Signed 9.3 | This field contains the unit weight of the item based on the stocking UOM. | MA54.2, MA540 |
#MDA-SUPLMNTARY-QTYSUPLMNTARY_QTY | Signed 13.4 | This field contains the desired quantity. | MA54.2, MA540 |
#MDA-LINE-TYPELINE_TYPE | Alpha 1 | This field contains the type of inventory on this line. | MA54.2, MA540 |
#MDA-CONTRACT-GROUPCONTRACT_GROUP | Alpha 4 | — | MA54.2, MA540 |
#MDA-CM-CONTRACTCM_CONTRACT | Numeric 15 | — | MA54.2, MA540 |
#MDA-REBATE-TYPEREBATE_TYPE | Alpha 25 | — | MA54.2, MA540 |
#MDA-REBATE-DUE-DTEREBATE_DUE_DTE | Numeric 8 (yyyymmdd) | — | MA54.2, MA540 |
#MDA-REBATE-SEQREBATE_SEQ | Numeric 6 | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MDASET1 |
| Primary | AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) |
Programs
Updated by (3)
Referenced by (113)
- AC191 Accounting Unit Balance Post
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- API1.1 Add Invoice
- API2.1 Add Invoice
- BR44.1 Mass Transaction Transfer
- CB222 Cash Position Reconciliation
- CU00.1 Currency Table
- CU01.1 Currency Code
- CU01.2 Currency Codes
- CU02.1 Currency Relationship
- CU02.2 Relationship Summary
- CU03.1 Currency Gain Loss Accounts
- CU10.1 Exchange Rates
- CU10.2 Daily Rate Entry
- CU20.1 Currency Table Translation Rates
- CU20.2 Currency Table Period Rate Entry
- CU20.3 Company Translation Rates
- DR100 Distribution Requirements Report
- FB45.1 Budget Journal Control
- GL00.2 Define Chart
- GL00.3 Detail Accounts
- GL00.6 Move Detail Account
- GL00.7 System Accounts
- GL00.9 Chart Copy
- GL02.1 Detail Subaccount Definition
- GL02.2 Multiple Detail Subaccount Definition
- GL02.3 Template Subaccount Definition
- GL02.6 Move Detail Account
- GL03.6 Posting Account System Restriction
- GL10.1 Company
- GL10.2 Backposting Control
- GL100 Mass Chart Account Change Delete
- GL110 Company Copy Delete
- GL111 Backposting Control Mass Upd
- GL120 Level Reorganization
- GL121 Mass Account Addition
- GL122 Mass Account Change Delete
- GL124 Mass Accounting Unit Addition
- GL125 Mass Accounting Unit Change
- GL135 Intercompany Chart Map Posting
- GL146 Batch Journal Control
- GL148 Zone Rebalancing
- GL160 Chart of Accounts Interface
- GL161 Accounting Unit Interface
- GL167 Balance Interface
- GL190 Journal Posting
- GL195 Translation Calculation
- GL196 Report Currency Translation
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL20.1 Accounting Units - Accounts
- GL20.2 Posting Accounts
- GL20.4 Mass Add Accounts
- GL330 Undistributed Retained Earnings Rebuild
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.3 Speed Entry
- GL40.7 Totals
- GL40.8 Journal Entry
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- GL500 Fiscal Year Change
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC222 Unreleased Documents
- IC83.1 Par Location Counts
- IFAC.1 General Ledger Account Edit
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA61.1 Match Invoice Approval
- MAI1.1 Invoke for MAMATCH Object
- ML146 Batch Ledger Journal Control
- ML167 Ledger Balance Interface
- ML190 Ledger Journal Posting
- ML195 Ledger Translation Calculation
- ML196 Ledger Report Currency Translation
- ML199 Ledger Period Closing
- ML330 Ledger Undistributed RE Rebuil
- ML40.1 Ledger Journal Entry
- ML40.2 Define Ledger Journal
- ML40.3 Ledger Speed Entry
- ML40.7 Ledger Totals
- ML40.8 Ledger Journal Entry
- ML44.1 Ledger Report Currency Entry
- ML45.1 Ledger Journal Control
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ11.1 Kit Accessories
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIJ.1 Requisition Copy