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 |