DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.RA_CUSTOMER_TRX_LINES_ALL

Object Details
Object Name: RA_CUSTOMER_TRX_LINES_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.RA_CUSTOMER_TRX_LINES_ALL
Subobject Name:
Status: VALID


The RA_CUSTOMER_TRX_LINES_ALL table stores information about invoice, debit memo, credit memo, bills receivable, and commitment lines. 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.
.
Invoice, debit memo, credit memo, bills receivable, and commitment lines are 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 MTL_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 that are stored in this table. 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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_CUSTOMER_TRX_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREVIOUS_CUSTOMER_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBR_REF_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBR_REF_PAYMENT_SCHEDULE_ID
RA_CUSTOMER_TRX_LINES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBR_ADJUSTMENT_ID
RA_CUSTOMER_TRX_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
ColumnLINE_NUMBER
RA_CUSTOMER_TRX_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINK_TO_CUST_TRX_LINE_ID
RA_CUSTOMER_TRX_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnCUSTOMER_TRX_ID
ColumnLINE_TYPE
RA_CUSTOMER_TRX_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREVIOUS_CUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUTORULE_COMPLETE_FLAG
ColumnCUSTOMER_TRX_ID
RA_CUSTOMER_TRX_LINES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALES_TAX_ID
RA_CUSTOMER_TRX_LINES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_EXCEPTION_RATE_ID
RA_CUSTOMER_TRX_LINES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALES_ORDER
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_LINE_ID NUMBER (15) Yes Invoice line identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CUSTOMER_TRX_ID NUMBER (15) Yes Invoice identifier
LINE_NUMBER NUMBER
Yes Line number of the invoice
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
REASON_CODE VARCHAR2 (30)
Reason code identifier
INVENTORY_ITEM_ID NUMBER (15)
Inventory item identifier. Mutually exclusive with the column MEMO_LINE_ID.
DESCRIPTION VARCHAR2 (240)
Line description
PREVIOUS_CUSTOMER_TRX_ID NUMBER (15)
Credit memo's invoice identifier
PREVIOUS_CUSTOMER_TRX_LINE_ID NUMBER (15)
Credit memo line's invoice line identifier
QUANTITY_ORDERED NUMBER

Quantity of an order
QUANTITY_CREDITED NUMBER

Quantity credited
QUANTITY_INVOICED NUMBER

Quantity of invoice line
UNIT_STANDARD_PRICE NUMBER

List price per unit. Price is gross of inclusive taxes. There is no separate gross standard price.
UNIT_SELLING_PRICE NUMBER

Selling price per unit for a transaction line
SALES_ORDER VARCHAR2 (50)
Sales order
SALES_ORDER_REVISION NUMBER

Not currently used
SALES_ORDER_LINE VARCHAR2 (30)
Sales order line
SALES_ORDER_DATE DATE

Sales order date
ACCOUNTING_RULE_ID NUMBER (15)
Accounting rule identifier
ACCOUNTING_RULE_DURATION NUMBER (15)
The number of periods in which revenue is to be recognized. Must be filled in for lines with fixed and variable duration rules.
LINE_TYPE VARCHAR2 (20) Yes Receivables lookup code for STD_LINE_TYPE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
RULE_START_DATE DATE

First GL date of the invoice. Only used for invoice with rules
INITIAL_CUSTOMER_TRX_LINE_ID NUMBER (15)
Identifies the initial transaction line for the customer
INTERFACE_LINE_CONTEXT VARCHAR2 (30)
Interface line context
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
Interface line attribute value
SALES_ORDER_SOURCE VARCHAR2 (50)
The source of the sales order
TAXABLE_FLAG VARCHAR2 (1)
No longer used
EXTENDED_AMOUNT NUMBER
Yes Transaction line amount
REVENUE_AMOUNT NUMBER

Transaction line revenue amount
AUTORULE_COMPLETE_FLAG VARCHAR2 (1)
Indicates if all account assignments have been created. Y for yes, N otherwise.
LINK_TO_CUST_TRX_LINE_ID NUMBER (15)
Link to transaction line identifier
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
TAX_PRECEDENCE NUMBER

Tax precedence for a tax line
TAX_RATE NUMBER

Tax rate for a line
ITEM_EXCEPTION_RATE_ID NUMBER (15)
Tax exception identifier
TAX_EXEMPTION_ID NUMBER (15)
Tax exemption identifier
MEMO_LINE_ID NUMBER (15)
Memo line description identifier. Mutually exclusive with the column INVENTORY_ITEM_ID.
AUTORULE_DURATION_PROCESSED NUMBER (15)
Number of times revenue recognition has created distributions for the line
UOM_CODE VARCHAR2 (3)
Unit of measure code
DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2 (30)
Default value for the USSGL Transaction Code Flexfield
DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
Default context value for the USSGL Transaction Code Flexfield
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
Interface line attribute value
VAT_TAX_ID NUMBER (15)
Unique identifier for AR_VAT_TAX
AUTOTAX VARCHAR2 (1)
Indicates if this tax line was generated automatically by the tax engine. Y for yes, N otherwise.
LAST_PERIOD_TO_CREDIT NUMBER

