Sage 200 Online Nominal Code XML

The value of every transaction entered into Sage 200 is posted to a nominal account. It is where the revenue and expenditure of the business is recorded. Further information can be found on the Sage 200 Online Nominal Code API Documentation.

Tasks

• Exporting Nominal Codes From Sage 200 Online

Fields for Download Only

id

Read Only
Nominal code record Id.

Type	Example	XML
integer(int64)	2	<id>2</id>

date_time_created

Read Only
The date and time this entity was created (UTC).

Type	Example	XML
datetime	2021-08-04T09:54:24.36Z	<date_time_created>2021-08-04T09:54:24.36Z</date_time_created>

date_time_updated

Read Only
The date and time this entity was last updated (UTC).

Type	Example	XML
datetime	2021-02-28T14:23:46.717Z	<date_time_updated>2021-02-28T14:23:46.717Z</date_time_updated>

reference

Read Only
Nominal code reference.

Type	Example	XML
string(8)	4000	<reference>4000</reference>

report_category_id

Read Only
Financial report category record Id. This is ignored when the nominal account type is Group (Sage 200 Professional only).

Type	Example	XML
integer(int64)	2259	<report_category_id>2259</report_category_id>

name

Read Only
Nominal code name.

Type	Example	XML
string(60)	Sales North Admin	<name>Sales North Admin</name>

cost_centre_id

Read Only
Nominal code cost centre record Id.

Type	Example	XML
integer(int64)	44851	<cost_centre_id>44851</cost_centre_id>

department_id

Read Only
Nominal code department record Id.

Type	Example	XML
integer(int64)	2254	<department_id>2254</department_id>

nominal_account_type

Read Only
The type of the nominal code. (Sage 200 Professional only).

Type	Example	XML
string(20)	NominalAccountTypePosting	<nominal_account_type>NominalAccountTypePosting</nominal_account_type>

account_status_type

Read Only
The status of the nominal code (Sage 200 Standard and versions of Professional released after February 2018). For example, this can either be 'Active' or 'Hidden'.

Type	Example	XML
string(20)	AccountStatusActive	<account_status_type>AccountStatusActive</account_status_type>

sofa_category_id

Read Only
Sofa category record Id.

Type	Example	XML
integer(int64)	0	<sofa_category_id>0</sofa_category_id>

display_balances_in_selection_list

Read Only
Whether balances for the nominal code can be shown in selection lists.

Type	Example	XML
boolean()	false	<display_balances_in_selection_list>false</display_balances_in_selection_list>

allow_manual_journal_entries

Read Only
Determines if manual journals can be entered using this nominal code. This is ignored when the nominal account type is Group (Sage200 Professional only).

Type	Example	XML
boolean()	true	<allow_manual_journal_entries>true</allow_manual_journal_entries>

use_batch_postings

Read Only
Determines if batch postings are to be made on this account when updating waiting postings. This is ignored when the nominal account type is Group (Sage200 Professional only).

Type	Example	XML
boolean()	false	<use_batch_postings>false</use_batch_postings>

periods_to_keep_transactions

Read Only
Number of periods to keep transactions. This is ignored when the nominal account type is Group (Sage200 Professional only).

Type	Example	XML
integer(int32)	36	<periods_to_keep_transactions>36</periods_to_keep_transactions>

consolidated_nominal_account_number

Read Only
Consolidated nominal account number. This is ignored when the nominal account type is Memo or Group (Sage200 Professional only).

Type	Example	XML
string(8)	4000	<consolidated_nominal_account_number>4000</consolidated_nominal_account_number>

consolidated_nominal_cost_centre

Read Only
Consolidated nominal cost centre. This is ignored when the nominal account type is Memo or Group (Sage200 Professional only).

Type	Example	XML
string(3)	ADM	<consolidated_nominal_cost_centre>ADM</consolidated_nominal_cost_centre>

consolidated_nominal_department

Read Only
Consolidated nominal department. This is ignored when the nominal account type is Memo or Group (Sage200 Professional only).

Type	Example	XML
string(3)	4	<consolidated_nominal_department>4</consolidated_nominal_department>

analysis_code_1

Read Only
Analysis Code 1.

Type	Example	XML
string(60)	Test	<analysis_code_1>Test</analysis_code_1>

analysis_code_2

Read Only
Analysis Code 2.

Type	Example	XML
string(60)	Test	<analysis_code_2>Test</analysis_code_2>

analysis_code_3

Read Only
Analysis Code 3.

Type	Example	XML
string(60)	Test	<analysis_code_3>Test</analysis_code_3>

analysis_code_4

Read Only
Analysis Code 4.

Type	Example	XML
string(60)	Test	<analysis_code_4>Test</analysis_code_4>

analysis_code_5

Read Only
Analysis Code 5.

