[Home] [Help] [Dependency Information]
Object Name: | ISCBV_EDW_BOOK_SUM1_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ISC.ISCBV_EDW_BOOK_SUM1_FCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the flexview for the Bookings Summary 1 Fact
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | Sequence Id used by the collection program | ||
BOOKINGS_PK | VARCHAR2 | (71) | Unique Identifier | |
BILL_TO_CUST_FK | VARCHAR2 | (85) | Foreign key to the Trading Partner dimension (Bill-to Site) | |
CURRENCY_BASE_FK | VARCHAR2 | (15) | Foreign key to the Currency dimension (Base Currency) | |
DATE_BOOKED_FK | VARCHAR2 | (76) | Foreign key to the Time dimension (Date Booked) | |
INSTANCE_FK | VARCHAR2 | (30) | Foreign key to the Instance dimension | |
OPERATING_UNIT_FK | VARCHAR2 | (4000) | Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked | |
SET_OF_BOOKS_FK | VARCHAR2 | (71) | Foreign key to the Set of Books dimension (GL Set of Book) | |
BOOKED_AMT_B | NUMBER | Total amount of bookings in Base Currency | ||
BOOKED_AMT_G | NUMBER | Total amount of bookings in Warehouse Currency | ||
BOOKED_LIST_AMT_B | NUMBER | Total amount of bookings in list price in Base Currency | ||
BOOKED_LIST_AMT_G | NUMBER | Total amount of bookings in list price in Warehouse Currency | ||
FULFILLED_AMT_B | NUMBER | Total amount fulfilled in Base Currency | ||
FULFILLED_AMT_G | NUMBER | Total amount fulfilled in Warehouse Currency | ||
INVOICED_AMT_B | NUMBER | Total amount invoiced in Base Currency | ||
INVOICED_AMT_G | NUMBER | Total amount invoiced in Warehouse Currency | ||
SHIPPED_AMT_B | NUMBER | Total amount shipped in Base Currency | ||
SHIPPED_AMT_G | NUMBER | Total amount shipped in Warehouse Currency | ||
DATE_BOOKED | DATE | Date Booked | ||
DATE_LATEST_FULFILLED | DATE | Date latest fulfilled | ||
DATE_LATEST_SHIP | DATE | Date latest shipped | ||
DATE_ORDERED | DATE | Date Ordered | ||
HEADER_ID | NUMBER | Yes | Sales Order Header Identifier in the source system | |
INSTANCE | VARCHAR2 | (30) | Instance | |
ORDER_NUMBER | NUMBER | Yes | Sales Order Number in the source system | |
USER_ATTRIBUTE1 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE16 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE17 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE18 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE19 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE20 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE21 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE22 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE23 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE24 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE25 | VARCHAR2 | (0) | User defined attribute | |
USER_FK1 | CHAR | (6) | Foreign key to user defined dimension | |
USER_FK2 | CHAR | (6) | Foreign key to user defined dimension | |
USER_FK3 | CHAR | (6) | Foreign key to user defined dimension | |
USER_FK4 | CHAR | (6) | Foreign key to user defined dimension | |
USER_FK5 | CHAR | (6) | Foreign key to user defined dimension | |
USER_MEASURE1 | NUMBER | User defined measure | ||
USER_MEASURE2 | NUMBER | User defined measure | ||
USER_MEASURE3 | NUMBER | User defined measure | ||
USER_MEASURE4 | NUMBER | User defined measure | ||
USER_MEASURE5 | NUMBER | User defined measure |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_ID
, BOOKINGS_PK
, BILL_TO_CUST_FK
, CURRENCY_BASE_FK
, DATE_BOOKED_FK
, INSTANCE_FK
, OPERATING_UNIT_FK
, SET_OF_BOOKS_FK
, BOOKED_AMT_B
, BOOKED_AMT_G
, BOOKED_LIST_AMT_B
, BOOKED_LIST_AMT_G
, FULFILLED_AMT_B
, FULFILLED_AMT_G
, INVOICED_AMT_B
, INVOICED_AMT_G
, SHIPPED_AMT_B
, SHIPPED_AMT_G
, DATE_BOOKED
, DATE_LATEST_FULFILLED
, DATE_LATEST_SHIP
, DATE_ORDERED
, HEADER_ID
, INSTANCE
, ORDER_NUMBER
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE16
, USER_ATTRIBUTE17
, USER_ATTRIBUTE18
, USER_ATTRIBUTE19
, USER_ATTRIBUTE20
, USER_ATTRIBUTE21
, USER_ATTRIBUTE22
, USER_ATTRIBUTE23
, USER_ATTRIBUTE24
, USER_ATTRIBUTE25
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
FROM APPS.ISCBV_EDW_BOOK_SUM1_FCV;
|
|
|