Lawson Insight Technical Documentation |
|
MAPOOLCNT
MAPOOLCNT FILE
Matching Pool Count
The Matching Pool Count file contains receipt and invoice counts and
amounts. This file determines if a match should be attempted.
REFERENCED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM500 AM51.1 AM551 AM97.1 AP03.3
AP10.1 AP110 AP210 AP220 AP510 AP90.1
AP91.1 API2.1 API3.1 API4.1 MX123 MX500
MA279 MA63.1 PD235 PO10.1 PO120 PO220
PO223 PO233 PO253 PO254 PO278 PO54.1
PO54.2 PO54.3 PO54.4 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 UK47.1
UPDATED BY
AP115 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP305 API1.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA168 MA180 MA310 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 WH20.2 WH20.7 MA01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAC-COMPANY Numeric 4 AP115 AP125
Element: Company Identifies the AP company if the AP126 AP131
resource type = V. Identifies the HR AP20.1 AP20.2
company if the resource type = E. It is AP20.3 AP20.4
blank for type A, P or Q resources. AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor The vendor's identification code. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: Po Number Purchase order number. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-PO-RELEASE Numeric 4 AP115 AP125
Element: Po Release Identifies a purchase order release AP126 AP131
(created from a Blanket or Standing AP20.1 AP20.2
order). AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-PO-CODE Alpha 4 AP115 AP125
Element: Purchase OrderPO number code. Can be used for AP126 AP131
reporting purposes. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-LOCATION Alpha 5 AP115 AP125
Element: Location A valid stocking location within the AP126 AP131
company inventory. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-NBR-INVOICES Numeric 4 AP115 AP125
Number of Unmatched The total number of unmatched invoices AP126 AP131
Invoices for a company, vendor, PO or location. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-NBR-RECEIPTS Numeric 4 AP115 AP125
Number of Unmatched The total number of unmatched receipts AP126 AP131
Receipts for a given company, vendor, PO or AP20.1 AP20.2
location. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-TOTAL-INVOICES Signed 18.2 AP115 AP125
Total Unmatched Total invoice dollar amount of AP126 AP131
Invoice Amount unmatched invoices for a given company, AP20.1 AP20.2
vendor, PO or location. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-TOTAL-RECEIPTS Signed 18.2 AP115 AP125
Total Unmatched Total receipt dollar amount of AP126 AP131
Receipt Amount unmatched invoices for a given company, AP20.1 AP20.2
vendor, PO or location. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-POOL-OPTION Numeric 1 AP115 AP125
Element: Pool Option The combination of levels to use for AP126 AP131
matching. The more specific combination, AP20.1 AP20.2
the smaller the number of invoices and AP20.3 AP20.4
receipts in the matching pool. AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-AUDIT-FLAG Alpha 1 AP115 AP125
Element: Audit Flag Indicates whether to create an audit AP126 AP131
trail. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-LAST-UPD-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Last Update DaLate update date. The format is AP126 AP131
YYYYMMDD. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-TOTAL-INV-AOC Signed 18.2 AP115 AP125
Element: Intl Amt This is the total amount of AOC open to AP126 AP131
match from the invoice(s). AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-TOTAL-REC-AOC Signed 18.2 AP115 AP125
Element: Intl Amt This is the total amount of AOC AP126 AP131
available to match on the receipts. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-TOTAL-INV-QTY Signed 15.4 AP115 AP125
Element: Total Inv Qty Total invoice quantity available to AP126 AP131
match. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAC-TOTAL-REC-QTY Signed 15.4 AP115 AP125
Element: Total Rec Qty Total receipt quantity available to AP126 AP131
match. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA168 MA180
MA310 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA65.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
...
MAPOOLCNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MACSET1 COMPANY AC160 AM115
VENDOR AM117 AM15.1
PO-NUMBER AM15.2 AM15.3
PO-RELEASE AM15.4 AM19.1
PO-CODE AM19.2 AM20.1
LOCATION AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP03.3
AP10.1 AP110
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
MACSET2 COMPANY KeyChange
LAST-UPD-DATE
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MACSET3 COMPANY KeyChange
VENDOR
LAST-UPD-DATE
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
|