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