Lawson Insight Technical Documentation |
|
MAMAAHIST
MAMAAHIST FILE
This is the history file for the MAAOCDTL records. These are the AOC detail
records related to invoices and invoice line details
REFERENCED BY
MA278
UPDATED BY
AM19.1 AM19.2 AP115 AP125 AP126 AP131
AP180 AP181 AP190 AP198 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP28.1
AP28.2 AP30.2 AP30.4 AP300 AP305 AP45.1
API1.1 API2.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MMH-COMPANY Numeric 4 AP198
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) AM19.1 AM19.2
Element: Vendor The vendor's identification code. AP115 AP125
AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.2
...
MMH-INVOICE Alpha 22 AM19.1 AM19.2
Element: Invoice Used to identify the invoice. AP115 AP125
AP126 AP131
AP198 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.2
MA66.3 MA67.2
...
MMH-SUFFIX Numeric 3 AP198
Element: Suffix This is the suffix for the invoice.
MMH-PO-NUMBER Alpha 14 (Right Justified) AP198
Element: Po Number This field contains the number
representing the purchase order.
MMH-PO-RELEASE Numeric 4 AP198
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
MMH-PO-CODE Alpha 4 AP198
Element: Po Code This is the purchase order code.
MMH-LINE-NBR Numeric 6 AP198
Element: Line Nbr This field contains the line number.
MMH-AOC-CODE Alpha 2 AP198
Element: Aoc Code This field contains the identifier for
the add on cost associated with this
line item.
MMH-CANCEL-SEQ Numeric 4 AP198
Element: Seq Nbr An automatically assigned sequence
number.
MMH-SEQ-NBR Numeric 4 AP198
Element: Seq Nbr An automatically assigned sequence
number.
MMH-MATCH-DTL-KEY Alpha 85 AP198
Element: Match Dtl Key
MMH-PURCH-FR-LOC Alpha 4 AP198
Element: Purch Fr Loc The vendor's purchase from location.
MMH-LOCATION Alpha 5 AP198
Element: Location This field contains a valid stocking
location within the company inventory.
MMH-AOC-RATE Percent 7.3 (Percent) AP198
Element: Aoc Rate 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.
MMH-API-OBJ-ID Numeric 12 AP198
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
MMH-MA-REC-NBR Numeric 10 AP198
Element: Rec Number The receiver number. Assigned when
this receiving information was added.
MMH-MA-LINE-NBR Numeric 6 AP198
Element: Line Nbr This field contains the line number.
MMH-INVOICE-TYPE Alpha 1 AP198
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) AP198
Element: Invoice Vendor
MMH-MATCH-OBJ-ID Numeric 12 AP198
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
MMH-ENT-UNIT-CST Signed 18.5 AP198
Element: Intl Cost
MMH-ORIG-UNIT-CST Signed 18.5
Element: Intl Cost
MMH-MATCH-UNIT-CST Signed 18.5 AP198
Element: Intl Cost
MMH-TOTAL-AOC Signed 18.2 AP198
Element: Intl Amt
MMH-TAX-CODE Alpha 10 AP198
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
MMH-TAXABLE-FLAG Alpha 1 AP198
Element: Taxable Flag Defines if Taxable.
MMH-TAX-AMOUNT Signed 18.2 AP198
Element: Intl Amt
MMH-AOC-ON-PO Alpha 1 AP198
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 AP198
Element: Landed Flag
MMH-SUMMARY-FLAG Alpha 1 AP198
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 AP198
Element: Zero Cost Flg Defines if this tax record is allowed
to have a zero unit cost.
MMH-CANCELLED-FL Alpha 1 AP198
Element: All Flag
MMH-CLOSED-FL Alpha 1 AP198
Element: Closed Fl The Closed Flag.
MMH-INV-SPRD-CRET Numeric 1 AP198
Element: Inv Sprd Cret Defines if record was created during PO
invoice spread.
MMH-ISSUED-FLAG Alpha 1 AP198
Element: All Flag
MMH-INVC-TAX-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-ACCR-TAX-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-EXT-TAX-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-LAND-UNIT-COST Signed 18.5 AP198
Element: Intl Cost
MMH-BL-INVC-AMT Signed 18.2
Element: Intl Amt
MMH-AOC-ALPHA Alpha 12 AP198
Element: Aoc Alpha
MMH-AOC-NUM Numeric 12 AP198
Element: Aoc Num
MMH-AOC-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-XREF-VENDOR Alpha 9 (Right Justified) AP198
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 AP198
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
MMH-CHARGEBACK-FL Alpha 1 AP198
Element: Chargeback Fl
MMH-IR-DIFF-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-ENTERED-QTY Signed 13.4 AP198
Element: Rec Qty This is the total quantity to date
received for this ordered item.
MMH-MATCHED-QTY Signed 13.4 AP198
Element: Rec Qty This is the total quantity to date
received for this ordered item.
MMH-DUE-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
MMH-TOT-DIST-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-TOT-BASE-AMT Signed 18.2 AP198
Element: Intl Amt
MMH-STATUS Numeric 1 AP198
Element: Status This field displays the status of the
transaction.
MMH-MATCH-SEQ-NBR Numeric 4 AP198
Element: Match Seq Nbr
MMH-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
MMH-UPDATE-DATE Numeric 8 (yyyymmdd) AP198
Element: Update Date This field contains the date the record
was updated.
MMH-UPDATE-TIME Numeric 6 AP198
Element: Update Time This field contains the system time
when the record was updated.
MMH-REC-SOURCE Alpha 2 AP198
Element: Rec Source
MMH-TRAN-ND Numeric 1 AP198
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
MMH-TAX-USAGE-CD Alpha 10 AP198
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 AP198
Element: Account Flag
MMH-TAX-TYPE Alpha 1 AP198
Element: Tax Type The type of tax.
MMH-ITEM Alpha 32
Element: Item This field contains the item
identifier.
MMH-ITEM-TYPE Alpha 1 AP198
Element: Item Type This field identifies the line item
type.
MMH-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
MMH-ORIG-CNV-RATE Signed 14.7
Element: Acct Rate
MAMAAHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MMHSET1 COMPANY AM19.1 AM19.2
VENDOR AP115 AP125
INVOICE AP126 AP131
SUFFIX AP180 AP181
PO-NUMBER AP190 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
AOC-CODE AP220 AP23.1
SEQ-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP28.1 AP28.2
AP30.2 AP30.4
AP300 AP305
AP45.1 API1.1
...
MMHSET2 COMPANY KeyChange
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
VENDOR
INVOICE
SUFFIX
AOC-CODE
SEQ-NBR
MMHSET8 COMPANY KeyChange AM19.1 AM19.2
API-OBJ-ID AP115 AP125
PO-NUMBER AP126 AP131
PO-RELEASE AP20.1 AP20.2
PO-CODE AP20.3 AP20.4
LOCATION AP20.5 AP20.7
MATCH-DTL-KEY AP21.1 AP220
LINE-NBR AP23.1 AP25.1
AOC-CODE AP25.2 AP26.1
SEQ-NBR AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
MMHSET9 COMPANY KeyChange AM19.1 AM19.2
MATCH-OBJ-ID AP115 AP125
MATCH-SEQ-NBR AP126 AP131
VENDOR AP20.1 AP20.2
INVOICE AP20.3 AP20.4
SUFFIX AP20.5 AP20.7
PO-NUMBER AP21.1 AP220
PO-RELEASE AP23.1 AP25.1
PO-CODE AP25.2 AP26.1
LINE-NBR AP27.1 AP30.2
AOC-CODE AP30.4 AP305
CANCEL-SEQ API1.1 API2.1
SEQ-NBR BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
|