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 |
|
|
|||||
ad_language | varchar | 6 | √ | null |
|
|
|||||
name | varchar | 60 | √ | null |
|
|
|||||
c_bpartner_id | numeric | 10 | √ | null |
|
|
|||||
cost | numeric | 0 | √ | null |
|
|
|||||
datefinish | timestamp | 29,6 | √ | null |
|
|
|||||
datefinishschedule | timestamp | 29,6 | √ | null |
|
|
|||||
datestart | timestamp | 29,6 | √ | null |
|
|
|||||
datestartschedule | timestamp | 29,6 | √ | null |
|
|
|||||
description | varchar | 255 | √ | null |
|
|
|||||
docaction | bpchar | 2 | √ | null |
|
|
|||||
docstatus | bpchar | 2 | √ | null |
|
|
|||||
duration | numeric | 10 | √ | null |
|
|
|||||
durationreal | numeric | 10 | √ | null |
|
|
|||||
durationrequiered | numeric | 10 | √ | null |
|
|
|||||
help | varchar | 2000 | √ | null |
|
|
|||||
ismilestone | bpchar | 1 | √ | null |
|
|
|||||
issubcontracting | bpchar | 1 | √ | null |
|
|
|||||
movingtime | numeric | 10 | √ | null |
|
|
|||||
overlapunits | numeric | 10 | √ | null |
|
|
|||||
pp_order_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_workflow_id | numeric | 10 | √ | null |
|
|
|||||
pp_order_node_id | numeric | 10 | √ | null |
|
|
|||||
priority | numeric | 10 | √ | null |
|
|
|||||
qtydelivered | numeric | 0 | √ | null |
|
|
|||||
qtyrequiered | numeric | 0 | √ | null |
|
|
|||||
qtyscrap | numeric | 0 | √ | null |
|
|
|||||
queuingtime | numeric | 10 | √ | null |
|
|
|||||
s_resource_id | numeric | 10 | √ | null |
|
|
|||||
setuptime | numeric | 10 | √ | null |
|
|
|||||
setuptimereal | numeric | 10 | √ | null |
|
|
|||||
unitscycles | numeric | 10 | √ | null |
|
|
|||||
validfrom | timestamp | 29,6 | √ | null |
|
|
|||||
validto | timestamp | 29,6 | √ | null |
|
|
|||||
value | varchar | 40 | √ | null |
|
|
|||||
waitingtime | numeric | 10 | √ | null |
|
|
|||||
workingtime | numeric | 10 | √ | null |
|
|
|||||
yield | numeric | 10 | √ | null |
|
|