Notes, Tips and Tricks on Developing in Dynamics GP
| 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 |
About Steve Gray
Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.