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.

Field / columnTypeDescription & valuesUpdated by
MDA-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.MA54.2, MA540
MDA-EDI-NBR PK
EDI_NBR		Alpha 15The electronic data interchange (EDI) number assigned to the vendor.MA54.2, MA540
MDA-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.MA54.2, MA540
MDA-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.MA54.2, MA540
MDA-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number.MA54.2, MA540
MDA-TAXABLE-AMT
TAXABLE_AMT		Signed 18.2—MA54.2, MA540
MDA-ORIG-TRAN-AMT
ORIG_TRAN_AMT		Signed 18.2The amount of the invoice distribution in the currency of the invoice.MA54.2, MA540
MDA-DIST-COMPANY
DIST_COMPANY		Numeric 4Identifies 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
DIS_ACCT_UNIT		Alpha 15The 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
DIS_ACCOUNT		Numeric 6This 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
DIS_SUB_ACCT		Numeric 4The 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
TAX_INDICATOR		Numeric 1—MA54.2, MA540
MDA-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.MA54.2, MA540
MDA-DESCRIPTION
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
DST_REFERENCE		Alpha 10The distribution reference. If left blank, the default reference value defined in AP Company defaults.MA54.2, MA540
MDA-ACTIVITY
ACTIVITY		Alpha 15Activities 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
ACCT_CATEGORY		Alpha 5Account 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 thruMA54.2, MA540
MDA-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—MA54.2, MA540
MDA-UNT-AMOUNT
UNT_AMOUNT		Signed 18.2—MA54.2, MA540
MDA-ASSET-DESC
ASSET_DESC		Alpha 30 (Lower Case)A description of the asset if an asset is assigned to the distribution.MA54.2, MA540
MDA-TAG-NBR
TAG_NBR		Alpha 12If 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
ITEM_NBR		Alpha 32If 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
ITEM_QUANTITY		Numeric 8If 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
ITEM_DESC		Alpha 30This field contains the description for stock and non-stock items.MA54.2, MA540
MDA-VEN-ITEM
VEN_ITEM		Alpha 32This field contains the item identifier.—
MDA-ASSET-TEMPLATE
ASSET_TEMPLATE		Alpha 10A 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
INSRV_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
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
MODEL_NUMBER		Alpha 30The 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
SERIAL_NUMBER		Alpha 30This optional field is used for the serial number of the asset.MA54.2, MA540
MDA-HOLD-AM
HOLD_AM		Alpha 1This 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
ASSET		Numeric 10The 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
ITEM_TAX_TRAN		Signed 18.2The tax amount associated with the asset distribution in the currency of the transaction.MA54.2, MA540
MDA-ASSET-GROUP
ASSET_GROUP		Alpha 10The asset group assigned to the distribution.MA54.2, MA540
MDA-COMBINE
COMBINE		Alpha 10This field indicates whether to combine items as one asset.MA54.2, MA540
MDA-AU-GROUP
AU_GROUP		Alpha 10Accounting 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
TAX_USAGE_CD		Alpha 10The 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
DST_USR_FLD_01		Alpha 20Distribution 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
DST_USR_FLD_02		Alpha 20Distribution 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
DST_USR_FLD_03		Alpha 20Distribution 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
DST_USR_FLD_04		Alpha 20Distribution 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
DST_USR_FLD_05		Alpha 20Distribution 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
PO_AOC_CODE		Alpha 2Add 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
SEGMENT_BLOCK		Alpha 103This 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
ICN_CODE		Alpha 8—MA54.2, MA540
MDA-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.MA54.2, MA540
MDA-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4This field contains the desired quantity.MA54.2, MA540
MDA-LINE-TYPE
LINE_TYPE		Alpha 1This field contains the type of inventory on this line.MA54.2, MA540
MDA-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 4—MA54.2, MA540
MDA-CM-CONTRACT
CM_CONTRACT		Numeric 15—MA54.2, MA540
MDA-REBATE-TYPE
REBATE_TYPE		Alpha 25—MA54.2, MA540
MDA-REBATE-DUE-DTE
REBATE_DUE_DTE		Numeric 8 (yyyymmdd)—MA54.2, MA540
MDA-REBATE-SEQ
REBATE_SEQ		Numeric 6——

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MDASET1COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, DIST-SEQ-NBRPrimaryAC191, 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)