|
|
MACAPDTL FILE
Invoice Distrib Conversion
The Invoice Distribution Conversion/Interface file contains invoice
distribution information that has been loaded from an external source.
UPDATED BY
MA54.1 MA54.2 MA540
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MDA-COMPANY Numeric 4 MA54.2 MA540
Element: Company The company number represents an
established company and is entered on
all function codes.
MDA-VENDOR Alpha 9 (Right Justified) MA54.2 MA540
Element: Vendor ID The vendor's identification code.
MDA-EDI-NBR Alpha 15 MA54.2 MA540
Element: EDI Number The electronic data interchange (EDI)
number assigned to the vendor.
MDA-INVOICE Alpha 22 MA54.2 MA540
Element: Invoice NumberUsed to identify the invoice.
MDA-SUFFIX Numeric 3 MA54.2 MA540
Element: Invoice SuffixThis is the suffix for the invoice.
MDA-DIST-SEQ-NBR Numeric 4 MA54.2 MA540
Element: Number of Items
MDA-TAXABLE-AMT Signed 15.2 MA54.2 MA540
Element: Adj Amt
MDA-ORIG-TRAN-AMT Signed 15.2 MA54.2 MA540
Element: Adj Amt The amount of the invoice distribution
in the currency of the invoice.
MDA-DIST-COMPANY Numeric 4 MA54.2 MA540
Element: Company
MDA-DIS-ACCT-UNIT Alpha 15 MA54.2 MA540
Element: Accounting Unit
MDA-DIS-ACCOUNT Numeric 6 MA54.2 MA540
Element: Account
MDA-DIS-SUB-ACCT Numeric 4 MA54.2 MA540
Element: Subaccount The general ledger distribution
subaccount. If you are using
subaccounts, this field is required
except for an unreleased distribution
with a tax code.
MDA-TAX-CODE Alpha 10 MA54.2 MA540
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MDA-DESCRIPTION Alpha 30 (Lower Case) MA54.2 MA540
Element: Description The description of the distribution. If
left blank, the vendor number and name
default.
MDA-DST-REFERENCE Alpha 10 MA54.2 MA540
Element: Cross Ref The distribution reference. If left
blank, the default reference value
defined in AP Company defaults.
MDA-ACTIVITY Alpha 15 MA54.2 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.
MDA-ACCT-CATEGORY Alpha 5 MA54.2 MA540
Element: Account CategoAccount 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.
MDA-UNT-AMOUNT Signed 15.2 MA54.2 MA540
Element: Unit Amount
MDA-ASSET-DESC Alpha 30 (Lower Case) MA54.2 MA540
Element: Asset DescriptA description of the asset if an asset
is assigned to the distribution.
MDA-TAG-NBR Alpha 12 MA54.2 MA540
Element: Tag Number If the distribution contains asset
information, this field contains the tag
number assigned to the asset. Represents
a short name for a part of an asset.
MDA-ITEM-NBR Alpha 32 MA54.2 MA540
Element: Item Number If the distribution contains asset
information, this field contains the
item number of an asset that is composed
of different elements, but depreciated
as a common asset unit.
MDA-ITEM-QUANTITY Numeric 8 MA54.2 MA540
Element: Item Quantity If the distribution contains asset
information, the number of units that
make up the asset item. Each unit of an
item is exactly the same as every other
unit of the item.
MDA-ITEM-DESC Alpha 30 MA54.2 MA540
Element: Item DescriptiThis field contains the description for
stock and non-stock items.
MDA-VEN-ITEM Alpha 32
Element: Item Number
MDA-ASSET-TEMPLATE Alpha 10 MA54.2 MA540
Element: Asset TemplateA user-defined asset template
identifies general asset creation
parameters that you can use to quickly
add assets with minimal keying. Using a
template lets you default many data
items associated with a new asset.
You can use an asset template to
process quick asset additions in AM20.1
(Quick Addition) and to create assets
and asset books from Accounts Payable
and Activity Management interface
information. Asset templates are
required if you define new assets as a
result of transactions interfaced from
the Lawson Purchase Order or Accounts
Payable systems.
MDA-INSRV-DATE Numeric 8 (yyyymmdd) MA54.2 MA540
Element: Inservice Date
MDA-PURCHASE-DATE Numeric 8 (yyyymmdd) MA54.2 MA540
Element: Purchase Date
MDA-MODEL-NUMBER Alpha 30 MA54.2 MA540
Element: Model Number The model number assigned to the
distribution. Used in conjunction with
the Asset Template field. If assigned,
an asset template must also be assigned
to the distribution.
MDA-SERIAL-NUMBER Alpha 30 MA54.2 MA540
Element: Serial Number This optional field is used for the
serial number of the asset.
MDA-HOLD-AM Alpha 1 MA54.2 MA540
Element: Hold Asset This field indicates whether to hold
the asset in the Asset Interface file.
Being held keeps items from becoming
assets until they are released from
hold. Valid values are:
N = No. Default.
Y = Yes.
MDA-ASSET Numeric 10 MA54.2 MA540
Element: Asset Number The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
MDA-ITEM-TAX-TRAN Signed 15.2 MA54.2 MA540
Element: Tax Amount The tax amount associated with the
asset distribution in the currency of
the transaction.
MDA-ASSET-GROUP Alpha 10 MA54.2 MA540
Element: Asset Group The asset group assigned to the
distribution.
MDA-COMBINE Alpha 10 MA54.2 MA540
Element: Combine AssetsThis field indicates whether to combine
items as one asset.
MDA-AU-GROUP Alpha 10 MA54.2 MA540
Element: Au Group Accounting unit groups group and
identify the accounting units to use
when you create journal entries for
adding, adjusting, transferring, or
disposing of assets. Changes to
accounting unit groups are dynamic,
affecting all assets using the
accounting unit group. Accounting unit
group names are user-definable, and
accounting unit groups are set up by
company.
MDA-TAX-USAGE-CD Alpha 10 MA54.2 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.
MDA-DST-USR-FLD-01 Alpha 20 MA54.2 MA540
Distribution User Distribution user-defined field number
Field 1 one.
This field can only be used for an AP
invoice, or invoices where the Match
Flag = No.
MDA-DST-USR-FLD-02 Alpha 20 MA54.2 MA540
Distribution User Distribution user-defined field number
Field 2 two.
This field can only be used for AP type
invoices, or invoices where the Match
Flag = No.
MDA-DST-USR-FLD-03 Alpha 20 MA54.2 MA540
Distribution User Distribution user-defined field number
Field 3 three.
This field can only be used for AP type
invoices, or invoices where the Match
Flag = No.
MDA-DST-USR-FLD-04 Alpha 20 MA54.2 MA540
Distribution User Distribution user-defined field number
Field 4 four.
This field can only be used for AP type
invoices, or invoices where the Match
Flag = No.
MDA-DST-USR-FLD-05 Alpha 20 MA54.2 MA540
Distribution User Distribution user-defined field number
Field 5 five.
This field can only be used for AP type
invoices, or invoices where the Match
Flag = No.
MDA-PO-AOC-CODE Alpha 2 MA54.2 MA540
Purchase Order Add Add on code assigned to a purchase
On Cost order. Add on costs can be extra costs
such as freight costs or other
miscellaneous costs, or can be
allowances such as credits and returns.
MDA-SEGMENT-BLOCK Alpha 103 MA54.2 MA540
Element: 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.
MACAPDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MDASET1 COMPANY MA54.1 MA54.2
VENDOR MA540
EDI-NBR
INVOICE
SUFFIX
DIST-SEQ-NBR
|
