Get all application payment details records
get
/fscmRestApi/resources/11.13.18.05/publicSectorPaymentsByTransactions
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 the application payment details data that matches the specified record key.
Finder Variables:- LnpRecordKey; integer; The unique identifier for the record key.
- PaymentReferenceId; string; Finds the application payment details data that meets the payment by transaction criteria.
- PrimaryKey: Finds the application payment details data that matches the specified record 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:- AboutToExpireDate; string; The date when the notification about an expiring license or permit is sent.
- Address1; string; The first line of the applicant address.
- Address2; string; The second line of the applicant address.
- AgencyId; integer; The identifier for a public sector agency. This is usually an alphanumeric identifier for a city, county, or state, but it can also be the name of a city, county, or state.
- AppAcceptDate; string; Identifies the accepted date for the application.
- Applicant; integer; The party ID of the applicant.
- ApplicantPhoneNumber; string; The phone number of the applicant.
- ApplicantUserId; string; The user ID of the applicant.
- AssignedSpecialistEmail; string; The email address of the specialist who is assigned to the application.
- AssignedSpecialistName; string; The user name of the specialist who is assigned to the application.
- AssignedSpecialistUserid; string; The user id of the specialist who is assigned to the application.
- AttributeCategory; string; The category of the application type.
- BalanceDue; number; The balance amount due for the application.
- BusAddress1; string; The address portion of the business??? address, indicated first line of address.
- BusAddress2; string; The address portion of the business??? address, indicated first line of address.
- BusBusinessLegalName; string; The legal name of the business entity.
- BusBusinessName; string; The name of the applicant's business. For example, a contractor enters his or her contracting business name.
- BusCity; string; The city portion of the business??? address.
- BusCountry; string; The country portion of the business??? address.
- BusCounty; string; The county portion of the business??? address.
- BusDbaBusinessName; string; The doing business as name for the business.
- BusDescription; string; A field in the business information component of the form designer used to enter a description of the business.
- BusPostalCode; string; The postal code portion of the business??? address.
- BusProvince; string; The province portion of the business??? address.
- BusState; string; The state portion of the business??? address.
- BusStatus; string; The current status of the business entity.
- BusinessEntityId; string; Meaningful identifier for the business entity.
- BusinessEntityKey; integer; The unique identifier for the business entity.
- BusinessLocationId; string; Meaningful identifier for the business location.
- BusinessLocationKey; integer; The unique identifier for the business location.
- City; string; The city in the applicant address.
- Classification; string; The application record classification. The classifications can be permit, business license, professional license, or planning and zoning.
- ClassificationName; string; The meaning of the application record classification.
- Country; string; The country in the applicant address.
- County; string; The county in the applicant address.
- CreatedBy; string; Identifies the user ID of the person who created the application.
- CreationDate; string; Identifies the date on which the application was created.
- Description; string; The description for the application.
- EmailAddress1; string; The first email address of the applicant.
- EmailAddress2; string; The second email address of the applicant.
- ExpirationDate; string; The date the license or permit is no longer valid.
- ExpirationGraceDate; string; Identifies the expiration grace date for the application.
- ExpirationStatus; string; Identifies the expiration status of the application.
- FeeDueUpdateDate; string; The identifier that captures the date when the fee item with due status is added or updated.
- IssueDate; string; The date the application was issued. Used in the application information component of the Permit Designer.
- LicensePeriod; string; The duration in which the business license is valid.
- LnpRecordId; string; The identifier for the application record.
- LnpRecordKey; integer; The unique identifier for the application record.
- LocationAddressOne; string; Address Line 1 as part of the parcel address.
- LocationAddressTwo; string; Address Line 2 as part of the parcel address.
- LocationCity; string; The city that is part of the parcel address.
- LocationCountry; string; The country that is part of the parcel address.
- LocationCounty; string; The county in which the parcel address is located.
- LocationPostalcode; string; The postal code that is part of the parcel address.
- LocationProvince; string; The location information about the province in which the parcel address is located.
- LocationState; string; The state that is part of the parcel address.
- OrganizationName; string; The business organization name of the applicant.
- Originator; string; Identifies the originator of the application.
- PaymentDate; string; Indicates the date for the fee payment.
- PaymentMethodCode; string; Indicates the payment method code for the fee payment.
- PaymentReferenceId; string; The reference ID of the payment details for the application.
- PersonFirstName; string; The applicant first name.
- PersonLastName; string; The applicant last name.
- PersonMiddleName; string; The applicant middle name.
- PersonName; string; The full name of the applicant.
- PersonTitle; string; The title of the contact.
- PostalCode; string; The postal code in the applicant address.
- PrimaryFlag; string; The application's relationship type as primary application.
- PrimaryRecordId; string; The record id of the primary application.
- PrimaryRecordKey; integer; The record key of the primary application.
- Province; string; The province in the applicant address.
- ReceivedDate; string; Identifies the received date for the application.
- RecordTypeCode; string; The unique alphanumeric code or short name for the record type.
- RecordTypeId; string; The identifier for a record type.
- RenewalDate; string; The renewal date for the license or permit.
- State; string; The state in the applicant address.
- Status; string; The status of the application.
- StatusCode; string; The status code of the application.
- SubapplicationFlag; string; The application's relationship type as subapplication.
- Subclassification; string; The subclassification code of the application type.
- SubclassificationName; string; The subclassification meaning of the application type.
- SubmitDate; string; The date the application transaction was submitted.
- SubmittedBy; string; Identifies the user ID of the person who submitted the application.
- SystemStatus; string; Identifies the system status of the application.
- SystemStatusCode; string; Identifies the system status code of the application.
- TotalDue; number; The total fees due for the application.
- TotalFees; number; The total fees for the application.
- TotalHold; number; The total amount on hold status for the application.
- TotalOutstanding; number; Identifies the total outstanding fee amount.
- TotalPaid; number; The total fees paid for the application.
- TotalPayable; number; The total payable amount for the application.
- TotalPaymentsInProcess; number; The total payment amount that is under process for the application.
- TotalPending; number; The total pending amount for the application.
- TotalWaived; number; The total fees waived for the application.
- Url; string; The URL for the application.
- UrlLabel; string; The URL label for the application.
- VersionType; string; The version of the permit. Values are original, amendment, and renewal.
- WfProcessId; number; The unique identifier for a workflow process.
-
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:
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.
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 : publicSectorPaymentsByTransactions
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 : publicSectorPaymentsByTransactions-item-response
Type:
Show Source
object-
AboutToExpireDate: string
(date-time)
Title:
About to Expire DateRead Only:trueThe date when the notification about an expiring license or permit is sent. -
Address1: string
Title:
Applicant Address Line 1Read Only:trueMaximum Length:240The first line of the applicant address. -
Address2: string
Title:
Applicant Address Line 2Read Only:trueMaximum Length:240The second line of the applicant address. -
AgencyId: integer
(int32)
Title:
Agency IDRead Only:trueThe identifier for a public sector agency. This is usually an alphanumeric identifier for a city, county, or state, but it can also be the name of a city, county, or state. -
AppAcceptDate: string
(date-time)
Title:
Acceptance DateRead Only:trueIdentifies the accepted date for the application. -
Applicant: integer
(int64)
Read Only:
trueThe party ID of the applicant. -
ApplicantPhoneNumber: string
Title:
Applicant Phone NumberRead Only:trueMaximum Length:40The phone number of the applicant. -
ApplicantUserId: string
Title:
Applicant User IDRead Only:trueMaximum Length:255The user ID of the applicant. -
AssignedSpecialistEmail: string
Title:
Assigned Specialist EmailRead Only:trueMaximum Length:255The email address of the specialist who is assigned to the application. -
AssignedSpecialistName: string
Title:
Assigned Specialist NameRead Only:trueMaximum Length:240The user name of the specialist who is assigned to the application. -
AssignedSpecialistUserid: string
Title:
Assigned Specialist User IDRead Only:trueMaximum Length:64The user id of the specialist who is assigned to the application. -
AttributeCategory: string
Read Only:
trueMaximum Length:30The category of the application type. -
BalanceDue: number
Title:
Fees Balance DueRead Only:trueThe balance amount due for the application. -
BusAddress1: string
Title:
Business Address 1Read Only:trueMaximum Length:240The address portion of the business??? address, indicated first line of address. -
BusAddress2: string
Title:
Business Address 2Read Only:trueMaximum Length:240The address portion of the business??? address, indicated first line of address. -
BusBusinessLegalName: string
Title:
Business Legal NameRead Only:trueMaximum Length:240The legal name of the business entity. -
BusBusinessName: string
Title:
BusinessRead Only:trueMaximum Length:100The name of the applicant's business. For example, a contractor enters his or her contracting business name. -
BusCity: string
Title:
Business CityRead Only:trueMaximum Length:60The city portion of the business??? address. -
BusCountry: string
Title:
Business CountryRead Only:trueMaximum Length:3The country portion of the business??? address. -
BusCounty: string
Title:
Business CountyRead Only:trueMaximum Length:60The county portion of the business??? address. -
BusDbaBusinessName: string
Title:
Doing Business AsRead Only:trueMaximum Length:100The doing business as name for the business. -
BusDescription: string
Title:
Location Business DescriptionRead Only:trueMaximum Length:200A field in the business information component of the form designer used to enter a description of the business. -
BusinessEntityId: string
Read Only:
trueMaximum Length:50Meaningful identifier for the business entity. -
BusinessEntityKey: integer
(int64)
Read Only:
trueThe unique identifier for the business entity. -
BusinessLocationId: string
Read Only:
trueMaximum Length:50Meaningful identifier for the business location. -
BusinessLocationKey: integer
(int64)
Read Only:
trueThe unique identifier for the business location. -
BusPostalCode: string
Title:
Business Postal CodeRead Only:trueMaximum Length:60The postal code portion of the business??? address. -
BusProvince: string
Title:
Business ProvinceRead Only:trueMaximum Length:60The province portion of the business??? address. -
BusState: string
Title:
Business StateRead Only:trueMaximum Length:60The state portion of the business??? address. -
BusStatus: string
Title:
License StatusRead Only:trueMaximum Length:10The current status of the business entity. -
City: string
Title:
Applicant CityRead Only:trueMaximum Length:60The city in the applicant address. -
Classification: string
Title:
ClassificationRead Only:trueMaximum Length:3The application record classification. The classifications can be permit, business license, professional license, or planning and zoning. -
ClassificationName: string
Read Only:
trueMaximum Length:50The meaning of the application record classification. -
Country: string
Title:
Applicant CountryRead Only:trueMaximum Length:3The country in the applicant address. -
County: string
Title:
Applicant CountyRead Only:trueMaximum Length:60The county in the applicant address. -
CreatedBy: string
Title:
Created by User IDRead Only:trueMaximum Length:64Identifies the user ID of the person who created the application. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueIdentifies the date on which the application was created. -
Description: string
Title:
DescriptionRead Only:trueMaximum Length:1000The description for the application. -
EmailAddress1: string
Title:
Applicant Email 1Read Only:trueMaximum Length:320The first email address of the applicant. -
EmailAddress2: string
Title:
Applicant Email 2Read Only:trueMaximum Length:320The second email address of the applicant. -
ExpirationDate: string
(date-time)
Title:
Expiration DateRead Only:trueThe date the license or permit is no longer valid. -
ExpirationGraceDate: string
(date-time)
Title:
Grace Period DateRead Only:trueIdentifies the expiration grace date for the application. -
ExpirationStatus: string
Title:
Expiration StatusRead Only:trueMaximum Length:15Identifies the expiration status of the application. -
FeeDueUpdateDate: string
(date-time)
Title:
Fees Due Updated DateRead Only:trueThe identifier that captures the date when the fee item with due status is added or updated. -
IssueDate: string
(date-time)
Title:
Issue DateRead Only:trueThe date the application was issued. Used in the application information component of the Permit Designer. -
LicensePeriod: string
Title:
License PeriodRead Only:trueMaximum Length:100The duration in which the business license is valid. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LnpRecordId: string
Title:
Application IDRead Only:trueMaximum Length:50The identifier for the application record. -
LnpRecordKey: integer
Read Only:
trueThe unique identifier for the application record. -
LocationAddressOne: string
Title:
Location Address Line 1Read Only:trueMaximum Length:240Address Line 1 as part of the parcel address. -
LocationAddressTwo: string
Title:
Location Address Line 2Read Only:trueMaximum Length:240Address Line 2 as part of the parcel address. -
LocationCity: string
Title:
Location CityRead Only:trueMaximum Length:60The city that is part of the parcel address. -
LocationCountry: string
Title:
Location CountryRead Only:trueMaximum Length:3The country that is part of the parcel address. -
LocationCounty: string
Title:
Location CountyRead Only:trueMaximum Length:60The county in which the parcel address is located. -
LocationPostalcode: string
Title:
Location Postal CodeRead Only:trueMaximum Length:60The postal code that is part of the parcel address. -
LocationProvince: string
Title:
Location ProvinceRead Only:trueMaximum Length:60The location information about the province in which the parcel address is located. -
LocationState: string
Title:
Location StateRead Only:trueMaximum Length:60The state that is part of the parcel address. -
OrganizationName: string
Title:
Applicant Business NameRead Only:trueMaximum Length:360The business organization name of the applicant. -
Originator: string
Title:
OriginatorRead Only:trueMaximum Length:3Identifies the originator of the application. -
PaymentDate: string
(date-time)
Title:
Payment DateRead Only:trueIndicates the date for the fee payment. -
PaymentMethodCode: string
Title:
Payment MethodRead Only:trueMaximum Length:30Indicates the payment method code for the fee payment. -
PaymentReferenceId: string
Title:
Payment ReferenceRead Only:trueMaximum Length:50The reference ID of the payment details for the application. -
PersonFirstName: string
Title:
Applicant First NameRead Only:trueMaximum Length:150The applicant first name. -
PersonLastName: string
Title:
Applicant Last NameRead Only:trueMaximum Length:150The applicant last name. -
PersonMiddleName: string
Title:
Applicant Middle NameRead Only:trueMaximum Length:60The applicant middle name. -
PersonName: string
Title:
Applicant Full NameRead Only:trueMaximum Length:450The full name of the applicant. -
PersonTitle: string
Title:
Applicant TitleRead Only:trueMaximum Length:60The title of the contact. -
PostalCode: string
Title:
Applicant Postal CodeRead Only:trueMaximum Length:60The postal code in the applicant address. -
PrimaryFlag: string
Read Only:
trueMaximum Length:1The application's relationship type as primary application. -
PrimaryRecordId: string
Read Only:
trueMaximum Length:50The record id of the primary application. -
PrimaryRecordKey: integer
(int64)
Read Only:
trueThe record key of the primary application. -
Province: string
Title:
Applicant ProvinceRead Only:trueMaximum Length:60The province in the applicant address. -
ReceivedDate: string
(date-time)
Title:
Received DateRead Only:trueIdentifies the received date for the application. -
RecordTypeCode: string
Title:
Application TypeRead Only:trueMaximum Length:20The unique alphanumeric code or short name for the record type. -
RecordTypeId: string
Read Only:
trueMaximum Length:30The identifier for a record type. -
RenewalDate: string
(date-time)
Title:
Renewal DateRead Only:trueThe renewal date for the license or permit. -
State: string
Title:
Applicant StateRead Only:trueMaximum Length:60The state in the applicant address. -
Status: string
Title:
Application StatusRead Only:trueMaximum Length:15The status of the application. -
StatusCode: string
Title:
Application Status CodeRead Only:trueMaximum Length:15The status code of the application. -
SubapplicationFlag: string
Read Only:
trueMaximum Length:1The application's relationship type as subapplication. -
Subclassification: string
Title:
SubclassificationRead Only:trueMaximum Length:10The subclassification code of the application type. -
SubclassificationName: string
Read Only:
trueMaximum Length:50The subclassification meaning of the application type. -
SubmitDate: string
(date-time)
Title:
Submission DateRead Only:trueThe date the application transaction was submitted. -
SubmittedBy: string
Title:
Submitted by User IDRead Only:trueMaximum Length:64Identifies the user ID of the person who submitted the application. -
SystemStatus: string
Title:
Application System StatusRead Only:trueMaximum Length:15Identifies the system status of the application. -
SystemStatusCode: string
Title:
Application System Status CodeRead Only:trueMaximum Length:15Identifies the system status code of the application. -
TotalDue: number
Read Only:
trueThe total fees due for the application. -
TotalFees: number
Title:
Fees Total AmountRead Only:trueThe total fees for the application. -
TotalHold: number
Title:
Fees on HoldRead Only:trueThe total amount on hold status for the application. -
TotalOutstanding: number
Title:
Fees Outstanding BalanceRead Only:trueIdentifies the total outstanding fee amount. -
TotalPaid: number
Title:
Fees Total PaidRead Only:trueThe total fees paid for the application. -
TotalPayable: number
Title:
Fees Total PayableRead Only:trueThe total payable amount for the application. -
TotalPaymentsInProcess: number
Read Only:
trueThe total payment amount that is under process for the application. -
TotalPending: number
Title:
Fees in Pending StatusRead Only:trueThe total pending amount for the application. -
TotalWaived: number
Title:
Fees WaivedRead Only:trueThe total fees waived for the application. -
Url: string
Title:
URLRead Only:trueMaximum Length:255The URL for the application. -
UrlLabel: string
Title:
Link to Business License ActivityRead Only:trueMaximum Length:255The URL label for the application. -
VersionType: string
Title:
Version TypeRead Only:trueMaximum Length:1The version of the permit. Values are original, amendment, and renewal. -
WfProcessId: number
Read Only:
trueThe unique identifier for a workflow process.
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.