ad_orginfo

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_adorginfo C
ad_client_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
c_location_id numeric 10 √ null
c_location.c_location_id c_location_ad_orginfo R
duns varchar 11 null
taxid varchar 20 null
pa_goal_id numeric 10 √ null
pa_goal.pa_goal_id Implied Constraint R
supervisor_id numeric 10 √ null
ad_user.ad_user_id aduser_adorginfo N
parent_org_id numeric 10 √ null
ad_org.ad_org_id adorgparent_adorginfo N
ad_orgtype_id numeric 10 √ null
ad_orgtype.ad_orgtype_id adorgtype_adorginfo R
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id mwarehouse_adorginfo R
transferbank_id numeric 0 √ null
c_bank.c_bank_id cbank_adorginfo R
transfercashbook_id numeric 0 √ null
c_cashbook.c_cashbook_id ccashbook_adorginfo R
receiptfootermsg varchar 1023 √ null
dropship_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id dropshipwarehouse_adorginfo R
c_calendar_id numeric 10 √ null
c_calendar.c_calendar_id ccalendar_adorginfo R
logo_id numeric 10 √ NULL::numeric
ad_image.ad_image_id logo_adorginfo R
phone varchar 40 √ NULL::character varying
phone2 varchar 40 √ NULL::character varying
fax varchar 40 √ NULL::character varying
email varchar 60 √ NULL::character varying
ad_orginfo_uu varchar 36 √ NULL::character varying
lbr_cnpj varchar 18 √ null
lbr_ie varchar 30 √ null
lbr_ccm varchar 30 √ null
lbr_suframa varchar 30 √ null
lbr_tax_id numeric 0 √ null
lbr_legalentity varchar 60 √ null
contactname varchar 60 √ null
lbr_dc_org_id numeric 10 √ null
lbr_dc_ws_id numeric 10 √ null
lbr_cnae varchar 10 √ null
lbr_nfeenv bpchar 1 √ '1'::bpchar
lbr_fantasia varchar 255 √ null
lbr_nire varchar 60 √ NULL::character varying
lbr_nfetpemi bpchar 1 √ '1'::bpchar
cof_taxregimecode bpchar 1 √ NULL::bpchar
cof_simplestaxrate numeric 0 √ null
cof_procemi bpchar 1 √ NULL::bpchar
cof_form_trib bpchar 1 √ NULL::bpchar
cof_entityindicator bpchar 1 '0'::bpchar
cof_dtarq timestamp 29,6 √ null
cof_dtarqconv timestamp 29,6 √ null
cof_indie bpchar 1 √ NULL::bpchar
cof_dhcont timestamp 29,6 √ null
cof_xjust varchar 256 √ NULL::character varying
cof_tabelaanexos varchar 50 √ NULL::character varying
cof_tipotributacao bpchar 1 √ NULL::bpchar
cof_regimeespecialtributacao bpchar 1 √ NULL::bpchar
cof_naturezatributacao bpchar 1 √ NULL::bpchar
infresptec_cnpj varchar 18 √ null
infresptec_xcontato varchar 60 √ NULL::character varying
infresptec_email varchar 60 √ NULL::character varying
infresptec_fone varchar 14 √ NULL::character varying
infresptec_idcsrt varchar 2 √ null
infresptec_csrt varchar 36 √ NULL::character varying
cof_clas_estab_ind varchar 2 √ NULL::character varying
lbr_contatonfe_id numeric 10 √ null

Indexes

Constraint Name Type Sort Column(s)
ad_orginfo_pkey Primary key Asc ad_org_id
ad_orginfo_uu_idx Must be unique Asc ad_orginfo_uu

Check Constraints

Constraint Name Constraint
ad_orginfo_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation