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 | 2147483647 | √ | null |
|
|
|||||
m_inoutconfirm_id | numeric | 10 | √ | null |
|
|
|||||
documentno | varchar | 30 | √ | null |
|
|
|||||
confirmtype | bpchar | 2 | √ | null |
|
|
|||||
isapproved | bpchar | 1 | √ | null |
|
|
|||||
iscancelled | bpchar | 1 | √ | null |
|
|
|||||
description | varchar | 255 | √ | null |
|
|
|||||
m_inout_id | numeric | 10 | √ | null |
|
|
|||||
shipdescription | varchar | 255 | √ | null |
|
|
|||||
c_bpartner_id | numeric | 10 | √ | null |
|
|
|||||
c_bpartner_location_id | numeric | 10 | √ | null |
|
|
|||||
ad_user_id | numeric | 10 | √ | null |
|
|
|||||
salesrep_id | numeric | 10 | √ | null |
|
|
|||||
c_doctype_id | numeric | 10 | √ | null |
|
|
|||||
documenttype | varchar | 60 | √ | null |
|
|
|||||
c_order_id | numeric | 10 | √ | null |
|
|
|||||
dateordered | timestamp | 29,6 | √ | null |
|
|
|||||
movementdate | timestamp | 29,6 | √ | null |
|
|
|||||
movementtype | bpchar | 2 | √ | null |
|
|
|||||
m_warehouse_id | numeric | 10 | √ | null |
|
|
|||||
poreference | varchar | 20 | √ | null |
|
|
|||||
deliveryrule | bpchar | 1 | √ | null |
|
|
|||||
freightcostrule | bpchar | 1 | √ | null |
|
|
|||||
deliveryviarule | bpchar | 1 | √ | null |
|
|
|||||
m_shipper_id | numeric | 10 | √ | null |
|
|
|||||
priorityrule | bpchar | 1 | √ | null |
|
|
|||||
processed | bpchar | 1 | √ | null |
|
|