A contract expense schedule shows when the deferred expense for a contract or contract line item is expected to post during the contract term.

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

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


List Contract Expense Schedules

readByQuery

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

Parameters

Name Required Type Description
object Required string Use CONTRACTEXPENSESCHEDULE
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 Set a 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 Expense 2 Schedules

readByQuery

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

Parameters

Name Required Type Description
object Required string Use CONTRACTEXPENSE2SCHEDULE
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 Set a 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 Expense Schedule

read

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

Parameters

Name Required Type Description
object Required string Use CONTRACTEXPENSESCHEDULE
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 Expense 2 Schedule

read

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

Parameters

Name Required Type Description
object Required string Use CONTRACTEXPENSE2SCHEDULE
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.

Provide feedback