POMATCHOBJ – Cost Change Information

System
Purchase Order (PO)
Prefix
PMJ
Primary key
COMPANY, REC-NUMBER, LINE-NBR, MATCH-OBJ-ID, MATCH-SEQ-NBR, AOC-CODE
Fields
47
Updated by
228 programs
Referenced by
5 programs

POMATCHOBJ is the Cost Change Information table in Lawson Purchase Order (prefix PMJ). It is indexed by COMPANY, REC-NUMBER, LINE-NBR, MATCH-OBJ-ID, MATCH-SEQ-NBR, AOC-CODE (PMJSET1); alternate indexes: PMJSET2, PMJSET3, PMJSET4 and PMJSET5. It is related 1:M to MAINVDTL. It is updated by AP125, AP126, AP131, AP191, AP20.1, AP20.2, AP20.3, AP20.4 and 220 more and referenced by MA90.2, MA90.3, MA90.5, MA90.6 and PO00.1. The table has 47 fields, 5 indexes and 1 documented relation.

About POMATCHOBJ

No description in the Lawson data dictionary.

Fields (47)

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

Field / columnTypeDescription & valuesUpdated by
PMJ-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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-REC-NUMBER PK
REC_NUMBER
Numeric 10The receiver number. Assigned when this receiving information was added.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MATCH-OBJ-ID PK
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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MATCH-SEQ-NBR PK
MATCH_SEQ_NBR
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-INVOICE
INVOICE
Alpha 22Used to identify the invoice.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-SUFFIX
SUFFIX
Numeric 3This is the suffix for the invoice.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-PO-NUMBER
PO_NUMBER
Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-PO-RELEASE
PO_RELEASE
Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-PO-CODE
PO_CODE
Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-PO-LINE-NBR
PO_LINE_NBR
Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ITEM
ITEM
Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MATCH-DTL-KEY
MATCH_DTL_KEY
Alpha 85AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MATCHED-QTY
MATCHED_QTY
Signed 13.4This is the total quantity to date received for this ordered item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MATCH-UNIT-CST
MATCH_UNIT_CST
Signed 18.5This is the cost on the PORECLINE at the time of Match. PRL-MATCH-UNIT-COST. This is not the cost that the invoice was at for match.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-AOC-CODE PK
AOC_CODE
Alpha 2This field contains the identifier for the add on cost associated with this line item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-TYPE
TYPE
Alpha 2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-TRAN-DATE
TRAN_DATE
Numeric 8 (yyyymmdd)This is the date the record was createdAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-TRAN-TIME
TRAN_TIME
Numeric 6This is the time the record was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-PO-COST-UPD
PO_COST_UPD
Signed 18.5This is the cost that the PO Last Match Unit Cost was updated to on the message file.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-CHARGEBACK-QTY
CHARGEBACK_QTY
Signed 13.4This is the qty of the chargeback qtyAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-WRITE-OFF-QTY
WRITE_OFF_QTY
Signed 13.4This is the qty for the line that has been written off.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ARCHIVE-QTY
ARCHIVE_QTY
Signed 13.4Qty on the line that is archivedAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MEMO-QTY
MEMO_QTY
Signed 13.4This is the qty of the line that a memo was applied against.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-REC-NBR
MNR_REC_NBR
Numeric 10This is the receipt number for the receipt that clears a MNR qty that had been written through a previous matchAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-QTY
MNR_QTY
Signed 13.4Match Not Received quantity for the line for the receipt.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-UCST
MNR_UCST
Signed 18.5The PO Cost at the time the MNR is created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-TAX-UCST
MNR_TAX_UCST
Signed 18.5The cost of the tax on the PO for the MNR.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-AMT
MNR_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-TOL-QTY
MNR_TOL_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-TOL-UCST
MNR_TOL_UCST
Signed 18.5This will be a cost difference-this field will contain any difference in the cost between the PO Cost and the Invoice cost for the MNR qty.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-TOL-TAX-UC
MNR_TOL_TAX_UC
Signed 18.5This is a cost difference-this field will contain any difference in the tax cost between the PO Cost and the Invoice cost on the MNR qty.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-MNR-TOL-AMT
MNR_TOL_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-QTY
ICV_QTY
Signed 13.4The Quantity that will be written to ICV.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-UCST
ICV_UCST
Signed 18.5The cost per unit that is written to ICV. This cost is the difference between the PO and the adjusted cost from the PO Cost Message or change to PO20 after the matched qty is populated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-TAX-UCST
ICV_TAX_UCST
Signed 18.5Thecost of the tax on the PO for the ICV.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-AMT
ICV_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-TOL-QTY
ICV_TOL_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-TOL-UCST
ICV_TOL_UCST
Signed 18.5This is the cost difference between the invoice cost and the PO COst Adjustment from messaging or a change to the PO after the match qty is populated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-TOL-TAX-UC
ICV_TOL_TAX_UC
Signed 18.5THis will be a cost difference-the field will contain any difference in the tax cost between the invoice and the adjusted po cost.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-ICV-TOL-AMT
ICV_TOL_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-STATUS
STATUS
Numeric 1
  • 0 Unreleased
  • 1 Released
  • 2 Processed
  • 9 Cancelled
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-OPERATOR
OPERATOR
Alpha 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-API-OBJ-ID
API_OBJ_ID
Numeric 12AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PMJ-REC-DATE
REC_DATE
Numeric 8 (yyyymmdd)
PMJ-REC-CNV-RATE
REC_CNV_RATE
Signed 14.7

Indexes (5)

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

IndexKeysFlagsConditionUsed in
PMJSET1COMPANY, REC-NUMBER, LINE-NBR, MATCH-OBJ-ID, MATCH-SEQ-NBR, AOC-CODEPrimaryAP125, AP126, AP131, AP191, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
PMJSET2COMPANY, MATCH-OBJ-ID, MATCH-SEQ-NBR, REC-NUMBER, LINE-NBR, AOC-CODEKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PMJSET3COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, TRAN-DATE*, TRAN-TIME*, MATCH-OBJ-ID, MATCH-SEQ-NBR, TYPEKeyChange, SubsetWhere REC-NUMBER = ZeroesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PMJSET4COMPANY, MATCH-OBJ-ID, MATCH-SEQ-NBR, API-OBJ-ID, REC-NUMBER, LINE-NBR, AOC-CODEKeyChange, SubsetWhere TYPE = "MA"MA70.1, MA75.1
PMJSET5COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, REC-NUMBER, MATCH-OBJ-ID, MATCH-SEQ-NBR, TYPE, STATUS, AOC-CODEKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
MainvdtlMAINVDTLPMJ-COMPANYMAD-COMPANY, PMJ-VENDORMAD-VENDOR, PMJ-INVOICEMAD-INVOICE, PMJ-SUFFIXMAD-SUFFIX, MAD-PO-NUMBER, MAD-PO-RELEASE, MAD-PO-CODE, MAD-LINE-NBR, MAD-SEQ-NBR

Programs

Updated by (228)

Referenced by (5)