MACINVDTL

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 MA540
MOP-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
MA54.3 MA540
MOP-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
MA54.3 MA540
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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MOPSET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SUFFIX
SEQ-NBR
MA54.1 MA54.3
MA540


File created: Thu Jun 09 11:20:16 2016

Home
Contact Us



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