Allocation Markers - Input Payload Element Definitions
Payload elements are defined as follows:
| Element | Type | Description |
<SSC> |
Top level element. | |
<User>
|
User element. | |
<Name>
|
Alphanumeric, length 3 | User name specify the user Id under which the payload is run. This user Id must be already set up in SunSystems using Security Console or User Manager prior to executing the payload. |
<SunSystemsContext>
|
Used to specify high level information that is used at run time to identify which business unit and ledger table are to be used. | |
<BusinessUnit> |
Alphanumeric, length 3 | Business unit the business unit in which ledger transactions are to be amended must be specified. |
<BudgetCode>
|
Alphabetic, length 1 | Budget code specify which ledger budget code for the transactions that are to be amended. |
<Payload> |
High level element that is used to flag the start of the data. A payload file only contains one <Payload> element. | |
<AllocationMarkers>
|
High level element that is used to flag the start of an allocation marker data element. A payload file must contain at least one of these. There is no limit to the number of <AllocationMarkers> that can be present within a <Payload> element. | |
<AllocationMarker>
|
Alphanumeric, length 1 | This is used as a selection criterion. Specify the allocation marker value that you wish to amend. The component then only selects ledger transactions that have this value. Allowable values are: 0-9, 'A', 'B', 'C', 'F', 'P', 'R', 'S', 'W', 'Y'. |
<AnalysisCode1>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode2>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode3>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode4>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode5>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode6>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode7> |
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode8>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode9>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<AnalysisCode10>
|
Alphanumeric, length 15 | Analysis value for given analysis dimension applicable for the ledger transaction. This is used as a selection criterion. The component then only selects transactions that have this value. |
<BaseAmount>
|
Numeric, maximum number of digits in total must not exceed 18 and including up to 3 decimal places | Transaction line value (base currency) - This is used as a selection criterion. The component then only selects transactions that have this value. |
<DebitCredit>
|
Alphabetic, length 1 | Debit Credit Indicator - this is used as a selection criterion. The component then only selects transactions that have this value. Allowable values are: 'C' Credit 'D' Debit. |
<DueDate>
|
Date, must be in DDMMYYY format, e.g. 31012003 | Due date - this is used as a selection criterion.
Nota: The component selects ALL transactions that have a Due Date
that is earlier or equal to this value.
|
<JournalLineNumber>
|
Numeric, must be greater than zero and less than 1000000000 | Journal line number this is used as a selection criterion.
The component then only selects transactions that have this value.
Nota:
SunSystems
does not allow you to create more than 999,999,999 Journal lines for a single
Journal.
|
<JournalNumber>
|
Numeric, must be greater than zero and less than 1000000000 | Journal number - this is used as a selection criterion. The
component then only selects transactions that have this value.
Nota:
SunSystems
does not allow you to create more than 999,999,999 Journals.
|
<JournalType>
|
Alphanumeric, length 5 | Journal type - this is used as a selection criterion. The component then only selects transactions that have this value. |
<TransactionAmount>
|
Numeric, maximum number of digits in total must not exceed 18, including up to 3 decimal places | Transaction line value (transaction currency) - this is used as a selection criterion. The component then only selects transactions that have this value. |
<TransactionReference> |
Alphanumeric, length 30 | Transaction reference this is used as a selection criterion. The component then only selects transactions that have this value. |
<TransactionDateFrom>
|
Alphanumeric.
Nota: If you specify an incorrect date, the payload may not be
imported into the system.
|
This is used as selection criteria. The component then only selects transactions taking place from that date. |
<TransactionDateTo>
|
Alphanumeric.
Nota: If you specify an incorrect date, the payload may not be
imported into the system.
|
This is used as selection criteria. The component then only selects transactions ending on that date. |
<AccountRange>
|
High level element used to specify an account code range, from which ledger transactions are selected. | |
<AccountCodeFrom>
|
Alphanumeric, length 15 | From account code - this is used as a selection criterion.
The component then only selects transactions that have this value. Specify the
start of the account code range that you wish to use.
Nota: If you wish to specify a single Account code, then set
<AccountCodeFrom> and <AccountCodeTo> to the same value.
|
<AccountCodeTo>
|
Alphanumeric, length 15 | To account code - this is used as a selection criterion.
The component then only selects transactions that have this value. Specify the
end of the account code range that you wish to use.
Nota: If you wish to specify a single account code, then set
<AccountCodeFrom> and <AccountCodeTo> to the same value.
|
<Actions>
|
High level element used to specify what action(s) you want to apply to your selected ledger transactions. | |
<AllocationMarker> |
Alphanumeric, length 1 | Specify the allocation marker that you wish the existing
value to be amended to. Allowable values are: 0-9, 'F', 'R', and 'W'.
Nota: You can only amend an existing non-balancing marker to
another non-balancing marker.
|
<ControlTotal> |
Numeric, maximum number of digits in total must not exceed 18 and including up to 3 decimal places | A control total of summed transaction line values (base
currency).
Nota: You must manually calculate the figure to be specified. If
the specified figure differs from the sum calculated by the component at run
time, an error is returned and the transaction lines are unchanged.
Nota: If you specify a control total value, you MUST specify a
value for <DebitCredit>.
|
<DebitCredit> |
Alphabetic, length 1 | Debit credit indicator this is used with ControlTotal to
specify whether the ControlTotal value is debit or credit. Allowable values
are: 'C' Credit, 'D' Debit.
Nota: If you specify a <DebitCredit> value you MUST specify
a value for <ControlTotal>.
|
<Increment>
|
Numeric, 1 digit | Specify the value by which the existing user-defined
allocation marker is to be incremented by. Allowable values: 1-9.
Nota: If you specify '1' an existing Allocation Marker value of
'0' is amended to '1'. If you specify '3' an existing Allocation Marker value
of '4' is amended to '7'.
If you specify an increment value that cannot be applied
to a ledger line, an error message is displayed and the transaction is left
unchanged. For example, if you specified an increment of '3' and a ledger
transaction with an allocation marker value of '8' qualified for selection.
Instead of amending the allocation marker value to '11', the component displays
an error message and the line is left unchanged.
Nota: You cannot specify both an <Increment> AND an
<AllocationMarker> within an <Action> element. You MUST only
specify one or the other.
|