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