|
|
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
Element: Company 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.
MOP-VENDOR Alpha 9 (Right Justified) MA54.3 MA540
Element: Vendor The vendor's identification code.
MOP-EDI-NBR Alpha 15 MA54.3 MA540
Element: Edi Nbr The electronic data interchange (EDI)
number assigned to the vendor.
MOP-INVOICE Alpha 22 MA54.3 MA540
Element: Invoice Used to identify the invoice.
MOP-SUFFIX Numeric 3 MA54.3 MA540
Element: Suffix This is the suffix for the invoice.
MOP-SEQ-NBR Numeric 4 MA54.3 MA540
Element: Seq Nbr An automatically assigned sequence
number.
MOP-LINE-NBR Numeric 6 MA54.3 MA540
Element: Line Nbr This field contains the line number of
the purchase order.
MOP-PO-NUMBER Alpha 14 (Right Justified)
Element: Po Number This field contains the number
representing the purchase order.
MOP-PO-RELEASE Numeric 4
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
MOP-PO-CODE Alpha 4
Element: Po Code This is the purchase order code.
MOP-ITEM Alpha 32 MA54.3 MA540
Element: Item This field contains the item
identifier.
MOP-VEN-ITEM Alpha 32 MA54.3 MA540
Element: Item This field contains the item
identifier.
MOP-ENTERED-QTY Signed 13.4 MA54.3 MA540
Element: Quantity Required. The quantity of goods being
invoiced on the detail line.
MOP-ENT-UOM Alpha 4 MA54.3 MA540
Element: 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 18.5 MA54.3 MA540
Element: Intl Cost Required. The unit cost of the line
item detail.
MOP-EXTENDED-AMT Signed 18.2 MA540
Element: Extended AmounThe total value of all the items
received on a given receiver.
MOP-LOCATION Alpha 5 MA54.3 MA540
Element: Location 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 MA540
Element: Aoc Code This field contains the identifier for
the add on cost associated with this
line item.
MOP-TOTAL-AOC Signed 18.2 MA540
Element: Intl Amt The total add on cost amount. Required
if an AOC code is defined.
MOP-RTL-UNIT-COST Signed 18.5 MA54.3 MA540
Element: Retail Unit CoThe retail unit cost of the line item
detail.
MOP-ELEMENT-VAL Alpha 32 Occurs 10 Times MA54.3 MA540
Element: Element Value
MOP-DIST-COMPANY Numeric 4 MA54.3 MA540
Element: Company 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.
MOP-ACCT-UNIT Alpha 15 MA54.3 MA540
Element: Acct 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
Element: 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
Element: Sub Acct 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
Element: 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
Element: Acct 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.
Valid account category types are:
cost
revenue
accrual
pass thru
MOP-BILL-CATEGORY Alpha 32 MA54.3 MA540
Element: Bill Category
MOP-TAX-CODE Alpha 10 MA54.3 MA540
Element: 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
Element: Account Flag N = No
Y = Yes
MOP-TAX-USAGE-CD Alpha 10 MA54.3 MA540
Element: 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
Element: Icn Code
MOP-SUPLMNTARY-QTY Signed 13.4 MA54.3 MA540
Element: Quantity This field contains the desired
quantity.
MOP-WEIGHT Signed 9.3 MA54.3 MA540
Element: Weight This field contains the unit weight of
the item based on the stocking UOM.
MOP-SEGMENT-BLOCK Alpha 103 MA54.3 MA540
Element: Segment Block 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.
MOP-PREPAY-QTY Signed 13.4
Element: Prepay Qty
MOP-PRPY-UNIT-CST Signed 18.5
Element: Intl Cost
MOP-PRPY-TAX-CODE Alpha 10
Element: Prpy Tax Code
MOP-PRPY-TAX-AMT Signed 18.2
Element: Intl Amt
MOP-PRPY-RTL-UCST Signed 18.5
Element: Intl Cost
MOP-PREPAY-DATE Numeric 8 (yyyymmdd)
Element: Prepay Date
MOP-XREF-VENDOR Alpha 9 (Right Justified)
Element: Xref Vendor 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 Signed 18.5
Element: Intl Cost
MOP-COMMODITY-CODE Alpha 35 MA54.3 MA540
Element: Commodity Code
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
|
