MACINVDTL FILE
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 Numeric 4 MA54.3 MA540
Company The company number represents an
established company and is entered on
all function codes.
MOP-VENDOR Alpha 9 (Right Justified) MA54.3 MA540
Vendor ID The vendor's identification code.
MOP-EDI-NBR Alpha 15 MA54.3 MA540
EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
MOP-INVOICE Alpha 22 MA54.3 MA540
Invoice Number Used to identify the invoice.
MOP-SUFFIX Numeric 3 MA54.3 MA540
Invoice Suffix This is the suffix for the invoice.
MOP-SEQ-NBR Numeric 4 MA54.3 MA540
Sequence Number An automatically assigned sequence
number.
MOP-LINE-NBR Numeric 6 MA54.3 MA540
Line Number This field contains the line number of
the purchase order.
MOP-PO-NUMBER Alpha 14 (Right Justified)
PO Number This field contains the number
representing the purchase order.
MOP-PO-RELEASE Numeric 4
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
MOP-PO-CODE Alpha 4
Po Code This is the purchase order code.
MOP-ITEM Alpha 32 MA54.3 MA540
Item Number This field contains the item
identifier.
MOP-VEN-ITEM Alpha 32 MA54.3 MA540
Vendor Item The vendor's item identifer.
MOP-ENTERED-QTY Signed 13.4 MA54.3 MA540
Entered Qty Required. The quantity of goods being
invoiced on the detail line.
MOP-ENT-UOM Alpha 4 MA54.3 MA540
Ent Uom 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.
MOP-UNIT-COST Signed 13.5 MA54.3 MA540
Unit Cost Required. The unit cost of the line
item detail.
MOP-EXTENDED-AMT Signed 15.2 MA54.3 MA540
Extended Amount The total value of all the items
received on a given receiver.
MOP-LOCATION Alpha 5 MA54.3 MA540
Location Code This field contains a valid stocking
location within the company inventory
system. Must be equal to the invoice
company location.
MOP-AOC-CODE Alpha 2 MA54.3 MA540
Add On Cost Code This field contains the identifier for
the add on cost associated with this
line item.
MOP-TOTAL-AOC Signed 15.2 MA54.3 MA540
Total Add On Cost The total add on cost amount. Required
if an AOC code is defined.
MOP-RTL-UNIT-COST Signed 13.5 MA54.3 MA540
Retail Unit Cost The retail unit cost of the line item
detail.
MOP-ELEMENT-VAL Alpha 32 Occurs 10 Times MA54.3 MA540
Element Val
MOP-DIST-COMPANY Numeric 4 MA54.3 MA540
Distribution Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
MOP-ACCT-UNIT Alpha 15 MA54.3 MA540
Accounting Unit 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.
MOP-ACCOUNT Numeric 6 MA54.3 MA540
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
MOP-SUB-ACCT Numeric 4 MA54.3 MA540
Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
MOP-ACTIVITY Alpha 15 MA54.3 MA540
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
MOP-ACCT-CATEGORY Alpha 5 MA54.3 MA540
Account Category 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.
MOP-TAX-CODE Alpha 10 MA54.3 MA540
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MOP-NO-TAX-FLAG Alpha 1 MA54.3 MA540
No Tax Flag N = No
Y = Yes
MOP-TAX-USAGE-CD Alpha 10 MA54.3 MA540
Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
MOP-ICN-CODE Alpha 8 MA54.3 MA540
Icn Code
MOP-SUPLMNTARY-QTY Signed 13.4 MA54.3 MA540
Suplmntary Qty
MOP-WEIGHT Signed 9.3 MA54.3 MA540
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
MOP-SEGMENT-BLOCK Alpha 103 MA54.3 MA540
User Analysis 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.
MACINVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MOPSET1 COMPANY MA54.1 MA54.3
VENDOR MA540
EDI-NBR
INVOICE
SUFFIX
SEQ-NBR
|
