<taAnalyticsDistribution>*

Element name

Data type

Length

Required

Default

Description

DOCNMBR

string

50

Y

Not applicable

The document number. Specify the same number as the document that includes the analytical accounting distribution. Refer to the next table for additional information.

DOCTYPE

i4

2

Y

0

The document type. The possible value of the document type is determined by the source of the document number. Refer to the next table to view the document types for each document.

AMOUNT

number

21

N

<blank>

When you need to change the assigned percentages, supply only the amount or percentage. No other elements should be included. You do not need to supply a dimension value.

aaAssignedPercent

number

9

N

<blank>

When you need to change the assigned percentages, supply only the amount or percentage. No other elements should be included. You do not need to supply a dimension value.

DistSequence

i4

2

N

<blank>

The GL distribution sequence number. If you have duplicate accounts in a transaction, associate them using sequence number values.

ACTNUMST

string

75

N

<blank>

Account number

ACTINDX

i4

2

N

<blank>

Account index

DistRef

string

31

N

<blank>

Distribution reference

NOTETEXT

string

8000

N

<blank>

Notes field

aaTrxDim

string

31

N

<blank>

Transaction dimension

aaTrxDimCode

string

31

N

<blank>

The transaction dimension alphanumeric code. If you update only the dimension code value, do not update the amount, assigned percentage, or other elements.

aaTrxDimCodeNum

number

21

N

<blank>

Transaction dimension numeric

aaTrxDimCodeBool

i4

2

N

<blank>

Transaction dimension yes/no

aaTrxDimCodeDate

datetime

8 bytes

(19 to 23 chars)

N

<blank>

Transaction dimension date

aaTrxDimID

i4

2

N

<blank>

Transaction dimension ID

aaTrxCodeID

i4

2

N

<blank>

Transaction dimension code ID

aaSubLedgerHdrID

i4

2

N

<blank>

Subledger header lookup

aaSubLedgerDistID

i4

2

N

<blank>

Subledger distribution lookup

aaSubLedgerAssignID

i4

2

N

1

The subledger assign lookup ID. To add new distribution lines, use this element and increment its value by 1 for each assignment.

UpdateIfExists

i4

2

N

1

Flag that specifies whether to update the data if it exists:

0 = Do not update;

1 = Update if record exists

RequesterTrx

i4

2

N

0

Requester transaction:

0 = False;

1 = True (if True, the Requester shadow table is populated)

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 document number and document type values vary, depending on the type of XML document that contains the analytical accounting distribution. For example, if the analytical accounting distribution is associated with a bank receipt document, the DOCNMBR value should be the same as the CMRECNUM value of the bank receipt document. With the DOCNMBR set to the value of the bank receipt document, set the DOCTYPE value of the analytical accounting distribution to 2.

The following table shows the document type values that can be used with a document number, based on the type of document number.

Document number (DOCNMBR)

Possible document type values (DOCTYPE)

General Ledger (JRNENTRY)

0 = Transactions

Bank Transaction (CMRECNUM)

3 = Credit

4 = Withdrawal

5 = Increase adjustment

6 = Decrease adjustment

Bank Receipt (CMRECNUM)

2 = Check, cash, or credit card

RM Transaction (DOCNUMBR)

1 = Sales invoice

3 = Debit memo

4 = Finance charge

5 = Service or repair

6 = Warranty

7 = Credit memo

8 = Return

9 = RM cash receipt

PM Transaction

0 = Voucher

1 = Payment

SOP Transaction (SOPNUMBE)

3 = Invoice

4 = Return

IV Transaction (IVDOCNBR)

1 = Adjustment (increase or decrease)

2 = Variance

3 = Transfer

POP Transaction (PONUMBER)

0 = Purchase order

POP Transaction (POPRCTNM)

1 = Shipment

2 = Enter/Match

3 = Shipment/Invoice