MAMAAHIST – No description in the Lawson data dictionary

System
Matching (MA)
Prefix
MMH
Primary key
COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR
Fields
68
Updated by
244 programs
Referenced by
0 programs

MAMAAHIST is a Lawson Matching table (prefix MMH); no description in the lawson data dictionary. It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR (MMHSET1); alternate indexes: MMHSET2, MMHSET8 and MMHSET9. It is updated by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 and 236 more. The table has 68 fields, 4 indexes and 0 documented relations.

About MAMAAHIST

No description in the Lawson data dictionary.

Fields (68)

Column = COBOL field name without the MMH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MMH-COMPANY PK
COMPANY		Numeric 4Identifies 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.AP198
MMH-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198, AP20.1 +52 more (list truncated in source)
MMH-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP198, AP20.1 +52 more (list truncated in source)
MMH-SUFFIX PK
SUFFIX		Numeric 3This is the suffix for the invoice.AP198
MMH-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP198
MMH-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP198
MMH-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AP198
MMH-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AP198
MMH-AOC-CODE PK
AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.AP198
MMH-CANCEL-SEQ
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP198
MMH-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AP198
MMH-MATCH-DTL-KEY
MATCH_DTL_KEY		Alpha 85—AP198
MMH-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP198
MMH-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP198
MMH-AOC-RATE
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.AP198
MMH-API-OBJ-ID
API_OBJ_ID		Numeric 12This 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.AP198
MMH-MA-REC-NBR
MA_REC_NBR		Numeric 10The receiver number. Assigned when this receiving information was added.AP198
MMH-MA-LINE-NBR
MA_LINE_NBR		Numeric 6This field contains the line number.AP198
MMH-INVOICE-TYPE
INVOICE_TYPE		Alpha 1THis 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.AP198
MMH-INVOICE-VENDOR
INVOICE_VENDOR		Alpha 9 (Right Justified)—AP198
MMH-MATCH-OBJ-ID
MATCH_OBJ_ID		Numeric 12This 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.AP198
MMH-ENT-UNIT-CST
ENT_UNIT_CST		Signed 18.5—AP198
MMH-ORIG-UNIT-CST
ORIG_UNIT_CST		Signed 18.5——
MMH-MATCH-UNIT-CST
MATCH_UNIT_CST		Signed 18.5—AP198
MMH-TOTAL-AOC
TOTAL_AOC		Signed 18.2—AP198
MMH-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP198
MMH-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1Defines if Taxable.AP198
MMH-TAX-AMOUNT
TAX_AMOUNT		Signed 18.2—AP198
MMH-AOC-ON-PO
AOC_ON_PO		Alpha 1Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor.AP198
MMH-LANDED-FLAG
LANDED_FLAG		Numeric 1—AP198
MMH-SUMMARY-FLAG
SUMMARY_FLAG		Alpha 1Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document.AP198
MMH-ZERO-COST-FLG
ZERO_COST_FLG		Alpha 1Defines if this tax record is allowed to have a zero unit cost.AP198
MMH-CANCELLED-FL
CANCELLED_FL		Alpha 1—AP198
MMH-CLOSED-FL
CLOSED_FL		Alpha 1The Closed Flag.AP198
MMH-INV-SPRD-CRET
INV_SPRD_CRET		Numeric 1Defines if record was created during PO invoice spread.AP198
MMH-ISSUED-FLAG
ISSUED_FLAG		Alpha 1—AP198
MMH-INVC-TAX-AMT
INVC_TAX_AMT		Signed 18.2—AP198
MMH-ACCR-TAX-AMT
ACCR_TAX_AMT		Signed 18.2—AP198
MMH-EXT-TAX-AMT
EXT_TAX_AMT		Signed 18.2—AP198
MMH-LAND-UNIT-COST
LAND_UNIT_COST		Signed 18.5—AP198
MMH-BL-INVC-AMT
BL_INVC_AMT		Signed 18.2——
MMH-AOC-ALPHA
AOC_ALPHA		Alpha 12—AP198
MMH-AOC-NUM
AOC_NUM		Numeric 12—AP198
MMH-AOC-AMT
AOC_AMT		Signed 18.2—AP198
MMH-XREF-VENDOR
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.AP198
MMH-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.AP198
MMH-CHARGEBACK-FL
CHARGEBACK_FL		Alpha 1—AP198
MMH-IR-DIFF-AMT
IR_DIFF_AMT		Signed 18.2—AP198
MMH-ENTERED-QTY
ENTERED_QTY		Signed 13.4This is the total quantity to date received for this ordered item.AP198
MMH-MATCHED-QTY
MATCHED_QTY		Signed 13.4This is the total quantity to date received for this ordered item.AP198
MMH-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
MMH-TOT-DIST-AMT
TOT_DIST_AMT		Signed 18.2—AP198
MMH-TOT-BASE-AMT
TOT_BASE_AMT		Signed 18.2—AP198
MMH-STATUS
STATUS		Numeric 1This field displays the status of the transaction.AP198
MMH-MATCH-SEQ-NBR
MATCH_SEQ_NBR		Numeric 4—AP198
MMH-DISTRIB-DATE
DISTRIB_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
MMH-UPDATE-DATE
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.AP198
MMH-UPDATE-TIME
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.AP198
MMH-REC-SOURCE
REC_SOURCE		Alpha 2—AP198
MMH-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AP198
MMH-TAX-USAGE-CD
TAX_USAGE_CD		Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP198
MMH-NO-TAX-FLAG
NO_TAX_FLAG		Alpha 1—AP198
MMH-TAX-TYPE
TAX_TYPE		Alpha 1The type of tax.AP198
MMH-ITEM
ITEM		Alpha 32This field contains the item identifier.—
MMH-ITEM-TYPE
ITEM_TYPE		Alpha 1This field identifies the line item type.AP198
MMH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
MMH-ORIG-CNV-RATE
ORIG_CNV_RATE		Signed 14.7——
MMH-PROD-TAX-CAT
PROD_TAX_CAT		Alpha 15——

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MMHSET1COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBRPrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +22 more (list truncated in source)
MMHSET2COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, VENDOR, INVOICE, SUFFIX, AOC-CODE, SEQ-NBRKeyChange—
MMHSET8COMPANY, API-OBJ-ID, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, MATCH-DTL-KEY, LINE-NBR, AOC-CODE, SEQ-NBRKeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
MMHSET9COMPANY, MATCH-OBJ-ID, MATCH-SEQ-NBR, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, CANCEL-SEQ, SEQ-NBRKeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)

Programs

Updated by (244)