[Home] [Help] [Dependency Information]
Object Name: | IN_STAT_DTL# |
---|---|
Object Type: | VIEW |
Owner: | GMI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STAT_ID | NUMBER | (10) | Yes | |
STATLINE_ID | NUMBER | (10) | Yes | |
TRANS_ID | NUMBER | (10) | Yes | |
PND_TRANS_ID | NUMBER | (10) | ||
CMP_TRANS_ID | NUMBER | (10) | ||
LINE_ID | NUMBER | (10) | Yes | |
PORECV_LINE_ID | NUMBER | (10) | ||
OPORDR_LINE_ID | NUMBER | (10) | ||
ICADJS_LINE_ID | NUMBER | (10) | ||
ITEM_ID | NUMBER | (10) | Yes | |
LOT_ID | NUMBER | (10) | Yes | |
COMMODITY_CODE | VARCHAR2 | (9) | Yes | |
STAT_QTY | NUMBER | (10) | Yes | |
STAT_UM | VARCHAR2 | (4) | Yes | |
STAT_VALUE | NUMBER | (10) | Yes | |
CURRENCY_CODE | VARCHAR2 | (4) | Yes | |
TRANS_DATE | DATE | Yes | ||
STAT_SUPP_QTY | NUMBER | (10) | ||
STAT_SUPP_UM | VARCHAR2 | (4) | ||
FROM_COUNTRY | VARCHAR2 | (3) | Yes | |
TO_COUNTRY | VARCHAR2 | (3) | Yes | |
CTRY_OF_ORIGIN | VARCHAR2 | (3) | ||
FROM_REGION_CODE | VARCHAR2 | (4) | ||
TO_REGION_CODE | VARCHAR2 | (4) | ||
TRANS_NATURE | NUMBER | (2) | Yes | |
EC_DELIVERY_CODE | VARCHAR2 | (4) | ||
MOT_CODE | NUMBER | (1) | ||
VAT_REGN | VARCHAR2 | (20) | Yes | |
BRANCH_NO | NUMBER | (3) | ||
PORT_CODE | VARCHAR2 | (8) | ||
ORIGINATION_IND | NUMBER | (1) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
TRANS_CNT | NUMBER | (10) | ||
DELETE_MARK | NUMBER | (5) | Yes | |
TEXT_CODE | NUMBER | (10) |
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#;
|
|
|