eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JA.JAI_CMN_BOE_HDRS_ALL

Object Details

Object Name:	JAI_CMN_BOE_HDRS_ALL
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_BOE_HDRS_ALL
Subobject Name:
Status:	VALID

Stores information about the Bill of entry header. Bill of entry header is as per the existing BOE format. For one bill of entry there will be one and only one record existing in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_BOE_HDRS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BOE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BOE_ID	NUMBER	(15)	Yes	Unique identifier, generated by system upon saving.
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization identifier.
BOE_TYPE	VARCHAR2	(25)		BOE type, the possible values can be defined by the user.
PORT_CODE	VARCHAR2	(25)		Port code.
BOL_DATE	DATE		Yes	Bill of leading date.
AGENT_ID	NUMBER	(15)		Agent identifier.
VESSEL_NAME	VARCHAR2	(50)		Vessel Name.
PORT_NAME	VARCHAR2	(50)		Port Name.
COUNTRY_ORIGIN	VARCHAR2	(50)		Country originating consignment.
COUNTRY_CONSIGNMNT	VARCHAR2	(50)		Country of consignment.
IMPORT_SR_NUM	VARCHAR2	(50)		Import Serial Number.
IMPORT_DATE	DATE			Import Date.
ROTATION_NO	VARCHAR2	(50)		Rotation Number.
ROTATION_DATE	DATE			Rotation Date.
BOE_AMOUNT	NUMBER		Yes	Bill of Entry Amount.
AMOUNT_APPLIED	NUMBER			Amount Applied.
VENDOR_ID	NUMBER	(15)	Yes	Vendor identifier.
VENDOR_SITE_ID	NUMBER	(15)	Yes	Vendor site identifier.
LOCATION_ID	NUMBER	(15)		Location identifier.
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
AMOUNT_WRITTEN_OFF	NUMBER			Written Off Amount.
CONSOLIDATED_FLAG	VARCHAR2	(1)		Indicates BOE is item independent.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
INVOICE_NUM	VARCHAR2	(50)		Stores the invoice number generated for the BOE
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ORG_ID	NUMBER	(15)		Operating Unit for the transaction.
BOE_DATE	DATE			System Date will be shown and User can change the same. This will be used as the AP Invoice Accounting Date.
BOE_WITHOUT_REFER_FLAG	VARCHAR2	(1)		Flag to indicate that BOE can be created without reference of PO etc.
CURRENCY_CODE	VARCHAR2	(30)		Currency code, used for deriving custom notified currency.
CURRENCY_RATE_DATE	DATE			Currency rate date, used for deriving custom notified exchange rate.
CURRENCY_RATE_TYPE	VARCHAR2	(50)		This is to determine the Currency Rate that needs to be used for Determining the Custom Notified Exchange Rate
CURRENCY_RATE	NUMBER			Currency rate, used for capturing custom notified exchange rate
BOL_NUMBER	VARCHAR2	(30)		Bill of Lading Number
LICENSE_NUM	VARCHAR2	(50)		License Number for reference
NATURE_OF_TRANSACTION	VARCHAR2	(50)		Nature of Transaction for Reference
TERMS_OF_PAYMENT	VARCHAR2	(50)		Terms of payment for reference.
GC_CLEARANCE_FLAG	VARCHAR2	(1)		A flag to indicate if it is green channel clearance.
CUSTOMS_AUTHORITY_ID	NUMBER	(15)		Select the respective Customs Authority from the LOV
CUSTOMS_AUTHORITY_SITE_ID	NUMBER	(15)		Select the respective Customs Authority Site from the LOV.
PORT_OF_SHIPMENT	VARCHAR2	(30)		Original Port name
NUMBER_OF_PACKAGE	NUMBER			Number of Packages for Reference
GROSS_WEIGHT	VARCHAR2	(50)		Gross weight for reference
IGM_NUMBER	VARCHAR2	(50)		IGM Number for Reference
IGM_DATE	DATE			IGM Date for Reference
MAWB_NUMBER	VARCHAR2	(50)		MAWB Number for Reference
MAWB_DATE	DATE			MAWB Date for Reference
HAWB_NUMBER	VARCHAR2	(50)		HAWB Number for Reference
HAWB_DATE	DATE			HAWB Date for Reference
DEPB_AMOUNT	NUMBER			The amount that needs to be adjusted against the BOE Invoice as it is already been paid via DEPB adjustment.
STATUS	VARCHAR2	(25)		Will be based on look up. And possible values are Not Yet Assessed, Confirmed, Applied, Available, Canceled
MIGRATION_FLAG	VARCHAR2	(1)		Indicate that the record need to be migrated.
TERMS_OF_INVOICE	VARCHAR2	(150)		TERMS_OF_INVOICE

Query Text

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


SELECT BOE_ID
,      ORGANIZATION_ID
,      BOE_TYPE
,      PORT_CODE
,      BOL_DATE
,      AGENT_ID
,      VESSEL_NAME
,      PORT_NAME
,      COUNTRY_ORIGIN
,      COUNTRY_CONSIGNMNT
,      IMPORT_SR_NUM
,      IMPORT_DATE
,      ROTATION_NO
,      ROTATION_DATE
,      BOE_AMOUNT
,      AMOUNT_APPLIED
,      VENDOR_ID
,      VENDOR_SITE_ID
,      LOCATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AMOUNT_WRITTEN_OFF
,      CONSOLIDATED_FLAG
,      OBJECT_VERSION_NUMBER
,      LEGAL_ENTITY_ID
,      INVOICE_NUM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ORG_ID
,      BOE_DATE
,      BOE_WITHOUT_REFER_FLAG
,      CURRENCY_CODE
,      CURRENCY_RATE_DATE
,      CURRENCY_RATE_TYPE
,      CURRENCY_RATE
,      BOL_NUMBER
,      LICENSE_NUM
,      NATURE_OF_TRANSACTION
,      TERMS_OF_PAYMENT
,      GC_CLEARANCE_FLAG
,      CUSTOMS_AUTHORITY_ID
,      CUSTOMS_AUTHORITY_SITE_ID
,      PORT_OF_SHIPMENT
,      NUMBER_OF_PACKAGE
,      GROSS_WEIGHT
,      IGM_NUMBER
,      IGM_DATE
,      MAWB_NUMBER
,      MAWB_DATE
,      HAWB_NUMBER
,      HAWB_DATE
,      DEPB_AMOUNT
,      STATUS
,      MIGRATION_FLAG
,      TERMS_OF_INVOICE
FROM JA.JAI_CMN_BOE_HDRS_ALL;

Dependencies

[top of page]

JA.JAI_CMN_BOE_HDRS_ALL does not reference any database object

JA.JAI_CMN_BOE_HDRS_ALL is referenced by following:

JA: JAI_CMN_BOE_HDRS_ALL#