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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET9
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 SET8
MATCH_DTL_KEY		Alpha 85—AP198
#MMH-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP198
#MMH-LOCATION SET8
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 SET8
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 SET9
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 SET9
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MMHSET1
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. PO-NUMBER
  6. PO-RELEASE
  7. PO-CODE
  8. LINE-NBR
  9. AOC-CODE
  10. SEQ-NBR
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +22 more (list truncated in source)
MMHSET2
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. LINE-NBR
  6. VENDOR
  7. INVOICE
  8. SUFFIX
  9. AOC-CODE
  10. SEQ-NBR
KeyChange—
MMHSET8
  1. COMPANY
  2. API-OBJ-ID
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. LOCATION
  7. MATCH-DTL-KEY
  8. LINE-NBR
  9. AOC-CODE
  10. SEQ-NBR
KeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
MMHSET9
  1. COMPANY
  2. MATCH-OBJ-ID
  3. MATCH-SEQ-NBR
  4. VENDOR
  5. INVOICE
  6. SUFFIX
  7. PO-NUMBER
  8. PO-RELEASE
  9. PO-CODE
  10. LINE-NBR
  11. AOC-CODE
  12. CANCEL-SEQ
  13. SEQ-NBR
KeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)

Programs

Updated by (244)