TransactionJournal

Represents information about journal records. This object is available in API version 57.0 and later.

This guide only lists certain information for each object. For more information, including descriptions of the fields, see TransactionJournal in the Accounting Subledger Developer Guide, Automotive Cloud Developer Guide, Channel Revenue Management Developer Guide, Loyalty Management Developer Guide, Public Sector Developer Guide, Rebate Management Developer Guide, Referral Marketing Developer Guide, and Usage Management Guide.

Fields

Field Name Field Label Type Digits Length Precision Scale
AccountId Account ID reference 18
ActivityDate Activity Date datetime
BookedFareClass Booked Fare Class picklist 255
BookedRoomType Booked Room Type picklist 255
BookingDate Booking Date date
Brand Brand string 30
Channel Channel picklist 255
CouponId Coupon ID reference 18
CreatedById Created By ID reference 18
CreatedDate Created Date datetime
CreationSourceType Creation Source Type picklist 40
Credit Credit currency 18 2
CreditGeneralLedgerAccountId General Ledger Account ID reference 18
CurrencyIsoCode Currency ISO Code picklist 3
Debit Debit currency 18 2
DebitGeneralLedgerAccountId General Ledger Account ID reference 18
Destination Destination string 30
DestinationLocationId Location ID reference 18
Distance Distance double 18 2
EndDate End Date datetime
ErrorDescription Error Message string 255
EscrowPointsCreditDate Escrow Points Credit Date date
Establishment Establishment string 40
ExternalTransactionNumber External Transaction ID string 40
FlightNumber Flight Number string 10
ForeignExchangeGainOrLossType Foreign Exchange Gain Or Loss Type picklist 40
GeneralLedgerAcctAsgntRuleId General Ledger Account Assignment Rule ID reference 18
GenlLdgrJournalEntryRuleId General Ledger Account Assignment Rule ID reference 18
Id Transaction Journal ID id 18
Industry Industry picklist 255
InvoiceDate Invoice Generated Date date
IsDeleted Deleted boolean
IsParentTransaction Parent Transaction boolean
JournalDate Journal Date datetime
JournalReason Journal Reason picklist 255
JournalSubTypeId Journal Subtype ID reference 18
JournalTypeId Journal Type ID reference 18
LastModifiedById Last Modified By ID reference 18
LastModifiedDate Last Modified Date datetime
LastReferencedDate Last Referenced Date datetime
LastViewedDate Last Viewed Date datetime
LegalEntityId Legal Entity ID reference 18
LegalEntyAccountingPeriodId Legal Entity Accounting Period ID reference 18
LoyaltyProgramId Loyalty Program ID reference 18
MemberId Program Member ID reference 18
Name Name string 30
OrderId Order ID reference 18
OrderItemId Order Product ID reference 18
Origin Origin string 30
PartnerId Loyalty Program Partner ID reference 18
PaymentMethod Payment Method picklist 255
PriceType Price Type picklist 255
ProductCategoryId Category ID reference 18
ProductId Product ID reference 18
PromotionId Promotion ID reference 18
Quantity Quantity double 18 2
QuantityUnitOfMeasureId Quantity Unit ID reference 18
RedeemedPointsExpirationInformation Redeemed Points Expiration Information textarea 131072
ReferenceRecordId Reference Record ID reference 18
ReferenceTransactionRecordId Reference Transaction Record ID reference 18
ReferralCode Referral Code string 85
ReferralId Referral ID reference 18
ReferredMemberId Referred Member ID reference 18
ReferredPartyId Associated Individual ID reference 18
RelatedCorporateMembershipId Related Corporate Membership ID reference 18
RelatedJournalId Related Journal ID reference 18
ResaleUnitPrice Resale Unit Price currency 18 2
SaleUnitPrice Sale Unit Price currency 18 2
ShipToAccountId Account ID reference 18
SourceLocationId Location ID reference 18
StartDate Start Date datetime
Status Status picklist 40
SystemModstamp System Modstamp datetime
TotalPromotionDiscount Total Promotion Discount currency 18 2
TransactionAmount Transaction Amount currency 18 2
TransactionLocation Transaction Location string 50
TransactionType Transaction Type picklist 40
TraveledFareClass Traveled Fare Class picklist 255
UniqueIdentifier Unique Identifier string 80
UsageResourceId Usage Resource ID reference 18
UsageSummaryId Usage Summary ID reference 18
UsageType Usage Type picklist 40
VoucherCode Voucher Code string 255