Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| prjid | VARCHAR | 30 |
|
|
||||
| dashboard_name | VARCHAR | 40 |
|
|
||||
| short_text | VARCHAR | 255 | null |
|
|
|||
| sap | VARCHAR | 4 | 0 |
|
|
|||
| cost_type | VARCHAR | 20 | √ | null |
|
|
||
| purchasing_doc | VARCHAR | 40 | √ | null |
|
|
||
| item | INT | 10 | √ | 0 |
|
|
||
| project_def | VARCHAR | 20 | √ | null |
|
|
||
| wbs_element | VARCHAR | 30 | √ | null |
|
|
||
| cost_element | INT | 10 | √ | 0 |
|
|
||
| cost_elem_name | VARCHAR | 30 | √ | null |
|
|
||
| purchase_order_text | VARCHAR | 255 | √ | null |
|
|
||
| company_code | VARCHAR | 10 | √ | null |
|
|
||
| document_date | DATE | 10 | √ | 0000-00-00 |
|
|
||
| posting_date | DATE | 10 | √ | 0000-00-00 |
|
|
||
| quantity | DECIMAL | 10,3 | √ | 0.000 |
|
|
||
| cost | DECIMAL | 10,2 | √ | 0.00 |
|
|
||
| month_posted | INT | 10 | √ | 0 |
|
|
||
| fiscal_year | INT | 10 | √ | 0 |
|
|
||
| vendor_name | VARCHAR | 40 | √ | null |
|
|
||
| po_requestor | VARCHAR | 20 | √ | null |
|
|
||
| im_node | VARCHAR | 20 | √ | null |
|
|
||
| document_number | VARCHAR | 20 | √ | null |
|
|
||
| name | VARCHAR | 255 | √ | null |
|
|
||
| created_on | VARCHAR | 30 | √ | null |
|
|
||
| document_header_text | VARCHAR | 255 | √ | null |
|
|
||
| ref_document_number | VARCHAR | 20 | √ | null |
|
|
||
| document_type | VARCHAR | 60 | √ | null |
|
|
||
| name_of_offsetting_account | VARCHAR | 60 | √ | null |
|
|
||
| dr_cr_indicator | VARCHAR | 10 | √ | null |
|
|
||
| item_text | VARCHAR | 260 | √ | null |
|
|
||
| po_line_value | VARCHAR | 20 | √ | null |
|
|
||
| open_qty | VARCHAR | 20 | √ | null |
|
|
||
| created_by | VARCHAR | 20 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| po_requestor | Performance | Asc | po_requestor |
| short_text | Performance | Asc/Asc | short_text + sap |
Relationships
Close relationships within degrees of separation
