MACINVAOC

UPDATED BY
MA54.1 MA54.7 MA540

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAO-COMPANY
Element: Company
Numeric 4
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.
MA54.1 MA54.7
MA540
MAO-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
MA54.1 MA54.7
MA540
MAO-EDI-NBR
Element: Edi Nbr
Alpha 15
MA54.1 MA54.7
MA540
MAO-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
MA54.1 MA54.7
MA540
MAO-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
MA540
MAO-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
MA54.7 MA540
MAO-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
MA54.7 MA540
MAO-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
MA540
MAO-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
MA540
MAO-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
MA540
MAO-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add on cost associated with this line item.
MA54.1 MA54.7
MA540
MAO-ENT-AOC-AMOUNT
Element: Intl Amt
Signed 18.2
MA54.1 MA54.7
MA540
MAO-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
MA54.1 MA54.7
MA540
MAO-DST-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
MA54.1 MA54.7
MA540
MAO-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
MA54.1 MA54.7
MA540
MAO-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
MA54.1 MA54.7
MA540
MAO-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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
MA54.1 MA54.7
MA540
MAO-BILL-CATEGORY
Element: Bill Category
Alpha 32
MA54.1 MA54.7
MA540
MAO-PURCH-FR-LOC
Element: Purch Fr Loc
Alpha 4
The vendor's purchase from location.
MA540
MAO-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
MA540
MAO-AOC-RATE
Element: Aoc Rate
Percent 7.3 (Percent)
Add 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.
MA540
MAO-ENTRY
Element: Entry
Alpha 1
Amount Entry Method.
MA540
MAO-QUANTITY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
MA54.7 MA540
MAO-UNIT-COST
Element: Intl Cost
Signed 18.5
MA540
MAO-TOTAL-AOC
Element: Intl Amt
Signed 18.2
MA540
MAO-ELEMENT-VAL
Element: Element Value
Alpha 32 Occurs 10 Times
MA540
MAO-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
MA540
MAO-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
Defines if Taxable.
Y = yES
N = No
MA540
MAO-TAX-USAGE-CD
Element: Tax Usage Cd
Alpha 10
The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.
MA540
MAO-LANDED-FLAG
Element: Landed Flag
Numeric 1
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
MA540
MAO-LAND-UNIT-CST
Element: Intl Cost
Signed 18.5
MA540
MAO-AOC-ON-PO
Element: Aoc On Po
Alpha 1
Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor.
MA540
MAO-SUMMARY-FLAG
Element: Summary Flag
Alpha 1
Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document.
MA540
MAO-ZERO-COST-FLG
Element: Zero Cost Flg
Alpha 1
Defines if this tax record is allowed to have a zero unit cost.
MA540
MAO-CANCELLED-FL
Element: All Flag
Alpha 1
MAO-CLOSED-FL
Element: Closed Fl
Alpha 1
The Closed Flag.
MAO-INV-SPRD-CRET
Element: Inv Sprd Cret
Numeric 1
Defines if record was created during PO invoice spread.
MA540
MAO-ACCR-TAX-AMT
Element: Intl Amt
Signed 18.2
MA540
MAO-EXT-TAX-AMT
Element: Intl Amt
Signed 18.2
MA540
MAO-BL-INVC-AMT
Element: Intl Amt
Signed 18.2
MA540
MAO-XREF-VENDOR
Element: Xref Vendor
Alpha 9 (Right Justified)
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
Element: Match Ref Nbr
Alpha 22
MA540
MAO-INV-TAX-AMOUNT
Element: Intl Amt
Signed 18.2
Tax amount on the invoice
MA540
MAO-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
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.
MA54.1 MA54.7
MA540
MAO-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
MAO-REC-CNV-RATE
Element: Ent Cnv Rate
Signed 14.7
Currency conversion rate at Purchase Order entry time.
MAO-TRACK-TYPE
Element: Aoc Type
Alpha 1

" " = Other AOC
I = Insurance
F = Freight
C = Customs Charges


MACINVAOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAOSET1 COMPANY
VENDOR
EDI-NBR
INVOICE
SEQ-NBR
AOC-CODE
MA54.1 MA54.7
MA540


File created: Thu Jun 09 02:22:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.