GP Tables

PM30300 - PM Apply To History File

Dynamics GP table PM30300 (PM Apply To History File) contains 63 columns including VENDORID, DOCDATE, DATE1....

SQL Query Builder

63 Columns

Column Description Type Length
VENDORID Vendor ID String 16
DOCDATE Document Date Date 4
DATE1 Date Date 4
GLPOSTDT GL Posting Date Date 4
TIME1 Time Time 4
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
ApplyFromGLPostDate Apply From GL Posting Date Date 4
FROMCURR Apply From Currency ID String 16
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
APTVCHNM Apply To Voucher Number String 22
APTODCTY Apply To Document Type Integer 2
APTODCNM Apply To Document Number String 22
APTODCDT Apply To Document Date Date 4
ApplyToGLPostDate Apply To GL Posting Date Date 4
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
APPLDAMT Applied Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
DISAVTKN Discount Available Taken Currency 10
WROFAMNT Write Off Amount Currency 10
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
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
PPSAMDED PPS Amount Deducted Currency 10
GSTDSAMT GST Discount Amount Currency 10
TAXDTLID Tax Detail ID String 16
POSTED Posted Boolean 2
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
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
Revaluation_Status Revaluation Status Integer 2
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 PM30300. 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

TIME1

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

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

DOCTYPE

ASIEXP09 ASIEXP10 ASIEXP18 ASIEXP21 ASIEXP25 ASIEXP26 ASIEXP29 EDCEI016

GLPOSTDT

AAG20001 AAG20011 ASIEXP06 ASIEXP08 ASIEXP19 ASIEXP20 ASIEXP22 ASIEXP25

WROFAMNT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA00402 PA00501 PA00511 PA01101

VCHRNMBR

ASIEXP09 ASIEXP27 CAM10100 ICJC9001 IEPMTRXI MC020103 PA11800 PA50103