Invoice Conversion/Interface

The Invoice Conversion/Interface file contains invoice detail information that has been interfaced or converted from an external source.
UPDATED BY

MA54.1

MA54.3

MA540

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MOP-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.3 MA540
MOP-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor's identification code.	MA54.3 MA540
MOP-EDI-NBR Element: Edi Nbr	Alpha 15 The electronic data interchange (EDI) number assigned to the vendor.	MA54.3 MA540
MOP-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.	MA54.3 MA540
MOP-SUFFIX Element: Suffix	Numeric 3 This is the suffix for the invoice.	MA54.3 MA540
MOP-SEQ-NBR Element: Seq Nbr	Numeric 4 An automatically assigned sequence number.	MA54.3 MA540
MOP-LINE-NBR Element: Line Nbr	Numeric 6 This field contains the line number of the purchase order.	MA54.3 MA540
MOP-PO-NUMBER Element: Po Number	Alpha 14 (Right Justified) This field contains the number representing the purchase order.	MA54.3
MOP-PO-RELEASE Element: Po Release	Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order).	MA54.3
MOP-PO-CODE Element: Po Code	Alpha 4 This is the purchase order code.	MA54.3
MOP-ITEM Element: Item	Alpha 32 This field contains the item identifier.	MA54.3 MA540
MOP-VEN-ITEM Element: Item	Alpha 32 This field contains the item identifier.	MA54.3 MA540
MOP-ENTERED-QTY Element: Quantity	Signed 13.4 Required. The quantity of goods being invoiced on the detail line.	MA54.3 MA540
MOP-ENT-UOM Element: Uom	Alpha 4 The 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 Element: Intl Cost	Signed 18.5 Required. The unit cost of the line item detail.	MA54.3 MA540
MOP-EXTENDED-AMT Element: Extended Amount	Signed 18.2 The total value of all the items received on a given receiver.	MA540
MOP-LOCATION Element: Location	Alpha 5 This 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 Element: Aoc Code	Alpha 2 This field contains the identifier for the add on cost associated with this line item.	MA540
MOP-TOTAL-AOC Element: Intl Amt	Signed 18.2 The total add on cost amount. Required if an AOC code is defined.	MA540
MOP-RTL-UNIT-COST Element: Retail Unit Cost	Signed 18.5 The retail unit cost of the line item detail.	MA54.3 MA540
MOP-ELEMENT-VAL Element: Element Value	Alpha 32 Occurs 10 Times	MA54.3 MA540
MOP-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.3 MA540
MOP-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.3 MA540
MOP-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.3 MA540
MOP-SUB-ACCT Element: Sub Acct	Numeric 4 This 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 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.3 MA540
MOP-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.3 MA540
MOP-BILL-CATEGORY Element: Bill Category	Alpha 32	MA54.3 MA540
MOP-TAX-CODE Element: Tax Code	Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code.	MA54.3 MA540
MOP-NO-TAX-FLAG Element: Account Flag	Alpha 1 N = No Y = Yes	MA54.3 MA540
MOP-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.3 MA540
MOP-ICN-CODE Element: Icn Code	Alpha 8	MA54.3 MA540
MOP-SUPLMNTARY-QTY Element: Quantity	Signed 13.4 This field contains the desired quantity.	MA54.3 MA540
MOP-WEIGHT Element: Weight	Signed 9.3 This field contains the unit weight of the item based on the stocking UOM.	MA54.3 MA540
MOP-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.3 MA540
MOP-PREPAY-QTY Element: Prepay Qty	Signed 13.4
MOP-PRPY-UNIT-CST Element: Intl Cost	Signed 18.5
MOP-PRPY-TAX-CODE Element: Prpy Tax Code	Alpha 10
MOP-PRPY-TAX-AMT Element: Intl Amt	Signed 18.2
MOP-PRPY-RTL-UCST Element: Intl Cost	Signed 18.5
MOP-PREPAY-DATE Element: Prepay Date	Numeric 8 (yyyymmdd)
MOP-XREF-VENDOR Element: 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 Element: Intl Cost	Signed 18.5
MOP-COMMODITY-CODE Element: Commodity Code	Alpha 35	MA54.3 MA540
MOP-RET-PCT Element: Pct	Percent 5.2 (Percent)	MA54.3 MA540
MOP-GTIN Element: Gtin	Numeric 14	MA54.3 MA540

MACINVDTL FILE INDEX

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