Get all loyalty transactions (Deprecated)
get
/crmRestApi/resources/11.13.18.05/loyaltyTransactions
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: Find transaction with specified transaction identifier
Finder Variables:- LoyTransactionId; integer; The loyalty transaction identifier
- TransactionNumberFinder: Finds a loyalty transaction vocuher with a specified transaction number finder.
Finder Variables:- TransactionNumber; string; The transaction number identifier.
- PrimaryKey: Find transaction with specified transaction identifier
-
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:- AccItmList; string; The list of accrual items resulting in a transaction after processing an accrual transaction. There is no default value, dependency, or limitation associated with this attribute.
- ActivityDate; string; The date when a transaction activity occurs. The transaction can be either an accrual or redemption transaction. There is no default value, dependency, or limitation associated with this attribute.
- ActivityDay; number; The transaction activity day. This attribute represents the day when an activity, either accrual or redemption, occurs. There is no default value, dependency, or limitation associated with this attribute.
- ActivityHour; number; The transaction activity hour. This attribute represents the time in hours when an activity, either accrual or redemption, occurs. There is no default value, dependency, or limitation associated with this attribute.
- AdjustedListPrice; number; The currency that displays the redemption price that is used during redemption. There is no default value, dependency, or limitation associated with this attribute.
- AmountValue; number; The total amount spent on the accrual or redemption transaction. There is no default value, dependency, or limitation associated with this attribute.
- ApproveDt; string; The transaction approval date. If the transactions involve an approval process, then the identifier indicates the date when transaction is approved by the reviewer. There is no default value, dependency, or limitation associated with this attribute.
- BUId; integer; The transaction business unit identifier. Oracle Loyalty Cloud generates this attribute value when it creates the transaction record. There is no default value, dependency, or limitation associated with this attribute.
- BidTransaction; string; The transaction bid. This attribute is populated with a value if the created transaction is a bid transaction. A bid transaction occurs mainly through a third party UI, for example, Web Services. There is no default value, dependency, or limitation associated with this attribute.
- BookClassMeaning; string; The booking class name. This attribute specifies the class of the airline ticket. The accepted values are Economy, Business Class, or First Class. There is no default value, dependency, or limitation associated with this attribute.
- BookingDt; string; The transaction booking date. If the transaction is an airline transaction, then this attribute indicates the date when the booking is made for travel. There is no default value, dependency, or limitation associated with this attribute.
- BulkReferenceId; integer; The bulk reference number associated with the transaction when the transaction is created as the result of a bulk transaction creation. There is no default value, dependency, or limitation associated with this attribute.
- CancReasonCode; string; The cancellation reason code. This attribute value represents the reason why the transaction is canceled. There is no default value, dependency, or limitation associated with this attribute.
- CancelledTransactionId; integer; The canceled transaction identifier. This attribute is the primary key of the transaction that is canceled. There is no default value, dependency, or limitation associated with this attribute.
- ChannelMeaning; string; The transaction channel name. This attribute indicates the means by which the transaction occurs. The accepted values are Web, Mobile, or Phone. There is no default value, dependency, or limitation associated with this attribute.
- Comments; string; The transaction comments. This attribute stores the comments entered by user, if any, for future reference. There is no default value, dependency, or limitation associated with this attribute.
- CorporateReferenceNumber; string; The reference to a third-party corporate member from the program to get the points split for the individual and the corporation or company, if an individual member completes a transaction on behalf of the corporation or company. There is no default value, dependency, or limitation associated with this attribute.
- CreatedBy; string; The details of who creates the transaction. Oracle Loyalty Cloud generates this attribute value during the creation of new transaction. There is no default value, dependency, or limitation associated with this attribute.
- CreationDate; string; The date when the transaction is created. Oracle Loyalty Cloud generates this attribute value during the creation of a new transaction. There is no default value, dependency, or limitation associated with this attribute.
- CurcyCode; string; The transaction currency code. This attribute indicates the currency used in the transaction. The accepted values are INR, USD, and GBP. There is no default value or dependency associated with this attribute.
- CurcyExchDt; string; The date when the currency exchange occurs during the transaction creation. There is no default value, dependency, or limitation associated with this attribute.
- DestCityCode; string; The destination city code. The attribute value represents the city where the flight arrives when it reaches its destination. There is no default value, dependency, or limitation associated with this attribute.
- DestinationAirportMeaning; string; The destination airport name. The attribute value is the name of the airport where the flight arrives when it reaches its destination. There is no default value, dependency, or limitation associated with this attribute.
- DestinationZoneMeaning; string; The destination zone name. This attribute value is the name of the zone where the flight arrives when it reaches its destination. The accepted values are Asia, Europe, or North America. There is no default value, dependency, or limitation associated with this attribute.
- DocumentNumber; string; The document number associated with the transaction. This attribute provides additional information in the transaction for the retail industry. There is no default value, dependency, or limitation associated with this attribute.
- EndDt; string; The transaction end date. This attribute is the date when the transaction is no longer in effect. This attribute value, if provided, must be set to a value after the StartDt attribute. There is no default value or dependency associated with this attribute.
- EnrolPromoId; integer; The enrolled promotion identifier. This attribute provides the promotion identifier of the enrolled promotion. There is no default value, dependency, or limitation associated with this attribute.
- ExpireInDays; number; The date when the accrued points will expire, in days. There is no default value, dependency, or limitation associated with this attribute.
- ExternalProductName; string; The product name reference in the external system. There is no default value, dependency, or limitation associated with this attribute.
- ExternalReservationNumber; string; The external reservation number is specific to the airline industry where a reservation is performed by an agent and has different reservation numbers. There is no default value, dependency, or limitation associated with this attribute.
- ExternalTransaction; string; The details of the transaction coming from a partner???s external application into loyalty when loyalty is integrated with a third-party application. There is no default value, dependency, or limitation associated with this attribute.
- FareBasisCode; string; The transaction fare basis. This attribute is a code which represents the fare basis on which the ticket fare is based. The accepted values are ORA_FARE_BASIS_BUSI or ORA_FARE_BASIS_ECO. There is no default value, dependency, or limitation associated with this attribute.
- FareBasisMeaning; string; The fare basis name. This attribute is the basis for the ticket fare. The accepted values are Business or Economy. There is no default value, dependency, or limitation associated with this attribute.
- FareTypeMeaning; string; The fare type name. This attribute value determines the ticket fare. The accepted values are Business Class or First Class. There is no default value, dependency, or limitation associated with this attribute.
- FlightNumber; string; The transaction flight number. If the transaction pertains to airlines, then this attribute indicates the flight number of the flight where the travel takes place. This attribute is input by the user during transaction creation. There is no default value, dependency, or limitation associated with this attribute.
- FltTypeCode; string; The attribute specifies the flight type, for example, Boeing or Airbus. There is no default value, dependency, or limitation associated with this attribute.
- GdsRecLocator; string; The global distribution system (GDS) record locator. There is no default value, dependency, or limitation associated with this attribute.
- IncentivChoice; string; The incentives or rewards that a member receives for enrolling into a promotion. There is no default value, dependency, or limitation associated with this attribute.
- InternalDest; string; The details of the destination that is used internally by Oracle Loyalty Cloud. There is no default value, dependency, or limitation associated with this attribute.
- InternalFlightDt; string; The local date for the flight for the country. For example, 24/01/2018 is equal to GMT +5.30 in India. There is no default value, dependency, or limitation associated with this attribute.
- InternalOrigin; string; The flight origin details that are local to the region. There is no default value, dependency, or limitation associated with this attribute.
- InvOrgId; integer; The organization from where inventory is being picked. For example, when a transaction is created, sometimes the inventory or goods are picked from the partner and directly delivered to the customer. That is, the transaction is created for one organization, but the inventory is being picked from a different organization. There is no default value, dependency, or limitation associated with this attribute.
- ItemNumber; string; The transaction item number that is used during transaction creation. There is no default value, dependency, or limitation associated with this attribute.
- LastUpdateDate; string; The date when the transaction is last updated. Oracle Loyalty Cloud generates this attribute value and updates it whenever there are any changes to the transaction. There is no default value, dependency, or limitation associated with this attribute.
- LastUpdateLogin; string; The login details of the user who last logged in. Oracle Loyalty Cloud generates this attribute value, and updates it whenever any changes to the transaction take place. There is no default value, dependency, or limitation associated with this attribute.
- LastUpdatedBy; string; The user who last updated the transaction. Oracle Loyalty Cloud generates this attribute value, and updates it whenever any changes to the transaction take place. There is no default value, dependency, or limitation associated with this attribute.
- LineItemNumber; integer; The line item number for a multiple line item order transaction. There is no default value, dependency, or limitation associated with this attribute.
- LoanBalance; number; The remaining balance of the loan that you can use during transaction creation. There is no default value, dependency, or limitation associated with this attribute.
- LoanRepaymentDt; string; The date which specifies when the loan is repaid. There is no default value, dependency, or limitation associated with this attribute.
- LocationCode; integer; The transaction location code which is used for giving promotions only for specific locations. For example, for the same retailer, the promotion can be applied only if the store is located in India. If the store is located outside India, then no promotions are applied. There is no default value, dependency, or limitation associated with this attribute.
- LocationName; string; The attribute is text that used in the retail industry for giving promotions. For example, for the same retailer, the promotion could be applied only if the store is located in India. If the store is located outside India no promotions are applied. There is no default value, dependency, or limitation associated with this attribute.
- LoyTransactionId; integer; The primary key to identify a transaction. Oracle Loyalty Cloud generates this attribute value during the creation of a transaction record. There is no default value, dependency, or limitation associated with this attribute.
- MarketingFlightNumber; string; The marketing flight number, which is specific to the airline industry and which indicates the flight number used in the airline's marketing campaign. There is no default value, dependency, or limitation associated with this attribute.
- ObjectVersionNumber; integer; The object version number. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute.
- OperFltNumber; string; The operating flight number used in airline transactions. There is no default value, dependency, or limitation associated with this attribute.
- OptyCost; number; The transaction opportunity cost associated with the transaction. There is no default value, dependency, or limitation associated with this attribute.
- OrderNumber; string; The number associated with an order. This attribute is used by Oracle Loyalty Cloud when consolidating transactions. There is no default value, dependency, or limitation associated with this attribute.
- OrderQuantity; number; The transaction order quantity. This attribute indicates the number of points for which the order is placed. There is no default value, dependency, or limitation associated with this attribute.
- OrigAmount; number; The total transaction amount without any discount applied in the transaction. There is no default value, dependency, or limitation associated with this attribute.
- OrigOrdItmId; integer; The details of the order item that is originally placed, especially used for exchanges, and so on in retail transactions. There is no default value, dependency, or limitation associated with this attribute.
- OrigPoints; number; The original value of the transaction in points without any subsequent bonus added by each promotion. There is no default value, dependency, or limitation associated with this attribute.
- OriginAirportMeaning; string; The name of the airport where the flight arrives on reaching its destination. There is no default value, dependency, or limitation associated with this attribute.
- OriginCityCode; string; The origin city code. This attribute value represents the city from where the flight departs. There is no default value, dependency, or limitation associated with this attribute.
- OriginZoneMeaning; string; The name of the zone from where the flight departs. There is no default value, dependency, or limitation associated with this attribute.
- OvrDupCheck; string; The flag that indicates whether duplicate line items are allowed in a transaction or not. There is no default value, dependency, or limitation associated with this attribute.
- PackageCode; string; The transaction package code. This attribute identifies the package from which line items are picked. There is no default value, dependency, or limitation associated with this attribute.
- ParentTransactionId; integer; The transaction identifier for the parent transaction that creates the current transaction. There is no default value, dependency, or limitation associated with this attribute.
- PartitionName; string; The transaction partition name. There is no default value, dependency, or limitation associated with this attribute.
- PaymentTypeMeaning; string; The payment type name that corresponds to the payment type code. There is no default value, dependency, or limitation associated with this attribute.
- PeriodDurCode; string; The period duration code which specifies the duration in days, or months, and so on. There is no default value, dependency, or limitation associated with this attribute.
- PeriodTypeCode; string; The period type code. Period type options are Months, Years, Lifetime, and so on. There is no default value, dependency, or limitation associated with this attribute.
- PnrName; string; The transaction passenger name record (PNR) name. There is no default value, dependency, or limitation associated with this attribute.
- PnrNumber; string; The transaction passenger name record (PNR) number. There is no default value, dependency, or limitation associated with this attribute.
- Points; number; The transaction points. This attribute corresponds to the price of the transaction in points. There is no default value, dependency, or limitation associated with this attribute.
- PostDt; string; The date when the transaction is posted. There is no default value, dependency, or limitation associated with this attribute.
- PriceOverriden; string; The flag that indicates whether the price need to be overridden or not. There is no default value, dependency, or limitation associated with this attribute.
- ProcFlowId; integer; The promotion process flow identifier used for promotion flow setup. There is no default value, dependency, or limitation associated with this attribute.
- ProcessDt; string; The transaction process date. This attribute specifies the day on which the created transaction is processed. There is no default value, dependency, or limitation associated with this attribute.
- ProcessingComment; string; The transaction processing comment that provides the details of an error, if any occurred, during transaction processing. There is no default value, dependency, or limitation associated with this attribute.
- ProcessingLog; string; The transaction processing log that provides details of all the promotions that are applied, all the points that are assigned, and all the vouchers that are assigned, if any. There is no default value, dependency, or limitation associated with this attribute.
- PtnrProcDt; string; The date on which the transaction is processed at the partner end. There is no default value, dependency, or limitation associated with this attribute.
- PtnrStatusCode; string; The status code used by the partner on processing the transaction. There is no default value, dependency, or limitation associated with this attribute.
- PymtTypeCode; string; The payment type code specifies how the payment is made for the transaction. There is no default value, dependency, or limitation associated with this attribute.
- QualifyingPointUsed; string; The qualifying point used. These points count toward a member???s tier status. There is no default value, dependency, or limitation associated with this attribute.
- ReasonCode; string; The reason for the cancellation or refund, if the transaction is cancelled. For example, a fee that is inadvertently applied. There is no default value, dependency, or limitation associated with this attribute.
- RedemptionQuantity; number; The product quantity that is redeemed in a redemption transaction. There is no default value, dependency, or limitation associated with this attribute.
- RedemptionQuantityUOMCode; string; The redemption products quantity unit of measure (UOM) code. For example, possible UOM codes are kilograms or litres. There is no default value, dependency, or limitation associated with this attribute.
- RefundBasisCode; string; The basis for the refund, in the event of cancellation of transaction. The refund options are Prorated, Percentage, or No Refunds. There is no default value, dependency, or limitation associated with this attribute.
- RefundPct; number; The percentage of the refund that is granted in the transaction. There is no default value, dependency, or limitation associated with this attribute.
- RfndOvrdCmnts; string; The refund override comments in the event a refund is made. There is no default value, dependency, or limitation associated with this attribute.
- RfndOvrdRsnCode; string; The refund override reason code in the event a refund is made. There is no default value, dependency, or limitation associated with this attribute.
- SocialActionMeaning; string; The social media action name. The accepted values are Check-in, Rate, Share. There is no default value, dependency, or limitation associated with this attribute.
- SourceMeaning; string; The name corresponding to the source code. The accepted values are Web, Mobile, or Billing. There is no default value, dependency, or limitation associated with this attribute.
- StartDt; string; The transaction start date. Either Oracle Loyalty Cloud generates this attribute value when a new transaction is created and populates the attribute with the current date, or it is provided as input from the user when creating transaction using the resource. There is no default value, dependency, or limitation associated with this attribute.
- StatusCode; string; The transaction status code values returned from look type ORA_LOY_TXN_STATUS. The default value is ORA_TXN_STAT_IN_PROG.
- SubmitDt; string; The transaction submission date. Oracle Loyalty Cloud assigns this attribute value when the transaction is submitted for approval by changing the Transaction Status attribute value to Submitted. There is no default value, dependency, or limitation associated with this attribute.
- SubmitToId; integer; The submit to identifier contains the details of the partner reviewer that approves the transaction. This attribute is input by the user. There is no default value, dependency, or limitation associated with this attribute.
- TaxAmount; number; The amount of tax that must be paid for the completed transaction. There is no default value, dependency, or limitation associated with this attribute.
- TicketNumber; string; The unique number that is used to identify the ticket booking for an airline transaction. There is no default value, dependency, or limitation associated with this attribute.
- ToMemberNumber; string; The unique identification number of the member to whom points are transferred. There is no default value, dependency, or limitation associated with this attribute.
- TotalDays; integer; The total days that are required for travel between the source and destination locations. There is no default value, dependency, or limitation associated with this attribute.
- TotalLines; number; The total line items for the transaction. A transaction can include many order line items. There is no default value, dependency, or limitation associated with this attribute.
- TransactionDate; string; The date when the transaction is completed. There is no default value, dependency, or limitation associated with this attribute.
- TransactionNumber; string; The transaction number. This is an alternate key that is mandatory during an update. This attribute is automatically generated by Oracle Loyalty Cloud. There is no default value, dependency, or limitation associated with this attribute.
- TransactionSourceCode; string; The transaction source code attribute indicates the transaction activity type like Airlines, Hotels, Car Rental, and so on. There is no default value, dependency, or limitation associated with this attribute.
- TransactionStatusMeaning; string; The name of the transaction status code. The accepted values are In Progress, Processed, or Rejected. There is no default value, dependency, or limitation associated with this attribute.
- TransactionSubStatusMeaning; string; The name of the transaction substatus code. The accepted values are Success, No Promotions Qualified, Insufficient Member Balance, Insufficient Point Blocks. There is no default value, dependency, or limitation associated with this attribute.
- TransferMemId; integer; The unique identification number of the member from whom points are transferred. There is no default value, dependency, or limitation associated with this attribute.
- TransferTransactionId; integer; The unique identification number of the transaction that is during transfer points. There is no default value, dependency, or limitation associated with this attribute.
- TravelClassMeaning; string; The travel class name that indicates the class of travel. The accepted values are Business, Economy. There is no default value, dependency, or limitation associated with this attribute.
- TrvlDistance; number; The transaction travel distance. This attribute stores the total miles travelled. There is no default value, dependency, or limitation associated with this attribute.
- UnaccMinor; string; The unaccounted transaction for a minor, that is below the age of majority. There is no default value, dependency, or limitation associated with this attribute.
- ValStatusCode; string; The status of the validation performed on the record. There is no default value, dependency, or limitation associated with this attribute.
- VoucherQuantity; number; The quantity of vouchers that are assigned because of the given transaction after processing. There is no default value, dependency, or limitation associated with this attribute.
-
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 : loyaltyTransactions
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 : loyaltyTransactions-item-response
Type:
Show Source
object-
AccItmList: string
Read Only:
trueMaximum Length:255The list of accrual items resulting in a transaction after processing an accrual transaction. There is no default value, dependency, or limitation associated with this attribute. -
AccrualItems: array
(Deprecated) Accrual Items
Title:
(Deprecated) Accrual ItemsThe accrual items resource is used to retrieve the accrual items that have been updated on transaction processing. -
ActivityDate: string
(date-time)
Title:
Activity DateThe date when a transaction activity occurs. The transaction can be either an accrual or redemption transaction. There is no default value, dependency, or limitation associated with this attribute. -
ActivityDay: number
Title:
Activity DayThe transaction activity day. This attribute represents the day when an activity, either accrual or redemption, occurs. There is no default value, dependency, or limitation associated with this attribute. -
ActivityHour: number
Title:
Activity HourThe transaction activity hour. This attribute represents the time in hours when an activity, either accrual or redemption, occurs. There is no default value, dependency, or limitation associated with this attribute. -
AdjustedListPrice: number
Title:
Adjusted List PriceThe currency that displays the redemption price that is used during redemption. There is no default value, dependency, or limitation associated with this attribute. -
AmountValue: number
Title:
AmountThe total amount spent on the accrual or redemption transaction. There is no default value, dependency, or limitation associated with this attribute. -
ApproveDt: string
(date-time)
Title:
Approve DateThe transaction approval date. If the transactions involve an approval process, then the identifier indicates the date when transaction is approved by the reviewer. There is no default value, dependency, or limitation associated with this attribute. -
BidTransaction: string
Title:
BidMaximum Length:1The transaction bid. This attribute is populated with a value if the created transaction is a bid transaction. A bid transaction occurs mainly through a third party UI, for example, Web Services. There is no default value, dependency, or limitation associated with this attribute. -
BookClassMeaning: string
The booking class name. This attribute specifies the class of the airline ticket. The accepted values are Economy, Business Class, or First Class. There is no default value, dependency, or limitation associated with this attribute.
-
BookingDt: string
(date-time)
Title:
Booking DateThe transaction booking date. If the transaction is an airline transaction, then this attribute indicates the date when the booking is made for travel. There is no default value, dependency, or limitation associated with this attribute. -
BUId: integer
(int64)
Title:
BidThe transaction business unit identifier. Oracle Loyalty Cloud generates this attribute value when it creates the transaction record. There is no default value, dependency, or limitation associated with this attribute. -
BulkReferenceId: integer
(int64)
Title:
Reference Member Bulk ActionsThe bulk reference number associated with the transaction when the transaction is created as the result of a bulk transaction creation. There is no default value, dependency, or limitation associated with this attribute. -
CancelledTransactionId: integer
(int64)
Title:
Canceled Transaction IDThe canceled transaction identifier. This attribute is the primary key of the transaction that is canceled. There is no default value, dependency, or limitation associated with this attribute. -
CancReasonCode: string
Title:
Cancellation Reason CodeMaximum Length:30The cancellation reason code. This attribute value represents the reason why the transaction is canceled. There is no default value, dependency, or limitation associated with this attribute. -
ChannelMeaning: string
The transaction channel name. This attribute indicates the means by which the transaction occurs. The accepted values are Web, Mobile, or Phone. There is no default value, dependency, or limitation associated with this attribute.
-
Comments: string
Title:
CommentsMaximum Length:250The transaction comments. This attribute stores the comments entered by user, if any, for future reference. There is no default value, dependency, or limitation associated with this attribute. -
CorporateReferenceNumber: string
Title:
Corporate Reference NumberMaximum Length:30The reference to a third-party corporate member from the program to get the points split for the individual and the corporation or company, if an individual member completes a transaction on behalf of the corporation or company. There is no default value, dependency, or limitation associated with this attribute. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The details of who creates the transaction. Oracle Loyalty Cloud generates this attribute value during the creation of new transaction. There is no default value, dependency, or limitation associated with this attribute. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the transaction is created. Oracle Loyalty Cloud generates this attribute value during the creation of a new transaction. There is no default value, dependency, or limitation associated with this attribute. -
CurcyCode: string
Title:
Currency CodeMaximum Length:20The transaction currency code. This attribute indicates the currency used in the transaction. The accepted values are INR, USD, and GBP. There is no default value or dependency associated with this attribute. -
CurcyExchDt: string
(date-time)
Title:
Currency Exchange DateThe date when the currency exchange occurs during the transaction creation. There is no default value, dependency, or limitation associated with this attribute. -
DestCityCode: string
Title:
Destination CityMaximum Length:30The destination city code. The attribute value represents the city where the flight arrives when it reaches its destination. There is no default value, dependency, or limitation associated with this attribute. -
DestinationAirportMeaning: string
The destination airport name. The attribute value is the name of the airport where the flight arrives when it reaches its destination. There is no default value, dependency, or limitation associated with this attribute.
-
DestinationZoneMeaning: string
The destination zone name. This attribute value is the name of the zone where the flight arrives when it reaches its destination. The accepted values are Asia, Europe, or North America. There is no default value, dependency, or limitation associated with this attribute.
-
DocumentNumber: string
Title:
Document NumberMaximum Length:30The document number associated with the transaction. This attribute provides additional information in the transaction for the retail industry. There is no default value, dependency, or limitation associated with this attribute. -
EndDt: string
(date-time)
Title:
End DateThe transaction end date. This attribute is the date when the transaction is no longer in effect. This attribute value, if provided, must be set to a value after the StartDt attribute. There is no default value or dependency associated with this attribute. -
EnrolPromoId: integer
(int64)
Title:
Enrolled Promotion IDThe enrolled promotion identifier. This attribute provides the promotion identifier of the enrolled promotion. There is no default value, dependency, or limitation associated with this attribute. -
ExpireInDays: number
Title:
Expires in DaysThe date when the accrued points will expire, in days. There is no default value, dependency, or limitation associated with this attribute. -
ExternalProductName: string
Title:
External Product NameMaximum Length:240The product name reference in the external system. There is no default value, dependency, or limitation associated with this attribute. -
ExternalReservationNumber: string
Title:
External Reservation NumberMaximum Length:250The external reservation number is specific to the airline industry where a reservation is performed by an agent and has different reservation numbers. There is no default value, dependency, or limitation associated with this attribute. -
ExternalTransaction: string
Title:
ExternalMaximum Length:1Default Value:NThe details of the transaction coming from a partner???s external application into loyalty when loyalty is integrated with a third-party application. There is no default value, dependency, or limitation associated with this attribute. -
ExternProdLineMeaning: string
The product line associated with the product for the transaction that is from an external source. There is no default value, dependency, or limitation associated with this attribute.
-
ExternProdTypeMeaning: string
The type of products coming into the Oracle Loyalty Cloud system from an external source. There is no default value, dependency, or limitation associated with this attribute.
-
FareBasisCode: string
Title:
Fare Basis CodeMaximum Length:30The transaction fare basis. This attribute is a code which represents the fare basis on which the ticket fare is based. The accepted values are ORA_FARE_BASIS_BUSI or ORA_FARE_BASIS_ECO. There is no default value, dependency, or limitation associated with this attribute. -
FareBasisMeaning: string
The fare basis name. This attribute is the basis for the ticket fare. The accepted values are Business or Economy. There is no default value, dependency, or limitation associated with this attribute.
-
FareTypeMeaning: string
The fare type name. This attribute value determines the ticket fare. The accepted values are Business Class or First Class. There is no default value, dependency, or limitation associated with this attribute.
-
FlightNumber: string
Title:
Flight NumberMaximum Length:30The transaction flight number. If the transaction pertains to airlines, then this attribute indicates the flight number of the flight where the travel takes place. This attribute is input by the user during transaction creation. There is no default value, dependency, or limitation associated with this attribute. -
FltTypeCode: string
Title:
Flight Type CodeMaximum Length:30The attribute specifies the flight type, for example, Boeing or Airbus. There is no default value, dependency, or limitation associated with this attribute. -
GdsRecLocator: string
Title:
GDS Record LocatorMaximum Length:30The global distribution system (GDS) record locator. There is no default value, dependency, or limitation associated with this attribute. -
IncentivChoice: string
Title:
Incentive ChoiceMaximum Length:30The incentives or rewards that a member receives for enrolling into a promotion. There is no default value, dependency, or limitation associated with this attribute. -
InternalDest: string
Title:
Internal DestinationMaximum Length:15The details of the destination that is used internally by Oracle Loyalty Cloud. There is no default value, dependency, or limitation associated with this attribute. -
InternalFlightDt: string
(date-time)
Title:
Internal Flight DateThe local date for the flight for the country. For example, 24/01/2018 is equal to GMT +5.30 in India. There is no default value, dependency, or limitation associated with this attribute. -
InternalOrigin: string
Title:
Internal OriginMaximum Length:15The flight origin details that are local to the region. There is no default value, dependency, or limitation associated with this attribute. -
InvOrgId: integer
(int64)
Title:
Inventory Organization IDThe organization from where inventory is being picked. For example, when a transaction is created, sometimes the inventory or goods are picked from the partner and directly delivered to the customer. That is, the transaction is created for one organization, but the inventory is being picked from a different organization. There is no default value, dependency, or limitation associated with this attribute. -
ItemNumber: string
Title:
Item NumberMaximum Length:30The transaction item number that is used during transaction creation. There is no default value, dependency, or limitation associated with this attribute. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date when the transaction is last updated. Oracle Loyalty Cloud generates this attribute value and updates it whenever there are any changes to the transaction. There is no default value, dependency, or limitation associated with this attribute. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64The user who last updated the transaction. Oracle Loyalty Cloud generates this attribute value, and updates it whenever any changes to the transaction take place. There is no default value, dependency, or limitation associated with this attribute. -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32The login details of the user who last logged in. Oracle Loyalty Cloud generates this attribute value, and updates it whenever any changes to the transaction take place. There is no default value, dependency, or limitation associated with this attribute. -
LineItemNumber: integer
(int64)
Title:
Order Line NumberThe line item number for a multiple line item order transaction. There is no default value, dependency, or limitation associated with this attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoanBalance: number
Title:
Loan BalanceThe remaining balance of the loan that you can use during transaction creation. There is no default value, dependency, or limitation associated with this attribute. -
LoanRepaymentDt: string
(date-time)
Title:
Loan Repayment DateThe date which specifies when the loan is repaid. There is no default value, dependency, or limitation associated with this attribute. -
LocationCode: integer
(int64)
Title:
Location IDThe transaction location code which is used for giving promotions only for specific locations. For example, for the same retailer, the promotion can be applied only if the store is located in India. If the store is located outside India, then no promotions are applied. There is no default value, dependency, or limitation associated with this attribute. -
LocationName: string
Title:
Location CodeMaximum Length:30The attribute is text that used in the retail industry for giving promotions. For example, for the same retailer, the promotion could be applied only if the store is located in India. If the store is located outside India no promotions are applied. There is no default value, dependency, or limitation associated with this attribute. -
LoyTransactionId: integer
(int64)
Title:
Loyalty Transaction IDThe primary key to identify a transaction. Oracle Loyalty Cloud generates this attribute value during the creation of a transaction record. There is no default value, dependency, or limitation associated with this attribute. -
MarketingFlightNumber: string
Title:
Marketing Flight NumberMaximum Length:30The marketing flight number, which is specific to the airline industry and which indicates the flight number used in the airline's marketing campaign. There is no default value, dependency, or limitation associated with this attribute. -
MemberNumber: string
Title:
Member NumberThe member for whom the transaction is created. There is no default value, dependency, or limitation associated with this attribute. -
ObjectVersionNumber: integer
(int32)
The object version number. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute.
-
OperFltNumber: string
Title:
Operating Flight NumberMaximum Length:30The operating flight number used in airline transactions. There is no default value, dependency, or limitation associated with this attribute. -
OptyCost: number
Title:
Opportunity CostThe transaction opportunity cost associated with the transaction. There is no default value, dependency, or limitation associated with this attribute. -
OrderNumber: string
Title:
Order NumberMaximum Length:30The number associated with an order. This attribute is used by Oracle Loyalty Cloud when consolidating transactions. There is no default value, dependency, or limitation associated with this attribute. -
OrderQuantity: number
Title:
Order QuantityThe transaction order quantity. This attribute indicates the number of points for which the order is placed. There is no default value, dependency, or limitation associated with this attribute. -
OrigAmount: number
Title:
Original AmountThe total transaction amount without any discount applied in the transaction. There is no default value, dependency, or limitation associated with this attribute. -
OriginAirportMeaning: string
The name of the airport where the flight arrives on reaching its destination. There is no default value, dependency, or limitation associated with this attribute.
-
OriginCityCode: string
Title:
Origin City CodeMaximum Length:30The origin city code. This attribute value represents the city from where the flight departs. There is no default value, dependency, or limitation associated with this attribute. -
OriginZoneMeaning: string
The name of the zone from where the flight departs. There is no default value, dependency, or limitation associated with this attribute.
-
OrigOrdItmId: integer
(int64)
Title:
Original Order Line ItemThe details of the order item that is originally placed, especially used for exchanges, and so on in retail transactions. There is no default value, dependency, or limitation associated with this attribute. -
OrigPoints: number
Title:
Original PointThe original value of the transaction in points without any subsequent bonus added by each promotion. There is no default value, dependency, or limitation associated with this attribute. -
OvrDupCheck: string
Title:
Duplicate Check OverriddenMaximum Length:1Default Value:NThe flag that indicates whether duplicate line items are allowed in a transaction or not. There is no default value, dependency, or limitation associated with this attribute. -
PackageCode: string
Title:
Package CodeMaximum Length:30The transaction package code. This attribute identifies the package from which line items are picked. There is no default value, dependency, or limitation associated with this attribute. -
ParentTransactionId: integer
(int64)
Title:
Partner Transaction IDThe transaction identifier for the parent transaction that creates the current transaction. There is no default value, dependency, or limitation associated with this attribute. -
PartitionName: string
Title:
Partition NameMaximum Length:30The transaction partition name. There is no default value, dependency, or limitation associated with this attribute. -
PartnerNumber: string
Title:
Partner NumberThe partner number attribute is a unique identifier from HZ_PARTIES which gives partner details against whom the transaction is being created. There is no default value, dependency, or limitation associated with this attribute. -
PaymentTypeMeaning: string
The payment type name that corresponds to the payment type code. There is no default value, dependency, or limitation associated with this attribute.
-
PeriodDurCode: string
Title:
Period DurationMaximum Length:30The period duration code which specifies the duration in days, or months, and so on. There is no default value, dependency, or limitation associated with this attribute. -
PeriodTypeCode: string
Title:
Period TypeMaximum Length:30The period type code. Period type options are Months, Years, Lifetime, and so on. There is no default value, dependency, or limitation associated with this attribute. -
PnrName: string
Title:
PNR NameMaximum Length:50The transaction passenger name record (PNR) name. There is no default value, dependency, or limitation associated with this attribute. -
PnrNumber: string
Title:
PNR NumberMaximum Length:50The transaction passenger name record (PNR) number. There is no default value, dependency, or limitation associated with this attribute. -
Points: number
Title:
Number PointsThe transaction points. This attribute corresponds to the price of the transaction in points. There is no default value, dependency, or limitation associated with this attribute. -
PointTypeName: string
Title:
Point Type NameThe point type name. This attribute is dependent on the Program Name Identifier. There is no default value, dependency, or limitation associated with this attribute. -
PostDt: string
(date-time)
Title:
Post DateThe date when the transaction is posted. There is no default value, dependency, or limitation associated with this attribute. -
PriceOverriden: string
Title:
Price OverriddenMaximum Length:1Default Value:NThe flag that indicates whether the price need to be overridden or not. There is no default value, dependency, or limitation associated with this attribute. -
ProcessDt: string
(date-time)
Title:
Process DateThe transaction process date. This attribute specifies the day on which the created transaction is processed. There is no default value, dependency, or limitation associated with this attribute. -
ProcessingComment: string
Title:
Processing CommentMaximum Length:1000The transaction processing comment that provides the details of an error, if any occurred, during transaction processing. There is no default value, dependency, or limitation associated with this attribute. -
ProcessingLog: string
Title:
Processing LogMaximum Length:1000The transaction processing log that provides details of all the promotions that are applied, all the points that are assigned, and all the vouchers that are assigned, if any. There is no default value, dependency, or limitation associated with this attribute. -
ProcFlowId: integer
(int64)
Title:
Process Flow IDThe promotion process flow identifier used for promotion flow setup. There is no default value, dependency, or limitation associated with this attribute. -
ProductNumber: string
Title:
Product NumberThe product that is used in the transaction. There is no default value, dependency, or limitation associated with this attribute. -
ProgramName: string
Title:
Program NameThe transaction program name. This attribute indicates for which the program the transaction is created. There is no default value, dependency, or limitation associated with this attribute. -
Promotions: array
(Deprecated) Loyalty Promotions
Title:
(Deprecated) Loyalty PromotionsThe loyalty promotions resource is used to retrieve the details of a loyalty promotion that is applied to the transaction. -
PtnrProcDt: string
(date-time)
Title:
Partner Processing DateThe date on which the transaction is processed at the partner end. There is no default value, dependency, or limitation associated with this attribute. -
PtnrStatusCode: string
Title:
Partner Status CodeMaximum Length:30The status code used by the partner on processing the transaction. There is no default value, dependency, or limitation associated with this attribute. -
PymtTypeCode: string
Title:
Payment TypeMaximum Length:30The payment type code specifies how the payment is made for the transaction. There is no default value, dependency, or limitation associated with this attribute. -
QualifyingPointUsed: string
Title:
QualifyingMaximum Length:1Default Value:NThe qualifying point used. These points count toward a member???s tier status. There is no default value, dependency, or limitation associated with this attribute. -
ReasonCode: string
Title:
Reason CodeMaximum Length:30The reason for the cancellation or refund, if the transaction is cancelled. For example, a fee that is inadvertently applied. There is no default value, dependency, or limitation associated with this attribute. -
RedemptionItems: array
(Deprecated) Redemption Items
Title:
(Deprecated) Redemption ItemsThe redemption items resource is used to retrieve the redemption items that have been updated on transaction processing. -
RedemptionQuantity: number
Title:
Redemption QuantityThe product quantity that is redeemed in a redemption transaction. There is no default value, dependency, or limitation associated with this attribute. -
RedemptionQuantityUOMCode: string
Title:
Unit of Measure for the Redemption QuantityMaximum Length:30The redemption products quantity unit of measure (UOM) code. For example, possible UOM codes are kilograms or litres. There is no default value, dependency, or limitation associated with this attribute. -
RefundBasisCode: string
Title:
Refund BasisMaximum Length:30The basis for the refund, in the event of cancellation of transaction. The refund options are Prorated, Percentage, or No Refunds. There is no default value, dependency, or limitation associated with this attribute. -
RefundPct: number
Title:
Refund PercentageThe percentage of the refund that is granted in the transaction. There is no default value, dependency, or limitation associated with this attribute. -
RfndOvrdCmnts: string
Title:
Refund Override CommentsMaximum Length:250The refund override comments in the event a refund is made. There is no default value, dependency, or limitation associated with this attribute. -
RfndOvrdRsnCode: string
Title:
Refund Override ReasonMaximum Length:30The refund override reason code in the event a refund is made. There is no default value, dependency, or limitation associated with this attribute. -
SocialActionMeaning: string
The social media action name. The accepted values are Check-in, Rate, Share. There is no default value, dependency, or limitation associated with this attribute.
-
SourceMeaning: string
The name corresponding to the source code. The accepted values are Web, Mobile, or Billing. There is no default value, dependency, or limitation associated with this attribute.
-
StartDt: string
(date-time)
Title:
Start DateThe transaction start date. Either Oracle Loyalty Cloud generates this attribute value when a new transaction is created and populates the attribute with the current date, or it is provided as input from the user when creating transaction using the resource. There is no default value, dependency, or limitation associated with this attribute. -
StatusCode: string
Title:
Status CodeMaximum Length:30Default Value:ORA_TXN_STAT_IN_PROGThe transaction status code values returned from look type ORA_LOY_TXN_STATUS. The default value is ORA_TXN_STAT_IN_PROG. -
SubmitDt: string
(date-time)
Title:
Submit DateThe transaction submission date. Oracle Loyalty Cloud assigns this attribute value when the transaction is submitted for approval by changing the Transaction Status attribute value to Submitted. There is no default value, dependency, or limitation associated with this attribute. -
SubmitToId: integer
(int64)
Title:
Submit to IDThe submit to identifier contains the details of the partner reviewer that approves the transaction. This attribute is input by the user. There is no default value, dependency, or limitation associated with this attribute. -
SubTypeName: string
Title:
Subtype NameThe transaction subtype name. This attribute is dependent on the TypeCodeName attribute. The accepted values are, A. if Accrual??? Product, Manual Credit, or B. if Redemption ??? Product, or Manual Debit. There is no default value, dependency, or limitation associated with this attribute. -
TaxAmount: number
Title:
Tax AmountThe amount of tax that must be paid for the completed transaction. There is no default value, dependency, or limitation associated with this attribute. -
TicketNumber: string
Title:
Ticket NumberMaximum Length:30The unique number that is used to identify the ticket booking for an airline transaction. There is no default value, dependency, or limitation associated with this attribute. -
ToMemberNumber: string
Title:
Recipient Membership NumberMaximum Length:30The unique identification number of the member to whom points are transferred. There is no default value, dependency, or limitation associated with this attribute. -
TotalDays: integer
(int64)
Title:
Total DaysThe total days that are required for travel between the source and destination locations. There is no default value, dependency, or limitation associated with this attribute. -
TotalLines: number
Title:
Total LinesThe total line items for the transaction. A transaction can include many order line items. There is no default value, dependency, or limitation associated with this attribute. -
TransactionDate: string
(date-time)
Title:
Transaction DateThe date when the transaction is completed. There is no default value, dependency, or limitation associated with this attribute. -
TransactionNumber: string
Title:
Transaction NumberMaximum Length:30The transaction number. This is an alternate key that is mandatory during an update. This attribute is automatically generated by Oracle Loyalty Cloud. There is no default value, dependency, or limitation associated with this attribute. -
TransactionSourceCode: string
Title:
Transaction Source CodeMaximum Length:30The transaction source code attribute indicates the transaction activity type like Airlines, Hotels, Car Rental, and so on. There is no default value, dependency, or limitation associated with this attribute. -
TransactionStatusMeaning: string
The name of the transaction status code. The accepted values are In Progress, Processed, or Rejected. There is no default value, dependency, or limitation associated with this attribute.
-
TransactionSubStatusMeaning: string
The name of the transaction substatus code. The accepted values are Success, No Promotions Qualified, Insufficient Member Balance, Insufficient Point Blocks. There is no default value, dependency, or limitation associated with this attribute.
-
TransactionVouchers: array
(Deprecated) Transaction Vouchers
Title:
(Deprecated) Transaction VouchersThe transaction vouchers resource is used to retrieve the details of loyalty vouchers that are applied to the transaction. -
TransferMemId: integer
(int64)
Title:
Transfer MemberThe unique identification number of the member from whom points are transferred. There is no default value, dependency, or limitation associated with this attribute. -
TransferTransactionId: integer
(int64)
Title:
Transfer Transaction IDThe unique identification number of the transaction that is during transfer points. There is no default value, dependency, or limitation associated with this attribute. -
TravelClassMeaning: string
The travel class name that indicates the class of travel. The accepted values are Business, Economy. There is no default value, dependency, or limitation associated with this attribute.
-
TrvlDistance: number
Title:
Travel DistanceThe transaction travel distance. This attribute stores the total miles travelled. There is no default value, dependency, or limitation associated with this attribute. -
TypeCodeName: string
Title:
Point Type Code NameThe transaction type code name. The accepted values are Accrual or Redemption. There is no default value, dependency, or limitation associated with this attribute. -
UnaccMinor: string
Title:
Unaccounted MinorMaximum Length:1Default Value:NThe unaccounted transaction for a minor, that is below the age of majority. There is no default value, dependency, or limitation associated with this attribute. -
ValStatusCode: string
Title:
Value Status CodeMaximum Length:30The status of the validation performed on the record. There is no default value, dependency, or limitation associated with this attribute. -
VoucherQuantity: number
Title:
Voucher QuantityThe quantity of vouchers that are assigned because of the given transaction after processing. There is no default value, dependency, or limitation associated with this attribute.
Nested Schema : (Deprecated) Accrual Items
Type:
arrayTitle:
(Deprecated) Accrual ItemsThe accrual items resource is used to retrieve the accrual items that have been updated on transaction processing.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : (Deprecated) Loyalty Promotions
Type:
arrayTitle:
(Deprecated) Loyalty PromotionsThe loyalty promotions resource is used to retrieve the details of a loyalty promotion that is applied to the transaction.
Show Source
Nested Schema : (Deprecated) Redemption Items
Type:
arrayTitle:
(Deprecated) Redemption ItemsThe redemption items resource is used to retrieve the redemption items that have been updated on transaction processing.
Show Source
Nested Schema : (Deprecated) Transaction Vouchers
Type:
arrayTitle:
(Deprecated) Transaction VouchersThe transaction vouchers resource is used to retrieve the details of loyalty vouchers that are applied to the transaction.
Show Source
Nested Schema : loyaltyTransactions-AccrualItems-item-response
Type:
Show Source
object-
AccrualedValue: number
Title:
Number of PointsThe number of accrued points. This attribute gets updated whenever the transaction creates accrual items and assigns points during transaction processing. There is no default value, dependency, or limitation associated with this attribute. -
Active: string
Title:
ActiveRead Only:trueMaximum Length:1The accrual item active flag. This attribute is a boolean flag which indicates whether the accrual item is active or not. There is no default value, dependency, or limitation associated with this attribute. -
AmountValue: number
Title:
AmountRead Only:trueThe currency value amount of the transaction from transactions. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
ExpirationDt: string
(date-time)
Title:
Expiration DateThe date when the points accrued expire. There is no default value, dependency, or limitation associated with this attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoyAcrlItmId: integer
(int64)
The primary key of loyalty accrual Items. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute.
-
LoyAttrdefnBId: integer
(int64)
Read Only:
trueThe primary key of the promotion attributes definition. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
LoyPromoId: integer
(int64)
Read Only:
trueThe primary key value of the promotion from loyalty promotions. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
LoyTransactionId: integer
(int64)
Title:
Loyalty Transaction IDRead Only:trueThe primary key value of the transaction from transactions. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
NumberOfPoints: number
Title:
Base PointsRead Only:trueThe number of points that have been accrued as a result of accrual type transactions being processed. There is no default value, dependency, or limitation associated with this attribute. -
ObjectVersionNumber: integer
(int32)
The accrual item version number. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute.
-
PointTypeId: integer
(int64)
Title:
Point Type IDRead Only:trueThe identifier of the point type, which is a primary key of the loyaltyPoints attribute. There is no default value, dependency, or limitation associated with this attribute. -
PointTypeName: string
Read Only:
trueMaximum Length:30The name of the point type for which the accrual Item is created during transaction processing. There is no default value, dependency, or limitation associated with this attribute. -
ProdId: integer
(int64)
Title:
Product IDRead Only:trueThe foreign key of loyalty products. Oracle Loyalty Cloud set this attribute. There is no default value, dependency, or limitation associated with this attribute. -
ProgId: integer
(int64)
Title:
Product IDRead Only:trueThe foreign key of the program. Oracle Loyalty Cloud set this attribute. There is no default value, dependency, or limitation associated with this attribute. -
ProgramName: string
Read Only:
trueThe name of the program in which the transaction is created. There is no default value, dependency, or limitation associated with this attribute. -
PromoId: integer
(int64)
Title:
Promotion IDThe foreign key of loyalty promotions. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
PromotionName: string
Title:
NameRead Only:trueMaximum Length:50The name of the promotion that has been applied and for which the accrual items are created during transaction processing. There is no default value, dependency, or limitation associated with this attribute. -
StatusCode: string
Title:
Status CodeMaximum Length:30The code that represents the status of the accrual item. The accepted values are ORA_LOY_AVAILABLE, ORA_LOY_CANCELLED or ORA_LOY_EXPIRED. There is no default value, dependency, or limitation associated with this attribute. -
TransactionId: integer
(int64)
Title:
Transaction IDThe foreign key for transactions. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
UsedValue: number
Title:
Used ValueThe total points used to date from the accrued points. There is no default value, dependency, or limitation associated with this attribute.
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.
Nested Schema : loyaltyTransactions-Promotions-item-response
Type:
Show Source
object-
Active: string
Title:
ActiveRead Only:trueMaximum Length:1The boolean attribute that identifies whether the promotion is currently active or not. There is no default value, dependency, or limitation associated with this attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoyBucketId: integer
(int64)
Title:
Loyalty Milestone IDThe primary key to identify a loyalty bucket transaction. Oracle Loyalty Cloud generates this attribute value when a bucket is created based on the promotion setup. There is no default value, dependency, or limitation associated with this attribute. -
LoyBucketTransactionId: integer
(int64)
Read Only:
trueThe primary key for the promotion bucket transaction identifier. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
LoyProgId: integer
(int64)
Read Only:
trueThe foreign key of the program. Oracle Loyalty Cloud set this attribute. There is no default value, dependency, or limitation associated with this attribute. -
LoyPromoId: integer
(int64)
Read Only:
trueThe primary key to identify a loyalty promotion. Oracle Loyalty Cloud generates this attribute value when a new promotion is set up. There is no default value, dependency, or limitation associated with this attribute. -
Name: string
Title:
NameRead Only:trueMaximum Length:50The name of the promotion, which can be easily remembered by the user. There is no default value, dependency, or limitation associated with this attribute. -
ObjectVersionNumber: integer
(int32)
The promotion version number. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute.
-
PromotionAttributes: array
(Deprecated) Promotion Attributes
Title:
(Deprecated) Promotion AttributesThe promotion attributes resource is used to retrieve the details of a promotion attribute that is updated for transaction. -
StatusCode: string
Title:
Status CodeMaximum Length:30The promotion status code that represents the status of the promotion. There is no default value, dependency, or limitation associated with this attribute. -
TransactionId: integer
(int64)
Read Only:
trueThe primary key for the transaction. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : (Deprecated) Promotion Attributes
Type:
arrayTitle:
(Deprecated) Promotion AttributesThe promotion attributes resource is used to retrieve the details of a promotion attribute that is updated for transaction.
Show Source
Nested Schema : loyaltyTransactions-Promotions-PromotionAttributes-item-response
Type:
Show Source
object-
Active: string
Read Only:
trueMaximum Length:1The promotion attribute active flag. This attribute is a boolean flag that indicates whether the promotion attribute is active or not. There is no default value, dependency, or limitation associated with this attribute. -
AttribDefnId: integer
(int64)
The attribute definition identifier that results from transaction processing. There is no default value, dependency, or limitation associated with this attribute.
-
AttrTypeCode: string
Read Only:
trueMaximum Length:30The promotion attribute type code. This attribute reflects the type of attribute, for example, Field, Point Total, and so on. There is no default value, dependency, or limitation associated with this attribute. -
DisplayName: string
Read Only:
trueMaximum Length:30The display name that is displayed to the user. There is no default value, dependency, or limitation associated with this attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoyAttrdefnBId: integer
(int64)
Read Only:
trueThe primary key of loyalty attributes. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
LoyAttrItmId: integer
(int64)
The primary key of loyalty attribute items. There is no default value, dependency, or limitation associated with this attribute.
-
ObjectCode: string
Read Only:
trueMaximum Length:30The details of the object whose attribute is compared. The picklist displays only those objects that are appropriate to the value in the Rule Applies To field. The accepted values are Transaction, Member, and so on. There is no default value, dependency, or limitation associated with this attribute. -
PromoBucketId: integer
(int64)
The promotion attribute bucket identifier. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute.
-
PromoId: integer
(int64)
The promotion attribute of the loyalty promotions. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute.
-
TransactionId: integer
(int64)
The primary key from transactions which is a foreign key for promotions. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute.
-
Value: string
Maximum Length:
250The value of the promotion or program attribute item. There is no default value, dependency, or limitation associated with this attribute.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : loyaltyTransactions-RedemptionItems-item-response
Type:
Show Source
object-
AccrualItemId: integer
(int64)
Title:
Accrual Item IDThe redemption item accrual item identifier. This attribute reflects the accrual item identifier, from which the points are redeemed. There is no default value, dependency, or limitation associated with this attribute. -
AmountValue: number
Title:
AmountRead Only:trueThe currency value of the transaction which results in the creation of the redemption item when processed. There is no default value, dependency, or limitation associated with this attribute. -
DisplayName: string
Read Only:
trueMaximum Length:30The name of the redemption items that are displayed to the user. Redemption items are created when a transaction of type Redemption is processed successfully. There is no default value, dependency, or limitation associated with this attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoyAttrdefnBId: integer
(int64)
Read Only:
trueThe redemption item attribute definition bid. This attribute is the primary key of loyalty attributes. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
LoyPromoId: integer
(int64)
Read Only:
trueThe primary key from loyalty promotions. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
LoyRdmItmId: integer
(int64)
Title:
Loyalty Redemption Item IDThe primary key of loyalty redemption items. The redemption items are created when a transaction that is of type Redemption is processed successfully resulting in redeeming accrued points. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
LoyTransactionId: integer
(int64)
Title:
Loyalty Transaction IDRead Only:trueThe primary key from transactions. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
ObjectCode: string
Read Only:
trueMaximum Length:30The redemption item object code. This attribute indicates the object, either Member, Transaction, Promotion, Calendar, and so on, to which the attributes belong. There is no default value, dependency, or limitation associated with this attribute. -
ObjectVersionNumber: integer
(int32)
Title:
Object Version NumberThe redemption item version number. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
PointTypeId: integer
(int64)
Title:
Point Type IDRead Only:trueThe identifier of point type which is a primary key of the loyaltyPoints attribute. There is no default value, dependency, or limitation associated with this attribute. -
ProcessDt: string
(date-time)
Title:
Process DateThe date when the transaction that resulted in the creation of the redemption is processed. There is no default value, dependency, or limitation associated with this attribute. -
ProgId: integer
(int64)
Title:
Product IDRead Only:trueThe foreign key for the program. Oracle Loyalty Cloud sets this attribute. There is no default value, dependency, or limitation associated with this attribute. -
ProgramName: string
Read Only:
trueThe name of the program under which the transaction is created. There is no default value, dependency, or limitation associated with this attribute. -
PromotionName: string
Title:
NameRead Only:trueMaximum Length:50The accrual item active flag. This attribute is a boolean flag which indicates whether the accrual item is active or not. There is no default value, dependency, or limitation associated with this attribute. -
PromotionTypeCode: string
Read Only:
trueMaximum Length:30The code representing the promotion type. The accepted values are ORA_TXN_ACC, ORA_TXN_RED or ORA_TIER. There is no default value, dependency, or limitation associated with this attribute. -
TransactionId: integer
(int64)
Title:
Transaction IDThe primary key from transactions which is a foreign key for redemption items. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
TypeCode: string
Title:
Type CodeMaximum Length:30The redemption item type code. The accepted values are ORA_TXN_CNCL or ORA_TXN_RED. There is no default value, dependency, or limitation associated with this attribute. -
Value: number
Title:
Redemption Item ValueThe value of redemption items that are redeemed. There is no default value, dependency, or limitation associated with this attribute.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : loyaltyTransactions-TransactionVouchers-item-response
Type:
Show Source
object-
CurcyAmount: number
Title:
Currency AmountRead Only:trueThe currency value of the voucher if the DiscountType attribute is set to Absolute Value. This value is provided by the user when creating a voucher and is required if the voucher is of type Absolute Value. This attribute depends up on the DiscountType attribute setting. There is no default value or limitation associated with this attribute. -
DiscntPct: number
Title:
Discount PercentageRead Only:trueThe voucher discount percent. This attribute is required if the Discount Type attribute is set to Percentage. This attribute depends on the DiscountType attribute setting which is an input value from the user when creating a voucher. There is no default value or limitation associated with this attribute. -
ExpirationDt: string
(date-time)
Title:
Expiration DateRead Only:trueThe expiration date of the voucher. Oracle Loyalty Cloud generates this attribute value when it assigns a voucher action or it can be provided as an input when creating a voucher using the resource. There is no default value, dependency, or limitation associated with this attribute. -
InvOrgId: integer
(int64)
Title:
Inventory Organization IDRead Only:trueThe unique identifier of the organization that provides the inventory when the user is redeeming the vouchers. There is no default value, dependency, or limitation associated with this attribute. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoyMemVchrId: integer
(int64)
Title:
Member Voucher IDRead Only:trueThe primary key to identify a loyalty voucher. Oracle Loyalty Cloud generates this attribute value when it assigns a voucher action or the value can be provided as input when creating a voucher using the resource. There is no default value, dependency, or limitation associated with this attribute. -
MemberId: integer
(int64)
Title:
Member IDRead Only:trueThe primary key of the member to whom the voucher is assigned. There is no default value, dependency, or limitation associated with this attribute. -
ProdId: integer
(int64)
Read Only:
trueThe identity of the product for an existing voucher. There is no default value, dependency, or limitation associated with this attribute. -
Quantity: number
Title:
QuantityRead Only:trueThe quantity of vouchers that are assigned to a member. The value for this attribute must be a positive integer. There is no default value, dependency, or limitation associated with this attribute. -
TransactionId: integer
(int64)
Title:
Transaction IDRead Only:trueThe primary key from the transaction. Oracle Loyalty Cloud generates this attribute value. There is no default value, dependency, or limitation associated with this attribute. -
UsedDt: string
(date-time)
Title:
Used DateRead Only:trueThe attribute is a date value that is assigned when the voucher status is changed from Available to Used through a PATCH request. There is no default value, dependency, or limitation associated with this attribute. -
VchrEffStartDt: string
(date)
Title:
Voucher Effective Start DateRead Only:trueThe date when the voucher is in effect. This date is assigned during an assign voucher action or when the voucher is created using the resource. There is no default value, dependency, or limitation associated with this attribute. -
VoucherBasis: string
Read Only:
trueThe voucher assignment based on the transaction type. It is set to Accrual for accrual transactions or Redemption for redemption transactions. This is an input value provided by a user when creating a voucher. There is no default value, dependency, or limitation associated with this attribute. -
VoucherStatus: string
Read Only:
trueThe voucher status. The accepted values are Available, Expired, or Used. There is no default value, dependency, or limitation associated with this attribute. -
VoucherType: string
Read Only:
trueThe loyalty product description for the voucher. Oracle Loyalty Cloud assigns the ProductId value with the identifier of the product when the user inputs the product description. There is no default value, dependency, or limitation associated with this attribute.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- processTransaction
-
Processes a loyalty transaction through the loyalty engine by evaluating the rules applied to the given transaction number.
Examples
This example shows how to retrieve all the transactions in your loyalty system.
Use GET with the following URI syntax to retrieve all transactions:
https://example.com:portcrmRestApi/resources/11.13.18.05/loyaltyTransactions
Example of Response Header
cache-control -no-cache, no-store, must-revalidate
connection -Keep-Alive
content-encoding -gzip
content-language -en
content-length -10008
content-type -application/vnd.oracle.adf.resourcecollection+json
date -Tue, 13 Mar 2018 16:34:15 GMT
keep-alive -timeout=61, max=98
link -,https://example.com:port/crmRestApi/resources/crmRestApi/resources/11.13.18.05/loyaltyTransactions>;rel="self";kind="collection";name="loyaltyTransactions"
location -
rest-framework-version -1
server -Oracle-HTTP-Server
vary -User-Agent
x-content-type-options -nosniff
x-oracle-dms-ecid -005PorKJ35AEoIILIqL6if0007EH0007aVExample of Response Body
{
"items": [
{
"LoyTransactionId": 300100125147914,
"ActivityDay": null,
"ActivityHour": null,
"AdjustedListPrice": null,
"AmountValue": 6000,
"ApproveDt": null,
"BidTransaction": "N",
"BookingDt": null,
"BUId": null,
"BulkReferenceId": null,
"CancReasonCode": null,
"CancelledTransactionId": null,
"Comments": null,
"CorporateReferenceNumber": null,
"CreatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"CreationDate": "2018-03-07T18:12:31+00:00",
"CurcyCode": "USD",
"CurcyExchDt": null,
"DestCityCode": null,
"DocumentNumber": null,
"EndDt": null,
"EnrolPromoId": null,
"ExpireInDays": null,
"ExternalReservationNumber": null,
"ExternalTransaction": "N",
"FareBasisCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IncentivChoice": null,
"InternalDest": null,
"InternalFlightDt": null,
"InternalOrigin": null,
"ItemNumber": null,
"LastUpdateDate": "2018-03-07T18:12:59+00:00",
"LastUpdateLogin": "66D7468D2C1FB147E05334C4F00AB58F",
"LastUpdatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"LoanBalance": null,
"LoanRepaymentDt": null,
"LocationCode": null,
"LocationName": null,
"MarketingFlightNumber": null,
"Points": 10,
"ObjectVersionNumber": 2,
"OperFltNumber": null,
"OptyCost": null,
"OrderNumber": null,
"OrderQuantity": null,
"OrigAmount": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OriginCityCode": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"ParentTransactionId": null,
"PartitionName": null,
"PeriodDurCode": null,
"PeriodTypeCode": null,
"PnrName": null,
"PostDt": null,
"ProcFlowId": null,
"ProcessDt": "2018-03-07T18:13:02.792+00:00",
"ProcessingComment": null,
"ProcessingLog": null,
"PtnrProcDt": null,
"PtnrStatusCode": null,
"PymtTypeCode": null,
"QualifyingPointUsed": "N",
"RedemptionQuantity": null,
"RedemptionQuantityUOMCode": null,
"ReasonCode": null,
"RefundBasisCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"StartDt": "2018-03-07T18:12:35.274+00:00",
"SubmitDt": null,
"SubmitToId": null,
"TaxAmount": null,
"TicketNumber": null,
"ToMemberNumber": null,
"TotalLines": null,
"TransferMemId": null,
"TransferTransactionId": null,
"TrvlDistance": null,
"TransactionDate": "2018-03-07T18:12:35.274+00:00",
"TransactionNumber": "300100125147914",
"TransactionSourceCode": null,
"UnaccMinor": "N",
"ValStatusCode": null,
"VoucherQuantity": null,
"InvOrgId": 204,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-03-07T18:12:35.274+00:00",
"ChannelMeaning": "Web",
"BookClassMeaning": null,
"FareTypeMeaning": null,
"SocialActionMeaning": null,
"PaymentTypeMeaning": null,
"SourceMeaning": null,
"TravelClassMeaning": null,
"DestinationZoneMeaning": null,
"DestinationAirportMeaning": null,
"FareBasisMeaning": null,
"OriginAirportMeaning": null,
"OriginZoneMeaning": null,
"TransactionStatusMeaning": "Processed",
"TransactionSubStatusMeaning": "No Promotions Qualified",
"MemberNumber": "300100125147630",
"ProgramName": "Auto Miles75045654368",
"TypeCodeName": "Accrual",
"SubTypeName": "Product",
"ProductNumber": "CRMITEM-AS54888-00182743",
"PartnerNumber": null,
"PointTypeName": "Base",
"ExternProdLineMeaning": null,
"ExternProdTypeMeaning": null,
"ExternalProductName": null,
"TotalDays": null,
"AccItmList": null,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914",
"name": "loyaltyTransactions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
}
},
{
"rel": "canonical",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914",
"name": "loyaltyTransactions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/ProductVO1",
"name": "ProductVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/ExternalProductLineVA",
"name": "ExternalProductLineVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionChannelVA",
"name": "TransactionChannelVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionFareTypeVA",
"name": "TransactionFareTypeVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/FareBasisVA",
"name": "FareBasisVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/SocialActionVA",
"name": "SocialActionVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionTypePVO",
"name": "TransactionTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/PointTypePVO1",
"name": "PointTypePVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionSourceVA",
"name": "TransactionSourceVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionAirPortVA",
"name": "TransactionAirPortVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionAirlineZoneVA",
"name": "TransactionAirlineZoneVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/ExternalProductTypeVA",
"name": "ExternalProductTypeVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/MemberPVO1",
"name": "MemberPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionTravelClassVA",
"name": "TransactionTravelClassVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionSubTypePVO",
"name": "TransactionSubTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/ProgramPVO",
"name": "ProgramPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/SubStatusVA",
"name": "SubStatusVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/BookClassVA",
"name": "BookClassVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/PartnerVO1",
"name": "PartnerVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionStatusVA",
"name": "TransactionStatusVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/lov/TransactionPaymentTypeVA",
"name": "TransactionPaymentTypeVA",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/child/RedemptionItems",
"name": "RedemptionItems",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/child/AccrualItems",
"name": "AccrualItems",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/child/TransactionVouchers",
"name": "TransactionVouchers",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125147914/child/Promotions",
"name": "Promotions",
"kind": "collection"
}
]
},
.
.
.
{
"LoyTransactionId": 300100125117639,
"ActivityDay": null,
"ActivityHour": null,
"AdjustedListPrice": null,
"AmountValue": 0,
"ApproveDt": null,
"BidTransaction": "N",
"BookingDt": null,
"BUId": null,
"BulkReferenceId": null,
"CancReasonCode": null,
"CancelledTransactionId": null,
"Comments": null,
"CorporateReferenceNumber": null,
"CreatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"CreationDate": "2018-03-07T13:31:29+00:00",
"CurcyCode": "USD",
"CurcyExchDt": null,
"DestCityCode": null,
"DocumentNumber": null,
"EndDt": null,
"EnrolPromoId": null,
"ExpireInDays": null,
"ExternalReservationNumber": null,
"ExternalTransaction": "N",
"FareBasisCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IncentivChoice": null,
"InternalDest": null,
"InternalFlightDt": null,
"InternalOrigin": null,
"ItemNumber": null,
"LastUpdateDate": "2018-03-07T13:32:02.167+00:00",
"LastUpdateLogin": "66D2DB43ACEFB992E05334C4F00AF4C4",
"LastUpdatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"LoanBalance": null,
"LoanRepaymentDt": null,
"LocationCode": null,
"LocationName": null,
"MarketingFlightNumber": null,
"Points": 10,
"ObjectVersionNumber": 2,
"OperFltNumber": null,
"OptyCost": null,
"OrderNumber": null,
"OrderQuantity": null,
"OrigAmount": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OriginCityCode": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"ParentTransactionId": null,
"PartitionName": null,
"PeriodDurCode": null,
"PeriodTypeCode": null,
"PnrName": null,
"PostDt": null,
"ProcFlowId": null,
"ProcessDt": "2018-03-07T13:32:05.330+00:00",
"ProcessingComment": null,
"ProcessingLog": "Assigned Points: 500.0 Base, Expiry Date: Tue May 01 23:59:59 UTC 2018 (--Set action Assign points 10--) <br>",
"PtnrProcDt": null,
"PtnrStatusCode": null,
"PymtTypeCode": null,
"QualifyingPointUsed": "N",
"RedemptionQuantity": null,
"RedemptionQuantityUOMCode": null,
"ReasonCode": null,
"RefundBasisCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"StartDt": "2018-03-07T13:31:32.318+00:00",
"SubmitDt": null,
"SubmitToId": null,
"TaxAmount": null,
"TicketNumber": null,
"ToMemberNumber": null,
"TotalLines": null,
"TransferMemId": null,
"TransferTransactionId": null,
"TrvlDistance": null,
"TransactionDate": "2018-03-07T13:31:32.318+00:00",
"TransactionNumber": "300100125117639",
"TransactionSourceCode": null,
"UnaccMinor": "N",
"ValStatusCode": null,
"VoucherQuantity": null,
"InvOrgId": 204,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-03-07T13:31:32.318+00:00",
"ChannelMeaning": "Web",
"BookClassMeaning": null,
"FareTypeMeaning": null,
"SocialActionMeaning": null,
"PaymentTypeMeaning": null,
"SourceMeaning": null,
"TravelClassMeaning": null,
"DestinationZoneMeaning": null,
"DestinationAirportMeaning": null,
"FareBasisMeaning": null,
"OriginAirportMeaning": null,
"OriginZoneMeaning": null,
"TransactionStatusMeaning": "Processed",
"TransactionSubStatusMeaning": "Success",
"MemberNumber": "300100125117435",
"ProgramName": "Auto Miles34428101051",
"TypeCodeName": "Accrual",
"SubTypeName": "Product",
"ProductNumber": "CRMITEM-AS54888-00182745",
"PartnerNumber": null,
"PointTypeName": "Base",
"ExternProdLineMeaning": null,
"ExternProdTypeMeaning": null,
"ExternalProductName": null,
"TotalDays": null,
"AccItmList": "[{\"PointTypeName\":\"Base\",\"LoyAttrdefnBId\":300100125117340,\"AccrualedValue\":500}]",
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639",
"name": "loyaltyTransactions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
}
},
{
"rel": "canonical",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639",
"name": "loyaltyTransactions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/ProductVO1",
"name": "ProductVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/ExternalProductLineVA",
"name": "ExternalProductLineVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionChannelVA",
"name": "TransactionChannelVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionFareTypeVA",
"name": "TransactionFareTypeVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/FareBasisVA",
"name": "FareBasisVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/SocialActionVA",
"name": "SocialActionVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionTypePVO",
"name": "TransactionTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/PointTypePVO1",
"name": "PointTypePVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionSourceVA",
"name": "TransactionSourceVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionAirPortVA",
"name": "TransactionAirPortVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionAirlineZoneVA",
"name": "TransactionAirlineZoneVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/ExternalProductTypeVA",
"name": "ExternalProductTypeVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/MemberPVO1",
"name": "MemberPVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionTravelClassVA",
"name": "TransactionTravelClassVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionSubTypePVO",
"name": "TransactionSubTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/ProgramPVO",
"name": "ProgramPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/SubStatusVA",
"name": "SubStatusVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/BookClassVA",
"name": "BookClassVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/PartnerVO1",
"name": "PartnerVO1",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionStatusVA",
"name": "TransactionStatusVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/lov/TransactionPaymentTypeVA",
"name": "TransactionPaymentTypeVA",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/child/RedemptionItems",
"name": "RedemptionItems",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/child/AccrualItems",
"name": "AccrualItems",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/child/TransactionVouchers",
"name": "TransactionVouchers",
"kind": "collection"
},
{
"rel": "child",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions/300100125117639/child/Promotions",
"name": "Promotions",
"kind": "collection"
}
]
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyaltyTransactions",
"name": "loyaltyTransactions",
"kind": "collection"
}
]
}