Transaction_lines

The Transaction Column Fields custom field is available for the Transaction Lines table.

Important: Credit and debit amounts are not exposed as columns in the Transaction Lines table. However, you can query this table to obtain transaction credit and debit amounts.
Important: Dates and times exposed in the date_last_modified column may be incorrect. For accurate date and time information, include the date_last_modified_gmt column in your query of TRANSACTION_LINES.
Note: To obtain landed cost category names, you can include the memo column in your query of TRANSACTION_LINES. For each line where is_landed_cost is set to True, text is written to this column in the format <Landed Cost Category Name>:<Item Name>.


Related Links:
Linking Gift Certificates to Transaction Line Items
Connect Access to Transaction Credit and Debit Amounts

Columns

Name Type Length Precision Scale References In Description
account_id NUMBER 39 0 account_id
Accounts
Account ID
alt_sales_amount NUMBER 20 2 Alt sales amount
amortization_residual VARCHAR2 42 Amortization residual
amount NUMBER 20 2 Amount
amount_foreign NUMBER 20 2 Foreign currency amount
amount_foreign_linked NUMBER 30 15 Foreign currency amount linked
amount_linked NUMBER 20 2 Amount linked
amount_pending NUMBER 20 2 Amount pending
amount_settlement NUMBER 20 2 Amount settlement
amount_taxable NUMBER 20 2 Amount taxable
amount_taxed NUMBER 20 2 Amount taxed
bill_variance_status VARCHAR2 50 Bill variance status
billing_schedule_id NUMBER 39 0 billing_schedule_id
Billing_schedule_descriptions
Billing schedule ID
bom_quantity NUMBER 12 5 Bom quantity
catch_up_period_id NUMBER 39 0 Catch-up period ID
charge_type NUMBER 39 0 Charge type
class_id NUMBER 39 0 Class ID
company_id NUMBER 39 0 Company ID
component_id NUMBER 39 0 Component ID
component_yield NUMBER 39 0 Component yield
cost_estimate_type VARCHAR2 200 Cost estimate type
date_cleared TIMESTAMP Date cleared
date_closed TIMESTAMP Date closed
date_created TIMESTAMP
date_last_modified TIMESTAMP Date last modified (Values exposed in this column may be inaccurate. Use date_last_modified_gmt instead.)
date_last_modified_gmt TIMESTAMP Date last modified in GMT format
date_revenue_committed TIMESTAMP Date revenue committed
delay_rev_rec VARCHAR2 3 Delay revenue recognition
department_id NUMBER 39 0 Department ID
do_not_display_line VARCHAR2 3 Do not display line
do_not_print_line VARCHAR2 3 Do not print line
do_restock VARCHAR2 3 Do restock
estimated_cost NUMBER 20 2 Estimated cost
estimated_cost_foreign NUMBER 20 2 Estimated cost in foreign currency
expected_receipt_date TIMESTAMP Expected receipt date
expense_category_id NUMBER 39 0 Expense category ID
gl_number VARCHAR2 80 GL number
gl_sequence VARCHAR2 31 GL sequence
gl_sequence_id NUMBER 39 0 GL sequence ID
gross_amount NUMBER 39 0 Gross amount
has_cost_line VARCHAR2 3 Has cost line
is_allocation VARCHAR2 1 Is allocation
is_amortization_rev_rec VARCHAR2 3 Is amortization revenue recognition
is_commitment_confirmed VARCHAR2 3 Is commitment confirmed
is_cost_line VARCHAR2 3 Is cost line
is_exclude_from_rate_request VARCHAR2 3 Is excluded from rate request
is_fx_variance VARCHAR2 3 Whether is foreign exchange variance
is_item_value_adjustment VARCHAR2 3 Is item value adjustment
is_landed_cost VARCHAR2 3 Boolean indicating whether line is a landed cost(See note below regarding landed cost category.)
is_scrap VARCHAR2 3 Is scrap
is_vsoe_allocation_line VARCHAR2 3 Line is VSOE allocation
isbillable VARCHAR2 3 Billable
iscleared VARCHAR2 3 Is cleared
isnonreimbursable VARCHAR2 3 Is non-reinbursable
istaxable VARCHAR2 3 Taxable
item_count NUMBER 18 8 Item count
item_id NUMBER 39 0 Item ID
item_received VARCHAR2 3 Item received
item_source VARCHAR2 30 Item source
item_unit_price VARCHAR2 42 Item unit price
kit_part_number NUMBER 39 0 Kit name/number
landed_cost_source_line_id NUMBER 38 0 transaction_line_id for the transaction to which this landed cost line is attached
location_id NUMBER 39 0 Location ID
match_bill_to_receipt VARCHAR2 1 Match bill to receipt
memo VARCHAR2 4000 Memo
needs_revenue_element VARCHAR2 3 Needs revenue element
net_amount NUMBER 39 0 Net amount
net_amount_foreign NUMBER 39 0 Net amount in foreign currency
non_posting_line VARCHAR2 3 Non posting line
number_billed NUMBER 18 8 Number billed
operation_sequence_number NUMBER 39 0 Operation sequence number
order_priority NUMBER 20 2 Order priority
payment_method_id NUMBER 39 0 Payment method ID
payroll_item_id NUMBER 39 0 Payroll item ID
payroll_wage_base_amount NUMBER 20 2 Payroll wage base amount
payroll_year_to_date_amount NUMBER 20 2 Payroll YTD amount
period_closed TIMESTAMP Period closed
price_type_id NUMBER 39 0 Price type ID
project_task_id NUMBER 39 0 Project task ID
purchase_contract_id NUMBER 39 0 Purchase contract ID
quantity_committed NUMBER 30 15 Quantity committed
quantity_packed NUMBER 18 8 Quantity packed
quantity_picked NUMBER 18 8 Quantity picked
quantity_received_in_shipment NUMBER 18 8 Quantity received in shipment
receivebydate TIMESTAMP Receive by date
reimbursement_type VARCHAR2 41 Reimbursement type
rev_rec_end_date TIMESTAMP Revenue recognition end date
rev_rec_rule_id NUMBER 39 0 Revenue recognition rule ID
rev_rec_start_date TIMESTAMP Revenue recognition start date
revenue_element_id NUMBER 39 0 Revenue element ID
schedule_id NUMBER 39 0 Revenue recognition schedule ID or amortization schedule ID
shipdate TIMESTAMP Ship date
shipment_received TIMESTAMP Shipment received
shipping_group_id NUMBER 39 0 shipping_group_id
Transaction_shipping_groups
Shipping group ID
subscription_line_id NUMBER 39 0 Subscription line ID
subsidiary_id NUMBER 39 0 Subsidiary ID
tax_item_id NUMBER 39 0 Tax item ID
tax_type VARCHAR2 64 Tax type
term_in_months NUMBER 39 0 Term in months
tobeemailed VARCHAR2 3 To be emailed
tobefaxed VARCHAR2 3 To be faxed
tobeprinted VARCHAR2 3 To be printed
transaction_discount_line VARCHAR2 3 Transaction discount line
transaction_id NUMBER 39 0 transaction_id
transaction_id
Transactions
Transaction_shipping_groups
Transaction ID
transaction_line_id NUMBER 39 0 Transaction line ID
transaction_order NUMBER 39 0 Transaction order
transfer_order_item_line NUMBER 39 0 Transfer order item line
transfer_order_line_type VARCHAR2 25 Transfer order line type
unique_key NUMBER 39 0
unit_cost_override NUMBER 30 15 Unit cost override
unit_of_measure_id NUMBER 39 0 Unit of measure ID
vsoe_allocation NUMBER 20 2 VSOE allocation
vsoe_amt NUMBER 20 2 VSOE amount
vsoe_deferral VARCHAR2 28 VSOE deferral
vsoe_delivered VARCHAR2 3 VSOE delivered
vsoe_discount VARCHAR2 12 VSOE discount
vsoe_price NUMBER 30 15 VSOE price

