| SchemaSpy Analysis of idempiere11.adempiere - ColumnsCommon Application | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:47 +0100 |
| |||||
|
| ||||||
idempiere11.adempiere contains 943 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | |
|---|---|---|---|---|---|---|---|
| c_bp_bankaccount | a_city | varchar | 60 | √ | null | City or the Credit Card or Account Holder | |
| c_bp_bankaccount | a_country | varchar | 40 | √ | null | Country | |
| c_bp_bankaccount | a_email | varchar | 60 | √ | null | Email Address | |
| c_bp_bankaccount | a_ident_dl | varchar | 20 | √ | null | Payment Identification - Driver License | |
| c_bp_bankaccount | a_ident_ssn | varchar | 20 | √ | null | Payment Identification - Social Security No | |
| c_bp_bankaccount | a_name | varchar | 60 | √ | null | Name on Credit Card or Account holder | |
| c_bp_bankaccount | a_state | varchar | 40 | √ | null | State of the Credit Card or Account holder | |
| c_bp_bankaccount | a_street | varchar | 60 | √ | null | Street address of the Credit Card or Account holder | |
| c_bp_bankaccount | a_zip | varchar | 20 | √ | null | Zip Code of the Credit Card or Account Holder | |
| c_bp_bankaccount | accountno | varchar | 20 | √ | null | Account Number | |
| c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | The cost of gaining the prospect as a customer | |
| c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | Actual Life Time Revenue | |
| c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
| c_country | ad_language | varchar | 6 | √ | null | Language for this entity | |
| c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | The Business Partner is another Organization for explicit Inter-Org transactions | |
| c_acctschema | ad_orgonly_id | numeric | 10 | √ | null | Create posting entries only for this organization | |
| c_project | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
| c_validcombination | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| c_channel | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
| c_doctype | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
| c_tax | ad_rule_id | numeric | 10 | √ | null | Rule | |
| c_element | ad_tree_id | numeric | 10 | √ | null | Identifies a Tree | |
| c_bp_bankaccount | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| c_project | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| c_location | address1 | varchar | 60 | √ | null | Address line 1 for this location | |
| c_location | address2 | varchar | 60 | √ | null | Address line 2 for this location | |
| c_location | address3 | varchar | 60 | √ | null | Address Line 3 for the location | |
| c_location | address4 | varchar | 60 | √ | null | Address Line 4 for the location | |
| c_location | address5 | varchar | 60 | √ | NULL::character varying | Address Line 5 for the location | |
| c_validcombination | alias | varchar | 40 | √ | null | Defines an alternate method of indicating an account combination. | |
| c_country | allowcitiesoutoflist | bpchar | 1 | √ | 'Y'::bpchar | A flag to allow cities, currently not in the list, to be entered | |
| c_city | areacode | varchar | 10 | √ | null | Phone Area Code | |
| c_bp_bankaccount | bankaccounttype | bpchar | 1 | √ | null | Bank Account Type | |
| c_bankaccount | bban | varchar | 40 | √ | null | Basic Bank Account Number | |
| c_withholding | beneficiary | numeric | 10 | √ | null | Business Partner to whom payment is made | |
| c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
| c_elementvalue | bpartnertype | bpchar | 1 | √ | NULL::bpchar | Business Partner Type | |
| c_bp_bankaccount | bpbankacctuse | bpchar | 1 | √ | null | Business Partner Bank Account usage | |
| c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_UU | |
| c_project | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
| c_validcombination | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_activity | c_activity_uu | varchar | 36 | √ | NULL::character varying | C_Activity_UU | |
| c_location | c_addressvalidation_id | numeric | 10 | √ | NULL::numeric | Address Validation | |
| c_bp_bankaccount | c_bank_id | numeric | 10 | √ | null | Bank | |
| c_bank | c_bank_uu | varchar | 36 | √ | NULL::character varying | C_Bank_UU | |
| c_elementvalue | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
| c_bankaccount | c_bankaccount_uu | varchar | 36 | √ | NULL::character varying | C_BankAccount_UU | |
| c_bp_bankaccount | c_bp_bankaccount_uu | varchar | 36 | √ | NULL::character varying | C_BP_BankAccount_UU | |
| c_bp_withholding | c_bp_withholding_uu | varchar | 36 | √ | NULL::character varying | C_BP_Withholding_UU | |
| c_project | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| c_validcombination | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| c_project | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
| c_bpartner_location | c_bpartner_location_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_Location_UU | |
| c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
| c_project | c_bpartnersr_id | numeric | 10 | √ | null | Business Partner (Agent or Sales Rep) | |
| c_calendar | c_calendar_uu | varchar | 36 | √ | NULL::character varying | C_Calendar_UU | |
| c_project | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_validcombination | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_campaign | c_campaign_uu | varchar | 36 | √ | NULL::character varying | C_Campaign_UU | |
| c_campaign | c_channel_id | numeric | 10 | √ | null | Sales Channel | |
| c_channel | c_channel_uu | varchar | 36 | √ | NULL::character varying | C_Channel_UU | |
| c_location | c_city_id | numeric | 10 | √ | null | City | |
| c_city | c_city_uu | varchar | 36 | √ | NULL::character varying | C_City_UU | |
| c_conversion_rate | c_conversion_rate_uu | varchar | 36 | √ | NULL::character varying | C_Conversion_Rate_UU | |
| c_city | c_country_id | numeric | 10 | √ | null | Country | |
| c_countrygroupcountry | c_country_id | numeric | 10 | √ | NULL::numeric | Country | |
| c_nonbusinessday | c_country_id | numeric | 10 | √ | NULL::numeric | Country | |
| c_tax | c_country_id | numeric | 10 | √ | null | Country | |
| c_country | c_country_uu | varchar | 36 | √ | NULL::character varying | C_Country_UU | |
| c_countrygroupcountry | c_countrygroup_id | numeric | 10 | √ | NULL::numeric | Country Group | |
| c_countrygroup | c_countrygroup_uu | varchar | 36 | √ | NULL::character varying | C_CountryGroup_UU | |
| c_countrygroupcountry | c_countrygroupcountry_uu | varchar | 36 | √ | NULL::character varying | C_CountryGroupCountry_UU | |
| c_tax | c_countrygroupfrom_id | numeric | 10 | √ | NULL::numeric | Country Group From | |
| c_tax | c_countrygroupto_id | numeric | 10 | √ | NULL::numeric | Country Group To | |
| c_country | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
| c_elementvalue | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
| c_currency | c_currency_uu | varchar | 36 | √ | NULL::character varying | C_Currency_UU | |
| c_docbasegroup | c_docbasegroup_uu | varchar | 36 | √ | NULL::character varying | C_DocBaseGroup_UU | |
| c_docbasegroupline | c_docbasegroupline_uu | varchar | 36 | √ | NULL::character varying | C_DocBaseGroupLine_UU | |
| c_doctype | c_doctype_uu | varchar | 36 | √ | NULL::character varying | C_DocType_UU | |
| c_doctypecounter | c_doctypecounter_uu | varchar | 36 | √ | NULL::character varying | C_DocTypeCounter_UU | |
| c_doctype | c_doctypedifference_id | numeric | 10 | √ | null | Document type for generating in dispute Shipments | |
| c_doctype | c_doctypeinvoice_id | numeric | 10 | √ | null | Document type used for invoices generated from this sales document | |
| c_doctype | c_doctypeproforma_id | numeric | 10 | √ | null | Document type used for pro forma invoices generated from this sales document | |
| c_doctype | c_doctypeshipment_id | numeric | 10 | √ | null | Document type used for shipments generated from this sales document | |
| c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
| c_dunning | c_dunning_uu | varchar | 36 | √ | NULL::character varying | C_Dunning_UU | |
| c_element | c_element_uu | varchar | 36 | √ | NULL::character varying | C_Element_UU | |
| c_elementvalue | c_elementvalue_uu | varchar | 36 | √ | NULL::character varying | C_ElementValue_UU | |
| c_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
| c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | Schedule for generating Invoices | |
| c_bank | c_location_id | numeric | 10 | √ | null | Location or Address | |
| c_bpartner_location | c_location_id | numeric | 10 | √ | null | Location or Address | |
| c_location | c_location_uu | varchar | 36 | √ | NULL::character varying | C_Location_UU | |
| c_validcombination | c_locfrom_id | numeric | 10 | √ | null | Location that inventory was moved from | |
| c_validcombination | c_locto_id | numeric | 10 | √ | null | Location that inventory was moved to | |
| c_nonbusinessday | c_nonbusinessday_uu | varchar | 36 | √ | NULL::character varying | C_NonBusinessDay_UU | |
| c_bp_bankaccount | c_paymentprocessor_id | numeric | 10 | √ | NULL::numeric | Payment processor for electronic payments | |
| c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
| c_project | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
| c_paymentterm | c_paymentterm_uu | varchar | 36 | √ | NULL::character varying | C_PaymentTerm_UU | |
| c_acctschema | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
| c_period | c_period_uu | varchar | 36 | √ | NULL::character varying | C_Period_UU | |
| c_periodcontrol | c_periodcontrol_uu | varchar | 36 | √ | NULL::character varying | C_PeriodControl_UU | |
| c_project | c_phase_id | numeric | 10 | √ | null | Standard Phase of the Project Type | |
| c_validcombination | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_project | c_project_uu | varchar | 36 | √ | NULL::character varying | C_Project_UU | |
| c_project | c_projecttype_id | numeric | 10 | √ | null | Type of the project | |
| c_city | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
| c_location | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
| c_tax | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
| c_region | c_region_uu | varchar | 36 | √ | NULL::character varying | C_Region_UU | |
| m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
| c_bpartner_location | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
| c_validcombination | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
| c_salesregion | c_salesregion_uu | varchar | 36 | √ | NULL::character varying | C_SalesRegion_UU | |
| c_validcombination | c_subacct_id | numeric | 10 | √ | null | Sub account for Element Value | |
| m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
| c_tax | c_tax_uu | varchar | 36 | √ | NULL::character varying | C_Tax_UU | |
| c_taxcategory | c_taxcategory_uu | varchar | 36 | √ | NULL::character varying | C_TaxCategory_UU | |
| c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
| c_tax | c_taxprovider_id | numeric | 10 | √ | NULL::numeric | Tax Provider | |
| c_uom_conversion | c_uom_conversion_uu | varchar | 36 | √ | NULL::character varying | C_UOM_Conversion_UU | |
| c_uom | c_uom_uu | varchar | 36 | √ | NULL::character varying | C_UOM_UU | |
| c_validcombination | c_validcombination_uu | varchar | 36 | √ | NULL::character varying | C_ValidCombination_UU | |
| c_withholding | c_withholding_uu | varchar | 36 | √ | NULL::character varying | C_Withholding_UU | |
| c_year | c_year_uu | varchar | 36 | √ | NULL::character varying | C_Year_UU | |
| c_country | capturesequence | varchar | 60 | √ | null | Capture Sequence | |
| c_location | city | varchar | 60 | √ | null | Identifies a City | |
| m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
| c_validcombination | combination | varchar | 60 | √ | null | Unique combination of account elements | |
| c_location | comments | varchar | 2000 | √ | NULL::character varying | Comments or additional information | |
| c_taxcategory | commoditycode | varchar | 20 | √ | null | Commodity code used for tax calculation | |
| c_city | coordinates | varchar | 15 | √ | null | Location coordinate | |
| c_project | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
| m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| c_doctypecounter | counter_c_doctype_id | numeric | 10 | √ | null | Generated Counter Document Type (To) | |
| c_bp_bankaccount | creditcardexpmm | numeric | 10 | √ | null | Expiry Month | |
| c_bp_bankaccount | creditcardexpyy | numeric | 10 | √ | null | Expiry Year | |
| c_bp_bankaccount | creditcardnumber | varchar | 20 | √ | null | Credit Card Number | |
| c_bp_bankaccount | creditcardtype | bpchar | 1 | √ | null | Credit Card (Visa, MC, AmEx) | |
| c_bp_bankaccount | creditcardvv | varchar | 4 | √ | null | Credit Card Verification code on credit card | |
| c_currency | cursymbol | varchar | 10 | √ | null | Symbol of the currency (opt used for printing only) | |
| c_bpartner_location | customeraddressid | varchar | 60 | √ | NULL::character varying | Customer Address ID | |
| c_bp_bankaccount | customerpaymentprofileid | varchar | 60 | √ | NULL::character varying | Customer Payment Profile ID | |
| c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
| m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
| c_project | datecontract | timestamp | 29,6 | √ | null | The (planned) effective date of this document. | |
| c_project | datefinish | timestamp | 29,6 | √ | null | Finish or (planned) completion date | |
| c_countrygroup | datefrom | timestamp | 29,6 | √ | null | Starting date for a range | |
| c_countrygroupcountry | datefrom | timestamp | 29,6 | √ | null | Starting date for a range | |
| c_countrygroup | dateto | timestamp | 29,6 | √ | null | End date of a date range | |
| c_countrygroupcountry | dateto | timestamp | 29,6 | √ | null | End date of a date range | |
| c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
| c_doctype | definitesequence_id | numeric | 10 | √ | null | Definite Sequence | |
| c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
| c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
| c_acctschema | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_activity | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bank | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bankaccount | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_calendar | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_campaign | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_channel | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_country | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_countrygroup | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
| c_doctype | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_doctypecounter | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_dunning | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_element | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_elementvalue | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_paymentterm | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_project | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_region | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_salesregion | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_tax | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_taxcategory | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_uom | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_validcombination | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_withholding | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_year | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_warehouse | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
| m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
| m_product | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
| m_product | discontinuedby | timestamp | 29,6 | √ | null | ||
| c_country | displaysequencelocal | varchar | 20 | √ | null | Format for printing this Address locally | |
| c_doctypecounter | docaction | bpchar | 2 | √ | null | The targeted status of the document | |
| c_doctype | docnosequence_id | numeric | 10 | √ | null | Document sequence determines the numbering of documents | |
| c_doctype | docsubtypeinv | varchar | 2 | √ | NULL::character varying | Inventory Sub Type | |
| c_doctype | docsubtypeso | bpchar | 2 | √ | null | Sales Order Sub Type | |
| c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
| c_doctype | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| c_paymentterm | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| m_product | downloadurl | varchar | 120 | √ | null | ||
| c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
| c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
| c_currency | emuentrydate | timestamp | 29,6 | √ | null | Date when the currency joined / will join the EMU | |
| c_currency | emurate | numeric | 0 | √ | 0 | Official rate to the Euro | |
| c_campaign | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
| c_period | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
| c_bp_withholding | exemptreason | varchar | 20 | √ | null | Reason for not withholding | |
| c_country | expressionbankaccountno | varchar | 20 | √ | null | Format of the Bank Account | |
| c_country | expressionbankroutingno | varchar | 20 | √ | null | Format of the Bank Routing Number | |
| c_country | expressionphone | varchar | 20 | √ | null | Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
| c_country | expressionpostal | varchar | 20 | √ | null | Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
| c_country | expressionpostal_add | varchar | 20 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
| c_bpartner_location | fax | varchar | 40 | √ | null | Facsimile number | |
| c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
| c_withholding | fixamt | numeric | 0 | √ | 0 | Fix amounted amount to be levied or paid | |
| c_paymentterm | fixmonthcutoff | numeric | 10 | √ | null | Last day to include for next due date | |
| c_paymentterm | fixmonthday | numeric | 10 | √ | null | Day of the month of the due date | |
| c_paymentterm | fixmonthoffset | numeric | 10 | √ | null | Number of months (0=same, 1=following) | |
| c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
| c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
| c_project | generateto | bpchar | 1 | √ | null | Generate To | |
| m_product | group1 | varchar | 255 | √ | null | Group1 | |
| m_product | group2 | varchar | 255 | √ | null | Group2 | |
| m_product | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
| m_product | guaranteedaysmin | numeric | 10 | √ | null | Minimum number of guarantee days | |
| c_doctype | hasproforma | bpchar | 1 | √ | 'N'::bpchar | Indicates if Pro Forma Invoices can be generated from this document | |
| c_activity | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_countrygroup | help | varchar | 2000 | √ | NULL::character varying | Comment or Hint | |
| c_docbasegroup | help | varchar | 2000 | √ | NULL::character varying | Comment or Hint | |
| m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_bankaccount | iban | varchar | 40 | √ | null | International Bank Account Number | |
| c_bp_bankaccount | iban | varchar | 40 | √ | NULL::character varying | International Bank Account Number | |
| m_product | imageurl | varchar | 120 | √ | null | URL of image | |
| c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
| c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
| c_acctschema | isallownegativeposting | bpchar | 1 | √ | 'Y'::bpchar | Allow to post negative accounting values | |
| c_elementvalue | isbankaccount | bpchar | 1 | √ | 'N'::bpchar | Indicates if this is the Bank Account | |
| c_doctype | ischargeorproductmandatory | bpchar | 1 | √ | 'N'::bpchar | Mandatory Charge or Product | |
| c_paymentterm | isdefault | bpchar | 1 | √ | 'N'::bpchar | Default value | |
| c_region | isdefault | bpchar | 1 | √ | 'N'::bpchar | Default value | |
| c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
| c_bpartner_location | isdn | varchar | 40 | √ | null | ISDN or modem line | |
| c_elementvalue | isdoccontrolled | bpchar | 1 | √ | 'N'::bpchar | Control account - If an account is controlled by a document, you cannot post manually to it | |
| c_elementvalue | isforeigncurrency | bpchar | 1 | √ | 'N'::bpchar | Balances in foreign currency accounts are held in the nominated currency | |
| m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | Movement is in transit | |
| c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
| c_paymentterm | isnextbusinessday | bpchar | 1 | √ | 'Y'::bpchar | Payment due on the next business day | |
| c_doctype | isnopricelistcheck | bpchar | 1 | √ | 'N'::bpchar | Allow Product Without Price List | |
| c_doctype | isoverwritedateoncomplete | bpchar | 1 | √ | 'N'::bpchar | Overwrite Date on Complete | |
| c_doctype | isoverwriteseqoncomplete | bpchar | 1 | √ | 'N'::bpchar | Overwrite Sequence on Complete | |
| m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
| c_acctschema | ispostifclearingequal | bpchar | 1 | √ | 'Y'::bpchar | This flag controls if Adempiere must post when clearing (transit) and final accounts are the same | |
| c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
| m_product | istoformule | bpchar | 1 | √ | null | ||
| c_location | isvalid | bpchar | 1 | √ | 'N'::bpchar | Element is valid | |
| c_city | locode | varchar | 10 | √ | null | Location code - UN/LOCODE | |
| c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
| c_country | lookupclassname | varchar | 255 | √ | null | The class name of the postcode lookup plugin | |
| c_country | lookupclientid | varchar | 50 | √ | null | The Client ID or Login submitted to the Lookup URL | |
| c_country | lookuppassword | varchar | 50 | √ | null | The password submitted to the Lookup URL | |
| c_country | lookupurl | varchar | 100 | √ | null | The URL of the web service that the plugin connects to in order to retrieve postcode data | |
| m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
| m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| c_acctschema | m_costtype_id | numeric | 10 | √ | null | Type of Cost (e.g. Current, Plan, Future) | |
| c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
| m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
| m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | Part Type | |
| c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
| c_project | m_pricelist_version_id | numeric | 10 | √ | null | Identifies a unique instance of a Price List | |
| c_uom_conversion | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| c_validcombination | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
| m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | Reservation Locator (just for reporting purposes) | |
| c_project | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
| m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | M_Warehouse_UU | |
| m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | Optional Warehouse to replenish from | |
| c_withholding | maxamt | numeric | 0 | √ | 0 | Maximum Amount in invoice currency | |
| c_country | mediasize | varchar | 40 | √ | null | Java Media Size | |
| c_withholding | minamt | numeric | 0 | √ | 0 | Minimum Amount in invoice currency | |
| c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
| c_nonbusinessday | name | varchar | 60 | √ | null | Alphanumeric identifier of the entity | |
| c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
| c_paymentterm | netday | bpchar | 1 | √ | null | Day when payment is due net | |
| c_project | note | varchar | 2000 | √ | null | Optional additional user defined information | |
| c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
| c_tax | parent_tax_id | numeric | 10 | √ | null | Parent Tax indicates a tax that is made up of multiple taxes | |
| c_bankaccount | paymentexportclass | varchar | 60 | √ | NULL::character varying | Payment Export Class | |
| c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
| c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
| c_withholding | percent | numeric | 0 | √ | 0 | Percentage | |
| c_acctschema | period_openfuture | numeric | 10 | √ | null | Number of days to be able to post to a future date (based on system date) | |
| c_acctschema | period_openhistory | numeric | 10 | √ | null | Number of days to be able to post in the past (based on system date) | |
| c_periodcontrol | periodstatus | bpchar | 1 | √ | null | Current state of this period | |
| c_bpartner_location | phone | varchar | 40 | √ | null | Identifies a telephone number | |
| c_bpartner_location | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
| c_country | placeholderaddress1 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 1 | |
| c_country | placeholderaddress2 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 2 | |
| c_country | placeholderaddress3 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 3 | |
| c_country | placeholderaddress4 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 4 | |
| c_country | placeholderaddress5 | varchar | 255 | √ | NULL::character varying | Placeholder for Address 5 | |
| c_country | placeholdercity | varchar | 255 | √ | NULL::character varying | Placeholder for city | |
| c_country | placeholdercomments | varchar | 255 | √ | NULL::character varying | Placeholder for comments | |
| c_country | placeholderpostal | varchar | 255 | √ | NULL::character varying | Placeholder for postal | |
| c_country | placeholderpostal_add | varchar | 255 | √ | NULL::character varying | Placeholder for additional zip | |
| c_bpartner | po_discountschema_id | numeric | 10 | √ | null | Schema to calculate the purchase trade discount percentage | |
| c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | Payment rules for a purchase order | |
| c_bpartner | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
| c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_project | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_city | postal | varchar | 10 | √ | null | Postal code | |
| c_location | postal | varchar | 10 | √ | null | Postal code | |
| c_location | postal_add | varchar | 10 | √ | null | Additional ZIP or Postal code | |
| c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
| c_acctschema | processing | bpchar | 1 | √ | null | Process Now | |
| c_doctypecounter | processing | bpchar | 1 | √ | null | Process Now | |
| c_paymentterm | processing | bpchar | 1 | √ | null | Process Now | |
| c_period | processing | bpchar | 1 | √ | null | Process Now | |
| c_periodcontrol | processing | bpchar | 1 | √ | null | Process Now | |
| c_project | processing | bpchar | 1 | √ | null | Process Now | |
| c_year | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | processing | bpchar | 1 | √ | null | Process Now | |
| c_project | projectcategory | bpchar | 1 | √ | 'N'::bpchar | Project Category | |
| c_bp_bankaccount | r_avsaddr | bpchar | 1 | √ | null | This address has been verified | |
| c_bp_bankaccount | r_avszip | bpchar | 1 | √ | null | The Zip Code has been verified | |
| m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
| c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
| c_country | regionname | varchar | 60 | √ | null | Name of the Region | |
| c_location | regionname | varchar | 40 | √ | null | Name of the Region | |
| m_warehouse | replenishmentclass | varchar | 60 | √ | null | Custom class to calculate Quantity to Order | |
| c_location | result | varchar | 2000 | √ | NULL::character varying | Result of the action taken | |
| c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment Amount | |
| c_bp_bankaccount | routingno | varchar | 20 | √ | null | Bank Routing Number | |
| m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
| m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
| c_bpartner | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| c_project | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| c_salesregion | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| m_product | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| c_bpartner | salesvolume | numeric | 10 | √ | null | Total Volume of Sales in Thousands of Currency | |
| c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
| m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
| m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
| c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
| m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
| m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
| c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | Total outstanding invoice amounts allowed | |
| c_bpartner | so_creditused | numeric | 0 | √ | 0 | Current open balance | |
| c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
| c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
| c_campaign | startdate | timestamp | 29,6 | √ | null | First effective day (inclusive) | |
| c_bank | swiftcode | varchar | 20 | √ | null | Swift Code or BIC | |
| c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | Type of Tax Correction | |
| c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
| c_tax | taxindicator | varchar | 10 | √ | null | Short form for Tax to be printed on documents | |
| c_tax | taxpostingindicator | bpchar | 1 | √ | '0'::bpchar | Type of input tax (deductible and non deductible) | |
| c_withholding | thresholdmax | numeric | 0 | √ | 0 | Maximum gross amount for withholding calculation (0=no limit) | |
| c_withholding | thresholdmin | numeric | 0 | √ | 0 | Minimum gross amount for withholding calculation | |
| c_tax | to_country_id | numeric | 10 | √ | null | Receiving Country | |
| c_tax | to_region_id | numeric | 10 | √ | null | Receiving Region | |
| c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
| m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
| c_uom | uomsymbol | varchar | 10 | √ | null | Symbol for a Unit of Measure | |
| c_uom | uomtype | varchar | 2 | √ | NULL::character varying | UOM Type | |
| m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
| c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
| c_validcombination | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| c_validcombination | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| c_validcombination | userelement1_id | numeric | 10 | √ | null | User defined accounting Element | |
| c_validcombination | userelement2_id | numeric | 10 | √ | null | User defined accounting Element | |
| c_location | validateaddress | bpchar | 1 | √ | NULL::bpchar | Validate Address | |
| c_elementvalue | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
| c_conversion_rate | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
| c_elementvalue | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
| c_docbasegroup | value | varchar | 40 | √ | NULL::character varying | Search key for the record in the format required - must be unique | |
| m_product | versionno | varchar | 20 | √ | null | Version Number | |
| c_element | vformat | varchar | 40 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
| m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
| m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
| c_validcombination | account_id | numeric | 10 | Account used | |||
| c_bankaccount | accountno | varchar | 20 | Account Number | |||
| c_elementvalue | accountsign | bpchar | 1 | Indicates the Natural Sign of the Account as a Debit or Credit | |||
| c_elementvalue | accounttype | bpchar | 1 | Indicates the type of account | |||
| c_acctschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_activity | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bank | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bankaccount | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bp_bankaccount | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bp_withholding | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bpartner_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_calendar | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_campaign | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_channel | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_city | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_conversion_rate | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_country | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_countrygroup | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_countrygroupcountry | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_currency | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_docbasegroup | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_docbasegroupline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_doctype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_doctypecounter | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_dunning | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_element | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_elementvalue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_nonbusinessday | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_paymentterm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_period | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_periodcontrol | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_project | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_region | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_salesregion | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_tax | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_taxcategory | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_uom | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_uom_conversion | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_validcombination | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_withholding | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_year | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_warehouse | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_acctschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_activity | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bank | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bankaccount | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bp_bankaccount | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bp_withholding | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_calendar | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_campaign | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_channel | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_city | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_conversion_rate | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_country | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_countrygroup | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_countrygroupcountry | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_currency | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_docbasegroup | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_docbasegroupline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_doctype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_doctypecounter | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_dunning | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_element | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_elementvalue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_nonbusinessday | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_paymentterm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_period | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_periodcontrol | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_project | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_region | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_salesregion | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_tax | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_taxcategory | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_uom | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_uom_conversion | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_validcombination | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_withholding | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_year | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_warehouse | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_paymentterm | afterdelivery | bpchar | 1 | 'N'::bpchar | Due after delivery rather than after invoicing | ||
| c_acctschema | autoperiodcontrol | bpchar | 1 | 'N'::bpchar | If selected, the periods are automatically opened and closed | ||
| c_bankaccount | bankaccounttype | bpchar | 1 | Bank Account Type | |||
| c_acctschema | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_validcombination | c_acctschema_id | numeric | 10 | Rules for accounting | |||
| c_activity | c_activity_id | numeric | 10 | Business Activity | |||
| c_bank | c_bank_id | numeric | 10 | Bank | |||
| c_bankaccount | c_bank_id | numeric | 10 | Bank | |||
| c_bankaccount | c_bankaccount_id | numeric | 10 | Account at the Bank | |||
| c_bp_bankaccount | c_bp_bankaccount_id | numeric | 10 | Bank Account of the Business Partner | |||
| c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| c_bp_bankaccount | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bp_withholding | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bpartner_location | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bpartner_location | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
| c_calendar | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| c_nonbusinessday | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| c_year | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| c_campaign | c_campaign_id | numeric | 10 | Marketing Campaign | |||
| c_channel | c_channel_id | numeric | 10 | Sales Channel | |||
| c_city | c_city_id | numeric | 10 | City | |||
| c_conversion_rate | c_conversion_rate_id | numeric | 10 | Rate used for converting currencies | |||
| c_conversion_rate | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
| c_country | c_country_id | numeric | 10 | Country | |||
| c_location | c_country_id | numeric | 10 | Country | |||
| c_region | c_country_id | numeric | 10 | Country | |||
| c_countrygroup | c_countrygroup_id | numeric | 10 | Country Group | |||
| c_countrygroupcountry | c_countrygroupcountry_id | numeric | 10 | Country on Country Group | |||
| c_acctschema | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_bankaccount | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_conversion_rate | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_currency | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_project | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_conversion_rate | c_currency_id_to | numeric | 10 | Target currency | |||
| c_docbasegroup | c_docbasegroup_id | numeric | 10 | Group of Document Base Type for Period Control | |||
| c_docbasegroupline | c_docbasegroup_id | numeric | 10 | Group of Document Base Type for Period Control | |||
| c_docbasegroupline | c_docbasegroupline_id | numeric | 10 | Line Items of a Document Base Type Group | |||
| c_doctype | c_doctype_id | numeric | 10 | Document type or rules | |||
| c_doctypecounter | c_doctype_id | numeric | 10 | Document type or rules | |||
| c_doctypecounter | c_doctypecounter_id | numeric | 10 | Counter Document Relationship | |||
| c_dunning | c_dunning_id | numeric | 10 | Dunning Rules for overdue invoices | |||
| c_element | c_element_id | numeric | 10 | Accounting Element | |||
| c_elementvalue | c_element_id | numeric | 10 | Accounting Element | |||
| c_elementvalue | c_elementvalue_id | numeric | 10 | Account Element | |||
| c_location | c_location_id | numeric | 10 | Location or Address | |||
| m_warehouse | c_location_id | numeric | 10 | Location or Address | |||
| c_nonbusinessday | c_nonbusinessday_id | numeric | 10 | Day on which business is not transacted | |||
| c_paymentterm | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
| c_withholding | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
| c_period | c_period_id | numeric | 10 | Period of the Calendar | |||
| c_periodcontrol | c_period_id | numeric | 10 | Period of the Calendar | |||
| c_periodcontrol | c_periodcontrol_id | numeric | 10 | Period Control | |||
| c_project | c_project_id | numeric | 10 | Financial Project | |||
| c_region | c_region_id | numeric | 10 | Identifies a geographical Region | |||
| c_salesregion | c_salesregion_id | numeric | 10 | Sales coverage region | |||
| c_tax | c_tax_id | numeric | 10 | Tax identifier | |||
| c_tax | c_taxcategory_id | numeric | 10 | Tax Category | |||
| c_taxcategory | c_taxcategory_id | numeric | 10 | Tax Category | |||
| m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
| c_uom_conversion | c_uom_conversion_id | numeric | 10 | Unit of Measure Conversion | |||
| c_uom | c_uom_id | numeric | 10 | Unit of Measure | |||
| c_uom_conversion | c_uom_id | numeric | 10 | Unit of Measure | |||
| m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
| c_uom_conversion | c_uom_to_id | numeric | 10 | Target or destination Unit of Measure | |||
| c_validcombination | c_validcombination_id | numeric | 10 | Valid Account Combination | |||
| c_bp_withholding | c_withholding_id | numeric | 10 | Withholding type defined | |||
| c_withholding | c_withholding_id | numeric | 10 | Withholding type defined | |||
| c_period | c_year_id | numeric | 10 | Calendar Year | |||
| c_year | c_year_id | numeric | 10 | Calendar Year | |||
| c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | Create Commitment and/or Reservations for Budget Control | ||
| c_project | committedamt | numeric | 0 | 0 | The (legal) commitment amount | ||
| c_project | committedqty | numeric | 0 | 0 | The (legal) commitment Quantity | ||
| c_acctschema | costinglevel | bpchar | 1 | 'C'::bpchar | The lowest level to accumulate Costing Information | ||
| c_acctschema | costingmethod | bpchar | 1 | Indicates how Costs will be calculated | |||
| c_currency | costingprecision | numeric | 10 | Rounding used costing calculations | |||
| c_uom | costingprecision | numeric | 10 | Rounding used costing calculations | |||
| c_campaign | costs | numeric | 0 | 0 | Costs in accounting currency | ||
| c_country | countrycode | bpchar | 2 | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | |||
| c_acctschema | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_activity | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bank | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bankaccount | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_bankaccount | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bp_withholding | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner_location | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_calendar | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_campaign | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_channel | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_city | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_conversion_rate | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_country | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_countrygroup | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| c_countrygroupcountry | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| c_currency | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_docbasegroup | created | timestamp | 29,6 | Date this record was created | |||
| c_docbasegroupline | created | timestamp | 29,6 | Date this record was created | |||
| c_doctype | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_doctypecounter | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_dunning | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_element | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_elementvalue | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_location | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_nonbusinessday | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_paymentterm | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_period | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_periodcontrol | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_project | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_region | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_salesregion | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_tax | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_taxcategory | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_uom | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_uom_conversion | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_validcombination | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_withholding | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_year | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_warehouse | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_acctschema | createdby | numeric | 10 | User who created this records | |||
| c_activity | createdby | numeric | 10 | User who created this records | |||
| c_bank | createdby | numeric | 10 | User who created this records | |||
| c_bankaccount | createdby | numeric | 10 | User who created this records | |||
| c_bp_bankaccount | createdby | numeric | 10 | User who created this records | |||
| c_bp_withholding | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | createdby | numeric | 10 | User who created this records | |||
| c_bpartner_location | createdby | numeric | 10 | User who created this records | |||
| c_calendar | createdby | numeric | 10 | User who created this records | |||
| c_campaign | createdby | numeric | 10 | User who created this records | |||
| c_channel | createdby | numeric | 10 | User who created this records | |||
| c_city | createdby | numeric | 10 | User who created this records | |||
| c_conversion_rate | createdby | numeric | 10 | User who created this records | |||
| c_country | createdby | numeric | 10 | User who created this records | |||
| c_countrygroup | createdby | numeric | 10 | User who created this records | |||
| c_countrygroupcountry | createdby | numeric | 10 | User who created this records | |||
| c_currency | createdby | numeric | 10 | User who created this records | |||
| c_docbasegroup | createdby | numeric | 10 | User who created this records | |||
| c_docbasegroupline | createdby | numeric | 10 | User who created this records | |||
| c_doctype | createdby | numeric | 10 | User who created this records | |||
| c_doctypecounter | createdby | numeric | 10 | User who created this records | |||
| c_dunning | createdby | numeric | 10 | User who created this records | |||
| c_element | createdby | numeric | 10 | User who created this records | |||
| c_elementvalue | createdby | numeric | 10 | User who created this records | |||
| c_location | createdby | numeric | 10 | User who created this records | |||
| c_nonbusinessday | createdby | numeric | 10 | User who created this records | |||
| c_paymentterm | createdby | numeric | 10 | User who created this records | |||
| c_period | createdby | numeric | 10 | User who created this records | |||
| c_periodcontrol | createdby | numeric | 10 | User who created this records | |||
| c_project | createdby | numeric | 10 | User who created this records | |||
| c_region | createdby | numeric | 10 | User who created this records | |||
| c_salesregion | createdby | numeric | 10 | User who created this records | |||
| c_tax | createdby | numeric | 10 | User who created this records | |||
| c_taxcategory | createdby | numeric | 10 | User who created this records | |||
| c_uom | createdby | numeric | 10 | User who created this records | |||
| c_uom_conversion | createdby | numeric | 10 | User who created this records | |||
| c_validcombination | createdby | numeric | 10 | User who created this records | |||
| c_withholding | createdby | numeric | 10 | User who created this records | |||
| c_year | createdby | numeric | 10 | User who created this records | |||
| m_product | createdby | numeric | 10 | User who created this records | |||
| m_warehouse | createdby | numeric | 10 | User who created this records | |||
| c_dunning | createlevelssequentially | bpchar | 1 | 'N'::bpchar | Create Dunning Letter by level sequentially | ||
| c_bankaccount | creditlimit | numeric | 0 | 0 | Amount of Credit allowed | ||
| c_bankaccount | currentbalance | numeric | 0 | 0 | Current Balance | ||
| c_nonbusinessday | date1 | timestamp | 29,6 | Date when business is not conducted | |||
| c_currency | description | varchar | 255 | Optional short description of the record | |||
| c_paymentterm | discount | numeric | 0 | Discount in percent | |||
| c_paymentterm | discount2 | numeric | 0 | Discount in percent | |||
| c_paymentterm | discountdays | numeric | 10 | Number of days from invoice date to be eligible for discount | |||
| c_paymentterm | discountdays2 | numeric | 10 | Number of days from invoice date to be eligible for discount | |||
| c_country | displaysequence | varchar | 20 | Format for printing this Address | |||
| c_conversion_rate | dividerate | numeric | 0 | 0 | To convert Source number to Target number, the Source is divided | ||
| c_uom_conversion | dividerate | numeric | 0 | 0 | To convert Source number to Target number, the Source is divided | ||
| c_docbasegroupline | docbasetype | varchar | 3 | Logical type of document | |||
| c_doctype | docbasetype | bpchar | 3 | Logical type of document | |||
| c_periodcontrol | docbasetype | bpchar | 3 | Logical type of document | |||
| c_doctype | documentcopies | numeric | 10 | Number of copies to be printed | |||
| c_element | elementtype | bpchar | 1 | Element Type (account or user defined) | |||
| c_year | fiscalyear | varchar | 10 | The Fiscal Year | |||
| c_acctschema | gaap | bpchar | 2 | Generally Accepted Accounting Principles | |||
| c_doctype | gl_category_id | numeric | 10 | General Ledger Category | |||
| c_paymentterm | gracedays | numeric | 10 | Days after due date to send first dunning letter | |||
| c_acctschema | hasalias | bpchar | 1 | 'Y'::bpchar | Ability to select (partial) account combinations by an Alias | ||
| c_doctype | hascharges | bpchar | 1 | 'N'::bpchar | Charges can be added to the document | ||
| c_acctschema | hascombination | bpchar | 1 | 'Y'::bpchar | Combination of account elements are checked | ||
| c_country | haspostal_add | bpchar | 1 | 'N'::bpchar | Has Additional Postal Code | ||
| c_country | hasregion | bpchar | 1 | 'N'::bpchar | Country contains Regions | ||
| c_project | invoicedamt | numeric | 0 | 0 | The amount invoiced | ||
| c_project | invoicedqty | numeric | 0 | 0 | The quantity invoiced | ||
| c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
| c_acctschema | isaccrual | bpchar | 1 | 'Y'::bpchar | Indicates if Accrual or Cash Based accounting will be used | ||
| c_bp_bankaccount | isach | bpchar | 1 | 'N'::bpchar | Automatic Clearing House | ||
| c_acctschema | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_activity | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bank | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bankaccount | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_bankaccount | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bp_withholding | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bpartner_location | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_calendar | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_campaign | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_channel | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_city | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_conversion_rate | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_country | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_countrygroup | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_countrygroupcountry | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_currency | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_docbasegroup | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_docbasegroupline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_doctype | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_doctypecounter | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_dunning | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_element | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_elementvalue | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_location | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_nonbusinessday | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_paymentterm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_period | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_periodcontrol | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_project | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_region | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_salesregion | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_tax | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_taxcategory | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_uom | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_uom_conversion | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_validcombination | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_withholding | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_year | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_country | isaddresslineslocalreverse | bpchar | 1 | 'N'::bpchar | Print Local Address in reverse Order | ||
| c_country | isaddresslinesreverse | bpchar | 1 | 'N'::bpchar | Print Address in reverse Order | ||
| c_acctschema | isadjustcogs | bpchar | 1 | 'N'::bpchar | Adjust Cost of Good Sold | ||
| m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
| c_element | isbalancing | bpchar | 1 | 'N'::bpchar | All transactions within an element value must balance (e.g. cost centers) | ||
| c_bpartner_location | isbillto | bpchar | 1 | 'Y'::bpchar | Business Partner Invoice/Bill Address | ||
| m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
| c_project | iscommitceiling | bpchar | 1 | 'N'::bpchar | The commitment amount/quantity is the chargeable ceiling | ||
| c_project | iscommitment | bpchar | 1 | 'Y'::bpchar | Is this document a (legal) commitment? | ||
| c_doctype | iscreatecounter | bpchar | 1 | 'Y'::bpchar | Create Counter Document | ||
| c_doctypecounter | iscreatecounter | bpchar | 1 | 'Y'::bpchar | Create Counter Document | ||
| c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
| c_bankaccount | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_doctype | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_dunning | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_salesregion | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_tax | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_taxcategory | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_uom | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_doctype | isdefaultcounterdoc | bpchar | 1 | 'N'::bpchar | The document type is the default counter document type | ||
| c_elementvalue | isdetailbpartner | bpchar | 1 | 'N'::bpchar | Manage Business Partners | ||
| c_elementvalue | isdetailproduct | bpchar | 1 | 'N'::bpchar | Manage Products | ||
| m_warehouse | isdisallownegativeinv | bpchar | 1 | 'N'::bpchar | Negative Inventory is not allowed in this warehouse | ||
| c_acctschema | isdiscountcorrectstax | bpchar | 1 | 'N'::bpchar | Correct the tax for payment discount and charges | ||
| c_doctype | isdocnocontrolled | bpchar | 1 | 'N'::bpchar | The document has a document sequence | ||
| c_tax | isdocumentlevel | bpchar | 1 | 'Y'::bpchar | Tax is calculated on document level (rather than line by line) | ||
| m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
| c_paymentterm | isduefixed | bpchar | 1 | 'N'::bpchar | Payment is due on a fixed date | ||
| c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
| c_currency | isemumember | bpchar | 1 | 'N'::bpchar | This currency is member if the European Monetary Union | ||
| c_currency | iseuro | bpchar | 1 | 'N'::bpchar | This currency is the Euro | ||
| m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
| c_acctschema | isexplicitcostadjustment | bpchar | 1 | 'N'::bpchar | Post the cost adjustment explicitly | ||
| c_validcombination | isfullyqualified | bpchar | 1 | 'Y'::bpchar | This account is fully qualified | ||
| c_doctype | isindexed | bpchar | 1 | 'Y'::bpchar | Index the document for the internal search engine | ||
| c_doctype | isintransit | bpchar | 1 | 'N'::bpchar | Movement is in transit | ||
| m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the invoice | ||
| m_product | iskanban | bpchar | 1 | 'N'::bpchar | This part is Kanban controlled | ||
| c_bp_withholding | ismandatorywithholding | bpchar | 1 | 'N'::bpchar | Monies must be withheld | ||
| m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
| c_element | isnaturalaccount | bpchar | 1 | 'Y'::bpchar | The primary natural account | ||
| c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
| c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
| c_bank | isownbank | bpchar | 1 | 'N'::bpchar | Bank for this Organization | ||
| m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
| c_withholding | ispaidto3party | bpchar | 1 | 'Y'::bpchar | Amount paid to someone other than the Business Partner | ||
| c_bpartner_location | ispayfrom | bpchar | 1 | 'Y'::bpchar | Business Partner pays from that address and we'll send dunning letters there | ||
| c_withholding | ispercentwithholding | bpchar | 1 | 'Y'::bpchar | Withholding amount is a percentage of the invoice amount | ||
| m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the pick list | ||
| c_doctype | ispickqaconfirm | bpchar | 1 | 'N'::bpchar | Require Pick or QA Confirmation before processing | ||
| c_country | ispostcodelookup | bpchar | 1 | 'N'::bpchar | Does this country have a post code web service | ||
| c_acctschema | ispostservices | bpchar | 1 | 'N'::bpchar | Differentiate between Services and Product Receivable/Payables | ||
| c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
| c_doctype | ispreparesplitdocument | bpchar | 1 | 'Y'::bpchar | Prepare generated split shipment/receipt document | ||
| c_bpartner_location | ispreservecustomname | bpchar | 1 | 'N'::bpchar | Preserve custom name | ||
| c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
| m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
| c_bpartner_location | isremitto | bpchar | 1 | 'Y'::bpchar | Business Partner payment address | ||
| c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
| c_tax | issalestax | bpchar | 1 | 'N'::bpchar | This is a sales tax (i.e. not a value added tax) | ||
| m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| c_doctype | isshipconfirm | bpchar | 1 | 'N'::bpchar | Require Ship or Receipt Confirmation before processing | ||
| c_bpartner_location | isshipto | bpchar | 1 | 'Y'::bpchar | Business Partner Shipment Address | ||
| m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
| c_doctype | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| c_doctype | issplitwhendifference | bpchar | 1 | 'N'::bpchar | Split document when there is a difference | ||
| m_product | isstocked | bpchar | 1 | 'Y'::bpchar | Organization stocks this product | ||
| c_activity | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_campaign | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_elementvalue | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_project | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_salesregion | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_tax | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| m_product | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_tax | istaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on sales | ||
| c_withholding | istaxprorated | bpchar | 1 | 'N'::bpchar | Tax is Prorated | ||
| c_withholding | istaxwithholding | bpchar | 1 | 'Y'::bpchar | This is a tax related withholding | ||
| c_bp_withholding | istemporaryexempt | bpchar | 1 | 'N'::bpchar | Temporarily do not withhold taxes | ||
| c_acctschema | istradediscountposted | bpchar | 1 | 'N'::bpchar | Generate postings for trade discounts | ||
| c_doctypecounter | isvalid | bpchar | 1 | 'N'::bpchar | Element is valid | ||
| c_paymentterm | isvalid | bpchar | 1 | 'N'::bpchar | Element is valid | ||
| c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is a Vendor | ||
| m_product | isverified | bpchar | 1 | 'N'::bpchar | The BOM configuration has been verified | ||
| m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
| m_product | lowlevel | numeric | 10 | (0)::numeric | The Low Level is used to calculate the material plan and determines if a net requirement should be exploited | ||
| m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
| m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_warehouse | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| c_conversion_rate | multiplyrate | numeric | 0 | 0 | Rate to multiple the source by to calculate the target. | ||
| c_uom_conversion | multiplyrate | numeric | 0 | 0 | Rate to multiple the source by to calculate the target. | ||
| c_acctschema | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_activity | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bank | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bankaccount | name | varchar | 60 | NULL::character varying | Alphanumeric identifier of the entity | ||
| c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
| c_bpartner_location | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_calendar | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_campaign | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_channel | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_city | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_country | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_countrygroup | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_docbasegroup | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_doctype | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_doctypecounter | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_dunning | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_element | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_elementvalue | name | varchar | 120 | Alphanumeric identifier of the entity | |||
| c_paymentterm | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_period | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_project | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_region | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_salesregion | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_tax | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_taxcategory | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_uom | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_withholding | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
| m_warehouse | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_paymentterm | netdays | numeric | 10 | Net Days in which payment is due | |||
| c_paymentterm | paymenttermusage | bpchar | 1 | 'B'::bpchar | Payment term usage indicates if this payment term is used for sales, purchases or both. | ||
| c_periodcontrol | periodaction | bpchar | 1 | Action taken for this period | |||
| c_period | periodno | numeric | 10 | Unique Period Number | |||
| c_period | periodtype | bpchar | 1 | Period Type | |||
| c_project | plannedamt | numeric | 0 | 0 | Planned amount for this project | ||
| c_project | plannedmarginamt | numeric | 0 | 0 | Project's planned margin amount | ||
| c_project | plannedqty | numeric | 0 | 0 | Planned quantity for this project | ||
| c_elementvalue | postactual | bpchar | 1 | 'Y'::bpchar | Actual Values can be posted | ||
| c_elementvalue | postbudget | bpchar | 1 | 'Y'::bpchar | Budget values can be posted | ||
| c_elementvalue | postencumbrance | bpchar | 1 | 'Y'::bpchar | Post commitments to this account | ||
| c_elementvalue | poststatistical | bpchar | 1 | 'Y'::bpchar | Post statistical quantities to this account? | ||
| c_doctype | printname | varchar | 60 | The label text to be printed on a document or correspondence. | |||
| c_project | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
| c_project | projectbalanceamt | numeric | 0 | 0 | Total Project Balance | ||
| c_project | projectlinelevel | bpchar | 1 | 'P'::bpchar | Project Line Level | ||
| c_project | projinvoicerule | bpchar | 1 | '-'::bpchar | Invoice Rule for the project | ||
| c_tax | rate | numeric | 0 | Rate or Tax or Exchange | |||
| c_tax | requirestaxcertificate | bpchar | 1 | 'N'::bpchar | This tax rate requires the Business Partner to be tax exempt | ||
| c_bank | routingno | varchar | 20 | Bank Routing Number | |||
| c_dunning | senddunningletter | bpchar | 1 | 'Y'::bpchar | Indicates if dunning letters will be sent | ||
| c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| c_acctschema | separator | bpchar | 1 | Element Separator | |||
| m_warehouse | separator | bpchar | 1 | Element Separator | |||
| c_tax | sopotype | bpchar | 1 | 'B'::bpchar | Sales Tax applies to sales situations, Purchase Tax to purchase situations | ||
| c_period | startdate | timestamp | 29,6 | First effective day (inclusive) | |||
| c_currency | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
| c_uom | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
| m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
| c_acctschema | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_activity | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bank | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bankaccount | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_bankaccount | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bp_withholding | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner_location | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_calendar | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_campaign | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_channel | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_city | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_conversion_rate | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_country | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_countrygroup | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| c_countrygroupcountry | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| c_currency | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_docbasegroup | updated | timestamp | 29,6 | Date this record was updated | |||
| c_docbasegroupline | updated | timestamp | 29,6 | Date this record was updated | |||
| c_doctype | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_doctypecounter | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_dunning | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_element | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_elementvalue | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_location | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_nonbusinessday | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_paymentterm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_period | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_periodcontrol | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_project | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_region | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_salesregion | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_tax | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_taxcategory | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_uom | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_uom_conversion | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_validcombination | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_withholding | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_year | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_warehouse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_acctschema | updatedby | numeric | 10 | User who updated this records | |||
| c_activity | updatedby | numeric | 10 | User who updated this records | |||
| c_bank | updatedby | numeric | 10 | User who updated this records | |||
| c_bankaccount | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_bankaccount | updatedby | numeric | 10 | User who updated this records | |||
| c_bp_withholding | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner_location | updatedby | numeric | 10 | User who updated this records | |||
| c_calendar | updatedby | numeric | 10 | User who updated this records | |||
| c_campaign | updatedby | numeric | 10 | User who updated this records | |||
| c_channel | updatedby | numeric | 10 | User who updated this records | |||
| c_city | updatedby | numeric | 10 | User who updated this records | |||
| c_conversion_rate | updatedby | numeric | 10 | User who updated this records | |||
| c_country | updatedby | numeric | 10 | User who updated this records | |||
| c_countrygroup | updatedby | numeric | 10 | User who updated this records | |||
| c_countrygroupcountry | updatedby | numeric | 10 | User who updated this records | |||
| c_currency | updatedby | numeric | 10 | User who updated this records | |||
| c_docbasegroup | updatedby | numeric | 10 | User who updated this records | |||
| c_docbasegroupline | updatedby | numeric | 10 | User who updated this records | |||
| c_doctype | updatedby | numeric | 10 | User who updated this records | |||
| c_doctypecounter | updatedby | numeric | 10 | User who updated this records | |||
| c_dunning | updatedby | numeric | 10 | User who updated this records | |||
| c_element | updatedby | numeric | 10 | User who updated this records | |||
| c_elementvalue | updatedby | numeric | 10 | User who updated this records | |||
| c_location | updatedby | numeric | 10 | User who updated this records | |||
| c_nonbusinessday | updatedby | numeric | 10 | User who updated this records | |||
| c_paymentterm | updatedby | numeric | 10 | User who updated this records | |||
| c_period | updatedby | numeric | 10 | User who updated this records | |||
| c_periodcontrol | updatedby | numeric | 10 | User who updated this records | |||
| c_project | updatedby | numeric | 10 | User who updated this records | |||
| c_region | updatedby | numeric | 10 | User who updated this records | |||
| c_salesregion | updatedby | numeric | 10 | User who updated this records | |||
| c_tax | updatedby | numeric | 10 | User who updated this records | |||
| c_taxcategory | updatedby | numeric | 10 | User who updated this records | |||
| c_uom | updatedby | numeric | 10 | User who updated this records | |||
| c_uom_conversion | updatedby | numeric | 10 | User who updated this records | |||
| c_validcombination | updatedby | numeric | 10 | User who updated this records | |||
| c_withholding | updatedby | numeric | 10 | User who updated this records | |||
| c_year | updatedby | numeric | 10 | User who updated this records | |||
| m_product | updatedby | numeric | 10 | User who updated this records | |||
| m_warehouse | updatedby | numeric | 10 | User who updated this records | |||
| c_conversion_rate | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
| c_tax | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
| c_activity | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_bankaccount | value | varchar | 40 | NULL::character varying | Search key for the record in the format required - must be unique | ||
| c_bpartner | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_campaign | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_countrygroup | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_elementvalue | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_paymentterm | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_project | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_salesregion | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
| m_warehouse | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_uom | x12de355 | varchar | 4 | UOM EDI X12 Code |