[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_BOE_DTLS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOE_ID | NUMBER | (15) | Yes | |
LINE_NUMBER | NUMBER | (15) | Yes | |
PKG_NUMBER | VARCHAR2 | (50) | ||
PKG_DESCRIPTION | VARCHAR2 | (50) | ||
SERIAL_NUMBER | VARCHAR2 | (50) | ||
QUANTITY | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
ITEM_NUMBER | VARCHAR2 | (50) | ||
CUSTOMS_TARIFF | VARCHAR2 | (50) | ||
DUTY_CODE | VARCHAR2 | (50) | ||
ACCESSIBLE_VALUE | NUMBER | |||
BASIC_DUTY_RATE | NUMBER | |||
BASIC_DUTY_AMOUNT | NUMBER | |||
EXEMPTION_NUM | VARCHAR2 | (50) | ||
TOTAL_VALUE | NUMBER | |||
ADDL_DUTY_RATE | NUMBER | |||
ADDL_DUTY_AMOUNT | NUMBER | |||
CUMM_DUTY_AMOUNT | NUMBER | |||
SURCH_DUTY_RATE | NUMBER | |||
SURCH_DUTY_AMOUNT | NUMBER | |||
TOTAL_DUTY_AMOUNT | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
EDU_CESS_CVD_RATE | NUMBER | |||
EDU_CESS_CVD_AMOUNT | NUMBER | |||
EDU_CESS_CVD_BASIS | NUMBER | |||
EDU_CESS_CUSTOMS_RATE | NUMBER | |||
EDU_CESS_CUSTOMS_AMOUNT | NUMBER | |||
EDU_CESS_CUSTOMS_BASIS | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | |||
ADDITIONAL_CVD_RATE | NUMBER | (15) | ||
ADDITIONAL_CVD_AMT | NUMBER | (38) | ||
ADDITIONAL_CVD_BASIS | NUMBER | (38) | ||
SH_CUSTOMS_CESS_AMOUNT | NUMBER | |||
SH_CUSTOMS_CESS_BASIS | NUMBER | |||
SH_CUSTOMS_CESS_RATE | NUMBER | |||
SH_CVD_CESS_AMOUNT | NUMBER | |||
SH_CVD_CESS_BASIS | NUMBER | |||
SH_CVD_CESS_RATE | NUMBER | |||
SH_EDU_CESS_AMOUNT | NUMBER | |||
SH_EDU_CESS_BASIS | NUMBER | |||
SH_EDU_CESS_RATE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BOE_ID
, LINE_NUMBER
, PKG_NUMBER
, PKG_DESCRIPTION
, SERIAL_NUMBER
, QUANTITY
, UOM_CODE
, ITEM_NUMBER
, CUSTOMS_TARIFF
, DUTY_CODE
, ACCESSIBLE_VALUE
, BASIC_DUTY_RATE
, BASIC_DUTY_AMOUNT
, EXEMPTION_NUM
, TOTAL_VALUE
, ADDL_DUTY_RATE
, ADDL_DUTY_AMOUNT
, CUMM_DUTY_AMOUNT
, SURCH_DUTY_RATE
, SURCH_DUTY_AMOUNT
, TOTAL_DUTY_AMOUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, EDU_CESS_CVD_RATE
, EDU_CESS_CVD_AMOUNT
, EDU_CESS_CVD_BASIS
, EDU_CESS_CUSTOMS_RATE
, EDU_CESS_CUSTOMS_AMOUNT
, EDU_CESS_CUSTOMS_BASIS
, OBJECT_VERSION_NUMBER
, ADDITIONAL_CVD_RATE
, ADDITIONAL_CVD_AMT
, ADDITIONAL_CVD_BASIS
, SH_CUSTOMS_CESS_AMOUNT
, SH_CUSTOMS_CESS_BASIS
, SH_CUSTOMS_CESS_RATE
, SH_CVD_CESS_AMOUNT
, SH_CVD_CESS_BASIS
, SH_CVD_CESS_RATE
, SH_EDU_CESS_AMOUNT
, SH_EDU_CESS_BASIS
, SH_EDU_CESS_RATE
FROM JA.JAI_CMN_BOE_DTLS#;
|
|
|