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.

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