CDS Views for Contract Billing (IS-U-BI)

CDS View NameDescriptionSQL View Name
C_ACTUALUTILSBILLINGDOCUMENTQActual Billing Document QueryCEACTLBILLGDOCQ
C_BLKDUTILSCONTRTOBEBLLDBlocked Utilities Contract to be BilledCECONTRBLOCKED
C_MISGUTILSBILLINGORDERWTHDETSMissing Utilities Billing Order with DetailsCEMISGBILLGORD
C_MISSINGUTILSBILLINGORDERQMissing Billing Order QueryCEMISGBILLGORDQ
C_NONBLLBLEUTILSBILLGORDNon-Billable Utilities Billing OrderCECNBLLBLEORDER
C_OPENUTILSBILLGBLKDCONTRBlocked Utilities Contract with Open BillingCECBLKDCONTR
C_OPENUTILSBILLGDOCANDORDOpen Utilities Billing Document and OrderCEOPENBILLGSQ
C_OUTSRTDUTILSBILLGDOCOutsorted Billing DocumentCEOUTSRTDBDOC
C_OUTSRTDUTILSBILLGDOCBSCDATAQOutsorted Billing Document Basic Data QueryCEOUTSRTDBDBSCDQ
C_OUTSRTDUTILSBILLGMALEAPPLYMachine Learning Apply Data for Outsorted BillingCEOUTBILMLAPPLY
C_OUTSRTDUTILSBILLGMALETRNGMachine Learning Training Data for Outsorted BillingCEOUTBILMLTRNG
C_OUTSRTDUTILSBILLINGDOCOutsorted Utilities Billing DocumentCECOUTSRTDBDOC
C_OUTSTDGUTILSBILLGITEMWTHDETSOutstanding Billing Item with DetailsCEOUTSTBILLGITMD
C_REVERSEDUTILSBILLINGDOCQUERYReversed Billing Document QueryCERVSDBILLGDOCQ
C_SPPRSDUTILSBILLGORDWTHDETSSuppressed Utilities Billing Order with DetailsCESPPRDBIORDD
C_SUPPRESSEDUTILSBILLGORDSuppressed Utilities Billing OrderCESUPPBILLGORD
C_UTILITIESBILLINGORDERHISTORYBilling Order HistoryCEBILLINGORDHIST
C_UTILSBILLGDOCMETERINGDATABilling Document Metering DataCEBILLGDOCMRDATA
C_UTILSBILLGDOCOUTSRTGDATAOutsorting Data for Billing DocumentCEOUTSRTGDBDOC
C_UTILSBILLGORDERFORCONTRACTQBilling Order For Contract QueryCEBILLGORDCONTRQ
C_UTILSBILLGORDERRORSWITHDETSUtilities Billing Order Errors With DetailsCEBILLGORDERR
C_UTILSBILLGORDRDYBILLGWTHDETSBilling Order Ready for Billing with DetailsCEBLLGORDRDYDET
C_UTILSBILLINGDOCUMENTHISTORYBilling Document HistoryCEBILLINGDOCHIST
C_UTILSBILLINGORDERUtilities Billing OrderCECBILLGORDER
C_UTILSCONTRACTBLKDFORBILLGQContract Blocked For Billing QueryCECONTRBLOCKEDBQ
C_UTILSCONTRACTTOBEBILLEDQContract To Be Billed QueryCECTOBEBILLEDQ
C_UTILSCONTRTOBEBLLDUtilities Contract to Be BilledCECONTRTBBILLEDQ
DDL_EPRESCLPrice Adjustment Clause for All Price CategoriesV_EPRESCL_CDS
DDL_TE069Rate TypesV_TE069_CDS
DDL_TE221OperandsV_TE221_CDS
E_UTILITIESBILLINGDOCUMENTUtilities Billing Document ExtensionEIEBILLINGDOC
I_ACTUALUTILSBILLINGDOCUMENTActual Billing DocumentIEACTLBILLGDOC
I_AUTOMLYOUTSRTDUTILSBILLGDOCFirst Record for Automatically Outsorted Billing DocumentIEAUTOUTBILDOC
I_LTSTBILLGDOCWTHNETAMTBYCONTRLatest Billing Document with Net Amount for ContractIELTSTSBILLGDOC
I_LTSTUTILSBILLGDATEFORCONTRLatest End Date of Utilities Billing Period for ContractIELBILLGDTECONTR
I_MANUALLYOUTSRTDUTILSBILLGDOCFirst Record for Manually Outsorted Billing DocumentIEMANOUTBILDOC
I_MANUALUTILSBILLGDOCCRTNRSNManual Billing Document Creation ReasonIEBILLGDCRTNRSN
I_MANUALUTILSBILLGDOCCRTNRSNTManual Billing Document Creation Reason TextIEBILLGDCRTNRSNT
I_MISSINGUTILSBILLINGORDERMissing Billing OrderIEMISGBILLGORDER
I_MTRRDNGDOCCONVERSIONCOUNTERNumber of Meter Reading Document Conversions in Billg DocIEMRDOCCNVRSNC
I_MTRRSNCORRESPGTOBILLGRSNMeter Reading Reason Corresponding To Billing ReasonIEMRSNTOBILLGRSN
I_NONBLLBLEUTILSBILLGORDNon-Billable Utilities Billing OrderIENBLLBLEORDER
I_NONBLLBLEUTILSBILLGORDERCNTRNon-Billable Billing Order CounterIENONBLLBLEORDCN
I_OPENUTILSBILLGDOCANDORDOpen Utilities Billing Document and OrderIEOPENBILLGS
I_OPENUTILSBILLGDOCANDORDDATAOpen Utilities Billing Document and Order DataIEOPENBILLGSU
I_OPNUTILSBILLGDOCANDORDTYPEOpen Utilities Billing Document and Order TypeIEOPNDOCORDTYPE
I_OPNUTILSBILLGDOCANDORDTYPETOpen Utilities Billing Document and Order Type TextIEOPNDOCORDTYPET
I_OUTSRTDUTILSBILLGDOCBSCDATAOutsorted Billing Document Basic DataIEOUTSRTDBDBSCD
I_OUTSRTDUTILSBILLGDOCMALERSLTMachine Learning Result for Outsorted Billing DocumentIEOUTBILLMLRSLT
I_OUTSRTDUTILSBILLGDOCTOTAMTOutsorted Billing Document: Total Net AmountIEOBDOCTOTAMT
I_OUTSRTDUTILSBILLGMALEAPPLYMachine Learning Apply Data for Outsorted BillingIEOUTBILMLAPPLY
I_OUTSRTDUTILSBILLGMALETRNGMachine Learning Training Data for Outsorted BillingIEOUTBILMLTRNG
I_OUTSRTGCHKGRPBILLG1STCHKFirst Check for Outsorting Check Group and Billing ReasonIEOCHKGRPB1CHK
I_REVERSEDUTILSBILLINGDOCUMENTReversed Billing DocumentIERVSDBILLGDOC
I_SPPRSDUTILSBILLGORDWTHDETSSuppressed Utilities Billing Order with DetailsIESPPRDBIORDD
I_SUPPRESSEDUTILSBILLGORDSuppressed Utilities Billing OrderIESUPPBILLGORD
I_UTILITIESBILLINGCHECKBilling CheckIEBILLGCHECK
I_UTILITIESBILLINGCHECKTEXTBilling Check TextIEBILLGCHECKT
I_UTILITIESBILLINGCHECKVHBilling Check Value HelpIEBILLGCHECKVH
I_UTILITIESBILLINGDOCUMENTBilling DocumentIEUTILSBILLGDOC
I_UTILITIESBILLINGDOCUMENTTPBilling Document for Transactional ProcessingIEBILLGDOCTP
I_UTILITIESBILLINGORDERBilling OrderIEBILLGORDER
I_UTILITIESBILLINGREASONBilling ReasonIEBILLINGREASON
I_UTILITIESBILLINGREASONTEXTBilling Reason TextIEBILLINGREASONT
I_UTILITIESCONTRACTContractIEUTILSCONTRACT
I_UTILITIESCONTRACTVHContract Value HelpIEUTILSCONTRVH
I_UTILITIESCONVERSIONREASONConversion ReasonIECNVRSNREASON
I_UTILITIESCONVERSIONREASONTConversion Reason TextIECNVRSNREASONT
I_UTILITIESPORTIONPortionIEPORTION
I_UTILITIESPORTIONSCHEDULERECDPortion Schedule RecordIEPORTNSCHEDRECD
I_UTILITIESRATECATEGORYRate CategoryIERATECATEGORY
I_UTILITIESRATECATEGORYTEXTRate Category TextIERATECATEGORYT
I_UTILITIESRATECATEGORYVHRate Category Value HelpIERATECATEGORYVH
I_UTILSACCOUNTCLASSAccount ClassIEACCTCLASSES
I_UTILSACCOUNTCLASSTEXTAccount Class TextIEACCTCLASSEST
I_UTILSACCOUNTCLASSVHAccount Class Value HelpIEACCTCLASSESVH
I_UTILSACCOUNTDETNCODEAccount Determination CodeIEACCTDETNCODE
I_UTILSACCOUNTDETNCODETEXTAccount Determination Code TextIEACCTDETNCODET
I_UTILSAIRPRESSUREAREAAir Pressure AreaIEAIRPRSAREA
I_UTILSAIRPRESSUREAREATEXTAir Pressure Area TextIEAIRPRSAREAT
I_UTILSBILLGBLOCKREASONBilling Block ReasonIEBILLGBLOCKRSN
I_UTILSBILLGBLOCKREASONTBilling Block Reason TextIEBILLGBLOCKRSNT
I_UTILSBILLGBLOCKREASONVHBilling Block Reason Value HelpIEBLLGBLOCKRSNVH
I_UTILSBILLGDOCADDLLINEITEMBilling Document Additional Line ItemIEBILLGITMRARELY
I_UTILSBILLGDOCCNVRSNRSNCNTRNumber of Conversion Reasons for Billing DocumentIEBILDOCCNRNCNT
I_UTILSBILLGDOCDATEINFORMATIONDate Information for Utilities Billing DocumentIEBILLGDOCDINFO
I_UTILSBILLGDOCDVCELINEITEMBilling Document Line Item for Device DataIEBILLGITMDVCE
I_UTILSBILLGDOCFORCONTRACTUtilities Billing Document for ContractIEBILLGDOCCONTR
I_UTILSBILLGDOCINTANDEXTPODInternal and External Point of Delivery for Billing DocumentIEBDOCINTEXTPOD
I_UTILSBILLGDOCINVCGHISTORYInvoicing History of Billing DocumentIEBILLGDOCINVCGH
I_UTILSBILLGDOCLINEITEMCNVRSNBilling Document Line Item ConversionIEBILLGITMCNVRSN
I_UTILSBILLGDOCLINEITMAMTPRCBilling Document Line Item for Amount and Price DataIEBILLGITMAMTPRC
I_UTILSBILLGDOCMETERINGDATABilling Document Metering DataIEBILLGDOCMRDATA
I_UTILSBILLGDOCMTRDOCQUANTITYMeter Reading Document Quantity in Billing DocumentIEBDOCMRQTY
I_UTILSBILLGDOCMTRGDATABASEBilling Document Metering Data BaseIEBILLGDOCMDATAB
I_UTILSBILLGDOCMTRRDNGCNVRSNMeter Reading Document Conversions in Billing DocIEBDOCCNVRSNMR
I_UTILSBILLGDOCMTRRDNGREASONBilling Document Meter Reading ReasonIEBILLGDOCMRRSN
I_UTILSBILLGDOCOUTSRTGCHKGRPOutsorting Data with Current Outsorting Check GroupIEOUTSRTGDCHKGRP
I_UTILSBILLGDOCOUTSRTGDATAOutsorting Data for Billing DocumentIEOUTSRTGDBDOC
I_UTILSBILLGDOCOUTSRTGDATACNTRNumber of Outsorting Data Records and First EntryIEOUTSRTGDATAC
I_UTILSBILLGDOCOUTSRTGDATARSNOutsorting Data for First Outsorting ReasonIEOUTSRTGDATARSN
I_UTILSBILLGDOCPREVYRINVCGDOCPrevious Year Invoicing Document for Billing DocumentIEBILLGDOCPYINVD
I_UTILSBILLGDOCSIMULATIONRSNBilling Document Simulation ReasonIEBILLGSIMURSN
I_UTILSBILLGDOCSIMULATIONRSNTBilling Document Simulation Reason TextIEBILLGSIMURSNT
I_UTILSBILLGDOCTOTALNETAMTBilling Document Total Net AmountIEBILLGDOCNETAMT
I_UTILSBILLGORDCHKBFRBILLINGBilling Order Check Before BillingIEBLLGORDCHKBLLG
I_UTILSBILLGORDCHKBFRBILLINGTBilling Order Check Before Billing TextIEBLGORDCHKBLLGT
I_UTILSBILLGORDCHKBFRBILLINGVHBilling Order Check before Billing Value HelpIEUBORDBLLGCHKVH
I_UTILSBILLGORDDETAILEDSTATUSDetailed Status of Billing OrderIEBLLGORDDETST
I_UTILSBILLGORDDETAILEDSTATUSTDetailed Status of Billing Order TextIEBLLGORDDETSTT
I_UTILSBILLGORDERFORCONTRACTBilling Order For ContractIEBILLGORDCONTR
I_UTILSBILLGOUTSORTINGGROUPOutsorting Reason for BillingIEOUTSRTGGRPB
I_UTILSBILLGOUTSORTINGGROUPTBilling Outsorting Group TextIEOUTSRTGGRPBT
I_UTILSBILLGOUTSORTINGGROUPVHOutsorting Reason for Billing Value HelpIEOUTSRTGGRPBVH
I_UTILSBILLGUNBLOCKREASONBilling Unblock ReasonIEBILLGUNBLKRSN
I_UTILSBILLGUNBLOCKREASONTBilling Unblock Reason TextIEBILLGUNBLKRSNT
I_UTILSBILLGUNBLOCKREASONVHReason for Removing Billing Block Value HelpIEBLLGUNBLKRSNVH
I_UTILSBILLINGDOCREVERSALRSNBilling Document Reversal ReasonIEBILLGDOCRVSLR
I_UTILSBILLINGDOCREVERSALRSNTBilling Document Reversal Reason TextIEBILLGDOCRVSLRT
I_UTILSBILLINGDOCUMENTLINEITEMBilling Document Line ItemIEBILLGITM
I_UTILSBILLINGORDERUtilities Billing OrderIEINBLLGORDER
I_UTILSBILLINGORDERINDICATORUtilities Billing Order IndicatorIEBILLGORDIND
I_UTILSBILLINGORDERINDICATORTUtilities Billing Order Indicator TextIEBILLGORDINDTX
I_UTILSBILLINGORDERSTATUSBilling Order StatusIEBILLGORDSTS
I_UTILSBILLINGORDERSTATUSTEXTBilling Order Status TextIEBILLGORDSTST
I_UTILSCALORIFICVALDSTRCTCalorific Value DistrictIECLVALUEDSTR
I_UTILSCALORIFICVALDSTRCTTEXTCalorific Value District TextIECLVALUEDSTRT
I_UTILSCONTRACTBLKDFORBILLGContract Blocked For BillingIECONTRBLKDBILLG
I_UTILSCONTRACTTOBEBILLEDContract To Be BilledIECONTRTOBEBLLD
I_UTILSCONTRSPCFCBDGTBILLGCYCContract-Specific Budget Billing CycleIECBDGTBILLGCYC
I_UTILSCONTRSPCFCBDGTBILLGCYCTContract-Specific Budget Billing Cycle TextIECBDGTBILLGCYCT
I_UTILSCONTRTOBEBLLDUtilities Contract to Be BilledIECONTRTBBILLED
I_UTILSCONTRTOBEBLLDDATAUtilities Contract to Be Billed DataIECONTRTBBILLEDD
I_UTILSCONTRTOBEBLLDDETSTYPEUtilities Contract to Be Billed Details TypeIECONTRBLLDDDTYP
I_UTILSCONTRTOBEBLLDDETSTYPETUtilities Contract to Be Billed Details Type TextIECONTRBLDDDTYPT
I_UTILSCONTRTOBEBLLDTYPEUtilities Contract to Be Billed TypeIECONTRBLLDDTYPE
I_UTILSCONTRTOBEBLLDTYPETUtilities Contract to Be Billed Type TextIECONTRBLLDDTYPT
I_UTILSGASPRESSUREAREAGas Pressure AreaIEGASPRSSRAREA
I_UTILSGASPRESSUREAREATEXTGas Pressure Area TextIEGASPRSSRAREAT
I_UTILSOUTSRTDBILLGMALRNPARAMMachine Learning Parameters for Outsorted BillingIEOUTBILMLPARAM
I_UTILSOUTSRTDBILLGPERDCNSMPNPeriod Consumption for Outsorted BillingIEOUTBILPERCONS
I_UTILSOUTSRTGCHECKGRPBILLGCHKChecks per Outsorting Check Group for BillingIEOUTSRTGCHKGBC
I_UTILSOUTSRTGCHKGRPBILLGOutsorting Check Group for BillingIEOUTSRTGCHKGB
I_UTILSOUTSRTGCHKGRPBILLGTEXTBilling Outsorting Check Group TextIEOUTSRTGCHKGBT
I_UTILSPORTNDFLTBDGTBILLGCYCDefault Budget Billing Cycle of PortionIEBDGTBILLGCYC
I_UTILSPORTNDFLTBDGTBILLGCYCTDefault Budget Billing Cycle of Portion TextIEBDGTBILLGCYCT
I_UTILSPREMISEADDRESSPremise with Address InformationIEPREMISEADDRESS
I_UTILSQUANTITYDETNPROCEDUREQuantity Determination ProcedureIEQTYDETNPROCED
I_UTILSQUANTITYDETNPROCEDURETQuantity Determination Procedure TextIEQTYDETNPROCEDT
I_UTILSTEMPERATUREAREATemperature AreaIETEMPERATUREA
I_UTILSTEMPERATUREAREATEXTTemperature Area TextIETEMPERATUREAT
P_NONBLLBLEUTILSBILLGORDNon-Billable Billing OrderPENONBLLBLEORDER
P_OUTSRTDUTILSBILLINGDOCUMENTOutsorted Billing DocumentPEOBILLGDOC
P_SUPPRESSEDUTILSBILLINGORDERSuppressed Billing OrderPESPPRSDBIORD
P_UTI_BI_OUTSORTED_V01Release Confidence for Outsorted Billing DocumentsPEUTIBIOUTSRTD01

Other CDS Views