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


TABLE: AR.RA_INTERFACE_LINES_ALL

Object Details
Object Name: RA_INTERFACE_LINES_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.RA_INTERFACE_LINES_ALL
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_INTERFACE_LINES_ALL view
which may be used by all products.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RA_INTERFACE_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_LINE_ID
RA_INTERFACE_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
RA_INTERFACE_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCUSTOMER_TRX_ID
RA_INTERFACE_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnLINK_TO_LINE_ID
RA_INTERFACE_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnREFERENCE_LINE_ID
RA_INTERFACE_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnTRX_NUMBER
ColumnREQUEST_ID
RA_INTERFACE_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnDOCUMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
INTERFACE_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)

BATCH_SOURCE_NAME VARCHAR2 (50) Yes
SET_OF_BOOKS_ID NUMBER (15)

LINE_TYPE VARCHAR2 (20) Yes
DESCRIPTION VARCHAR2 (240) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
AMOUNT NUMBER


CUST_TRX_TYPE_NAME VARCHAR2 (20)

CUST_TRX_TYPE_ID NUMBER (15)

TERM_NAME VARCHAR2 (15)

TERM_ID NUMBER (15)

ORIG_SYSTEM_BATCH_NAME VARCHAR2 (40)
Value used to uniquely identify batch name from original system
ORIG_SYSTEM_BILL_CUSTOMER_REF VARCHAR2 (240)

ORIG_SYSTEM_BILL_CUSTOMER_ID NUMBER (15)

ORIG_SYSTEM_BILL_ADDRESS_REF VARCHAR2 (240)

ORIG_SYSTEM_BILL_ADDRESS_ID NUMBER (15)

ORIG_SYSTEM_BILL_CONTACT_REF VARCHAR2 (240)

ORIG_SYSTEM_BILL_CONTACT_ID NUMBER (15)

ORIG_SYSTEM_SHIP_CUSTOMER_REF VARCHAR2 (240)

ORIG_SYSTEM_SHIP_CUSTOMER_ID NUMBER (15)

ORIG_SYSTEM_SHIP_ADDRESS_REF VARCHAR2 (240)

ORIG_SYSTEM_SHIP_ADDRESS_ID NUMBER (15)

ORIG_SYSTEM_SHIP_CONTACT_REF VARCHAR2 (240)

ORIG_SYSTEM_SHIP_CONTACT_ID NUMBER (15)

ORIG_SYSTEM_SOLD_CUSTOMER_REF VARCHAR2 (240)

ORIG_SYSTEM_SOLD_CUSTOMER_ID NUMBER (15)

LINK_TO_LINE_ID NUMBER (15)

LINK_TO_LINE_CONTEXT VARCHAR2 (30)

LINK_TO_LINE_ATTRIBUTE1 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE2 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE3 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE4 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE5 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE6 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE7 VARCHAR2 (150)

RECEIPT_METHOD_NAME VARCHAR2 (30)

RECEIPT_METHOD_ID NUMBER (15)

CONVERSION_TYPE VARCHAR2 (30) Yes
CONVERSION_DATE DATE


CONVERSION_RATE NUMBER


CUSTOMER_TRX_ID NUMBER (15)

TRX_DATE DATE


GL_DATE DATE


DOCUMENT_NUMBER NUMBER (15)

TRX_NUMBER VARCHAR2 (20)

LINE_NUMBER NUMBER (15)

QUANTITY NUMBER


QUANTITY_ORDERED NUMBER


UNIT_SELLING_PRICE NUMBER


UNIT_STANDARD_PRICE NUMBER


PRINTING_OPTION VARCHAR2 (20)

INTERFACE_STATUS VARCHAR2 (1)

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).
RELATED_BATCH_SOURCE_NAME VARCHAR2 (50)

RELATED_TRX_NUMBER VARCHAR2 (20)

RELATED_CUSTOMER_TRX_ID NUMBER (15)

PREVIOUS_CUSTOMER_TRX_ID NUMBER (15)

CREDIT_METHOD_FOR_ACCT_RULE VARCHAR2 (30)

CREDIT_METHOD_FOR_INSTALLMENTS VARCHAR2 (30)

REASON_CODE VARCHAR2 (30)

TAX_RATE NUMBER


TAX_CODE VARCHAR2 (50)

TAX_PRECEDENCE NUMBER


EXCEPTION_ID NUMBER (15)

