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_project_id | numeric | 10 | √ | null |
|
|
|||||
m_product_id | numeric | 10 | √ | null |
|
|
|||||
c_projectline_id | numeric | 10 | √ | null |
|
|
|||||
line | numeric | 10 | √ | null |
|
|
|||||
description | varchar | 255 | √ | null |
|
|
|||||
plannedqty | numeric | 0 | √ | null |
|
|
|||||
plannedprice | numeric | 0 | √ | null |
|
|
|||||
plannedamt | numeric | 0 | √ | null |
|
|
|||||
plannedmarginamt | numeric | 0 | √ | null |
|
|
|||||
committedqty | numeric | 0 | √ | null |
|
|
|||||
c_projectissue_id | numeric | 10 | √ | null |
|
|
|||||
m_locator_id | numeric | 10 | √ | null |
|
|
|||||
movementqty | numeric | 0 | √ | null |
|
|
|||||
movementdate | timestamp | 29,6 | √ | null |
|
|
|||||
issueline | numeric | 10 | √ | null |
|
|
|||||
issuedescription | varchar | 255 | √ | null |
|
|
|||||
m_inoutline_id | numeric | 10 | √ | null |
|
|
|||||
s_timeexpenseline_id | numeric | 10 | √ | null |
|
|
|||||
c_acctschema_id | numeric | 10 | √ | null |
|
|
|||||
account_id | numeric | 10 | √ | null |
|
|
|||||
amtsourcedr | numeric | 0 | √ | null |
|
|
|||||
amtsourcecr | numeric | 0 | √ | null |
|
|
|||||
amtacctdr | numeric | 0 | √ | null |
|
|
|||||
amtacctcr | numeric | 0 | √ | null |
|
|
|||||
linemargin | numeric | 0 | √ | null |
|
|