GP Tables

Purchasing

38 tables in this module

Payables Management (PM) and Purchase Order Processing (POP) tables manage vendor relationships, purchase orders, receipts, and payments. PM tables track the full AP lifecycle from invoice entry through payment and history.

Table Description
PM00100 PM Class Master File
PM00101 Vendor Class Accounts
PM00200 PM Vendor Master File
PM00201 PM Vendor Master Summary
PM00202 PM Vendor Master Period Summary
PM00203 Vendor Accounts
PM00204 Purchasing 1099 Period Detail
PM00300 PM Address MSTR
PM00400 PM Key Master File
PM10000 PM Transaction WORK File
PM10100 PM Distribution WORK OPEN
PM10200 PM Apply To WORK OPEN File
PM10201 PM Payment Apply To Work File
PM10300 PM Payment WORK
PM10400 PM Manual Payment WORK File
PM10600 PM Distribution Void WORK Temporary File
PM10801 PM Payment Stub Duplicate
PM10900 Void Payment WORK Temporary File
PM10901 PM Void Transaction WORK Temporary File
PM20000 PM Transaction OPEN File
PM20100 PM Apply To OPEN OPEN Temporary File
PM20200 PM Distribution OPEN OPEN Temporary File
PM30200 PM Paid Transaction History File
PM30300 PM Apply To History File
PM30600 PM Distribution History File
PM40102 Payables Document Types
PM80100 PM Batch Headers
PM80500 PM Reprint Posting Journal Apply To File
POP10100 Purchase Order Work
POP10110 Purchase Order Line
POP10300 Purchasing Receipt Work
POP10306 Purchasing Receipt User-Defined
POP10550 Purchasing Comment
POP11300 POP PA Receipt View
POP30110 Purchase Order Line History
POP30300 Purchasing Receipt History
POP31300 POP PA Receipt Hist View
POR10310 Purchasing Return Line