Skip to content
Revenue API
/
/
List journal entry lines...

List journal entry lines by sales order number

Request

Purpose

Returns the lines of a journal entry that reference the given sales order number (soNum).

When to use

  • Find the lines of an entry that relate to a specific sales order, for example when an auditor or customer asks about one order.
Security
OneIdOAuth
Path
jeIdinteger, (int64)required

ID of the journal entry.

Example:10045
soNumberstringrequired

Sales order number to search for.

Example:SO-50012
cURL
curl -i -X GET \
  https://one.zuora.com/revenue/services/v1/journal-entries/10045/lines/search/SO-50012 \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>'

Responses

Matching lines (may be empty)

Headers
traceIdstring

Identifier of the request. Quote it when you contact Zuora Support.

Bodyapplication/json
Array [
idinteger or null, (int64)

Unique system-generated identifier of the journal entry line.

Example:70001
headerIdinteger or null, (int64)

Identifier of the journal entry (header) this record belongs to.

Example:10045
clientIdinteger or null, (int32)

Identifier of your Zuora Revenue client (tenant partition). Informational.

Example:1
orgIdstring or null

Organization (operating unit) identifier the entry belongs to, also called the security attribute value (secAtrVal). Valid values come from orgId in GET /journal-entries/metadata.

Example:"101"
createdBystring or null

User who created the record.

Example:"jane.doe@example.com"
createdDatestring or null, (date-time)

Timestamp when the record was created (ISO 8601).

Example:"2026-09-28T10:21:04.000+00:00"
updatedBystring or null

User who last updated the record.

Example:"jane.doe@example.com"
updatedDatestring or null, (date-time)

Timestamp when the record was last updated (ISO 8601).

Example:"2026-09-28T10:21:04.000+00:00"
bookIdinteger or null, (int32)

Identifier of the accounting book (for example the primary book or a secondary/parallel book) the entry belongs to.

Example:1
rcIdinteger or null, (int64)

Revenue contract (RC) identifier the line relates to.

Example:1001
rcLineIdinteger or null, (int64)

Revenue contract line identifier the line relates to.

Example:50001
currencystring or null

ISO 4217 transaction currency of the line amount.

Example:"USD"
debitnumber or null, (double)

Debit amount in transaction currency.

Example:1500
creditnumber or null, (double)

Credit amount in transaction currency.

exchangeRateDatestring or null, (date-time)

Date the exchange rates apply to.

Example:"2026-09-30T00:00:00.000+00:00"
exchangeRatenumber or null, (double)

Functional exchange rate: converts transaction currency to functional currency.

Example:1
gexchangeRatenumber or null, (double)

Global (reporting) exchange rate: converts functional currency to the reporting currency.

Example:1
startDatestring or null, (date-time)

Start date of the revenue recognition period for the line.

Example:"2026-09-01T00:00:00.000+00:00"
endDatestring or null, (date-time)

End date of the revenue recognition period for the line.

Example:"2026-09-30T00:00:00.000+00:00"
reasonstring or null

Reason code explaining the adjustment.

Example:"RECLASS"
errorMessagestring or null

Validation error recorded on the line by the service, if any.

descriptionstring or null

Free-text description of the line.

Example:"Move deferred revenue to revenue"
commentsstring or null

Free-text comments on the line.

accountTypestring or null

Revenue activity (account) type of the line, for example Revenue, Contract Liability, Adjustment Revenue. Valid values come from accountTypes in GET /journal-entries/metadata.

Example:"Contract Liability"
soLineIdstring or null

Sales order (document) line identifier the line relates to.

Example:"SO-50012-1"
soNumstring or null

Sales order (document) number the line relates to.

Example:"SO-50012"
costOrVcTypestring or null

Indicates whether typeName is a cost type or a variable consideration type.

jeSetNointeger or null, (int64)

Set number that groups lines into a balanced set. Debits and credits within the same set number must net to zero. Use 1, 2, 3 ... to post several independent balanced sets in one entry.

Example:1
unbillAccountingstring or null

Unbilled accounting flag (Y/N). Y posts the line to unbilled (contract asset/unbilled receivable) accounts.

Example:"N"
accountCodestring or null

General ledger account code (accounting segments joined by your configured delimiter), for example 1000-200-4000.

Example:"1000-200-4000"
typeNamestring or null

Name of the cost type or variable consideration (VC) type when accountType is a cost or VC account.

reference1string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference1 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference2string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference2 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference3string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference3 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference4string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference4 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference5string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference5 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference6string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference6 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference7string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference7 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference8string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference8 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference9string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference9 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference10string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference10 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference11string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference11 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference12string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference12 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference13string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference13 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference14string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference14 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

reference15string or null

Customer-defined reference field. Use for your own identifiers (for example a ticket number or source-system key). reference15 is one of 15 reference fields; your tenant may assign it a custom label (see GET /journal-entries/configurations).

]
Response
[
  {
    "id": 70001,
    "headerId": 10045,
    "clientId": 1,
    "orgId": "101",
    "bookId": 1,
    "rcId": 1001,
    "rcLineId": 50001,
    "currency": "USD",
    "debit": 1500,
    "credit": null,
    "exchangeRateDate": "2026-09-30T00:00:00.000+00:00",
    "exchangeRate": 1,
    "gexchangeRate": 1,
    "startDate": "2026-09-01T00:00:00.000+00:00",
    "endDate": "2026-09-30T00:00:00.000+00:00",
    "accountType": "Contract Liability",
    "accountCode": "2400-100-000",
    "jeSetNo": 1,
    "soNum": "SO-50012",
    "soLineId": "SO-50012-1",
    "unbillAccounting": "N",
    "description": "Release deferred revenue",
    "errorMessage": null,
    "reference1": "TCK-4471",
    "createdBy": "jane.doe@example.com",
    "createdDate": "2026-09-28T10:21:04.000+00:00",
    "updatedBy": "jane.doe@example.com",
    "updatedDate": "2026-09-28T10:21:04.000+00:00"
  },
  {
    "id": 70002,
    "headerId": 10045,
    "clientId": 1,
    "orgId": "101",
    "bookId": 1,
    "rcId": 1001,
    "rcLineId": 50001,
    "currency": "USD",
    "debit": null,
    "credit": 1500,
    "exchangeRateDate": "2026-09-30T00:00:00.000+00:00",
    "exchangeRate": 1,
    "gexchangeRate": 1,
    "startDate": "2026-09-01T00:00:00.000+00:00",
    "endDate": "2026-09-30T00:00:00.000+00:00",
    "accountType": "Revenue",
    "accountCode": "4000-100-000",
    "jeSetNo": 1,
    "soNum": "SO-50012",
    "soLineId": "SO-50012-1",
    "unbillAccounting": "N",
    "description": "Recognize revenue",
    "errorMessage": null,
    "reference1": "TCK-4471",
    "createdBy": "jane.doe@example.com",
    "createdDate": "2026-09-28T10:21:04.000+00:00",
    "updatedBy": "jane.doe@example.com",
    "updatedDate": "2026-09-28T10:21:04.000+00:00"
  }
]