[Home] [Help] [Dependency Information]
Object Name: | PN_VOL_HIST_BATCH_ITF |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_VOL_HIST_BATCH_ITF |
Subobject Name: | |
Status: | VALID |
This is interface table whcih contains information of Variable Rent Volume History Batch whcih is being imported into Variable Rent Volume History table.
Scope: public
Product: PN
Lifecycle: active
Display Name: PN Volume History Batch Interface
Category: BUSINESS_ENTITY PN_VOLUME_HISTORY
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_VOL_HIST_BATCH_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | Identifier of volume history batch |
BATCH_NAME | VARCHAR2 | (30) | Yes | Name of volume history batch |
MIN_REP_DATE | DATE | Yes | Earliest reporting date of volume history batch | |
MAX_REP_DATE | DATE | Yes | Latest reporting date of volume history batch | |
VOLUME_TYPE | VARCHAR2 | (30) | Voulme type of volume history batch. | |
STATUS | VARCHAR2 | (1) | Status of volume history batch to indicate whether batch is pending for import,errored out or imported. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column: The date on which a user updated the row | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column: The user who updated the row. This column is a foreign key to FND_USER.USER_ID. |
CREATION_DATE | DATE | Yes | Standard Who column: The date on which row was created | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column: The user who created row. This column is a foreign key to FND_USER.USER_ID. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column: The operating system login of the user who last updated the row. This column is a foreign key to FND_LOGINS.LOGIN_ID. | |
SALES_STATUS_CODE | VARCHAR2 | (30) | Identifies if a volume history record is in DRAFT, ON HOLD or APPROVED status. | |
REPORT_TYPE_CODE | VARCHAR2 | (30) | Report type used while reporting sales |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_NAME
, MIN_REP_DATE
, MAX_REP_DATE
, VOLUME_TYPE
, STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SALES_STATUS_CODE
, REPORT_TYPE_CODE
FROM PN.PN_VOL_HIST_BATCH_ITF;
PN.PN_VOL_HIST_BATCH_ITF does not reference any database object
PN.PN_VOL_HIST_BATCH_ITF is referenced by following:
|
|
|