Commonly Used Tables:
PM00200 – Vendor Master
PM00201 – Vendor Master Summary
PM00202 - Vendor Period Summary
PM00204 – 1099 Period Detail (only in GP 10.0 and GP 2010)
PM00400 – PM Keys Master
PM10000 - Work/Unposted Transactions
PM10100 – GL Distributions for Work and Open Transactions
PM10200 – Apply To Work/Open
PM10300 – Work/Unposted Payments
PM10400 – Work/Unposted Manual Payments
PM20000 – Open/Posted Transactions
PM30200 – Historical/Paid Transactions
PM30300 – Apply To History
PM30600 – GL Distributions for Historical Transactions
MC020103 – Multicurrency Payables Transactions

DOCTYPE (Document Type):
1 – Invoice
2 – Finance Charge
3 – Misc Charge
4 – Return
5 – Credit Memo
6 – Payment (Check, Cash, or Credit Card)

DISTTYPE (PM Distribution Type):
1 – Cash
2 – Payable
3 – Discount Available
4 – Discount Taken
5 – Finance Charge
6 – Purchase
7 – Trade Disc.
8 – Misc. Charge
9 – Freight
10 – Taxes
11 – Writeoffs
12 – Other
13 – GST Disc
14 – PPS Amount
16 – Round
17 – Realized Gain
18 – Relaized Loss
19 – Due To
20 – Due From

PM AGE BY:
0 – Due Date
1 – Document Date

TEN99TYPE (1099 Type):
1 – Not a 1099 Vendor
2 – Divident
3 – Interest
4 – Miscellaneous
5 – Withholding

PSTGSTUS (Posting Status) in PM10000:
10 - transaction being entered for the first time before it has been saved by the used
20 - saved but unposted transaction
30 -  transaction that is currently realtime posting
40 - posted transaction
50 - transactions that has encountered an error during posting
60 - transaction that has been saved previously and has a status of 20 is now being edited by a user
70 - transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user

PSTGSTUS (Posting Status) in PM10100:
0 – Unposted
1 – Posted
3 – Unposted  [used for Computer Checks, not in the SDK]

CNTRLTYP (Control Type):
0 – Voucher types
1 – Payment types
2 – Printed alignment forms

 DCSTATUS (Document Status):
0 – Reserved
1 – Work
2 – Open
3 – History

VENDSTTS (Vendor Status):
1 – Active
2 – Inactive
3 – Temporary

CREDTLMT (Credit Limit) in PM00200:
[Thanks to Bud Cool, a frequent contributor to the Microsoft GP Newsgroup, for this information!]
0 – No Credit
1 – Unlimited
2 – Amount   
[Note: If CREDTLMT = 2 then CRLMTDLR contains the amount of the credit limit, otherwise CRLMTDLR is zero]


HISTTYPE (History Type):
0 – Calendar
1 – Fiscal

PYENTTYP (Payment Type):
0 – Check
1 – Cash
2 – Credit Card
3 – EFT




Leave a Reply.