[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JE_IT_TRX_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | JE |
| FND Design Data: |  JE.JE_IT_TRX_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
This table stores the detailed information of transactions which are eligible for Italian Invoices Above Threshold Data Extraction
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JE_IT_TRX_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 REQUEST_ID#1
|
| JE_IT_TRX_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORIG_TRX_ID
|
| JE_IT_TRX_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRX_LINE_ID
|
| JE_IT_TRX_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID#1
TRX_ID
|
| 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 |
| 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 | |
| TRX_LINE_ID | NUMBER | (15) | Transaction Line ID | |
| TRX_LINE_NUM | NUMBER | (5) | Trasnction Line Number | |
| TRX_LINE_TYPE | VARCHAR2 | (20) | Transaction Line Type | |
| ASSESSABLE_AMT | NUMBER | Assessable Amount | ||
| VAT_AMT | NUMBER | VAT Amount | ||
| PAYMENT_MODE | VARCHAR2 | (2) | Payment Mode | |
| BELOW_THRESHOLD_FLAG | VARCHAR2 | (1) | Below Threshold Flag | |
| REPORT_EXCLUSION_FLAG | VARCHAR2 | (1) | Report Exclusion Flag | |
| CONTRACT_IDENTIFICATION | VARCHAR2 | (30) | Contract Identification | |
| ADJ_INV_FLAG | VARCHAR2 | (1) | Adjustment Invoice Flag. Y or N | |
| ORIG_TRX_ID | NUMBER | (15) | Original Transaction ID. Populated if the Transaction Type is either Credit memo or Debit memo | |
| RECORD_TYPE | NUMBER | (1) | Record Type | |
| 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 | |
| INCONST_CM_DM_APPL_FLAG | VARCHAR2 | (1) | Inconsistent Credit/Debit memo application | |
| ORIG_TRX_MISSING_FLAG | VARCHAR2 | (1) | Original Transaction Missing Flag | |
| PAYMENT_MODE_ERR_FLAG | VARCHAR2 | (1) | Payment Mode Error Flag | |
| PARTIAL_ADJ_INV_FLAG | VARCHAR2 | (1) | Partial Adjustment Invoice Flag. This column will be populated with 'Y' if the 'Adjustment Invoice Flag' of the GDF is populated only for some invoice lines. | |
| IS_ABOVE_THRESHOLD | VARCHAR2 | (1) | Is Above Threshold Flag | |
| 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 | commnet 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
, 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
, TRX_LINE_ID
, TRX_LINE_NUM
, TRX_LINE_TYPE
, ASSESSABLE_AMT
, VAT_AMT
, PAYMENT_MODE
, BELOW_THRESHOLD_FLAG
, REPORT_EXCLUSION_FLAG
, CONTRACT_IDENTIFICATION
, ADJ_INV_FLAG
, ORIG_TRX_ID
, RECORD_TYPE
, PARTY_TYPE
, INDV_PARTY_DOB
, INDV_PARTY_PROVINCE
, INCONST_CM_DM_APPL_FLAG
, ORIG_TRX_MISSING_FLAG
, PAYMENT_MODE_ERR_FLAG
, PARTIAL_ADJ_INV_FLAG
, IS_ABOVE_THRESHOLD
, 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_LINES_ALL;
JE.JE_IT_TRX_LINES_ALL does not reference any database object
JE.JE_IT_TRX_LINES_ALL is referenced by following:
JE
JE_IT_TRX_LINES_ALL#
|
|
|
|