GP Tables

gpPayWork - PM Payment WORK Temp

Dynamics GP table gpPayWork (PM Payment WORK Temp) contains 69 columns including BACHNUMB, BCHSOURC, PMNTNMBR....

SQL Query Builder

69 Columns

Column Description Type Length
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
PMNTNMBR Payment Number String 22
CHEKBKID Checkbook ID String 16
DOCDATE Document Date Date 4
DOCNUMBR Document Number String 22
APPLDAMT Applied Amount Currency 10
CURTRXAM Current Trx Amount Currency 10
CHEKTOTL Check Total Currency 10
VENDORID Vendor ID String 16
VENDNAME Vendor Name String 66
COMMENT1 Comment1 String 32
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
COUNTRY Country String 62
VNDCHKNM Vendor Check Name String 66
SOURCDOC Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo String 12
DISTKNAM Discount Taken Amount Currency 10
DISAMTAV Discount Amount Available Currency 10
WROFAMNT Write Off Amount Currency 10
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
VOIDED Voided Boolean 2
REPRNTED Reprinted Integer 2
GSTDSAMT GST Discount Amount Currency 10
PGRAMSBJ Percent Of Gross Amount Subject Integer 2
PPSTAXRT PPS Tax Rate Integer 2
PPSAMDED PPS Amount Deducted Currency 10
LDOCRMTC List Documents on Remittance Integer 2
SDORMBY Sort Documents on Remittance By Integer 2
KEYFIELD Key Field String 22
AMWDSNBR Amount in Words and Numbers String 62
NOTEINDX Note Index Currency 10
VCHRNMBR Voucher Number String 22
CNTRLTYP Control Type Integer 2
Control Type values (3)
0 = Voucher types1 = Payment types2 = Printed alignment forms
DOCTYPE Document Type Integer 2
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
MODIFDT Modified Date Date 4
MDFUSRID Modified User ID String 16
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
PMWRKMSG PM WORK Messages Long Integer 4
PMDSTMSG PM Distribution Messages Long Integer 4
CHKCOMNT Check Comment String 62
PSTGDATE Posting Date Date 4
STRGA255 String A 255 String 256
STRGB255 String B 255 String 256
SEPRMTNC Seperate Remittance Boolean 2
STBOVRFL Stub Overflow Boolean 2
CTYSTZIP City-State-Zip Code String 48
TotDocAmt Total Document Amount Currency 10
TotAmtPaid Total Amount Paid Currency 10
TotCrdAmt Total Credit Amount Currency 10
TotalPaidTot Total Paid Total Currency 10
TotNegTot Total Negative Total Currency 10
TotCrdDocAmt Total Credit Document Amount Currency 10
TotTotDocAmt Total Total Document Amount Currency 10
TotDiscTknAmt Total Discount Taken Amount Currency 10
TotWOAmt Total Write Off Amount Currency 10
TotPPSAmtDed Total PPS Amount Deducted Currency 10
TotGSTDiscAmt Total GST Discount Amount Currency 10
TotDiscTknTot Total Discount Taken Total Currency 10
TotWOTot Total Write Off Total Currency 10
Outstanding_Amount Outstanding Amount Currency 10
Net_Paid_Amount Net Paid Amount Currency 10
AMTINWDS Amount in Words Text 2

Related Tables

Tables that share columns with gpPayWork. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27

DOCDATE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP21

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

BCHSOURC

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27

DOCTYPE

ASIEXP09 ASIEXP10 ASIEXP18 ASIEXP21 ASIEXP25 ASIEXP26 ASIEXP29 EDCEI016

DOCNUMBR

ASIEXP08 ASIEXP09 ASIEXP14 ASIEXP19 ASIEXP29 CFM20101 CFM20102 CN100201