 |
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 MAED.1
UPDATED BY
AP115 AP30.2 AP30.4 AP305 API1.1 MA126
MA310 MA63.1 MA65.1 POIJ.1 MA01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAC-COMPANY Numeric 4 AP115 AP30.2
Company The company number represents an AP30.4 AP305
established company and is entered on API1.1 MA126
all function codes. MA310 MA63.1
MA65.1 POIJ.1
MAC-VENDOR Alpha 9 (Right Justified) AP115 AP30.2
Vendor ID The vendor's identification code. AP30.4 AP305
API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAC-PO-NUMBER Alpha 14 (Right Justified) AP115 AP30.2
PO Number Purchase order number. AP30.4 AP305
API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAC-PO-RELEASE Numeric 4 AP115 AP30.2
PO Release Number Identifies a purchase order release AP30.4 AP305
(created from a Blanket or Standing API1.1 MA126
order). MA310 MA63.1
MA65.1 POIJ.1
MAC-PO-CODE Alpha 4 AP115 AP30.2
Purchase Order Code PO number code. Can be used for AP30.4 AP305
reporting purposes. API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAC-LOCATION Alpha 5 AP115 AP30.2
Location Code A valid stocking location within the AP30.4 AP305
company inventory. API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAC-NBR-INVOICES Numeric 4 AP115 AP30.2
Number of Unmatched The total number of unmatched invoices AP30.4 AP305
Invoices for a company, vendor, PO or location API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAC-NBR-RECEIPTS Numeric 4 AP115 AP30.2
Number of Unmatched The total number of unmatched receipts AP30.4 AP305
Receipts for a given company, vendor, PO or API1.1 MA126
location. MA310 MA63.1
MA65.1 POIJ.1
MAC-TOTAL-INVOICES Signed 15.2 AP115 AP30.2
Total Unmatched Total invoice dollar amount of AP30.4 AP305
Invoice Amount unmatched invoices for a given company, API1.1 MA126
vendor, PO or location. MA310 MA63.1
MA65.1 POIJ.1
MAC-TOTAL-RECEIPTS Signed 15.2 AP115 AP30.2
Total Unmatched Total receipt dollar amount of AP30.4 AP305
Receipt Amount unmatched invoices for a given company, API1.1 MA126
vendor, PO or location. MA310 MA63.1
MA65.1 POIJ.1
MAC-POOL-OPTION Numeric 1 AP115 AP30.2
Pool Option The combination of levels to use for AP30.4 AP305
matching. The more specific combination, API1.1 MA126
the smaller the number of invoices and MA310 MA63.1
receipts in the matching pool. MA65.1 POIJ.1
MAC-AUDIT-FLAG Alpha 1 AP115 AP30.2
Audit Flag Indicates whether to create an audit AP30.4 AP305
trail. API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAC-LAST-UPD-DATE Numeric 8 (yyyymmdd) AP115 AP30.2
Last Update Date Late update date. The format is AP30.4 AP305
YYYYMMDD. API1.1 MA126
MA310 MA63.1
MA65.1 POIJ.1
MAPOOLCNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MACSET1 COMPANY AP10.1 AP115
VENDOR AP30.2 AP30.4
PO-NUMBER AP305 API1.1
PO-RELEASE API3.1 API4.1
PO-CODE MA01.1 MA126
LOCATION MA310 MA63.1
MA65.1 MAED.1
POIJ.1
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
|