Loyalty Transaction
Transaction Data Object for Loyalty Transaction Service
QName: {http://xmlns.oracle.com/apps/sales/loyalty/transaction/transactionService/}Transaction
Logical Business Objects
-
CRM : Loyalty : Loyalty Transaction
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contains |
|
Contains |
|
Contained by |
|
Handled by |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AccrRuleId |
long |
Accrual rule Id |
AccrualDisputeStatus |
string |
List of Value Meaning for Accrual Dispute Status |
AccrualDisputeStatusCode |
string |
Accrual Dispute Status Code |
AccrualDisputeType |
string |
List of Value Meaning for Accrual Dispute Type |
AccrualDisputeTypeCode |
string |
Accrual Dispute Type Code |
AccrualDisputedTransactionNumber |
string |
Accrual Disputed Transaction Number |
ActivityDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Activity date |
ActivityDay |
decimal |
Activity day |
ActivityHour |
decimal |
Activity hour |
AdjustedListPriceValue |
decimal |
Adjusted list price value |
AmountValue |
decimal |
Amount value |
ApproveDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Approve date |
ApproveId |
long |
Approve Id |
AttributeDefnBId |
long |
Loyalty attribute definition Id |
BUId |
long |
BU Id |
BackupInvOrgId |
long |
Backup InvOrgId |
BackupProductNumber |
string |
Backup Product Number |
Balance |
decimal |
Transaction balance |
BookClassCode |
string |
Book class code |
BookingClass |
string |
List of Value Meaning for Booking Class Code |
BookingDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Booking date |
Bucket |
Bucket object associated with transaction |
|
CancReasonCode |
string |
Cancel reason code |
CancelledTransactionId |
long |
Cancelled transaction Id |
CancelledTransactionNumber |
string |
Cancelled transaction number |
ChildTransactionId |
long |
Child transaction Id |
ChildTransactionNumber |
string |
Child transaction number |
Comments |
string |
Transaction comments |
ConflictId |
long |
Conflict Id |
CorpCurrencyCode |
string |
Corp currency code |
CorpReferenceMemberId |
long |
Corp reference member Id |
CorpReferenceMemberType |
string |
Corp reference member type |
CorpReferenceName |
string |
Corp reference name |
CorporateReferenceNumber |
string |
Corporate reference number |
CreatedBy |
string |
Indicates who create the transaction |
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the date and time of the creation of the row |
CurcyCode |
string |
Currency code |
CurcyConvRateType |
string |
Currency conv rate type |
CurcyExchDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Currency exchange date |
Description |
string |
Transaction description |
DestAirport |
string |
List of Value Meaning for Dest Airport Code |
DestAirportCode |
string |
Destination airport code |
DestCityCode |
string |
Destination city code |
DestZone |
string |
List of Value Meaning for Dest AirlineZone Code |
DestZoneCode |
string |
Destination zone code |
DisplayName |
string |
Point Type Name |
DocumentNumber |
string |
Doucment number |
EndDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
End date |
EventName |
string |
Event name |
ExpireInDays |
decimal |
Expire in days |
ExternProdLineMeaning |
string |
Exernal product line meaning |
ExternProdTypeMeaning |
string |
External product type meaning |
ExternalProductLine |
string |
External product line |
ExternalProductLineMeaning |
string |
List of Value Meaning for External Product Line Code |
ExternalProductName |
string |
External product name |
ExternalProductTyeMeaning |
string |
List of Value Meaning for External Product Type Code |
ExternalProductType |
string |
External product type |
ExternalReservationNumber |
string |
External reservation number |
ExternalTransaction |
string |
External Transaction |
FareBasis |
string |
Fare basis |
FareBasisCode |
string |
Fare basis code |
FareBasisMeaning |
string |
List of Value Meaning for Fare Basis Code |
FareType |
string |
List of Value Meaning for Fare Type Code |
FareTypeCode |
string |
Fare type code |
FlightNumber |
string |
Flight number |
FltTypeCode |
string |
Flight type code |
GdsRecLocator |
string |
Gds record locator |
IncentivChoice |
string |
Incentive choice |
IntegrationId |
string |
Integration Id |
InternalDest |
string |
Internal destination |
InternalFlightDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Internal flight date |
InternalOrigin |
string |
Internal origin |
InvOrgId |
long |
Inventory organization Id |
InventoryItemId |
long |
Inventory item Id |
ItemNumber |
string |
Item number |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the date and time of the last update of the row |
LastUpdateLogin |
string |
Indicates the session login associated to the user who last updated the row |
LastUpdatedBy |
string |
Indicates the user who last updated the row |
LineItemNumber |
long |
Line item number |
LoanBalance |
decimal |
Loan balance |
LoanRepaymentDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Loan repayment date |
LocationCode |
long |
Location code |
LocationName |
string |
Location name |
LoyMemberId |
long |
Loyalty member Id |
LoyProgramId |
long |
Loyalty program Id |
MarketingFlightNumber |
string |
marketing flight number |
MemName |
string |
Member name |
MemTypeCode |
string |
Member type code |
MemberId |
long |
Member identifier |
MemberName |
string |
Member name |
MemberNumber |
string |
Member number |
MemberTypeCode |
string |
Member type code |
ObjectVersionNumber |
int |
Used to implement optimistic locking |
OperCarrierId |
long |
Oper carrier Id |
OperFltNumber |
string |
Oper flight number |
OptyCost |
decimal |
Opportunity cost |
OrderNumber |
string |
Order number |
OrderQuantityValue |
decimal |
Order quantity value |
OrganizationCode |
string |
Organization Code |
OrganizationId |
long |
Organization Id |
OrigAcrlReferenceId |
long |
Origin accrual reference Id |
OrigAirport |
string |
List of Value Meaning for Org Airport Code |
OrigAirportCode |
string |
Origin airport code |
OrigAmountValue |
decimal |
Original amount value |
OrigOrdItmId |
long |
Origin order item Id |
OrigOrderId |
long |
Origin order Id |
OrigPoints |
decimal |
Origin points |
OrigZone |
string |
List of Value Meaning for Org AirlineZone Code |
OrigZoneCode |
string |
Origin zone code |
OriginCityCode |
string |
Origin city code |
OvrDupCheck |
string |
Ovr dup check flag |
OwnerId |
long |
Owner Id |
PackageCode |
string |
Package code |
ParentTransactionId |
long |
Parent transaction Id |
ParentTransactionNumber |
string |
Parent transaction number |
PartitionName |
string |
Partition name |
PartnerCompanyNumber |
string |
Partner Company Number |
PartnerId |
long |
Partner Id |
PartnerNumber |
string |
Partner Number |
PartyId |
long |
Party Id |
PartyName |
string |
Party name |
PartyNumber |
string |
Party Number |
PaymentTypeMeaning |
string |
List of Value Meaning for Payment Type Code |
PeriodDurCode |
string |
Period dur code |
PeriodTypeCode |
string |
Period type code |
PersonId |
long |
Person Id |
PnrName |
string |
Pnr name |
PnrNumber |
string |
Pnr number |
PointTypeId |
long |
Point type Id |
PointTypeName |
string |
Point type name |
Points |
decimal |
Transaction points |
PostDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Post date |
PrConId |
long |
Primary contact Id |
PrgName |
string |
Program name |
PriceOverriden |
string |
Price overriden |
ProcessDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Process date |
ProcessingComment |
string |
Processing comment |
ProcessingLog |
string |
Processing log |
ProdId |
long |
Product Id |
ProdItemNumber |
string |
Product Item Number |
ProductDescription |
string |
Product description |
ProductNumber |
string |
Product Number |
ProgId |
long |
Program Id |
ProgName |
string |
Program name |
ProgramName |
string |
Program Name |
ProgramNumber |
string |
Transaction associated program number |
Promotions |
Promotion object associated with transaction |
|
PtnrProcDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Partener process date |
PtnrStatusCode |
string |
Partener status code |
PtnrUserId |
long |
Partener user Id |
PymtTypeCode |
string |
Payment type code |
QualifyingPointUsed |
string |
Qualifying point used |
QueuedProcessingFlag |
boolean |
Queued Processing Flag |
ReasonCode |
string |
Reason code |
RedemptionQuantityUOMCode |
string |
Redemption quantity UOM code |
RedemptionQuantityValue |
decimal |
Redemption quantity value |
ReferredByMemId |
long |
Referred by member Id |
ReferredByMemNumber |
string |
Referred by member number |
RefundPct |
decimal |
Refund pct |
RfndOvrdCmnts |
string |
Refund overriden comments |
RfndOvrdRsnCode |
string |
Refund overriden rsn code |
SmActionMeaning |
string |
Sm action meaning |
SmActionType |
string |
List of Value Meaning for Social Action Type Code |
SmActionTypeCode |
string |
Sm action type code |
SmDataId |
long |
Sm data Id |
Source |
string |
List of Value Meaning for Transaction Source Code |
SourceCode |
string |
Source code |
StartDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Start date |
StatusCode |
string |
Transaction status code |
StatusLookupCode |
string |
Status lookup code |
StatusLookupType |
string |
Status lookup type |
StatusLookupTypeValue |
string |
Status lookup type value |
StatusMeaning |
string |
Transaction status meaning |
SubStatus |
string |
List of Value Meaning for Sub Status Code |
SubStatusCode |
string |
Substatus code |
SubTypeCode |
string |
Transaction sub type code |
SubTypeLookupCode |
string |
Subtype lookup code |
SubTypeLookupType |
string |
Subtype lookup type |
SubTypeMeaning |
string |
Transaction sub type meaning |
SubTypeName |
string |
Sub type name |
SubmitDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Submit date |
SubmitToId |
long |
Submit to Id |
TaxAmountValue |
decimal |
Tax amount value |
TicketNumber |
string |
Ticket number |
ToMemberNumber |
string |
To member number |
TotalDays |
long |
Storing number of days stayed in a hotel or car rented or any other service taken on per-day basis |
TotalLines |
decimal |
Total lines |
TransactionChannel |
string |
List of Value Meaning for Transaction Channel Code |
TransactionChannelCode |
string |
Transaction channel code |
TransactionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Transaction date |
TransactionId |
long |
Loyalty transaction identifier |
TransactionNumber |
string |
Transaction number |
TransactionSourceCode |
string |
Transaction source code |
TransferMemId |
long |
Transfer member Id |
TransferMemName |
string |
Transfer member name |
TransferMemNumber |
string |
Transfer Member Number |
TransferPoints |
decimal |
Transfer points |
TransferToMember |
string |
Fransfer to member |
TransferTransactionId |
long |
Transfer transaction Id |
TrvClass |
string |
List of Value Meaning for Travel Class Code |
TrvClassCode |
string |
Travel class code |
TrvlDistance |
decimal |
Travel distance |
TypeCode |
string |
Transaction type code |
TypeCodeName |
string |
Type code name |
TypeLookupCode |
string |
Type lookup code |
TypeMeaning |
string |
Transaction type meaning |
UnaccMinor |
string |
Unacc minor |
ValStatusCode |
string |
Val status code |
Voucher |
Voucher object associated with transaction |
|
VoucherId |
string |
Voucher Id |
VoucherNumber |
string |
Voucher Number |
VoucherQuantityValue |
decimal |
Voucher quantity value |
VoucherTypeId |
long |
Voucher type Id |
Vouchers |
Voucher object associated with transaction |