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
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP10.1 API3.1 API4.1 IC840
MAED.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 UK47.1
UPDATED BY
AP115 AP125 AP126 AP131 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
IC28.1 MA126 MA180 MA310 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.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 AP25.1 AP25.2
company if the resource type = E. It is AP26.1 AP27.1
blank for type A, P or Q resources. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: Vendor ID The vendor's identification code. AP126 AP131
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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
Element: PO Number Purchase order number. AP126 AP131
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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-PO-RELEASE Numeric 4 AP115 AP125
Element: PO Release NumIdentifies a purchase order release AP126 AP131
(created from a Blanket or Standing AP25.1 AP25.2
order). 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-PO-CODE Alpha 4 AP115 AP125
Element: Purchase OrderPO number code. Can be used for AP126 AP131
reporting purposes. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-LOCATION Alpha 5 AP115 AP125
Element: Location Code A valid stocking location within the AP126 AP131
company inventory. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
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 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
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 AP25.1 AP25.2
location. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
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, AP25.1 AP25.2
vendor, PO or location. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
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, AP25.1 AP25.2
vendor, PO or location. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-POOL-OPTION Numeric 1 AP115 AP125
Element: Pool Option The combination of levels to use for AP126 AP131
matching. The more specific combination, AP25.1 AP25.2
the smaller the number of invoices and AP26.1 AP27.1
receipts in the matching pool. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-AUDIT-FLAG Alpha 1 AP115 AP125
Element: Audit Flag Indicates whether to create an audit AP126 AP131
trail. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-LAST-UPD-DATE Numeric 8 (yyyymmdd) AP115 AP125
Element: Last Update DaLate update date. The format is AP126 AP131
YYYYMMDD. 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
IC28.1 MA126
MA180 MA310
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA65.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
...
MAC-TOTAL-INV-AOC Signed 18.2
Element: Intl Amt
MAC-TOTAL-REC-AOC Signed 18.2
Element: Intl Amt
MAC-TOTAL-INV-QTY Signed 15.4
Element: Total Inv Qty
MAC-TOTAL-REC-QTY Signed 15.4
Element: Total Rec Qty
MAPOOLCNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MACSET1 COMPANY AM115 AM117
VENDOR AM15.1 AM15.2
PO-NUMBER AM15.3 AM15.4
PO-RELEASE AM20.1 AM20.3
PO-CODE AM21.1 AM21.3
LOCATION AM500 AM51.1
AM551 AM97.1
AP10.1 AP115
AP125 AP126
AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API3.1
API4.1 BL120
...
MACSET2 COMPANY KeyChange MA126
LAST-UPD-DATE
VENDOR
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
MACSET3 COMPANY KeyChange MA126
VENDOR
LAST-UPD-DATE
PO-NUMBER
PO-RELEASE
PO-CODE
LOCATION
|