Site Search:
Sign in | Join | Help

Dynamics GP

Notes, Tips and Tricks on Developing in Dynamics GP

CM20200 Fields Definitions

Element name Data type Length Required Default Description
Option i4 2 Y Not applicable Transaction option:
1=Enter transaction;
2=Enter receipt
CMTrxType i4 2 N 3 Transaction type (only used when Option=1):
3=Check;
4=Withdrawal;
5=Increase adjustment; 6=Decrease adjustment
RcpType i4 2 N 1 Receipt type (only used when Option=2):
1=Check;
2=Cash;
3=Credit card
TRXDATE datetime 16 N Transaction date; default is system date
CHEKBKID string 15 Y Not applicable Checkbook ID
CURNCYID string 15 N Currency ID; default is currency assigned to the checkbook
CMTrxNum string 20 Y Not applicable Transaction number
CARDNAME string 15 N Credit card name; required when RcpType=3
paidtorcvdfrom string 30 N Paid to: when Option=1
or
Rcvd from: when Option=2
DSCRIPTN string 30 N Description
TRXAMNT number 21 Y Not applicable Transaction amount
USERID string 15 N User ID; default is eBusiness
GLPOSTDT datetime 16 N GL posting date; default is TRXDATE
DistRef string 30 N Distribution reference; only used for required default distribution
BACHNUMB string 15 N GL batch number
For additional information, see Bank Reconciliationi
XCHGRATE number 21 N 0 Exchange rate
RATETPID string 15 N Rate type ID
EXPNDATE datetime 16 N Expiration date
EXCHDATE datetime 16 N Exchange date
EXGTBDSC string 30 N Exchange ID description
EXTBLSRC string 50 N Exchange rate source
RATEEXPR i4 2 N Default is from setup Rate expiration:
0=None
1=Daily;
2=Weekly;
3=Biweekly;
4=Semimonthly;
5=Monthly;
6=Quarterly;
7=Annually;
8=Miscellaneous;
9=None;
DYSTINCR i4 2 N Default is from setup Days to increment; only used when RATEEXPR=8
RATEVARC number 21 N 0 Rate variance
TRXDTDEF i4 2 N Default is from setup Transaction date default: 0=Exact date;
1=Next date;
2=Previous date
RTCLCMTD i4 2 N Default is from setup Rate calculation method: 0=Multiply;
1=Divide
PRVDSLMT i4 2 N 0 Previous days limit
DATELMTS i4 2 N 0 Date limits:
0=Unlimited;
1=Limited
TIME1 datetime 16 N Time 1; if not passed in, field used for finding XCHGRATE
Published Aug 07 2008, 10:56 AM by steve gray

Comments

 

Dynamics GP said:

AF00100 Financials Subsidiary Master AF_Subsidiary_MSTR AF10000 Prior Period Adjustment Work AF_Prior_Period_ADJ_WORK

August 7, 2008 11:41 AM

Leave a Comment

(required)  
(optional)
(required)  
Add