ZX_WHT_TRX_LINES_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| TRX_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| INDIRECT_TAX_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRX_LINE_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| ACCOUNT_CCID | NUMBER | 18 | Oracle internal use only. | ||
| ACCOUNT_STRING | VARCHAR2 | 1000 | Oracle internal use only. | ||
| ADJ_DOC_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJ_DOC_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJUSTED_DOC_APPLICATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| ADJUSTED_DOC_DATE | DATE | Oracle internal use only. | |||
| ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| ADJUSTED_DOC_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| ADJUSTED_DOC_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADJUSTED_DOC_TRX_ID | NUMBER | 18 | Oracle internal use only. | ||
| ADJUSTED_DOC_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APP_FROM_DST_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_DST_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_DST_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_DST_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_DST_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_DST_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_LIN_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_LIN_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_LIN_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_LIN_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_LIN_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_FROM_LIN_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_TO_HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_TO_HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_TO_HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_TO_HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_TO_HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APP_TO_HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| APPLIED_FROM_APPLICATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLIED_FROM_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| APPLIED_FROM_TRX_ID | NUMBER | 18 | Oracle internal use only. | ||
| APPLIED_FROM_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | ||
| APPLIED_TO_APPLICATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| APPLIED_TO_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLIED_TO_TRX_ID | NUMBER | 18 | Oracle internal use only. | ||
| APPLIED_TO_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| APPLIED_TO_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | ||
| ASSESSABLE_VALUE | NUMBER | Oracle internal use only. | |||
| ASSET_ACCUM_DEPRECIATION | NUMBER | Oracle internal use only. | |||
| ASSET_COST | NUMBER | Oracle internal use only. | |||
| ASSET_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| ASSET_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | ||
| ASSET_TYPE | VARCHAR2 | 150 | Oracle internal use only. | ||
| BILL_FROM_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_FROM_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_FROM_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_FROM_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_FROM_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_THIRD_PTY_ACCT_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_THIRD_PTY_ACCT_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_CUST_ACCT_SITE_USE_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| CASH_DISCOUNT | NUMBER | Oracle internal use only. | |||
| CHAR1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR10 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR7 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR8 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHAR9 | VARCHAR2 | 150 | Oracle internal use only. | ||
| CHECKRUN_ID | NUMBER | 18 | Oracle internal use only. | ||
| DATE1 | DATE | Oracle internal use only. | |||
| DATE10 | DATE | Oracle internal use only. | |||
| DATE2 | DATE | Oracle internal use only. | |||
| DATE3 | DATE | Oracle internal use only. | |||
| DATE4 | DATE | Oracle internal use only. | |||
| DATE5 | DATE | Oracle internal use only. | |||
| DATE6 | DATE | Oracle internal use only. | |||
| DATE7 | DATE | Oracle internal use only. | |||
| DATE8 | DATE | Oracle internal use only. | |||
| DATE9 | DATE | Oracle internal use only. | |||
| DEFAULTING_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DEFAULTING_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. | ||
| DISCOUNT_AMT | NUMBER | Oracle internal use only. | |||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| FIRST_PTY_ORG_ID | NUMBER | 18 | Oracle internal use only. | ||
| FOB_POINT | VARCHAR2 | 30 | Oracle internal use only. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| HDR_GL_DATE | DATE | Oracle internal use only. | |||
| HDR_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| HDR_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| HDR_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| HDR_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| HDR_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| HDR_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| HISTORICAL_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| HQ_ESTB_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| INPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Oracle internal use only. | ||
| INSURANCE_CHARGE | NUMBER | Oracle internal use only. | |||
| INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Oracle internal use only. | ||
| INTERNAL_ORG_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| INTERNAL_ORGANIZATION_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| LINE_AMT | NUMBER | Yes | Oracle internal use only. | ||
| LINE_CLASS | VARCHAR2 | 30 | Oracle internal use only. | ||
| LINE_INTENDED_USE | VARCHAR2 | 30 | Oracle internal use only. | ||
| LINE_LEVEL_ACTION | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| LINE_TRX_USER_KEY1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| LINE_TRX_USER_KEY2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| LINE_TRX_USER_KEY3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| LINE_TRX_USER_KEY4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| LINE_TRX_USER_KEY5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| LINE_TRX_USER_KEY6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| MERCHANT_PARTY_COUNTRY | VARCHAR2 | 150 | Oracle internal use only. | ||
| MERCHANT_PARTY_DOCUMENT_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | ||
| MERCHANT_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| MERCHANT_PARTY_NAME | VARCHAR2 | 150 | Oracle internal use only. | ||
| MERCHANT_PARTY_REFERENCE | VARCHAR2 | 150 | Oracle internal use only. | ||
| MERCHANT_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| MERCHANT_PARTY_TAX_REG_NUMBER | VARCHAR2 | 150 | Oracle internal use only. | ||
| MERCHANT_PARTY_TAXPAYER_ID | VARCHAR2 | 150 | Oracle internal use only. | ||
| NUMERIC1 | NUMBER | Oracle internal use only. | |||
| NUMERIC10 | NUMBER | Oracle internal use only. | |||
| NUMERIC2 | NUMBER | Oracle internal use only. | |||
| NUMERIC3 | NUMBER | Oracle internal use only. | |||
| NUMERIC4 | NUMBER | Oracle internal use only. | |||
| NUMERIC5 | NUMBER | Oracle internal use only. | |||
| NUMERIC6 | NUMBER | Oracle internal use only. | |||
| NUMERIC7 | NUMBER | Oracle internal use only. | |||
| NUMERIC8 | NUMBER | Oracle internal use only. | |||
| NUMERIC9 | NUMBER | Oracle internal use only. | |||
| OTHER_CHARGE | NUMBER | Oracle internal use only. | |||
| OUTPUT_TAX_CLASSIFICATION_CODE | VARCHAR2 | 50 | Oracle internal use only. | ||
| OWN_HQ_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| OWN_HQ_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| OWN_HQ_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| OWN_HQ_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| OWN_HQ_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| PAYING_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| PAYING_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| PAYING_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| PAYING_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| PAYING_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| PAYMENT_AMT | NUMBER | Oracle internal use only. | |||
| PAYMENT_ID | NUMBER | 18 | Oracle internal use only. | ||
| POA_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| POA_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| POA_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| POA_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POA_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POC_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| POD_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| POD_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| POD_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| POD_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POD_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POI_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| POI_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| POI_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| POI_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POI_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POO_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| POO_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| POO_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| POO_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| POO_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| PROD_FC_CATEG_ID | NUMBER | 18 | Oracle internal use only. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Oracle internal use only. | ||
| PRODUCT_CODE | VARCHAR2 | 300 | Oracle internal use only. | ||
| PRODUCT_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Oracle internal use only. | ||
| PRODUCT_ID | NUMBER | 18 | Oracle internal use only. | ||
| PRODUCT_ORG_ID | NUMBER | 18 | Oracle internal use only. | ||
| PRODUCT_TYPE | VARCHAR2 | 240 | Oracle internal use only. | ||
| PROJECT_ID | NUMBER | 18 | Oracle internal use only. | ||
| PROVNL_TAX_DETERMINATION_DATE | DATE | Oracle internal use only. | |||
| RECEIVABLES_TRX_TYPE_SEQ_ID | NUMBER | 18 | Oracle internal use only. | ||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only. | |
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_FROM_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_FROM_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_FROM_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_FROM_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_THIRD_PTY_ACCT_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_THIRD_PTY_ACCT_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_TO_CUST_ACCT_SITE_USE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_TO_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_TO_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| SHIP_TO_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| SOURCE_APPLICATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| SOURCE_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SOURCE_TAX_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SOURCE_TRX_ID | NUMBER | 18 | Oracle internal use only. | ||
| SOURCE_TRX_LEVEL_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| START_EXPENSE_DATE | DATE | Oracle internal use only. | |||
| TAX | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_ID | NUMBER | 18 | Oracle internal use only. | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_JURISDICTION_ID | NUMBER | 18 | Oracle internal use only. | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_REGIME_ID | NUMBER | 18 | Oracle internal use only. | ||
| TAX_REPORTING_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| TITLE_TRANS_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| TITLE_TRANS_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| TITLE_TRANSFER_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| TITLE_TRANSFER_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| TITLE_TRANSFER_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRADING_DISCOUNT | NUMBER | Oracle internal use only. | |||
| TRADING_HQ_LOCATION_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRADING_HQ_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRADING_HQ_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRADING_HQ_PARTY_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRADING_HQ_SITE_TAX_PROF_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRANSFER_CHARGE | NUMBER | Oracle internal use only. | |||
| TRANSPORTATION_CHARGE | NUMBER | Oracle internal use only. | |||
| TRX_BATCH_ID | NUMBER | 18 | Oracle internal use only. | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. | ||
| TRX_ID_LEVEL2 | NUMBER | Oracle internal use only. | |||
| TRX_ID_LEVEL3 | NUMBER | Oracle internal use only. | |||
| TRX_ID_LEVEL4 | NUMBER | Oracle internal use only. | |||
| TRX_ID_LEVEL5 | NUMBER | Oracle internal use only. | |||
| TRX_ID_LEVEL6 | NUMBER | Oracle internal use only. | |||
| TRX_LINE_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| TRX_LINE_CURRENCY_CONV_DATE | DATE | Oracle internal use only. | |||
| TRX_LINE_CURRENCY_CONV_RATE | NUMBER | Oracle internal use only. | |||
| TRX_LINE_CURRENCY_CONV_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TRX_LINE_DATE | DATE | Oracle internal use only. | |||
| TRX_LINE_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| TRX_LINE_GL_DATE | DATE | Oracle internal use only. | |||
| TRX_LINE_MAU | NUMBER | Oracle internal use only. | |||
| TRX_LINE_NUMBER | NUMBER | Oracle internal use only. | |||
| TRX_LINE_PRECISION | NUMBER | Oracle internal use only. | |||
| TRX_LINE_QUANTITY | NUMBER | Oracle internal use only. | |||
| TRX_LINE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| TRX_RECEIPT_DATE | DATE | Oracle internal use only. | |||
| TRX_SHIPPING_DATE | DATE | Oracle internal use only. | |||
| TRX_SIC_CODE | VARCHAR2 | 150 | Oracle internal use only. | ||
| TRX_WAYBILL_NUMBER | VARCHAR2 | 50 | Oracle internal use only. | ||
| UNIT_PRICE | NUMBER | Oracle internal use only. | |||
| UOM_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | Oracle internal use only. | ||
| USER_UPD_DET_FACTORS_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| VOLUME_DISCOUNT | NUMBER | Oracle internal use only. | |||
| WHT_GROUP_ID | NUMBER | 18 | Oracle internal use only. | ||
| WITHHELD_TAX_AMT | NUMBER | Oracle internal use only. | |||
| RETAINAGE_AMT | NUMBER | Retainage amount for the item line. | |||
| RETAINAGE_PERCENTAGE | NUMBER | Retainage percentage for the item line. | |||
| TAX_GROSS_NET_FLAG | VARCHAR2 | 1 | Transaction tax calculated on the gross or net amount identifier. | ||
| WHT_GROSS_NET_FLAG | VARCHAR2 | 1 | Withholding tax calculated on the gross or net amount identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_WHT_TRX_LINES_GT_U1 | Unique | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, INDIRECT_TAX_LINE_ID, TRX_LINE_ID, TRX_LEVEL_TYPE |