# DW_NS_billingSchedule_D

This table contains information about various billing schedules which includes recurrence frequency for billing, initial amount and initial payment terms.

## Details

Module:

## Key Columns

id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
id | NUMBER | 38 | 0 | True |  |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. |  |
name | VARCHAR2 | 128 |  |  |  |  |
inarrears | VARCHAR2 | 16 |  |  |  |  |
isinactive | VARCHAR2 | 16 |  |  |  |  |
ispublic | VARCHAR2 | 16 |  |  |  |  |
applytosubtotal | VARCHAR2 | 16 |  |  |  |  |
billforactuals | VARCHAR2 | 16 |  |  |  |  |
initialterms | NUMBER | 38 | 0 |  |  | DW_NS_term_D | id
numberremaining | NUMBER | 38 | 0 |  |  |  |
repeatevery | NUMBER | 38 | 0 |  |  |  |
scheduletype | VARCHAR2 | 64 |  |  |  | DW_NS_BillingScheduleType_D | id
recurrencepattern | VARCHAR2 | 64 |  |  |  |  |
frequency | VARCHAR2 | 64 |  |  |  | DW_NS_FrequencyType_D | type

Copyright © 2019, 2025, Oracle and/or its affiliates.