[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_BOE_HDRS |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_CMN_BOE_HDRS |
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_CMN_BOE_HDRS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BOE_ID |
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 |
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
FROM JA.JAI_CMN_BOE_HDRS;
JA.JAI_CMN_BOE_HDRS does not reference any database object
JA.JAI_CMN_BOE_HDRS is referenced by following:
|
|
|