# DW_NS_billingAccount_D

This table contains information about the billing accounts used for billing the customers for various goods and services.

## 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. |  |
memo | VARCHAR2 | 999 |  |  |  |  |
createddate | TIMESTAMP |  |  |  |  |  |
requestoffcycleinvoice | VARCHAR2 | 16 |  |  |  |  |
lastbillcycledate | TIMESTAMP |  |  |  |  |  |
location | NUMBER | 38 | 0 |  |  | DW_NS_location_D | id
customer | NUMBER | 38 | 0 |  |  | DW_NS_customer_D | id
lastbilldate | TIMESTAMP |  |  |  | Internal Column -Do not use. Last Bill Date |  |
inactive | VARCHAR2 | 16 |  |  |  |  |
billaddresslist | NUMBER | 38 | 0 |  |  | DW_NS_entityAddressbook_D | internalid
name | VARCHAR2 | 128 |  |  |  |  |
currency | NUMBER | 38 | 0 |  |  | DW_NS_currency_D | id
startdate | TIMESTAMP |  |  |  |  |  |
department | NUMBER | 38 | 0 |  |  | DW_NS_department_D | id
createdby | VARCHAR2 | 256 |  |  |  |  |
billingschedule | NUMBER | 38 | 0 |  |  | DW_NS_billingSchedule_D | id
subsidiary | NUMBER | 38 | 0 |  |  | DW_NS_subsidiary_D | id
nextbillcycledate | VARCHAR2 | 32 |  |  |  |  |
customerdefault | VARCHAR2 | 16 |  |  |  |  |
class | NUMBER | 38 | 0 |  |  | DW_NS_classification_D | id
idnumber | VARCHAR2 | 128 |  |  |  |  |
shipaddresslist | NUMBER | 38 | 0 |  |  | DW_NS_entityAddressbook_D | internalid
lastmodifieddate | TIMESTAMP |  |  |  | Last Modified Date |  |

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