DW_NS_accountingBook_D
This table contains information of accounting books used in maintaining accounting records based on a single set of real-time financial transactions. This enables businesses to support different managerial and regulatory compliance needs.
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 | 64 | This column is for Oracle Internal use only. | ||||
| isconsolidated | VARCHAR2 | 16 | |||||
| name | VARCHAR2 | 256 | |||||
| lastmodifieddate | TIMESTAMP | ||||||
| isadjustmentonly | VARCHAR2 | 32 | |||||
| basebook | NUMBER | 38 | 0 | DW_NS_accountingBook_D | id | ||
| effectiveperiod | NUMBER | 38 | 0 | DW_NS_accountingPeriod_D | id | ||
| isprimary | VARCHAR2 | 16 |