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