<taSopDistribution>

  • Article

Element name

Data type

Length

Required

Default

Description

SOPTYPE

i4

2

Y

Not applicable

SOP type:

1=Quote;

2=Order;

3=Invoice;

4=Return;

5=Bkorder;

6=Fulfillment order

SOPNUMBE

string

21

Y

Not applicable

SOP number

SEQNUMBR

i4

4

N

0

Sequence number

DISTTYPE

i4

2

Y

Not applicable

Distribution type:

1=Sales;

2=Receiving;

3=Cash;

4=Taken;

5=Available;

6=Trade;

7=Freight;

8=Miscellaneous;

9=Taxes;

10=Mark;

11=Commission Expense;

12=Commission pay;

13=Other;

14=COGS;

15=Invoice;

16=Returns;

17=In use;

18=In service;

19=Damaged;

20=Unit;

21=Deposits;

22=Round

DistRef

string

30

N

<blank>

Distribution reference

ACTINDX

i4

4

N

0

Account index

ACTNUMST

string

75

N

<blank>

Account number string

DEBITAMT

number

21

N

0

Debit amount

CRDTAMNT

number

21

N

0

Credit amount

CUSTNMBR

string

15

Y

Not applicable

Customer number

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates the requester shadow table)

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 valid distribution types for each SOPTYPE are as follows:

SOPTYPE

Distribution types

3

1 , 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, or 21

4

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, or 21

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.