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

VIEW: APPS.RA_CUST_TRX_LN_MRC_V

Object Details
Object Name: RA_CUST_TRX_LN_MRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.RA_CUST_TRX_LN_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 (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
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
WH_UPDATE_DATE DATE

Date sent to data warehouse
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
Yes 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
PAYMENT_SET_ID NUMBER (15)
Identifies the prepayment application's payment set
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
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
,      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_MRC_V;

Dependencies

[top of page]

APPS.RA_CUST_TRX_LN_MRC_V references the following:

SchemaAPPS
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymRA_MC_CUSTOMER_TRX_LINES

APPS.RA_CUST_TRX_LN_MRC_V is not referenced by any database object