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 |