|
|
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 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.
MDA-VENDOR Alpha 9 (Right Justified) MA54.2 MA540
Element: Vendor The vendor's identification code.
MDA-EDI-NBR Alpha 15 MA54.2 MA540
Element: Edi Nbr The electronic data interchange (EDI)
number assigned to the vendor.
MDA-INVOICE Alpha 22 MA54.2 MA540
Element: Invoice Used to identify the invoice.
MDA-SUFFIX Numeric 3 MA54.2 MA540
Element: Suffix This is the suffix for the invoice.
MDA-DIST-SEQ-NBR Numeric 6 MA54.2 MA540
Element: Dist Seq Nbr A unique sequence number.
MDA-TAXABLE-AMT Signed 18.2 MA54.2 MA540
Element: Intl Amt
MDA-ORIG-TRAN-AMT Signed 18.2 MA54.2 MA540
Element: Intl Amt The amount of the invoice distribution
in the currency of the invoice.
MDA-DIST-COMPANY Numeric 4 MA54.2 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.
MDA-DIS-ACCT-UNIT Alpha 15 MA54.2 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.
MDA-DIS-ACCOUNT Numeric 6 MA54.2 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.
MDA-DIS-SUB-ACCT Numeric 4 MA54.2 MA540
Element: Sub Acct 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-INDICATOR Numeric 1 MA54.2 MA540
Element: Tax Indicator
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: 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
MDA-BILL-CATEGORY Alpha 32 MA54.2 MA540
Element: Bill Category
MDA-UNT-AMOUNT Signed 18.2 MA54.2 MA540
Element: Unit Amount
MDA-ASSET-DESC Alpha 30 (Lower Case) MA540
Element: Asset DescriptA description of the asset if an asset
is assigned to the distribution.
MDA-TAG-NBR Alpha 12 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 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 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 MA540
Element: Item Desc This field contains the description for
stock and non-stock items.
MDA-VEN-ITEM Alpha 32
Element: Item This field contains the item
identifier.
MDA-ASSET-TEMPLATE Alpha 10 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) MA540
Element: Inservice DateThe book in-service date for the asset.
Note: The in-service date can be
different for each depreciation book
used.
MDA-PURCHASE-DATE Numeric 8 (yyyymmdd) MA540
Element: Purchase Date The date the asset was purchased. This
purchased date can be different from the
in-service dates for the depreciation
books used.
MDA-MODEL-NUMBER Alpha 30 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 MA540
Element: Serial Number This optional field is used for the
serial number of the asset.
MDA-HOLD-AM Alpha 1 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 MA540
Element: Asset 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 18.2 MA540
Element: Tax Amount The tax amount associated with the
asset distribution in the currency of
the transaction.
MDA-ASSET-GROUP Alpha 10 MA540
Element: Asset Group The asset group assigned to the
distribution.
MDA-COMBINE Alpha 10 MA540
Element: Combine AssetsThis field indicates whether to combine
items as one asset.
MDA-AU-GROUP Alpha 10 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
Accounts Payable 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
Accounts Payable 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
Accounts Payable 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
Accounts Payable 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: 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.
MDA-ICN-CODE Alpha 8 MA54.2 MA540
Element: Icn Code
MDA-WEIGHT Signed 9.3 MA54.2 MA540
Element: Weight This field contains the unit weight of
the item based on the stocking UOM.
MDA-SUPLMNTARY-QTY Signed 13.4 MA54.2 MA540
Element: Quantity This field contains the desired
quantity.
MDA-LINE-TYPE Alpha 1 MA54.2 MA540
Element: Line Type This field contains the type of
inventory on this line.
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
|
