MACINVDTL – Invoice Conversion/Interface

System
Matching (MA)
Prefix
MOP
Primary key
COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR
Fields
48
Updated by
3 programs
Referenced by
0 programs

MACINVDTL is the Invoice Conversion/Interface table in Lawson Matching (prefix MOP). It is indexed by COMPANY, VENDOR, EDI-NBR, INVOICE, SUFFIX, SEQ-NBR (MOPSET1). It is updated by MA54.1, MA54.3 and MA540. The table has 48 fields, 1 index and 0 documented relations.

About MACINVDTL

No description in the Lawson data dictionary.

Fields (48)

Column = COBOL field name without the MOP- 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 / columnTypeDescription & valuesUpdated by
#MOP-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.3, MA540
#MOP-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.MA54.3, MA540
#MOP-EDI-NBR PK
EDI_NBR		Alpha 15The electronic data interchange (EDI) number assigned to the vendor.MA54.3, MA540
#MOP-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.MA54.3, MA540
#MOP-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.MA54.3, MA540
#MOP-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.MA54.3, MA540
#MOP-LINE-NBR
LINE_NBR		Numeric 6This field contains the line number of the purchase order.MA54.3, MA540
#MOP-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.MA54.3, MA540
#MOP-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).MA54.3, MA540
#MOP-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.MA54.3, MA540
#MOP-ITEM
ITEM		Alpha 32This field contains the item identifier.MA54.3, MA540
#MOP-VEN-ITEM
VEN_ITEM		Alpha 32This field contains the item identifier.MA54.3, MA540
#MOP-ENTERED-QTY
ENTERED_QTY		Signed 13.4Required. The quantity of goods being invoiced on the detail line.MA54.3, MA540
#MOP-ENT-UOM
ENT_UOM		Alpha 4The unit of measure the entered quantity is expressed in. If left blank, the unit of measure will default from the item/vendor definition, if it exists. If no item/vendor definition exists, the default vendor buy unit of measure will be used. The unit of measure must be valid for the item.MA54.3, MA540
#MOP-UNIT-COST
UNIT_COST		Signed 18.5Required. The unit cost of the line item detail.MA54.3, MA540
#MOP-EXTENDED-AMT
EXTENDED_AMT		Signed 18.2The total value of all the items received on a given receiver.MA540
#MOP-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory system. Must be equal to the invoice company location.MA54.3, MA540
#MOP-AOC-CODE
AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.MA540
#MOP-TOTAL-AOC
TOTAL_AOC		Signed 18.2The total add on cost amount. Required if an AOC code is defined.MA540
#MOP-RTL-UNIT-COST
RTL_UNIT_COST		Signed 18.5The retail unit cost of the line item detail.MA54.3, MA540
#MOP-ELEMENT-VAL
ELEMENT_VAL		Alpha 32 Occurs 10 Times ×10—MA54.3, MA540
#MOP-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.3, MA540
#MOP-ACCT-UNIT
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.3, MA540
#MOP-ACCOUNT
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.3, MA540
#MOP-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.MA54.3, MA540
#MOP-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.3, MA540
#MOP-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.3, MA540
#MOP-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—MA54.3, MA540
#MOP-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.MA54.3, MA540
#MOP-NO-TAX-FLAG
NO_TAX_FLAG		Alpha 1—
  • N No
  • Y Yes
MA54.3, MA540
#MOP-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.3, MA540
#MOP-ICN-CODE
ICN_CODE		Alpha 8—MA54.3, MA540
#MOP-SUPLMNTARY-QTY
SUPLMNTARY_QTY		Signed 13.4This field contains the desired quantity.MA54.3, MA540
#MOP-WEIGHT
WEIGHT		Signed 9.3This field contains the unit weight of the item based on the stocking UOM.MA54.3, MA540
#MOP-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.3, MA540
#MOP-PREPAY-QTY
PREPAY_QTY		Signed 13.4——
#MOP-PRPY-UNIT-CST
PRPY_UNIT_CST		Signed 18.5——
#MOP-PRPY-TAX-CODE
PRPY_TAX_CODE		Alpha 10——
#MOP-PRPY-TAX-AMT
PRPY_TAX_AMT		Signed 18.2——
#MOP-PRPY-RTL-UCST
PRPY_RTL_UCST		Signed 18.5——
#MOP-PREPAY-DATE
PREPAY_DATE		Numeric 8 (yyyymmdd)——
#MOP-XREF-VENDOR
XREF_VENDOR		Alpha 9 (Right Justified)This is a vendor that is supported on a system outside Lawson. When records are interfaces we will maintain this vendor on the file but we will use the Lawson vendor while in the lawson application.—
#MOP-CATCH-WGT-COST
CATCH_WGT_COST		Signed 18.5——
#MOP-COMMODITY-CODE
COMMODITY_CODE		Alpha 35—MA54.3, MA540
#MOP-RET-PCT
RET_PCT		Percent 5.2 (Percent)—MA54.3, MA540
#MOP-GTIN
GTIN		Numeric 14—MA54.3, MA540
#MOP-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15—MA54.3, MA540
#MOP-COST-OPTION
COST_OPTION		Alpha 1" " = Default from PO line
  • 1 Cost Required
  • 2 No Charge
  • 3 Vendor Determined
—

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.

IndexKeysFlagsConditionUsed in
MOPSET1
  1. COMPANY
  2. VENDOR
  3. EDI-NBR
  4. INVOICE
  5. SUFFIX
  6. SEQ-NBR
PrimaryMA54.1, MA54.3, MA540

Programs

Updated by (3)