SchemaSpy Analysis of idempiere11.adempiere - ColumnsAssets | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:46 +0100 |
| |||||
|
idempiere11.adempiere contains 1495 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
a_asset_acct | a_accumdepreciation_acct | numeric | 10 | Accumulated Depreciation Account | |||
a_asset_acct | a_asset_acct | numeric | 10 | Asset Acct | |||
a_asset_acct | a_asset_acct_id | numeric | 10 | A_Asset_Acct_ID | |||
a_asset_acct | a_asset_acct_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Acct_UU | |
a_asset_acct | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_acct | a_asset_spread_id | numeric | 10 | √ | null | A_Asset_Spread_ID | |
a_asset_acct | a_depreciation_acct | numeric | 10 | Depreciation Account | |||
a_asset_acct | a_depreciation_conv_f_id | numeric | 10 | √ | null | Depreciation Convention (fiscal) | |
a_asset_acct | a_depreciation_conv_id | numeric | 10 | √ | null | Convention Type | |
a_asset_acct | a_depreciation_f_id | numeric | 10 | Depreciation (fiscal) | |||
a_asset_acct | a_depreciation_id | numeric | 10 | Depreciation | |||
a_asset_acct | a_depreciation_manual_amount | numeric | 0 | √ | null | A_Depreciation_Manual_Amount | |
a_asset_acct | a_depreciation_manual_period | varchar | 2 | √ | null | A_Depreciation_Manual_Period | |
a_asset_acct | a_depreciation_method_f_id | numeric | 10 | √ | null | Depreciation Method (fiscal) | |
a_asset_acct | a_depreciation_method_id | numeric | 10 | √ | null | Depreciation Method | |
a_asset_acct | a_depreciation_table_header_id | numeric | 10 | √ | null | A_Depreciation_Table_Header_ID | |
a_asset_acct | a_depreciation_variable_perc | numeric | 0 | √ | null | Variable Percent | |
a_asset_acct | a_depreciation_variable_perc_f | numeric | 0 | √ | null | Variable Percent (fiscal) | |
a_asset_acct | a_disposal_gain | varchar | 10 | √ | null | Disposal Gain | |
a_asset_acct | a_disposal_gain_acct | numeric | 10 | √ | NULL::numeric | Disposal Gain Acct | |
a_asset_acct | a_disposal_loss | varchar | 40 | √ | null | Loss on Disposal | |
a_asset_acct | a_disposal_loss_acct | numeric | 10 | Disposal Loss Acct | |||
a_asset_acct | a_disposal_revenue | varchar | 40 | √ | null | Disposal Revenue | |
a_asset_acct | a_disposal_revenue_acct | numeric | 10 | Disposal Revenue Acct | |||
a_asset_acct | a_period_end | numeric | 10 | A_Period_End | |||
a_asset_acct | a_period_start | numeric | 10 | A_Period_Start | |||
a_asset_acct | a_reval_accumdep_offset_cur | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Current Year | |
a_asset_acct | a_reval_accumdep_offset_prior | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Prior Year | |
a_asset_acct | a_reval_adep_offset_cur_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Cur | |
a_asset_acct | a_reval_adep_offset_prior_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Prior | |
a_asset_acct | a_reval_cal_method | varchar | 3 | √ | null | A_Reval_Cal_Method | |
a_asset_acct | a_reval_cost_offset | varchar | 22 | √ | null | Revaluation Cost Offset for Current Year | |
a_asset_acct | a_reval_cost_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Acct | |
a_asset_acct | a_reval_cost_offset_prior | varchar | 22 | √ | null | Revaluation Cost Offset for Prior Year | |
a_asset_acct | a_reval_cost_offset_prior_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Prior Acct | |
a_asset_acct | a_reval_depexp_offset | varchar | 22 | √ | null | Revaluation Expense Offs | |
a_asset_acct | a_reval_depexp_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Depexp Offset Acct | |
a_asset_acct | a_salvage_value | numeric | 0 | √ | (0)::numeric | Asset Salvage Value | |
a_asset_acct | a_split_percent | numeric | 0 | (1)::numeric | Split Percent | ||
a_asset_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
a_asset_acct | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_acct | createdby | numeric | 10 | User who created this records | |||
a_asset_acct | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_acct | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_asset_acct | processing | bpchar | 1 | √ | 'Y'::bpchar | Process Now | |
a_asset_acct | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_acct | updatedby | numeric | 10 | User who updated this records | |||
a_asset_acct | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
a_asset_addition | a_accumulated_depr | numeric | 0 | (0)::numeric | Accumulated Depreciation | ||
a_asset_addition | a_accumulated_depr_adjust | bpchar | 1 | 'N'::bpchar | Adjust Accumulated Depreciation | ||
a_asset_addition | a_accumulated_depr_f | numeric | 0 | (0)::numeric | Accumulated Depreciation (fiscal) | ||
a_asset_addition | a_asset_addition_id | numeric | 10 | Asset Addition | |||
a_asset_addition | a_asset_addition_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Addition_UU | |
a_asset_addition | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_addition | a_capvsexp | varchar | 3 | 'Cap'::character varying | Capital/Expense | ||
a_asset_addition | a_createasset | bpchar | 1 | 'N'::bpchar | Create Asset | ||
a_asset_addition | a_period_start | numeric | 10 | (0)::numeric | A_Period_Start | ||
a_asset_addition | a_qty_current | numeric | 0 | (0)::numeric | Current Qty | ||
a_asset_addition | a_salvage_value | numeric | 0 | √ | null | Asset Salvage Value | |
a_asset_addition | a_sourcetype | varchar | 3 | 'INV'::character varying | Source Type | ||
a_asset_addition | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_addition | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_addition | assetamtentered | numeric | 0 | (0)::numeric | Entered Amount | ||
a_asset_addition | assetsourceamt | numeric | 0 | √ | null | Source Amount | |
a_asset_addition | assetvalueamt | numeric | 0 | Book Value of the asset | |||
a_asset_addition | c_charge_id | numeric | 10 | √ | NULL::numeric | Additional document charges | |
a_asset_addition | c_conversiontype_id | numeric | 10 | Currency Conversion Rate Type | |||
a_asset_addition | c_currency_id | numeric | 10 | The Currency for this record | |||
a_asset_addition | c_doctype_id | numeric | 10 | √ | NULL::numeric | Document type or rules | |
a_asset_addition | c_invoice_id | numeric | 10 | √ | null | Invoice Identifier | |
a_asset_addition | c_invoiceline_id | numeric | 10 | √ | null | Invoice Detail Line | |
a_asset_addition | c_project_id | numeric | 10 | √ | NULL::numeric | Financial Project | |
a_asset_addition | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_addition | createdby | numeric | 10 | User who created this records | |||
a_asset_addition | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
a_asset_addition | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
a_asset_addition | datedoc | timestamp | 29,6 | Date of the Document | |||
a_asset_addition | deltauselifeyears | numeric | 10 | (0)::numeric | Delta Use Life Years | ||
a_asset_addition | deltauselifeyears_f | numeric | 10 | (0)::numeric | Delta Use Life Years (fiscal) | ||
a_asset_addition | description | varchar | 510 | √ | null | Optional short description of the record | |
a_asset_addition | docaction | bpchar | 2 | √ | 'CO'::bpchar | The targeted status of the document | |
a_asset_addition | docstatus | varchar | 2 | 'DR'::character varying | The current status of the document | ||
a_asset_addition | documentno | varchar | 30 | √ | null | Document sequence number of the document | |
a_asset_addition | gl_journalbatch_id | numeric | 10 | √ | null | General Ledger Journal Batch | |
a_asset_addition | i_fixedasset_id | numeric | 10 | √ | NULL::numeric | Imported Fixed Asset | |
a_asset_addition | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_addition | isapproved | bpchar | 1 | Indicates if this document requires approval | |||
a_asset_addition | line | numeric | 10 | √ | null | Unique line for this document | |
a_asset_addition | m_attributesetinstance_id | numeric | 10 | √ | NULL::numeric | Product Attribute Set Instance | |
a_asset_addition | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
a_asset_addition | m_locator_id | numeric | 10 | √ | NULL::numeric | Warehouse Locator | |
a_asset_addition | m_matchinv_id | numeric | 10 | √ | NULL::numeric | Match Shipment/Receipt to Invoice | |
a_asset_addition | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
a_asset_addition | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
a_asset_addition | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_asset_addition | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_asset_addition | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
a_asset_addition | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
a_asset_addition | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_addition | updatedby | numeric | 10 | User who updated this records | |||
a_asset_change | a_accumdepreciation_acct | numeric | 10 | √ | null | Accumulated Depreciation Account | |
a_asset_change | a_asset_acct | numeric | 10 | √ | null | Asset Acct | |
a_asset_change | a_asset_acct_id | numeric | 10 | √ | null | A_Asset_Acct_ID | |
a_asset_change | a_asset_addition_id | numeric | 10 | √ | null | Asset Addition | |
a_asset_change | a_asset_change_id | numeric | 10 | A_Asset_Change_ID | |||
a_asset_change | a_asset_change_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Change_UU | |
a_asset_change | a_asset_createdate | timestamp | 29,6 | √ | null | Create Date | |
a_asset_change | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_change | a_asset_retirement_id | numeric | 10 | √ | null | Internally used asset is not longer used. | |
a_asset_change | a_asset_revaldate | timestamp | 29,6 | √ | null | Revaluation Date | |
a_asset_change | a_asset_spread_type | varchar | 10 | √ | null | Spread Type | |
a_asset_change | a_depreciation_acct | numeric | 10 | √ | null | Depreciation Account | |
a_asset_change | a_depreciation_calc_type | varchar | 10 | √ | null | Calculation Type | |
a_asset_change | a_depreciation_manual_amount | numeric | 0 | √ | null | A_Depreciation_Manual_Amount | |
a_asset_change | a_depreciation_manual_period | varchar | 2 | √ | null | A_Depreciation_Manual_Period | |
a_asset_change | a_depreciation_table_header_id | numeric | 10 | √ | null | A_Depreciation_Table_Header_ID | |
a_asset_change | a_depreciation_variable_perc | numeric | 0 | √ | null | Variable Percent | |
a_asset_change | a_disposal_loss | varchar | 22 | √ | null | Loss on Disposal | |
a_asset_change | a_disposal_loss_acct | numeric | 10 | √ | NULL::numeric | Disposal Loss Acct | |
a_asset_change | a_disposal_revenue | varchar | 22 | √ | null | Disposal Revenue | |
a_asset_change | a_disposal_revenue_acct | numeric | 10 | √ | NULL::numeric | Disposal Revenue Acct | |
a_asset_change | a_parent_asset_id | numeric | 10 | √ | null | Parent Asset | |
a_asset_change | a_period_end | numeric | 10 | √ | null | A_Period_End | |
a_asset_change | a_period_start | numeric | 10 | √ | null | A_Period_Start | |
a_asset_change | a_qty_current | numeric | 0 | √ | null | Current Qty | |
a_asset_change | a_qty_original | numeric | 0 | √ | null | A_QTY_Original | |
a_asset_change | a_reval_accumdep_offset_cur | numeric | 10 | √ | null | Revaluation Accumulated Depreciation Offset for Current Year | |
a_asset_change | a_reval_accumdep_offset_prior | numeric | 10 | √ | null | Revaluation Accumulated Depreciation Offset for Prior Year | |
a_asset_change | a_reval_adep_offset_cur_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Cur | |
a_asset_change | a_reval_adep_offset_prior_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Prior | |
a_asset_change | a_reval_cal_method | varchar | 3 | √ | null | A_Reval_Cal_Method | |
a_asset_change | a_reval_cost_offset | numeric | 10 | √ | null | Revaluation Cost Offset for Current Year | |
a_asset_change | a_reval_cost_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Acct | |
a_asset_change | a_reval_cost_offset_prior | numeric | 10 | √ | null | Revaluation Cost Offset for Prior Year | |
a_asset_change | a_reval_cost_offset_prior_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Prior Acct | |
a_asset_change | a_reval_depexp_offset | numeric | 10 | √ | null | Revaluation Expense Offs | |
a_asset_change | a_reval_depexp_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Depexp Offset Acct | |
a_asset_change | a_salvage_value | numeric | 0 | √ | null | Asset Salvage Value | |
a_asset_change | a_split_percent | numeric | 0 | √ | (1)::numeric | Split Percent | |
a_asset_change | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_change | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_change | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
a_asset_change | assetaccumdepreciationamt | numeric | 0 | √ | null | Asset Accum Depreciation Amt | |
a_asset_change | assetbookvalueamt | numeric | 0 | √ | null | Asset Book Value Amt | |
a_asset_change | assetdepreciationdate | timestamp | 29,6 | √ | null | Date of last depreciation | |
a_asset_change | assetdisposaldate | timestamp | 29,6 | √ | null | Date when the asset is/was disposed | |
a_asset_change | assetmarketvalueamt | numeric | 0 | √ | null | Market value of the asset | |
a_asset_change | assetservicedate | timestamp | 29,6 | √ | null | Date when Asset was put into service | |
a_asset_change | assetvalueamt | numeric | 0 | (0)::numeric | Book Value of the asset | ||
a_asset_change | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
a_asset_change | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
a_asset_change | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
a_asset_change | c_location_id | numeric | 10 | √ | null | Location or Address | |
a_asset_change | c_validcombination_id | numeric | 10 | √ | null | Valid Account Combination | |
a_asset_change | changeamt | numeric | 0 | √ | null | Change Amt | |
a_asset_change | changedate | timestamp | 29,6 | √ | null | Change Date | |
a_asset_change | changetype | varchar | 3 | Change Type | |||
a_asset_change | conventiontype | varchar | 10 | √ | null | Convention Type | |
a_asset_change | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_change | createdby | numeric | 10 | User who created this records | |||
a_asset_change | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
a_asset_change | depreciationtype | varchar | 10 | √ | null | Depreciation Type | |
a_asset_change | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_change | isdepreciated | bpchar | 1 | √ | null | The asset will be depreciated | |
a_asset_change | isdisposed | bpchar | 1 | √ | null | The asset is disposed | |
a_asset_change | isfullydepreciated | bpchar | 1 | √ | null | The asset is fully depreciated | |
a_asset_change | isinposession | bpchar | 1 | √ | null | The asset is in the possession of the organization | |
a_asset_change | isowned | bpchar | 1 | √ | null | The asset is owned by the organization | |
a_asset_change | lifeuseunits | numeric | 10 | √ | null | Units of use until the asset is not usable anymore | |
a_asset_change | lot | varchar | 40 | √ | null | Lot number (alphanumeric) | |
a_asset_change | postingtype | varchar | 10 | √ | 'A'::character varying | The type of posted amount for the transaction | |
a_asset_change | serno | varchar | 40 | √ | null | Product Serial Number | |
a_asset_change | textdetails | varchar | 60 | Details | |||
a_asset_change | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_change | updatedby | numeric | 10 | User who updated this records | |||
a_asset_change | uselifemonths | numeric | 10 | √ | null | Months of the usable life of the asset | |
a_asset_change | uselifeyears | numeric | 0 | √ | null | Years of the usable life of the asset | |
a_asset_change | useunits | numeric | 10 | √ | null | Currently used units of the assets | |
a_asset_change | versionno | varchar | 40 | √ | null | Version Number | |
a_asset_change_amt | a_asset_change_id | numeric | 10 | ||||
a_asset_change_amt | ad_client_id | numeric | 10 | ||||
a_asset_change_amt | ad_org_id | numeric | 10 | ||||
a_asset_change_amt | assetaccumdepreciationamt | numeric | 0 | 0 | |||
a_asset_change_amt | assetbookvalueamt | numeric | 0 | 0 | |||
a_asset_change_amt | assetmarketvalueamt | numeric | 0 | 0 | |||
a_asset_change_amt | assetvalueamt | numeric | 0 | 0 | |||
a_asset_change_amt | c_acctschema_id | numeric | 10 | ||||
a_asset_change_amt | created | timestamp | 29,6 | now() | |||
a_asset_change_amt | createdby | numeric | 10 | ||||
a_asset_change_amt | isactive | bpchar | 1 | 'Y'::bpchar | |||
a_asset_change_amt | updated | timestamp | 29,6 | now() | |||
a_asset_change_amt | updatedby | numeric | 10 | ||||
a_asset_class | a_asset_class_id | numeric | 10 | Asset class | |||
a_asset_class | a_asset_class_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Class_UU | |
a_asset_class | a_life_period_2004 | numeric | 10 | √ | NULL::numeric | Life Periods 2004 (min) | |
a_asset_class | a_life_period_max | numeric | 10 | Life periods (max) | |||
a_asset_class | a_life_period_min | numeric | 10 | Life periods (min) | |||
a_asset_class | a_value_2004 | varchar | 40 | √ | NULL::character varying | Value 2004 | |
a_asset_class | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_class | ad_org_id | numeric | 10 | √ | NULL::numeric | Organizational entity within tenant | |
a_asset_class | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_class | createdby | numeric | 10 | User who created this records | |||
a_asset_class | description | varchar | 2000 | √ | null | Optional short description of the record | |
a_asset_class | isactive | bpchar | 1 | √ | NULL::bpchar | The record is active in the system | |
a_asset_class | mfx_clasa | numeric | 10 | √ | NULL::numeric | Fixed Asset Class | |
a_asset_class | mfx_grupa | numeric | 10 | √ | NULL::numeric | Fixed Asset Group | |
a_asset_class | mfx_subclasa | numeric | 10 | √ | NULL::numeric | Fixed Asset Subclass | |
a_asset_class | mfx_subgrupa | numeric | 10 | √ | NULL::numeric | Fixed Asset Subgroup | |
a_asset_class | name | varchar | 2000 | Alphanumeric identifier of the entity | |||
a_asset_class | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_class | updatedby | numeric | 10 | User who updated this records | |||
a_asset_class | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
a_asset_delivery | a_asset_delivery_id | numeric | 10 | Delivery of Asset | |||
a_asset_delivery | a_asset_delivery_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Delivery_UU | |
a_asset_delivery | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_delivery | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_delivery | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_delivery | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
a_asset_delivery | created | timestamp | 29,6 | now() | Date this record was created | ||
a_asset_delivery | createdby | numeric | 10 | User who created this records | |||
a_asset_delivery | deliveryconfirmation | varchar | 120 | √ | null | EMail Delivery confirmation | |
a_asset_delivery | description | varchar | 255 | √ | null | Optional short description of the record | |
a_asset_delivery | varchar | 60 | √ | null | Electronic Mail Address | ||
a_asset_delivery | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_delivery | lot | varchar | 40 | √ | null | Lot number (alphanumeric) | |
a_asset_delivery | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
a_asset_delivery | m_productdownload_id | numeric | 10 | √ | null | Product downloads | |
a_asset_delivery | messageid | varchar | 120 | √ | null | EMail Message ID | |
a_asset_delivery | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
a_asset_delivery | referrer | varchar | 255 | √ | null | Referring web address | |
a_asset_delivery | remote_addr | varchar | 60 | √ | null | Remote Address | |
a_asset_delivery | remote_host | varchar | 60 | √ | null | Remote host Info | |
a_asset_delivery | serno | varchar | 40 | √ | null | Product Serial Number | |
a_asset_delivery | updated | timestamp | 29,6 | now() | Date this record was updated | ||
a_asset_delivery | updatedby | numeric | 10 | User who updated this records | |||
a_asset_delivery | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
a_asset_delivery | versionno | varchar | 20 | √ | null | Version Number | |
a_asset_disposed | a_accumulated_depr | numeric | 0 | (0)::numeric | Accumulated Depreciation | ||
a_asset_disposed | a_accumulated_depr_delta | numeric | 0 | (0)::numeric | Accumulated Depreciation (delta) | ||
a_asset_disposed | a_activation_method | varchar | 2 | 'AA'::character varying | Activation Method | ||
a_asset_disposed | a_asset_cost | numeric | 0 | √ | null | Asset Cost | |
a_asset_disposed | a_asset_disposed_id | numeric | 10 | Asset Disposed | |||
a_asset_disposed | a_asset_disposed_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Disposed_UU | |
a_asset_disposed | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_disposed | a_asset_status | varchar | 2 | √ | NULL::character varying | Asset Status | |
a_asset_disposed | a_asset_trade_id | numeric | 10 | √ | null | Asset Trade | |
a_asset_disposed | a_disposal_amt | numeric | 0 | (0)::numeric | Disposal Amount | ||
a_asset_disposed | a_disposed_date | timestamp | 29,6 | Disposed Date | |||
a_asset_disposed | a_disposed_method | varchar | 2 | Disposed Method | |||
a_asset_disposed | a_disposed_reason | varchar | 10 | √ | null | Disposed Reason | |
a_asset_disposed | a_proceeds | numeric | 0 | √ | null | Asset Proceeds | |
a_asset_disposed | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_disposed | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_disposed | c_doctype_id | numeric | 10 | √ | NULL::numeric | Document type or rules | |
a_asset_disposed | c_invoice_id | numeric | 10 | √ | NULL::numeric | Invoice Identifier | |
a_asset_disposed | c_invoiceline_id | numeric | 10 | √ | NULL::numeric | Invoice Detail Line | |
a_asset_disposed | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
a_asset_disposed | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_disposed | createdby | numeric | 10 | User who created this records | |||
a_asset_disposed | dateacct | timestamp | 29,6 | Accounting Date | |||
a_asset_disposed | datedoc | timestamp | 29,6 | Date of the Document | |||
a_asset_disposed | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
a_asset_disposed | docaction | bpchar | 2 | √ | 'CO'::bpchar | The targeted status of the document | |
a_asset_disposed | docstatus | varchar | 2 | √ | 'DR'::character varying | The current status of the document | |
a_asset_disposed | documentno | varchar | 30 | Document sequence number of the document | |||
a_asset_disposed | expense | numeric | 0 | (0)::numeric | Expense | ||
a_asset_disposed | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_disposed | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
a_asset_disposed | isdisposed | bpchar | 1 | √ | NULL::bpchar | The asset is disposed | |
a_asset_disposed | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
a_asset_disposed | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_asset_disposed | processed | bpchar | 1 | The document has been processed | |||
a_asset_disposed | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
a_asset_disposed | processing | bpchar | 1 | Process Now | |||
a_asset_disposed | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_disposed | updatedby | numeric | 10 | User who updated this records | |||
a_asset_group | a_asset_class_id | numeric | 10 | √ | NULL::numeric | Asset class | |
a_asset_group | a_asset_group_id | numeric | 10 | Group of Assets | |||
a_asset_group | a_asset_group_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Group_UU | |
a_asset_group | a_asset_type_id | numeric | 10 | √ | null | Asset Type | |
a_asset_group | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_group | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_group | created | timestamp | 29,6 | now() | Date this record was created | ||
a_asset_group | createdby | numeric | 10 | User who created this records | |||
a_asset_group | description | varchar | 255 | √ | null | Optional short description of the record | |
a_asset_group | help | varchar | 2000 | √ | null | Comment or Hint | |
a_asset_group | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_group | iscreateasactive | bpchar | 1 | 'Y'::bpchar | Create Asset and activate it | ||
a_asset_group | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
a_asset_group | isdepreciated | bpchar | 1 | 'Y'::bpchar | The asset will be depreciated | ||
a_asset_group | isfixedasset | bpchar | 1 | √ | 'Y'::bpchar | Is Fixed Asset | |
a_asset_group | isoneassetperuom | bpchar | 1 | 'N'::bpchar | Create one asset per UOM | ||
a_asset_group | isowned | bpchar | 1 | 'Y'::bpchar | The asset is owned by the organization | ||
a_asset_group | istrackissues | bpchar | 1 | 'N'::bpchar | Enable tracking issues for this asset | ||
a_asset_group | name | varchar | 60 | Alphanumeric identifier of the entity | |||
a_asset_group | updated | timestamp | 29,6 | now() | Date this record was updated | ||
a_asset_group | updatedby | numeric | 10 | User who updated this records | |||
a_asset_group_acct | a_accumdepreciation_acct | numeric | 10 | Accumulated Depreciation Account | |||
a_asset_group_acct | a_asset_acct | numeric | 10 | Asset Acct | |||
a_asset_group_acct | a_asset_group_acct_id | numeric | 10 | Asset Group Accounting | |||
a_asset_group_acct | a_asset_group_acct_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Group_Acct_UU | |
a_asset_group_acct | a_asset_group_id | numeric | 10 | Group of Assets | |||
a_asset_group_acct | a_asset_spread_type | varchar | 10 | √ | null | Spread Type | |
a_asset_group_acct | a_depreciation_acct | numeric | 10 | Depreciation Account | |||
a_asset_group_acct | a_depreciation_calc_type | varchar | 10 | √ | null | Calculation Type | |
a_asset_group_acct | a_depreciation_conv_f_id | numeric | 10 | √ | null | Depreciation Convention (fiscal) | |
a_asset_group_acct | a_depreciation_conv_id | numeric | 10 | √ | null | Convention Type | |
a_asset_group_acct | a_depreciation_f_id | numeric | 10 | Depreciation (fiscal) | |||
a_asset_group_acct | a_depreciation_id | numeric | 10 | Depreciation | |||
a_asset_group_acct | a_depreciation_manual_amount | numeric | 0 | √ | null | A_Depreciation_Manual_Amount | |
a_asset_group_acct | a_depreciation_manual_period | varchar | 2 | √ | null | A_Depreciation_Manual_Period | |
a_asset_group_acct | a_depreciation_method_f_id | numeric | 10 | √ | null | Depreciation Method (fiscal) | |
a_asset_group_acct | a_depreciation_method_id | numeric | 10 | √ | null | Depreciation Method | |
a_asset_group_acct | a_depreciation_table_header_id | numeric | 10 | √ | null | A_Depreciation_Table_Header_ID | |
a_asset_group_acct | a_depreciation_variable_perc | numeric | 0 | √ | null | Variable Percent | |
a_asset_group_acct | a_depreciation_variable_perc_f | numeric | 0 | √ | null | Variable Percent (fiscal) | |
a_asset_group_acct | a_disposal_gain | varchar | 10 | √ | null | Disposal Gain | |
a_asset_group_acct | a_disposal_gain_acct | numeric | 10 | √ | NULL::numeric | Disposal Gain Acct | |
a_asset_group_acct | a_disposal_loss | varchar | 22 | √ | null | Loss on Disposal | |
a_asset_group_acct | a_disposal_loss_acct | numeric | 10 | √ | NULL::numeric | Disposal Loss Acct | |
a_asset_group_acct | a_disposal_revenue | varchar | 22 | √ | null | Disposal Revenue | |
a_asset_group_acct | a_disposal_revenue_acct | numeric | 10 | √ | NULL::numeric | Disposal Revenue Acct | |
a_asset_group_acct | a_reval_accumdep_offset_cur | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Current Year | |
a_asset_group_acct | a_reval_accumdep_offset_prior | varchar | 22 | √ | null | Revaluation Accumulated Depreciation Offset for Prior Year | |
a_asset_group_acct | a_reval_adep_offset_cur_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Cur | |
a_asset_group_acct | a_reval_adep_offset_prior_acct | numeric | 10 | √ | NULL::numeric | A_Reval_Accumdep_Offset_Prior | |
a_asset_group_acct | a_reval_cal_method | varchar | 22 | √ | null | A_Reval_Cal_Method | |
a_asset_group_acct | a_reval_cost_offset | varchar | 22 | √ | null | Revaluation Cost Offset for Current Year | |
a_asset_group_acct | a_reval_cost_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Acct | |
a_asset_group_acct | a_reval_cost_offset_prior | varchar | 22 | √ | null | Revaluation Cost Offset for Prior Year | |
a_asset_group_acct | a_reval_cost_offset_prior_acct | numeric | 10 | √ | NULL::numeric | Reval Cost Offset Prior Acct | |
a_asset_group_acct | a_reval_depexp_offset | varchar | 22 | √ | null | Revaluation Expense Offs | |
a_asset_group_acct | a_reval_depexp_offset_acct | numeric | 10 | √ | NULL::numeric | Reval Depexp Offset Acct | |
a_asset_group_acct | a_split_percent | numeric | 0 | (1)::numeric | Split Percent | ||
a_asset_group_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_group_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_group_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
a_asset_group_acct | conventiontype | varchar | 10 | √ | null | Convention Type | |
a_asset_group_acct | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_group_acct | createdby | numeric | 10 | √ | null | User who created this records | |
a_asset_group_acct | depreciationtype | varchar | 10 | √ | null | Depreciation Type | |
a_asset_group_acct | isactive | bpchar | 1 | √ | null | The record is active in the system | |
a_asset_group_acct | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_asset_group_acct | processing | bpchar | 1 | √ | null | Process Now | |
a_asset_group_acct | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_group_acct | updatedby | numeric | 10 | √ | null | User who updated this records | |
a_asset_group_acct | uselifemonths | numeric | 10 | √ | (0)::numeric | Months of the usable life of the asset | |
a_asset_group_acct | uselifemonths_f | numeric | 10 | (0)::numeric | Use Life - Months (fiscal) | ||
a_asset_group_acct | uselifeyears | numeric | 0 | √ | null | Years of the usable life of the asset | |
a_asset_group_acct | uselifeyears_f | numeric | 0 | '0'::numeric | Use Life - Years (fiscal) | ||
a_asset_group_trl | a_asset_group_id | numeric | 10 | Group of Assets | |||
a_asset_group_trl | a_asset_group_trl_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Group_Trl_UU | |
a_asset_group_trl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_group_trl | ad_language | varchar | 6 | Language for this entity | |||
a_asset_group_trl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_group_trl | created | timestamp | 29,6 | Date this record was created | |||
a_asset_group_trl | createdby | numeric | 10 | User who created this records | |||
a_asset_group_trl | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
a_asset_group_trl | help | varchar | 2000 | √ | NULL::character varying | Comment or Hint | |
a_asset_group_trl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_group_trl | istranslated | bpchar | 1 | 'N'::bpchar | This column is translated | ||
a_asset_group_trl | name | varchar | 60 | Alphanumeric identifier of the entity | |||
a_asset_group_trl | updated | timestamp | 29,6 | Date this record was updated | |||
a_asset_group_trl | updatedby | numeric | 10 | User who updated this records | |||
a_asset_info_fin | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_info_fin | a_asset_info_fin_id | numeric | 10 | Asset Info Financial ID | |||
a_asset_info_fin | a_asset_info_fin_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Info_Fin_UU | |
a_asset_info_fin | a_contract_date | timestamp | 29,6 | √ | null | Contract Date | |
a_asset_info_fin | a_due_on | varchar | 22 | √ | null | Asset Due On | |
a_asset_info_fin | a_expired_date | timestamp | 29,6 | √ | null | Asset Expired Date | |
a_asset_info_fin | a_finance_meth | varchar | 2 | √ | null | Asset Finance Method | |
a_asset_info_fin | a_monthly_payment | numeric | 0 | √ | null | Asset Monthly Payment | |
a_asset_info_fin | a_purchase_option | bpchar | 1 | √ | null | Purchase Option | |
a_asset_info_fin | a_purchase_option_credit | numeric | 10 | √ | null | Purchase Option Credit | |
a_asset_info_fin | a_purchase_option_credit_per | numeric | 0 | √ | null | Purchase Option Credit % | |
a_asset_info_fin | a_purchase_price | numeric | 0 | √ | null | Purchase Price | |
a_asset_info_fin | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_info_fin | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_info_fin | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
a_asset_info_fin | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_info_fin | createdby | numeric | 10 | User who created this records | |||
a_asset_info_fin | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_info_fin | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
a_asset_info_fin | textmsg | varchar | 510 | √ | null | Text Message | |
a_asset_info_fin | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_info_fin | updatedby | numeric | 10 | User who updated this records | |||
a_asset_info_ins | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_info_ins | a_asset_info_ins_id | numeric | 10 | A_Asset_Info_Ins_ID | |||
a_asset_info_ins | a_asset_info_ins_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Info_Ins_UU | |
a_asset_info_ins | a_ins_premium | numeric | 0 | √ | null | Asset Insurance Premium | |
a_asset_info_ins | a_ins_value | numeric | 0 | √ | null | Asset Insurance Value | |
a_asset_info_ins | a_insurance_co | varchar | 22 | √ | null | Insurance Company | |
a_asset_info_ins | a_policy_no | varchar | 100 | √ | null | Asset Policy No | |
a_asset_info_ins | a_renewal_date | timestamp | 29,6 | √ | null | Asset Renewal Date | |
a_asset_info_ins | a_replace_cost | numeric | 0 | √ | null | Asset Replace Cost | |
a_asset_info_ins | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_info_ins | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_info_ins | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_info_ins | createdby | numeric | 10 | User who created this records | |||
a_asset_info_ins | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_info_ins | text | varchar | 510 | √ | null | Description | |
a_asset_info_ins | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_info_ins | updatedby | numeric | 10 | User who updated this records | |||
a_asset_info_lic | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_info_lic | a_asset_info_lic_id | numeric | 10 | A_Asset_Info_Lic_ID | |||
a_asset_info_lic | a_asset_info_lic_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Info_Lic_UU | |
a_asset_info_lic | a_issuing_agency | varchar | 22 | √ | null | Issuing Agency | |
a_asset_info_lic | a_license_fee | numeric | 0 | √ | null | Asset License Fee | |
a_asset_info_lic | a_license_no | varchar | 120 | √ | null | Asset License No | |
a_asset_info_lic | a_renewal_date | timestamp | 29,6 | √ | null | Asset Renewal Date | |
a_asset_info_lic | a_state | varchar | 60 | √ | null | State of the Credit Card or Account holder | |
a_asset_info_lic | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_info_lic | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_info_lic | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_info_lic | createdby | numeric | 10 | User who created this records | |||
a_asset_info_lic | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_info_lic | processed | bpchar | 1 | √ | 'N'::bpchar | The document has been processed | |
a_asset_info_lic | text | varchar | 510 | √ | null | Description | |
a_asset_info_lic | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_info_lic | updatedby | numeric | 10 | User who updated this records | |||
a_asset_info_oth | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_info_oth | a_asset_info_oth_id | numeric | 10 | A_Asset_Info_Oth_ID | |||
a_asset_info_oth | a_asset_info_oth_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Info_Oth_UU | |
a_asset_info_oth | a_user1 | varchar | 3 | √ | null | A_User1 | |
a_asset_info_oth | a_user10 | varchar | 3 | √ | null | A_User10 | |
a_asset_info_oth | a_user11 | varchar | 10 | √ | null | A_User11 | |
a_asset_info_oth | a_user12 | varchar | 10 | √ | null | A_User12 | |
a_asset_info_oth | a_user13 | varchar | 10 | √ | null | A_User13 | |
a_asset_info_oth | a_user14 | varchar | 10 | √ | null | A_User14 | |
a_asset_info_oth | a_user15 | varchar | 10 | √ | null | A_User15 | |
a_asset_info_oth | a_user2 | varchar | 3 | √ | null | A_User2 | |
a_asset_info_oth | a_user3 | varchar | 3 | √ | null | A_User3 | |
a_asset_info_oth | a_user4 | varchar | 3 | √ | null | A_User4 | |
a_asset_info_oth | a_user5 | varchar | 3 | √ | null | A_User5 | |
a_asset_info_oth | a_user6 | varchar | 3 | √ | null | A_User6 | |
a_asset_info_oth | a_user7 | varchar | 3 | √ | null | A_User7 | |
a_asset_info_oth | a_user8 | varchar | 3 | √ | null | A_User8 | |
a_asset_info_oth | a_user9 | varchar | 3 | √ | null | A_User9 | |
a_asset_info_oth | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_info_oth | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_info_oth | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_info_oth | createdby | numeric | 10 | User who created this records | |||
a_asset_info_oth | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_info_oth | text | varchar | 510 | √ | null | Description | |
a_asset_info_oth | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_info_oth | updatedby | numeric | 10 | User who updated this records | |||
a_asset_info_tax | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_info_tax | a_asset_info_tax_id | numeric | 10 | Asset Info Tax | |||
a_asset_info_tax | a_asset_info_tax_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Info_Tax_UU | |
a_asset_info_tax | a_finance_meth | varchar | 2 | √ | null | Asset Finance Method | |
a_asset_info_tax | a_investment_cr | numeric | 10 | √ | null | Asset Investment CR | |
a_asset_info_tax | a_new_used | bpchar | 1 | √ | null | Asset New Used | |
a_asset_info_tax | a_state | varchar | 60 | √ | null | State of the Credit Card or Account holder | |
a_asset_info_tax | a_tax_entity | varchar | 22 | √ | null | Asset Tax Entity | |
a_asset_info_tax | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_info_tax | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_info_tax | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_info_tax | createdby | numeric | 10 | User who created this records | |||
a_asset_info_tax | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_info_tax | textmsg | varchar | 510 | √ | null | Text Message | |
a_asset_info_tax | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_info_tax | updatedby | numeric | 10 | User who updated this records | |||
a_asset_product | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_product | a_asset_product_id | numeric | 10 | Asset Product | |||
a_asset_product | a_asset_product_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Product_UU | |
a_asset_product | a_qty_current | numeric | 0 | (0)::numeric | Current Qty | ||
a_asset_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_product | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_product | createdby | numeric | 10 | User who created this records | |||
a_asset_product | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
a_asset_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_product | m_attributesetinstance_id | numeric | 10 | Product Attribute Set Instance | |||
a_asset_product | m_locator_id | numeric | 10 | √ | NULL::numeric | Warehouse Locator | |
a_asset_product | m_product_id | numeric | 10 | Product, Service, Item | |||
a_asset_product | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_product | updatedby | numeric | 10 | User who updated this records | |||
a_asset_retirement | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_retirement | a_asset_retirement_id | numeric | 10 | Internally used asset is not longer used. | |||
a_asset_retirement | a_asset_retirement_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Retirement_UU | |
a_asset_retirement | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_retirement | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_retirement | assetmarketvalueamt | numeric | 0 | 0 | Market value of the asset | ||
a_asset_retirement | assetvalueamt | numeric | 0 | 0 | Book Value of the asset | ||
a_asset_retirement | c_invoiceline_id | numeric | 10 | √ | null | Invoice Detail Line | |
a_asset_retirement | created | timestamp | 29,6 | now() | Date this record was created | ||
a_asset_retirement | createdby | numeric | 10 | User who created this records | |||
a_asset_retirement | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_retirement | updated | timestamp | 29,6 | now() | Date this record was updated | ||
a_asset_retirement | updatedby | numeric | 10 | User who updated this records | |||
a_asset_reval | a_accumulated_depr | numeric | 0 | √ | null | Accumulated Depreciation | |
a_asset_reval | a_asset_cost | numeric | 0 | √ | null | Asset Cost | |
a_asset_reval | a_asset_cost_change | numeric | 0 | (0)::numeric | Asset Cost Change | ||
a_asset_reval | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_reval | a_asset_reval_id | numeric | 10 | Asset Revaluation | |||
a_asset_reval | a_asset_reval_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Reval_UU | |
a_asset_reval | a_change_acumulated_depr | numeric | 0 | (0)::numeric | Change Accumulated Depreciation | ||
a_asset_reval | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_reval | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_reval | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_reval | createdby | numeric | 10 | User who created this records | |||
a_asset_reval | dateacct | timestamp | 29,6 | Accounting Date | |||
a_asset_reval | datedoc | timestamp | 29,6 | √ | null | Date of the Document | |
a_asset_reval | docaction | bpchar | 2 | 'CO'::bpchar | The targeted status of the document | ||
a_asset_reval | docstatus | varchar | 2 | 'DR'::character varying | The current status of the document | ||
a_asset_reval | documentno | varchar | 30 | √ | NULL::character varying | Document sequence number of the document | |
a_asset_reval | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_reval | posted | bpchar | 1 | √ | NULL::bpchar | Posting status | |
a_asset_reval | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_asset_reval | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_asset_reval | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
a_asset_reval | processing | bpchar | 1 | 'N'::bpchar | Process Now | ||
a_asset_reval | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_reval | updatedby | numeric | 10 | User who updated this records | |||
a_asset_reval_entry | a_asset_reval_entry_id | numeric | 10 | Asset Reval. Entry | |||
a_asset_reval_entry | a_asset_reval_entry_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Reval_Entry_UU | |
a_asset_reval_entry | a_effective_date | timestamp | 29,6 | Effective Date | |||
a_asset_reval_entry | a_rev_code | varchar | 3 | Rev. Code | |||
a_asset_reval_entry | a_reval_cal_method | varchar | 3 | A_Reval_Cal_Method | |||
a_asset_reval_entry | a_reval_effective_date | varchar | 2 | Reval. Effective Date | |||
a_asset_reval_entry | a_reval_multiplier | varchar | 3 | Reval. Multiplier | |||
a_asset_reval_entry | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_reval_entry | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_reval_entry | c_acctschema_id | numeric | 10 | √ | null | Rules for accounting | |
a_asset_reval_entry | c_currency_id | numeric | 10 | The Currency for this record | |||
a_asset_reval_entry | c_doctype_id | numeric | 10 | √ | null | Document type or rules | |
a_asset_reval_entry | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
a_asset_reval_entry | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_reval_entry | createdby | numeric | 10 | User who created this records | |||
a_asset_reval_entry | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
a_asset_reval_entry | datedoc | timestamp | 29,6 | √ | null | Date of the Document | |
a_asset_reval_entry | description | varchar | 510 | Optional short description of the record | |||
a_asset_reval_entry | documentno | varchar | 60 | Document sequence number of the document | |||
a_asset_reval_entry | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
a_asset_reval_entry | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_reval_entry | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
a_asset_reval_entry | processed | bpchar | 1 | The document has been processed | |||
a_asset_reval_entry | processing | bpchar | 1 | Process Now | |||
a_asset_reval_entry | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_reval_entry | updatedby | numeric | 10 | User who updated this records | |||
a_asset_reval_index | a_asset_reval_index_id | numeric | 10 | Asset Reval Index | |||
a_asset_reval_index | a_asset_reval_index_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Reval_Index_UU | |
a_asset_reval_index | a_effective_date | timestamp | 29,6 | Effective Date | |||
a_asset_reval_index | a_reval_code | varchar | 3 | Reval. Code | |||
a_asset_reval_index | a_reval_multiplier | varchar | 3 | Reval. Multiplier | |||
a_asset_reval_index | a_reval_rate | numeric | 0 | Reval. Rate | |||
a_asset_reval_index | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_reval_index | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_reval_index | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_reval_index | createdby | numeric | 10 | User who created this records | |||
a_asset_reval_index | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_reval_index | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_reval_index | updatedby | numeric | 10 | User who updated this records | |||
a_asset_split | a_amount_split | numeric | 0 | √ | null | Amount Split | |
a_asset_split | a_asset_acct_id | numeric | 10 | A_Asset_Acct_ID | |||
a_asset_split | a_asset_cost | numeric | 0 | √ | null | Asset Cost | |
a_asset_split | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_split | a_asset_id_to | numeric | 10 | √ | null | To Asset ID | |
a_asset_split | a_asset_split_id | numeric | 10 | Asset Split | |||
a_asset_split | a_asset_split_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Split_UU | |
a_asset_split | a_depreciation_workfile_id | numeric | 10 | A_Depreciation_Workfile_ID | |||
a_asset_split | a_percent_original | numeric | 0 | √ | null | Original Percent | |
a_asset_split | a_percent_split | numeric | 0 | √ | null | A_Percent_Split | |
a_asset_split | a_qty_current | numeric | 0 | Current Qty | |||
a_asset_split | a_qty_split | numeric | 0 | √ | null | Qty. Split | |
a_asset_split | a_split_type | varchar | 3 | Split Type | |||
a_asset_split | a_transfer_balance_is | bpchar | 1 | A_Transfer_Balance_IS | |||
a_asset_split | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_split | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_split | c_period_id | numeric | 10 | Period of the Calendar | |||
a_asset_split | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_split | createdby | numeric | 10 | User who created this records | |||
a_asset_split | dateacct | timestamp | 29,6 | Accounting Date | |||
a_asset_split | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_split | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
a_asset_split | processed | bpchar | 1 | The document has been processed | |||
a_asset_split | processing | bpchar | 1 | Process Now | |||
a_asset_split | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_split | updatedby | numeric | 10 | User who updated this records | |||
a_asset_spread | a_asset_spread_id | numeric | 10 | A_Asset_Spread_ID | |||
a_asset_spread | a_asset_spread_type | varchar | 20 | √ | null | Spread Type | |
a_asset_spread | a_asset_spread_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Spread_UU | |
a_asset_spread | a_period_1 | numeric | 0 | Period 1 | |||
a_asset_spread | a_period_10 | numeric | 0 | Period 10 | |||
a_asset_spread | a_period_11 | numeric | 0 | Period 11 | |||
a_asset_spread | a_period_12 | numeric | 0 | Period 12 | |||
a_asset_spread | a_period_13 | numeric | 0 | Period 13 | |||
a_asset_spread | a_period_14 | numeric | 0 | Period 14 | |||
a_asset_spread | a_period_2 | numeric | 0 | Period 2 | |||
a_asset_spread | a_period_3 | numeric | 0 | Period 3 | |||
a_asset_spread | a_period_4 | numeric | 0 | Period 4 | |||
a_asset_spread | a_period_5 | numeric | 0 | Period 5 | |||
a_asset_spread | a_period_6 | numeric | 0 | Period 6 | |||
a_asset_spread | a_period_7 | numeric | 0 | Period 7 | |||
a_asset_spread | a_period_8 | numeric | 0 | Period 8 | |||
a_asset_spread | a_period_9 | numeric | 0 | Period 9 | |||
a_asset_spread | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_spread | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_spread | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_spread | createdby | numeric | 10 | User who created this records | |||
a_asset_spread | description | varchar | 255 | √ | null | Optional short description of the record | |
a_asset_spread | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_spread | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_spread | updatedby | numeric | 10 | User who updated this records | |||
a_asset_transfer | a_accumdepreciation_acct | numeric | 10 | √ | null | Accumulated Depreciation Account | |
a_asset_transfer | a_accumdepreciation_acct_new | varchar | 22 | √ | null | New Accum Depreciation Acct | |
a_asset_transfer | a_accumdepreciation_acct_str | varchar | 40 | √ | null | Old Asset Cost Acct | |
a_asset_transfer | a_accumdepreciation_new_acct | numeric | 10 | Accumulated Depreciation Account (new) | |||
a_asset_transfer | a_accumulated_depr_f | numeric | 0 | √ | null | Accumulated Depreciation (fiscal) | |
a_asset_transfer | a_asset_acct | numeric | 10 | √ | null | Asset Acct | |
a_asset_transfer | a_asset_acct_id | numeric | 10 | √ | null | A_Asset_Acct_ID | |
a_asset_transfer | a_asset_acct_new | varchar | 22 | √ | null | New Asset Cost Acct | |
a_asset_transfer | a_asset_acct_str | varchar | 40 | √ | null | A_Asset_Acct_Str | |
a_asset_transfer | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_transfer | a_asset_new_acct | numeric | 10 | Asset Acct (new) | |||
a_asset_transfer | a_asset_transfer_id | numeric | 10 | A_Asset_Transfer_ID | |||
a_asset_transfer | a_asset_transfer_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Transfer_UU | |
a_asset_transfer | a_capvsexp | varchar | 3 | 'Cap'::character varying | Capital/Expense | ||
a_asset_transfer | a_depreciation_acct | numeric | 10 | √ | null | Depreciation Account | |
a_asset_transfer | a_depreciation_acct_new | varchar | 22 | √ | null | New Depreciation Exp Acct | |
a_asset_transfer | a_depreciation_acct_str | varchar | 40 | √ | null | A_Depreciation_Acct_Str | |
a_asset_transfer | a_depreciation_new_acct | numeric | 10 | Depreciation Acct (new) | |||
a_asset_transfer | a_disposal_loss | numeric | 10 | √ | null | Loss on Disposal | |
a_asset_transfer | a_disposal_loss_acct | numeric | 10 | √ | NULL::numeric | Disposal Loss Acct | |
a_asset_transfer | a_disposal_loss_new | varchar | 22 | √ | null | New Disposal Loss | |
a_asset_transfer | a_disposal_loss_new_acct | numeric | 10 | Disposal Loss Acct (new) | |||
a_asset_transfer | a_disposal_loss_str | varchar | 40 | √ | null | Disposal Loss Str | |
a_asset_transfer | a_disposal_revenue | numeric | 10 | √ | null | Disposal Revenue | |
a_asset_transfer | a_disposal_revenue_acct | numeric | 10 | √ | NULL::numeric | Disposal Revenue Acct | |
a_asset_transfer | a_disposal_revenue_new | varchar | 22 | √ | null | New Disposal Revenue | |
a_asset_transfer | a_disposal_revenue_new_acct | numeric | 10 | Disposal Revenue Acct (new) | |||
a_asset_transfer | a_disposal_revenue_str | varchar | 40 | √ | null | Disposal Revenue Str | |
a_asset_transfer | a_period_end | numeric | 10 | A_Period_End | |||
a_asset_transfer | a_period_start | numeric | 10 | A_Period_Start | |||
a_asset_transfer | a_split_percent | numeric | 0 | (1)::numeric | Split Percent | ||
a_asset_transfer | a_transfer_balance | bpchar | 1 | 'Y'::bpchar | A_Transfer_Balance | ||
a_asset_transfer | a_transfer_balance_is | bpchar | 1 | A_Transfer_Balance_IS | |||
a_asset_transfer | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_transfer | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_transfer | c_acctschema_id | numeric | 10 | Rules for accounting | |||
a_asset_transfer | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
a_asset_transfer | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_transfer | createdby | numeric | 10 | User who created this records | |||
a_asset_transfer | dateacct | timestamp | 29,6 | Accounting Date | |||
a_asset_transfer | datedoc | timestamp | 29,6 | √ | null | Date of the Document | |
a_asset_transfer | docaction | bpchar | 2 | 'CO'::bpchar | The targeted status of the document | ||
a_asset_transfer | docstatus | varchar | 2 | 'DR'::character varying | The current status of the document | ||
a_asset_transfer | documentno | varchar | 30 | √ | NULL::character varying | Document sequence number of the document | |
a_asset_transfer | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_asset_transfer | posted | bpchar | 1 | √ | NULL::bpchar | Posting status | |
a_asset_transfer | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_asset_transfer | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_asset_transfer | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
a_asset_transfer | processing | bpchar | 1 | 'N'::bpchar | Process Now | ||
a_asset_transfer | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_transfer | updatedby | numeric | 10 | User who updated this records | |||
a_asset_type | a_asset_type_id | numeric | 10 | Asset Type | |||
a_asset_type | a_asset_type_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Type_UU | |
a_asset_type | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_type | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_type | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_type | createdby | numeric | 10 | User who created this records | |||
a_asset_type | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
a_asset_type | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_type | isdepreciable | varchar | 2 | 'XX'::character varying | This asset CAN be depreciated | ||
a_asset_type | isinposession | varchar | 2 | 'XX'::character varying | The asset is in the possession of the organization | ||
a_asset_type | isowned | varchar | 2 | 'XX'::character varying | The asset is owned by the organization | ||
a_asset_type | name | varchar | 120 | Alphanumeric identifier of the entity | |||
a_asset_type | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_type | updatedby | numeric | 10 | User who updated this records | |||
a_asset_type | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
a_asset_use | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_asset_use | a_asset_use_id | numeric | 10 | A_Asset_Use_ID | |||
a_asset_use | a_asset_use_uu | varchar | 36 | √ | NULL::character varying | A_Asset_Use_UU | |
a_asset_use | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_use | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_use | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_use | createdby | numeric | 10 | User who created this records | |||
a_asset_use | description | varchar | 255 | √ | null | Optional short description of the record | |
a_asset_use | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_use | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_use | updatedby | numeric | 10 | User who updated this records | |||
a_asset_use | usedate | timestamp | 29,6 | Use Date | |||
a_asset_use | useunits | numeric | 10 | Currently used units of the assets | |||
a_depreciation | a_depreciation_id | numeric | 10 | Depreciation | |||
a_depreciation | a_depreciation_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_UU | |
a_depreciation | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation | createdby | numeric | 10 | User who created this records | |||
a_depreciation | depreciationtype | varchar | 10 | Depreciation Type | |||
a_depreciation | description | varchar | 510 | √ | null | Optional short description of the record | |
a_depreciation | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation | name | varchar | 120 | Alphanumeric identifier of the entity | |||
a_depreciation | processed | bpchar | 1 | 'Y'::bpchar | The document has been processed | ||
a_depreciation | script | varchar | 2000 | √ | null | ||
a_depreciation | text | varchar | 2000 | √ | null | Description | |
a_depreciation | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_build | a_depreciation_build_id | numeric | 10 | Build Depreciation | |||
a_depreciation_build | a_depreciation_build_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Build_UU | |
a_depreciation_build | a_end_asset_id | numeric | 10 | √ | null | To Asset | |
a_depreciation_build | a_start_asset_id | numeric | 10 | √ | null | From Asset | |
a_depreciation_build | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
a_depreciation_build | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
a_depreciation_build | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
a_depreciation_build | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_build | createdby | numeric | 10 | √ | null | User who created this records | |
a_depreciation_build | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
a_depreciation_build | datedoc | timestamp | 29,6 | √ | null | Date of the Document | |
a_depreciation_build | isactive | bpchar | 1 | √ | null | The record is active in the system | |
a_depreciation_build | periodno | numeric | 10 | √ | null | Unique Period Number | |
a_depreciation_build | postingtype | bpchar | 1 | √ | 'A'::bpchar | The type of posted amount for the transaction | |
a_depreciation_build | processed | bpchar | 1 | √ | null | The document has been processed | |
a_depreciation_build | processing | bpchar | 1 | √ | null | Process Now | |
a_depreciation_build | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_build | updatedby | numeric | 10 | √ | null | User who updated this records | |
a_depreciation_convention | a_depreciation_convention_id | numeric | 10 | Depreciation Convention | |||
a_depreciation_convention | a_depreciation_convention_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Convention_UU | |
a_depreciation_convention | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_convention | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_convention | conventiontype | varchar | 10 | √ | null | Convention Type | |
a_depreciation_convention | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_convention | createdby | numeric | 10 | User who created this records | |||
a_depreciation_convention | description | varchar | 510 | √ | null | Optional short description of the record | |
a_depreciation_convention | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_convention | name | varchar | 120 | √ | null | Alphanumeric identifier of the entity | |
a_depreciation_convention | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_depreciation_convention | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
a_depreciation_convention | textmsg | varchar | 2000 | √ | null | Text Message | |
a_depreciation_convention | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_convention | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_entry | a_depreciation_entry_id | numeric | 10 | Depreciation Entry | |||
a_depreciation_entry | a_depreciation_entry_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Entry_UU | |
a_depreciation_entry | a_entry_type | varchar | 3 | √ | null | Entry Type | |
a_depreciation_entry | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_entry | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_entry | c_acctschema_id | numeric | 10 | Rules for accounting | |||
a_depreciation_entry | c_currency_id | numeric | 10 | The Currency for this record | |||
a_depreciation_entry | c_doctype_id | numeric | 10 | Document type or rules | |||
a_depreciation_entry | c_period_id | numeric | 10 | Period of the Calendar | |||
a_depreciation_entry | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_entry | createdby | numeric | 10 | User who created this records | |||
a_depreciation_entry | dateacct | timestamp | 29,6 | Accounting Date | |||
a_depreciation_entry | datedoc | timestamp | 29,6 | Date of the Document | |||
a_depreciation_entry | description | varchar | 510 | √ | null | Optional short description of the record | |
a_depreciation_entry | docaction | bpchar | 2 | 'CO'::bpchar | The targeted status of the document | ||
a_depreciation_entry | docstatus | varchar | 2 | 'DR'::character varying | The current status of the document | ||
a_depreciation_entry | documentno | varchar | 60 | Document sequence number of the document | |||
a_depreciation_entry | gl_category_id | numeric | 10 | √ | null | General Ledger Category | |
a_depreciation_entry | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_depreciation_entry | isapproved | bpchar | 1 | Indicates if this document requires approval | |||
a_depreciation_entry | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
a_depreciation_entry | postingtype | bpchar | 1 | 'A'::bpchar | The type of posted amount for the transaction | ||
a_depreciation_entry | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_depreciation_entry | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
a_depreciation_entry | processing | bpchar | 1 | Process Now | |||
a_depreciation_entry | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_entry | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_exp | a_account_number_acct | numeric | 10 | √ | NULL::numeric | A_Account_Number_Acct | |
a_depreciation_exp | a_accumulated_depr | numeric | 0 | √ | null | Accumulated Depreciation | |
a_depreciation_exp | a_accumulated_depr_delta | numeric | 0 | (0)::numeric | Accumulated Depreciation (delta) | ||
a_depreciation_exp | a_accumulated_depr_f | numeric | 0 | √ | null | Accumulated Depreciation (fiscal) | |
a_depreciation_exp | a_accumulated_depr_f_delta | numeric | 0 | (0)::numeric | Accumulated Depreciation - fiscal (delta) | ||
a_depreciation_exp | a_asset_addition_id | numeric | 10 | √ | NULL::numeric | Asset Addition | |
a_depreciation_exp | a_asset_cost | numeric | 0 | √ | null | Asset Cost | |
a_depreciation_exp | a_asset_cost_delta | numeric | 0 | (0)::numeric | Delta Asset Cost | ||
a_depreciation_exp | a_asset_disposed_id | numeric | 10 | √ | NULL::numeric | Asset Disposed | |
a_depreciation_exp | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_depreciation_exp | a_asset_remaining | numeric | 0 | √ | null | Remaining Amt | |
a_depreciation_exp | a_asset_remaining_f | numeric | 0 | √ | null | Remaining Amt (fiscal) | |
a_depreciation_exp | a_depreciation_entry_id | numeric | 10 | √ | NULL::numeric | Depreciation Entry | |
a_depreciation_exp | a_depreciation_exp_id | numeric | 10 | A_Depreciation_Exp_ID | |||
a_depreciation_exp | a_depreciation_exp_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Exp_UU | |
a_depreciation_exp | a_entry_type | varchar | 3 | Entry Type | |||
a_depreciation_exp | a_period | numeric | 10 | Asset Period | |||
a_depreciation_exp | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_exp | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_exp | c_acctschema_id | numeric | 10 | √ | NULL::numeric | Rules for accounting | |
a_depreciation_exp | cr_account_id | numeric | 10 | √ | NULL::numeric | Account used | |
a_depreciation_exp | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_exp | createdby | numeric | 10 | User who created this records | |||
a_depreciation_exp | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
a_depreciation_exp | description | varchar | 255 | Optional short description of the record | |||
a_depreciation_exp | dr_account_id | numeric | 10 | √ | NULL::numeric | Account used | |
a_depreciation_exp | expense | numeric | 0 | (0)::numeric | Expense | ||
a_depreciation_exp | expense_f | numeric | 0 | (0)::numeric | Expense (fiscal) | ||
a_depreciation_exp | help | varchar | 2000 | √ | NULL::character varying | Comment or Hint | |
a_depreciation_exp | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_exp | isdepreciated | bpchar | 1 | The asset will be depreciated | |||
a_depreciation_exp | postingtype | bpchar | 1 | √ | 'A'::bpchar | The type of posted amount for the transaction | |
a_depreciation_exp | processed | bpchar | 1 | The document has been processed | |||
a_depreciation_exp | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
a_depreciation_exp | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_exp | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_exp | uselifemonths | numeric | 10 | √ | NULL::numeric | Months of the usable life of the asset | |
a_depreciation_exp | uselifemonths_f | numeric | 10 | √ | NULL::numeric | Use Life - Months (fiscal) | |
a_depreciation_forecast | a_depreciation_forecast_id | numeric | 10 | Depreciation Forecast | |||
a_depreciation_forecast | a_depreciation_forecast_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Forecast_UU | |
a_depreciation_forecast | a_end_asset_id | numeric | 10 | To Asset | |||
a_depreciation_forecast | a_start_asset_id | numeric | 10 | From Asset | |||
a_depreciation_forecast | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_forecast | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_forecast | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_forecast | createdby | numeric | 10 | User who created this records | |||
a_depreciation_forecast | datedoc | timestamp | 29,6 | Date of the Document | |||
a_depreciation_forecast | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_forecast | postingtype | bpchar | 1 | The type of posted amount for the transaction | |||
a_depreciation_forecast | processed | bpchar | 1 | √ | null | The document has been processed | |
a_depreciation_forecast | processing | bpchar | 1 | √ | null | Process Now | |
a_depreciation_forecast | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_forecast | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_method | a_depreciation_method_id | numeric | 10 | Depreciation Method | |||
a_depreciation_method | a_depreciation_method_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Method_UU | |
a_depreciation_method | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_method | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_method | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_method | createdby | numeric | 10 | User who created this records | |||
a_depreciation_method | depreciationtype | varchar | 10 | √ | null | Depreciation Type | |
a_depreciation_method | description | varchar | 510 | √ | null | Optional short description of the record | |
a_depreciation_method | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_method | name | varchar | 120 | √ | null | Alphanumeric identifier of the entity | |
a_depreciation_method | processed | bpchar | 1 | 'Y'::bpchar | The document has been processed | ||
a_depreciation_method | text | varchar | 2000 | √ | null | Description | |
a_depreciation_method | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_method | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_table_detail | a_depreciation_rate | numeric | 0 | Rate | |||
a_depreciation_table_detail | a_depreciation_table_code | varchar | 20 | Depreciation Code | |||
a_depreciation_table_detail | a_depreciation_table_detail_id | numeric | 10 | Depreciation Table Detail | |||
a_depreciation_table_detail | a_depreciation_table_detail_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Table_Detail_UU | |
a_depreciation_table_detail | a_period | numeric | 10 | Asset Period | |||
a_depreciation_table_detail | a_table_rate_type | varchar | 2 | √ | 'RT'::character varying | Type | |
a_depreciation_table_detail | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_table_detail | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_table_detail | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_table_detail | createdby | numeric | 10 | User who created this records | |||
a_depreciation_table_detail | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_table_detail | processed | bpchar | 1 | The document has been processed | |||
a_depreciation_table_detail | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_table_detail | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_table_header | a_depreciation_table_code | varchar | 20 | Depreciation Code | |||
a_depreciation_table_header | a_depreciation_table_header_id | numeric | 10 | A_Depreciation_Table_Header_ID | |||
a_depreciation_table_header | a_depreciation_table_header_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Table_Header_UU | |
a_depreciation_table_header | a_table_rate_type | varchar | 2 | Type | |||
a_depreciation_table_header | a_term | varchar | 2 | Period/Yearly | |||
a_depreciation_table_header | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_table_header | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_table_header | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_table_header | createdby | numeric | 10 | User who created this records | |||
a_depreciation_table_header | description | varchar | 510 | Optional short description of the record | |||
a_depreciation_table_header | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_table_header | processed | bpchar | 1 | The document has been processed | |||
a_depreciation_table_header | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_table_header | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_workfile | a_accumulated_depr | numeric | 0 | (0)::numeric | Accumulated Depreciation | ||
a_depreciation_workfile | a_accumulated_depr_f | numeric | 0 | (0)::numeric | Accumulated Depreciation (fiscal) | ||
a_depreciation_workfile | a_asset_cost | numeric | 0 | (0)::numeric | Asset Cost | ||
a_depreciation_workfile | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
a_depreciation_workfile | a_asset_life_current_year | numeric | 0 | (0)::numeric | A_Asset_Life_Current_Year | ||
a_depreciation_workfile | a_asset_life_years | numeric | 0 | '0'::numeric | Life Years | ||
a_depreciation_workfile | a_asset_life_years_f | numeric | 0 | '0'::numeric | Life Years (fiscal) | ||
a_depreciation_workfile | a_asset_remaining | numeric | 0 | √ | null | Remaining Amt | |
a_depreciation_workfile | a_asset_remaining_f | numeric | 0 | √ | null | Remaining Amt (fiscal) | |
a_depreciation_workfile | a_base_amount | numeric | 0 | √ | null | A_Base_Amount | |
a_depreciation_workfile | a_calc_accumulated_depr | numeric | 0 | √ | (0)::numeric | A_Calc_Accumulated_Depr | |
a_depreciation_workfile | a_curr_dep_exp | numeric | 0 | (0)::numeric | A_Curr_Dep_Exp | ||
a_depreciation_workfile | a_current_period | numeric | 10 | √ | null | Current Period | |
a_depreciation_workfile | a_depreciation_workfile_id | numeric | 10 | A_Depreciation_Workfile_ID | |||
a_depreciation_workfile | a_depreciation_workfile_uu | varchar | 36 | √ | NULL::character varying | A_Depreciation_Workfile_UU | |
a_depreciation_workfile | a_fundingmode_id | numeric | 10 | √ | NULL::numeric | Asset Funding Mode | |
a_depreciation_workfile | a_life_period | numeric | 10 | (0)::numeric | Life Periods | ||
a_depreciation_workfile | a_life_period_f | numeric | 10 | (0)::numeric | Life Period (fiscal) | ||
a_depreciation_workfile | a_period_forecast | numeric | 0 | √ | null | A_Period_Forecast | |
a_depreciation_workfile | a_period_posted | numeric | 10 | √ | null | A_Period_Posted | |
a_depreciation_workfile | a_prior_year_accumulated_depr | numeric | 0 | √ | null | A_Prior_Year_Accumulated_Depr | |
a_depreciation_workfile | a_qty_current | numeric | 0 | Current Qty | |||
a_depreciation_workfile | a_salvage_value | numeric | 0 | (0)::numeric | Asset Salvage Value | ||
a_depreciation_workfile | a_tip_finantare | bpchar | 1 | 'P'::bpchar | Financing Type | ||
a_depreciation_workfile | a_valoare_cofinantare | numeric | 0 | √ | null | Own contribution | |
a_depreciation_workfile | a_valoare_tert | numeric | 0 | √ | null | Third contribution | |
a_depreciation_workfile | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_depreciation_workfile | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_depreciation_workfile | assetdepreciationdate | timestamp | 29,6 | √ | null | Date of last depreciation | |
a_depreciation_workfile | c_acctschema_id | numeric | 10 | √ | NULL::numeric | Rules for accounting | |
a_depreciation_workfile | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_depreciation_workfile | createdby | numeric | 10 | User who created this records | |||
a_depreciation_workfile | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
a_depreciation_workfile | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
a_depreciation_workfile | isactive | bpchar | 1 | The record is active in the system | |||
a_depreciation_workfile | isdepreciated | bpchar | 1 | √ | null | The asset will be depreciated | |
a_depreciation_workfile | postingtype | bpchar | 1 | √ | 'A'::bpchar | The type of posted amount for the transaction | |
a_depreciation_workfile | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_depreciation_workfile | processing | bpchar | 1 | √ | 'N'::bpchar | Process Now | |
a_depreciation_workfile | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_depreciation_workfile | updatedby | numeric | 10 | User who updated this records | |||
a_depreciation_workfile | uselifemonths | numeric | 10 | (0)::numeric | Months of the usable life of the asset | ||
a_depreciation_workfile | uselifemonths_f | numeric | 10 | (0)::numeric | Use Life - Months (fiscal) | ||
a_depreciation_workfile | uselifeyears | numeric | 0 | '0'::numeric | Years of the usable life of the asset | ||
a_depreciation_workfile | uselifeyears_f | numeric | 0 | '0'::numeric | Use Life - Years (fiscal) | ||
a_fundingmode | a_fundingmode_id | numeric | 10 | Asset Funding Mode | |||
a_fundingmode | a_fundingmode_uu | varchar | 36 | √ | NULL::character varying | A_FundingMode_UU | |
a_fundingmode | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_fundingmode | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_fundingmode | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_fundingmode | createdby | numeric | 10 | User who created this records | |||
a_fundingmode | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
a_fundingmode | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_fundingmode | name | varchar | 60 | Alphanumeric identifier of the entity | |||
a_fundingmode | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_fundingmode | updatedby | numeric | 10 | User who updated this records | |||
a_fundingmode | value | varchar | 30 | Search key for the record in the format required - must be unique | |||
a_fundingmode_acct | a_fundingmode_acct | numeric | 10 | Funding Mode Account | |||
a_fundingmode_acct | a_fundingmode_acct_uu | varchar | 36 | √ | NULL::character varying | A_FundingMode_Acct_UU | |
a_fundingmode_acct | a_fundingmode_id | numeric | 10 | Asset Funding Mode | |||
a_fundingmode_acct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_fundingmode_acct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_fundingmode_acct | c_acctschema_id | numeric | 10 | Rules for accounting | |||
a_fundingmode_acct | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_fundingmode_acct | createdby | numeric | 10 | User who created this records | |||
a_fundingmode_acct | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
a_fundingmode_acct | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_fundingmode_acct | updatedby | numeric | 10 | User who updated this records | |||
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
ad_user | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | Address of the Business Partner | |
ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
ad_user | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
ad_user | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
ad_user | c_job_id | numeric | 10 | √ | null | Job Position | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_user | createdby | numeric | 10 | User who created this records | |||
ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | Date Account Locked | |
ad_user | datelastlogin | timestamp | 29,6 | √ | null | Date Last Login | |
ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | Date Password Changed | |
ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
ad_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
ad_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
ad_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
ad_user | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | The selected mail template will be automatically inserted when creating an email | ||
ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | The user/contact has full access to Business Partner information and resources | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
ad_user | ismenuautoexpand | bpchar | 1 | √ | null | If ticked, the menu is automatically expanded | |
ad_user | isnoexpire | bpchar | 1 | 'N'::bpchar | No Expire | ||
ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | No Password Reset | ||
ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | This contact is a sales lead | ||
ad_user | isshipto | bpchar | 1 | 'N'::bpchar | Business Partner Shipment Address | ||
ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | Support User | ||
ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | This contact is a vendor lead | ||
ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
ad_user | ldapuser | varchar | 60 | √ | null | User Name used for authorization via LDAP (directory) services | |
ad_user | leadsource | varchar | 10 | √ | NULL::character varying | The source of this lead/opportunity | |
ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | Additional information on the source of this lead/opportunity | |
ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | The status of this lead/opportunity in the sales cycle | |
ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | Additional information on the status of this lead/opportunity | |
ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
ad_user | processing | bpchar | 1 | √ | null | Process Now | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | Sales Representative or Company Agent | |
ad_user | salt | varchar | 16 | √ | NULL::character varying | Random data added to improve password hash effectiveness | |
ad_user | securityquestion | varchar | 1024 | √ | null | Security Question | |
ad_user | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_user | updatedby | numeric | 10 | User who updated this records | |||
ad_user | userpin | varchar | 20 | √ | null | User PIN | |
ad_user | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
c_acctschema | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_acctschema | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_acctschema | ad_orgonly_id | numeric | 10 | √ | null | Create posting entries only for this organization | |
c_acctschema | autoperiodcontrol | bpchar | 1 | 'N'::bpchar | If selected, the periods are automatically opened and closed | ||
c_acctschema | c_acctschema_id | numeric | 10 | Rules for accounting | |||
c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | C_AcctSchema_UU | |
c_acctschema | c_currency_id | numeric | 10 | The Currency for this record | |||
c_acctschema | c_period_id | numeric | 10 | √ | null | Period of the Calendar | |
c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | Create Commitment and/or Reservations for Budget Control | ||
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_acctschema | created | timestamp | 29,6 | now() | Date this record was created | ||
c_acctschema | createdby | numeric | 10 | User who created this records | |||
c_acctschema | description | varchar | 255 | √ | null | Optional short description of the record | |
c_acctschema | gaap | bpchar | 2 | Generally Accepted Accounting Principles | |||
c_acctschema | hasalias | bpchar | 1 | 'Y'::bpchar | Ability to select (partial) account combinations by an Alias | ||
c_acctschema | hascombination | bpchar | 1 | 'Y'::bpchar | Combination of account elements are checked | ||
c_acctschema | isaccrual | bpchar | 1 | 'Y'::bpchar | Indicates if Accrual or Cash Based accounting will be used | ||
c_acctschema | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_acctschema | isadjustcogs | bpchar | 1 | 'N'::bpchar | Adjust Cost of Good Sold | ||
c_acctschema | isallownegativeposting | bpchar | 1 | √ | 'Y'::bpchar | Allow to post negative accounting values | |
c_acctschema | isdiscountcorrectstax | bpchar | 1 | 'N'::bpchar | Correct the tax for payment discount and charges | ||
c_acctschema | isexplicitcostadjustment | bpchar | 1 | 'N'::bpchar | Post the cost adjustment explicitly | ||
c_acctschema | ispostifclearingequal | bpchar | 1 | √ | 'Y'::bpchar | This flag controls if Adempiere must post when clearing (transit) and final accounts are the same | |
c_acctschema | ispostservices | bpchar | 1 | 'N'::bpchar | Differentiate between Services and Product Receivable/Payables | ||
c_acctschema | istradediscountposted | bpchar | 1 | 'N'::bpchar | Generate postings for trade discounts | ||
c_acctschema | m_costtype_id | numeric | 10 | √ | null | Type of Cost (e.g. Current, Plan, Future) | |
c_acctschema | name | varchar | 60 | Alphanumeric identifier of the entity | |||
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_acctschema | processing | bpchar | 1 | √ | null | Process Now | |
c_acctschema | separator | bpchar | 1 | Element Separator | |||
c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | Type of Tax Correction | |
c_acctschema | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_acctschema | updatedby | numeric | 10 | User who updated this records | |||
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_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | The Business Partner is another Organization for explicit Inter-Org transactions | |
c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
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_bpartner | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bpartner | createdby | numeric | 10 | User who created this records | |||
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
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_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is a Vendor | ||
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
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_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
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_bpartner | 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 | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
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_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
c_bpartner | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_bpartner_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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_bpartner_location | c_bpartner_location_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_Location_UU | |
c_bpartner_location | c_location_id | numeric | 10 | √ | null | Location or Address | |
c_bpartner_location | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
c_bpartner_location | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bpartner_location | createdby | numeric | 10 | User who created this records | |||
c_bpartner_location | customeraddressid | varchar | 60 | √ | NULL::character varying | Customer Address ID | |
c_bpartner_location | fax | varchar | 40 | √ | null | Facsimile number | |
c_bpartner_location | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_bpartner_location | isbillto | bpchar | 1 | 'Y'::bpchar | Business Partner Invoice/Bill Address | ||
c_bpartner_location | isdn | varchar | 40 | √ | null | ISDN or modem line | |
c_bpartner_location | ispayfrom | bpchar | 1 | 'Y'::bpchar | Business Partner pays from that address and we'll send dunning letters there | ||
c_bpartner_location | ispreservecustomname | bpchar | 1 | 'N'::bpchar | Preserve custom name | ||
c_bpartner_location | isremitto | bpchar | 1 | 'Y'::bpchar | Business Partner payment address | ||
c_bpartner_location | isshipto | bpchar | 1 | 'Y'::bpchar | Business Partner Shipment Address | ||
c_bpartner_location | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_bpartner_location | phone | varchar | 40 | √ | null | Identifies a telephone number | |
c_bpartner_location | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
c_bpartner_location | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bpartner_location | updatedby | numeric | 10 | User who updated this records | |||
c_calendar | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_calendar | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_calendar | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
c_calendar | c_calendar_uu | varchar | 36 | √ | NULL::character varying | C_Calendar_UU | |
c_calendar | created | timestamp | 29,6 | now() | Date this record was created | ||
c_calendar | createdby | numeric | 10 | User who created this records | |||
c_calendar | description | varchar | 255 | √ | null | Optional short description of the record | |
c_calendar | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_calendar | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_calendar | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_calendar | updatedby | numeric | 10 | User who updated this records | |||
c_charge | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_charge | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_charge | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_charge | c_charge_id | numeric | 10 | Additional document charges | |||
c_charge | c_charge_uu | varchar | 36 | √ | NULL::character varying | C_Charge_UU | |
c_charge | c_chargetype_id | numeric | 10 | √ | null | Charge Type | |
c_charge | c_taxcategory_id | numeric | 10 | √ | null | Tax Category | |
c_charge | chargeamt | numeric | 0 | 0 | Charge Amount | ||
c_charge | created | timestamp | 29,6 | now() | Date this record was created | ||
c_charge | createdby | numeric | 10 | User who created this records | |||
c_charge | description | varchar | 255 | √ | null | Optional short description of the record | |
c_charge | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_charge | issamecurrency | bpchar | 1 | 'N'::bpchar | Same Currency | ||
c_charge | issametax | bpchar | 1 | 'N'::bpchar | Use the same tax as the main transaction | ||
c_charge | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
c_charge | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_charge | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_charge | updatedby | numeric | 10 | User who updated this records | |||
c_currency | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_currency | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_currency | c_currency_id | numeric | 10 | The Currency for this record | |||
c_currency | c_currency_uu | varchar | 36 | √ | NULL::character varying | C_Currency_UU | |
c_currency | costingprecision | numeric | 10 | Rounding used costing calculations | |||
c_currency | created | timestamp | 29,6 | now() | Date this record was created | ||
c_currency | createdby | numeric | 10 | User who created this records | |||
c_currency | cursymbol | varchar | 10 | √ | null | Symbol of the currency (opt used for printing only) | |
c_currency | description | varchar | 255 | Optional short description of the record | |||
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_currency | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
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 | ||
c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment Amount | |
c_currency | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
c_currency | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_currency | updatedby | numeric | 10 | User who updated this records | |||
c_invoiceline | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
c_invoiceline | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
c_invoiceline | a_capvsexp | varchar | 3 | √ | null | Capital/Expense | |
c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
c_invoiceline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoiceline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoiceline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | 1099 Box | |
c_invoiceline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
c_invoiceline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_invoiceline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
c_invoiceline | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoiceline | c_invoiceline_id | numeric | 10 | Invoice Detail Line | |||
c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | C_InvoiceLine_UU | |
c_invoiceline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
c_invoiceline | c_project_id | numeric | 10 | √ | null | Financial Project | |
c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
c_invoiceline | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
c_invoiceline | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
c_invoiceline | created | timestamp | 29,6 | now() | Date this record was created | ||
c_invoiceline | createdby | numeric | 10 | User who created this records | |||
c_invoiceline | description | varchar | 255 | √ | null | Optional short description of the record | |
c_invoiceline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_invoiceline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
c_invoiceline | line | numeric | 10 | Unique line for this document | |||
c_invoiceline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
c_invoiceline | linetotalamt | numeric | 0 | √ | 0 | Total line amount incl. Tax | |
c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
c_invoiceline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
c_invoiceline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
c_invoiceline | priceactual | numeric | 0 | 0 | Actual Price | ||
c_invoiceline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
c_invoiceline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
c_invoiceline | pricelist | numeric | 0 | 0 | List Price | ||
c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_invoiceline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
c_invoiceline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
c_invoiceline | ref_invoiceline_id | numeric | 10 | √ | null | Referenced Invoice Line | |
c_invoiceline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
c_invoiceline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
c_invoiceline | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
c_invoiceline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_invoiceline | updatedby | numeric | 10 | User who updated this records | |||
c_invoiceline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
c_invoiceline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
c_location | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_location | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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_location | c_addressvalidation_id | numeric | 10 | √ | NULL::numeric | Address Validation | |
c_location | c_city_id | numeric | 10 | √ | null | City | |
c_location | c_country_id | numeric | 10 | Country | |||
c_location | c_location_id | numeric | 10 | Location or Address | |||
c_location | c_location_uu | varchar | 36 | √ | NULL::character varying | C_Location_UU | |
c_location | c_region_id | numeric | 10 | √ | null | Identifies a geographical Region | |
c_location | city | varchar | 60 | √ | null | Identifies a City | |
c_location | comments | varchar | 2000 | √ | NULL::character varying | Comments or additional information | |
c_location | created | timestamp | 29,6 | now() | Date this record was created | ||
c_location | createdby | numeric | 10 | User who created this records | |||
c_location | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_location | isvalid | bpchar | 1 | √ | 'N'::bpchar | Element is valid | |
c_location | postal | varchar | 10 | √ | null | Postal code | |
c_location | postal_add | varchar | 10 | √ | null | Additional ZIP or Postal code | |
c_location | regionname | varchar | 40 | √ | null | Name of the Region | |
c_location | result | varchar | 2000 | √ | NULL::character varying | Result of the action taken | |
c_location | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_location | updatedby | numeric | 10 | User who updated this records | |||
c_location | validateaddress | bpchar | 1 | √ | NULL::bpchar | Validate Address | |
c_period | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_period | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_period | c_period_id | numeric | 10 | Period of the Calendar | |||
c_period | c_period_uu | varchar | 36 | √ | NULL::character varying | C_Period_UU | |
c_period | c_year_id | numeric | 10 | Calendar Year | |||
c_period | created | timestamp | 29,6 | now() | Date this record was created | ||
c_period | createdby | numeric | 10 | User who created this records | |||
c_period | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
c_period | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_period | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_period | periodno | numeric | 10 | Unique Period Number | |||
c_period | periodtype | bpchar | 1 | Period Type | |||
c_period | processing | bpchar | 1 | √ | null | Process Now | |
c_period | startdate | timestamp | 29,6 | First effective day (inclusive) | |||
c_period | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_period | updatedby | numeric | 10 | User who updated this records | |||
c_uom | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_uom | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_uom | c_uom_id | numeric | 10 | Unit of Measure | |||
c_uom | c_uom_uu | varchar | 36 | √ | NULL::character varying | C_UOM_UU | |
c_uom | costingprecision | numeric | 10 | Rounding used costing calculations | |||
c_uom | created | timestamp | 29,6 | now() | Date this record was created | ||
c_uom | createdby | numeric | 10 | User who created this records | |||
c_uom | description | varchar | 255 | √ | null | Optional short description of the record | |
c_uom | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_uom | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_uom | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_uom | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
c_uom | uomsymbol | varchar | 10 | √ | null | Symbol for a Unit of Measure | |
c_uom | uomtype | varchar | 2 | √ | NULL::character varying | UOM Type | |
c_uom | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_uom | updatedby | numeric | 10 | User who updated this records | |||
c_uom | x12de355 | varchar | 4 | UOM EDI X12 Code | |||
c_year | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_year | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_year | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
c_year | c_year_id | numeric | 10 | Calendar Year | |||
c_year | c_year_uu | varchar | 36 | √ | NULL::character varying | C_Year_UU | |
c_year | created | timestamp | 29,6 | now() | Date this record was created | ||
c_year | createdby | numeric | 10 | User who created this records | |||
c_year | description | varchar | 255 | √ | null | Optional short description of the record | |
c_year | fiscalyear | varchar | 10 | The Fiscal Year | |||
c_year | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_year | processing | bpchar | 1 | √ | null | Process Now | |
c_year | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_year | updatedby | numeric | 10 | User who updated this records | |||
m_inoutline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_inoutline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_inoutline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
m_inoutline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
m_inoutline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
m_inoutline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
m_inoutline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
m_inoutline | c_project_id | numeric | 10 | √ | null | Financial Project | |
m_inoutline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
m_inoutline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
m_inoutline | c_uom_id | numeric | 10 | Unit of Measure | |||
m_inoutline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
m_inoutline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_inoutline | createdby | numeric | 10 | User who created this records | |||
m_inoutline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_inoutline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_inoutline | isautoproduce | bpchar | 1 | √ | 'N'::bpchar | Auto create production to fulfill shipment | |
m_inoutline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
m_inoutline | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
m_inoutline | line | numeric | 10 | Unique line for this document | |||
m_inoutline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_inoutline | m_inout_id | numeric | 10 | Material Shipment Document | |||
m_inoutline | m_inoutline_id | numeric | 10 | Line on Shipment or Receipt document | |||
m_inoutline | m_inoutline_uu | varchar | 36 | √ | NULL::character varying | M_InOutLine_UU | |
m_inoutline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_inoutline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
m_inoutline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
m_inoutline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
m_inoutline | pickedqty | numeric | 0 | √ | 0 | Picked Quantity | |
m_inoutline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_inoutline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
m_inoutline | qtyoverreceipt | numeric | 0 | √ | 0 | Over Receipt Quantity | |
m_inoutline | ref_inoutline_id | numeric | 10 | √ | null | Referenced Shipment Line | |
m_inoutline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
m_inoutline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
m_inoutline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
m_inoutline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_inoutline | updatedby | numeric | 10 | User who updated this records | |||
m_inoutline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
m_inoutline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
m_locator | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_locator | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_locator | created | timestamp | 29,6 | now() | Date this record was created | ||
m_locator | createdby | numeric | 10 | User who created this records | |||
m_locator | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_locator | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_locator | m_locator_id | numeric | 10 | Warehouse Locator | |||
m_locator | m_locator_uu | varchar | 36 | √ | NULL::character varying | M_Locator_UU | |
m_locator | m_locatortype_id | numeric | 10 | √ | NULL::numeric | Locator Type | |
m_locator | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
m_locator | priorityno | numeric | 10 | Where inventory should be picked from first | |||
m_locator | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_locator | updatedby | numeric | 10 | User who updated this records | |||
m_locator | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_locator | x | varchar | 60 | √ | null | X dimension, e.g., Aisle | |
m_locator | y | varchar | 60 | √ | null | Y dimension, e.g., Bin | |
m_locator | z | varchar | 60 | √ | null | Z dimension, e.g., Level | |
m_movementline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_movementline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_movementline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
m_movementline | created | timestamp | 29,6 | now() | Date this record was created | ||
m_movementline | createdby | numeric | 10 | User who created this records | |||
m_movementline | dd_orderline_id | numeric | 10 | √ | null | Distribution Order Line | |
m_movementline | description | varchar | 255 | √ | null | Optional short description of the record | |
m_movementline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_movementline | line | numeric | 10 | √ | null | Unique line for this document | |
m_movementline | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
m_movementline | m_attributesetinstanceto_id | numeric | 10 | √ | null | Target Product Attribute Set Instance | |
m_movementline | m_locator_id | numeric | 10 | Warehouse Locator | |||
m_movementline | m_locatorto_id | numeric | 10 | Location inventory is moved to | |||
m_movementline | m_movement_id | numeric | 10 | Movement of Inventory | |||
m_movementline | m_movementline_id | numeric | 10 | Inventory Move document Line | |||
m_movementline | m_movementline_uu | varchar | 36 | √ | NULL::character varying | M_MovementLine_UU | |
m_movementline | m_product_id | numeric | 10 | Product, Service, Item | |||
m_movementline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
m_movementline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
m_movementline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
m_movementline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
m_movementline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
m_movementline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_movementline | updatedby | numeric | 10 | User who updated this records | |||
m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product | createdby | numeric | 10 | User who created this records | |||
m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
m_product | 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 | ||
m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
m_product | downloadurl | varchar | 120 | √ | null | ||
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 | |
m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
m_product | imageurl | varchar | 120 | √ | null | URL of image | |
m_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
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 | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the pick list | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | Organization stocks this product | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
m_product | istoformule | bpchar | 1 | √ | null | ||
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_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
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 | |
m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
m_product | processing | bpchar | 1 | √ | null | Process Now | |
m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
m_product | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product | updatedby | numeric | 10 | User who updated this records | |||
m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
m_product | versionno | varchar | 20 | √ | null | Version Number | |
m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
m_product_category | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
m_product_category | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_category | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_category | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
m_product_category | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product_category | createdby | numeric | 10 | User who created this records | |||
m_product_category | description | varchar | 255 | √ | null | Optional short description of the record | |
m_product_category | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product_category | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_product_category | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product_category | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product_category | m_product_category_parent_id | numeric | 10 | √ | null | Parent Product Category | |
m_product_category | m_product_category_uu | varchar | 36 | √ | NULL::character varying | M_Product_Category_UU | |
m_product_category | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
m_product_category | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_product_category | plannedmargin | numeric | 0 | Project's planned margin as a percentage | |||
m_product_category | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product_category | updatedby | numeric | 10 | User who updated this records | |||
m_product_category | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_productdownload | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_productdownload | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_productdownload | created | timestamp | 29,6 | now() | Date this record was created | ||
m_productdownload | createdby | numeric | 10 | User who created this records | |||
m_productdownload | downloadurl | varchar | 120 | URL of the Download files | |||
m_productdownload | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_productdownload | m_product_id | numeric | 10 | Product, Service, Item | |||
m_productdownload | m_productdownload_id | numeric | 10 | Product downloads | |||
m_productdownload | m_productdownload_uu | varchar | 36 | √ | NULL::character varying | M_ProductDownload_UU | |
m_productdownload | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_productdownload | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_productdownload | updatedby | numeric | 10 | User who updated this records | |||
r_mailtext | ad_client_id | numeric | 10 | Tenant for this installation. | |||
r_mailtext | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
r_mailtext | created | timestamp | 29,6 | now() | Date this record was created | ||
r_mailtext | createdby | numeric | 10 | User who created this records | |||
r_mailtext | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
r_mailtext | ishtml | bpchar | 1 | 'N'::bpchar | Text has HTML tags | ||
r_mailtext | mailheader | varchar | 2000 | √ | null | Mail Header (Subject) | |
r_mailtext | mailtext | text | 2147483647 | Text used for Mail message | |||
r_mailtext | mailtext2 | varchar | 2000 | √ | null | Optional second text part used for Mail message | |
r_mailtext | mailtext3 | varchar | 2000 | √ | null | Optional third text part used for Mail message | |
r_mailtext | name | varchar | 60 | Alphanumeric identifier of the entity | |||
r_mailtext | r_mailtext_id | numeric | 10 | Text templates for mailings | |||
r_mailtext | r_mailtext_uu | varchar | 36 | √ | NULL::character varying | R_MailText_UU | |
r_mailtext | updated | timestamp | 29,6 | now() | Date this record was updated | ||
r_mailtext | updatedby | numeric | 10 | User who updated this records |