Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | √ | null |
|
|
||
| ad_org_id | numeric | 10 | √ | null |
|
|
||
| isactive | bpchar | 1 | √ | null |
|
|
||
| created | timestamp | 29,6 | √ | null |
|
|
||
| createdby | numeric | 10 | √ | null |
|
|
||
| updated | timestamp | 29,6 | √ | null |
|
|
||
| updatedby | numeric | 10 | √ | null |
|
|
||
| c_cycle_id | numeric | 10 | √ | null |
|
|
||
| cyclename | varchar | 60 | √ | null |
|
|
||
| c_currency_id | numeric | 10 | √ | null |
|
|
||
| c_cyclestep_id | numeric | 10 | √ | null |
|
|
||
| cyclestepname | varchar | 60 | √ | null |
|
|
||
| seqno | numeric | 10 | √ | null |
|
|
||
| relativeweight | numeric | 0 | √ | null |
|
|
||
| c_phase_id | numeric | 10 | √ | null |
|
|
||
| projectphasename | varchar | 60 | √ | null |
|
|
||
| c_projecttype_id | numeric | 10 | √ | null |
|
|
||
| projecttypename | varchar | 60 | √ | null |
|
|
||
| projectvalue | varchar | 40 | √ | null |
|
|
||
| projectname | varchar | 60 | √ | null |
|
|
||
| description | varchar | 255 | √ | null |
|
|
||
| note | varchar | 2000 | √ | null |
|
|
||
| c_bpartner_id | numeric | 10 | √ | null |
|
|
||
| c_bpartner_location_id | numeric | 10 | √ | null |
|
|
||
| ad_user_id | numeric | 10 | √ | null |
|
|
||
| poreference | varchar | 20 | √ | null |
|
|
||
| salesrep_id | numeric | 10 | √ | null |
|
|
||
| m_warehouse_id | numeric | 10 | √ | null |
|
|
||
| projectcategory | bpchar | 1 | √ | null |
|
|
||
| datecontract | timestamp | 29,6 | √ | null |
|
|
||
| datefinish | timestamp | 29,6 | √ | null |
|
|
||
| iscommitment | bpchar | 1 | √ | null |
|
|
||
| iscommitceiling | bpchar | 1 | √ | null |
|
|
||
| committedqty | numeric | 0 | √ | null |
|
|
||
| committedamt | numeric | 0 | √ | null |
|
|
||
| plannedqty | numeric | 0 | √ | null |
|
|
||
| plannedamt | numeric | 0 | √ | null |
|
|
||
| plannedmarginamt | numeric | 0 | √ | null |
|
|
||
| invoicedamt | numeric | 0 | √ | null |
|
|
||
| invoicedqty | numeric | 0 | √ | null |
|
|
||
| projectbalanceamt | numeric | 0 | √ | null |
|
|