1. Tables and Views for Financials
  2. RA_CUSTOMER_TRX_LINES_ALL

RA_CUSTOMER_TRX_LINES_ALL

The RA_CUSTOMER_TRX_LINES_ALL table stores line information about invoices, debit memos, credit memos, and bills receivable. For example, an invoice can have one line for Product A and another line for Product B. Each line requires one row in this table. Invoices, debit memos, credit memos, and bills receivable distinguished by the transaction type of the corresponding row in the RA_CUSTOMER_TRX_ALL table. Credit memos must also have a value in the PREVIOUS_CUSTOMER_TRX_LINE_ID column. On-account credits, which are not related to specific invoices or invoice lines when they are created, will not have values in this column. The QUANTITY_ORDERED column stores the amount of product that was ordered. The QUANTITY_INVOICED column stores the amount of product that was invoiced. For manually entered invoices, the QUANTITY_ORDERED and QUANTITY_INVOICED columns must be the same. For invoices that were imported through AutoInvoice, the QUANTITY_ORDERED and QUANTITY_INVOICED columns can be different. If you enter a credit memo, the QUANTITY_CREDITED column stores the amount of product that was credited. The UOM_CODE column stores the unit of measure code as defined in the INV_UNITS_OF_MEASURE table. The UNIT_STANDARD_PRICE column stores the list price per unit for this transaction line. The UNIT_SELLING_PRICE column stores the selling price per unit for this transaction line. For transactions that were imported through AutoInvoice, the UNIT_STANDARD_PRICE and UNIT_SELLING_PRICE columns can be different. The DESCRIPTION, TAXING_RULE, QUANTITY_ORDERED, UNIT_STANDARD_PRICE, UOM_CODE, and UNIT_SELLING_PRICE columns are required even though they are null allowed. Receivables uses the LINE_TYPE column to distinguish between the different types of lines. LINE represents regular invoice lines that normally refer to an item. TAX represents a tax line. The LINK_TO_CUST_TRX_LINE_ID column references the invoice line that is associated with the row that holds the TAX line type. FREIGHT is similar to TAX, but you can have at most one freight line per invoice line. You can also have one freight line that has a null LINK_TO_CUST_TRX_LINE_ID column. An invoice that has one freight line with a null LINK_TO_CUST_TRX_LINE_ID column has header-level freight. CB represents a chargeback line. For every row in this table that belongs to a completed postable or nonpostable transaction, where the RA_CUSTOMER_TRX.COMPLETE_FLAG is Y, there must be at least one row in the RA_CUST_TRX_LINE_GL_DIST table that stores accounting information. There must be at least one row in this table even for nonpostable transactions. The primary key for this table is CUSTOMER_TRX_LINE_ID.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

RA_CUSTOMER_TRX_LINES_PK

