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
| 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 |