DW_NS_job_D
This table contains information about projects to track all customer billable activities.
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. | ||||
| actualtime | NUMBER | Actual Work | |||||
| allowallresourcesfortasks | VARCHAR2 | 16 | Display All Resources for Project Task Assignment | ||||
| allowexpenses | VARCHAR2 | 16 | Allow Expenses | ||||
| allowtime | VARCHAR2 | 16 | Allow Time Entry | ||||
| altname | VARCHAR2 | 999 | Vendor | ||||
| billingratecard | NUMBER | 38 | 0 | Billing Rate Card | DW_NS_BillingRateCard_D | id | |
| billingschedule | NUMBER | 38 | 0 | Billing Schedule | DW_NS_billingSchedule_D | id | |
| calculatedenddate | TIMESTAMP | Calculated End Date | |||||
| calculatedstartdate | TIMESTAMP | Calculated Start Date | |||||
| calculatedwork | NUMBER | Calculated Work | |||||
| companyname | VARCHAR2 | 256 | Company Name | ||||
| currency | NUMBER | 38 | 0 | Currency | DW_NS_currency_D | id | |
| currencyprecision | NUMBER | 38 | 0 | Currency Precision | |||
| customer | NUMBER | 38 | 0 | Customer | DW_NS_Customer_D | id | |
| datecreated | TIMESTAMP | Date Created | |||||
| enddate | TIMESTAMP | Actual End Date | |||||
| entityid | VARCHAR2 | 256 | Entity ID | ||||
| entitystatus | NUMBER | 38 | 0 | Status (Customer) | DW_NS_EntityStatus_D | key | |
| entitytitle | VARCHAR2 | 512 | Vendor ID | ||||
| estimatedcost | NUMBER | Estimated Cost | |||||
| estimatedgrossprofit | NUMBER | Estimated Gross Profit | |||||
| estimatedgrossprofitpercent | NUMBER | Estimated Gross Profit Percent | |||||
| estimatedlaborcost | NUMBER | Estimated Labor Cost | |||||
| estimatedlaborrevenue | NUMBER | Estimated Labor Revenue | |||||
| estimatedrevenue | NUMBER | Estimated Revenue | |||||
| estimatedtime | NUMBER | Initial Time Budget | |||||
| forecastchargerunondemand | VARCHAR2 | 16 | Forecast Charge Run on Demand | ||||
| fxrate | NUMBER | Exchange Rate | |||||
| includecrmtasksintotals | VARCHAR2 | 16 | Include CRM Task In Project Totals | ||||
| isexempttime | VARCHAR2 | 16 | Classify Time as Exempt | ||||
| isinactive | VARCHAR2 | 16 | Inactive | ||||
| isproductivetime | VARCHAR2 | 16 | Classify Time as Productive | ||||
| isutilizedtime | VARCHAR2 | 16 | Classify Time as Utilized | ||||
| jobbillingtype | VARCHAR2 | 32 | Billing Type | DW_NS_BillingScheduleType_D | id | ||
| jobitem | NUMBER | 38 | 0 | Billing Item | DW_NS_item_D | id | |
| jobprice | NUMBER | Project Price | |||||
| lastbaselinedate | TIMESTAMP | Last Baseline Date | |||||
| lastmodifieddate | TIMESTAMP | Last Modified Date | |||||
| limittimetoassignees | VARCHAR2 | 16 | Limit Time and Expenses To Resources | ||||
| materializetime | VARCHAR2 | 16 | Create Planned Time Entries | ||||
| parent | NUMBER | 38 | 0 | Parent Workplace | DW_NS_entity_D | id | |
| percentcomplete | NUMBER | Percent Complete | |||||
| percenttimecomplete | NUMBER | Percent Complete (Time) | |||||
| plannedwork | NUMBER | Planned Work | |||||
| projectedenddate | TIMESTAMP | Estimated End Date | |||||
| projectmanager | NUMBER | 38 | 0 | Job Manager | DW_NS_employee_D | id | |
| revrecforecastrule | NUMBER | 38 | 0 | Rev Rec Forecast Rule | DW_NS_RevenueRecognitionRule_D | id | |
| scheduledenddate | TIMESTAMP | End Date | |||||
| schedulingmethod | VARCHAR2 | 32 | Scheduling Method | DW_NS_schedulingMethod_D | key | ||
| sourceserviceitemfromratecard | VARCHAR2 | 16 | Source Service Item to Task Assignments from Rate Card | ||||
| startdate | TIMESTAMP | Start Date | |||||
| timeapproval | NUMBER | 38 | 0 | Time Approval | DW_NS_ProjectTimeApprovalType_D | id | |
| timeremaining | NUMBER | Remaining Work | |||||
| usepercentcompleteoverride | VARCHAR2 | 16 | Use Percent Complete Override for Forecasting | ||||
| projectexpensetype | NUMBER | 38 | 0 | Project Expense Type | DW_NS_projectExpenseType_D | id | |
| contact | NUMBER | 38 | 0 | Primary Contact | DW_NS_Contact_D | id |