Get all billing adjustments
get
/crmRestApi/resources/11.13.18.05/billingAdjustments
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- PrimaryKey: Finds a bill adjustment with the specified primary key.
Finder Variables:- BillAdjustmentRequestsId; integer; The unique identifier of the billing adjustment.
- RowFinder: Finds a bill adjustment with the specified alternate primary key.
Finder Variables:- BillAdjustmentRequestsNumber; string; The alternate unique identifier of the billing adjustment.
- PrimaryKey: Finds a bill adjustment with the specified primary key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AdditionalComments; string; The additional approval or rejection comments for this adjustment.
- AdjustmentReason; string; The reason for the bill adjustment.
- AdjustmentType; string; The type of the adjustment request, such as bill, item or event level adjustment.
- AdjustmentUnitOfMeasure; string; The unit of measure for the bill adjustment.
- AmountDue; number; The actual due amount.
- ApproveAmount; number; The amount for which adjustment is approved.
- ApprovePercent; number; The percentage of amount for which adjustment is approved.
- ApprovedByPartyId; integer; The unique identifier of the user who approved the adjustment request.
- ApprovedByPartyName; string; The name of the user who approved the adjustment request.
- ApprovedByPartyNumber; string; The public unique identifier of the user who approved the adjustment request.
- AssigneePersonName; string; The name of the assignee.
- AssigneeResourceId; integer; The unique identifier of the resource assigned to the service request.
- AssigneeResourceNumber; string; The public unique identifier of the assignee.
- BillAdjustmentRequestsId; integer; The unique identifier of the bill adjustment request.
- BillAdjustmentRequestsNumber; string; The unique identifier of the bill adjustment request record.
- CategoryId; integer; The service request category associated with the bill adjustment.
- CategoryName; string; The service request category name associated with the bill adjustment.
- CategoryShortName; string; The service request category short name.
- Comments; string; The comments for this adjustment.
- CorpCurrencyCode; string; The corporate currency code of the bill adjustment request.
- CreatedBy; string; The user who created the row.
- CreationDate; string; The date and time of the row creation.
- CurcyConvRateType; string; The rate type of currency conversion.
- CurrencyCode; string; The currency code of the bill adjustment request.
- ExternalAdjustmentId; string; The adjustment ID from the external billing system.
- ExternalAdjustmentNumber; string; The public unique identifier of adjustment from the external billing system.
- ExternalBalanceGroupId; string; The unique identifier of balance group of noncurrency from the external billing system.
- ExternalBalanceGroupNumber; string; The public unique identifier of balance group of noncurrency from the external billing system.
- ExternalBillId; string; The bill ID from the external billing system.
- ExternalBillItemId; string; The bill item ID from the external billing system.
- ExternalBillItemNumber; string; The public unique identifier of the bill item from the external billing system.
- ExternalBillNumber; string; The public unique identifier of the bill from the external billing system.
- ExternalBillUnitId; string; The unique identifier of the bill unit for the adjustment request.
- ExternalBillUnitNumber; string; The public unique identifier of the bill unit for the adjustment request.
- ExternalServiceId; string; The service ID from the external billing system.
- ExternalServiceNumber; string; The public unique identifier of the service from the external billing system.
- ExternalServiceType; string; The type of the adjusted resource for a noncurrency adjustment request.
- LastUpdateDate; string; The date and time of the last update made to the row.
- LastUpdateLogin; string; The session login associated to the user who last updated the row.
- LastUpdatedBy; string; The user who last updated the row.
- NonCurrencyAdjustmentFlag; boolean; Indicates if the adjustment request is for a currency value or non-currency usage.
- NonCurrencyAdjustmentType; string; The type of the adjustment request, such as bill unit or event level for a non-currency adjustment.
- NonCurrencyUsageAmount; number; The actual non currency usage before adjustment.
- PartyName; string; The name of the resource assigned to the service request.
- PrimaryContactPartyId; integer; The unique identifier of the user who initially reported the adjustment request.
- PrimaryContactPartyName; string; The name of the adjustment request primary contact.
- PrimaryContactPartyNumber; string; The public unique identifier of the primary contact associated.
- QueueId; integer; The unique identifier of the queue assigned to the service request.
- QueueName; string; Indicates the service request queue.
- QueueNumber; string; The alternative key for the queue identifier.
- RejectReason; string; The reason for rejecting the adjustment.
- RejectedByPartyId; integer; The unique identifier of the user who rejected the adjustment request.
- RejectedByPartyName; string; The name of the user who rejected the adjustment request.
- RejectedByPartyNumber; string; The public unique identifier of the user who rejected the adjustment request.
- ReportedByPartyName; string; The person who reported the adjustment request.
- RequestAmount; number; The amount for which adjustment is requested.
- RequestPercent; number; The percentage of amount for which adjustment is requested.
- SrId; integer; The unique identifier of a service request record.
- SrNumber; string; The service request reference number that is associated with the bill adjustment.
- StatusCode; string; The status of the adjustment request.
- SubmittedByPartyId; integer; The unique ID of the user who submitted the adjustment request.
- SubmittedByPartyName; string; The user who submitted the adjustment request.
- SubmittedByPartyNumber; string; The public unique identifier of the user who submitted the adjustment request.
- TaxTreatment; string; Indicates whether the tax is included in the bill adjustment.
- Title; string; The title of a service request.
- ValidFrom; string; The date when the validity for non-currency adjustment starts.
- ValidTo; string; The date when the validity for non-currency adjustment ends.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : billingAdjustments
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : billingAdjustments-item-response
Type:
Show Source
object-
AdditionalComments: string
Title:
Additional CommentsMaximum Length:255The additional approval or rejection comments for this adjustment. -
AdjustmentReason: string
Title:
Adjustment ReasonMaximum Length:30The reason for the bill adjustment. -
AdjustmentType: string
Title:
Adjustment TypeMaximum Length:20The type of the adjustment request, such as bill, item or event level adjustment. -
AdjustmentUnitOfMeasure: string
Title:
Unit of MeasureMaximum Length:100The unit of measure for the bill adjustment. -
AmountDue: number
Title:
Amount DueThe actual due amount. -
ApproveAmount: number
Title:
Approved AmountThe amount for which adjustment is approved. -
ApprovedByPartyId: integer
(int64)
Title:
Approved by Party IDThe unique identifier of the user who approved the adjustment request. -
ApprovedByPartyName: string
Title:
Approved ByRead Only:trueMaximum Length:360The name of the user who approved the adjustment request. -
ApprovedByPartyNumber: string
Title:
Approved by Party NumberRead Only:trueMaximum Length:30The public unique identifier of the user who approved the adjustment request. -
ApprovePercent: number
Title:
Approved PercentageThe percentage of amount for which adjustment is approved. -
AssigneePersonName: string
Title:
Assigned ToRead Only:trueMaximum Length:360The name of the assignee. -
AssigneeResourceId: integer
(int64)
Title:
Assigned to Resource IDThe unique identifier of the resource assigned to the service request. -
AssigneeResourceNumber: string
Title:
Assigned to Resource NumberRead Only:trueMaximum Length:30The public unique identifier of the assignee. -
BillAdjustmentRequestsId: integer
(int64)
Title:
Bill Adjustment Request IDRead Only:trueThe unique identifier of the bill adjustment request. -
BillAdjustmentRequestsNumber: string
Title:
Bill Adjustment Request NumberMaximum Length:30The unique identifier of the bill adjustment request record. -
billingAdjustmentEvents: array
Billing Adjustment Events
Title:
Billing Adjustment EventsThe billing adjustment event resource is used to view, create, update, and delete a billing adjustment events. -
CategoryId: integer
(int64)
Title:
CategoryRead Only:trueThe service request category associated with the bill adjustment. -
CategoryName: string
Title:
Category NameRead Only:trueMaximum Length:400The service request category name associated with the bill adjustment. -
CategoryShortName: string
Title:
Category Short NameRead Only:trueMaximum Length:240The service request category short name. -
Comments: string
Title:
CommentsMaximum Length:255The comments for this adjustment. -
CorpCurrencyCode: string
Title:
Corporate Currency CodeMaximum Length:15The corporate currency code of the bill adjustment request. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The user who created the row. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date and time of the row creation. -
CurcyConvRateType: string
Title:
Currency Conversion Rate TypeMaximum Length:30The rate type of currency conversion. -
CurrencyCode: string
Title:
Currency CodeMaximum Length:15The currency code of the bill adjustment request. -
DeleteFlag: boolean
Title:
Delete IndicatorRead Only:trueIndicates whether the user can delete the record. -
ExternalAdjustmentId: string
Title:
External Adjustment IDMaximum Length:300The adjustment ID from the external billing system. -
ExternalAdjustmentNumber: string
Title:
External Adjustment NumberMaximum Length:300The public unique identifier of adjustment from the external billing system. -
ExternalBalanceGroupId: string
Title:
External Balance Group IDMaximum Length:300The unique identifier of balance group of noncurrency from the external billing system. -
ExternalBalanceGroupNumber: string
Title:
External Balance Group NumberMaximum Length:300The public unique identifier of balance group of noncurrency from the external billing system. -
ExternalBillId: string
Title:
External Bill IDMaximum Length:300The bill ID from the external billing system. -
ExternalBillItemId: string
Title:
External Bill Item IDMaximum Length:300The bill item ID from the external billing system. -
ExternalBillItemNumber: string
Title:
External Bill Item NumberMaximum Length:300The public unique identifier of the bill item from the external billing system. -
ExternalBillNumber: string
Title:
External Bill NumberMaximum Length:300The public unique identifier of the bill from the external billing system. -
ExternalBillUnitId: string
Title:
External Bill Unit IDMaximum Length:300The unique identifier of the bill unit for the adjustment request. -
ExternalBillUnitNumber: string
Title:
External Bill Unit NumberMaximum Length:300The public unique identifier of the bill unit for the adjustment request. -
ExternalServiceId: string
Title:
External Service IDMaximum Length:300The service ID from the external billing system. -
ExternalServiceNumber: string
Title:
External Service NumberMaximum Length:300The public unique identifier of the service from the external billing system. -
ExternalServiceType: string
Title:
External Service TypeMaximum Length:300The type of the adjusted resource for a noncurrency adjustment request. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date and time of the last update made to the row. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64The user who last updated the row. -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32The session login associated to the user who last updated the row. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NonCurrencyAdjustmentFlag: boolean
Title:
Noncurrency AdjustmentMaximum Length:1Default Value:falseIndicates if the adjustment request is for a currency value or non-currency usage. -
NonCurrencyAdjustmentType: string
Title:
Noncurrency Adjustment TypeMaximum Length:30The type of the adjustment request, such as bill unit or event level for a non-currency adjustment. -
NonCurrencyUsageAmount: number
Title:
Noncurrency UsageThe actual non currency usage before adjustment. -
PartyName: string
Title:
Assigned ToRead Only:trueMaximum Length:360The name of the resource assigned to the service request. -
PrimaryContactPartyId: integer
(int64)
Title:
Primary Contact IDThe unique identifier of the user who initially reported the adjustment request. -
PrimaryContactPartyName: string
Title:
Primary ContactRead Only:trueMaximum Length:360The name of the adjustment request primary contact. -
PrimaryContactPartyNumber: string
Title:
Primary Contact NumberRead Only:trueMaximum Length:30The public unique identifier of the primary contact associated. -
QueueId: integer
(int64)
Title:
Assigned Queue IDThe unique identifier of the queue assigned to the service request. -
QueueName: string
Title:
QueueRead Only:trueMaximum Length:400Indicates the service request queue. -
QueueNumber: string
Title:
Queue NumberRead Only:trueMaximum Length:30The alternative key for the queue identifier. -
RejectedByPartyId: integer
(int64)
Title:
Rejected by Party IDThe unique identifier of the user who rejected the adjustment request. -
RejectedByPartyName: string
Title:
Rejected ByRead Only:trueMaximum Length:360The name of the user who rejected the adjustment request. -
RejectedByPartyNumber: string
Title:
Rejected by Party NumberRead Only:trueMaximum Length:30The public unique identifier of the user who rejected the adjustment request. -
RejectReason: string
Title:
Rejection ReasonMaximum Length:255The reason for rejecting the adjustment. -
ReportedByPartyName: string
Title:
Reported ByRead Only:trueMaximum Length:360The person who reported the adjustment request. -
RequestAmount: number
Title:
Requested AmountThe amount for which adjustment is requested. -
RequestPercent: number
Title:
Requested PercentageThe percentage of amount for which adjustment is requested. -
SrId: integer
(int64)
Title:
Service Request IDThe unique identifier of a service request record. -
SrNumber: string
Title:
Reference NumberMaximum Length:30The service request reference number that is associated with the bill adjustment. -
StatusCode: string
Title:
StatusMaximum Length:30The status of the adjustment request. -
SubmittedByPartyId: integer
(int64)
Title:
Submitted by Party IDThe unique ID of the user who submitted the adjustment request. -
SubmittedByPartyName: string
Title:
Submitted ByRead Only:trueMaximum Length:360The user who submitted the adjustment request. -
SubmittedByPartyNumber: string
Title:
Submitted by Party IDRead Only:trueMaximum Length:30The public unique identifier of the user who submitted the adjustment request. -
TaxTreatment: string
Title:
Tax TreatmentMaximum Length:30Indicates whether the tax is included in the bill adjustment. -
Title: string
Title:
TitleRead Only:trueMaximum Length:400The title of a service request. -
UpdateFlag: boolean
Title:
Update IndicatorRead Only:trueIndicates whether the user can update the record. -
ValidFrom: string
(date)
Title:
Valid FromThe date when the validity for non-currency adjustment starts. -
ValidTo: string
(date)
Title:
Valid ToThe date when the validity for non-currency adjustment ends.
Nested Schema : Billing Adjustment Events
Type:
arrayTitle:
Billing Adjustment EventsThe billing adjustment event resource is used to view, create, update, and delete a billing adjustment events.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : billingAdjustments-billingAdjustmentEvents-item-response
Type:
Show Source
object-
BillAdjustmentRequestEventsId: integer
(int64)
Title:
Adjustment Event IDRead Only:trueThe unique identifier of the adjustment event. -
BillAdjustmentRequestEventsNumber: string
Title:
Adjustment Event NumberMaximum Length:30The event number of the adjustment. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The user who created the row. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date and time of the row creation. -
DeleteFlag: boolean
Title:
Delete IndicatorRead Only:trueIndicates whether the user can delete the record. -
ExternalBillEventId: string
Title:
External Bill Event IDMaximum Length:300The unique identifier of the external bill event. -
ExternalBillEventNumber: string
Title:
External Bill Event NumberMaximum Length:300The public unique identifier of the external bill event. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date and time of the last update made to the row. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64The user who last updated the row. -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32The session login associated to the user who last updated the row. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
UpdateFlag: boolean
Title:
Update IndicatorRead Only:trueIndicates whether the user can update the record.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.