GP Tables

PM20100 - PM Apply To OPEN OPEN Temporary File

Dynamics GP table PM20100 (PM Apply To OPEN OPEN Temporary File) contains 87 columns including KEYSOURC, DOCDATE, TIME1....

SQL Query Builder

87 Columns

Column Description Type Length
KEYSOURC Key Source String 42
DOCDATE Document Date Date 4
TIME1 Time Time 4
VENDORID Vendor ID String 16
POSTED Posted Boolean 2
BCHSOURC Batch Source String 16
USERID User ID String 16
APTVCHNM Apply To Voucher Number String 22
APTODCTY Apply To Document Type Integer 2
APTODCDT Apply To Document Date Date 4
APTODCNM Apply To Document Number String 22
APPLDAMT Applied Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
DISAVTKN Discount Available Taken 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
CURRNIDX Currency Index Integer 2
ORAPPAMT Originating Applied Amount Currency 10
ORDISTKN Originating Discount Taken Amount Currency 10
ORDATKN Originating Discount Available Taken Currency 10
ORWROFAM Originating Write Off Amount Currency 10
Apply_To_Document_Amount Apply To Document Amount Currency 10
Apply_To_Orig_Doc_Amount Apply To Orig Doc Amount Currency 10
Apply_To_Discount_Date Apply To Discount Date Date 4
Apply_To_Due_Date Apply To Due Date Date 4
Apply_To_Description Apply To Description String 32
Apply_To_IS_MC_Trx Apply To IS MC Trx Integer 2
ApplyToGLPostDate Apply To GL Posting Date Date 4
APTOEXRATE Apply To Exchange Rate Currency (Variable) 10
APTODENRATE Apply To Denomination Exchange Rate Currency (Variable) 10
APTORTCLCMETH Apply To Rate Calc Method Integer 2
APTOMCTRXSTT Apply To MC Transaction State Integer 2
ISMCTRX IS MC Trx Integer 2
VCHRNMBR Voucher Number String 22
DOCTYPE Document Type Integer 2
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
APFRDCNM Apply From Document Number String 22
FROMCURR Apply From Currency ID String 16
Apply_From_Document_Amou Apply From Document Amount Currency 10
Apply_From_Orig_Doc_Amou Apply From Orig Doc Amount Currency 10
APFRMAPLYAMT Apply From Apply Amount Currency 10
APFRMDISCTAKEN Apply From Discount Taken Amount Currency 10
APFRMDISCAVAIL Apply From Discount Available Taken Currency 10
APFRMWROFAMT Apply From Write Off Amount Currency 10
ActualApplyToAmount Actual Apply To Amount Currency 10
ActualDiscTakenAmount Actual Discount Taken Amount Currency 10
ActualDiscAvailTaken Actual Discount Available Taken Currency 10
ActualWriteOffAmount Actual Write Off Amount Currency 10
APFRMEXRATE Apply From Exchange Rate Currency (Variable) 10
APFRMDENRATE Apply From Denomination Exchange Rate Currency (Variable) 10
APFRMRTCLCMETH Apply From Rate Calc Method Integer 2
APFRMMCTRXSTT Apply From MC Transaction State Integer 2
Apply_From_Description Apply From Description String 32
Apply_From_IS_MC_Trx Apply From IS MC Trx Integer 2
PPSAMDED PPS Amount Deducted Currency 10
GSTDSAMT GST Discount Amount Currency 10
TAXDTLID Tax Detail ID String 16
UPDTKNAM Unposted Discount Taken Amount Currency 10
UPGSTDAM Unposted GST Discount Amount Currency 10
UNPPPSAD Unposted PPS Amount Deducted Currency 10
UPWROFAM Unposted Write Off Amount Currency 10
PMDSTMSG PM Distribution Messages Long Integer 4
MODIFDT Modified Date Date 4
MDFUSRID Modified User ID String 16
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
TEN99AMNT 1099 Amount Currency 10
RLGANLOS Realized Gain-Loss Amount Currency 10
APYFRMRNDAMT Apply From Round Amount Currency 10
APYTORNDAMT Apply To Round Amount Currency 10
APYTORNDDISC Apply To Round Discount Currency 10
XCHGRATE Exchange Rate Currency (Variable) 10
DECPLCUR Decimal Places Currency Integer 2
RATECALC Rate Calc Method Integer 2
Payment_To_Print_On_Stub Payment To Print On Stub String 22
OAPYFRMRNDAMT Originating Apply From Round Amount Currency 10
OAPYTORNDAMT Originating Apply To Round Amount Currency 10
OAPYTORNDDISC Originating Apply To Round Discount Currency 10
Settled_Gain_CreditCurrT Settled Gain CreditCurrTrx Currency 10
Settled_Loss_CreditCurrT Settled Loss CreditCurrTrx Currency 10
Settled_Gain_DebitCurrTr Settled Gain DebitCurrTrx Currency 10
Settled_Loss_DebitCurrTr Settled Loss DebitCurrTrx Currency 10
Settled_Gain_DebitDiscAv Settled Gain DebitDiscAvail Currency 10
Settled_Loss_DebitDiscAv Settled Loss DebitDiscAvail Currency 10
VADCDTRO Vendor Address Code - Remit To String 16
Credit1099Amount Credit 1099 Amount Currency 10
DEFTEN99TYPE Default 1099 Type Integer 2
DEFTEN99BOXNUMBER Default 1099 Box Number Integer 2

Related Tables

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

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 ASIEXP100 ASIEXP85 CAM10200

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

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