Transactions

The Transaction Body Fields custom field is available for the Transactions table.

Important: Credit and debit amounts are not exposed as columns in the Transactions table. However, you can query the Transaction Lines table to obtain transaction credit and debit amounts. For more details, see Connect Access to Transaction Credit and Debit Amounts.
Important: Item count and quantity values are not exposed as columns in the Transactions table. However, you can query the Transaction Lines table to obtain these values. For more details, see Connect Access to Transaction Quantities.

Columns

Name Type Length Precision Scale References In Description
account_based_number VARCHAR2 138 Account based number
accounting_book_id NUMBER 39 0 Accounting book ID
accounting_period_id NUMBER 39 0 Accounting period ID
acct_corp_card_expenses_id NUMBER 39 0 account_id
Accounts
ID of the account for corporate card in expense report
amount_unbilled NUMBER 20 2 Amount unbilled
bill_pay_transaction VARCHAR2 3 Bill pay transaction
billaddress VARCHAR2 999 Billing address
billing_account_id NUMBER 39 0 Billing account ID
billing_instructions VARCHAR2 999 Billing instructions
buildable NUMBER 39 0 The number of assemblies that can be built with the current supplies.
bulk_submission_id NUMBER 39 0 Bulk submission ID
carrier VARCHAR2 100 Carrier
closed TIMESTAMP Closed
company_status_id NUMBER 39 0 Company status ID
contract_cost_amount NUMBER 20 2 Contract cost amount
contract_defer_expense_acct_id NUMBER 39 0 Contract defer expense account ID
contract_expense_acct_id NUMBER 39 0 Contract expense account ID
contract_expense_src_acct_id NUMBER 39 0 Contract acquisition expense source account
create_date TIMESTAMP Creation date (GMT)
created_by_id NUMBER 39 0 ID of the creator
created_from_id NUMBER 39 0 Created from ID
currency_id NUMBER 39 0 Currency ID
custom_form_id NUMBER 39 0 Custom form ID
date_actual_prod_end TIMESTAMP The date production ends.
date_actual_prod_start TIMESTAMP The date production starts.
date_as_of TIMESTAMP As of date
date_bid_close TIMESTAMP Bid close date
date_bid_open TIMESTAMP Bid open date
date_contract_cost_accrual TIMESTAMP Date contract cost accrual
date_last_modified TIMESTAMP Date last modified (GMT)
date_tax_point TIMESTAMP Transaction date determining taxability rules
due_date TIMESTAMP Due date
email VARCHAR2 256 Email
end_date TIMESTAMP End date
entity_id NUMBER 39 0 Entity ID
entity_tax_reg_num VARCHAR2 30 Entity's tax registration number
exchange_rate NUMBER 30 15 Exchange rate
expected_close TIMESTAMP Expected close
external_ref_number VARCHAR2 138 External reference number
fax VARCHAR2 100 Fax
fob VARCHAR2 13 FOB
forecast_type VARCHAR2 384 Forecast type
include_in_forecast VARCHAR2 3 Include in forecast
incoterm VARCHAR2 100 International commercial term (Incoterm)
intercompany_transaction_id NUMBER 39 0 Intercompany transaction ID
is_actualprodenddate_manual VARCHAR2 3 Whether the actual production end date needs to be entered manually.
is_actualprodstartdate_manual VARCHAR2 3 Whether the actual production start date needs to be entered manually.
is_advanced_intercompany VARCHAR2 3 Indicates whether the transaction is an advanced intercompany journal entry
is_autocalculate_lag VARCHAR2 3 Whether lag times for operation tasks should be calculated.
is_compliant VARCHAR2 3 Whether the transaction is compliant
is_created_from_merge VARCHAR2 3 Whether the transaction was created from a merge
is_cross_sub_transactions VARCHAR2 3 Whether the transaction is a cross-subsidiary transaction
is_finance_charge VARCHAR2 3 Is finance charge line
is_firmed VARCHAR2 3 Whether the transaction is in the Firmed status
is_in_transit_payment VARCHAR2 3 Whether the payment is in transit
is_intercompany VARCHAR2 3 Whether the transaction is an intercompany transaction
is_merged_into_arrangements VARCHAR2 3 Whether the transaction is to be merged into arrangements
is_non_posting VARCHAR2 3 Whether the transaction is non-posting
is_override_installments VARCHAR2 3 Whether installments have been overridden
is_payment_hold VARCHAR2 3 Whether the transaction has a payment hold
is_recurring_bill VARCHAR2 3 Whether the bill is recurring
is_reversal VARCHAR2 3 Whether the transaction is a reversal
is_tax_point_date_override VARCHAR2 3 Indicates whether the tax point date was set manually by the user
is_tax_reg_override VARCHAR2 3 Whether a tax regulation override is applied
is_wip VARCHAR2 1 Is wip
item_revision NUMBER 39 0 Item revision
job_id NUMBER 39 0 Name / job ID
landed_cost_allocation_method VARCHAR2 8 Cost allocation method (for example: weight, quantity, or value)
last_modified_date TIMESTAMP Date last modified (GMT)
lead_source_id NUMBER 39 0 Lead source ID
location_id NUMBER 39 0 Location ID
memo VARCHAR2 4000 Memo
memorized VARCHAR2 3 Memorized
message VARCHAR2 999 Message
needs_bill VARCHAR2 3 Needs to be billed
needs_revenue_commitment VARCHAR2 3 Needs revenue commitment
number_of_pricing_tiers NUMBER 39 0 Number of pricing tiers
opening_balance_transaction VARCHAR2 3 Opening balance transaction
ownership_transfer_id NUMBER 39 0 Ownership ID
packing_list_instructions VARCHAR2 999 Packing list instructions
partner_id NUMBER 39 0 Partner ID
payment_terms_id NUMBER 39 0 Payment terms ID
pn_ref_num VARCHAR2 100 P/N reference number
probability NUMBER 6 2 Probability
product_label_instructions VARCHAR2 999 Product label instructions
projected_total NUMBER 20 2 Projected total
promotion_code_id NUMBER 39 0 Promotion code ID
promotion_code_instance_id NUMBER 39 0 Promotion code insurance ID
purchase_order_instructions VARCHAR2 999 Purchase order instructions
renewal TIMESTAMP Renewal date
revenue_commitment_status VARCHAR2 480 Revenue committed status
revenue_committed TIMESTAMP Revenue committed
revenue_status VARCHAR2 480 Revenue Status
reversing_transaction_id NUMBER 39 0 Reversing transaction ID
sales_effective_date TIMESTAMP Sales effective date (for commissions)
sales_rep_id NUMBER 39 0 Sales rep ID
scheduling_method_id VARCHAR2 15 Scheduling method ID
shipaddress VARCHAR2 999 Shipping address
shipment_received TIMESTAMP Shipment received
shipping_item_id NUMBER 39 0 Shipping item ID
start_date TIMESTAMP Start date
status VARCHAR2 4000 Status
tax_reg_id NUMBER 39 0 Tax regulation ID. This field is no longer supported.
title VARCHAR2 200 Title
trandate TIMESTAMP Transaction date
tranid VARCHAR2 138 Check or document #
trans_is_vsoe_bundle VARCHAR2 3 Transaction is VSOE bundle
transaction_extid VARCHAR2 255 Transaction external ID
transaction_id NUMBER 39 0 Internal transaction ID
transaction_number VARCHAR2 138 Transaction number
transaction_partner VARCHAR2 40 Transaction partner
transaction_source VARCHAR2 4000 Source of transaction (name of web site if source is web store)
transaction_type VARCHAR2 192 Transaction type
transaction_website NUMBER 39 0 Numerical ID of source web site
transfer_location NUMBER 39 0 Transfer location
use_item_cost_as_transfer_cost VARCHAR2 3 Whether the Use Item Cost as Transfer Cost preference applies to the transaction
visible_in_customer_center VARCHAR2 1 Visible in the Customer Center
weighted_total NUMBER 39 0 Weighted total

