<taRMTransaction>
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
RMDTYPAL |
i4 |
2 |
Y |
Not applicable |
1=Sales/invoice; 3=Debit memo; 4=Finance charge; 5=Service/repair; 6=Warranty; 7=Credit memo; 8=Return |
DOCNUMBR |
string |
17 |
Y |
Not applicable |
Document number |
DOCDATE |
datetime |
8 bytes (19 to 23 chars) |
Y |
Not applicable |
Document date |
BACHNUMB |
string |
15 |
Y |
Not applicable |
Batch number |
CUSTNMBR |
string |
15 |
Y |
Not applicable |
Customer number |
DOCAMNT |
number |
21 |
Y |
Not applicable |
Document amount |
SLSAMNT |
number |
21 |
Y |
Not applicable |
Sales amount |
DOCDESCR |
string |
30 |
N |
<blank> |
Document description |
ADRSCODE |
string |
15 |
N |
<blank> |
Address code |
SLPRSNID |
string |
15 |
N |
Default from setup |
Salesperson ID |
SALSTERR |
string |
15 |
N |
Default from setup |
Sales territory |
SHIPMTHD |
string |
15 |
N |
<blank> |
Shipping method |
TAXSCHID |
string |
15 |
N |
Default from setup |
Tax schedule ID |
CSTPONBR |
string |
20 |
N |
<blank> |
Customer PO number |
COSTAMNT |
number |
21 |
N |
0 |
Cost amount |
TRDISAMT |
number |
21 |
N |
0 |
Trade discount amount |
TRDDISCT |
i4 |
2 |
N |
0 |
Trade discount |
FRTAMNT |
number |
21 |
N |
0 |
Freight amount |
MISCAMNT |
number |
21 |
N |
0 |
Miscellaneous amount |
TAXAMNT |
number |
21 |
N |
0 |
Tax amount |
BKTSLSAM |
number |
21 |
N |
0 |
Back out sales amount |
BKTFRTAM |
number |
21 |
N |
0 |
Back out freight amount |
BKTMSCAM |
number |
21 |
N |
0 |
Back out miscellaneous amount |
CASHAMNT |
number |
21 |
N |
0 |
Cash amount |
CBKIDCSH |
string |
15 |
N |
<blank> |
Checkbook ID cash |
CASHDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Cash date |
DCNUMCSH |
string |
20 |
N |
<blank> |
Document number cash |
CHEKAMNT |
number |
21 |
N |
0 |
Check amount |
CBKIDCHK |
string |
15 |
N |
<blank> |
Checkbook ID check |
CBKIDCRD |
string |
15 |
N |
<blank> |
Checkbook ID credit card |
CHEKNMBR |
string |
20 |
N |
<blank> |
Check number |
CHEKDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Check date |
DCNUMCHK |
string |
20 |
N |
<blank> |
Document number of the check |
CRCRDAMT |
number |
21 |
N |
0 |
Credit card amount |
CRCRDNAM |
string |
15 |
N |
<blank> |
Credit card name |
RCTNCCRD |
string |
20 |
N |
<blank> |
Receipt number for the credit card |
CRCARDDT |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Credit card date |
DCNUMCRD |
string |
20 |
N |
<blank> |
Document number for the credit card |
DISCRTND |
number |
21 |
N |
0 |
Discount returned |
DISTKNAM |
number |
21 |
N |
0 |
Discount taken amount |
WROFAMNT |
number |
21 |
N |
0 |
Write-off amount for credit documents |
PPSAMDED |
number |
21 |
N |
0 |
PPS amount deducted for credits |
GSTDSAMT |
number |
21 |
N |
0 |
GST discount amount |
PYMTRMID |
string |
20 |
N |
Default from setup |
Payment term ID |
DISAVAMT |
number |
21 |
N |
Default from setup |
Discount available amount |
DSCDLRAM |
number |
21 |
N |
Default from setup |
Discount dollar amount |
DSCPCTAM |
number |
21 |
N |
Default from setup |
Discount percent amount |
LSTUSRED |
string |
15 |
N |
<blank> |
Last user to edit |
PTDUSRID |
string |
15 |
N |
<blank> |
Posted user ID |
DistRef |
string |
30 |
N |
<blank> |
Distribution reference |
BatchCHEKBKID |
string |
15 |
N |
<blank> |
Checkbook ID for the batch |
DUEDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Due date |
DISCDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Discount date |
CURNCYID |
string |
15 |
N |
<blank> |
Currency ID |
XCHGRATE |
number |
21 |
N |
0 |
Exchange rate |
RATETPID |
string |
15 |
N |
<blank> |
Rate type ID |
EXPNDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Expiration date |
EXCHDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Exchange date |
EXGTBDSC |
string |
30 |
N |
<blank> |
Exchange ID description |
EXTBLSRC |
string |
50 |
N |
<blank> |
Exchange rate source |
RATEEXPR |
i4 |
2 |
N |
Default 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 from setup |
Days to increment--used only when RATEEXPR=8 |
RATEVARC |
number |
21 |
N |
0 |
Rate variance |
TRXDTDEF |
i4 |
2 |
N |
Default from setup |
Transaction date default: 0=Exact date; 1=Next date; 2=Previous date |
RTCLCMTD |
i4 |
2 |
N |
Default from setup |
Rate calculation method: 0=Multiply; 1=Divide |
PRVDSLMT |
i4 |
2 |
N |
0 |
Previous day's limits |
DATELMTS |
i4 |
2 |
N |
0 |
Date limits: 0=Unlimited; 1=Limited |
TIME1 |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Time 1 |
COMDLRAM |
number |
21 |
N |
Default from setup |
Commission amount |
COMAPPTO |
i4 |
2 |
N |
Default from setup |
Commission apply to |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, it populates the requester shadow table) |
CREATEDIST |
i4 |
2 |
N |
1 |
Flag to autocreate distributions: 0=Manual; 1=Automatic |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.