Last period to credit for unit credit memos against invoices with rules
ITEM_CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure defining column
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.
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Exemption certificate number for item lines that have TAX_EXEMPT_FLAG set to E for exempt
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Tax Exempt Reason, for item lines that have tax_exempt_flag set to "E" (exempt)
TAX_VENDOR_RETURN_CODE VARCHAR2 (30)
Warning code returned during vendor calculation of a sales tax rate, used for diagnostics and support. Only applicable if the artaxvdr() returns TAX_SUCCESS
SALES_TAX_ID NUMBER (15)
Not currently used in the production release - replaced by location_segment_id
LOCATION_SEGMENT_ID NUMBER (15)
This column points to the record in the AR_LOCATION_VALUES table from which AutoAccounting derived the tax account for this line
MOVEMENT_ID NUMBER (15)
Intrastat movement ID number
ORG_ID NUMBER (15)
Organization identifier
WH_UPDATE_DATE DATE

Date sent to data warehouse
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
GROSS_UNIT_SELLING_PRICE NUMBER

Unit selling price inclusive of tax amounts
GROSS_EXTENDED_AMOUNT NUMBER

Amount gross of inclusive tax amounts
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Y indicates tax is inclusive. N indicates tax is exclusive. NULL for lines indicates tax is not-overridable or tax is a tax group. Cannot be NULL for tax types. Must be NULL for other types.
TAXABLE_AMOUNT NUMBER

The taxable amount for lines of the tax type that are tax inclusive
WAREHOUSE_ID NUMBER (15)
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.
TRANSLATED_DESCRIPTION VARCHAR2 (1000)
Translated description of this transaction line.
EXTENDED_ACCTD_AMOUNT NUMBER

Transaction line amount in functional currency for bills receivable
BR_REF_CUSTOMER_TRX_ID NUMBER (15)
Transaction ID of a transaction exchanged for a bills receivable
BR_REF_PAYMENT_SCHEDULE_ID NUMBER (15)
Payment Schedule ID of a transaction exchanged for a bills receivable
BR_ADJUSTMENT_ID NUMBER (15)
Adjustment identifier of a non-accounting adjustment created when a transaction is exchanged for a bills receivable
MRC_EXTENDED_ACCTD_AMOUNT VARCHAR2 (2000)
MRC only: Concatenated string of reporting Set of Books, with amount in reporting currency(s) pairs.
PAYMENT_SET_ID NUMBER (15)
Identifies the prepayment application's payment set
CONTRACT_LINE_ID NUMBER

Identifies the contract line from Oracle Contracts Core that is associated with this line
SOURCE_DATA_KEY1 VARCHAR2 (150)
Identifies source data from original system
SOURCE_DATA_KEY2 VARCHAR2 (150)
Identifies source data from original system
SOURCE_DATA_KEY3 VARCHAR2 (150)
Identifies source data from original system
SOURCE_DATA_KEY4 VARCHAR2 (150)
Identifies source data from original system
SOURCE_DATA_KEY5 VARCHAR2 (150)
Identifies source data from original system
INVOICED_LINE_ACCTG_LEVEL VARCHAR2 (15)
Identifies accounting level for invoiceable lines in original system
OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 (1)
Overrides AutoAccounting
SHIP_TO_CUSTOMER_ID NUMBER (15)
Identifies ship-to customer
SHIP_TO_ADDRESS_ID NUMBER (15)
Identifies ship-to address
SHIP_TO_SITE_USE_ID NUMBER (15)
Identifies ship-to site
SHIP_TO_CONTACT_ID NUMBER (15)
Identifies ship-to contact or recipient
HISTORICAL_FLAG VARCHAR2 (1)
Y, N, or NULL indicates if transaction line existed prior to implementation of eTax
TAX_LINE_ID NUMBER (15)
Identifies the detail tax line in ZX_LINES that corresponds to this tax line of eTax
LINE_RECOVERABLE NUMBER

Line amount for this line that is considered recoverable for eTax calculations
TAX_RECOVERABLE NUMBER

Total tax amount associated with this line that is considered recoverable for eTax calculations
TAX_CLASSIFICATION_CODE VARCHAR2 (50)
Single tax attribute code supported by eTax for backward compatibility. Represents a tax code or tax group as defined in eTax output tax classifications.
AMOUNT_DUE_REMAINING NUMBER

remaining balance
ACCTD_AMOUNT_DUE_REMAINING NUMBER

accounted remaining balance
AMOUNT_DUE_ORIGINAL NUMBER

original balance
ACCTD_AMOUNT_DUE_ORIGINAL NUMBER

accounted original balance
CHRG_AMOUNT_REMAINING NUMBER

charges balance on revenue line
CHRG_ACCTD_AMOUNT_REMAINING NUMBER

accounted charges balance on revenue line
FRT_ADJ_REMAINING NUMBER

