|
|
MAMAAHIST FILE
This is the history file for the MAAOCDTL records. These are the AOC detail
records related to invoices and invoice line details
UPDATED BY
AP115 AP125 AP126 AP131 AP180 AP181
AP190 AP220 AP25.1 AP25.2 AP26.1 AP27.1
AP28.1 AP28.2 AP30.2 AP30.4 AP300 AP305
AP45.1 MA61.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMH-COMPANY Numeric 4
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.
MMH-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The vendor's identification code. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
MA61.1 MAI1.1
MMH-INVOICE Alpha 22 AP115 AP125
Element: Invoice NumberUsed to identify the invoice. AP126 AP131
AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
MA61.1 MAI1.1
MMH-SUFFIX Numeric 3
Element: Invoice SuffixThis is the suffix for the invoice.
MMH-PO-NUMBER Alpha 14 (Right Justified)
Element: PO Number This field contains the number
representing the purchase order.
MMH-PO-RELEASE Numeric 4
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
MMH-PO-CODE Alpha 4
Element: Po Code This is the purchase order code.
MMH-LINE-NBR Numeric 6
Element: Line Number This field contains the line number.
MMH-AOC-CODE Alpha 2
Element: Add On Cost CoThis field contains the identifier for
the add on cost associated with this
line item.
MMH-CANCEL-SEQ Numeric 4
Element: Sequence NumbeThe sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
MMH-SEQ-NBR Numeric 4
Element: Sequence NumbeAn automatically assigned sequence
number.
MMH-MATCH-DTL-KEY Alpha 85
Element: Match Dtl Key
MMH-PURCH-FR-LOC Alpha 4
Purchase From The vendor's purchase from location.
Location Code
MMH-LOCATION Alpha 5
Element: Location Code This field contains a valid stocking
location within the company inventory.
MMH-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.
MMH-API-OBJ-ID Numeric 12
Object
Identification
MMH-MA-REC-NBR Numeric 10
Element: Receiver Number
MMH-MA-LINE-NBR Numeric 6
Element: Line Number
MMH-INVOICE-TYPE Alpha 1
Element: Invoice Type 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.
MMH-INVOICE-VENDOR Alpha 9 (Right Justified)
Element: Invoice Vendor
MMH-MATCH-OBJ-ID Numeric 12
Object
Identification
MMH-ENT-UNIT-CST Signed 18.5
Element: Intl Cost The entered unit cost.
MMH-ORIG-UNIT-CST Signed 18.5
Element: Intl Cost
MMH-MATCH-UNIT-CST Signed 18.5
Element: Intl Cost
MMH-TOTAL-AOC Signed 18.2
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.
MMH-TAX-CODE Alpha 10
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MMH-TAXABLE-FLAG Alpha 1
Taxable or Defines if Taxable.
Non-Taxable Flag
MMH-TAX-AMOUNT Signed 18.2
Element: Intl Amt
MMH-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.
MMH-LANDED-FLAG Numeric 1
Element: Landed Flag
MMH-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.
MMH-ZERO-COST-FLG Alpha 1
Element: Zero Cost FlagDefines if this tax record is allowed
to have a zero unit cost.
MMH-CANCELLED-FL Alpha 1
Element: All Flag The canceled flag.
MMH-CLOSED-FL Alpha 1
Element: Closed Flag The Closed Flag.
MMH-INV-SPRD-CRET Numeric 1
Element: Inv Sprd Cret Defines if record was created during PO
invoice spread.
MMH-ISSUED-FLAG Alpha 1
Element: All Flag This is the issue status of the purchase
order source record. If the PO has been
issued at least once since the PO source
record was created, this flag will be
set to a value of "Y". Once set to "Y",
it never changes.
MMH-INVC-TAX-AMT Signed 18.2
Element: Intl Amt The tax amount that is to be invoiced.
MMH-ACCR-TAX-AMT Signed 18.2
Element: Intl Amt The tax amount that is to be accrued.
MMH-EXT-TAX-AMT Signed 18.2
Element: Intl Amt
MMH-LAND-UNIT-COST Signed 18.5
Element: Intl Cost
MMH-BL-INVC-AMT Signed 18.2
Element: Intl Amt
MMH-AOC-ALPHA Alpha 12
Element: Aoc Alpha
MMH-AOC-NUM Numeric 12
Element: Aoc Num
MMH-AOC-AMT Signed 18.2
Element: Intl Amt
MMH-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.
MMH-REASON-CODE Alpha 4
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MMH-CHARGEBACK-FL Alpha 1
Element: Chargeback Fl
MMH-IR-DIFF-AMT Signed 18.2
Element: Intl Amt THis is the field that will hold the
difference between the invoice and the
receipt in order to calculate the
chargeback
MMH-ENTERED-QTY Signed 13.4
Element: Receiving Quantity
MMH-MATCHED-QTY Signed 13.4
Element: Receiving Quantity
MMH-DUE-DATE Numeric 8 (yyyymmdd)
Element: Date The transaction due date.
MMH-TOT-DIST-AMT Signed 18.2
Element: Intl Amt
MMH-TOT-BASE-AMT Signed 18.2
Element: Intl Amt This defines the total distributed
approval amount in the company base
currency.
MMH-STATUS Numeric 1
Element: Status This field displays the status of the
transaction.
MMH-MATCH-SEQ-NBR Numeric 4
Element: Match Seq Nbr
MMH-DISTRIB-DATE Numeric 8 (yyyymmdd)
Element: Date The date used for posting the
transactions to the general ledger.
MMH-UPDATE-DATE Numeric 8 (yyyymmdd)
Element: Update Date This field contains the date the record
was updated.
MMH-UPDATE-TIME Numeric 6
Element: Update Time This field contains the system time
when the record was updated.
MMH-REC-SOURCE Alpha 2
Element: Rec Source
MMH-TRAN-ND Numeric 1
Account Currency The number of decimal positions defined
Code for the transaction currency.
MMH-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.
MMH-NO-TAX-FLAG Alpha 1
Element: Account Flag
MMH-TAX-TYPE Alpha 1
Element: Tax Type The type of tax.
MMH-ITEM Alpha 32
Element: Item Number This field contains the item
identifier.
MMH-ITEM-TYPE Alpha 1
Element: Item Type This field identifies the line item
type.
MAMAAHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMHSET1 COMPANY AP115 AP125
VENDOR AP126 AP131
INVOICE AP180 AP181
SUFFIX AP190 AP220
PO-NUMBER AP25.1 AP25.2
PO-RELEASE AP26.1 AP27.1
PO-CODE AP28.1 AP28.2
LINE-NBR AP30.2 AP30.4
AOC-CODE AP300 AP305
SEQ-NBR AP45.1 MA61.1
MAI1.1
MMHSET10 COMPANY KeyChange, Subset
PO-NUMBER Where STATUS = Zeroes
PO-RELEASE
PO-CODE
LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
MMHSET2 COMPANY KeyChange
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
MMHSET8 COMPANY KeyChange AP115 AP125
API-OBJ-ID AP126 AP131
PO-NUMBER AP220 AP25.1
PO-RELEASE AP25.2 AP26.1
PO-CODE AP27.1 AP30.2
LOCATION AP30.4 AP305
MATCH-DTL-KEY MA61.1 MAI1.1
LINE-NBR
AOC-CODE
SEQ-NBR
MMHSET9 COMPANY KeyChange AP115 AP125
MATCH-OBJ-ID AP126 AP131
MATCH-SEQ-NBR AP220 AP25.1
VENDOR AP25.2 AP26.1
INVOICE AP27.1 AP30.2
SUFFIX AP30.4 AP305
PO-NUMBER MA61.1 MAI1.1
PO-RELEASE
PO-CODE
LINE-NBR
AOC-CODE
CANCEL-SEQ
SEQ-NBR
|
