AR_DOC_TRANSFER_LINE_EXT
This is a temporary table which is used internally by Oracle. The AR_DOC_TRANSFER_LINE_EXT table stores the extended attributes that used for the xml invoicing service and data will be purged periodically.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AR_DOC_TRANSFER_LINE_EXT_PK |
DOC_TRANSFER_LINE_EXT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DOC_TRANSFER_LINE_EXT_ID | NUMBER | 18 | Yes | Unique identifier of document transfer line. | |
CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Yes | Identifier of the Customer Transaction Line. | |
CUSTOMER_TRX_ID | NUMBER | 18 | Yes | Identifier of the Customer Transaction. | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
ITEM_DESCRIPTION_US | VARCHAR2 | 80 | Description of this standard memo line in English. | ||
USER_DEFINED_FISC_CLASS_ID | NUMBER | 18 | Unique identifier of user defined fiscal classification codes. | ||
USER_DEFINED_FISC_CLASS_NAME | VARCHAR2 | 240 | User defined fiscal classification name. | ||
PRODUCT_CATEGORY_ID | NUMBER | 18 | Unique identifier of Product category. | ||
PRODUCT_CATEGORY_CODE | VARCHAR2 | 30 | Use to identify the product category code. | ||
PRODUCT_CATEGORY_NAME | VARCHAR2 | 240 | Indicates the product category name. | ||
LINE_INTENDED_USE_DESC | VARCHAR2 | 240 | Transaction line intended use tax determinant name. | ||
LINE_INTENDED_USE_CODE | VARCHAR2 | 820 | Transaction line intended use tax determinant code. | ||
PRODUCT_FISC_CLASSIF_DESC | VARCHAR2 | 240 | Product fiscal classification tax determinant description. | ||
PRODUCT_FISC_CLASSIF_CODE | VARCHAR2 | 820 | Product fiscal classification code based tax determinant. | ||
TRX_BUSINESS_CATEGORY_NAME | VARCHAR2 | 240 | Transaction business category name based tax determinant. | ||
TAX_CLASSIFICATION_MEANING | VARCHAR2 | 80 | Meaning of the tax classification. | ||
ITEM_CATEGORY_NAME | VARCHAR2 | 250 | Indicates the Item Category Name. | ||
TP_ITEM_DESC | VARCHAR2 | 150 | Trading partner item's description. | ||
TP_ITEM_NUMBER | VARCHAR2 | 240 | Indicates the trading partner item number. | ||
TAX_EXEMPT_HANDLING | VARCHAR2 | 80 | Tax exemption handling selected for the transaction | ||
ORDER_PRICE_ELEMENT_CODE | VARCHAR2 | 30 | Element reference to the Price Elements setup, for example LISTPRICE and NETPRICE. | ||
ORDER_PRICE_ELEMENT_USAGE_CODE | VARCHAR2 | 30 | Indicates how the charge component is used. Values are populated from a QP lookup OOTB. The values include List Price and Invoice Price. | ||
ORDER_ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | Indicates the method used for calculating a manual/negotiated discount for product charge. | ||
ORDER_ADJUSTMENT_REASON_CODE | VARCHAR2 | 30 | Code which explains the details of a manual discount. | ||
SHIP_TO_LOC_NAME | VARCHAR2 | 360 | Party name for the ship-to location. | ||
SHIP_TO_LOC_ADDRESS1 | VARCHAR2 | 240 | Address line 1 of the ship-to location. | ||
SHIP_TO_LOC_ADDRESS2 | VARCHAR2 | 240 | Address line 2 of the ship-to location. | ||
SHIP_TO_LOC_ADDRESS3 | VARCHAR2 | 240 | Address line 3 of the ship-to location. | ||
SHIP_TO_LOC_CITY | VARCHAR2 | 60 | City name of the ship-to location. | ||
SHIP_TO_LOC_POSTAL_CODE | VARCHAR2 | 60 | Postal code of the ship-to location. | ||
SHIP_TO_LOC_COUNTY | VARCHAR2 | 60 | County of the ship-to location. | ||
SHIP_TO_LOC_COUNTRY | VARCHAR2 | 2 | Country code of the ship-to location. | ||
ORIGINAL_TRX_NUMBER | VARCHAR2 | 20 | Transaction number of the original transaction. | ||
ORIGINAL_TRX_TYPE | VARCHAR2 | 20 | Transaction type name of the original transaction. | ||
ORIGINAL_TRX_CLASS | VARCHAR2 | 20 | Transaction class of the original transaction. | ||
ORIGINAL_TRX_DATE | DATE | Transaction date of the original transaction. | |||
ORIGINAL_LINE_NUMBER | NUMBER | Line number of the original line of the transaction. | |||
LEGAL_JUSTIFICATION_CODE | VARCHAR2 | 60 | Column to store alphanumeric value for the reporting code. | ||
LEGAL_JUSTIFICATION_TEXT | VARCHAR2 | 240 | Description of the reporting code. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AR_DOC_TRANSFER_LINE_EXT_N1 | Non Unique | Default | CUSTOMER_TRX_ID, REQUEST_ID |
AR_DOC_TRANSFER_LINE_EXT_U1 | Unique | Default | DOC_TRANSFER_LINE_EXT_ID |