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

VIEW: APPS.RA_CUST_TRX_LN_ALL_MRC_V

Object Details
Object Name: RA_CUST_TRX_LN_ALL_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.RA_CUST_TRX_LN_ALL_MRC_V
Subobject Name:
Status: VALID

View Type

A multiple reporting currency view

[View Source]

Columns
Name Datatype Length Mandatory Comments
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
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
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

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
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
WH_UPDATE_DATE DATE

GROSS_UNIT_SELLING_PRICE NUMBER

GROSS_EXTENDED_AMOUNT NUMBER

AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
TAXABLE_AMOUNT NUMBER

WAREHOUSE_ID NUMBER (15)
TRANSLATED_DESCRIPTION VARCHAR2 (1000)
EXTENDED_ACCTD_AMOUNT NUMBER
Yes
BR_REF_CUSTOMER_TRX_ID NUMBER (15)
BR_REF_PAYMENT_SCHEDULE_ID NUMBER (15)
BR_ADJUSTMENT_ID NUMBER (15)
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)
Query Text

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


SELECT 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
,      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
,      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
,      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
,      WH_UPDATE_DATE
,      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
,      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
FROM APPS.RA_CUST_TRX_LN_ALL_MRC_V;

Dependencies

[top of page]

APPS.RA_CUST_TRX_LN_ALL_MRC_V references the following:

SchemaAPPS
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_MC_CUSTOMER_TRX_LINES

APPS.RA_CUST_TRX_LN_ALL_MRC_V is not referenced by any database object