This is the history file for the MAAOCDTL records. These are the AOC detail
records related to invoices and invoice line details
UPDATED BY
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| MMH-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. |
|
||
| MMH-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|||
| MMH-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|||
| MMH-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
| MMH-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||
| MMH-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||
| MMH-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
| MMH-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
| MMH-AOC-CODE Element: Aoc Code | Alpha 2 This field contains the identifier for the add on cost associated with this line item. |
|
||
| MMH-CANCEL-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
| MMH-SEQ-NBR Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
| MMH-MATCH-DTL-KEY Element: Match Dtl Key | Alpha 85 |
|
||
| MMH-PURCH-FR-LOC Element: Purch Fr Loc | Alpha 4 The vendor's purchase from location. |
|
||
| MMH-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||
| MMH-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. |
|
||
| MMH-API-OBJ-ID Element: Obj Id | Numeric 12 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 Element: Rec Number | Numeric 10 The receiver number. Assigned when this receiving information was added. |
|
||
| MMH-MA-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
| MMH-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. |
|
||
| MMH-INVOICE-VENDOR Element: Invoice Vendor | Alpha 9 (Right Justified) |
|
||
| MMH-MATCH-OBJ-ID Element: Obj Id | Numeric 12 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 Element: Intl Cost | Signed 18.5 |
|
||
| MMH-ORIG-UNIT-CST Element: Intl Cost | Signed 18.5 |
|
||
| MMH-MATCH-UNIT-CST Element: Intl Cost | Signed 18.5 |
|
||
| MMH-TOTAL-AOC Element: Intl Amt | Signed 18.2 |
|
||
| MMH-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
| MMH-TAXABLE-FLAG Element: Taxable Flag | Alpha 1 Defines if Taxable. |
|
||
| MMH-TAX-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-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. |
|
||
| MMH-LANDED-FLAG Element: Landed Flag | Numeric 1 |
|
||
| MMH-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. |
|
||
| MMH-ZERO-COST-FLG Element: Zero Cost Flg | Alpha 1 Defines if this tax record is allowed to have a zero unit cost. |
|
||
| MMH-CANCELLED-FL Element: All Flag | Alpha 1 |
|
||
| MMH-CLOSED-FL Element: Closed Fl | Alpha 1 The Closed Flag. |
|
||
| MMH-INV-SPRD-CRET Element: Inv Sprd Cret | Numeric 1 Defines if record was created during PO invoice spread. |
|
||
| MMH-ISSUED-FLAG Element: All Flag | Alpha 1 |
|
||
| MMH-INVC-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-ACCR-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-EXT-TAX-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-LAND-UNIT-COST Element: Intl Cost | Signed 18.5 |
|
||
| MMH-BL-INVC-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-AOC-ALPHA Element: Aoc Alpha | Alpha 12 |
|
||
| MMH-AOC-NUM Element: Aoc Num | Numeric 12 |
|
||
| MMH-AOC-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-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. |
|
||
| MMH-REASON-CODE Element: Reason Code | Alpha 4 This field contains the reason code, which indicates the cause for credit memos. |
|
||
| MMH-CHARGEBACK-FL Element: Chargeback Fl | Alpha 1 |
|
||
| MMH-IR-DIFF-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-ENTERED-QTY Element: Rec Qty | Signed 13.4 This is the total quantity to date received for this ordered item. |
|
||
| MMH-MATCHED-QTY Element: Rec Qty | Signed 13.4 This is the total quantity to date received for this ordered item. |
|
||
| MMH-DUE-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
| MMH-TOT-DIST-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-TOT-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||
| MMH-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. |
|
||
| MMH-MATCH-SEQ-NBR Element: Match Seq Nbr | Numeric 4 |
|
||
| MMH-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
| MMH-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record was updated. |
|
||
| MMH-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time when the record was updated. |
|
||
| MMH-REC-SOURCE Element: Rec Source | Alpha 2 |
|
||
| MMH-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
| MMH-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. |
|
||
| MMH-NO-TAX-FLAG Element: Account Flag | Alpha 1 |
|
||
| MMH-TAX-TYPE Element: Tax Type | Alpha 1 The type of tax. |
|
||
| MMH-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
| MMH-ITEM-TYPE Element: Item Type | Alpha 1 This field identifies the line item type. |
|
||
| MMH-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||
| MMH-ORIG-CNV-RATE Element: Acct Rate | Signed 14.7 |
|
||
| MMH-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| MMHSET1 |
COMPANY VENDOR INVOICE SUFFIX PO-NUMBER PO-RELEASE PO-CODE LINE-NBR AOC-CODE SEQ-NBR |
|
||||||||
| MMHSET2 |
COMPANY PO-NUMBER PO-RELEASE PO-CODE LINE-NBR VENDOR INVOICE SUFFIX AOC-CODE SEQ-NBR |
|
||||||||
| MMHSET8 |
COMPANY API-OBJ-ID PO-NUMBER PO-RELEASE PO-CODE LOCATION MATCH-DTL-KEY LINE-NBR AOC-CODE SEQ-NBR |
|
||||||||
| MMHSET9 |
COMPANY MATCH-OBJ-ID MATCH-SEQ-NBR VENDOR INVOICE SUFFIX PO-NUMBER PO-RELEASE PO-CODE LINE-NBR AOC-CODE CANCEL-SEQ SEQ-NBR |
|
||||||||
All trademarks and registered trademarks are the property of their
respective owners.