i_invoice

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_invoice_id numeric 10 null
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
ad_org.ad_org_id adorg_iinvoice N
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_iinvoice N
isactive bpchar 1 √ 'Y'::bpchar
created timestamp 29,6 statement_timestamp()
createdby numeric 10 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ null
i_isimported bpchar 1 'N'::bpchar
i_errormsg varchar 2000 √ null
processing bpchar 1 √ null
processed bpchar 1 √ 'N'::bpchar
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id mpricelist_iinvoice N
c_currency_id numeric 10 √ null
c_currency.c_currency_id ccurrency_iinvoice N
salesrep_id numeric 10 √ null
ad_user.ad_user_id adusersalesrep_iinvoice N
issotrx bpchar 1 √ 'Y'::bpchar
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_iinvoice N
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbplocation_iinvoice N
bpartnervalue varchar 40 √ null
name varchar 60 √ null
c_location_id numeric 10 √ null
c_location.c_location_id clocation_iinvoice N
address1 varchar 60 √ null
address2 varchar 60 √ null
postal varchar 10 √ null
city varchar 60 √ null
c_region_id numeric 10 √ null
c_region.c_region_id cregion_iinvoice N
regionname varchar 60 √ null
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_iinvoice N
email varchar 60 √ null
contactname varchar 60 √ null
phone varchar 40 √ null
c_country_id numeric 10 √ null
c_country.c_country_id ccountry_iinvoice N
countrycode bpchar 2 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_iinvoice N
doctypename varchar 60 √ null
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpaymentterm_iinvoice N
paymenttermvalue varchar 40 √ null
c_project_id numeric 10 √ null
c_project.c_project_id cproject_iinvoice N
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_iinvoice N
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_iinvoice N
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_iinvoice N
documentno varchar 30 √ null
dateinvoiced timestamp 29,6 √ null
dateacct timestamp 29,6 √ null
description varchar 255 √ null
m_product_id numeric 10 √ null
m_product.m_product_id nproduct_iinvoice N
productvalue varchar 40 √ null
upc varchar 30 √ null
sku varchar 30 √ null
c_tax_id numeric 10 √ null
c_tax.c_tax_id ctax_iinvoice N
taxindicator varchar 100 √ null
taxamt numeric 0 √ 0
c_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id cinvliceline_iinvoice N
linedescription varchar 255 √ null
qtyordered numeric 0 √ 0
priceactual numeric 0 √ 0
projectvalue varchar 40 √ null
activityvalue varchar 40 √ null
chargename varchar 60 √ null
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_iinvoice R
i_invoice_uu varchar 36 √ NULL::character varying
c_1099box_id numeric 10 √ NULL::numeric
c_1099box.c_1099box_id c1099box_iinvoice R
c_1099box_value varchar 40 √ NULL::character varying
cof_cfopvalue varchar 60 √ NULL::character varying
lbr_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id lbrcfop_iinvoice R
cof_c_custody_id numeric 10 √ NULL::numeric
cof_c_custody.cof_c_custody_id cofccustody_iinvoice R
cof_custodyvalue varchar 50 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
i_invoice_pkey Primary key Asc i_invoice_id
i_invoice_uu_idx Must be unique Asc i_invoice_uu

Check Constraints

Constraint Name Constraint
i_invoice_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_invoice_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_invoice_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation