[Home] [Help] [Dependency Information]
Object Name: | JE_IT_LIST_PARTIES_ALL |
---|---|
Object Type: | TABLE |
Owner: | JE |
FND Design Data: | JE.JE_IT_LIST_PARTIES_ALL |
Subobject Name: | |
Status: | VALID |
JE_IT_LIST_PARTIES_ALL table contains Italian Annual Supplier and Customer listing extract summary data
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JE_IT_LIST_PARTIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
VAT_REPORTING_ENTITY_ID
YEAR_OF_DECLARATION PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | No longer used | |
ORG_ID | NUMBER | (15) | No longer used | |
TRANSMISSION_NUM | NUMBER | (15) | Yes | Gapless transmission progressive number |
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier. 200 for SQLAP and 222 for AR |
PARTY_ID | NUMBER | (15) | Yes | Party identifier |
TAXABLE_AMT | NUMBER | Taxable amount | ||
VAT_AMT | NUMBER | VAT amount | ||
NON_TAXABLE_AMT | NUMBER | Non taxable amount | ||
EXEMPT_AMT | NUMBER | Exempt Amount | ||
TAXABLE_VAT_AMT | NUMBER | Taxable amount which includes VAT | ||
TAXABLE_VAT_INV_AMT | NUMBER | Taxable amount which includes VAT not shown in the invoice | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
PARTY_SEQUENCE_NUM | NUMBER | Party sequence number | ||
VAT_REPORTING_ENTITY_ID | NUMBER | (15) | VAT reporting entity configuration identifier | |
YEAR_OF_DECLARATION | NUMBER | (4) | Year of declaration | |
CM_TAXABLE_AMT | NUMBER | Credit memos taxable amount | ||
CM_VAT_AMT | NUMBER | Credit memos VAT amount | ||
CM_NON_TAXABLE_AMT | NUMBER | Credit memos non taxable amount | ||
CM_EXEMPT_AMT | NUMBER | Credit memos exempt amount | ||
CM_TAXABLE_VAT_AMT | NUMBER | Credit memos taxable amount which includes VAT | ||
CM_TAXABLE_VAT_INV_AMT | NUMBER | Credit memos taxable amount which includes VAT not shown in the invoice | ||
VAT_REGISTRATION_NUM | VARCHAR2 | (60) | VAT registration number | |
FISCAL_ID_NUM | VARCHAR2 | (30) | Taxpayer ID |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_NAME
, ORG_ID
, TRANSMISSION_NUM
, APPLICATION_ID
, PARTY_ID
, TAXABLE_AMT
, VAT_AMT
, NON_TAXABLE_AMT
, EXEMPT_AMT
, TAXABLE_VAT_AMT
, TAXABLE_VAT_INV_AMT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, PARTY_SEQUENCE_NUM
, VAT_REPORTING_ENTITY_ID
, YEAR_OF_DECLARATION
, CM_TAXABLE_AMT
, CM_VAT_AMT
, CM_NON_TAXABLE_AMT
, CM_EXEMPT_AMT
, CM_TAXABLE_VAT_AMT
, CM_TAXABLE_VAT_INV_AMT
, VAT_REGISTRATION_NUM
, FISCAL_ID_NUM
FROM JE.JE_IT_LIST_PARTIES_ALL;
JE.JE_IT_LIST_PARTIES_ALL does not reference any database object
JE.JE_IT_LIST_PARTIES_ALL is referenced by following:
|
|
|