Product: | OKS - Service Contracts |
---|---|
Description: | This View Is used to Store Billing Schedule Infomation for Lines |
Implementation/DBA Data: |
![]() |
SELECT LET.ROWID ROW_ID
, LET.ID ID
, LET.CLE_ID CLE_ID
, LET.DNZ_CHR_ID DNZ_CHR_ID
, LET.PARENT_CLE_ID PARENT_CLE_ID
, LET.SEQUENCE_NUMBER SEQUENCE_NUMBER
, LET.DATE_START DATE_START
, LET.DATE_END DATE_END
, LET.AMOUNT AMOUNT
, LET.DATE_REVENUE_RULE_START DATE_REVENUE_RULE_START
, LET.DATE_RECEIVABLE_GL DATE_RECEIVABLE_GL
, LET.DATE_TRANSACTION DATE_TRANSACTION
, LET.DATE_DUE DATE_DUE
, LET.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LET.DATE_PRINT DATE_PRINT
, LET.DATE_TO_INTERFACE DATE_TO_INTERFACE
, LET.DATE_COMPLETED DATE_COMPLETED
, LET.RUL_ID RUL_ID
, LET.CREATED_BY CREATED_BY
, LET.CREATION_DATE CREATION_DATE
, LET.LAST_UPDATED_BY LAST_UPDATED_BY
, LET.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM OKS_LEVEL_ELEMENTS LET