| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| 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 |
|
|
| 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 |
|
|
Analyzed at 2021-12-25 14:43 +0100
|