Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ad_client_id | numeric | 10 | √ | null |
|
|
||
| ad_org_id | numeric | 10 | √ | null |
|
|
||
| mp_ot_id | numeric | 10 | √ | null |
|
|
||
| c_doctype_id | numeric | 10 | √ | null |
|
|
||
| datetrx | timestamp | 29,6 | √ | null |
|
|
||
| ad_user_id | numeric | 10 | √ | null |
|
|
||
| description | varchar | 255 | √ | null |
|
|
||
| docstatus | varchar | 2 | √ | null |
|
|
||
| processed | bpchar | 1 | √ | null |
|
|
||
| a_asset_id | numeric | 10 | √ | null |
|
|
||
| a_asset_group_id | numeric | 10 | √ | null |
|
|
||
| mp_ot_request_id | numeric | 10 | √ | null |
|
|
||
| ot_request_type | varchar | 2 | √ | null |
|
|
||
| seqno | numeric | 10 | √ | null |
|
|
||
| ottdescription | varchar | 255 | √ | null |
|
|
||
| c_uom_id | numeric | 10 | √ | null |
|
|
||
| duration | numeric | 0 | √ | null |
|
|
||
| status | varchar | 2 | √ | null |
|
|
||
| resourcetype | varchar | 2 | √ | null |
|
|
||
| m_product_id | numeric | 10 | √ | null |
|
|
||
| s_resource_id | numeric | 10 | √ | null |
|
|
||
| resourceqty | numeric | 0 | √ | null |
|
|
||
| costamt | numeric | 0 | √ | null |
|
|
||
| documentno | varchar | 30 | √ | null |
|
|