GP Tables

RM20201 - RM Apply Open File

Dynamics GP table RM20201 (RM Apply Open File) contains 59 columns including CUSTNMBR, CPRCSTNM, TRXSORCE....

SQL Query Builder

59 Columns

Column Description Type Length
CUSTNMBR Customer Number String 16
CPRCSTNM Corporate Customer Number String 16
TRXSORCE TRX Source String 14
DATE1 Date Date 4
TIME1 Time Time 4
GLPOSTDT GL Posting Date Date 4
POSTED Posted Boolean 2
TAXDTLID Tax Detail ID String 16
APTODCNM Apply To Document Number String 22
APTODCTY Apply To Document Type Integer 2
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
APPTOAMT Apply To Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
DISAVTKN Discount Available Taken Currency 10
WROFAMNT Write Off Amount Currency 10
ORAPTOAM Originating Apply To 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
APFRDCNM Apply From Document Number String 22
APFRDCTY Apply From Document Type Integer 2
APFRDCDT Apply From Document Date Date 4
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
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
GSTDSAMT GST Discount Amount Currency 10
PPSAMDED PPS Amount Deducted Currency 10
RLGANLOS Realized Gain-Loss Amount 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

Related Tables

Tables that share columns with RM20201. 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

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

GLPOSTDT

AAG20001 AAG20011 ASIEXP06 ASIEXP08 ASIEXP19 ASIEXP20 ASIEXP22 ASIEXP25

WROFAMNT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA00402 PA00501 PA00511 PA01101

ORDISTKN

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 MC020102 MC020103 PA10500 PA10701

GSTDSAMT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA50105 PM10000 PM10200 PM10201