<taCreateSopPaymentInsertRecord>

Element name

Data type

Length

Required

Default

Description

SOPTYPE

i4

2

Y

Not applicable

2=Order;

3=Invoice;

4=Return;

5=Back order;

6=Fulfillment order

SOPNUMBE

string

21

Y

Not applicable

Invoice number

CUSTNMBR

string

15

Y

Not applicable

Customer number

CUSTNAME

string

64

N

<blank>

Customer name

DOCDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Document date

DOCAMNT

number

21

N

0

Payment amount; required and used only when Action=1 or 3

CHEKBKID

string

15

N

<blank>

Checkbook ID

CARDNAME

string

15

N

<blank>

Credit card name--value if credit card transaction

CHEKNMBR

string

20

N

<blank>

Check number--value if check

RCTNCCRD

string

20

N

<blank>

Credit card number--value if credit card

AUTHCODE

string

15

N

<blank>

Authorization code--value if credit card

EXPNDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Credit card expiration date

PYMTTYPE**

i4

4

N

1

Payment types:

1=Cash deposit;

2=Check deposit;

3=Credit card deposit;

4=Cash payment;

5=Check payment;

6=Credit card payment

DOCNUMBR

string

20

N

<blank>

Payment number/cash receipt number; required if Action=2, SOPTYPE=2, and PYMTTYPE=(1, 2, or 3); required if Action=2 and SOPTYPE=3; required if Action=3, SOPTYPE=2, and PYMTTYPE=(1, 2, or 3)

Action

i4

2

N

Default from setup

Default from setup:

1=New transaction/new payment;

3=Modify existing payment

Must set to 2 manually;

2=Delete payment

SEQNUMBR

i4

4

N

Default from setup

Sequence number; required if Action=1, SOPTYPE=2, and multiple PYMTTYPE=6 exist

Required if Action=2, SOPTYPE=2, and PYMTTYPE=6

Required if Action=3 and DOCNUMBR and PYMTTYPE elements exist multiple times on document

MDFUSRID

string

15

N

<blank>

Modified user iD

VOIDDATE

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Void date

PROCESSELECTRONICALLY

i4

1

N

0

Process Electronically

0 = False

1 = True

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

** The following are the valid payment type codes for each SOPTYPE:

SOPTYPE

PYMTTYPE

2

1=Cash deposit

2=Check deposit;

3=Credit card deposit

6=Credit card payment

3

4=Cash payment

5=Check payment

6=Credit card payment

4

4=Cash payment

5=Check payment

6=Credit card payment

5

1=Cash deposit

2=Check deposit;

3=Credit card deposit

6=Credit card payment

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.