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 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
PR514 UK47.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 MA41.7 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.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1 WH20.2
WH20.7 MA01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAC-COMPANY Numeric 4 AP115 AP125
Element: 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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
MAC-VENDOR Alpha 9 (Right Justified) AP115 AP125
Element: 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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
MAC-PO-RELEASE Numeric 4 AP115 AP125
Element: PO Release NumIdentifies 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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
MAC-LOCATION Alpha 5 AP115 AP125
Element: 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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
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 MA41.7
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.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
...
MAPOOLCNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MACSET1 COMPANY AM115 AM15.1
VENDOR AM15.2 AM15.3
PO-NUMBER AM15.4 AM20.1
PO-RELEASE AM20.3 AM21.1
PO-CODE AM21.3 AM500
LOCATION AM51.1 AM551
AM97.1 AP10.1
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
...
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
|