CUSTOMER_TRX_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
CUSTOMER_TRX_LINE_ID NUMBER 18 Yes Transaction line identifier.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CUSTOMER_TRX_ID NUMBER 18 Yes Transaction identifier. Active
LINE_NUMBER NUMBER Yes Transaction line number. Active
SET_OF_BOOKS_ID NUMBER 18 Yes Identifies the ledger associated with the transaction line. Active
REASON_CODE VARCHAR2 30 Transaction line reason code. Active
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier. Mutually exclusive with the column MEMO_LINE_ID. Active
DESCRIPTION VARCHAR2 240 Line description Active
PREVIOUS_CUSTOMER_TRX_ID NUMBER 18 Credit memo's invoice identifier Active
PREVIOUS_CUSTOMER_TRX_LINE_ID NUMBER 18 Credit memo line's invoice line identifier
QUANTITY_ORDERED NUMBER Quantity of an order Active
QUANTITY_CREDITED NUMBER Quantity credited Active
QUANTITY_INVOICED NUMBER Quantity of invoice line Items (RA_CUSTOMER_TRX_LINES_ITEMS) Active
UNIT_STANDARD_PRICE NUMBER List price per unit. Price is gross of inclusive taxes. There is no separate gross standard price. Active
UNIT_SELLING_PRICE NUMBER Selling price per unit for a transaction line Items (RA_CUSTOMER_TRX_LINES_ITEMS) Active
SALES_ORDER VARCHAR2 50 Sales order Active
SALES_ORDER_REVISION NUMBER Not currently used Active
SALES_ORDER_LINE VARCHAR2 30 Sales order line Active
SALES_ORDER_DATE DATE Sales order date Active
ACCOUNTING_RULE_ID NUMBER 18 Accounting rule identifier Active
ACCOUNTING_RULE_DURATION NUMBER 18 The number of periods in which revenue is to be recognized. Must be filled in for lines with fixed and variable duration rules. Active
LINE_TYPE VARCHAR2 20 Yes Receivables lookup code for STD_LINE_TYPE Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
PROGRAM_APPLICATION_ID NUMBER 18 Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). Active
PROGRAM_ID NUMBER 18 Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). Active
PROGRAM_UPDATE_DATE DATE Concurrent Program who column - date when a program last updated this row). Active
RULE_START_DATE DATE First GL date of the invoice. Only used for invoice with rules Active
INITIAL_CUSTOMER_TRX_LINE_ID NUMBER 18 Identifies the initial transaction line for the customer
INTERFACE_LINE_CONTEXT VARCHAR2 30 Interface line context Active
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 30 Interface line attribute value Active
SALES_ORDER_SOURCE VARCHAR2 50 The source of the sales order Active
TAXABLE_FLAG VARCHAR2 1 Not currently used. Active
EXTENDED_AMOUNT NUMBER Yes Transaction line amount Active
REVENUE_AMOUNT NUMBER Transaction line revenue amount Active
AUTORULE_COMPLETE_FLAG VARCHAR2 1 Indicates if all account assignments have been created. Y for yes, N otherwise. Active
LINK_TO_CUST_TRX_LINE_ID NUMBER 18 Link to transaction line identifier Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoice Lines (RA_CUSTOMER_TRX_LINES) Active
TAX_PRECEDENCE NUMBER Tax precedence for a tax line Active
TAX_RATE NUMBER Tax rate for a line Active
ITEM_EXCEPTION_RATE_ID NUMBER 18 Tax exception identifier Active
TAX_EXEMPTION_ID NUMBER 18 Tax exemption identifier Active
AUTORULE_DURATION_PROCESSED NUMBER 18 Number of times revenue recognition has created distributions for the line Active
UOM_CODE VARCHAR2 3 Unit of measure code Items (RA_CUSTOMER_TRX_LINES_ITEMS) Active
DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2 30 Default value for the USSGL Transaction Code Flexfield Government Transaction Lines (RA_CUSTOMER_TRX_LINES_GOV)
DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2 30 Default context value for the USSGL Transaction Code Flexfield Government Transaction Lines (RA_CUSTOMER_TRX_LINES_GOV)
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 30 Interface line attribute value Active
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 30 Interface line attribute value Active
VAT_TAX_ID NUMBER 18 Unique identifier for AR_VAT_TAX Active
AUTOTAX VARCHAR2 1 Indicates if this tax line was generated automatically by the tax engine. Y for yes, N otherwise. Active
LAST_PERIOD_TO_CREDIT NUMBER Last period to credit for unit credit memos against invoices with rules Active
ITEM_CONTEXT VARCHAR2 30 Descriptive Flexfield structure defining column Items (RA_CUSTOMER_TRX_LINES_ITEMS) Active
TAX_EXEMPT_FLAG VARCHAR2 1 Tax Lines are controlled by the lookup (TAX_CONTROL_FLAG), which allows for standard tax, exempt tax, and required tax. Active
TAX_EXEMPT_NUMBER VARCHAR2 80 Exemption certificate number for item lines that have TAX_EXEMPT_FLAG set to E for exempt Active
TAX_EXEMPT_REASON_CODE VARCHAR2 30 Tax Exempt Reason, for item lines that have tax_exempt_flag set to "E" (exempt) Active
TAX_VENDOR_RETURN_CODE VARCHAR2 30 Warning code returned during vendor calculation of a sales tax rate, used for diagnostics and support. Active
SALES_TAX_ID NUMBER 18 Not currently used in the production release - replaced by location_segment_id Active
LOCATION_SEGMENT_ID NUMBER 18 This column points to the record in the AR_LOCATION_VALUES table from which AutoAccounting derived the tax account for this line Active
MOVEMENT_ID NUMBER 18 Intrastat movement identification number. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
WH_UPDATE_DATE DATE Date sent to data warehouse Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GROSS_UNIT_SELLING_PRICE NUMBER Unit selling price inclusive of tax amounts Active
GROSS_EXTENDED_AMOUNT NUMBER Amount gross of inclusive tax amounts Active
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 1 Yes or No flag that indicates if the tax is inclusive or exclusive. Yes (Y) indicates tax is inclusive, No (N) indicates tax is exclusive, and NULL for lines indicates that you cannot override tax or tax group. The value cannot be NULL for tax types. Active
TAXABLE_AMOUNT NUMBER The taxable amount for lines of the tax type that are tax inclusive Active
WAREHOUSE_ID NUMBER 18 Foreign key to the HR_ORGANIZATIONS table. The warehouse identifies the ship-from location and can be used to control taxation. Within the US, the Warehouse ID is important when calculating tax on the origin/modified origin state sales tax. Outside the US you can use tax groups and conditions to build a schedule of multiple conditional taxes based on both the ship-from and ship-to county/county/state or provinces. Active
TRANSLATED_DESCRIPTION VARCHAR2 1000 Translated description of this transaction line. Active
EXTENDED_ACCTD_AMOUNT NUMBER Transaction line amount in functional currency for bills receivable Active
BR_REF_CUSTOMER_TRX_ID NUMBER 18 Identifier of a transaction to which the bill receivable is applied. Active
BR_REF_PAYMENT_SCHEDULE_ID NUMBER 18 Identifier of a transaction installment to which the bill receivable is applied. Active
BR_ADJUSTMENT_ID NUMBER 18 Identifier of a non-accounting adjustment created when a bill receivable is applied to an existing bill receivable. Active
MRC_EXTENDED_ACCTD_AMOUNT VARCHAR2 2000 Not currently used. Active
PAYMENT_SET_ID NUMBER 18 Identifies the prepayment application's payment set Active
CONTRACT_LINE_ID NUMBER Identifies the contract line from Oracle Contracts Core that is associated with this line Active
SOURCE_DATA_KEY1 VARCHAR2 150 Identifies source data from original system Active
SOURCE_DATA_KEY2 VARCHAR2 150 Identifies source data from original system Active
SOURCE_DATA_KEY3 VARCHAR2 150 Identifies source data from original system Active
SOURCE_DATA_KEY4 VARCHAR2 150 Identifies source data from original system Active
SOURCE_DATA_KEY5 VARCHAR2 150 Identifies source data from original system Active
INVOICED_LINE_ACCTG_LEVEL VARCHAR2 15 Identifies accounting level for lines eligible for invoice in original system. Active
OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 1 Flag provided by the source system indicating if AutoAccounting should overridden.
SHIP_TO_CUSTOMER_ID NUMBER 18 Identifies ship-to customer Active
SHIP_TO_ADDRESS_ID NUMBER 18 Identifies ship-to address Active
SHIP_TO_SITE_USE_ID NUMBER 18 Identifies ship-to site Active
SHIP_TO_CONTACT_ID NUMBER 18 Identifies ship-to contact or recipient Active
HISTORICAL_FLAG VARCHAR2 1 Yes, No, or NULL flag indicates if the transaction line exists prior to EBS release 12. Active
TAX_LINE_ID NUMBER 18 Identifies the detail tax line in ZX_LINES table that corresponds to this tax line. Active
LINE_RECOVERABLE NUMBER Transaction line amount which is considered to be recoverable during tax calculation. Active
TAX_RECOVERABLE NUMBER Total tax recovery amount used for tax calculations. Active
TAX_CLASSIFICATION_CODE VARCHAR2 30 Tax determining attribute used at transaction line level. Active
AMOUNT_DUE_REMAINING NUMBER remaining balance Active
ACCTD_AMOUNT_DUE_REMAINING NUMBER accounted remaining balance Active
AMOUNT_DUE_ORIGINAL NUMBER original balance Active
CHRG_AMOUNT_REMAINING NUMBER charges balance on revenue line Active
CHRG_ACCTD_AMOUNT_REMAINING NUMBER accounted charges balance on revenue line Active
FRT_ADJ_REMAINING NUMBER freight adjusted amount on revenue line Active
FRT_ADJ_ACCTD_REMAINING NUMBER freight adjusted accounted amount on revenue line. Active
FRT_ED_AMOUNT NUMBER earned discount on freight assigned to the revenue line. Active
FRT_ED_ACCTD_AMOUNT NUMBER earned accounted discount on freight assigned to the revenue line. Active
FRT_UNED_AMOUNT NUMBER unearned discount on freight assigned to the revenue line. Active
FRT_UNED_ACCTD_AMOUNT NUMBER unearned accounted discount on freight assigned to the revenue line. Active
DEFERRAL_EXCLUSION_FLAG VARCHAR2 1 Excludes line from automated revenue deferral Active
ACCTD_AMOUNT_DUE_ORIGINAL NUMBER accounted original balance Active
RULE_END_DATE DATE Last GL date of the invoice. Only used for invoice Active
PAYMENT_TRXN_EXTENSION_ID NUMBER 18 Oracle Payments transaction identifier for processing a credit card or bank account payment. Active
INTEREST_LINE_ID NUMBER 18 Foreign key for late charge. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
MEMO_LINE_SEQ_ID NUMBER 18 Memo line sequence identifier. Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction business category tax determinant. Active
USER_DEFINED_FISC_CLASS VARCHAR2 30 User defined fiscal classification tax determinant. Active
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product fiscal classification tax determinant. Active
LINE_INTENDED_USE VARCHAR2 240 Transaction line intended use tax determinant. Active
PRODUCT_TYPE VARCHAR2 240 Product type tax determinant. Active
PRODUCT_CATEGORY VARCHAR2 240 Product category tax determinant. Active
ASSESSABLE_VALUE NUMBER Assessable value tax determinant. Active
SOURCE_DOCUMENT_LINE_NUMBER VARCHAR2 240 Source Document Line Number Active
SOURCE_DOCUMENT_LINE_ID NUMBER 18 Source Document Line Identifier Active
FAIR_MARKET_VALUE_AMOUNT NUMBER Fair market value amount. Active
LINK_TO_PARENTLINE_CONTEXT VARCHAR2 240 Link to parent line to derive its contingency information. Active
LINK_TO_PARENTLINE_ATTRIBUTE1 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE2 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE3 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE4 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE5 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE6 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE7 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE8 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE9 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE10 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE11 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE12 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE13 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE14 VARCHAR2 240 Link to parent line to derive its contingency information.
LINK_TO_PARENTLINE_ATTRIBUTE15 VARCHAR2 240 Link to parent line to derive its contingency information.
TAX_ACTION VARCHAR2 10 This column will store Tax Action values of CREATE, UPDATE that is used by calculate tax api
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
REQUIRES_MANUAL_SCHEDULING VARCHAR2 1 REQUIRES_MANUAL_SCHEDULING
TAX_INVOICE_NUMBER VARCHAR2 150 Number on Fiscal document generated during shipment of goods
TAX_INVOICE_DATE DATE Date on Fiscal document generated during shipment of goods
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 End final discharge point or final customer location where shipment will be sent
AUTHORIZATION_NUMBER VARCHAR2 30 Credit check authorization number linked to the invoice.
AUTH_COMPLETE_FLAG VARCHAR2 1 Indicates whether credit check authorization is complete.
SHIP_TO_PARTY_ID NUMBER 18 Identifier of the ship-to party.
SHIP_TO_PARTY_CONTACT_ID NUMBER 18 Identifier of the ship-to party contact.
SHIP_TO_PARTY_SITE_USE_ID NUMBER 18 Identifier of the ship-to party site use.
SHIP_TO_PARTY_ADDRESS_ID NUMBER 18 Identifier of the ship-to party address.
DOC_LINE_ID_INT_1 NUMBER Source document line unique identifier.
DOC_LINE_ID_INT_2 NUMBER Source document line unique identifier.
DOC_LINE_ID_INT_3 NUMBER Source document line unique identifier.
DOC_LINE_ID_INT_4 NUMBER Source document line unique identifier.
DOC_LINE_ID_INT_5 NUMBER Source document line unique identifier.
DOC_LINE_ID_CHAR_1 VARCHAR2 30 Unique identifier of the source document line.
DOC_LINE_ID_CHAR_2 VARCHAR2 30 Unique identifier of the source document line.
DOC_LINE_ID_CHAR_3 VARCHAR2 30 Unique identifier of the source document line.
DOC_LINE_ID_CHAR_4 VARCHAR2 30 Unique identifier of the source document line.
DOC_LINE_ID_CHAR_5 VARCHAR2 30 Unique identifier of the source document line.
RECURRING_BILL_FLAG VARCHAR2 1 Option that indicates whether the line is for a recurring invoice. Valid values are Y, N, null. Null is the same as N.
CONTRACT_START_DATE DATE The start date of the contract, if the transaction line is associated with a contract.
CONTRACT_END_DATE DATE The end date of the contract, if the transaction line is associated with a contract.
RECURRING_BILL_PLAN_ID NUMBER 18 Unique identifier for the recurring bill plan associated with the invoice.
BILLING_PERIOD_START_DATE DATE The start date of the billing period associated with the invoice.
BILLING_PERIOD_END_DATE DATE The end date of the billing period associated with the invoice.
RECURRING_BILL_PLAN_LINE_ID NUMBER 18 Unique identifier for the recurring bill plan line associated with the credit memo.
BILL_PLAN_LINE_ID NUMBER 18 Identifier of the recurring bill plan line.
FREIGHT_CHARGE NUMBER Freight amount charged to the customer for the sale of item on the line.
INSURANCE_CHARGE NUMBER Insurance amount charged to the customer for the sale of item on the line.
PACKING_CHARGE NUMBER Packing amount charged to the customer for the sale of item on the line.
MISCELLANEOUS_CHARGE NUMBER Other charge amount charged to the customer for the sale of item on the line.
COMMERCIAL_DISCOUNT NUMBER Commercial discount extended to the customer for the purchase of the item on the line.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
PREPAY_CUSTOMER_TRX_ID NUMBER 18 Oracle internal use only. Prepayment customer transaction identifier. Active
PREPAY_CUSTOMER_TRX_LINE_ID NUMBER 18 Oracle internal use only. Prepayment customer transaction line identifier.
REMAINING_PREPAY_AMOUNT NUMBER Remaining prepayment amount against the prepayment transaction line. Active

