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

TABLE: JA.JAI_CMN_BOE_DTLS

Object Details
Object Name: JAI_CMN_BOE_DTLS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_CMN_BOE_DTLS
Subobject Name:
Status: VALID


Stores information about the Bill of entry details. Bill of entry details are as per the existing BOE format. For one bill of entry there could be more than one detail record existing in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_CMN_BOE_DTLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOE_ID
ColumnLINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
BOE_ID NUMBER (15) Yes BOE identifier.
LINE_NUMBER NUMBER (15) Yes BOE line identifier.
PKG_NUMBER VARCHAR2 (50)
Package Number.
PKG_DESCRIPTION VARCHAR2 (50)
Package Description.
SERIAL_NUMBER VARCHAR2 (50)
Serial Number.
QUANTITY NUMBER

Quantity.
UOM_CODE VARCHAR2 (3)
Unit of measure code.
ITEM_NUMBER VARCHAR2 (50)
Item number.
CUSTOMS_TARIFF VARCHAR2 (50)
Customs Tariff no / code.
DUTY_CODE VARCHAR2 (50)
Duty Code.
ACCESSIBLE_VALUE NUMBER

Assessable value.
BASIC_DUTY_RATE NUMBER

Basic Customs Duty rate.
BASIC_DUTY_AMOUNT NUMBER

Basic Customs Duty amount.
EXEMPTION_NUM VARCHAR2 (50)
Duty exemption number.
TOTAL_VALUE NUMBER

Total Value of the asset.
ADDL_DUTY_RATE NUMBER

Additional Customs Duty rate.
ADDL_DUTY_AMOUNT NUMBER

Additional Customs Duty amount.
CUMM_DUTY_AMOUNT NUMBER

Cumulative Value of the asset.
SURCH_DUTY_RATE NUMBER

Surcharge Customs Duty rate.
SURCH_DUTY_AMOUNT NUMBER

Surcharge Customs Duty Amount.
TOTAL_DUTY_AMOUNT NUMBER

Total Customs Duty amount.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
EDU_CESS_CVD_RATE NUMBER

Indicates the Rate of education cess on CVD
EDU_CESS_CVD_AMOUNT NUMBER

Education Cess Amount calculated for CVD
EDU_CESS_CVD_BASIS NUMBER

CVD Amount on which education cess is calculated
EDU_CESS_CUSTOMS_RATE NUMBER

Indicates the Rate of education cess on Customs
EDU_CESS_CUSTOMS_AMOUNT NUMBER

Customs Amount on which education cess is calculated
EDU_CESS_CUSTOMS_BASIS NUMBER

Education Cess Amount calculated for Customs
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
ADDITIONAL_CVD_RATE NUMBER (15)
It Holds the rate of additional CVD
ADDITIONAL_CVD_AMT NUMBER (38)
It holds the amount of additional CVD
ADDITIONAL_CVD_BASIS NUMBER (38)
It holds the basis for additional CVD.
SH_CUSTOMS_CESS_AMOUNT NUMBER

Indicates the SHE CUSTOMS Cess amount in bill of entry
SH_CUSTOMS_CESS_BASIS NUMBER

Indicates the basis for SHE CUSTOMS Cess amount calculation in bill of entry
SH_CUSTOMS_CESS_RATE NUMBER

Indicates the rate of SHE CUSTOMS Cess in bill of entry
SH_CVD_CESS_AMOUNT NUMBER

Indicates the SHE CVD Cess amount in bill of entry
SH_CVD_CESS_BASIS NUMBER

Indicates the basis on which SHE CVD Cess amount is calculated in bill of entry
SH_CVD_CESS_RATE NUMBER

Indicates the rate of SHE CVD Cess in bill of entry
SH_EDU_CESS_AMOUNT NUMBER

Indicates the SHE EXCISE Cess amount in bill of entry
SH_EDU_CESS_BASIS NUMBER

Indicates the basis for SHE EXCISE Cess amount calculation in bill of entry
SH_EDU_CESS_RATE NUMBER

Indicates the rate of SHE EXCISE Cess in bill of entry
Query Text

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;

Dependencies

[top of page]

JA.JAI_CMN_BOE_DTLS does not reference any database object

JA.JAI_CMN_BOE_DTLS is referenced by following:

SchemaAPPS
SynonymJAI_CMN_BOE_DTLS