Primary key

PK Column Name
transaction_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
transactions_accounts_fk acct_corp_card_expenses_id Accounts account_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Amortization_sched_lines_transactions_fk transaction_id Amortization_sched_lines journal_id 1
Billing_subscription_lines_transactions_fk transaction_id Billing_subscription_lines purchase_order_id 1
Billing_subscription_lines_transactions_fk_2 transaction_id Billing_subscription_lines sales_order_id 1
Billing_subscriptions_transactions_fk transaction_id Billing_subscriptions sales_order_id 1
Campaignresponsehistory_transactions_fk transaction_id Campaignresponsehistory transaction_id 1
Employee_time_transactions_fk transaction_id Employee_time transaction_id 1
Expense_plan_lines_transactions_fk transaction_id Expense_plan_lines journal_id 1
Expense_plans_transactions_fk transaction_id Expense_plans related_revenue_arrangement_id 1
Expense_reports_transactions_fk transaction_id Expense_reports expense_report_id 1
Notes_user_transactions_fk transaction_id Notes_user transaction_id 1
Opportunities_transactions_fk transaction_id Opportunities reversing_transaction_id 1
Revenue_plan_lines_transactions_fk transaction_id Revenue_plan_lines journal_id 1
Revenue_plan_version_lines_transactions_fk transaction_id Revenue_plan_version_lines journal_id 1
Revrecschedulelines_transactions_fk transaction_id Revrecschedulelines journal_id 1
System_notes_custom_transactions_fk transaction_id System_notes_custom transaction_id 1
System_notes_transactions_fk transaction_id System_notes transaction_id 1
Transaction_address_transactions_fk transaction_id Transaction_address transaction_id 1
Transaction_book_map_transactions_fk transaction_id Transaction_book_map transaction_id 1
Transaction_history_transactions_fk transaction_id Transaction_history transaction_id 1
Transaction_lines_transactions_fk transaction_id Transaction_lines transaction_id 1
Transaction_links_applied_transactions_fk transaction_id Transaction_links applied_transaction_id 1
Transaction_links_original_transactions_fk transaction_id Transaction_links original_transaction_id 1
Transaction_shipping_groups_transactions_fk transaction_id Transaction_shipping_groups transaction_id 1

This table is included in the following domains

Domains
Campaignevents
Expense_amortization
General_accounting
Invoice_with_amortization
Multibooks
Revenue_recognition

Domain diagrams

Campaignevents
Expense_amortization
General_accounting
Invoice_with_amortization
Multibooks
Revenue_recognition