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

VIEW: AR.RA_CUSTOMER_TRX_LINES_ALL#

Object Details
Object Name: RA_CUSTOMER_TRX_LINES_ALL#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


This is the RA_CUSTOMER_TRX_LINES_ALL view
which may be used by all products.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_LINE_ID NUMBER (15) Yes
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
LINE_NUMBER NUMBER
Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
REASON_CODE VARCHAR2 (30)

INVENTORY_ITEM_ID NUMBER (15)

DESCRIPTION VARCHAR2 (240)

PREVIOUS_CUSTOMER_TRX_ID NUMBER (15)

PREVIOUS_CUSTOMER_TRX_LINE_ID NUMBER (15)

QUANTITY_ORDERED NUMBER


QUANTITY_CREDITED NUMBER


QUANTITY_INVOICED NUMBER


UNIT_STANDARD_PRICE NUMBER


UNIT_SELLING_PRICE NUMBER


SALES_ORDER VARCHAR2 (50)

SALES_ORDER_REVISION NUMBER


SALES_ORDER_LINE VARCHAR2 (30)

SALES_ORDER_DATE DATE


ACCOUNTING_RULE_ID NUMBER (15)

ACCOUNTING_RULE_DURATION NUMBER (15)

LINE_TYPE VARCHAR2 (20) Yes
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


INITIAL_CUSTOMER_TRX_LINE_ID NUMBER (15)

INTERFACE_LINE_CONTEXT VARCHAR2 (30)

INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)

SALES_ORDER_SOURCE VARCHAR2 (50)

TAXABLE_FLAG VARCHAR2 (1)
EXTENDED_AMOUNT NUMBER
Yes
REVENUE_AMOUNT NUMBER


AUTORULE_COMPLETE_FLAG VARCHAR2 (1)

LINK_TO_CUST_TRX_LINE_ID NUMBER (15)

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_RATE NUMBER


ITEM_EXCEPTION_RATE_ID NUMBER (15)

TAX_EXEMPTION_ID NUMBER (15)

MEMO_LINE_ID NUMBER (15)

AUTORULE_DURATION_PROCESSED NUMBER (15)

UOM_CODE VARCHAR2 (3)

DEFAULT_USSGL_TRANSACTION_CODE VARCHAR2 (30)

DEFAULT_USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)

INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)

INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)

VAT_TAX_ID NUMBER (15)

AUTOTAX VARCHAR2 (1)

LAST_PERIOD_TO_CREDIT NUMBER


ITEM_CONTEXT VARCHAR2 (30)

TAX_EXEMPT_FLAG VARCHAR2 (1)

TAX_EXEMPT_NUMBER VARCHAR2 (80)

TAX_EXEMPT_REASON_CODE VARCHAR2 (30)

TAX_VENDOR_RETURN_CODE VARCHAR2 (30)

SALES_TAX_ID NUMBER (15)

LOCATION_SEGMENT_ID NUMBER (15)

MOVEMENT_ID NUMBER (15)

ORG_ID NUMBER (15)
Organization identifier
WH_UPDATE_DATE DATE

Warehouse update date when record was recorded or changed
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved For Globalization Functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved For Globalization 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-overrideable or tax is a tax group.Cannot be NULL for tax types.Must be NULL for other types.
TAXABLE_AMOUNT NUMBER

For lines of type tax and tax-inclusive, the taxable amount.
WAREHOUSE_ID NUMBER (15)
TRANSLATED_DESCRIPTION VARCHAR2 (1000)
EXTENDED_ACCTD_AMOUNT NUMBER

BR_REF_CUSTOMER_TRX_ID NUMBER (15)
BR_REF_PAYMENT_SCHEDULE_ID NUMBER (15)
BR_ADJUSTMENT_ID NUMBER (15)
MRC_EXTENDED_ACCTD_AMOUNT VARCHAR2 (2000)
PAYMENT_SET_ID NUMBER (15)
CONTRACT_LINE_ID NUMBER

SOURCE_DATA_KEY1 VARCHAR2 (150)
SOURCE_DATA_KEY2 VARCHAR2 (150)
SOURCE_DATA_KEY3 VARCHAR2 (150)
SOURCE_DATA_KEY4 VARCHAR2 (150)
SOURCE_DATA_KEY5 VARCHAR2 (150)
INVOICED_LINE_ACCTG_LEVEL VARCHAR2 (15)
OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 (1)
Overrides AutoAccounting
SHIP_TO_CUSTOMER_ID NUMBER (15)
SHIP_TO_ADDRESS_ID NUMBER (15)
SHIP_TO_SITE_USE_ID NUMBER (15)
SHIP_TO_CONTACT_ID NUMBER (15)
HISTORICAL_FLAG VARCHAR2 (1)
TAX_LINE_ID NUMBER (15)
LINE_RECOVERABLE NUMBER

TAX_RECOVERABLE NUMBER

TAX_CLASSIFICATION_CODE VARCHAR2 (50)
AMOUNT_DUE_REMAINING NUMBER

ACCTD_AMOUNT_DUE_REMAINING NUMBER

AMOUNT_DUE_ORIGINAL NUMBER

ACCTD_AMOUNT_DUE_ORIGINAL NUMBER

CHRG_AMOUNT_REMAINING NUMBER

CHRG_ACCTD_AMOUNT_REMAINING NUMBER

FRT_ADJ_REMAINING NUMBER

FRT_ADJ_ACCTD_REMAINING NUMBER

FRT_ED_AMOUNT NUMBER

FRT_ED_ACCTD_AMOUNT NUMBER

FRT_UNED_AMOUNT NUMBER

FRT_UNED_ACCTD_AMOUNT NUMBER

DEFERRAL_EXCLUSION_FLAG VARCHAR2 (1)
RULE_END_DATE DATE

PAYMENT_TRXN_EXTENSION_ID NUMBER (15)
INTEREST_LINE_ID NUMBER (15)
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# references the following:

SchemaAR
TableRA_CUSTOMER_TRX_LINES_ALL
AR.RA_CUSTOMER_TRX_LINES_ALL# is referenced by following:

SchemaAPPS
TriggerJAI_AR_RCTLA_ARIUD_T1
SynonymRA_CUSTOMER_TRX_LINES
SynonymRA_CUSTOMER_TRX_LINES_ALL