 |
Lawson Insight Technical Documentation |
|
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
AP10.1 API3.1 API4.1 IC840 MAED.1
UPDATED BY
AP115 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
API1.1 IC28.1 MA126 MA180 MA310 MA41.1
MA41.2 MA43.1 MA43.2 MA43.3 MA43.4 MA43.5
MA43.7 MA43.8 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 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
Company The company number represents an AP126 AP131
established company and is entered on AP20.1 AP20.2
all function codes. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-VENDOR Alpha 9 (Right Justified) AP115 AP125
Vendor ID The vendor's identification code. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-PO-NUMBER Alpha 14 (Right Justified) AP115 AP125
PO Number Purchase order number. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-PO-RELEASE Numeric 4 AP115 AP125
PO Release Number 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-PO-CODE Alpha 4 AP115 AP125
Purchase Order Code PO number code. Can be used for AP126 AP131
reporting purposes. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-LOCATION Alpha 5 AP115 AP125
Location Code A valid stocking location within the AP126 AP131
company inventory. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-TOTAL-INVOICES Signed 15.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-TOTAL-RECEIPTS Signed 15.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-POOL-OPTION Numeric 1 AP115 AP125
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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-AUDIT-FLAG Alpha 1 AP115 AP125
Audit Flag Indicates whether to create an audit AP126 AP131
trail. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAC-LAST-UPD-DATE Numeric 8 (yyyymmdd) AP115 AP125
Last Update Date Late update date. The format is AP126 AP131
YYYYMMDD. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 IC28.1
MA126 MA180
MA310 MA41.1
MA41.2 MA43.1
MA43.2 MA43.3
MA43.4 MA43.5
MA43.7 MA43.8
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA63.1
MA65.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
...
MAPOOLCNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MACSET1 COMPANY AP10.1 AP115
VENDOR AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LOCATION AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API3.1 API4.1
IC28.1 IC840
MA01.1 MA126
MA180 MA310
MA41.1 MA41.2
...
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
|