EXEMPTION_ID NUMBER (15)

SHIP_DATE_ACTUAL DATE


FOB_POINT VARCHAR2 (30)

SHIP_VIA VARCHAR2 (25)

WAYBILL_NUMBER VARCHAR2 (50)

INVOICING_RULE_NAME VARCHAR2 (30)

INVOICING_RULE_ID NUMBER (15)

ACCOUNTING_RULE_NAME VARCHAR2 (30)

ACCOUNTING_RULE_ID NUMBER (15)

ACCOUNTING_RULE_DURATION NUMBER (15)

RULE_START_DATE DATE


PRIMARY_SALESREP_NUMBER VARCHAR2 (30)

PRIMARY_SALESREP_ID NUMBER (15)

SALES_ORDER VARCHAR2 (50)

SALES_ORDER_LINE VARCHAR2 (30)

SALES_ORDER_DATE DATE


SALES_ORDER_SOURCE VARCHAR2 (50)

SALES_ORDER_REVISION NUMBER


PURCHASE_ORDER VARCHAR2 (50)

PURCHASE_ORDER_REVISION VARCHAR2 (50)

PURCHASE_ORDER_DATE DATE


AGREEMENT_NAME VARCHAR2 (30)

AGREEMENT_ID NUMBER (15)

MEMO_LINE_NAME VARCHAR2 (50)

MEMO_LINE_ID NUMBER (15)

INVENTORY_ITEM_ID NUMBER (15)

MTL_SYSTEM_ITEMS_SEG1 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG2 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG3 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG4 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG5 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG6 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG7 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG8 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG9 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG10 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG11 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG12 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG13 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG14 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG15 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG16 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG17 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG18 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG19 VARCHAR2 (40)

MTL_SYSTEM_ITEMS_SEG20 VARCHAR2 (40)

REFERENCE_LINE_ID NUMBER (15)

REFERENCE_LINE_CONTEXT VARCHAR2 (30)

REFERENCE_LINE_ATTRIBUTE1 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE2 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE3 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE4 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE5 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE6 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE7 VARCHAR2 (150)

TERRITORY_ID NUMBER (15)

TERRITORY_SEGMENT1 VARCHAR2 (25)

TERRITORY_SEGMENT2 VARCHAR2 (25)

TERRITORY_SEGMENT3 VARCHAR2 (25)

TERRITORY_SEGMENT4 VARCHAR2 (25)

TERRITORY_SEGMENT5 VARCHAR2 (25)

TERRITORY_SEGMENT6 VARCHAR2 (25)

TERRITORY_SEGMENT7 VARCHAR2 (25)

TERRITORY_SEGMENT8 VARCHAR2 (25)

TERRITORY_SEGMENT9 VARCHAR2 (25)

TERRITORY_SEGMENT10 VARCHAR2 (25)

TERRITORY_SEGMENT11 VARCHAR2 (25)

TERRITORY_SEGMENT12 VARCHAR2 (25)

TERRITORY_SEGMENT13 VARCHAR2 (25)

TERRITORY_SEGMENT14 VARCHAR2 (25)

TERRITORY_SEGMENT15 VARCHAR2 (25)

TERRITORY_SEGMENT16 VARCHAR2 (25)

TERRITORY_SEGMENT17 VARCHAR2 (25)

TERRITORY_SEGMENT18 VARCHAR2 (25)

TERRITORY_SEGMENT19 VARCHAR2 (25)

TERRITORY_SEGMENT20 VARCHAR2 (25)

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
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
HEADER_ATTRIBUTE_CATEGORY VARCHAR2 (30)

HEADER_ATTRIBUTE1 VARCHAR2 (150)

HEADER_ATTRIBUTE2 VARCHAR2 (150)

HEADER_ATTRIBUTE3 VARCHAR2 (150)

HEADER_ATTRIBUTE4 VARCHAR2 (150)

HEADER_ATTRIBUTE5 VARCHAR2 (150)

HEADER_ATTRIBUTE6 VARCHAR2 (150)

HEADER_ATTRIBUTE7 VARCHAR2 (150)

HEADER_ATTRIBUTE8 VARCHAR2 (150)

HEADER_ATTRIBUTE9 VARCHAR2 (150)

HEADER_ATTRIBUTE10 VARCHAR2 (150)

HEADER_ATTRIBUTE11 VARCHAR2 (150)

HEADER_ATTRIBUTE12 VARCHAR2 (150)

