A revenue schedule shows when the deferred revenue for a contract line item is expected to be recognized during the contract line term.

You can post revenue schedules according to an as-of date, or you can post individual revenue schedule entries.

For a revenue schedule, you typically execute two posts: one to the ASC 605 set of journals (revenue schedule) and one for the ASC 606 set of journals (revenue 2 schedule).


List Contract Revenue Schedules

readByQuery

<readByQuery>
    <object>CONTRACTREVENUESCHEDULE</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use CONTRACTREVENUESCHEDULE
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
CONTRACTID Optional string Contract ID
LINENO Optional integer Line number from the contract
STATE Optional string State of the schedule. Use I for in progress, H for on hold, C for completed, or T for terminated.

List Contract Revenue 2 Schedules

readByQuery

<readByQuery>
    <object>CONTRACTREVENUE2SCHEDULE</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use CONTRACTREVENUE2SCHEDULE
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
CONTRACTID Optional string Contract ID
LINENO Optional integer Line number from the contract
STATE Optional string State of the schedule. Use I for in progress, H for on hold, C for completed, or T for terminated.

Get Contract Revenue Schedule

read

<read>
    <object>CONTRACTREVENUESCHEDULE</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use CONTRACTREVENUESCHEDULE
keys Required string The record RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Get Contract Revenue 2 Schedule

read

<read>
    <object>CONTRACTREVENUE2SCHEDULE</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use CONTRACTREVENUE2SCHEDULE
keys Required string The record RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Post Contract Revenue Schedule

You can post all contract revenue schedule entries for a given customer (across contracts) or for a given contract.

post

<post>
    <CONTRACTREVENUESCHEDULE>
        <POSTINGDATE>09/05/2017</POSTINGDATE>
        <ASOFDATE>07/05/2017</ASOFDATE>
        <CUSTOMERID>C-103</CUSTOMERID>
        <CONTRACTID>CTRC-003</CONTRACTID>
    </CONTRACTREVENUESCHEDULE>
</post>

Parameters

Name Required Type Description
CONTRACTREVENUESCHEDULE Required object Object to post

CONTRACTREVENUESCHEDULE

Name Required Type Description
POSTINGDATE Required string Posting date in format mm/dd/yyyy
ASOFDATE Required string As of date in format mm/dd/yyyy
CUSTOMERID Optional string Customer ID. To post all schedule entries for the customer, omit CONTRACTID. Required if not not using Contract ID.
CONTRACTID Optional string Contract ID. Required if not not using Customer ID.

Post Contract Revenue 2 Schedule

You can post all contract revenue 2 schedule entries for a given customer (across contracts) or for a given contract.

post

<post>
    <CONTRACTREVENUE2SCHEDULE>
        <POSTINGDATE>09/05/2017</POSTINGDATE>
        <ASOFDATE>07/05/2017</ASOFDATE>
        <CUSTOMERID>C-103</CUSTOMERID>
        <CONTRACTID>CTRC-003</CONTRACTID>
    </CONTRACTREVENUE2SCHEDULE>
</post>

Parameters

Name Required Type Description
CONTRACTREVENUE2SCHEDULE Required object Object to post

CONTRACTREVENUE2SCHEDULE

Name Required Type Description
POSTINGDATE Required string Posting date in format mm/dd/yyyy
ASOFDATE Required string As of date in format mm/dd/yyyy
CUSTOMERID Optional string Customer ID. To post all schedule entries for the customer, omit CONTRACTID. Required if not not using Contract ID.
CONTRACTID Optional string Contract ID. Required if not not using Customer ID.

Post Contract Revenue Schedule Entry

Posts a single contract revenue schedule entry.

post

<post>
    <CONTRACTREVENUESCHEDULEENTRY>
        <RECORDNO>5</RECORDNO>
        <POSTINGDATE>09/05/2017</POSTINGDATE>
    </CONTRACTREVENUESCHEDULEENTRY>
</post>

Parameters

Name Required Type Description
CONTRACTREVENUESCHEDULEENTRY Optional object Object to post

CONTRACTREVENUESCHEDULEENTRY

Name Required Type Description
RECORDNO Required integer Record number of the contract revenue schedule entry to post
ASOFDATE Required string As of date in format mm/dd/yyyy

Unpost Contract Revenue Schedule Entry

unpost

<unpost>
    <CONTRACTREVENUESCHEDULEENTRY>
        <RECORDNO>5</RECORDNO>
    </CONTRACTREVENUESCHEDULEENTRY>
</unpost>

Parameters

Name Required Type Description
CONTRACTREVENUESCHEDULEENTRY Required object Object to unpost

CONTRACTREVENUESCHEDULEENTRY

Name Required Type Description
RECORDNO Required integer Record number of the contract revenue schedule entry to unpost

Provide feedback