DBA Data[Home] [Help] [Dependency Information]

TABLE: JE.JE_IT_ABOVE_THR_HDR_ALL

Object Details
Object Name: JE_IT_ABOVE_THR_HDR_ALL
Object Type: TABLE
Owner: JE
FND Design Data: TableJE.JE_IT_ABOVE_THR_HDR_ALL
Subobject Name:
Status: VALID


This table stores the parameter details of Italian Invoice Above Threshold Data extract Run


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JE_IT_ABOVE_THR_HDR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID#1
Columns
Name Datatype Length Mandatory Comments
VAT_REPORTING_ENTITY_ID NUMBER (15) Yes Vat Reporting Entity Id
YEAR_OF_DECLARATION NUMBER (4) Yes Year Of Declaration
ORG_ID NUMBER (15)
Org Id
REPORT_MODE VARCHAR2 (1)
Report Mode
TYPE_OF_UPLOAD VARCHAR2 (1)
Type Of Upload
TRANSMISSION_CODE NUMBER (17)
Electronic Transmission code to be Substituted or Canceled
PROVINCE_CODE VARCHAR2 (2)
Province Code
DECLR_OF_INCORP_COMP NUMBER (1)
Declaration of an Incorporated Company
TRX_ACCOUNTING_STATUS VARCHAR2 (15)
Transaction Accounting Status
END_DATE_TO_EXTR_CM_DM DATE

End Date to extract Credit Memos and Debit Memos
B2C_INVOICE_THRESHOLD NUMBER (10)
B2C Invoice Threshold Amount
B2B_INVOICE_THRESHOLD NUMBER (10)
B2B Invoice Threshold Amount
START_DATE_TO_EXTR_B2C_TRX DATE

Start Date to Extract B2C Transactions
NO_OF_DETAILED_RECORDS NUMBER (5)
Maximum Number of Detail Records per EFT File.
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
PROTOCOL_NUM NUMBER (10)
Protocol Number
REQUEST_ID#1 NUMBER (15)
Italian Invoices Above Threshold Data Extract Request ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT VAT_REPORTING_ENTITY_ID
,      YEAR_OF_DECLARATION
,      ORG_ID
,      REPORT_MODE
,      TYPE_OF_UPLOAD
,      TRANSMISSION_CODE
,      PROVINCE_CODE
,      DECLR_OF_INCORP_COMP
,      TRX_ACCOUNTING_STATUS
,      END_DATE_TO_EXTR_CM_DM
,      B2C_INVOICE_THRESHOLD
,      B2B_INVOICE_THRESHOLD
,      START_DATE_TO_EXTR_B2C_TRX
,      NO_OF_DETAILED_RECORDS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROTOCOL_NUM
,      REQUEST_ID#1
FROM JE.JE_IT_ABOVE_THR_HDR_ALL;

Dependencies

[top of page]

JE.JE_IT_ABOVE_THR_HDR_ALL does not reference any database object

JE.JE_IT_ABOVE_THR_HDR_ALL is referenced by following:

SchemaJE
ViewJE_IT_ABOVE_THR_HDR_ALL#