[Home] [Help]
View: OE_BIS_CUST_SAT_V
View Text
SELECT SET_OF_BOOKS_ID
, SET_OF_BOOKS_NAME
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_ID
, OPERATING_UNIT_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, INVENTORY_ITEM_ID
, CATEGORY_ID
, CATEGORY_DESC
, ITEM_DESCRIPTION
, INVENTORY_ITEM_NAME
, CUSTOMER_ID
, SALES_CHANNEL_CODE
, CUSTOMER_NAME
, AREA
, COUNTRY
, TRANSACTION_DATE
, DEL_SALES
, RET_SALES
, NET_SALES
, PERIOD_SET_NAME
, YEAR_PERIOD
, QUARTER_PERIOD
, MONTH_PERIOD
, HEADER_ID
, LINE_ID
, LOCATION_ID
, LOCATION_CODE
, REGION
FROM OE_BIS_CUST_SAT_T2
Columns
Name |
SET_OF_BOOKS_ID |
SET_OF_BOOKS_NAME |
LEGAL_ENTITY_ID |
LEGAL_ENTITY_NAME |
OPERATING_UNIT_ID |
OPERATING_UNIT_NAME |
ORGANIZATION_ID |
ORGANIZATION_NAME |
INVENTORY_ITEM_ID |
CATEGORY_ID |
CATEGORY_DESC |
ITEM_DESCRIPTION |
INVENTORY_ITEM_NAME |
CUSTOMER_ID |
SALES_CHANNEL_CODE |
CUSTOMER_NAME |
AREA |
COUNTRY |
TRANSACTION_DATE |
DEL_SALES |
RET_SALES |
NET_SALES |
PERIOD_SET_NAME |
YEAR_PERIOD |
QUARTER_PERIOD |
MONTH_PERIOD |
HEADER_ID |
LINE_ID |
LOCATION_ID |
LOCATION_CODE |
REGION |