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

TABLE: GMI.IN_STAT_DTL

Object Details
Object Name: IN_STAT_DTL
Object Type: TABLE
Owner: GMI
FND Design Data: TableGMI.IN_STAT_DTL
Subobject Name:
Status: VALID


EC Statistics Detail. Intrastat statistics detail file.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IN_STAT_DTL_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSTAT_ID
ColumnSTATLINE_ID
Columns
Name Datatype Length Mandatory Comments
STAT_ID NUMBER (10) Yes FK as found in in_stat_hdr
STATLINE_ID NUMBER (10) Yes surrogate key to this table
TRANS_ID NUMBER (10) Yes FK to ic_tran_pnd or ic_tran_cmp
PND_TRANS_ID NUMBER (10)
FK as found in ic_tran_pnd
CMP_TRANS_ID NUMBER (10)
FK as found in ic_tran_cmp
LINE_ID NUMBER (10) Yes FK as found in po_recv_dtl op_ordr_dtl, ic_adjs_jnl
PORECV_LINE_ID NUMBER (10)
FK as found in po_recv_dtl
OPORDR_LINE_ID NUMBER (10)
FK as found in op_ordr_dtl
ICADJS_LINE_ID NUMBER (10)
FK as found in ic_adjs_jnl
ITEM_ID NUMBER (10) Yes FK as found in ic_item_mst
LOT_ID NUMBER (10) Yes FK as found in ic_lots_mst
COMMODITY_CODE VARCHAR2 (9) Yes valid commodity code as defined in ic_comd_cds
STAT_QTY NUMBER (10) Yes quantity of goods moved in ?SY$INTRASTAT_UM?
STAT_UM VARCHAR2 (4) Yes value of ?SY$INTRASTAT_UM?
STAT_VALUE NUMBER (10) Yes value of goods in base currency
CURRENCY_CODE VARCHAR2 (4) Yes base currency code
TRANS_DATE DATE
Yes date of movement
STAT_SUPP_QTY NUMBER (10)
quantity of goods in supplementary unit of measure
STAT_SUPP_UM VARCHAR2 (4)
supplementary unit of measure
FROM_COUNTRY VARCHAR2 (3) Yes country code of member state where goods dispatched from.
TO_COUNTRY VARCHAR2 (3) Yes country code of member state where goods are moved to.
CTRY_OF_ORIGIN VARCHAR2 (3)
valid country code as defined in in_ctry_mst
FROM_REGION_CODE VARCHAR2 (4)
region code as defined in in_regn_mst where goods dispatched from.
TO_REGION_CODE VARCHAR2 (4)
valid region code as defined in in_regn_mst where goods moved to
TRANS_NATURE NUMBER (2) Yes Standard 2 digit code identifying nature of transaction.
EC_DELIVERY_CODE VARCHAR2 (4)
valid delivery code as defined in in_tofd_mst
MOT_CODE NUMBER (1)
Standard 1 digit code identifying mode of transport.
VAT_REGN VARCHAR2 (20) Yes VAT registration of customer / supplier or warehouse
BRANCH_NO NUMBER (3)
Branch identifier
PORT_CODE VARCHAR2 (8)
code of port
ORIGINATION_IND NUMBER (1) Yes 0 = manual creation / amendment1 = auto created by ?build? routine.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
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
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes used to logically delete row
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
Query Text

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


SELECT STAT_ID
,      STATLINE_ID
,      TRANS_ID
,      PND_TRANS_ID
,      CMP_TRANS_ID
,      LINE_ID
,      PORECV_LINE_ID
,      OPORDR_LINE_ID
,      ICADJS_LINE_ID
,      ITEM_ID
,      LOT_ID
,      COMMODITY_CODE
,      STAT_QTY
,      STAT_UM
,      STAT_VALUE
,      CURRENCY_CODE
,      TRANS_DATE
,      STAT_SUPP_QTY
,      STAT_SUPP_UM
,      FROM_COUNTRY
,      TO_COUNTRY
,      CTRY_OF_ORIGIN
,      FROM_REGION_CODE
,      TO_REGION_CODE
,      TRANS_NATURE
,      EC_DELIVERY_CODE
,      MOT_CODE
,      VAT_REGN
,      BRANCH_NO
,      PORT_CODE
,      ORIGINATION_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
FROM GMI.IN_STAT_DTL;

Dependencies

[top of page]

GMI.IN_STAT_DTL does not reference any database object

GMI.IN_STAT_DTL is referenced by following:

SchemaAPPS
SynonymIN_STAT_DTL