# 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. This is source record id column. |  |
name | VARCHAR2 | 128 |  |  | Name |  |
inarrears | VARCHAR2 | 16 |  |  | In Arrears |  |
isinactive | VARCHAR2 | 16 |  |  | Inactive |  |
ispublic | VARCHAR2 | 16 |  |  | Public |  |
applytosubtotal | VARCHAR2 | 16 |  |  | Apply To Subtotal |  |
billforactuals | VARCHAR2 | 16 |  |  | Invoice Actual Time Only |  |
initialterms | NUMBER | 38 | 0 |  | Initial Payment Terms | DW_NS_term_D | id
numberremaining | NUMBER | 38 | 0 |  | Number Remaining |  |
repeatevery | NUMBER | 38 | 0 |  | Repeat Every |  |
scheduletype | VARCHAR2 | 64 |  |  | Type | DW_NS_BillingScheduleType_D | id
recurrencepattern | VARCHAR2 | 64 |  |  | Type |  |
frequency | VARCHAR2 | 64 |  |  | frequency | DW_NS_FrequencyType_D | type

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