OKS Service Contracts Billing Schedule

Description

Categories
Enginatics
Repository
GitHub
Service Contracts billing schedule with invoicing and accounting rules, and detailed to be billed period dates and amounts from the stream level elements table oks_level_elements.

Column date_competed is used to identify open or already billed records and date_to_interface is used by the service contracts billing program to identify the records to be billed at any given date.
For advance billing, date_to_interface is set to the beginning of the billing period and for arrears, it is set to the end. When creating new billing schedule record for past periods (that should have been billed already), date_to_interface is set to the current date.

An overview of oracle service contracts and other line types can be found here: https://www.enginatics.com/reports/okc-contract-lines-summary/

SQL 78 lines

Parameters 9

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
Contract NumberLOV
okhab.contract_number=:contract_nunber
ModifierLOV
okhab.contract_number_modifier=:modifier
Contract StatusLOV
osv0.meaning=:contract_status
Exclude Contract StatusLOV
osv0.meaning<>:exclude_contract_status
Interface Date FromDate
ole.date_to_interface>=:interface_date_from
Interface Date ToDate
ole.date_to_interface<:interface_date_to+1
Show unbilled onlyLOV
ole.date_completed is null
LevelLOV
oklb1.id=oslb.cle_id