Skip to content

Open Balance Schemas

All fields applicable to the Open Balance product. Open Balance is a lightweight schema — its primary purpose is delivering a current balance snapshot per document for portal display and payment facilitation.

For shared schemas (Currency Models, etc.) see Shared Schemas & Currency Models.


Account

Only the account name and reference are applicable to Open Balance. Account records are still required as parent resources for documents.

Field Type Required Description
reference string Yes Caller-defined unique identifier.
name string Yes Customer name.

Document

Core Fields

Field Type Required Description
account_number string Yes Account this document belongs to.
invoice_num string Conditional Display invoice number shown in portals. If omitted, the URL path document_number is used.
applies_to_invoice string Conditional Required when document_type is credit_note.
invoice_date date (ISO 8601) Yes Document issue date.
ship_to_account_num string No Ship-to customer account number.
po_number string No Purchase order number.
fabricated_record boolean No True indicates this document was synthesised by Data Bridge and does not correspond to a real invoice in the caller's ERP.
branch_name string Conditional Branch / territory identifier. Required for multi-entity deployments.
discount_date date No Early-payment discount expiry date.
discount_amount string No Early-payment discount amount.
template_id string Conditional Open Balance template ID. Required when configured to accept flexible payments on fabricated records.

Custom Fields (UDP)

Up to 5 User Defined Properties, configurable for portal display columns.

Field Type Description
udp1 string Open Balance custom field 1
udp2 string Open Balance custom field 2
udp3 string Open Balance custom field 3
udp4 string Open Balance custom field 4
udp5 string Open Balance custom field 5

Financial Fields — Basic Currency Model

All three fields must be provided together.

Field Type Required Description
currency ISO 4217 Conditional* ISO 4217 currency code. *All three Basic fields must be provided together.
original_denomination denomination Conditional* Original gross amount. Does not change when partially paid.
denomination denomination Conditional* Current open balance. When 0, document is automatically closed.

Closure

Field Type Required Description
closure_reason string Yes One of: paid, write_off, contra, adjustment, other
closure_date date (ISO 8601) No Date of closure. Defaults to current date if absent.
notes string No Free-text notes on the closure.