Journal Instruction



JournalInstruction [Schema]

Name Type Required Description
StartDate xsd:date yes The starting date when the instruction become effective.
EndDate xsd:date no The end date when the instruction stops being effective. [Optional] if omitted, instruction runs indefinitely.
NomCode xsd:string ( max: 10) yes The nominal code for the journal line.
SubNomCode xsd:string ( max: 10) no [Optional] The sub nominal code for the journal line.
Description xsd:string ( max: 250) yes The description of any generated journal lines.
LedgerTarget xsd:string ( max: 250) no The ledger target for generated journal lines. [Optional] used to target an accounting ledger format.
AccountingType xsd:string (enumeration)
  • Debit
  • Credit
yes The journal instruction account type.
Expression xsd:string
Pattern: ^[sS][eE][lL][eE][cC][tT].+ [fF][rR][oO][mM] .+
yes The journal instruction expression. Controls how the journal lines are generated from this instruction. Expression must follow the "SELECT [value] FROM [table]" pattern.
JournalLineTag xsd:string no The generated journal line tag value. [Optional] if present then all generated journal lines will be tagged with the specified value.

Example

<?xml version="1.0"?>
<JournalInstruction xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <StartDate>2021-01-26</StartDate>
  <EndDate>2021-01-26</EndDate>
  <NomCode>string</NomCode>
  <SubNomCode>string</SubNomCode>
  <Description>string</Description>
  <LedgerTarget>string</LedgerTarget>
  <AccountingType>Credit</AccountingType>
  <Expression>string</Expression>
  <JournalLineTag>string</JournalLineTag>
</JournalInstruction>
{
  "JournalInstruction": {
    "StartDate": "2021-01-26",
    "EndDate": "2021-01-26",
    "NomCode": "string",
    "SubNomCode": "string",
    "Description": "string",
    "LedgerTarget": "string",
    "AccountingType": "Credit",
    "Expression": "string",
    "JournalLineTag": "string"
  }
}