Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
c_orderline_id |
numeric |
10 |
|
|
|
|
|
ad_client_id |
numeric |
10 |
|
|
|
|
|
ad_org_id |
numeric |
10 |
|
|
|
|
|
isactive |
bpchar |
1 |
|
|
'Y'::bpchar |
|
|
created |
timestamp |
29,6 |
|
|
now() |
|
|
createdby |
numeric |
10 |
|
|
|
|
|
updated |
timestamp |
29,6 |
|
|
now() |
|
|
updatedby |
numeric |
10 |
|
|
|
|
|
c_order_id |
numeric |
10 |
|
|
|
|
|
line |
numeric |
10 |
|
|
|
|
|
c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
c_bpartner_location_id |
numeric |
10 |
√ |
|
null |
|
|
dateordered |
timestamp |
29,6 |
|
|
|
|
|
datepromised |
timestamp |
29,6 |
√ |
|
null |
|
|
datedelivered |
timestamp |
29,6 |
√ |
|
null |
|
|
dateinvoiced |
timestamp |
29,6 |
√ |
|
null |
|
|
description |
varchar |
255 |
√ |
|
null |
|
|
m_product_id |
numeric |
10 |
√ |
|
null |
|
|
m_warehouse_id |
numeric |
10 |
|
|
|
|
|
c_uom_id |
numeric |
10 |
|
|
|
|
|
qtyordered |
numeric |
0 |
|
|
0 |
|
|
qtyreserved |
numeric |
0 |
|
|
0 |
|
|
qtydelivered |
numeric |
0 |
|
|
0 |
|
|
qtyinvoiced |
numeric |
0 |
|
|
0 |
|
|
m_shipper_id |
numeric |
10 |
√ |
|
null |
|
|
c_currency_id |
numeric |
10 |
|
|
|
|
|
pricelist |
numeric |
0 |
|
|
0 |
|
|
priceactual |
numeric |
0 |
|
|
0 |
|
|
pricelimit |
numeric |
0 |
|
|
0 |
|
|
linenetamt |
numeric |
0 |
|
|
0 |
|
|
discount |
numeric |
0 |
√ |
|
null |
|
|
freightamt |
numeric |
0 |
|
|
0 |
|
|
c_charge_id |
numeric |
10 |
√ |
|
null |
|
|
c_tax_id |
numeric |
10 |
|
|
|
|
|
s_resourceassignment_id |
numeric |
10 |
√ |
|
null |
|
|
ref_orderline_id |
numeric |
10 |
√ |
|
null |
|
|
m_attributesetinstance_id |
numeric |
10 |
√ |
|
0 |
|
|
isdescription |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
processed |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
qtyentered |
numeric |
0 |
|
|
|
|
|
priceentered |
numeric |
0 |
|
|
|
|
|
c_project_id |
numeric |
10 |
√ |
|
null |
|
|
pricecost |
numeric |
0 |
√ |
|
null |
|
|
qtylostsales |
numeric |
0 |
|
|
0 |
|
|
c_projectphase_id |
numeric |
10 |
√ |
|
null |
|
|
c_projecttask_id |
numeric |
10 |
√ |
|
null |
|
|
rrstartdate |
timestamp |
29,6 |
√ |
|
null |
|
|
rramt |
numeric |
0 |
√ |
|
null |
|
|
c_campaign_id |
numeric |
10 |
√ |
|
null |
|
|
c_activity_id |
numeric |
10 |
√ |
|
null |
|
|
user1_id |
numeric |
10 |
√ |
|
null |
|
|
user2_id |
numeric |
10 |
√ |
|
null |
|
|
ad_orgtrx_id |
numeric |
10 |
√ |
|
null |
|
|
link_orderline_id |
numeric |
10 |
√ |
|
null |
|
|
pp_cost_collector_id |
numeric |
10 |
√ |
|
null |
|
|
m_promotion_id |
numeric |
10 |
√ |
|
null |
|
|
c_orderline_uu |
varchar |
36 |
√ |
|
NULL::character varying |
|
|
createshipment |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
createproduction |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
Table contained 27 rows at 2024-01-03 13:53 +0100
|