AR_TRX_LINES_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
TRX_HEADER_ID | NUMBER | 18 | Oracle internal use only | ||
TRX_DATE | DATE | Oracle internal use only | |||
CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
LINK_TO_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
LINE_NUMBER | NUMBER | Oracle internal use only | |||
LINE_TYPE | VARCHAR2 | 20 | Oracle internal use only | ||
CURRENCY_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only | ||
LINK_TO_CUST_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
SET_OF_BOOKS_ID | NUMBER | 18 | Oracle internal use only | ||
REASON_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Oracle internal use only | ||
DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only | ||
QUANTITY_ORDERED | NUMBER | Oracle internal use only | |||
QUANTITY_CREDITED | NUMBER | Oracle internal use only | |||
QUANTITY_INVOICED | NUMBER | Oracle internal use only | |||
UNIT_STANDARD_PRICE | NUMBER | Oracle internal use only | |||
UNIT_SELLING_PRICE | NUMBER | Oracle internal use only | |||
SALES_ORDER | VARCHAR2 | 50 | Oracle internal use only | ||
SALES_ORDER_LINE | VARCHAR2 | 30 | Oracle internal use only | ||
SALES_ORDER_DATE | DATE | Oracle internal use only | |||
ACCOUNTING_RULE_ID | NUMBER | 18 | Oracle internal use only | ||
ACCOUNTING_RULE_DURATION | NUMBER | 18 | Oracle internal use only | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
RULE_START_DATE | DATE | Oracle internal use only | |||
INTERFACE_LINE_CONTEXT | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Oracle internal use only | ||
INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Oracle internal use only | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
SALES_ORDER_SOURCE | VARCHAR2 | 50 | Oracle internal use only | ||
EXTENDED_AMOUNT | NUMBER | Oracle internal use only | |||
REVENUE_AMOUNT | NUMBER | Oracle internal use only | |||
AUTORULE_COMPLETE_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
TAX_PRECEDENCE | NUMBER | Oracle internal use only | |||
TAX_RATE | NUMBER | Oracle internal use only | |||
ITEM_EXCEPTION_RATE_ID | NUMBER | 18 | Oracle internal use only | ||
TAX_EXEMPTION_ID | NUMBER | 18 | Oracle internal use only | ||
MEMO_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
AUTORULE_DURATION_PROCESSED | NUMBER | 18 | Oracle internal use only | ||
UOM_CODE | VARCHAR2 | 3 | Oracle internal use only | ||
DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | 30 | Oracle internal use only | ||
VAT_TAX_ID | NUMBER | 18 | Oracle internal use only | ||
AUTOTAX | VARCHAR2 | 1 | Oracle internal use only | ||
LAST_PERIOD_TO_CREDIT | NUMBER | Oracle internal use only | |||
ITEM_CONTEXT | VARCHAR2 | 30 | Oracle internal use only | ||
TAX_EXEMPT_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
TAX_EXEMPT_NUMBER | VARCHAR2 | 80 | Oracle internal use only | ||
TAX_EXEMPT_REASON_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
TAX_VENDOR_RETURN_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
LOCATION_SEGMENT_ID | NUMBER | 18 | Oracle internal use only | ||
MOVEMENT_ID | NUMBER | 18 | Oracle internal use only | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
GROSS_UNIT_SELLING_PRICE | NUMBER | Oracle internal use only | |||
GROSS_EXTENDED_AMOUNT | NUMBER | Oracle internal use only | |||
AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
TAXABLE_AMOUNT | NUMBER | Oracle internal use only | |||
WAREHOUSE_ID | NUMBER | 18 | Oracle internal use only | ||
EXTENDED_ACCTD_AMOUNT | NUMBER | Oracle internal use only | |||
CONTRACT_LINE_ID | NUMBER | Oracle internal use only | |||
SOURCE_DATA_KEY1 | VARCHAR2 | 150 | Oracle internal use only | ||
SOURCE_DATA_KEY2 | VARCHAR2 | 150 | Oracle internal use only | ||
SOURCE_DATA_KEY3 | VARCHAR2 | 150 | Oracle internal use only | ||
SOURCE_DATA_KEY4 | VARCHAR2 | 150 | Oracle internal use only | ||
SOURCE_DATA_KEY5 | VARCHAR2 | 150 | Oracle internal use only | ||
INVOICED_LINE_ACCTG_LEVEL | VARCHAR2 | 15 | Oracle internal use only | ||
SHIP_VIA | VARCHAR2 | 30 | Oracle internal use only | ||
FOB_POINT | VARCHAR2 | 30 | Oracle internal use only | ||
WAYBILL_NUMBER | VARCHAR2 | 50 | Oracle internal use only | ||
SHIP_DATE_ACTUAL | DATE | Oracle internal use only | |||
GL_DATE | DATE | Oracle internal use only | |||
OVERRIDE_AUTO_ACCOUNTING_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
PARENT_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
DEFERRAL_EXCLUSION_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
SOURCE_APPLICATION_ID | NUMBER | 18 | Oracle internal use only | ||
SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
SOURCE_TRX_ID | NUMBER | 18 | Oracle internal use only | ||
SOURCE_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
SOURCE_TRX_LINE_TYPE | VARCHAR2 | 30 | Oracle internal use only | ||
SOURCE_TRX_DETAIL_TAX_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
HISTORICAL_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
TAXABLE_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
TAX_REGIME_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
TAX | VARCHAR2 | 30 | Oracle internal use only | ||
TAX_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
TAX_RATE_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Oracle internal use only | ||
RULE_END_DATE | DATE | Oracle internal use only | |||
INTEREST_LINE_ID | NUMBER | 18 | Oracle internal use only | ||
MEMO_LINE_SEQ_ID | NUMBER | 18 | Oracle internal use only |
Indexes
Index | Uniqueness | Columns |
---|---|---|
AR_TRX_LINES_GT_U1 | Unique | TRX_LINE_ID |
AR_TRX_LINES_GT_N1 | Non Unique | TRX_HEADER_ID |