Primary key (Composite)

PK Column Name
transaction_id
transaction_line_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
transaction_lines_accounts_fk account_id Accounts account_id 1
transaction_lines_billing_schedule_descriptions_fk billing_schedule_id Billing_schedule_descriptions billing_schedule_id 1
transaction_lines_transaction_shipping_groups_fk transaction_id Transaction_shipping_groups transaction_id 1
transaction_lines_transaction_shipping_groups_fk shipping_group_id Transaction_shipping_groups shipping_group_id 2
transaction_lines_transactions_fk transaction_id Transactions transaction_id 1

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Notes_system_custom_transaction_lines_fk transaction_id Notes_system_custom line_transaction_id 1
Notes_system_custom_transaction_lines_fk transaction_line_id Notes_system_custom line_id 2
Notes_system_transaction_lines_fk transaction_id Notes_system line_transaction_id 1
Notes_system_transaction_lines_fk transaction_line_id Notes_system line_id 2
System_notes_custom_transaction_lines_fk transaction_id System_notes_custom line_transaction_id 1
System_notes_custom_transaction_lines_fk transaction_line_id System_notes_custom line_id 2
System_notes_transaction_lines_fk transaction_id System_notes line_transaction_id 1
System_notes_transaction_lines_fk transaction_line_id System_notes line_id 2
Transaction_line_book_map_transaction_lines_fk transaction_id Transaction_line_book_map transaction_id 1
Transaction_line_book_map_transaction_lines_fk transaction_line_id Transaction_line_book_map transaction_line_id 2
Transaction_links_applied_transaction_lines_fk transaction_id Transaction_links applied_transaction_id 1
Transaction_links_applied_transaction_lines_fk transaction_line_id Transaction_links applied_transaction_line_id 2
Transaction_links_original_transaction_lines_fk transaction_id Transaction_links original_transaction_id 1
Transaction_links_original_transaction_lines_fk transaction_line_id Transaction_links original_transaction_line_id 2
Transaction_tax_detail_transaction_lines_fk transaction_id Transaction_tax_detail transaction_id 1
Transaction_tax_detail_transaction_lines_fk transaction_line_id Transaction_tax_detail transaction_line_id 2

This table is included in the following domains

Domains
Expense_amortization
General_accounting
Invoice_with_amortization
Multibooks
Revenue_recognition

Domain diagrams

Expense_amortization
General_accounting
Invoice_with_amortization
Multibooks
Revenue_recognition