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.
Columns
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| account_based_number | VARCHAR2 | 138 | Account based number | ||||
| accounting_book_id | NUMBER | 22 | 0 | Accounting book ID | |||
| accounting_period_id | NUMBER | 22 | 0 | Accounting period ID | |||
| amount_unbilled | NUMBER | 20 | 2 | Amount unbilled | |||
| bill_pay_transaction | VARCHAR2 | 32 | Bill pay transaction | ||||
| billaddress | VARCHAR2 | 999 | Billing address | ||||
| billing_account_id | NUMBER | 22 | 0 | Billing account ID | |||
| billing_instructions | VARCHAR2 | 999 | |||||
| bulk_submission_id | NUMBER | 22 | 0 | ||||
| carrier | VARCHAR2 | 100 | |||||
| closed | TIMESTAMP | Closed | |||||
| company_status_id | NUMBER | 22 | 0 | Company status ID | |||
| create_date | TIMESTAMP | Creation date (GMT) | |||||
| created_by_id | NUMBER | 22 | 0 | ID of the creator | |||
| created_from_id | NUMBER | 22 | 0 | Created from ID | |||
| currency_id | NUMBER | 22 | 0 | Currency ID | |||
| custom_form_id | NUMBER | 22 | 0 | Custom form ID | |||
| date_bid_close | TIMESTAMP | ||||||
| date_bid_open | TIMESTAMP | ||||||
| date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
| due_date | TIMESTAMP | Due date | |||||
| VARCHAR2 | 256 | ||||||
| end_date | TIMESTAMP | End date | |||||
| entity_id | NUMBER | 22 | 0 | Entity ID | |||
| 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 | 300 | Forecast type | ||||
| include_in_forecast | VARCHAR2 | 32 | Include in forecast | ||||
| incoterm | VARCHAR2 | 100 | |||||
| intercompany_transaction_id | NUMBER | 22 | 0 | Intercompany transaction ID | |||
| is_autocalculate_lag | VARCHAR2 | 32 | |||||
| is_compliant | VARCHAR2 | 32 | Whether is compliant | ||||
| is_finance_charge | VARCHAR2 | 32 | Is finance charge line | ||||
| is_firmed | VARCHAR2 | 32 | |||||
| is_intercompany | VARCHAR2 | 32 | Is intercompany | ||||
| is_non_posting | VARCHAR2 | 32 | |||||
| is_payment_hold | VARCHAR2 | 32 | |||||
| is_tax_reg_override | VARCHAR2 | 32 | |||||
| is_wip | VARCHAR2 | 1 | Is wip | ||||
| item_revision | NUMBER | 22 | 0 | Item revision | |||
| job_id | NUMBER | 22 | 0 | Name / job ID | |||
| landed_cost_allocation_method | VARCHAR2 | 32 | Cost allocation method (for example: weight, quantity, or value) | ||||
| last_modified_date | TIMESTAMP | Date last modified (GMT) | |||||
| lead_source_id | NUMBER | 22 | 0 | Lead source ID | |||
| location_id | NUMBER | 22 | 0 | Location ID | |||
| memo | VARCHAR2 | 4000 | Memo | ||||
| memorized | VARCHAR2 | 32 | Memorized | ||||
| message | VARCHAR2 | 999 | Message | ||||
| needs_bill | VARCHAR2 | 32 | Needs to be billed | ||||
| needs_revenue_commitment | VARCHAR2 | 32 | Needs revenue commitment | ||||
| number_of_pricing_tiers | NUMBER | 22 | 0 | ||||
| opening_balance_transaction | VARCHAR2 | 32 | Opening balance transaction | ||||
| packing_list_instructions | VARCHAR2 | 999 | Packing list instructions | ||||
| partner_id | NUMBER | 22 | 0 | Partner ID | |||
| payment_terms_id | NUMBER | 22 | 0 | Payment terms ID | |||
| pn_ref_num | VARCHAR2 | 100 | |||||
| probability | NUMBER | 6 | 2 | Probability | |||
| product_label_instructions | VARCHAR2 | 999 | Product label instructions | ||||
| projected_total | NUMBER | 20 | 2 | Projected total | |||
| promotion_code_id | NUMBER | 22 | 0 | Promotion code ID | |||
| promotion_code_instance_id | NUMBER | 22 | 0 | Promotion code insurance ID | |||
| purchase_order_instructions | VARCHAR2 | 999 | Purchase order instructions | ||||
| related_tranid | VARCHAR2 | 138 | Related transaction ID | ||||
| 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 | 22 | 0 | Reversing transaction ID | |||
| sales_effective_date | TIMESTAMP | Sales effective date (for commissions) | |||||
| sales_rep_id | NUMBER | 22 | 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 | 22 | 0 | Shipping item ID | |||
| start_date | TIMESTAMP | Start date | |||||
| status | VARCHAR2 | 480 | Status | ||||
| tax_reg_id | NUMBER | 22 | 0 | Tax regulation ID | |||
| title | VARCHAR2 | 200 | Title | ||||
| trandate | TIMESTAMP | Transaction date | |||||
| tranid | VARCHAR2 | 138 | Check or document # | ||||
| trans_is_vsoe_bundle | VARCHAR2 | 32 | Transaction is VSOE bundle | ||||
| transaction_extid | VARCHAR2 | 255 | Transaction external ID | ||||
| transaction_id | NUMBER | 22 | 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 | 22 | 0 | Numerical ID of source web site | |||
| transfer_location | NUMBER | 22 | 0 | Transfer location | |||
| visible_in_customer_center | VARCHAR2 | 1 | Visible in the Customer Center | ||||
| weighted_total | NUMBER | 22 | 0 | Weighted total |
Primary key
| PK Column Name |
|---|
| transaction_id |
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 |
| Campaignresponsehistory_transactions_fk | transaction_id | Campaignresponsehistory | transaction_id | 1 |
| Notes_system_custom_transactions_fk | transaction_id | Notes_system_custom | transaction_id | 1 |
| Notes_system_transactions_fk | transaction_id | Notes_system | transaction_id | 1 |
| Notes_user_transactions_fk | transaction_id | Notes_user | transaction_id | 1 |
| Opportunities_transactions_fk | transaction_id | Opportunities | reversing_transaction_id | 1 |
| Revrecschedulelines_transactions_fk | transaction_id | Revrecschedulelines | journal_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_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 |
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
