SchemaSpy Analysis of idempiere9.adempiere - ColumnsAssets Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:45 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 1494 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 Client/Tenant for this installation.
a_asset_acct ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_addition ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_change ad_org_id numeric 10 Organizational entity within client
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 AssetAccumDepreciationAmt
a_asset_change assetbookvalueamt numeric 0  √  null AssetBookValueAmt
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 ChangeAmt
a_asset_change changedate timestamp 29,6  √  null ChangeDate
a_asset_change changetype varchar 3 ChangeType
a_asset_change conventiontype varchar 10  √  null ConventionType
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 DepreciationType
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 10  √  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 Client/Tenant for this installation.
a_asset_class ad_org_id numeric 10  √  NULL::numeric Organizational entity within client
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 Client/Tenant for this installation.
a_asset_delivery ad_org_id numeric 10 Organizational entity within client
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 email 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 Client/Tenant for this installation.
a_asset_disposed ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_group ad_org_id numeric 10 Organizational entity within client
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 IsFixedAsset
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 Client/Tenant for this installation.
a_asset_group_acct ad_org_id numeric 10 Organizational entity within client
a_asset_group_acct c_acctschema_id numeric 10 Rules for accounting
a_asset_group_acct conventiontype varchar 10  √  null ConventionType
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 DepreciationType
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 10  √  null Years of the usable life of the asset
a_asset_group_acct uselifeyears_f numeric 10 (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 Client/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 client
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 Client/Tenant for this installation.
a_asset_info_fin ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_info_ins ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_info_lic ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_info_oth ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_info_tax ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_product ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_retirement ad_org_id numeric 10 Organizational entity within client
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 Acumulated Depreciation
a_asset_reval ad_client_id numeric 10 Client/Tenant for this installation.
a_asset_reval ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_reval_entry ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_reval_index ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_split ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_spread ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_transfer ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_type ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_asset_use ad_org_id numeric 10 Organizational entity within client
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 UseDate
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 Client/Tenant for this installation.
a_depreciation ad_org_id numeric 10 Organizational entity within client
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 DepreciationType
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 Client/Tenant for this installation.
a_depreciation_build ad_org_id numeric 10  √  null Organizational entity within client
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 Client/Tenant for this installation.
a_depreciation_convention ad_org_id numeric 10 Organizational entity within client
a_depreciation_convention conventiontype varchar 10  √  null ConventionType
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 Client/Tenant for this installation.
a_depreciation_entry ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_depreciation_exp ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_depreciation_forecast ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_depreciation_method ad_org_id numeric 10 Organizational entity within client
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 DepreciationType
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 Client/Tenant for this installation.
a_depreciation_table_detail ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_depreciation_table_header ad_org_id numeric 10 Organizational entity within client
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 10 (0)::numeric Life Years
a_depreciation_workfile a_asset_life_years_f numeric 10 (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 Client/Tenant for this installation.
a_depreciation_workfile ad_org_id numeric 10 Organizational entity within client
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 10 (0)::numeric Years of the usable life of the asset
a_depreciation_workfile uselifeyears_f numeric 10 (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 Client/Tenant for this installation.
a_fundingmode ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
a_fundingmode_acct ad_org_id numeric 10 Organizational entity within client
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 Client/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 client
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 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 Client 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 email 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 Client/Tenant for this installation.
c_acctschema ad_org_id numeric 10 Organizational entity within client
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 Client/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 client
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 Client/Tenant for this installation.
c_bpartner_location ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_calendar ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_charge ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_currency ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_invoiceline ad_org_id numeric 10 Organizational entity within client
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 IsFixedAssetInvoice
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 Client/Tenant for this installation.
c_location ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_period ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_uom ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
c_year ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
m_inoutline ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
m_locator ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
m_movementline ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within client
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 40 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 Client/Tenant for this installation.
m_product_category ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
m_productdownload ad_org_id numeric 10 Organizational entity within client
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 Client/Tenant for this installation.
r_mailtext ad_org_id numeric 10 Organizational entity within client
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