DW_NS_WBS_F
This table contains information about Work Breakdown Structure created for a project like associated project tasks, estimated and actual costs, revenues, profits and margins.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Transaction Identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| createdby | NUMBER | 38 | 0 | Transaction creator identifier. | DW_NS_entity_D | id | |
| createddate | TIMESTAMP | Transaction creation date. | |||||
| description | VARCHAR2 | 512 | Description. | ||||
| enddate | TIMESTAMP | Transaction end date: the date the project is finished. | |||||
| isinactive | VARCHAR2 | 16 | flag to identify if the record is inactive. | ||||
| lastmodifiedby | NUMBER | 38 | 0 | ID of the last entity who modified the transaction details. | DW_NS_entity_D | id | |
| lastmodifieddate | TIMESTAMP | Last Modification Date. | |||||
| margintarget | NUMBER | Margin Target. | |||||
| project | NUMBER | 38 | 0 | Project identifier. | DW_NS_job_D | id | |
| startdate | TIMESTAMP | Start Date which is used to autofill the related downstream transaction (e.g. If a sales order includes a Start Date and End Date, those dates autofill on the invoice or cash sale when the order is billed ). |