HEADER_ATTRIBUTE13 VARCHAR2 (150)

HEADER_ATTRIBUTE14 VARCHAR2 (150)

HEADER_ATTRIBUTE15 VARCHAR2 (150)

COMMENTS VARCHAR2 (240)

INTERNAL_NOTES VARCHAR2 (240)

INITIAL_CUSTOMER_TRX_ID NUMBER (15)

USSGL_TRANSACTION_CODE_CONTEXT VARCHAR2 (30)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

ACCTD_AMOUNT NUMBER


CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)

CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2 (80)

UOM_CODE VARCHAR2 (3)

UOM_NAME VARCHAR2 (25)

DOCUMENT_NUMBER_SEQUENCE_ID NUMBER (15)

LINK_TO_LINE_ATTRIBUTE10 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE11 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE12 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE13 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE14 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE15 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE8 VARCHAR2 (150)

LINK_TO_LINE_ATTRIBUTE9 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE10 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE11 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE12 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE13 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE14 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE15 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE8 VARCHAR2 (150)

REFERENCE_LINE_ATTRIBUTE9 VARCHAR2 (150)

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)

REASON_CODE_MEANING VARCHAR2 (80)

LAST_PERIOD_TO_CREDIT NUMBER


PAYING_CUSTOMER_ID NUMBER (15)

PAYING_SITE_USE_ID NUMBER (15)

TAX_EXEMPT_FLAG VARCHAR2 (1)

TAX_EXEMPT_REASON_CODE VARCHAR2 (30)

TAX_EXEMPT_REASON_CODE_MEANING VARCHAR2 (80)

TAX_EXEMPT_NUMBER VARCHAR2 (80)

SALES_TAX_ID NUMBER (15)

CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
LOCATION_SEGMENT_ID NUMBER (15)

MOVEMENT_ID NUMBER (15)

ORG_ID NUMBER (15)
Organization identifier
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
'Y' indicates tax is inclusive. 'N' indicates tax is exclusive. NULL indicates that this flag should be defaulted from the tax code.
HEADER_GDF_ATTR_CATEGORY VARCHAR2 (30)
HEADER_GDF_ATTRIBUTE1 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE2 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE3 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE4 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE5 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE6 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE7 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE8 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE9 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE10 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE11 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE12 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE13 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE14 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE15 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE16 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE17 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE18 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE19 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE20 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE21 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE22 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE23 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE24 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE25 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE26 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE27 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE28 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE29 VARCHAR2 (150)
HEADER_GDF_ATTRIBUTE30 VARCHAR2 (150)
LINE_GDF_ATTR_CATEGORY VARCHAR2 (30)
LINE_GDF_ATTRIBUTE1 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE2 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE3 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE4 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE5 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE6 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE7 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE8 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE9 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE10 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE11 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE12 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE13 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE14 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE15 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE16 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE17 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE18 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE19 VARCHAR2 (150)
LINE_GDF_ATTRIBUTE20 VARCHAR2 (150)
RESET_TRX_DATE_FLAG VARCHAR2 (1)
PAYMENT_SERVER_ORDER_NUM VARCHAR2 (80)
Identifies credit card payment authorized by Oracle Payment Server
APPROVAL_CODE VARCHAR2 (80)
Payment approval code from credit card issuer
ADDRESS_VERIFICATION_CODE VARCHAR2 (80)
Credit card address verification code from Oracle Payment Server
WAREHOUSE_ID NUMBER (15)
TRANSLATED_DESCRIPTION VARCHAR2 (1000)
CONS_BILLING_NUMBER VARCHAR2 (30)
PROMISED_COMMITMENT_AMOUNT NUMBER

PAYMENT_SET_ID NUMBER (15)
ORIGINAL_GL_DATE DATE

Stores the value of the GL_DATE column before Autoinvoice modifies the GL date.
CONTRACT_LINE_ID NUMBER

CONTRACT_ID NUMBER

Identifies the contract from Oracle Contracts Core that is associated with this line
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)
SOURCE_APPLICATION_ID NUMBER (15)
Identifies the application that supplied this transaction line
SOURCE_EVENT_CLASS_CODE VARCHAR2 (30)
Identifies the event class provided by the source application
SOURCE_ENTITY_CODE VARCHAR2 (30)
Identifies the entity provided by the source application
SOURCE_TRX_ID NUMBER

