[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JE_IT_TRX_ABOVE_THR_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JE |
| FND Design Data: |  JE.JE_IT_TRX_ABOVE_THR_ALL
|
| Subobject Name: | |
| Status: | VALID |
A table to store the detailed information of transactions which are eligible for Data Extraction
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JE_IT_TRX_ABOVE_THR_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 REQUEST_ID#1
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VAT_REPORTING_ENTITY_ID | NUMBER | (15) | Yes | Vat Reporting Entity Id |
| ORG_ID | NUMBER | (15) | Org ID | |
| APPLICATION_ID | NUMBER | (15) | Yes | Application ID |
| RECORD_TYPE | NUMBER | (1) | Data Extract Concurrent Request ID | |
| EFT_PROGRESSION_NUM | NUMBER | (5) | Org ID | |
| EFT_SEQUENTIAL_NUM | NUMBER | (5) | Application ID | |
| PARTY_ID | NUMBER | (15) | Third Party ID | |
| PARTY_NAME | VARCHAR2 | (240) | Third Party Name | |
| VAT_REGISTRATION_NUM | VARCHAR2 | (30) | Third Party VAT Registration Number | |
| TAX_PAYER_ID | VARCHAR2 | (30) | Third Party Taxpayer ID | |
| COUNTRY | VARCHAR2 | (3) | Country | |
| TRX_ID | NUMBER | (15) | Transaction ID | |
| TRX_NUM | VARCHAR2 | (50) | Transaction Number | |
| TRX_DATE | DATE | Transaction Date | ||
| TRX_GL_DATE | DATE | Transaction GL Date | ||
| TRX_TYPE | VARCHAR2 | (25) | Transaction Type | |
| PAYMENT_METHOD | VARCHAR2 | (50) | Transaction Payment Method | |
| TRX_ACCOUNTING_STATUS | VARCHAR2 | (15) | Transaction Accounting Status | |
| ASSESSABLE_AMT | NUMBER | (20) | Assessable Amount | |
| VAT_AMT | NUMBER | (20) | VAT Amount | |
| PAYMENT_MODE | VARCHAR2 | (2) | Payment Mode | |
| BELOW_THRESHOLD_FLAG | VARCHAR2 | (1) | Below Threshold Flag | |
| CONTRACT_IDENTIFICATION | VARCHAR2 | (30) | Contract Identification | |
| ORIG_TRX_ID | NUMBER | (15) | Original Transaction ID. Populated if the Transaction Type is either Credit memo or Debit memo | |
| ORIG_TRX_NUM | VARCHAR2 | (50) | Original Transaction Number. Populated if the Transaction Type is either Credit memo or Debit memo | |
| ORIG_TRX_DATE | DATE | Original Transaction Date. Populated if the Transaction Type is either Credit memo or Debit memo | ||
| ORIG_TRX_GL_DATE | DATE | Original Transaction GL Date. Populated if the Transaction Type is either Credit memo or Debit memo | ||
| ORIG_TRX_ACCTG_STATUS | VARCHAR2 | (15) | Original Transaction Accounting Status. Populated if the Transaction Type is either Credit memo or Debit memo | |
| ORIG_TRX_PAYMENT_METHOD | VARCHAR2 | (50) | Original Transaction Payment Method. Populated if the Transaction Type is either Credit memo or Debit memo | |
| PARTY_TYPE | VARCHAR2 | (20) | Third Party Type | |
| INDV_PARTY_DOB | DATE | Individual Party Date Of Birth. Populated if the Third party is an individual | ||
| INDV_PARTY_PROVINCE | VARCHAR2 | (3) | Individual Party Province code. Populated if the Third party is an individual | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| REQUEST_ID#1 | NUMBER | (15) | Yes | Data Extract Concurrent Request ID |
| INDV_PARTY_LAST_NAME#1 | VARCHAR2 | (150) | Individual Party Last Name. Populated if the Third party is an individual | |
| INDV_PARTY_FIRST_NAME#1 | VARCHAR2 | (150) | Individual Party First Name. Populated if the Third party is an individual | |
| INDV_PARTY_CITY#1 | VARCHAR2 | (120) | Individual Party City Name. Populated if the Third party is an individual | |
| COMPANY_CITY#1 | VARCHAR2 | (60) | Company City Name.Populated if the Third party is a company | |
| COMPANY_ADDRESS#1 | VARCHAR2 | (240) | Company Address.Populated if the Third party is a company |
Cut, paste (and edit) the following text to query this object:
SELECT VAT_REPORTING_ENTITY_ID
, ORG_ID
, APPLICATION_ID
, RECORD_TYPE
, EFT_PROGRESSION_NUM
, EFT_SEQUENTIAL_NUM
, PARTY_ID
, PARTY_NAME
, VAT_REGISTRATION_NUM
, TAX_PAYER_ID
, COUNTRY
, TRX_ID
, TRX_NUM
, TRX_DATE
, TRX_GL_DATE
, TRX_TYPE
, PAYMENT_METHOD
, TRX_ACCOUNTING_STATUS
, ASSESSABLE_AMT
, VAT_AMT
, PAYMENT_MODE
, BELOW_THRESHOLD_FLAG
, CONTRACT_IDENTIFICATION
, ORIG_TRX_ID
, ORIG_TRX_NUM
, ORIG_TRX_DATE
, ORIG_TRX_GL_DATE
, ORIG_TRX_ACCTG_STATUS
, ORIG_TRX_PAYMENT_METHOD
, PARTY_TYPE
, INDV_PARTY_DOB
, INDV_PARTY_PROVINCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID#1
, INDV_PARTY_LAST_NAME#1
, INDV_PARTY_FIRST_NAME#1
, INDV_PARTY_CITY#1
, COMPANY_CITY#1
, COMPANY_ADDRESS#1
FROM JE.JE_IT_TRX_ABOVE_THR_ALL;
JE.JE_IT_TRX_ABOVE_THR_ALL does not reference any database object
JE.JE_IT_TRX_ABOVE_THR_ALL is referenced by following:
JE
JE_IT_TRX_ABOVE_THR_ALL#
|
|
|
|