Foreign Keys

Table Foreign Table Foreign Key Column
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_all PREVIOUS_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_lines_all INITIAL_CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_lines_all LINK_TO_CUST_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_lines_all PREVIOUS_CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL hz_cust_accounts SHIP_TO_CUSTOMER_ID
RA_CUSTOMER_TRX_LINES_ALL hz_cust_account_roles SHIP_TO_CONTACT_ID
RA_CUSTOMER_TRX_LINES_ALL iby_fndcpt_tx_extensions PAYMENT_TRXN_EXTENSION_ID
RA_CUSTOMER_TRX_LINES_ALL ar_interest_lines_all INTEREST_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL hz_cust_acct_sites_all SHIP_TO_ADDRESS_ID
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_all CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_ALL zx_lines TAX_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL hz_parties SHIP_TO_PARTY_ID
RA_CUSTOMER_TRX_LINES_ALL hz_party_site_uses SHIP_TO_PARTY_SITE_USE_ID
RA_CUSTOMER_TRX_LINES_ALL hz_party_sites SHIP_TO_PARTY_ADDRESS_ID
RA_CUSTOMER_TRX_LINES_ALL ra_recurring_bill_plans RECURRING_BILL_PLAN_ID
RA_CUSTOMER_TRX_LINES_ALL ra_recurring_bill_plan_lines RECURRING_BILL_PLAN_LINE_ID
RA_CUSTOMER_TRX_LINES_ALL ra_rules ACCOUNTING_RULE_ID
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_all PREPAY_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_ALL ra_customer_trx_lines_all PREPAY_CUSTOMER_TRX_LINE_ID
ar_adjustments_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_revenue_adjustments_all ra_customer_trx_lines_all FROM_CUST_TRX_LINE_ID
ar_revenue_adjustments_all ra_customer_trx_lines_all TO_CUST_TRX_LINE_ID
ra_cust_trx_line_gl_dist_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_ramc_audit_trail ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_activity_details ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_credit_memo_amounts ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
jl_br_ar_comp_inv_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ra_cm_request_lines_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_deferred_lines_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ra_interface_lines_all ra_customer_trx_lines_all REFERENCE_LINE_ID
ra_interface_lines_all ra_customer_trx_lines_all SOURCE_TRX_LINE_ID
ra_interface_lines_all ra_customer_trx_lines_all PREPAY_CUSTOMER_TRX_LINE_ID
ar_line_conts_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_cons_inv_trx_lines_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ar_interim_cash_rcpt_lines_all ra_customer_trx_lines_all CUSTOMER_TRX_LINE_ID
ra_customer_trx_lines_all ra_customer_trx_lines_all INITIAL_CUSTOMER_TRX_LINE_ID
ra_customer_trx_lines_all ra_customer_trx_lines_all LINK_TO_CUST_TRX_LINE_ID
ra_customer_trx_lines_all ra_customer_trx_lines_all PREVIOUS_CUSTOMER_TRX_LINE_ID
ra_customer_trx_lines_all ra_customer_trx_lines_all PREPAY_CUSTOMER_TRX_LINE_ID
ar_receivable_applications_all ra_customer_trx_lines_all APPLIED_CUSTOMER_TRX_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
RA_CUSTOMER_TRX_LINES_N1 Non Unique FUSION_TS_TX_IDX PREVIOUS_CUSTOMER_TRX_LINE_ID Active
RA_CUSTOMER_TRX_LINES_N10 Non Unique FUSION_TS_TX_IDX BR_REF_CUSTOMER_TRX_ID Active
RA_CUSTOMER_TRX_LINES_N11 Non Unique FUSION_TS_TX_IDX BR_REF_PAYMENT_SCHEDULE_ID Active
RA_CUSTOMER_TRX_LINES_N12 Non Unique FUSION_TS_TX_IDX BR_ADJUSTMENT_ID Active
RA_CUSTOMER_TRX_LINES_N13 Non Unique FUSION_TS_TX_DATA INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3, INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5, INTERFACE_LINE_ATTRIBUTE6, INTERFACE_LINE_ATTRIBUTE7, INTERFACE_LINE_ATTRIBUTE8, INTERFACE_LINE_ATTRIBUTE9, INTERFACE_LINE_ATTRIBUTE10, INTERFACE_LINE_ATTRIBUTE11, INTERFACE_LINE_ATTRIBUTE12, INTERFACE_LINE_ATTRIBUTE13, INTERFACE_LINE_ATTRIBUTE14, INTERFACE_LINE_ATTRIBUTE15
RA_CUSTOMER_TRX_LINES_N14 Non Unique Default REQUIRES_MANUAL_SCHEDULING
RA_CUSTOMER_TRX_LINES_N2 Non Unique FUSION_TS_TX_IDX CUSTOMER_TRX_ID, LINE_NUMBER Active
RA_CUSTOMER_TRX_LINES_N3 Non Unique FUSION_TS_TX_IDX LINK_TO_CUST_TRX_LINE_ID Active
RA_CUSTOMER_TRX_LINES_N4 Non Unique FUSION_TS_TX_IDX REQUEST_ID, CUSTOMER_TRX_ID, LINE_TYPE Active
RA_CUSTOMER_TRX_LINES_N5 Non Unique FUSION_TS_TX_IDX PREVIOUS_CUSTOMER_TRX_ID Active
RA_CUSTOMER_TRX_LINES_N6 Non Unique FUSION_TS_TX_IDX AUTORULE_COMPLETE_FLAG Active
RA_CUSTOMER_TRX_LINES_N7 Non Unique FUSION_TS_TX_IDX SALES_TAX_ID Active
RA_CUSTOMER_TRX_LINES_N8 Non Unique FUSION_TS_TX_IDX ITEM_EXCEPTION_RATE_ID Active
RA_CUSTOMER_TRX_LINES_N9 Non Unique FUSION_TS_TX_IDX SALES_ORDER Active
RA_CUSTOMER_TRX_LINES_U1 Unique FUSION_TS_TX_IDX CUSTOMER_TRX_LINE_ID Active