Type	Example	XML
string(60)	Test	<analysis_code_5>Test</analysis_code_5>

cost_centre_code

Read Only
Cost centre code.

Type	Example	XML
string(3)	ADM	<cost_centre_code>ADM</cost_centre_code>

department_code

Read Only
Department code.

Type	Example	XML
string(3)	4	<department_code>4</department_code>

balance_year_to_date

Read Only
The nominal account balance, if balances can be shown for the nominal account.

Type	Example	XML
number(decimal 2dp)	-1300.00	<balance_year_to_date>-1300.00</balance_year_to_date>

debit_balance_year_to_date

Read Only
The debit balance year to date.

Type	Example	XML
number(decimal 2dp)	0.00	<debit_balance_year_to_date>0.00</debit_balance_year_to_date>

credit_balance_year_to_date

Read Only
The credit balance year to date.

Type	Example	XML
number(decimal 2dp)	1300.00	<credit_balance_year_to_date>1300.00</credit_balance_year_to_date>

brought_forward_balance

Read Only
The nominal account brought forward balance, if balances can be shown for the nominal account.

Type	Example	XML
number(decimal 2dp)	0.00	<brought_forward_balance>0.00</brought_forward_balance>

cost_centre

Read Only
Contains further information relating to the cost centre.

Type	Example	XML
object	See below	See below

department

Read Only
Contains further information relating to the department.

Type	Example	XML
object	See below	See below

report_category

Read Only
Contains further information relating to the report category.

Type	Example	XML
object	See below	See below

sofa_category

Read Only
Contains further information relating to the sofa category.

Type	Example	XML
object	See below	See below

Example XML

<?xml version="1.0" encoding="utf-8"?>
<NominalCodes
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <NominalCode>
    <id>49781</id>
    <date_time_created>2021-08-04T09:54:24.36Z</date_time_created>
    <date_time_updated>2021-02-28T14:23:46.717Z</date_time_updated>
    <reference>4000</reference>
    <report_category_id>2259</report_category_id>
    <name>Sales North Admin</name>
    <cost_centre_id>44851</cost_centre_id>
    <department_id>2254</department_id>
    <nominal_account_type>NominalAccountTypePosting</nominal_account_type>
    <account_status_type>AccountStatusActive</account_status_type>
    <sofa_category_id>0</sofa_category_id>
    <display_balances_in_selection_list>false</display_balances_in_selection_list>
    <allow_manual_journal_entries>true</allow_manual_journal_entries>
    <use_batch_postings>false</use_batch_postings>
    <periods_to_keep_transactions>36</periods_to_keep_transactions>
    <consolidated_nominal_account_number />
    <consolidated_nominal_cost_centre />
    <consolidated_nominal_department />
    <analysis_code_1 />
    <analysis_code_2 />
    <analysis_code_3 />
    <analysis_code_4 />
    <analysis_code_5 />
    <cost_centre_code>ADM</cost_centre_code>
    <department_code>4</department_code>
    <balance_year_to_date>-1300.00</balance_year_to_date>
    <debit_balance_year_to_date>0.00</debit_balance_year_to_date>
    <credit_balance_year_to_date>1300.00</credit_balance_year_to_date>
    <brought_forward_balance>0.00</brought_forward_balance>
    <cost_centre>
      <id>44851</id>
      <date_time_created>2021-07-22T14:03:17.53Z</date_time_created>
      <date_time_updated>2021-02-28T14:23:46.23Z</date_time_updated>
      <code>ADM</code>
      <name>Administration</name>
      <contact_name />
      <contact_details />
      <contact_email_address />
      <is_to_delete xsi:nil="true" />
    </cost_centre>
    <department>
      <id>2254</id>
      <date_time_created>2021-02-28T14:03:57.137Z</date_time_created>
      <date_time_updated>2021-02-28T14:23:46.277Z</date_time_updated>
      <code>4</code>
      <name>Admin</name>
      <contact_name />
      <contact_details />
      <contact_email_address />
      <is_to_delete xsi:nil="true" />
    </department>
    <report_category>
      <id>2259</id>
      <date_time_created>2021-02-28T14:03:57.783Z</date_time_created>
      <date_time_updated>2021-02-28T14:23:45.96Z</date_time_updated>
      <account_report_type>ProfitLoss</account_report_type>
      <code>101</code>
      <description>Product Sales</description>
      <account_report_category_type>NominalReportingCategoryTypeIncome</account_report_category_type>
    </report_category>
    <sofa_category>
      <id>0</id>
      <date_time_created xsi:nil="true" />
      <date_time_updated xsi:nil="true" />
      <account_report_type>ProfitLoss</account_report_type>
      <code />
      <description />
      <account_report_category_type>NominalReportingCategoryTypeExpense</account_report_category_type>
    </sofa_category>
  </NominalCode>
</NominalCodes>