Identifies the transaction in the source application
SOURCE_TRX_LINE_ID NUMBER

Identifies the transaction line in the source application
SOURCE_TRX_LINE_TYPE VARCHAR2 (30)
Identifies lowest level at which information is being passed from source application. Values can be HEADER, LINE, SHIPMENT, FREIGHT, or DISTRIBUTION.
SOURCE_TRX_DETAIL_TAX_LINE_ID NUMBER (15)
Identifies the detail tax line in ZX_LINES that corresponds to this tax line
HISTORICAL_FLAG VARCHAR2 (1)
Y, N, or NULL indicates if transaction line existed prior to implementation of eTax
TAX_REGIME_CODE VARCHAR2 (30)
Represents a high-level entity for defining common set of tax rules
TAX VARCHAR2 (30)
Represents a charge imposed by a fiscal or tax authority within a regime
TAX_STATUS_CODE VARCHAR2 (30)
Represents the taxable nature of a product or service. Defined within the scope of a tax and tax regime.
TAX_RATE_CODE VARCHAR2 (30)
Represents a numeric rate for calculations. Defined within the scope of a tax status, tax, and tax regime
TAX_JURISDICTION_CODE VARCHAR2 (30)
Represents a geographic area where taxes are levied. Defined within the scope of a tax and tax regime.
TAXABLE_AMOUNT NUMBER

The taxable amount for lines of type TAX that are tax inclusive.
TAXABLE_FLAG VARCHAR2 (1)
Y, N, or NULL. Determines if the current line is taxable.
LEGAL_ENTITY_ID NUMBER (15)
Identifies the legal entity responsible for issuing the invoice line.
PARENT_LINE_ID NUMBER (15)
Parent line identifier
DEFERRAL_EXCLUSION_FLAG VARCHAR2 (1)
Excludes line from automated revenue deferralExcludes line from automated revenue deferral
PAYMENT_TRXN_EXTENSION_ID NUMBER (15)
Payment extension identifier
RULE_END_DATE DATE

Date when this transaction's accounting rule ends
PAYMENT_ATTRIBUTES VARCHAR2 (1000)
Payment attributes used for grouping transaction lines.
APPLICATION_ID NUMBER (15)
Source application importing transactions into Receivables.
BILLING_DATE DATE

Date specified by feeder system for external consolidated billing schedules
TRX_BUSINESS_CATEGORY VARCHAR2 (240)
Transaction business category code of the transaction line
PRODUCT_FISC_CLASSIFICATION VARCHAR2 (240)
Product fiscal classification code of the inventory item
PRODUCT_CATEGORY VARCHAR2 (240)
Product category code of the transaction line
PRODUCT_TYPE VARCHAR2 (240)
Product type code of the inventory item. Possible values are GOODS and SERVICES
LINE_INTENDED_USE VARCHAR2 (240)
Intended use code of the transaction line. This identifies the purpose for which the product is used.
ASSESSABLE_VALUE NUMBER

Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes.
DOCUMENT_SUB_TYPE VARCHAR2 (240)
Document sub type code
DEFAULT_TAXATION_COUNTRY VARCHAR2 (2)
Default taxation country code
USER_DEFINED_FISC_CLASS VARCHAR2 (30)
User defined fiscal classification code of the transaction line
TAXED_UPSTREAM_FLAG VARCHAR2 (1)
Y or N indicates whether tax was calculated for this line in the source or upstream product.
Query Text

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


