|
|
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 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
Distribution A unique sequence number.
Sequence Number
MDA-TAXABLE-AMT Signed 18.2 MA54.2 MA540
Element: Intl Amt This is the taxable amount.
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 The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
MDA-DIS-ACCT-UNIT Alpha 15 MA54.2 MA540
Element: Accounting UniThe general ledger distribution
accounting unit. Select a valid
accounting unit if you want the
interface program to create general
ledger transactions for transaction with
a record status of '1' and '2' only. A
transaction will be created to this
account and an offset transaction to the
cash account will occur.
MDA-DIS-ACCOUNT Numeric 6 MA54.2 MA540
Element: Account Required if the distribution accounting
unit field is not blank. The general
ledger distribution 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-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: 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.
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 The total units.
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 The vendor's item identifer.
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 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) MA54.2 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 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 18.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
|
