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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MOP-COMPANY Numeric 4 MA54.3
Company The company number represents an
established company and is entered on
all function codes.
MOP-VENDOR Alpha 9 (Right Justified) MA54.3
Vendor ID The vendor's identification code.
MOP-EDI-NBR Alpha 15 MA54.3
EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
MOP-INVOICE Alpha 22 MA54.3
Invoice Number Used to identify the invoice.
MOP-SUFFIX Numeric 3 MA54.3
Invoice Suffix This is the suffix for the invoice.
MOP-SEQ-NBR Numeric 4 MA54.3
Sequence Number An automatically assigned sequence
number.
MOP-LINE-NBR Numeric 6 MA54.3
Line Number This field contains the line number of
the purchase order.
MOP-ITEM Alpha 32 MA54.3
Item Number This field contains the item
identifier.
MOP-VEN-ITEM Alpha 32 MA54.3
Vendor Item The vendor's item identifer.
MOP-ENTERED-QTY Signed 13.4 MA54.3
Entered Qty Required. The quantity of goods being
invoiced on the detail line.
MOP-ENT-UOM Alpha 4 MA54.3
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
Unit Cost Required. The unit cost of the line
item detail.
MOP-EXTENDED-AMT Signed 15.2 MA54.3
Extended Amount The total value of all the items
received on a given receiver.
MOP-LOCATION Alpha 5 MA54.3
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
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
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
Retail Unit Cost The retail unit cost of the line item
detail.
MOP-ELEMENT-VAL Alpha 32 Occurs 10 Times MA54.3
Element Val
MOP-DIST-COMPANY Numeric 4 MA54.3
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
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
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
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
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
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
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
No Tax Flag N = No
Y = Yes
MOP-TAX-USAGE-CD Alpha 10 MA54.3
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
Icn Code
MOP-SUPLMNTARY-QTY Signed 13.4 MA54.3
Suplmntary Qty
MOP-WEIGHT Signed 9.3 MA54.3
Unit Weight This field contains the unit weight of
the item based on the stocking UOM.
MOP-SEGMENT-BLOCK Alpha 103 MA54.3
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
EDI-NBR
INVOICE
SUFFIX
SEQ-NBR
|