SELECT INTERFACE_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
,      BATCH_SOURCE_NAME
,      SET_OF_BOOKS_ID
,      LINE_TYPE
,      DESCRIPTION
,      CURRENCY_CODE
,      AMOUNT
,      CUST_TRX_TYPE_NAME
,      CUST_TRX_TYPE_ID
,      TERM_NAME
,      TERM_ID
,      ORIG_SYSTEM_BATCH_NAME
,      ORIG_SYSTEM_BILL_CUSTOMER_REF
,      ORIG_SYSTEM_BILL_CUSTOMER_ID
,      ORIG_SYSTEM_BILL_ADDRESS_REF
,      ORIG_SYSTEM_BILL_ADDRESS_ID
,      ORIG_SYSTEM_BILL_CONTACT_REF
,      ORIG_SYSTEM_BILL_CONTACT_ID
,      ORIG_SYSTEM_SHIP_CUSTOMER_REF
,      ORIG_SYSTEM_SHIP_CUSTOMER_ID
,      ORIG_SYSTEM_SHIP_ADDRESS_REF
,      ORIG_SYSTEM_SHIP_ADDRESS_ID
,      ORIG_SYSTEM_SHIP_CONTACT_REF
,      ORIG_SYSTEM_SHIP_CONTACT_ID
,      ORIG_SYSTEM_SOLD_CUSTOMER_REF
,      ORIG_SYSTEM_SOLD_CUSTOMER_ID
,      LINK_TO_LINE_ID
,      LINK_TO_LINE_CONTEXT
,      LINK_TO_LINE_ATTRIBUTE1
,      LINK_TO_LINE_ATTRIBUTE2
,      LINK_TO_LINE_ATTRIBUTE3
,      LINK_TO_LINE_ATTRIBUTE4
,      LINK_TO_LINE_ATTRIBUTE5
,      LINK_TO_LINE_ATTRIBUTE6
,      LINK_TO_LINE_ATTRIBUTE7
,      RECEIPT_METHOD_NAME
,      RECEIPT_METHOD_ID
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CUSTOMER_TRX_ID
,      TRX_DATE
,      GL_DATE
,      DOCUMENT_NUMBER
,      TRX_NUMBER
,      LINE_NUMBER
,      QUANTITY
,      QUANTITY_ORDERED
,      UNIT_SELLING_PRICE
,      UNIT_STANDARD_PRICE
,      PRINTING_OPTION
,      INTERFACE_STATUS
,      REQUEST_ID
,      RELATED_BATCH_SOURCE_NAME
,      RELATED_TRX_NUMBER
,      RELATED_CUSTOMER_TRX_ID
,      PREVIOUS_CUSTOMER_TRX_ID
,      CREDIT_METHOD_FOR_ACCT_RULE
,      CREDIT_METHOD_FOR_INSTALLMENTS
,      REASON_CODE
,      TAX_RATE
,      TAX_CODE
,      TAX_PRECEDENCE
,      EXCEPTION_ID
,      EXEMPTION_ID
,      SHIP_DATE_ACTUAL
,      FOB_POINT
,      SHIP_VIA
,      WAYBILL_NUMBER
,      INVOICING_RULE_NAME
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_NAME
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_DURATION
,      RULE_START_DATE
,      PRIMARY_SALESREP_NUMBER
,      PRIMARY_SALESREP_ID
,      SALES_ORDER
,      SALES_ORDER_LINE
,      SALES_ORDER_DATE
,      SALES_ORDER_SOURCE
,      SALES_ORDER_REVISION
,      PURCHASE_ORDER
,      PURCHASE_ORDER_REVISION
,      PURCHASE_ORDER_DATE
,      AGREEMENT_NAME
,      AGREEMENT_ID
,      MEMO_LINE_NAME
,      MEMO_LINE_ID
,      INVENTORY_ITEM_ID
,      MTL_SYSTEM_ITEMS_SEG1
,      MTL_SYSTEM_ITEMS_SEG2
,      MTL_SYSTEM_ITEMS_SEG3
,      MTL_SYSTEM_ITEMS_SEG4
,      MTL_SYSTEM_ITEMS_SEG5
,      MTL_SYSTEM_ITEMS_SEG6
,      MTL_SYSTEM_ITEMS_SEG7
,      MTL_SYSTEM_ITEMS_SEG8
,      MTL_SYSTEM_ITEMS_SEG9
,      MTL_SYSTEM_ITEMS_SEG10
,      MTL_SYSTEM_ITEMS_SEG11
,      MTL_SYSTEM_ITEMS_SEG12
,      MTL_SYSTEM_ITEMS_SEG13
,      MTL_SYSTEM_ITEMS_SEG14
,      MTL_SYSTEM_ITEMS_SEG15
,      MTL_SYSTEM_ITEMS_SEG16
,      MTL_SYSTEM_ITEMS_SEG17
,      MTL_SYSTEM_ITEMS_SEG18
,      MTL_SYSTEM_ITEMS_SEG19
,      MTL_SYSTEM_ITEMS_SEG20
,      REFERENCE_LINE_ID
,      REFERENCE_LINE_CONTEXT
,      REFERENCE_LINE_ATTRIBUTE1
,      REFERENCE_LINE_ATTRIBUTE2
,      REFERENCE_LINE_ATTRIBUTE3
,      REFERENCE_LINE_ATTRIBUTE4
,      REFERENCE_LINE_ATTRIBUTE5
,      REFERENCE_LINE_ATTRIBUTE6
,      REFERENCE_LINE_ATTRIBUTE7
,      TERRITORY_ID
,      TERRITORY_SEGMENT1
,      TERRITORY_SEGMENT2
,      TERRITORY_SEGMENT3
,      TERRITORY_SEGMENT4
,      TERRITORY_SEGMENT5
,      TERRITORY_SEGMENT6
,      TERRITORY_SEGMENT7
,      TERRITORY_SEGMENT8
,      TERRITORY_SEGMENT9
,      TERRITORY_SEGMENT10
,      TERRITORY_SEGMENT11
,      TERRITORY_SEGMENT12
,      TERRITORY_SEGMENT13
,      TERRITORY_SEGMENT14
,      TERRITORY_SEGMENT15
,      TERRITORY_SEGMENT16
,      TERRITORY_SEGMENT17
,      TERRITORY_SEGMENT18
,      TERRITORY_SEGMENT19
,      TERRITORY_SEGMENT20
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      HEADER_ATTRIBUTE_CATEGORY
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_ATTRIBUTE11
,      HEADER_ATTRIBUTE12
,      HEADER_ATTRIBUTE13
,      HEADER_ATTRIBUTE14
,      HEADER_ATTRIBUTE15
,      COMMENTS
,      INTERNAL_NOTES
,      INITIAL_CUSTOMER_TRX_ID
,      USSGL_TRANSACTION_CODE_CONTEXT
,      USSGL_TRANSACTION_CODE
,      ACCTD_AMOUNT
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUSTOMER_BANK_ACCOUNT_NAME
,      UOM_CODE
,      UOM_NAME
,      DOCUMENT_NUMBER_SEQUENCE_ID
,      LINK_TO_LINE_ATTRIBUTE10
,      LINK_TO_LINE_ATTRIBUTE11
,      LINK_TO_LINE_ATTRIBUTE12
,      LINK_TO_LINE_ATTRIBUTE13
,      LINK_TO_LINE_ATTRIBUTE14
,      LINK_TO_LINE_ATTRIBUTE15
,      LINK_TO_LINE_ATTRIBUTE8
,      LINK_TO_LINE_ATTRIBUTE9
,      REFERENCE_LINE_ATTRIBUTE10
,      REFERENCE_LINE_ATTRIBUTE11
,      REFERENCE_LINE_ATTRIBUTE12
,      REFERENCE_LINE_ATTRIBUTE13
,      REFERENCE_LINE_ATTRIBUTE14
,      REFERENCE_LINE_ATTRIBUTE15
,      REFERENCE_LINE_ATTRIBUTE8
,      REFERENCE_LINE_ATTRIBUTE9
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      INTERFACE_LINE_ATTRIBUTE9
,      VAT_TAX_ID
,      REASON_CODE_MEANING
,      LAST_PERIOD_TO_CREDIT
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_REASON_CODE
,      TAX_EXEMPT_REASON_CODE_MEANING
,      TAX_EXEMPT_NUMBER
,      SALES_TAX_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOCATION_SEGMENT_ID
,      MOVEMENT_ID
,      ORG_ID
,      AMOUNT_INCLUDES_TAX_FLAG
,      HEADER_GDF_ATTR_CATEGORY
,      HEADER_GDF_ATTRIBUTE1
,      HEADER_GDF_ATTRIBUTE2
,      HEADER_GDF_ATTRIBUTE3
,      HEADER_GDF_ATTRIBUTE4
,      HEADER_GDF_ATTRIBUTE5
,      HEADER_GDF_ATTRIBUTE6
,      HEADER_GDF_ATTRIBUTE7
,      HEADER_GDF_ATTRIBUTE8
,      HEADER_GDF_ATTRIBUTE9
,      HEADER_GDF_ATTRIBUTE10
,      HEADER_GDF_ATTRIBUTE11
,      HEADER_GDF_ATTRIBUTE12
,      HEADER_GDF_ATTRIBUTE13
,      HEADER_GDF_ATTRIBUTE14
,      HEADER_GDF_ATTRIBUTE15
,      HEADER_GDF_ATTRIBUTE16
,      HEADER_GDF_ATTRIBUTE17
,      HEADER_GDF_ATTRIBUTE18
,      HEADER_GDF_ATTRIBUTE19
,      HEADER_GDF_ATTRIBUTE20
,      HEADER_GDF_ATTRIBUTE21
,      HEADER_GDF_ATTRIBUTE22
,      HEADER_GDF_ATTRIBUTE23
,      HEADER_GDF_ATTRIBUTE24
,      HEADER_GDF_ATTRIBUTE25
,      HEADER_GDF_ATTRIBUTE26
,      HEADER_GDF_ATTRIBUTE27
,      HEADER_GDF_ATTRIBUTE28
,      HEADER_GDF_ATTRIBUTE29
,      HEADER_GDF_ATTRIBUTE30
,      LINE_GDF_ATTR_CATEGORY
,      LINE_GDF_ATTRIBUTE1
,      LINE_GDF_ATTRIBUTE2
,      LINE_GDF_ATTRIBUTE3
,      LINE_GDF_ATTRIBUTE4
,      LINE_GDF_ATTRIBUTE5
,      LINE_GDF_ATTRIBUTE6
,      LINE_GDF_ATTRIBUTE7
,      LINE_GDF_ATTRIBUTE8
,      LINE_GDF_ATTRIBUTE9
,      LINE_GDF_ATTRIBUTE10
,      LINE_GDF_ATTRIBUTE11
,      LINE_GDF_ATTRIBUTE12
,      LINE_GDF_ATTRIBUTE13
,      LINE_GDF_ATTRIBUTE14
,      LINE_GDF_ATTRIBUTE15
,      LINE_GDF_ATTRIBUTE16
,      LINE_GDF_ATTRIBUTE17
,      LINE_GDF_ATTRIBUTE18
,      LINE_GDF_ATTRIBUTE19
,      LINE_GDF_ATTRIBUTE20
,      RESET_TRX_DATE_FLAG
,      PAYMENT_SERVER_ORDER_NUM
,      APPROVAL_CODE
,      ADDRESS_VERIFICATION_CODE
,      WAREHOUSE_ID
,      TRANSLATED_DESCRIPTION
,      CONS_BILLING_NUMBER
,      PROMISED_COMMITMENT_AMOUNT
,      PAYMENT_SET_ID
,      ORIGINAL_GL_DATE
,      CONTRACT_LINE_ID
,      CONTRACT_ID
,      SOURCE_DATA_KEY1
,      SOURCE_DATA_KEY2
,      SOURCE_DATA_KEY3
,      SOURCE_DATA_KEY4
,      SOURCE_DATA_KEY5
,      INVOICED_LINE_ACCTG_LEVEL
,      OVERRIDE_AUTO_ACCOUNTING_FLAG
,      SOURCE_APPLICATION_ID
,      SOURCE_EVENT_CLASS_CODE
,      SOURCE_ENTITY_CODE
,      SOURCE_TRX_ID
,      SOURCE_TRX_LINE_ID
,      SOURCE_TRX_LINE_TYPE
,      SOURCE_TRX_DETAIL_TAX_LINE_ID
,      HISTORICAL_FLAG
,      TAX_REGIME_CODE
,      TAX
,      TAX_STATUS_CODE
,      TAX_RATE_CODE
,      TAX_JURISDICTION_CODE
,      TAXABLE_AMOUNT
,      TAXABLE_FLAG
,      LEGAL_ENTITY_ID
,      PARENT_LINE_ID
,      DEFERRAL_EXCLUSION_FLAG
,      PAYMENT_TRXN_EXTENSION_ID
,      RULE_END_DATE
,      PAYMENT_ATTRIBUTES
,      APPLICATION_ID
,      BILLING_DATE
,      TRX_BUSINESS_CATEGORY
,      PRODUCT_FISC_CLASSIFICATION
,      PRODUCT_CATEGORY
,      PRODUCT_TYPE
,      LINE_INTENDED_USE
,      ASSESSABLE_VALUE
,      DOCUMENT_SUB_TYPE
,      DEFAULT_TAXATION_COUNTRY
,      USER_DEFINED_FISC_CLASS
,      TAXED_UPSTREAM_FLAG
FROM AR.RA_INTERFACE_LINES_ALL;

Dependencies

[top of page]

AR.RA_INTERFACE_LINES_ALL does not reference any database object

AR.RA_INTERFACE_LINES_ALL is referenced by following:

SchemaAPPS
SynonymRA_INTERFACE_LINES
SynonymRA_INTERFACE_LINES_ALL