The Matching Pool Count file contains receipt and invoice counts and
amounts. This file determines if a match should be attempted.
UPDATED BY
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
MAC-COMPANY
Element: Company | Numeric 4
Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
|
|
MAC-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor's identification code.
|
|
MAC-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
Purchase order number.
|
|
MAC-PO-RELEASE
Element: Po Release | Numeric 4
Identifies a purchase order release
(created from a Blanket or Standing
order).
|
|
MAC-PO-CODE
Element: Purchase Order Code | Alpha 4
PO number code. Can be used for
reporting purposes.
|
|
MAC-LOCATION
Element: Location | Alpha 5
A valid stocking location within the
company inventory.
|
|
MAC-NBR-INVOICES
Number of Unmatched
Invoices | Numeric 4
The total number of unmatched invoices
for a company, vendor, PO or location.
|
|
MAC-NBR-RECEIPTS
Number of Unmatched
Receipts | Numeric 4
The total number of unmatched receipts
for a given company, vendor, PO or
location.
|
|
MAC-TOTAL-INVOICES
Total Unmatched
Invoice Amount | Signed 18.2
Total invoice dollar amount of
unmatched invoices for a given company,
vendor, PO or location.
|
|
MAC-TOTAL-RECEIPTS
Total Unmatched
Receipt Amount | Signed 18.2
Total receipt dollar amount of
unmatched invoices for a given company,
vendor, PO or location.
|
|
MAC-POOL-OPTION
Element: Pool Option | Numeric 1
The combination of levels to use for
matching. The more specific combination,
the smaller the number of invoices and
receipts in the matching pool.
|
|
MAC-AUDIT-FLAG
Element: Audit Flag | Alpha 1
Indicates whether to create an audit
trail.
|
|
MAC-LAST-UPD-DATE
Element: Last Update Date | Numeric 8 (yyyymmdd)
Late update date. The format is
YYYYMMDD.
|
|
MAC-TOTAL-INV-AOC
Element: Intl Amt | Signed 18.2
This is the total amount of AOC open to
match from the invoice(s).
|
|
MAC-TOTAL-REC-AOC
Element: Intl Amt | Signed 18.2
This is the total amount of AOC
available to match on the receipts.
|
|
MAC-TOTAL-INV-QTY
Element: Total Inv Qty | Signed 15.4
Total invoice quantity available to
match.
|
|
MAC-TOTAL-REC-QTY
Element: Total Rec Qty | Signed 15.4
Total receipt quantity available to
match.
|
|
