SchemaSpy Analysis of idempiere9.adempiere - ColumnsRequisition / Demand | Generated by Quality Systems & Solutions |
Generated on 2021-12-25 14:55 +0100 |
| |||||
|
idempiere9.adempiere contains 684 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | |
c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | |
ad_user | ad_client_id | numeric | 10 | |||
c_bpartner | ad_client_id | numeric | 10 | |||
c_calendar | ad_client_id | numeric | 10 | |||
c_cashplan | ad_client_id | numeric | 10 | |||
c_cashplanline | ad_client_id | numeric | 10 | |||
c_charge | ad_client_id | numeric | 10 | |||
c_doctype | ad_client_id | numeric | 10 | |||
c_order | ad_client_id | numeric | 10 | |||
c_orderline | ad_client_id | numeric | 10 | |||
c_period | ad_client_id | numeric | 10 | |||
c_year | ad_client_id | numeric | 10 | |||
m_demand | ad_client_id | numeric | 10 | |||
m_demanddetail | ad_client_id | numeric | 10 | |||
m_demandline | ad_client_id | numeric | 10 | |||
m_forecast | ad_client_id | numeric | 10 | |||
m_forecastline | ad_client_id | numeric | 10 | |||
m_pricelist | ad_client_id | numeric | 10 | |||
m_product | ad_client_id | numeric | 10 | |||
m_requisition | ad_client_id | numeric | 10 | |||
m_requisitionline | ad_client_id | numeric | 10 | |||
m_warehouse | ad_client_id | numeric | 10 | |||
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | ad_language | varchar | 6 | √ | null | |
ad_user | ad_org_id | numeric | 10 | |||
c_bpartner | ad_org_id | numeric | 10 | |||
c_calendar | ad_org_id | numeric | 10 | |||
c_cashplan | ad_org_id | numeric | 10 | |||
c_cashplanline | ad_org_id | numeric | 10 | |||
c_charge | ad_org_id | numeric | 10 | |||
c_doctype | ad_org_id | numeric | 10 | |||
c_order | ad_org_id | numeric | 10 | |||
c_orderline | ad_org_id | numeric | 10 | |||
c_period | ad_org_id | numeric | 10 | |||
c_year | ad_org_id | numeric | 10 | |||
m_demand | ad_org_id | numeric | 10 | |||
m_demanddetail | ad_org_id | numeric | 10 | |||
m_demandline | ad_org_id | numeric | 10 | |||
m_forecast | ad_org_id | numeric | 10 | |||
m_forecastline | ad_org_id | numeric | 10 | |||
m_pricelist | ad_org_id | numeric | 10 | |||
m_product | ad_org_id | numeric | 10 | |||
m_requisition | ad_org_id | numeric | 10 | |||
m_requisitionline | ad_org_id | numeric | 10 | |||
m_warehouse | ad_org_id | numeric | 10 | |||
c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | |
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | |
c_cashplan | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | |
c_cashplanline | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | |
c_order | ad_orgtrx_id | numeric | 10 | √ | null | |
c_orderline | ad_orgtrx_id | numeric | 10 | √ | null | |
c_doctype | ad_printformat_id | numeric | 10 | √ | null | |
ad_user | ad_user_id | numeric | 10 | |||
c_order | ad_user_id | numeric | 10 | √ | null | |
m_requisition | ad_user_id | numeric | 10 | |||
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | |
c_order | amountrefunded | numeric | 22,2 | √ | null | |
c_order | amounttendered | numeric | 22,2 | √ | null | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | |
m_pricelist | basepricelist_id | numeric | 10 | √ | null | |
c_order | bill_bpartner_id | numeric | 10 | √ | null | |
c_order | bill_location_id | numeric | 10 | √ | null | |
c_order | bill_user_id | numeric | 10 | √ | null | |
ad_user | birthday | timestamp | 29,6 | √ | null | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | |
c_cashplan | c_activity_id | numeric | 10 | √ | null | |
c_cashplanline | c_activity_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_activity_id | numeric | 10 | √ | null | |
c_orderline | c_activity_id | numeric | 10 | √ | null | |
c_bpartner | c_bp_group_id | numeric | 10 | |||
ad_user | c_bpartner_id | numeric | 10 | √ | null | |
c_bpartner | c_bpartner_id | numeric | 10 | |||
c_cashplan | c_bpartner_id | numeric | 10 | √ | NULL::numeric | |
c_cashplanline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | |
c_charge | c_bpartner_id | numeric | 10 | √ | null | |
c_order | c_bpartner_id | numeric | 10 | |||
c_orderline | c_bpartner_id | numeric | 10 | √ | null | |
m_requisitionline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | |
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | |
c_order | c_bpartner_location_id | numeric | 10 | |||
c_orderline | c_bpartner_location_id | numeric | 10 | √ | null | |
c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | |
c_calendar | c_calendar_id | numeric | 10 | |||
c_year | c_calendar_id | numeric | 10 | |||
m_demand | c_calendar_id | numeric | 10 | |||
m_forecast | c_calendar_id | numeric | 10 | |||
c_calendar | c_calendar_uu | varchar | 36 | √ | NULL::character varying | |
ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | |
c_cashplan | c_campaign_id | numeric | 10 | √ | NULL::numeric | |
c_cashplanline | c_campaign_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_campaign_id | numeric | 10 | √ | null | |
c_orderline | c_campaign_id | numeric | 10 | √ | null | |
c_order | c_cashline_id | numeric | 10 | √ | null | |
c_cashplan | c_cashplan_id | numeric | 10 | |||
c_cashplanline | c_cashplan_id | numeric | 10 | |||
c_cashplan | c_cashplan_uu | varchar | 36 | √ | NULL::character varying | |
c_cashplanline | c_cashplanline_id | numeric | 10 | |||
c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | |
c_cashplanline | c_cashplanline_uu | varchar | 36 | √ | NULL::character varying | |
c_cashplanline | c_charge_id | numeric | 10 | √ | NULL::numeric | |
c_charge | c_charge_id | numeric | 10 | |||
c_order | c_charge_id | numeric | 10 | √ | null | |
c_orderline | c_charge_id | numeric | 10 | √ | null | |
m_requisitionline | c_charge_id | numeric | 10 | √ | null | |
c_charge | c_charge_uu | varchar | 36 | √ | NULL::character varying | |
c_charge | c_chargetype_id | numeric | 10 | √ | null | |
c_order | c_conversiontype_id | numeric | 10 | √ | null | |
c_order | c_currency_id | numeric | 10 | |||
c_orderline | c_currency_id | numeric | 10 | |||
m_pricelist | c_currency_id | numeric | 10 | |||
c_doctype | c_doctype_id | numeric | 10 | |||
c_order | c_doctype_id | numeric | 10 | |||
m_requisition | c_doctype_id | numeric | 10 | |||
c_doctype | c_doctype_uu | varchar | 36 | √ | NULL::character varying | |
c_doctype | c_doctypedifference_id | numeric | 10 | √ | null | |
c_doctype | c_doctypeinvoice_id | numeric | 10 | √ | null | |
c_doctype | c_doctypeproforma_id | numeric | 10 | √ | null | |
c_doctype | c_doctypeshipment_id | numeric | 10 | √ | null | |
c_order | c_doctypetarget_id | numeric | 10 | |||
c_bpartner | c_dunning_id | numeric | 10 | √ | null | |
ad_user | c_greeting_id | numeric | 10 | √ | null | |
c_bpartner | c_greeting_id | numeric | 10 | √ | null | |
c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | |
ad_user | c_job_id | numeric | 10 | √ | null | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | |
m_warehouse | c_location_id | numeric | 10 | |||
c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_order_id | numeric | 10 | |||
c_orderline | c_order_id | numeric | 10 | |||
c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | |
c_orderline | c_orderline_id | numeric | 10 | |||
m_demanddetail | c_orderline_id | numeric | 10 | √ | null | |
m_requisitionline | c_orderline_id | numeric | 10 | √ | null | |
c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | |
c_order | c_ordersource_id | numeric | 10 | √ | null | |
c_order | c_payment_id | numeric | 10 | √ | null | |
c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | |
c_order | c_paymentterm_id | numeric | 10 | |||
c_period | c_period_id | numeric | 10 | |||
m_demandline | c_period_id | numeric | 10 | |||
m_forecastline | c_period_id | numeric | 10 | |||
c_period | c_period_uu | varchar | 36 | √ | NULL::character varying | |
c_order | c_pos_id | numeric | 10 | √ | null | |
c_cashplan | c_project_id | numeric | 10 | √ | null | |
c_cashplanline | c_project_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_project_id | numeric | 10 | √ | null | |
c_orderline | c_project_id | numeric | 10 | √ | null | |
c_cashplanline | c_projectphase_id | numeric | 10 | √ | NULL::numeric | |
c_orderline | c_projectphase_id | numeric | 10 | √ | null | |
c_cashplanline | c_projecttask_id | numeric | 10 | √ | NULL::numeric | |
c_orderline | c_projecttask_id | numeric | 10 | √ | null | |
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | |
c_orderline | c_tax_id | numeric | 10 | |||
c_charge | c_taxcategory_id | numeric | 10 | √ | null | |
m_product | c_taxcategory_id | numeric | 10 | |||
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | |
c_orderline | c_uom_id | numeric | 10 | |||
m_product | c_uom_id | numeric | 10 | |||
m_requisitionline | c_uom_id | numeric | 10 | √ | NULL::numeric | |
c_period | c_year_id | numeric | 10 | |||
c_year | c_year_id | numeric | 10 | |||
m_demand | c_year_id | numeric | 10 | |||
m_forecast | c_year_id | numeric | 10 | |||
c_year | c_year_uu | varchar | 36 | √ | NULL::character varying | |
c_cashplan | cashflowtype | bpchar | 1 | √ | NULL::bpchar | |
c_charge | chargeamt | numeric | 0 | 0 | ||
c_order | chargeamt | numeric | 0 | √ | 0 | |
m_product | classification | varchar | 12 | √ | null | |
ad_user | comments | varchar | 2000 | √ | null | |
ad_user | connectionprofile | bpchar | 1 | √ | null | |
c_cashplan | copyfrom | bpchar | 1 | √ | NULL::bpchar | |
c_order | copyfrom | bpchar | 1 | √ | null | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | |
ad_user | created | timestamp | 29,6 | now() | ||
c_bpartner | created | timestamp | 29,6 | now() | ||
c_calendar | created | timestamp | 29,6 | now() | ||
c_cashplan | created | timestamp | 29,6 | statement_timestamp() | ||
c_cashplanline | created | timestamp | 29,6 | statement_timestamp() | ||
c_charge | created | timestamp | 29,6 | now() | ||
c_doctype | created | timestamp | 29,6 | now() | ||
c_order | created | timestamp | 29,6 | now() | ||
c_orderline | created | timestamp | 29,6 | now() | ||
c_period | created | timestamp | 29,6 | now() | ||
c_year | created | timestamp | 29,6 | now() | ||
m_demand | created | timestamp | 29,6 | now() | ||
m_demanddetail | created | timestamp | 29,6 | now() | ||
m_demandline | created | timestamp | 29,6 | now() | ||
m_forecast | created | timestamp | 29,6 | now() | ||
m_forecastline | created | timestamp | 29,6 | now() | ||
m_pricelist | created | timestamp | 29,6 | now() | ||
m_product | created | timestamp | 29,6 | now() | ||
m_requisition | created | timestamp | 29,6 | now() | ||
m_requisitionline | created | timestamp | 29,6 | now() | ||
m_warehouse | created | timestamp | 29,6 | now() | ||
ad_user | createdby | numeric | 10 | |||
c_bpartner | createdby | numeric | 10 | |||
c_calendar | createdby | numeric | 10 | |||
c_cashplan | createdby | numeric | 10 | |||
c_cashplanline | createdby | numeric | 10 | |||
c_charge | createdby | numeric | 10 | |||
c_doctype | createdby | numeric | 10 | |||
c_order | createdby | numeric | 10 | |||
c_orderline | createdby | numeric | 10 | |||
c_period | createdby | numeric | 10 | |||
c_year | createdby | numeric | 10 | |||
m_demand | createdby | numeric | 10 | |||
m_demanddetail | createdby | numeric | 10 | |||
m_demandline | createdby | numeric | 10 | |||
m_forecast | createdby | numeric | 10 | |||
m_forecastline | createdby | numeric | 10 | |||
m_pricelist | createdby | numeric | 10 | |||
m_product | createdby | numeric | 10 | |||
m_requisition | createdby | numeric | 10 | |||
m_requisitionline | createdby | numeric | 10 | |||
m_warehouse | createdby | numeric | 10 | |||
c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | |
c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | |
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | |
m_product | customstariffnumber | varchar | 20 | √ | null | |
ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | |
c_order | dateacct | timestamp | 29,6 | |||
c_orderline | datedelivered | timestamp | 29,6 | √ | null | |
c_cashplan | datedoc | timestamp | 29,6 | |||
m_requisition | datedoc | timestamp | 29,6 | now() | ||
c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | |
ad_user | datelastlogin | timestamp | 29,6 | √ | null | |
c_order | dateordered | timestamp | 29,6 | |||
c_orderline | dateordered | timestamp | 29,6 | |||
ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | |
c_order | dateprinted | timestamp | 29,6 | √ | null | |
c_order | datepromised | timestamp | 29,6 | √ | null | |
c_orderline | datepromised | timestamp | 29,6 | √ | null | |
m_forecastline | datepromised | timestamp | 29,6 | |||
m_requisition | daterequired | timestamp | 29,6 | |||
c_cashplanline | datetrx | timestamp | 29,6 | |||
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | |
c_doctype | definitesequence_id | numeric | 10 | √ | null | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | |
c_order | deliveryrule | bpchar | 1 | |||
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | |
c_order | deliveryviarule | bpchar | 1 | |||
ad_user | description | varchar | 255 | √ | null | |
c_bpartner | description | varchar | 255 | √ | null | |
c_calendar | description | varchar | 255 | √ | null | |
c_cashplan | description | varchar | 255 | √ | NULL::character varying | |
c_cashplanline | description | varchar | 255 | √ | NULL::character varying | |
c_charge | description | varchar | 255 | √ | null | |
c_doctype | description | varchar | 255 | √ | null | |
c_order | description | varchar | 255 | √ | null | |
c_orderline | description | varchar | 255 | √ | null | |
c_year | description | varchar | 255 | √ | null | |
m_demand | description | varchar | 255 | √ | null | |
m_forecast | description | varchar | 255 | √ | null | |
m_pricelist | description | varchar | 255 | √ | null | |
m_product | description | varchar | 255 | √ | null | |
m_requisition | description | varchar | 255 | √ | null | |
m_requisitionline | description | varchar | 255 | √ | null | |
m_warehouse | description | varchar | 255 | √ | null | |
m_product | descriptionurl | varchar | 120 | √ | null | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | |
m_product | discontinuedby | timestamp | 29,6 | √ | null | |
c_orderline | discount | numeric | 0 | √ | null | |
c_order | docaction | bpchar | 2 | |||
m_requisition | docaction | bpchar | 2 | |||
c_doctype | docbasetype | bpchar | 3 | |||
c_doctype | docnosequence_id | numeric | 10 | √ | null | |
c_order | docstatus | bpchar | 2 | |||
m_requisition | docstatus | bpchar | 2 | |||
c_doctype | docsubtypeinv | varchar | 2 | √ | NULL::character varying | |
c_doctype | docsubtypeso | bpchar | 2 | √ | null | |
c_bpartner | documentcopies | numeric | 10 | √ | null | |
c_doctype | documentcopies | numeric | 10 | |||
c_cashplan | documentno | varchar | 30 | |||
c_order | documentno | varchar | 30 | |||
m_requisition | documentno | varchar | 30 | |||
c_doctype | documentnote | varchar | 2000 | √ | null | |
m_product | documentnote | varchar | 2000 | √ | null | |
m_product | downloadurl | varchar | 120 | √ | null | |
c_order | dropship_bpartner_id | numeric | 10 | √ | null | |
c_order | dropship_location_id | numeric | 10 | √ | null | |
c_order | dropship_user_id | numeric | 10 | √ | null | |
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | |
c_bpartner | duns | varchar | 11 | √ | null | |
ad_user | varchar | 60 | √ | null | ||
ad_user | emailuser | varchar | 60 | √ | null | |
ad_user | emailuserpw | varchar | 255 | √ | null | |
ad_user | emailverify | varchar | 40 | √ | null | |
ad_user | emailverifydate | timestamp | 29,6 | √ | null | |
c_period | enddate | timestamp | 29,6 | √ | null | |
m_pricelist | enforcepricelimit | bpchar | 1 | 'N'::bpchar | ||
ad_user | failedlogincount | numeric | 10 | (0)::numeric | ||
ad_user | fax | varchar | 40 | √ | null | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | |
c_year | fiscalyear | varchar | 10 | |||
c_bpartner | flatdiscount | numeric | 0 | √ | null | |
c_order | freightamt | numeric | 0 | √ | 0 | |
c_orderline | freightamt | numeric | 0 | 0 | ||
c_bpartner | freightcostrule | bpchar | 1 | √ | null | |
c_order | freightcostrule | bpchar | 1 | |||
c_cashplan | generateperiodic | bpchar | 1 | √ | NULL::bpchar | |
c_doctype | gl_category_id | numeric | 10 | |||
c_cashplan | grandtotal | numeric | 0 | |||
c_order | grandtotal | numeric | 0 | 0 | ||
m_product | group1 | varchar | 255 | √ | null | |
m_product | group2 | varchar | 255 | √ | null | |
m_product | guaranteedays | numeric | 10 | √ | null | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | |
c_doctype | hascharges | bpchar | 1 | 'N'::bpchar | ||
c_doctype | hasproforma | bpchar | 1 | √ | 'N'::bpchar | |
m_demand | help | varchar | 2000 | √ | null | |
m_forecast | help | varchar | 2000 | √ | null | |
m_product | help | varchar | 2000 | √ | null | |
m_requisition | help | varchar | 2000 | √ | null | |
m_product | imageurl | varchar | 120 | √ | null | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | |
c_order | invoicerule | bpchar | 1 | |||
c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | ||
ad_user | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_calendar | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_cashplan | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_cashplanline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_charge | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_order | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_orderline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_period | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_year | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_demand | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_demanddetail | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_demandline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_forecast | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_forecastline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_pricelist | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_requisition | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_requisitionline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | ||
ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | ||
c_cashplan | isapproved | bpchar | 1 | |||
c_order | isapproved | bpchar | 1 | 'Y'::bpchar | ||
m_requisition | isapproved | bpchar | 1 | 'Y'::bpchar | ||
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | ||
c_doctype | ischargeorproductmandatory | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | iscreatecounter | bpchar | 1 | 'Y'::bpchar | ||
c_order | iscreditapproved | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isdefault | bpchar | 1 | 'N'::bpchar | ||
m_demand | isdefault | bpchar | 1 | 'N'::bpchar | ||
m_forecast | isdefault | bpchar | 1 | 'N'::bpchar | ||
m_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isdefaultcounterdoc | bpchar | 1 | 'N'::bpchar | ||
c_order | isdelivered | bpchar | 1 | 'N'::bpchar | ||
c_orderline | isdescription | bpchar | 1 | 'N'::bpchar | ||
m_warehouse | isdisallownegativeinv | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | |
c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isdocnocontrolled | bpchar | 1 | 'N'::bpchar | ||
c_order | isdropship | bpchar | 1 | 'N'::bpchar | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | ||
ad_user | isexpired | bpchar | 1 | 'N'::bpchar | ||
ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isindexed | bpchar | 1 | 'Y'::bpchar | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isintransit | bpchar | 1 | 'N'::bpchar | ||
m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | |
c_order | isinvoiced | bpchar | 1 | 'N'::bpchar | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | ||
ad_user | islocked | bpchar | 1 | 'N'::bpchar | ||
m_pricelist | ismandatory | bpchar | 1 | √ | 'N'::bpchar | |
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | |
ad_user | ismenuautoexpand | bpchar | 1 | √ | null | |
ad_user | isnoexpire | bpchar | 1 | 'N'::bpchar | ||
ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isnopricelistcheck | bpchar | 1 | √ | 'N'::bpchar | |
c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | ||
c_doctype | isoverwritedateoncomplete | bpchar | 1 | √ | 'N'::bpchar | |
c_doctype | isoverwriteseqoncomplete | bpchar | 1 | √ | 'N'::bpchar | |
m_product | isownbox | bpchar | 1 | 'N'::bpchar | ||
c_order | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | ||
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | |
m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | ||
c_doctype | ispickqaconfirm | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | ||
c_doctype | ispreparesplitdocument | bpchar | 1 | 'Y'::bpchar | ||
m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | |
c_order | isprinted | bpchar | 1 | 'N'::bpchar | ||
c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | ||
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | ||
c_charge | issamecurrency | bpchar | 1 | 'N'::bpchar | ||
c_charge | issametax | bpchar | 1 | 'N'::bpchar | ||
c_order | isselected | bpchar | 1 | 'N'::bpchar | ||
c_order | isselfservice | bpchar | 1 | 'N'::bpchar | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | isshipconfirm | bpchar | 1 | 'N'::bpchar | ||
ad_user | isshipto | bpchar | 1 | 'N'::bpchar | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | ||
m_pricelist | issopricelist | bpchar | 1 | 'Y'::bpchar | ||
c_cashplan | issotrx | bpchar | 1 | |||
c_doctype | issotrx | bpchar | 1 | 'Y'::bpchar | ||
c_order | issotrx | bpchar | 1 | 'Y'::bpchar | ||
c_doctype | issplitwhendifference | bpchar | 1 | 'N'::bpchar | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | ||
ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | |
c_charge | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
m_pricelist | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
m_product | istoformule | bpchar | 1 | √ | null | |
c_order | istransferred | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | ||
ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | ||
m_product | isverified | bpchar | 1 | 'N'::bpchar | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | ||
ad_user | lastcontact | timestamp | 29,6 | √ | null | |
ad_user | lastresult | varchar | 255 | √ | null | |
ad_user | ldapuser | varchar | 60 | √ | null | |
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | |
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | |
ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | |
c_cashplanline | line | numeric | 10 | |||
c_orderline | line | numeric | 10 | |||
m_requisitionline | line | numeric | 10 | |||
c_orderline | linenetamt | numeric | 0 | 0 | ||
m_requisitionline | linenetamt | numeric | 0 | 0 | ||
c_cashplanline | linetotalamt | numeric | 0 | √ | null | |
c_order | link_order_id | numeric | 10 | √ | null | |
c_orderline | link_orderline_id | numeric | 10 | √ | null | |
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | |
m_product | lowlevel | numeric | 10 | (0)::numeric | ||
m_product | m_attributeset_id | numeric | 10 | √ | null | |
c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_requisitionline | m_attributesetinstance_id | numeric | 0 | √ | null | |
m_demand | m_demand_id | numeric | 10 | |||
m_demandline | m_demand_id | numeric | 10 | |||
m_demand | m_demand_uu | varchar | 36 | √ | NULL::character varying | |
m_demanddetail | m_demanddetail_id | numeric | 10 | |||
m_demanddetail | m_demanddetail_uu | varchar | 36 | √ | NULL::character varying | |
m_demanddetail | m_demandline_id | numeric | 10 | |||
m_demandline | m_demandline_id | numeric | 10 | |||
m_demandline | m_demandline_uu | varchar | 36 | √ | NULL::character varying | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | |
m_forecast | m_forecast_id | numeric | 10 | |||
m_forecastline | m_forecast_id | numeric | 10 | |||
m_forecast | m_forecast_uu | varchar | 36 | √ | NULL::character varying | |
m_demanddetail | m_forecastline_id | numeric | 10 | √ | null | |
m_forecastline | m_forecastline_id | numeric | 10 | |||
m_forecastline | m_forecastline_uu | varchar | 36 | √ | NULL::character varying | |
c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | |
m_product | m_locator_id | numeric | 10 | √ | null | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | |
c_order | m_pricelist_id | numeric | 10 | |||
m_forecast | m_pricelist_id | numeric | 10 | √ | null | |
m_pricelist | m_pricelist_id | numeric | 10 | |||
m_requisition | m_pricelist_id | numeric | 10 | |||
m_pricelist | m_pricelist_uu | varchar | 36 | √ | NULL::character varying | |
m_product | m_product_category_id | numeric | 10 | |||
c_cashplanline | m_product_id | numeric | 10 | √ | NULL::numeric | |
c_orderline | m_product_id | numeric | 10 | √ | null | |
m_demandline | m_product_id | numeric | 10 | |||
m_forecastline | m_product_id | numeric | 10 | |||
m_product | m_product_id | numeric | 10 | |||
m_requisitionline | m_product_id | numeric | 10 | √ | null | |
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | |
c_orderline | m_promotion_id | numeric | 10 | √ | null | |
m_requisition | m_requisition_id | numeric | 10 | |||
m_requisitionline | m_requisition_id | numeric | 10 | |||
m_requisition | m_requisition_uu | varchar | 36 | √ | NULL::character varying | |
m_demanddetail | m_requisitionline_id | numeric | 10 | √ | null | |
m_requisitionline | m_requisitionline_id | numeric | 10 | |||
m_requisitionline | m_requisitionline_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | |
c_order | m_shipper_id | numeric | 10 | √ | null | |
c_orderline | m_shipper_id | numeric | 10 | √ | null | |
c_order | m_warehouse_id | numeric | 10 | |||
c_orderline | m_warehouse_id | numeric | 10 | |||
m_forecastline | m_warehouse_id | numeric | 10 | |||
m_requisition | m_warehouse_id | numeric | 10 | |||
m_warehouse | m_warehouse_id | numeric | 10 | |||
m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | |
c_bpartner | naics | varchar | 6 | √ | null | |
ad_user | name | varchar | 60 | |||
c_bpartner | name | varchar | 120 | |||
c_calendar | name | varchar | 60 | |||
c_cashplanline | name | varchar | 60 | √ | NULL::character varying | |
c_charge | name | varchar | 60 | |||
c_doctype | name | varchar | 60 | |||
c_period | name | varchar | 60 | |||
m_demand | name | varchar | 60 | |||
m_forecast | name | varchar | 60 | |||
m_pricelist | name | varchar | 60 | |||
m_product | name | varchar | 255 | |||
m_warehouse | name | varchar | 60 | |||
c_bpartner | name2 | varchar | 60 | √ | null | |
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | ||
c_bpartner | numberemployees | numeric | 10 | √ | null | |
c_order | ordertype | varchar | 510 | √ | null | |
ad_user | password | varchar | 1024 | √ | null | |
c_order | pay_bpartner_id | numeric | 10 | √ | null | |
c_order | pay_location_id | numeric | 10 | √ | null | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | |
c_order | paymentrule | bpchar | 1 | |||
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | |
c_period | periodno | numeric | 10 | |||
c_period | periodtype | bpchar | 1 | |||
ad_user | phone | varchar | 40 | √ | null | |
ad_user | phone2 | varchar | 40 | √ | null | |
c_bpartner | po_discountschema_id | numeric | 10 | √ | null | |
c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | |
c_bpartner | po_pricelist_id | numeric | 10 | √ | null | |
c_bpartner | poreference | varchar | 20 | √ | null | |
c_order | poreference | varchar | 20 | √ | null | |
c_order | posted | bpchar | 1 | 'N'::bpchar | ||
m_requisition | posted | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | |
c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | |
c_orderline | priceactual | numeric | 0 | 0 | ||
m_requisitionline | priceactual | numeric | 0 | 0 | ||
c_orderline | pricecost | numeric | 0 | √ | null | |
c_orderline | priceentered | numeric | 0 | |||
c_orderline | pricelimit | numeric | 0 | 0 | ||
c_orderline | pricelist | numeric | 0 | 0 | ||
m_pricelist | priceprecision | numeric | 10 | 2 | ||
c_doctype | printname | varchar | 60 | |||
c_order | priorityrule | bpchar | 1 | |||
m_requisition | priorityrule | bpchar | 1 | |||
c_cashplanline | probability | numeric | 0 | √ | null | |
c_cashplan | processed | bpchar | 1 | |||
c_cashplanline | processed | bpchar | 1 | |||
c_order | processed | bpchar | 1 | 'N'::bpchar | ||
c_orderline | processed | bpchar | 1 | 'N'::bpchar | ||
m_requisition | processed | bpchar | 1 | 'N'::bpchar | ||
c_order | processedon | numeric | 0 | √ | null | |
m_requisition | processedon | numeric | 0 | √ | null | |
ad_user | processing | bpchar | 1 | √ | null | |
c_order | processing | bpchar | 1 | √ | null | |
c_period | processing | bpchar | 1 | √ | null | |
c_year | processing | bpchar | 1 | √ | null | |
m_demand | processing | bpchar | 1 | √ | null | |
m_forecast | processing | bpchar | 1 | √ | null | |
m_product | processing | bpchar | 1 | √ | null | |
m_requisition | processing | bpchar | 1 | √ | null | |
m_product | producttype | bpchar | 1 | 'I'::bpchar | ||
c_order | promotioncode | varchar | 30 | √ | null | |
m_demandline | qty | numeric | 0 | 0 | ||
m_forecastline | qty | numeric | 0 | 0 | ||
m_requisitionline | qty | numeric | 0 | 0 | ||
m_demandline | qtycalculated | numeric | 0 | 0 | ||
m_forecastline | qtycalculated | numeric | 0 | 0 | ||
c_orderline | qtydelivered | numeric | 0 | 0 | ||
c_cashplanline | qtyentered | numeric | 0 | 1 | ||
c_orderline | qtyentered | numeric | 0 | |||
c_orderline | qtyinvoiced | numeric | 0 | 0 | ||
c_orderline | qtylostsales | numeric | 0 | 0 | ||
c_orderline | qtyordered | numeric | 0 | 0 | ||
c_orderline | qtyreserved | numeric | 0 | 0 | ||
c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | |
m_product | r_mailtext_id | numeric | 10 | √ | null | |
c_bpartner | rating | bpchar | 1 | √ | null | |
c_order | ref_order_id | numeric | 10 | √ | null | |
c_orderline | ref_orderline_id | numeric | 10 | √ | null | |
c_bpartner | referenceno | varchar | 40 | √ | null | |
m_warehouse | replenishmentclass | varchar | 60 | √ | null | |
c_orderline | rramt | numeric | 0 | √ | null | |
c_orderline | rrstartdate | timestamp | 29,6 | √ | null | |
m_product | s_expensetype_id | numeric | 10 | √ | null | |
m_product | s_resource_id | numeric | 10 | √ | null | |
c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | salesrep_id | numeric | 10 | √ | null | |
c_order | salesrep_id | numeric | 10 | √ | null | |
m_forecastline | salesrep_id | numeric | 10 | √ | null | |
m_product | salesrep_id | numeric | 10 | √ | null | |
c_bpartner | salesvolume | numeric | 10 | √ | null | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | |
ad_user | securityquestion | varchar | 1024 | √ | null | |
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | ||
c_order | sendemail | bpchar | 1 | 'N'::bpchar | ||
m_warehouse | separator | bpchar | 1 | |||
c_bpartner | shareofcustomer | numeric | 10 | √ | null | |
m_product | shelfdepth | numeric | 10 | √ | null | |
m_product | shelfheight | numeric | 0 | √ | null | |
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | |
m_product | shelfwidth | numeric | 10 | √ | null | |
c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | |
m_product | sku | varchar | 30 | √ | null | |
c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | |
c_bpartner | so_creditused | numeric | 0 | √ | 0 | |
c_bpartner | so_description | varchar | 255 | √ | null | |
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | |
c_period | startdate | timestamp | 29,6 | |||
ad_user | supervisor_id | numeric | 10 | √ | null | |
c_bpartner | taxid | varchar | 20 | √ | null | |
ad_user | title | varchar | 40 | √ | null | |
c_order | totallines | numeric | 0 | 0 | ||
m_requisition | totallines | numeric | 0 | 0 | ||
c_bpartner | totalopenbalance | numeric | 0 | √ | null | |
m_product | unitsperpack | numeric | 10 | 1 | ||
m_product | unitsperpallet | numeric | 0 | √ | null | |
m_product | upc | varchar | 30 | √ | null | |
ad_user | updated | timestamp | 29,6 | now() | ||
c_bpartner | updated | timestamp | 29,6 | now() | ||
c_calendar | updated | timestamp | 29,6 | now() | ||
c_cashplan | updated | timestamp | 29,6 | statement_timestamp() | ||
c_cashplanline | updated | timestamp | 29,6 | statement_timestamp() | ||
c_charge | updated | timestamp | 29,6 | now() | ||
c_doctype | updated | timestamp | 29,6 | now() | ||
c_order | updated | timestamp | 29,6 | now() | ||
c_orderline | updated | timestamp | 29,6 | now() | ||
c_period | updated | timestamp | 29,6 | now() | ||
c_year | updated | timestamp | 29,6 | now() | ||
m_demand | updated | timestamp | 29,6 | now() | ||
m_demanddetail | updated | timestamp | 29,6 | now() | ||
m_demandline | updated | timestamp | 29,6 | now() | ||
m_forecast | updated | timestamp | 29,6 | now() | ||
m_forecastline | updated | timestamp | 29,6 | now() | ||
m_pricelist | updated | timestamp | 29,6 | now() | ||
m_product | updated | timestamp | 29,6 | now() | ||
m_requisition | updated | timestamp | 29,6 | now() | ||
m_requisitionline | updated | timestamp | 29,6 | now() | ||
m_warehouse | updated | timestamp | 29,6 | now() | ||
ad_user | updatedby | numeric | 10 | |||
c_bpartner | updatedby | numeric | 10 | |||
c_calendar | updatedby | numeric | 10 | |||
c_cashplan | updatedby | numeric | 10 | |||
c_cashplanline | updatedby | numeric | 10 | |||
c_charge | updatedby | numeric | 10 | |||
c_doctype | updatedby | numeric | 10 | |||
c_order | updatedby | numeric | 10 | |||
c_orderline | updatedby | numeric | 10 | |||
c_period | updatedby | numeric | 10 | |||
c_year | updatedby | numeric | 10 | |||
m_demand | updatedby | numeric | 10 | |||
m_demanddetail | updatedby | numeric | 10 | |||
m_demandline | updatedby | numeric | 10 | |||
m_forecast | updatedby | numeric | 10 | |||
m_forecastline | updatedby | numeric | 10 | |||
m_pricelist | updatedby | numeric | 10 | |||
m_product | updatedby | numeric | 10 | |||
m_requisition | updatedby | numeric | 10 | |||
m_requisitionline | updatedby | numeric | 10 | |||
m_warehouse | updatedby | numeric | 10 | |||
c_bpartner | url | varchar | 120 | √ | null | |
c_cashplan | user1_id | numeric | 10 | √ | NULL::numeric | |
c_cashplanline | user1_id | numeric | 10 | √ | NULL::numeric | |
c_order | user1_id | numeric | 10 | √ | null | |
c_orderline | user1_id | numeric | 10 | √ | null | |
c_cashplan | user2_id | numeric | 10 | √ | NULL::numeric | |
c_cashplanline | user2_id | numeric | 10 | √ | NULL::numeric | |
c_order | user2_id | numeric | 10 | √ | null | |
c_orderline | user2_id | numeric | 10 | √ | null | |
ad_user | userpin | varchar | 20 | √ | null | |
ad_user | value | varchar | 40 | √ | null | |
c_bpartner | value | varchar | 40 | |||
m_product | value | varchar | 40 | |||
m_warehouse | value | varchar | 40 | |||
m_product | versionno | varchar | 20 | √ | null | |
c_order | volume | numeric | 0 | √ | null | |
m_product | volume | numeric | 0 | √ | 0 | |
c_order | weight | numeric | 0 | √ | null | |
m_product | weight | numeric | 0 | √ | 0 |