Window: Asset
[Created: 23/01/2003 - Updated: 17/06/2010 ]
Description: Asset used internally or by customers
Help: An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset.
Tab: Asset
[Created: 23/01/2003 - Updated: 20/06/2010 ]
Description: Asset used internally or by customers
Help: An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset.
Tab Level: 0
Table 10: Asset - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset.AD_Org_ID numeric(10) Table Direct |
| Search Key | Search key for the record in the format required - must be unique | A search key allows you a fast method of finding a particular record.If you leave the search key empty, the system automatically creates a numeric number. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order). | a_asset.Value character varying(40) String |
| Inventory No | a_asset.InventoryNo character varying(30) String | ||
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | a_asset.Name character varying(60) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | a_asset.Description character varying(255) String |
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | a_asset.Help character varying(2000) Text |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | a_asset.IsActive character(1) Yes-No |
| Parent Asset | a_asset.A_Parent_Asset_ID numeric(10) Search | ||
| Asset Group | Group of Assets | The group of assets determines default accounts. If an asset group is selected in the product category, assets are created when delivering the asset. | a_asset.A_Asset_Group_ID numeric(10) Search |
| Version No | Version Number | a_asset.VersionNo character varying(20) String | |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | a_asset.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | a_asset.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Serial No | Product Serial Number | The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | a_asset.SerNo character varying(255) String |
| Manufactured Year | a_asset.ManufacturedYear numeric(10) Integer | ||
| Lot No | Lot number (alphanumeric) | The Lot Number indicates the specific lot that a product was part of. | a_asset.Lot character varying(255) String |
| In Service Date | Date when Asset was put into service | The date when the asset was put into service - usually used as start date for depreciation. | a_asset.AssetServiceDate timestamp without time zone Date |
| Guarantee Date | Date when guarantee expires | Date when the normal guarantee or availability expires | a_asset.GuaranteeDate timestamp without time zone Date |
| Create Date | a_asset.A_Asset_CreateDate timestamp without time zone Date | ||
| Revaluation Date | a_asset.A_Asset_RevalDate timestamp without time zone Date | ||
| Project | Financial Project | A Project allows you to track and control internal or external activities. | a_asset.C_Project_ID numeric(10) Search |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | a_asset.C_Activity_ID numeric(10) Table Direct |
| In Possession | The asset is in the possession of the organization | Assets which are not in possession are e.g. at Customer site and may or may not be owned by the company. | a_asset.IsInPosession character(1) Yes-No |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | a_asset.C_BPartner_ID numeric(10) Search |
| Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | a_asset.C_BPartner_Location_ID numeric(10) Table Direct |
| User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | a_asset.AD_User_ID numeric(10) Table Direct |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | a_asset.M_Locator_ID numeric(10) Locator (WH) |
| BPartner (Agent) | Business Partner (Agent or Sales Rep) | a_asset.C_BPartnerSR_ID numeric(10) Search | |
| Address | Location or Address | The Location / Address field defines the location of an entity. | a_asset.C_Location_ID numeric(10) Location (Address) |
| Location comment | Additional comments or remarks concerning the location | a_asset.LocationComment character varying(255) String | |
| Owned | The asset is owned by the organization | The asset may not be in possession, but the asset is legally owned by the organization | a_asset.IsOwned character(1) Yes-No |
| Lessor | The Business Partner who rents or leases | a_asset.Lease_BPartner_ID numeric(10) Search | |
| Lease Termination | Lease Termination Date | Last Date of Lease | a_asset.LeaseTerminationDate timestamp without time zone Date |
| Depreciate | The asset will be depreciated | The asset is used internally and will be depreciated | a_asset.IsDepreciated character(1) Yes-No |
| Fully depreciated | The asset is fully depreciated | The asset costs are fully amortized. | a_asset.IsFullyDepreciated character(1) Yes-No |
| Life use | Units of use until the asset is not usable anymore | Life use and the actual use may be used to calculate the depreciation | a_asset.LifeUseUnits numeric Integer |
| Use units | Currently used units of the assets | a_asset.UseUnits numeric Integer | |
| Last Maintenance | Last Maintenance Date | a_asset.LastMaintenanceDate timestamp without time zone Date | |
| Last Unit | Last Maintenance Unit | a_asset.LastMaintenanceUnit numeric(10) Integer | |
| Last Note | Last Maintenance Note | a_asset.LastMaintenanceNote character varying(60) String | |
| Next Maintenance | Next Maintenance Date | a_asset.NextMaintenenceDate timestamp without time zone Date | |
| Next Unit | Next Maintenance Unit | a_asset.NextMaintenenceUnit numeric(10) Integer | |
| Asset Status | a_asset.A_Asset_Status character varying(2) List | ||
| Activation Date | a_asset.AssetActivationDate timestamp without time zone Date | ||
| Asset Depreciation Date | Date of last depreciation | Date of the last deprecation, if the asset is used internally and depreciated. | a_asset.AssetDepreciationDate timestamp without time zone Date |
| Disposed | The asset is disposed | The asset is no longer used and disposed | a_asset.IsDisposed character(1) Yes-No |
| Asset Disposal Date | Date when the asset is/was disposed | a_asset.AssetDisposalDate timestamp without time zone Date |
Tab: Product
[Created: 17/06/2010 - Updated: 19/05/2011 ]
Description:
Help:
Tab Level: 1
Table 11: Product - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_product.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_product.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_product.A_Asset_ID numeric(10) Search |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | a_asset_product.IsActive character(1) Yes-No |
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | a_asset_product.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | a_asset_product.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Current Qty | a_asset_product.A_QTY_Current numeric Quantity | ||
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | a_asset_product.M_Locator_ID numeric(10) Locator (WH) |
| Description | Optional short description of the record | A description is limited to 255 characters. | a_asset_product.Description character varying(255) String |
Tab: Asset Balances
[Created: 30/05/2008 - Updated: 17/06/2010 ]
Description: Asset Balance Report and Adjustments
Help:
Tab Level: 1
Table 12: Asset Balances - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_depreciation_workfile.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_depreciation_workfile.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_depreciation_workfile.A_Asset_ID numeric(10) Search |
| Description | Optional short description of the record | A description is limited to 255 characters. | a_depreciation_workfile.Description character varying(255) String |
| Asset Cost | a_depreciation_workfile.A_Asset_Cost numeric Amount | ||
| Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | a_depreciation_workfile.PostingType character(1) List |
| Asset Salvage Value | a_depreciation_workfile.A_Salvage_Value numeric Amount | ||
| Accumulated Depreciation | a_depreciation_workfile.A_Accumulated_Depr numeric Amount | ||
| Accumulated Depreciation (fiscal) | a_depreciation_workfile.A_Accumulated_Depr_F numeric Amount | ||
| Remaining Amt | a_depreciation_workfile.A_Asset_Remaining numeric Amount | ||
| Remaining Amt (fiscal) | a_depreciation_workfile.A_Asset_Remaining_F numeric Amount | ||
| Usable Life - Years | Years of the usable life of the asset | a_depreciation_workfile.UseLifeYears numeric Number | |
| Use Life - Years (fiscal) | a_depreciation_workfile.UseLifeYears_F numeric Number | ||
| Usable Life - Months | Months of the usable life of the asset | a_depreciation_workfile.UseLifeMonths numeric(10) Integer | |
| Use Life - Months (fiscal) | a_depreciation_workfile.UseLifeMonths_F numeric(10) Integer | ||
| Depreciate | The asset will be depreciated | The asset is used internally and will be depreciated | a_depreciation_workfile.IsDepreciated character(1) Yes-No |
| Current Period | a_depreciation_workfile.A_Current_Period numeric(10) Integer | ||
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | a_depreciation_workfile.DateAcct timestamp without time zone Date |
| Update depreciation | a_depreciation_workfile.Processing character(1) Button | ||
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | a_depreciation_workfile.C_AcctSchema_ID numeric(10) Table Direct |
Tab: Accounting Setup
[Created: 30/05/2008 - Updated: 17/06/2010 ]
Description: Enter accounting setup information
Help:
Tab Level: 1
Table 14: Accounting Setup - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_acct.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_acct.AD_Org_ID numeric(10) Table Direct |
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | a_asset_acct.C_AcctSchema_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_acct.A_Asset_ID numeric(10) Search |
| Valid from | Valid from including this date (first day) | The Valid From date indicates the first day of a date range | a_asset_acct.ValidFrom timestamp without time zone Date |
| Asset Salvage Value | a_asset_acct.A_Salvage_Value numeric Amount | ||
| Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | a_asset_acct.PostingType character(1) List |
| Depreciation | a_asset_acct.A_Depreciation_ID numeric(10) Table | ||
| Depreciation (fiscal) | a_asset_acct.A_Depreciation_F_ID numeric(10) Table | ||
| Asset Acct | a_asset_acct.A_Asset_Acct numeric(10) Account | ||
| Accumulated Depreciation Account | a_asset_acct.A_Accumdepreciation_Acct numeric(10) Account | ||
| Depreciation Account | a_asset_acct.A_Depreciation_Acct numeric(10) Account | ||
| Disposal Revenue Acct | a_asset_acct.A_Disposal_Revenue_Acct numeric(10) Account | ||
| Disposal Loss Acct | a_asset_acct.A_Disposal_Loss_Acct numeric(10) Account |
Tab: Activation/Addition
[Created: 17/06/2010 - Updated: 19/05/2011 ]
Description: Activation/Addition
Help:
Tab Level: 1
Table 15: Activation/Addition - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_addition.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_addition.AD_Org_ID numeric(10) Table Direct |
| Document No | Document sequence number of the document | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "".If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_", where TableName is the actual name of the table (e.g. C_Order). | a_asset_addition.DocumentNo character varying(30) String |
| Create Asset | a_asset_addition.A_CreateAsset character(1) Yes-No | ||
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_addition.A_Asset_ID numeric(10) Search |
| Document Date | Date of the Document | The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date. | a_asset_addition.DateDoc timestamp without time zone Date |
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | a_asset_addition.DateAcct timestamp without time zone Date |
| Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | a_asset_addition.PostingType character(1) List |
| Capital/Expense | a_asset_addition.A_CapvsExp character varying(3) List | ||
| Source Type | a_asset_addition.A_SourceType character varying(3) List | ||
| Invoice | Invoice Identifier | The Invoice Document. | a_asset_addition.C_Invoice_ID numeric(10) Search |
| Invoice Line | Invoice Detail Line | The Invoice Line uniquely identifies a single line of an Invoice. | a_asset_addition.C_InvoiceLine_ID numeric(10) Search |
| Match Invoice | Match Shipment/Receipt to Invoice | a_asset_addition.M_MatchInv_ID numeric(10) Search | |
| Shipment/Receipt Line | Line on Shipment or Receipt document | The Shipment/Receipt Line indicates a unique line in a Shipment/Receipt document | a_asset_addition.M_InOutLine_ID numeric(10) Search |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | a_asset_addition.C_Project_ID numeric(10) Search |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | a_asset_addition.C_Charge_ID numeric(10) Search |
| Imported Fixed Asset | a_asset_addition.I_FixedAsset_ID numeric(10) Search | ||
| Product | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | a_asset_addition.M_Product_ID numeric(10) Search |
| Attribute Set Instance | Product Attribute Set Instance | The values of the actual Product Attribute Instances. The product level attributes are defined on Product level. | a_asset_addition.M_AttributeSetInstance_ID numeric(10) Product Attribute |
| Locator | Warehouse Locator | The Locator indicates where in a Warehouse a product is located. | a_asset_addition.M_Locator_ID numeric(10) Locator (WH) |
| Description | Optional short description of the record | A description is limited to 255 characters. | a_asset_addition.Description character varying(510) String |
| Source Amount | a_asset_addition.AssetSourceAmt numeric Amount | ||
| Asset value | Book Value of the asset | a_asset_addition.AssetValueAmt numeric Amount | |
| Entered Amount | a_asset_addition.AssetAmtEntered numeric Amount | ||
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | a_asset_addition.C_Currency_ID numeric(10) Table Direct |
| Current Qty | a_asset_addition.A_QTY_Current numeric Number | ||
| Accumulated Depreciation | a_asset_addition.A_Accumulated_Depr numeric Amount | ||
| Accumulated Depreciation (fiscal) | a_asset_addition.A_Accumulated_Depr_F numeric Amount | ||
| Delta Use Life Years | a_asset_addition.DeltaUseLifeYears numeric(10) Integer | ||
| Delta Use Life Years (fiscal) | Delta Use Life Years (fiscal) | a_asset_addition.DeltaUseLifeYears_F numeric(10) Integer | |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | a_asset_addition.Processed character(1) Yes-No |
| Document Status | The current status of the document | The Document Status indicates the status of a document at this time. If you want to change the document status, use the Document Action field | a_asset_addition.DocStatus character varying(2) List |
| Asset Addition Process | a_asset_addition.DocAction character(2) Button |
Tab: Disposal
[Created: 17/06/2010 - Updated: 19/05/2011 ]
Description:
Help:
Tab Level: 1
Table 16: Disposal - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_disposed.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_disposed.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_disposed.A_Asset_ID numeric(10) Search |
| Disposed Method | a_asset_disposed.A_Disposed_Method character varying(2) List | ||
| Disposed Date | a_asset_disposed.A_Disposed_Date timestamp without time zone Date | ||
| Document Date | Date of the Document | The Document Date indicates the date the document was generated. It may or may not be the same as the accounting date. | a_asset_disposed.DateDoc timestamp without time zone Date |
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | a_asset_disposed.DateAcct timestamp without time zone Date |
| Asset Proceeds | a_asset_disposed.A_Proceeds numeric Amount | ||
| Asset Trade | a_asset_disposed.A_Asset_Trade_ID numeric(10) Search | ||
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | a_asset_disposed.IsActive character(1) Yes-No |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | a_asset_disposed.Processed character(1) Yes-No |
Tab: Asset History
[Created: 30/05/2008 - Updated: 20/06/2010 ]
Description: Detail asset transaction history
Help:
Tab Level: 1
Table 25: Asset History - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_change.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_change.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_change.A_Asset_ID numeric(10) Search |
| Details | a_asset_change.TextDetails character varying(60) String | ||
| Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | a_asset_change.PostingType character varying(10) List |
| Change Type | a_asset_change.ChangeType character varying(3) List | ||
| Created | Date this record was created | The Created field indicates the date that this record was created. | a_asset_change.Created timestamp without time zone Date+Time |
| Updated By | User who updated this records | The Updated By field indicates the user who updated this record. | a_asset_change.UpdatedBy numeric(10) Search |
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | a_asset_change.C_AcctSchema_ID numeric(10) Table Direct |
| A_Period_Start | a_asset_change.A_Period_Start numeric(10) Integer | ||
| A_Period_End | a_asset_change.A_Period_End numeric(10) Integer | ||
| A_Depreciation_Manual_Amount | a_asset_change.A_Depreciation_Manual_Amount numeric Amount | ||
| A_Depreciation_Manual_Period | a_asset_change.A_Depreciation_Manual_Period character varying(2) List | ||
| Variable Percent | a_asset_change.A_Depreciation_Variable_Perc numeric Number | ||
| A_Depreciation_Table_Header_ID | a_asset_change.A_Depreciation_Table_Header_ID numeric(10) Table | ||
| Spread Type | a_asset_change.A_Asset_Spread_Type character varying(10) Table | ||
| Asset Salvage Value | a_asset_change.A_Salvage_Value numeric Amount | ||
| Split Percent | a_asset_change.A_Split_Percent numeric Number | ||
| Owned | The asset is owned by the organization | The asset may not be in possession, but the asset is legally owned by the organization | a_asset_change.IsOwned character(1) Yes-No |
| In Possession | The asset is in the possession of the organization | Assets which are not in possession are e.g. at Customer site and may or may not be owned by the company. | a_asset_change.IsInPosession character(1) Yes-No |
| Depreciate | The asset will be depreciated | The asset is used internally and will be depreciated | a_asset_change.IsDepreciated character(1) Yes-No |
| Fully depreciated | The asset is fully depreciated | The asset costs are fully amortized. | a_asset_change.IsFullyDepreciated character(1) Yes-No |
| Disposed | The asset is disposed | The asset is no longer used and disposed | a_asset_change.IsDisposed character(1) Yes-No |
| A_Reval_Cal_Method | a_asset_change.A_Reval_Cal_Method character varying(3) List | ||
| Change Amt | a_asset_change.ChangeAmt numeric Amount | ||
| Asset value | Book Value of the asset | a_asset_change.AssetValueAmt numeric Amount | |
| Asset Book Value Amt | a_asset_change.AssetBookValueAmt numeric Amount | ||
| Asset Accum Depreciation Amt | a_asset_change.AssetAccumDepreciationAmt numeric Amount | ||
| Market value Amount | Market value of the asset | For reporting, the market value of the asset | a_asset_change.AssetMarketValueAmt numeric Amount |
| A_QTY_Original | a_asset_change.A_QTY_Original numeric Number | ||
| Current Qty | a_asset_change.A_QTY_Current numeric Number | ||
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | a_asset_change.DateAcct timestamp without time zone Date |
| Create Date | a_asset_change.A_Asset_CreateDate timestamp without time zone Date | ||
| In Service Date | Date when Asset was put into service | The date when the asset was put into service - usually used as start date for depreciation. | a_asset_change.AssetServiceDate timestamp without time zone Date |
| Asset Depreciation Date | Date of last depreciation | Date of the last deprecation, if the asset is used internally and depreciated. | a_asset_change.AssetDepreciationDate timestamp without time zone Date |
| Revaluation Date | a_asset_change.A_Asset_RevalDate timestamp without time zone Date | ||
| Asset Disposal Date | Date when the asset is/was disposed | a_asset_change.AssetDisposalDate timestamp without time zone Date | |
| Usable Life - Years | Years of the usable life of the asset | a_asset_change.UseLifeYears numeric Number | |
| Usable Life - Months | Months of the usable life of the asset | a_asset_change.UseLifeMonths numeric(10) Integer | |
| Life use | Units of use until the asset is not usable anymore | Life use and the actual use may be used to calculate the depreciation | a_asset_change.LifeUseUnits numeric(10) Integer |
| Use units | Currently used units of the assets | a_asset_change.UseUnits numeric(10) Integer | |
| Parent Asset | a_asset_change.A_Parent_Asset_ID numeric(10) Search | ||
| User/Contact | User within the system - Internal or Business Partner Contact | The User identifies a unique user in the system. This could be an internal user or a business partner contact | a_asset_change.AD_User_ID numeric(10) Search |
| Address | Location or Address | The Location / Address field defines the location of an entity. | a_asset_change.C_Location_ID numeric(10) Location (Address) |
| Lot No | Lot number (alphanumeric) | The Lot Number indicates the specific lot that a product was part of. | a_asset_change.Lot character varying(40) String |
| Serial No | Product Serial Number | The Serial Number identifies a tracked, warranted product. It can only be used when the quantity is 1. | a_asset_change.SerNo character varying(40) String |
| Version No | Version Number | a_asset_change.VersionNo character varying(40) String | |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | a_asset_change.C_BPartner_ID numeric(10) Search |
| Partner Location | Identifies the (ship to) address for this Business Partner | The Partner address indicates the location of a Business Partner | a_asset_change.C_BPartner_Location_ID numeric(10) Table |
| Asset Acct | a_asset_change.A_Asset_Acct numeric(10) Account | ||
| Depreciation Account | a_asset_change.A_Depreciation_Acct numeric(10) Account | ||
| Accumulated Depreciation Account | a_asset_change.A_Accumdepreciation_Acct numeric(10) Account | ||
| Disposal Revenue Acct | a_asset_change.A_Disposal_Revenue_Acct numeric(10) Account | ||
| Disposal Loss Acct | a_asset_change.A_Disposal_Loss_Acct numeric(10) Account | ||
| Revaluation Cost Offset for Current Year | a_asset_change.A_Reval_Cost_Offset numeric(10) Integer | ||
| Reval Cost Offset Acct | a_asset_change.A_Reval_Cost_Offset_Acct numeric(10) Integer | ||
| Revaluation Cost Offset for Prior Year | a_asset_change.A_Reval_Cost_Offset_Prior numeric(10) Integer | ||
| Reval Cost Offset Prior Acct | a_asset_change.A_Reval_Cost_Offset_Prior_Acct numeric(10) Integer | ||
| Revaluation Accumulated Depreciation Offset for Current Year | a_asset_change.A_Reval_Accumdep_Offset_Cur numeric(10) Integer | ||
| A_Reval_Accumdep_Offset_Cur | a_asset_change.A_Reval_Adep_Offset_Cur_Acct numeric(10) Integer | ||
| Revaluation Accumulated Depreciation Offset for Prior Year | a_asset_change.A_Reval_Accumdep_Offset_Prior numeric(10) Integer | ||
| A_Reval_Accumdep_Offset_Prior | a_asset_change.A_Reval_Adep_Offset_Prior_Acct numeric(10) Integer | ||
| Reval Depexp Offset Acct | a_asset_change.A_Reval_Depexp_Offset_Acct numeric(10) Integer | ||
| Revaluation Expense Offs | a_asset_change.A_Reval_Depexp_Offset numeric(10) Integer | ||
| A_Asset_Change_ID | a_asset_change.A_Asset_Change_ID numeric(10) ID |
Tab: Issue Project
[Created: 31/12/2005 - Updated: 20/06/2010 ]
Description: Automatic Issue Reporting
Help:
Tab Level: 1
Table 30: Issue Project - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | r_issueproject.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | r_issueproject.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | r_issueproject.A_Asset_ID numeric(10) Search |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | r_issueproject.C_Project_ID numeric(10) Search |
| Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | r_issueproject.Name character varying(120) String |
| Description | Optional short description of the record | A description is limited to 255 characters. | r_issueproject.Description character varying(255) String |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | r_issueproject.IsActive character(1) Yes-No |
| System Status | Status of the system - Support priority depends on system status | System status helps to prioritize support resources | r_issueproject.SystemStatus character(1) List |
| Statistics | Information to help profiling the system for solving support issues | Profile information do not contain sensitive information and are used to support issue detection and diagnostics as well as general anonymous statistics | r_issueproject.StatisticsInfo character varying(60) String |
| Profile | Information to help profiling the system for solving support issues | Profile information do not contain sensitive information and are used to support issue detection and diagnostics | r_issueproject.ProfileInfo character varying(4000) String |
Tab: Finance Information
[Created: 30/05/2008 - Updated: 19/05/2011 ]
Description: Finace Information for the Asset
Help:
Tab Level: 1
Table 35: Finance Information - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_info_fin.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_info_fin.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_info_fin.A_Asset_ID numeric(10) Search |
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | a_asset_info_fin.IsActive character(1) Yes-No |
| Asset Finance Method | a_asset_info_fin.A_Finance_Meth character varying(2) List | ||
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | a_asset_info_fin.C_BPartner_ID numeric(10) Search |
| Contract Date | a_asset_info_fin.A_Contract_Date timestamp without time zone Date | ||
| Asset Expired Date | a_asset_info_fin.A_Expired_Date timestamp without time zone Date | ||
| Asset Monthly Payment | a_asset_info_fin.A_Monthly_Payment numeric Amount | ||
| Asset Due On | a_asset_info_fin.A_Due_On character varying(22) List | ||
| Purchase Option | a_asset_info_fin.A_Purchase_Option character(1) Yes-No | ||
| Purchase Price | a_asset_info_fin.A_Purchase_Price numeric Amount | ||
| Purchase Option Credit | a_asset_info_fin.A_Purchase_Option_Credit numeric(10) Integer | ||
| Purchase Option Credit % | a_asset_info_fin.A_Purchase_Option_Credit_Per numeric Number | ||
| Text Message | Text Message | a_asset_info_fin.TextMsg character varying(510) Text |
Tab: License Information
[Created: 30/05/2008 - Updated: 19/05/2011 ]
Description: License Information for Asset
Help:
Tab Level: 1
Table 40: License Information - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_info_lic.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_info_lic.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_info_lic.A_Asset_ID numeric(10) Search |
| Description | a_asset_info_lic.Text character varying(510) String | ||
| Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. | a_asset_info_lic.IsActive character(1) Yes-No |
| Account State | State of the Credit Card or Account holder | The State of the Credit Card or Account holder | a_asset_info_lic.A_State character varying(60) String |
| Issuing Agency | a_asset_info_lic.A_Issuing_Agency character varying(22) String | ||
| Asset License No | a_asset_info_lic.A_License_No character varying(120) String | ||
| Asset License Fee | a_asset_info_lic.A_License_Fee numeric Amount | ||
| Asset Renewal Date | a_asset_info_lic.A_Renewal_Date timestamp without time zone Date |
Tab: Insurance Information
[Created: 30/05/2008 - Updated: 20/06/2010 ]
Description: Insurance Information for asset
Help:
Tab Level: 1
Table 45: Insurance Information - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_info_ins.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_info_ins.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_info_ins.A_Asset_ID numeric(10) ID |
| Insurance Company | a_asset_info_ins.A_Insurance_Co character varying(22) String | ||
| Asset Policy No | a_asset_info_ins.A_Policy_No character varying(100) String | ||
| Asset Renewal Date | a_asset_info_ins.A_Renewal_Date timestamp without time zone Date | ||
| Asset Insurance Premium | a_asset_info_ins.A_Ins_Premium numeric Amount | ||
| Asset Replace Cost | a_asset_info_ins.A_Replace_Cost numeric Amount | ||
| Asset Insurance Value | a_asset_info_ins.A_Ins_Value numeric Amount | ||
| Description | a_asset_info_ins.Text character varying(510) String |
Tab: Tax Information
[Created: 30/05/2008 - Updated: 20/06/2010 ]
Description: Tax information for asset
Help:
Tab Level: 1
Table 50: Tax Information - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_info_tax.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_info_tax.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_info_tax.A_Asset_ID numeric(10) ID |
| Asset Tax Entity | a_asset_info_tax.A_Tax_Entity character varying(22) String | ||
| Account State | State of the Credit Card or Account holder | The State of the Credit Card or Account holder | a_asset_info_tax.A_State character varying(60) String |
| Asset New Used | a_asset_info_tax.A_New_Used character(1) Yes-No | ||
| Asset Finance Method | a_asset_info_tax.A_Finance_Meth character varying(2) List | ||
| Asset Investment CR | a_asset_info_tax.A_Investment_CR numeric(10) Integer | ||
| Text Message | Text Message | a_asset_info_tax.TextMsg character varying(510) String |
Tab: Other Information
[Created: 30/05/2008 - Updated: 20/06/2010 ]
Description: Other information associated with asset
Help:
Tab Level: 1
Table 55: Other Information - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | a_asset_info_oth.AD_Client_ID numeric(10) Table Direct |
| Organization | Organizational entity within tenant | An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. | a_asset_info_oth.AD_Org_ID numeric(10) Table Direct |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_asset_info_oth.A_Asset_ID numeric(10) ID |
| A_User1 | a_asset_info_oth.A_User1 character varying(3) String | ||
| A_User10 | a_asset_info_oth.A_User10 character varying(3) String | ||
| A_User2 | a_asset_info_oth.A_User2 character varying(3) String | ||
| A_User11 | a_asset_info_oth.A_User11 character varying(10) String | ||
| A_User3 | a_asset_info_oth.A_User3 character varying(3) String | ||
| A_User12 | a_asset_info_oth.A_User12 character varying(10) String | ||
| A_User4 | a_asset_info_oth.A_User4 character varying(3) String | ||
| A_User13 | a_asset_info_oth.A_User13 character varying(10) String | ||
| A_User5 | a_asset_info_oth.A_User5 character varying(3) String | ||
| A_User14 | a_asset_info_oth.A_User14 character varying(10) String | ||
| A_User6 | a_asset_info_oth.A_User6 character varying(3) String | ||
| A_User15 | a_asset_info_oth.A_User15 character varying(10) String | ||
| A_User7 | a_asset_info_oth.A_User7 character varying(3) String | ||
| A_User8 | a_asset_info_oth.A_User8 character varying(3) String | ||
| A_User9 | a_asset_info_oth.A_User9 character varying(3) String | ||
| Description | a_asset_info_oth.Text character varying(510) Memo |
Tab: Expense
[Created: 17/06/2010 - Updated: 19/05/2011 ]
Description:
Help:
Tab Level: 1
Table 65: Expense - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Entry Type | a_depreciation_exp.A_Entry_Type character varying(3) List | ||
| Description | Optional short description of the record | A description is limited to 255 characters. | a_depreciation_exp.Description character varying(255) String |
| Expense | a_depreciation_exp.Expense numeric Amount | ||
| Expense (fiscal) | a_depreciation_exp.Expense_F numeric Amount | ||
| Account (debit) | Account used | The (natural) account used | a_depreciation_exp.DR_Account_ID numeric(10) Account |
| Account (credit) | Account used | The (natural) account used | a_depreciation_exp.CR_Account_ID numeric(10) Account |
| Asset Period | a_depreciation_exp.A_Period numeric(10) Integer | ||
| Account Date | Accounting Date | The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. | a_depreciation_exp.DateAcct timestamp without time zone Date |
| Posting Type | The type of posted amount for the transaction | The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. | a_depreciation_exp.PostingType character(1) List |
| Asset | Asset used internally or by customers | An asset is either created by purchasing or by delivering a product. An asset can be used internally or be a customer asset. | a_depreciation_exp.A_Asset_ID numeric(10) Search |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | a_depreciation_exp.Processed character(1) Yes-No |
| Process Depreciation Expense | a_depreciation_exp.Processing character(1) Button | ||
| Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | a_depreciation_exp.Help character varying(2000) Text |
| Asset Cost | a_depreciation_exp.A_Asset_Cost numeric Amount | ||
| Delta Asset Cost | a_depreciation_exp.A_Asset_Cost_Delta numeric Amount | ||
| Accumulated Depreciation | a_depreciation_exp.A_Accumulated_Depr numeric Amount | ||
| Accumulated Depreciation (delta) | a_depreciation_exp.A_Accumulated_Depr_Delta numeric Amount | ||
| Accumulated Depreciation (fiscal) | a_depreciation_exp.A_Accumulated_Depr_F numeric Amount | ||
| Accumulated Depreciation - fiscal (delta) | a_depreciation_exp.A_Accumulated_Depr_F_Delta numeric Amount | ||
| Remaining Amt | a_depreciation_exp.A_Asset_Remaining numeric Amount | ||
| Remaining Amt (fiscal) | a_depreciation_exp.A_Asset_Remaining_F numeric Amount | ||
| Usable Life - Months | Months of the usable life of the asset | a_depreciation_exp.UseLifeMonths numeric(10) Integer | |
| Use Life - Months (fiscal) | a_depreciation_exp.UseLifeMonths_F numeric(10) Integer | ||
| Asset Addition | a_depreciation_exp.A_Asset_Addition_ID numeric(10) Search | ||
| Asset Disposed | a_depreciation_exp.A_Asset_Disposed_ID numeric(10) Search | ||
| Accounting Schema | Rules for accounting | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | a_depreciation_exp.C_AcctSchema_ID numeric(10) Table Direct |