ad_clientinfo

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_adclientinfo C
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
isdiscountlineamt bpchar 1 'Y'::bpchar
c_calendar_id numeric 10 √ null
c_calendar.c_calendar_id ccalendar_adclientinfo R
c_acctschema1_id numeric 10 √ null
c_acctschema.c_acctschema_id cacctschema1_adclientinfo R
c_uom_volume_id numeric 10 √ null
c_uom.c_uom_id c_uom_volume_ad_clientinfo R
c_uom_weight_id numeric 10 √ null
c_uom.c_uom_id c_uom_weight_ad_clientinfo R
c_uom_length_id numeric 10 √ null
c_uom.c_uom_id c_uom_length_ad_clientinfo R
c_uom_time_id numeric 10 √ null
c_uom.c_uom_id c_uom_time_ad_clientinfo R
ad_tree_menu_id numeric 10 √ null
ad_tree.ad_tree_id adtreemenu_adclientinfo R
ad_tree_org_id numeric 10 √ null
ad_tree.ad_tree_id adtreeorg_adclientinfo R
ad_tree_bpartner_id numeric 10 √ null
ad_tree.ad_tree_id adtreebpartner_adclientinfo R
ad_tree_project_id numeric 10 √ null
ad_tree.ad_tree_id adtreeproject_adclientinfo R
ad_tree_salesregion_id numeric 10 √ null
ad_tree.ad_tree_id adtreesalesreg_adclientinfo R
ad_tree_product_id numeric 10 √ null
ad_tree.ad_tree_id adtreeproduct_adclientinfo R
m_productfreight_id numeric 10 √ null
m_product.m_product_id mproductfreight_adclientinfo R
c_bpartnercashtrx_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartnercashtrx_adclientinfo R
keeplogdays numeric 10 √ null
ad_tree_activity_id numeric 10 √ null
ad_tree.ad_tree_id adtreeactivity_adclientinfo R
ad_tree_campaign_id numeric 10 √ null
ad_tree.ad_tree_id adtreecampaign_adclientinfo R
logo_id numeric 10 √ NULL::numeric
ad_image.ad_image_id logo_adclientinfo R
logoreport_id numeric 10 √ NULL::numeric
ad_image.ad_image_id logoreport_adclientinfo R
logoweb_id numeric 10 √ NULL::numeric
ad_image.ad_image_id logoweb_adclientinfo R
ad_clientinfo_uu varchar 36 √ NULL::character varying
ad_storageprovider_id numeric 10 √ NULL::numeric
ad_storageprovider.ad_storageprovider_id adstorageprovider_adclientinfo R
storagearchive_id numeric 10 √ NULL::numeric
ad_storageprovider.ad_storageprovider_id storagearchive_adclientinfo R
c_chargefreight_id numeric 10 √ NULL::numeric
c_charge.c_charge_id cchargefreight_adclientinfo R
fy_startdate timestamp 29,6 √ null
isconfirmondocclose bpchar 1 'Y'::bpchar
isconfirmondocvoid bpchar 1 'N'::bpchar
storageimage_id numeric 10 √ NULL::numeric
ad_storageprovider.ad_storageprovider_id storageimage_adclientinfo R
timezone varchar 60 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_clientinfo_pkey Primary key Asc ad_client_id
ad_clientinfo_uu_idx Must be unique Asc ad_clientinfo_uu

Check Constraints

Constraint Name Constraint
ad_clientinfo_isconfirmondocvoid_check ((isconfirmondocvoid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_clientinfo_isconfirmondocclose_check ((isconfirmondocclose = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_clientinfo_isdiscountlineamt_check ((isdiscountlineamt = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_clientinfo_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation