This is the AOC detail record. This file contains the AOC details related to
the APINVOICE and MAINVDTL records.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
MAA-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.
|
|
MAA-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor's identification code.
|
|
MAA-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice.
|
|
MAA-SUFFIX
Element: Suffix | Numeric 3
This is the suffix for the invoice.
|
|
MAA-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
MAA-PO-RELEASE
Element: Po Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
MAA-PO-CODE
Element: Po Code | Alpha 4
This is the purchase order code.
|
|
MAA-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the line number.
|
|
MAA-AOC-CODE
Element: Aoc Code | Alpha 2
This field contains the identifier for
the add on cost associated with this
line item.
|
|
MAA-CANCEL-SEQ
Element: Seq Nbr | Numeric 4
An automatically assigned sequence
number.
|
|
MAA-SEQ-NBR
Element: Seq Nbr | Numeric 4
An automatically assigned sequence
number.
|
|
MAA-MATCH-DTL-KEY
Element: Match Dtl Key | Alpha 85
The match detail key is a user defined
set of match criteria. THe item number
is required and other criteria can be
added up to 85 charachters.
|
|
MAA-PURCH-FR-LOC
Element: Purch Fr Loc | Alpha 4
The vendor's purchase from location.
|
|
MAA-LOCATION
Element: Location | Alpha 5
This field contains a valid stocking
location within the company inventory.
|
|
MAA-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.
|
|
MAA-API-OBJ-ID
Element: Obj Id | Numeric 12
This object ID links the detail records
to the invoice.
|
|
MAA-MA-REC-NBR
Element: Rec Number | Numeric 10
Receipt number associated with the this
AOC record.
|
|
MAA-MA-LINE-NBR
Element: Line Nbr | Numeric 6
The receipt line number associated with
this AOC line.
|
|
MAA-MATCH-SEQ-NBR
Element: Match Seq Nbr | Numeric 4
This sequence number is assigned to the
detail information in order to link to
the goods line.
|
|
MAA-INVOICE-TYPE
Element: Invoice Type | Alpha 1
THis field will be filled in from the
Invoice based on PO number. This is a
carrier for the field. The PORECEIVE
file will have to be updated with this
field.
|
|
MAA-INVOICE-VENDOR
Element: Invoice Vendor | Alpha 9 (Right Justified)
This is the AP vendor that is on the
invoice. There are cases when the
invoice on the invoice and the vendor on
an interfaced PO may be different.
|
|
MAA-MATCH-OBJ-ID
Element: Obj Id | Numeric 12
This object ID links the MAAOCDTL record
to the MAINVDTL record. There can be
multiple MAAOCDTL records(AOC details)
associated to one MAINVDTL record (item
detail)
|
|
MAA-ENT-UNIT-CST
Element: Intl Cost | Signed 18.5
The entered unit cost in vendor price
unit of measure. May be entered
manually on the line or calculated from
entry of cost in buy unit of measure
terms.
|
|
MAA-MATCH-UNIT-CST
Element: Intl Cost | Signed 18.5
This unit cost is updated at match.
|
|
MAA-TOTAL-AOC
Element: Intl Amt | Signed 18.2
THis is the AOC in the vendor currency.
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.
The total AOC would be the UNIT-COST *
the QUANTITY
|
|
MAA-TAX-CODE
Element: Tax Code | Alpha 10
This field contains a code representing
specific tax information. This must be
valid Tax Code.
|
|
MAA-TAXABLE-FLAG
Element: Taxable Flag | Alpha 1
Defines if Taxable.
|
|
MAA-TAX-AMOUNT
Element: Intl Amt | Signed 18.2
This is the tax amount associated with
this AOC record.
|
|
MAA-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.
|
|
MAA-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.
|
|
MAA-LANDED-FLAG
Element: Landed Flag | Numeric 1
This flag notes that the AOC of record
is landed. Landed means as the goods
change the AOC will change in the same
manner.
|
|
MAA-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.
|
|
MAA-ZERO-COST-FLG
Element: Zero Cost Flg | Alpha 1
Defines if this tax record is allowed
to have a zero unit cost.
|
|
MAA-CANCELLED-FL
Element: All Flag | Alpha 1
|
|
MAA-CLOSED-FL
Element: Closed Fl | Alpha 1
The Closed Flag.
|
|
MAA-INV-SPRD-CRET
Element: Inv Sprd Cret | Numeric 1
Defines if record was created during PO
invoice spread.
|
|
MAA-ISSUED-FLAG
Element: All Flag | Alpha 1
|
|
MAA-INVC-TAX-AMT
Element: Intl Amt | Signed 18.2
The tax amount that is to be invoiced.
|
|
MAA-ACCR-TAX-AMT
Element: Intl Amt | Signed 18.2
|
|
MAA-EXT-TAX-AMT
Element: Intl Amt | Signed 18.2
The extended tax amount on the record.
WHich would be the INVC-TAX-AMT and the
ACCR-TAX-AMT
|
|
MAA-LAND-UNIT-CST
Element: Intl Cost | Signed 18.5
In this record the landed unit cost
would be the landed ta associated to the
AOC
|
|
MAA-AOC-ALPHA
Element: Aoc Alpha | Alpha 12
|
|
MAA-AOC-NUM
Element: Aoc Num | Numeric 12
|
|
MAA-AOC-AMT
Element: Intl Amt | Signed 18.2
|
|
MAA-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.
|
|
MAA-REASON-CODE
Element: Reason Code | Alpha 4
This field contains the reason code,
which indicates the cause for
chargebacks(credit memos).
|
|
MAA-CHARGEBACK-FL
Element: Chargeback Fl | Alpha 1
This flag notes if a chargeback was
created for differences related to this
record.
|
|
MAA-IR-DIFF-AMT
Element: Intl Amt | Signed 18.2
|
|
MAA-ENTERED-QTY
Element: Rec Qty | Signed 13.4
THis is the Quanitity entered on the
invoice. If the AOC is landed the
Quantity is always equal to the goods
quantity on the MAIVDTL record. If the
AOC code is non landed the entered qty
could be different than the goods.
|
|
MAA-MATCHED-QTY
Element: Quantity | Signed 13.4
This is the quantity that was matched.
|
|
MAA-DUE-DATE
Element: Due Date | Numeric 8 (yyyymmdd)
The transaction due date.
|
|
MAA-TOT-DIST-AMT
Element: Intl Amt | Signed 18.2
Total distribution amount on this record
|
|
MAA-TOT-BASE-AMT
Element: Intl Amt | Signed 18.2
|
|
MAA-STATUS
Element: Status | Numeric 1
This field displays the status of the
transaction.
|
|
MAA-DISTRIB-DATE
Element: Date | Numeric 8 (yyyymmdd)
This field displays the system date
when this was created.
|
|
MAA-UPDATE-DATE
Element: Update Date | Numeric 8 (yyyymmdd)
This field contains the date the record
was updated.
|
|
MAA-UPDATE-TIME
Element: Update Time | Numeric 6
This field contains the system time
when the record was updated.
|
|
MAA-REC-SOURCE
Element: Rec Source | Alpha 2
|
|
MAA-TRAN-ND
Element: Acct Nd | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
MAA-NO-TAX-FLAG
Element: Account Flag | Alpha 1
|
|
MAA-TAX-TYPE
Element: Tax Type | Alpha 1
The type of tax.
|
|
MAA-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
MAA-ITEM-TYPE
Element: Item Type | Alpha 1
This field identifies the line item
type.
|
|
MAA-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
MAA-ORIG-CNV-RATE
Element: Acct Rate | Signed 14.7
|
|
MAA-RET-PCT
Element: Pct | Percent 5.2 (Percent)
|
|
MAA-PVN-OBJ-ID
Element: Obj Id | Numeric 12
|
|
MAA-PROD-TAX-CAT
Element: Prod Tax Cat | Alpha 15
|
|
MAA-TRACK-TYPE
Element: Aoc Type | Alpha 1
" " = Other AOC
I = Insurance
F = Freight
C = Customs Charges |
|
MAA-GLBL-LINE-TYPE
Element: Glbl Line Type | Alpha 15
|
|
