|
|
MACINVAOC FILE
UPDATED BY
MA54.1 MA54.3 MA540
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAO-COMPANY Numeric 4 MA54.1 MA54.3
Element: Company Identifies the AP company if the MA540
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
MAO-VENDOR Alpha 9 (Right Justified) MA54.1 MA54.3
Element: Vendor ID The vendor's identification code. MA540
MAO-EDI-NBR Alpha 15 MA54.1 MA54.3
Element: EDI Number MA540
MAO-INVOICE Alpha 22 MA54.1 MA54.3
Element: Invoice NumberUsed to identify the invoice. MA540
MAO-SUFFIX Numeric 3
Element: Invoice SuffixThis is the suffix for the invoice.
MAO-SEQ-NBR Numeric 4 MA54.3 MA540
Element: Sequence NumbeAn automatically assigned sequence
number.
MAO-LINE-NBR Numeric 6
Element: Line Number This field contains the line number.
MAO-PO-NUMBER Alpha 14 (Right Justified)
Element: PO Number This field contains the number
representing the purchase order.
MAO-PO-RELEASE Numeric 4
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
MAO-PO-CODE Alpha 4
Element: Po Code This is the purchase order code.
MAO-AOC-CODE Alpha 2 MA54.1 MA54.3
Element: Add On Cost CoThis field contains the identifier for MA540
the add on cost associated with this
line item.
MAO-ENT-AOC-AMOUNT Signed 18.2 MA54.1 MA54.3
Element: Intl Amt MA540
MAO-DST-ACCT-UNIT Alpha 15 MA54.1 MA540
Element: Accounting UniContains the General Ledger accounting
unit to which the amount is posted.
MAO-DST-ACCOUNT Numeric 6 MA54.1 MA540
Element: Account Contains the General Ledger account to
which the amount is posted.
MAO-DST-SUB-ACCT Numeric 4 MA54.1 MA540
Element: Subaccount Contains the General Ledger subaccount
to which the amount is posted.
MAO-ACTIVITY Alpha 15 MA54.1 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.
MAO-ACCT-CATEGORY Alpha 5 MA54.1 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
MAO-BILL-CATEGORY Alpha 32 MA54.1 MA540
Element: Bill Category
MAO-PURCH-FR-LOC Alpha 4
Purchase From The vendor's purchase from location.
Location Code
MAO-LOCATION Alpha 5
Element: Location Code This field contains a valid stocking
location within the company inventory.
MAO-AOC-RATE Percent 7.3 (Percent)
Element: Add On Cost RaAdd On Cost Percentage Rate. If add on
cost is spread by rate, this value times
the line unit cost is the unit add on
cost for the PO line.
MAO-ENTRY Alpha 1
Element: Entry Amount Entry Method.
MAO-QUANTITY Signed 13.4 MA54.3
Element: Quantity This field contains the desired
quantity.
MAO-UNIT-COST Signed 18.5
Element: Intl Cost This field contains the unit cost.
MAO-TOTAL-AOC Signed 18.2 MA54.3
Element: Intl Amt The total add on cost amount can be an
entered amount if entered at this
level, or a calculated amount if a unit
add on cost or add on cost percent is
entered.
MAO-ELEMENT-VAL Alpha 32 Occurs 10 Times
Element: Element Value
MAO-TAX-CODE Alpha 10
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MAO-TAXABLE-FLAG Alpha 1
Taxable or Defines if Taxable.
Non-Taxable Flag Y = yES
N = No
MAO-TAX-USAGE-CD Alpha 10
Element: Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
MAO-LANDED-FLAG Numeric 1
Element: Landed Flag This field notes it the AOC is to be
landed based on the AOC code. Landed
would denote that the AOC will take on
the attributes of the goods line,
account, qty etc.
0 = No
1 = Landed
MAO-LAND-UNIT-CST Signed 18.5
Element: Intl Cost All add on costs that are landed
in addition to the product unit cost.
MAO-AOC-ON-PO Alpha 1
Element: Aoc On Po Indicates if the add-on cost is to
appear on the Purchase Order document
that is issued to the vendor.
MAO-SUMMARY-FLAG Alpha 1
Element: Summary Flag Defines if add on cost is printed in
summary or at a detail level on the
Lawson Purchase Order document.
MAO-ZERO-COST-FLG Alpha 1
Element: Zero Cost FlagDefines if this tax record is allowed
to have a zero unit cost.
MAO-CANCELLED-FL Alpha 1
Element: All Flag The canceled flag.
MAO-CLOSED-FL Alpha 1
Element: Closed Flag The Closed Flag.
MAO-INV-SPRD-CRET Numeric 1
Element: Inv Sprd Cret Defines if record was created during PO
invoice spread.
MAO-ACCR-TAX-AMT Signed 18.2
Element: Intl Amt The tax amount that is to be accrued.
MAO-EXT-TAX-AMT Signed 18.2
Element: Intl Amt
MAO-BL-INVC-AMT Signed 18.2
Element: Intl Amt
MAO-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.
MAO-MATCH-REF-NBR Alpha 22
Element: Match Ref Nbr
MAO-INV-TAX-AMOUNT Signed 18.2
Element: Intl Amt Tax amount on the invoice
MAO-SEGMENT-BLOCK Alpha 103 MA54.1 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.
MAO-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
MAO-REC-CNV-RATE Signed 14.7
Entered Conversion Currency conversion rate for the
Rate Purchase Order at receiving time.
MAO-TOTAL-AOC-PO Signed 18.2
Element: Intl Amt
MACINVAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAOSET1 COMPANY MA54.1 MA54.3
VENDOR MA540
EDI-NBR
INVOICE
SEQ-NBR
AOC-CODE
|
