Lawson Insight Technical Documentation |
|
POMATCHOBJ
POMATCHOBJ FILE
REFERENCED BY
AP131 AP30.4 MA60.3 MA63.1 PO00.1
UPDATED BY
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
API1.1 MA41.7 MA61.1 MA66.2 MA70.1 MA75.1
MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PMJ-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP25.1 AP25.2
established company and is entered on AP26.1 AP27.1
all function codes. API1.1 MA41.7
MA61.1 MAI1.1
PMJ-REC-NUMBER Numeric 10 AP125 AP126
Element: Receiver NumbeThe receiver number. Assigned when AP25.1 AP25.2
this receiving information was added. AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-MATCH-OBJ-ID Numeric 12 AP125 AP126
Object AP25.1 AP25.2
Identification AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-MATCH-SEQ-NBR Numeric 4 AP125 AP126
Element: Number of Items AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MA66.2
MAI1.1
PMJ-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID The vendor's identification code. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-INVOICE Alpha 22 AP125 AP126
Element: Invoice NumberUsed to identify the invoice. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-SUFFIX Numeric 3 AP125 AP126
Element: Invoice SuffixThis is the suffix for the invoice. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP25.1 AP25.2
representing the purchase order. AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP25.1 AP25.2
release (created from a Blanket or AP26.1 AP27.1
Standing order). API1.1 MA41.7
MA61.1 MAI1.1
PMJ-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-PO-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP25.1 AP25.2
identifier. AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-MATCH-DTL-KEY Alpha 85 AP125 AP126
Element: Match Dtl Key AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
PMJ-MATCHED-QTY Signed 13.4 AP125 AP126
Element: Quantity AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MA66.2
MAI1.1
PMJ-MATCH-UNIT-CST Signed 13.5 AP125 AP126
Element: Base Cost AP25.1 AP25.2
AP26.1 AP27.1
API1.1 MA41.7
MA61.1 MAI1.1
POMATCHOBJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PMJSET1 COMPANY AP125 AP126
REC-NUMBER AP131 AP25.1
LINE-NBR AP25.2 AP26.1
MATCH-OBJ-ID AP27.1 AP30.4
MATCH-SEQ-NBR API1.1 MA41.7
MA60.3 MA61.1
MA63.1 MA66.2
MA70.1 MA75.1
MAI1.1 PO00.1
PMJSET2 COMPANY MA66.1 MA66.2
MATCH-OBJ-ID MA70.1 MA75.1
MATCH-SEQ-NBR
REC-NUMBER
LINE-NBR
POMATCHOBJ FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Mainvdtl MAINVDTL
PMJ-COMPANY -> MAD-COMPANY
PMJ-VENDOR -> MAD-VENDOR
PMJ-INVOICE -> MAD-INVOICE
PMJ-SUFFIX -> MAD-SUFFIX
MAD-PO-NUMBER
MAD-PO-RELEASE
MAD-PO-CODE
MAD-LINE-NBR
MAD-AOC-CODE
MAD-SEQ-NBR
|