c_invoice_linetax_v

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
ad_language text 2147483647 √ null
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id Implied Constraint R
c_invoiceline_id numeric 0 √ null
c_tax_id numeric 0 √ null
taxamt numeric 0 √ null
linetotalamt numeric 0 √ null
taxindicator varchar 2147483647 √ null
line numeric 0 √ null
m_product_id numeric 0 √ null
qtyinvoiced numeric 0 √ null
qtyentered numeric 0 √ null
uomsymbol varchar 2147483647 √ null
name varchar 2147483647 √ null
character_entity.name Implied Constraint R
description varchar 2147483647 √ null
documentnote varchar 2147483647 √ null
upc varchar 2147483647 √ null
sku varchar 2147483647 √ null
productvalue varchar 2147483647 √ null
resourcedescription varchar 2147483647 √ null
pricelist numeric 0 √ null
priceenteredlist numeric 0 √ null
discount numeric 0 √ null
priceactual numeric 0 √ null
priceentered numeric 0 √ null
linenetamt numeric 0 √ null
m_attributesetinstance_id numeric 0 √ null
m_attributeset_id numeric 0 √ null
serno varchar 2147483647 √ null
lot varchar 2147483647 √ null
m_lot_id numeric 0 √ null
guaranteedate timestamp 29,6 √ null
productdescription varchar 2147483647 √ null
imageurl varchar 2147483647 √ null
c_campaign_id numeric 0 √ null
c_project_id numeric 0 √ null
c_activity_id numeric 0 √ null
c_projectphase_id numeric 0 √ null
c_projecttask_id numeric 0 √ null
c_invoiceline_ad_orgtrx_id numeric 0 √ null
a_processed bpchar 2147483647 √ null
c_charge_id numeric 0 √ null
c_orderline_id numeric 0 √ null
c_uom_id numeric 0 √ null
isdescription bpchar 2147483647 √ null
c_invoiceline_isprinted bpchar 2147483647 √ null
m_inoutline_id numeric 0 √ null
m_rmaline_id numeric 0 √ null
pricelimit numeric 0 √ null
c_invoiceline_processed bpchar 2147483647 √ null
ref_invoiceline_id numeric 0 √ null
rramt numeric 0 √ null
rrstartdate timestamp 29,6 √ null
s_resourceassignment_id numeric 0 √ null
c_invoiceline_user1_id numeric 0 √ null
c_invoiceline_user2_id numeric 0 √ null
c_uom_ad_org_id numeric 0 √ null
costingprecision numeric 0 √ null
c_uom_description varchar 2147483647 √ null
c_uom_isactive bpchar 2147483647 √ null
c_uom_isdefault bpchar 2147483647 √ null
c_uom_name varchar 2147483647 √ null
character_entity.name Implied Constraint R
stdprecision numeric 0 √ null
uomtype varchar 2147483647 √ null
x12de355 varchar 2147483647 √ null
c_invoice_ad_org_id numeric 0 √ null
c_invoice_ad_orgtrx_id numeric 0 √ null
c_invoice_ad_user_id numeric 0 √ null
c_invoice_c_activity_id numeric 0 √ null
c_invoice_c_bpartner_id numeric 0 √ null
c_bpartner_location_id numeric 0 √ null
c_invoice_c_campaign_id numeric 0 √ null
c_invoice_c_charge_id numeric 0 √ null
c_conversiontype_id numeric 0 √ null
c_currency_id numeric 0 √ null
c_doctype_id numeric 0 √ null
c_doctypetarget_id numeric 0 √ null
c_dunninglevel_id numeric 0 √ null
c_invoice_chargeamt numeric 0 √ null
c_order_id numeric 0 √ null
c_payment_id numeric 0 √ null
c_paymentterm_id numeric 0 √ null
c_invoice_c_project_id numeric 0 √ null
c_invoice_created timestamp 29,6 √ null
c_invoice_createdby numeric 0 √ null
dateacct timestamp 29,6 √ null
dateinvoiced timestamp 29,6 √ null
dateordered timestamp 29,6 √ null
dateprinted timestamp 29,6 √ null
c_invoice_description varchar 2147483647 √ null
docaction bpchar 2147483647 √ null
docstatus bpchar 2147483647 √ null
documentno varchar 2147483647 √ null
dunninggrace timestamp 29,6 √ null
generateto bpchar 2147483647 √ null
grandtotal numeric 0 √ null
invoicecollectiontype bpchar 2147483647 √ null
c_invoice_isactive bpchar 2147483647 √ null
isapproved bpchar 2147483647 √ null
isdiscountprinted bpchar 2147483647 √ null
isindispute bpchar 2147483647 √ null
ispaid bpchar 2147483647 √ null
ispayschedulevalid bpchar 2147483647 √ null
c_invoice_isprinted bpchar 2147483647 √ null
c_invoice_isselfservice bpchar 2147483647 √ null
issotrx bpchar 2147483647 √ null
c_invoice_istaxincluded bpchar 2147483647 √ null
istransferred bpchar 2147483647 √ null
m_pricelist_id numeric 0 √ null
m_rma_id numeric 0 √ null
paymentrule bpchar 2147483647 √ null
poreference varchar 2147483647 √ null
posted bpchar 2147483647 √ null
processedon numeric 0 √ null
processing bpchar 2147483647 √ null
ref_invoice_id numeric 0 √ null
reversal_id numeric 0 √ null
salesrep_id numeric 0 √ null
sendemail bpchar 2147483647 √ null
totallines numeric 0 √ null
c_invoice_updated timestamp 29,6 √ null
c_invoice_updatedby numeric 0 √ null
c_invoice_user1_id numeric 0 √ null
c_invoice_user2_id numeric 0 √ null
c_tax_ad_org_id numeric 0 √ null
ad_rule_id numeric 0 √ null
c_country_id numeric 0 √ null
c_region_id numeric 0 √ null
c_tax_c_taxcategory_id numeric 0 √ null
c_tax_description varchar 2147483647 √ null
c_tax_isactive bpchar 2147483647 √ null
c_tax_isdefault bpchar 2147483647 √ null
isdocumentlevel bpchar 2147483647 √ null
issalestax bpchar 2147483647 √ null
c_tax_issummary bpchar 2147483647 √ null
istaxexempt bpchar 2147483647 √ null
c_tax_name varchar 2147483647 √ null
character_entity.name Implied Constraint R
parent_tax_id numeric 0 √ null
rate numeric 0 √ null
requirestaxcertificate bpchar 2147483647 √ null
sopotype bpchar 2147483647 √ null
to_country_id numeric 0 √ null
to_region_id numeric 0 √ null
validfrom timestamp 29,6 √ null
m_product_ad_org_id numeric 0 √ null
classification varchar 2147483647 √ null
m_product_copyfrom bpchar 2147483647 √ null
m_product_created timestamp 29,6 √ null
m_product_createdby numeric 0 √ null
c_revenuerecognition_id numeric 0 √ null
c_subscriptiontype_id numeric 0 √ null
m_product_c_taxcategory_id numeric 0 √ null
descriptionurl varchar 2147483647 √ null
discontinued bpchar 2147483647 √ null
discontinuedat timestamp 29,6 √ null
group1 varchar 2147483647 √ null
group2 varchar 2147483647 √ null
guaranteedays numeric 0 √ null
guaranteedaysmin numeric 0 √ null
help varchar 2147483647 √ null
m_product_isactive bpchar 2147483647 √ null
isbom bpchar 2147483647 √ null
isdropship bpchar 2147483647 √ null
isexcludeautodelivery bpchar 2147483647 √ null
isinvoiceprintdetails bpchar 2147483647 √ null
ispicklistprintdetails bpchar 2147483647 √ null
ispurchased bpchar 2147483647 √ null
m_product_isselfservice bpchar 2147483647 √ null
issold bpchar 2147483647 √ null
isstocked bpchar 2147483647 √ null
m_product_issummary bpchar 2147483647 √ null
isverified bpchar 2147483647 √ null
iswebstorefeatured bpchar 2147483647 √ null
lowlevel numeric 0 √ null
m_product_m_attributeset_id numeric 0 √ null
m_product_m_asi_id numeric 0 √ null
m_freightcategory_id numeric 0 √ null
m_locator_id numeric 0 √ null
m_product_m_prod_category_id numeric 0 √ null
m_product_processing bpchar 2147483647 √ null
producttype bpchar 2147483647 √ null
r_mailtext_id numeric 0 √ null
m_product_salesrep_id numeric 0 √ null
s_expensetype_id numeric 0 √ null
shelfdepth numeric 0 √ null
shelfheight numeric 0 √ null
shelfwidth numeric 0 √ null
m_product_s_resource_id numeric 0 √ null
unitsperpack numeric 0 √ null
unitsperpallet numeric 0 √ null
m_product_updated timestamp 29,6 √ null
m_product_updatedby numeric 0 √ null
versionno varchar 2147483647 √ null
volume numeric 0 √ null
weight numeric 0 √ null
c_charge_ad_org_id numeric 0 √ null
c_charge_c_bpartner_id numeric 0 √ null
c_chargetype_id numeric 0 √ null
c_charge_chargeamt numeric 0 √ null
c_charge_c_taxcategory_id numeric 0 √ null
c_charge_description varchar 2147483647 √ null
c_charge_isactive bpchar 2147483647 √ null
issamecurrency bpchar 2147483647 √ null
issametax bpchar 2147483647 √ null
c_charge_istaxincluded bpchar 2147483647 √ null
c_bp_product_ad_org_id numeric 0 √ null
c_bp_product_c_bpartner_id numeric 0 √ null
c_bp_product_created timestamp 29,6 √ null
c_bp_product_createdby numeric 0 √ null
c_bp_product_description varchar 2147483647 √ null
c_bp_product_isactive bpchar 2147483647 √ null
ismanufacturer bpchar 2147483647 √ null
manufacturer varchar 2147483647 √ null
qualityrating numeric 0 √ null
shelflifemindays numeric 0 √ null
shelflifeminpct numeric 0 √ null
c_bp_product_updated timestamp 29,6 √ null
c_bp_product_updatedby numeric 0 √ null
vendorcategory varchar 2147483647 √ null
s_rassignment_ad_org_id numeric 0 √ null
assigndatefrom timestamp 29,6 √ null
assigndateto timestamp 29,6 √ null
s_rassignment_created timestamp 29,6 √ null
s_rassignment_createby numeric 0 √ null
s_rassignment_isactive bpchar 2147483647 √ null
isconfirmed bpchar 2147483647 √ null
s_rassignment_name varchar 2147483647 √ null
character_entity.name Implied Constraint R
s_rassignment_qty numeric 0 √ null
s_rassignment_s_resource_id numeric 0 √ null
s_rassignment_updated timestamp 29,6 √ null
s_rassignment_updatedby numeric 0 √ null
m_asi_ad_org_id numeric 0 √ null
m_asi_created timestamp 29,6 √ null
m_asi_createdby numeric 0 √ null
m_asi_description varchar 2147483647 √ null
m_asi_isactive bpchar 2147483647 √ null
m_asi_updated timestamp 29,6 √ null
m_asi_updatedby numeric 0 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views