| 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 |