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 |
|
|
c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
value |
varchar |
40 |
√ |
|
null |
|
|
name |
varchar |
120 |
√ |
|
null |
|
|
name2 |
varchar |
60 |
√ |
|
null |
|
|
description |
varchar |
255 |
√ |
|
null |
|
|
issummary |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_group_id |
numeric |
10 |
√ |
|
null |
|
|
isonetime |
bpchar |
1 |
√ |
|
null |
|
|
isprospect |
bpchar |
1 |
√ |
|
null |
|
|
isvendor |
bpchar |
1 |
√ |
|
null |
|
|
iscustomer |
bpchar |
1 |
√ |
|
null |
|
|
isemployee |
bpchar |
1 |
√ |
|
null |
|
|
issalesrep |
bpchar |
1 |
√ |
|
null |
|
|
referenceno |
varchar |
40 |
√ |
|
null |
|
|
duns |
varchar |
11 |
√ |
|
null |
|
|
url |
varchar |
120 |
√ |
|
null |
|
|
ad_language |
varchar |
6 |
√ |
|
null |
|
|
taxid |
varchar |
20 |
√ |
|
null |
|
|
istaxexempt |
bpchar |
1 |
√ |
|
null |
|
|
c_invoiceschedule_id |
numeric |
10 |
√ |
|
null |
|
|
rating |
bpchar |
1 |
√ |
|
null |
|
|
salesvolume |
numeric |
10 |
√ |
|
null |
|
|
numberemployees |
numeric |
10 |
√ |
|
null |
|
|
naics |
varchar |
6 |
√ |
|
null |
|
|
firstsale |
timestamp |
29,6 |
√ |
|
null |
|
|
acqusitioncost |
numeric |
0 |
√ |
|
null |
|
|
potentiallifetimevalue |
numeric |
0 |
√ |
|
null |
|
|
actuallifetimevalue |
numeric |
0 |
√ |
|
null |
|
|
shareofcustomer |
numeric |
10 |
√ |
|
null |
|
|
paymentrule |
bpchar |
1 |
√ |
|
null |
|
|
so_creditlimit |
numeric |
0 |
√ |
|
null |
|
|
so_creditused |
numeric |
0 |
√ |
|
null |
|
|
so_creditavailable |
numeric |
0 |
√ |
|
null |
|
|
c_paymentterm_id |
numeric |
10 |
√ |
|
null |
|
|
m_pricelist_id |
numeric |
10 |
√ |
|
null |
|
|
m_discountschema_id |
numeric |
10 |
√ |
|
null |
|
|
c_dunning_id |
numeric |
10 |
√ |
|
null |
|
|
isdiscountprinted |
bpchar |
1 |
√ |
|
null |
|
|
so_description |
varchar |
255 |
√ |
|
null |
|
|
poreference |
varchar |
20 |
√ |
|
null |
|
|
paymentrulepo |
bpchar |
1 |
√ |
|
null |
|
|
po_pricelist_id |
numeric |
10 |
√ |
|
null |
|
|
po_discountschema_id |
numeric |
10 |
√ |
|
null |
|
|
po_paymentterm_id |
numeric |
10 |
√ |
|
null |
|
|
documentcopies |
numeric |
10 |
√ |
|
null |
|
|
c_greeting_id |
numeric |
10 |
√ |
|
null |
|
|
invoicerule |
bpchar |
1 |
√ |
|
null |
|
|
deliveryrule |
bpchar |
1 |
√ |
|
null |
|
|
freightcostrule |
bpchar |
1 |
√ |
|
null |
|
|
deliveryviarule |
bpchar |
1 |
√ |
|
null |
|
|
salesrep_id |
numeric |
10 |
√ |
|
null |
|
|
sendemail |
bpchar |
1 |
√ |
|
null |
|
|
bpartner_parent_id |
numeric |
10 |
√ |
|
null |
|
|
invoice_printformat_id |
numeric |
10 |
√ |
|
null |
|
|
socreditstatus |
bpchar |
1 |
√ |
|
null |
|
|
shelflifeminpct |
numeric |
10 |
√ |
|
null |
|
|
ad_orgbp_id |
numeric |
10 |
√ |
|
null |
|
|
flatdiscount |
numeric |
0 |
√ |
|
null |
|
|
totalopenbalance |
numeric |
0 |
√ |
|
null |
|
|
ad_user_id |
numeric |
10 |
√ |
|
null |
|
|
contactname |
varchar |
60 |
√ |
|
null |
|
|
contactdescription |
varchar |
255 |
√ |
|
null |
|
|
email |
varchar |
60 |
√ |
|
null |
|
|
supervisor_id |
numeric |
10 |
√ |
|
null |
|
|
emailuser |
varchar |
60 |
√ |
|
null |
|
|
bpcontactgreeting |
numeric |
10 |
√ |
|
null |
|
|
title |
varchar |
40 |
√ |
|
null |
|
|
comments |
varchar |
2000 |
√ |
|
null |
|
|
phone |
varchar |
40 |
√ |
|
null |
|
|
phone2 |
varchar |
40 |
√ |
|
null |
|
|
fax |
varchar |
40 |
√ |
|
null |
|
|
lastcontact |
timestamp |
29,6 |
√ |
|
null |
|
|
lastresult |
varchar |
255 |
√ |
|
null |
|
|
birthday |
timestamp |
29,6 |
√ |
|
null |
|
|
ad_orgtrx_id |
numeric |
10 |
√ |
|
null |
|
|
emailverify |
varchar |
40 |
√ |
|
null |
|
|
ldapuser |
varchar |
60 |
√ |
|
null |
|
|
emailverifydate |
timestamp |
29,6 |
√ |
|
null |
|
|
notificationtype |
bpchar |
1 |
√ |
|
null |
|
|
c_bpartner_location_id |
numeric |
10 |
√ |
|
null |
|
|
postal |
varchar |
10 |
√ |
|
null |
|
|
city |
varchar |
60 |
√ |
|
null |
|
|
address1 |
varchar |
60 |
√ |
|
null |
|
|
address2 |
varchar |
60 |
√ |
|
null |
|
|
address3 |
varchar |
60 |
√ |
|
null |
|
|
c_region_id |
numeric |
10 |
√ |
|
null |
|
|
regionname |
varchar |
2147483647 |
√ |
|
null |
|
|
c_country_id |
numeric |
10 |
√ |
|
null |
|
|
countryname |
varchar |
60 |
√ |
|
null |
|
|
c_bp_c_taxgroup_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_dunninggrace |
timestamp |
29,6 |
√ |
|
null |
|
|
c_bp_ismanufacturer |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_ispotaxexempt |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_logo_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_location_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_location_c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_location_c_location_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_location_created |
timestamp |
29,6 |
√ |
|
null |
|
|
c_bp_location_createdby |
numeric |
10 |
√ |
|
null |
|
|
c_bp_location_salesregion_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_location_fax |
varchar |
40 |
√ |
|
null |
|
|
c_bp_location_isactive |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_location_isbillto |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_location_isdn |
varchar |
40 |
√ |
|
null |
|
|
c_bp_location_ispayfrom |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_location_isremitto |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_location_isshipto |
bpchar |
1 |
√ |
|
null |
|
|
c_bp_location_name |
varchar |
60 |
√ |
|
null |
|
|
c_bp_location_phone |
varchar |
40 |
√ |
|
null |
|
|
c_bp_location_phone2 |
varchar |
40 |
√ |
|
null |
|
|
c_bp_location_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
c_bp_location_updatedby |
numeric |
10 |
√ |
|
null |
|
|
ad_user_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
ad_user_c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
ad_user_c_bpartner_location_id |
numeric |
10 |
√ |
|
null |
|
|
ad_user_created |
timestamp |
29,6 |
√ |
|
null |
|
|
ad_user_createdby |
numeric |
10 |
√ |
|
null |
|
|
ad_user_isactive |
bpchar |
1 |
√ |
|
null |
|
|
ad_user_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
ad_user_updatedby |
numeric |
10 |
√ |
|
null |
|
|
ad_user_value |
varchar |
40 |
√ |
|
null |
|
|
address4 |
varchar |
60 |
√ |
|
null |
|
|
c_location_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
c_city_id |
numeric |
10 |
√ |
|
null |
|
|
c_location_id |
numeric |
10 |
√ |
|
null |
|
|
c_location_created |
timestamp |
29,6 |
√ |
|
null |
|
|
c_location_createdby |
numeric |
10 |
√ |
|
null |
|
|
c_location_isactive |
bpchar |
1 |
√ |
|
null |
|
|
postal_add |
varchar |
10 |
√ |
|
null |
|
|
c_location_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
c_location_updatedby |
numeric |
10 |
√ |
|
null |
|
|
c_region_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
c_region_c_country_id |
numeric |
10 |
√ |
|
null |
|
|
c_region_description |
varchar |
255 |
√ |
|
null |
|
|
c_region_isactive |
bpchar |
1 |
√ |
|
null |
|
|
isdefault |
bpchar |
1 |
√ |
|
null |
|
|
c_country_ad_language |
varchar |
6 |
√ |
|
null |
|
|
c_country_c_currency_id |
numeric |
10 |
√ |
|
null |
|
|
countrycode |
bpchar |
2 |
√ |
|
null |
|
|
c_country_description |
varchar |
255 |
√ |
|
null |
|
|
c_country_isactive |
bpchar |
1 |
√ |
|
null |
|
|
Analyzed at 2024-01-03 13:44 +0100
|