DW_NS_ExpenseReportPolicyCategories_D
This table contains expense report policy details and associated expense category.
Details
Module:
Key Columns
expensecategory, expensereportpolicy
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| expensereportpolicy | NUMBER | 38 | 0 | True | |||
| expensecategory | NUMBER | 38 | 0 | True | DW_NS_ExpenseCategory_D | id | |
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| status | VARCHAR2 | 999 | Status | DW_NS_StatusType_D | type | ||
| action | VARCHAR2 | 64 | action | DW_NS_ActionType_D | type | ||
| description | VARCHAR2 | 999 | description | ||||
| enddate | TIMESTAMP | enddate | |||||
| isbillable | VARCHAR2 | 16 | isbillable | ||||
| isinactive | VARCHAR2 | 16 | isinactive | ||||
| limittype | VARCHAR2 | 64 | limittype | DW_NS_LimitType_D | type | ||
| maxamount | NUMBER | maxamount | |||||
| name | VARCHAR2 | 999 | name | ||||
| nowarningreqfieldincluded | VARCHAR2 | 16 | nowarningreqfieldincluded | ||||
| requiresmemo | VARCHAR2 | 16 | requiresmemo | ||||
| requiresreceipt | VARCHAR2 | 16 | requiresreceipt | ||||
| startdate | TIMESTAMP | startdate |