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 |
|
|
ad_language |
varchar |
6 |
√ |
|
null |
|
|
c_invoice_id |
numeric |
10 |
√ |
|
null |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
Analyzed at 2024-01-03 13:53 +0100
|