Product: | OKC - Contracts Core |
---|---|
Description: | view for service sales credits history |
Implementation/DBA Data: |
![]() |
SELECT KSCHV.ROWID ROW_ID
, KSCHV.ID ID
, KSCHV.DNZ_CHR_ID DNZ_CHR_ID
, KSCHV.MAJOR_VERSION MAJOR_VERSION
, KSCHV.PERCENT PERCENT
, KSCHV.CHR_ID CHR_ID
, KSCHV.CLE_ID CLE_ID
, KSCHV.SALESREP_ID1 SALESREP_ID1
, KSCHV.SALESREP_ID2 SALESREP_ID2
, KSCHV.SALES_CREDIT_TYPE_ID1 SALES_CREDIT_TYPE_ID1
, KSCHV.SALES_CREDIT_TYPE_ID2 SALES_CREDIT_TYPE_ID2
, KSCHV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KSCHV.CREATED_BY CREATED_BY
, KSCHV.CREATION_DATE CREATION_DATE
, KSCHV.LAST_UPDATED_BY LAST_UPDATED_BY
, KSCHV.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM OKC_K_SALES_CREDITS_H KSCHV