MAAOCDTL – Invoice Add On Cost Detail
- System
- Matching (MA)
- Prefix
MAA- Primary key
COMPANY,VENDOR,INVOICE,SUFFIX,PO-NUMBER,PO-RELEASE,PO-CODE,LINE-NBR,AOC-CODE,SEQ-NBR- Fields
- 70
- Updated by
- 253 programs
- Referenced by
- 8 programs
MAAOCDTL is the Invoice Add On Cost Detail table in Lawson Matching (prefix MAA). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR (MAASET1); alternate indexes: MAASET10, MAASET2, MAASET3, MAASET6, MAASET8 and MAASET9. It is related 1:1 to APBATCH, APINVOICE, MAINVDTL, POAOCMAST, POLINE and POMATCHOBJ and 1:M to APDISTPAY, MMDIST and RECAOCDTL. It is updated by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 and 245 more and referenced by AP295, API5.1, MA279, MA540, MM280, MM80.1, MM80.2 and PO64.1. The table has 70 fields, 7 indexes and 9 documented relations.
About MAAOCDTL
This is the AOC detail record. This file contains the AOC details related to the APINVOICE and MAINVDTL records.
Fields (70)
Column = COBOL field name without the MAA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MAA-COMPANY PKCOMPANY | 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. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-PO-NUMBER PKPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-PO-RELEASE PKPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-PO-CODE PKPO_CODE | Alpha 4 | This is the purchase order code. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-AOC-CODE PKAOC_CODE | Alpha 2 | This field contains the identifier for the add on cost associated with this line item. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-CANCEL-SEQCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-MATCH-DTL-KEYMATCH_DTL_KEY | Alpha 85 | The match detail key is a user defined set of match criteria. THe item number is required and other criteria can be added up to 85 charachters. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-PURCH-FR-LOCPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-LOCATIONLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-AOC-RATEAOC_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. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-API-OBJ-IDAPI_OBJ_ID | Numeric 12 | This object ID links the detail records to the invoice. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-MA-REC-NBRMA_REC_NBR | Numeric 10 | Receipt number associated with the this AOC record. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-MA-LINE-NBRMA_LINE_NBR | Numeric 6 | The receipt line number associated with this AOC line. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-MATCH-SEQ-NBRMATCH_SEQ_NBR | Numeric 4 | This sequence number is assigned to the detail information in order to link to the goods line. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-INVOICE-TYPEINVOICE_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. | AP180, AP181, AP190, AP28.1, AP28.2, AP45.1 |
MAA-INVOICE-VENDORINVOICE_VENDOR | Alpha 9 (Right Justified) | This is the AP vendor that is on the invoice. There are cases when the invoice on the invoice and the vendor on an interfaced PO may be different. | — |
MAA-MATCH-OBJ-IDMATCH_OBJ_ID | Numeric 12 | This object ID links the MAAOCDTL record to the MAINVDTL record. There can be multiple MAAOCDTL records(AOC details) associated to one MAINVDTL record (item detail) | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-ENT-UNIT-CSTENT_UNIT_CST | Signed 18.5 | The entered unit cost in vendor price unit of measure. May be entered manually on the line or calculated from entry of cost in buy unit of measure terms. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-MATCH-UNIT-CSTMATCH_UNIT_CST | Signed 18.5 | This unit cost is updated at match. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-TOTAL-AOCTOTAL_AOC | Signed 18.2 | THis is the AOC in the vendor currency. 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. The total AOC would be the UNIT-COST * the QUANTITY | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-TAXABLE-FLAGTAXABLE_FLAG | Alpha 1 | Defines if Taxable. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-TAX-AMOUNTTAX_AMOUNT | Signed 18.2 | This is the tax amount associated with this AOC record. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-TAX-USAGE-CDTAX_USAGE_CD | Alpha 10 | The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-AOC-ON-POAOC_ON_PO | Alpha 1 | Indicates if the add-on cost is to appear on the Purchase Order document that is issued to the vendor. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-LANDED-FLAGLANDED_FLAG | Numeric 1 | This flag notes that the AOC of record is landed. Landed means as the goods change the AOC will change in the same manner. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-SUMMARY-FLAGSUMMARY_FLAG | Alpha 1 | Defines if add on cost is printed in summary or at a detail level on the Lawson Purchase Order document. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-ZERO-COST-FLGZERO_COST_FLG | Alpha 1 | Defines if this tax record is allowed to have a zero unit cost. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-CANCELLED-FLCANCELLED_FL | Alpha 1 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-CLOSED-FLCLOSED_FL | Alpha 1 | The Closed Flag. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-INV-SPRD-CRETINV_SPRD_CRET | Numeric 1 | Defines if record was created during PO invoice spread. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-ISSUED-FLAGISSUED_FLAG | Alpha 1 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-INVC-TAX-AMTINVC_TAX_AMT | Signed 18.2 | The tax amount that is to be invoiced. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-ACCR-TAX-AMTACCR_TAX_AMT | Signed 18.2 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-EXT-TAX-AMTEXT_TAX_AMT | Signed 18.2 | The extended tax amount on the record. WHich would be the INVC-TAX-AMT and the ACCR-TAX-AMT | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-LAND-UNIT-CSTLAND_UNIT_CST | Signed 18.5 | In this record the landed unit cost would be the landed ta associated to the AOC | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-AOC-ALPHAAOC_ALPHA | Alpha 12 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-AOC-NUMAOC_NUM | Numeric 12 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-AOC-AMTAOC_AMT | Signed 18.2 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-XREF-VENDORXREF_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. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for chargebacks(credit memos). | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-CHARGEBACK-FLCHARGEBACK_FL | Alpha 1 | This flag notes if a chargeback was created for differences related to this record. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-IR-DIFF-AMTIR_DIFF_AMT | Signed 18.2 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-ENTERED-QTYENTERED_QTY | Signed 13.4 | THis is the Quanitity entered on the invoice. If the AOC is landed the Quantity is always equal to the goods quantity on the MAIVDTL record. If the AOC code is non landed the entered qty could be different than the goods. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-MATCHED-QTYMATCHED_QTY | Signed 13.4 | This is the quantity that was matched. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-DUE-DATEDUE_DATE | Numeric 8 (yyyymmdd) | The transaction due date. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-TOT-DIST-AMTTOT_DIST_AMT | Signed 18.2 | Total distribution amount on this record | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-TOT-BASE-AMTTOT_BASE_AMT | Signed 18.2 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-DISTRIB-DATEDISTRIB_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-UPDATE-DATEUPDATE_DATE | Numeric 8 (yyyymmdd) | This field contains the date the record was updated. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-REC-SOURCEREC_SOURCE | Alpha 2 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-TRAN-NDTRAN_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-NO-TAX-FLAGNO_TAX_FLAG | Alpha 1 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-TAX-TYPETAX_TYPE | Alpha 1 | The type of tax. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-ITEMITEM | Alpha 32 | This field contains the item identifier. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-ITEM-TYPEITEM_TYPE | Alpha 1 | This field identifies the line item type. | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP180, AP181 +52 more (list truncated in source) |
MAA-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-ORIG-CNV-RATEORIG_CNV_RATE | Signed 14.7 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-RET-PCTRET_PCT | Percent 5.2 (Percent) | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-PVN-OBJ-IDPVN_OBJ_ID | Numeric 12 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-PROD-TAX-CATPROD_TAX_CAT | Alpha 15 | — | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-TRACK-TYPETRACK_TYPE | Alpha 1 | " " = Other AOC
| AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source) |
MAA-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | — |
Indexes (7)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MAASET1 | COMPANY, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR | Primary | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP195, AP198 +22 more (list truncated in source) | |
MAASET10 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, UPDATE-DATE*, UPDATE-TIME*, VENDOR, INVOICE, SUFFIX, AOC-CODE, SEQ-NBR | KeyChange | MA278 | |
MAASET2 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, VENDOR, INVOICE, SUFFIX, AOC-CODE, SEQ-NBR | KeyChange | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source) | |
MAASET3 | COMPANY, API-OBJ-ID, PO-NUMBER, PO-RELEASE, PO-CODE, MATCH-DTL-KEY, LINE-NBR, SEQ-NBR, AOC-CODE | KeyChange | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source) | |
MAASET6 | COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, VENDOR, AOC-CODE, INVOICE, SUFFIX, SEQ-NBR | KeyChange | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) | |
MAASET8 | COMPANY, API-OBJ-ID, PO-NUMBER, PO-RELEASE, PO-CODE, LOCATION, MATCH-DTL-KEY, LINE-NBR, AOC-CODE, SEQ-NBR | KeyChange | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source) | |
MAASET9 | COMPANY, MATCH-OBJ-ID, MATCH-SEQ-NBR, VENDOR, INVOICE, SUFFIX, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, SEQ-NBR | KeyChange, Subset | Where INVOICE-TYPE = Spaces | AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source) |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apbatch | APBATCH | Not Required | MAA-COMPANY → APB-COMPANY, API-BATCH-NUM → APB-BATCH-NUM | |
| Apinvoice | APINVOICE | Required | MAA-COMPANY → API-COMPANY, MAA-VENDOR → API-VENDOR, MAA-INVOICE → API-INVOICE, MAA-SUFFIX → API-SUFFIX, Zeroes → API-CANCEL-SEQ | |
| Mainvdtl | MAINVDTL | Required | MAA-COMPANY → MAD-COMPANY, MAA-VENDOR → MAD-VENDOR, MAA-INVOICE → MAD-INVOICE, MAA-SUFFIX → MAD-SUFFIX, MAA-PO-NUMBER → MAD-PO-NUMBER, MAA-PO-RELEASE → MAD-PO-RELEASE, MAA-PO-CODE → MAD-PO-CODE, MAA-LINE-NBR → MAD-LINE-NBR, MAA-SEQ-NBR → MAD-SEQ-NBR | |
| Poaocmast | POAOCMAST | Required | When ((MAA-AOC-CODE != Spaces) And (MAA-TAX-CODE = Spaces)) | MAA-COMPANY → PAM-COMPANY, MAA-AOC-CODE → PAM-AOC-CODE |
| Poline | POLINE | Not Required | MAA-COMPANY → PLI-COMPANY, MAA-PO-NUMBER → PLI-PO-NUMBER, MAA-PO-RELEASE → PLI-PO-RELEASE, MAA-PO-CODE → PLI-PO-CODE, MAA-LINE-NBR → PLI-LINE-NBR | |
| Pomatchobj | POMATCHOBJ | Required | MAA-COMPANY → PMJ-COMPANY, MAA-MATCH-OBJ-ID → PMJ-MATCH-OBJ-ID, MAA-MATCH-SEQ-NBR → PMJ-MATCH-SEQ-NBR, MAA-MA-REC-NBR → PMJ-REC-NUMBER, MAA-LINE-NBR → PMJ-LINE-NBR, MAA-AOC-CODE → PMJ-AOC-CODE |
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apdistpay | APDISTPAY | MAA-COMPANY → DTY-COMPANY, MAA-PO-NUMBER → DTY-PO-NUMBER, MAA-PO-RELEASE → DTY-PO-RELEASE, MAA-PO-CODE → DTY-PO-CODE, MAA-LINE-NBR → DTY-LINE-NBR, MAA-SEQ-NBR → DTY-MAD-SEQ-NBR, MAA-VENDOR → DTY-VENDOR, MAA-INVOICE → DTY-INVOICE, MAA-SUFFIX → DTY-SUFFIX, DTY-PMT-SEQ-NBR, DTY-DIST-SEQ-NBR | ||
| Mmdist | MMDIST | Valid When MAA-ITEM-TYPE != "I" | MAA-COMPANY → MMD-COMPANY, "PO" → MMD-SYSTEM-CD, MAA-LOCATION → MMD-LOCATION, "PT" → MMD-DOC-TYPE, MAA-PO-NUMBER → MMD-DOC-NUMBER, MAA-PO-RELEASE → MMD-DOC-NBR-NUM, MAA-PO-CODE → MMD-PO-CODE, MAA-LINE-NBR → MMD-LINE-NBR, Zeroes → MMD-COMPONENT-SEQ, MAA-AOC-CODE → MMD-AOC-CODE, MMD-LINE-SEQ, MMD-REQ-LOCATION, MMD-API-OBJ-ID | |
| Recaocdtl | RECAOCDTL | MAA-COMPANY → REC-COMPANY, MAA-PO-NUMBER → REC-PO-NUMBER, MAA-PO-RELEASE → REC-PO-RELEASE, MAA-PO-CODE → REC-PO-CODE, REC-REC-NUMBER, REC-LINE-NBR, REC-AOC-CODE, REC-VENDOR, REC-LOCATION |
Programs
Updated by (253)
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AP115 Vendor Merge
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP180 Bill of Exchange Cashing Update
- AP181 Bill of Exchange Statement Update
- AP190 Invoice Reinstatement
- AP195 Period Closing
- AP198 Invoice Data Archival
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP220 Invoice Edit Report
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP28.1 Bill of Exchange Acceptance by Vendor
- AP28.2 Bill of Exchange Acceptance by Date
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP45.1 Reportable Income Adjustment
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- MA08.1 Add On Charge/Allowance
- MA126 Auto Matching
- MA180 Open Receipt Archive
- MA26.1 PO Invoice Match
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.1 Memo Line Detail - Purchase Order
- MA42.2 Memo Line AOC Detail
- MA43.1 Invoice Line Detail - Purchase Order
- MA43.2 Purchase Order Lookup
- MA43.3 Invoice Line Detail - Receipt
- MA43.4 Invoice Line Detail - Service
- MA43.6 Service Agreement Detail
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.4 Invoice Match Reference Adjustment
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.4 Invoice Match Reference Adjustment
- MA68.5 Receipt Match Reference Adjustment
- MA69.1 AOC Level Detail Match
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MA90.2 All Transactions for Invoice
- MA90.3 Match Analysis Details
- MA90.5 Misc AOC for an Invoice
- MA90.6 Summarization
- MAI1.1 Invoke for MAMATCH Object
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO135 Received, Not Invoiced Report
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.3 Vendor Agreement Commitments Spread
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program