freight adjusted amount on revenue line
FRT_ADJ_ACCTD_REMAINING NUMBER

freight adjusted accounted amount on revenue line.
FRT_ED_AMOUNT NUMBER

earned discount on freight assigned to the revenue line.
FRT_ED_ACCTD_AMOUNT NUMBER

earned accounted discount on freight assigned to the revenue line.
FRT_UNED_AMOUNT NUMBER

unearned discount on freight assigned to the revenue line.
FRT_UNED_ACCTD_AMOUNT NUMBER

unearned accounted discount on freight assigned to the revenue line.
DEFERRAL_EXCLUSION_FLAG VARCHAR2 (1)
Excludes line from automated revenue deferral
RULE_END_DATE DATE

Last GL date of the invoice. Only used for invoice
PAYMENT_TRXN_EXTENSION_ID NUMBER (15)
Payment extension identifier
INTEREST_LINE_ID NUMBER (15)
Fkey late charge
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CUSTOMER_TRX_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_TRX_ID
,      LINE_NUMBER
,      SET_OF_BOOKS_ID
,      REASON_CODE
,      INVENTORY_ITEM_ID
,      DESCRIPTION
,      PREVIOUS_CUSTOMER_TRX_ID
,      PREVIOUS_CUSTOMER_TRX_LINE_ID
,      QUANTITY_ORDERED
,      QUANTITY_CREDITED
,      QUANTITY_INVOICED
,      UNIT_STANDARD_PRICE
,      UNIT_SELLING_PRICE
,      SALES_ORDER
,      SALES_ORDER_REVISION
,      SALES_ORDER_LINE
,      SALES_ORDER_DATE
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_DURATION
,      LINE_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RULE_START_DATE
,      INITIAL_CUSTOMER_TRX_LINE_ID
,      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
,      SALES_ORDER_SOURCE
,      TAXABLE_FLAG
,      EXTENDED_AMOUNT
,      REVENUE_AMOUNT
,      AUTORULE_COMPLETE_FLAG
,      LINK_TO_CUST_TRX_LINE_ID
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TAX_PRECEDENCE
,      TAX_RATE
,      ITEM_EXCEPTION_RATE_ID
,      TAX_EXEMPTION_ID
,      MEMO_LINE_ID
,      AUTORULE_DURATION_PROCESSED
,      UOM_CODE
,      DEFAULT_USSGL_TRANSACTION_CODE
,      DEFAULT_USSGL_TRX_CODE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      INTERFACE_LINE_ATTRIBUTE9
,      VAT_TAX_ID
,      AUTOTAX
,      LAST_PERIOD_TO_CREDIT
,      ITEM_CONTEXT
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_VENDOR_RETURN_CODE
,      SALES_TAX_ID
,      LOCATION_SEGMENT_ID
,      MOVEMENT_ID
,      ORG_ID
,      WH_UPDATE_DATE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GROSS_UNIT_SELLING_PRICE
,      GROSS_EXTENDED_AMOUNT
,      AMOUNT_INCLUDES_TAX_FLAG
,      TAXABLE_AMOUNT
,      WAREHOUSE_ID
,      TRANSLATED_DESCRIPTION
,      EXTENDED_ACCTD_AMOUNT
,      BR_REF_CUSTOMER_TRX_ID
,      BR_REF_PAYMENT_SCHEDULE_ID
,      BR_ADJUSTMENT_ID
,      MRC_EXTENDED_ACCTD_AMOUNT
,      PAYMENT_SET_ID
,      CONTRACT_LINE_ID
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      INVOICED_LINE_ACCTG_LEVEL
,      OVERRIDE_AUTO_ACCOUNTING_FLAG
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_ADDRESS_ID
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      HISTORICAL_FLAG
,      TAX_LINE_ID
,      LINE_RECOVERABLE
,      TAX_RECOVERABLE
,      TAX_CLASSIFICATION_CODE
,      AMOUNT_DUE_REMAINING
,      ACCTD_AMOUNT_DUE_REMAINING
,      AMOUNT_DUE_ORIGINAL
,      ACCTD_AMOUNT_DUE_ORIGINAL
,      CHRG_AMOUNT_REMAINING
,      CHRG_ACCTD_AMOUNT_REMAINING
,      FRT_ADJ_REMAINING
,      FRT_ADJ_ACCTD_REMAINING
,      FRT_ED_AMOUNT
,      FRT_ED_ACCTD_AMOUNT
,      FRT_UNED_AMOUNT
,      FRT_UNED_ACCTD_AMOUNT
,      DEFERRAL_EXCLUSION_FLAG
,      RULE_END_DATE
,      PAYMENT_TRXN_EXTENSION_ID
,      INTEREST_LINE_ID
FROM AR.RA_CUSTOMER_TRX_LINES_ALL;

Dependencies

[top of page]

AR.RA_CUSTOMER_TRX_LINES_ALL does not reference any database object

AR.RA_CUSTOMER_TRX_LINES_ALL is referenced by following:

SchemaAR
ViewRA_CUSTOMER_TRX_LINES_ALL#