Skip to main content

Window: Cash Plan

[Created: 08/12/2010 - Updated: 03/06/2021 ]
Description:
Help:

Tab: Cash Plan

[Created: 08/12/2010 - Updated: 08/12/2010 ]
Description:
Help:
Tab Level: 0

Table 10: Cash Plan - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_cashplan.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_cashplan.AD_Org_ID numeric(10)
Table Direct
Document NoDocument sequence number of the documentThe 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).c_cashplan.DocumentNo character varying(30)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.c_cashplan.Description character varying(255)
Text
Document DateDate of the DocumentThe Document Date indicates the date the document was generated. It may or may not be the same as the accounting date.c_cashplan.DateDoc timestamp without time zone
Date
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonc_cashplan.C_BPartner_ID numeric(10)
Search
Sales TransactionThis is a Sales TransactionThe Sales Transaction checkbox indicates if this item is a Sales Transaction.c_cashplan.IsSOTrx character(1)
Yes-No
Cash Flow Typec_cashplan.CashFlowType character(1)
List
Generate Periodic Planc_cashplan.GeneratePeriodic character(1)
Button
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.c_cashplan.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingc_cashplan.C_Activity_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.c_cashplan.C_Campaign_ID numeric(10)
Table Direct
Trx OrganizationPerforming or initiating organizationThe organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.c_cashplan.AD_OrgTrx_ID numeric(10)
Table
User Element List 1User defined list element #1The user defined element displays the optional elements that have been defined for this account combination.c_cashplan.User1_ID numeric(10)
Search
User Element List 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.c_cashplan.User2_ID numeric(10)
Search
Grand TotalTotal amount of documentThe Grand Total displays the total amount including Tax and Freight in document currencyc_cashplan.GrandTotal numeric
Amount
Copy From Cash PlanCopy From Another Cash PlanCopy From Another Cash Planc_cashplan.CopyFrom character(1)
Button
ActiveThe record is active in the systemThere 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.c_cashplan.IsActive character(1)
Yes-No

Tab: Cash Plan Line

[Created: 08/12/2010 - Updated: 08/12/2010 ]
Description:
Help:
Tab Level: 1

Table 20: Cash Plan Line - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.c_cashplanline.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.c_cashplanline.AD_Org_ID numeric(10)
Table Direct
Cash Planc_cashplanline.C_CashPlan_ID numeric(10)
Search
Line NoUnique line for this documentIndicates the unique line for a document. It will also control the display order of the lines within a document.c_cashplanline.Line numeric(10)
Integer
Business PartnerIdentifies a Business PartnerA Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salespersonc_cashplanline.C_BPartner_ID numeric(10)
Search
Transaction DateTransaction DateThe Transaction Date indicates the date of the transaction.c_cashplanline.DateTrx timestamp without time zone
Date
ProductProduct, Service, ItemIdentifies an item which is either purchased or sold in this organization.c_cashplanline.M_Product_ID numeric(10)
Search
ChargeAdditional document chargesThe Charge indicates a type of Charge (Handling, Shipping, Restocking)c_cashplanline.C_Charge_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe 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.c_cashplanline.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.c_cashplanline.Description character varying(255)
Text
QuantityThe Quantity Entered is based on the selected UoMThe Quantity Entered is converted to base product UoM quantityc_cashplanline.QtyEntered numeric
Quantity
Probabilityc_cashplanline.Probability numeric
Number
Line TotalTotal line amount incl. TaxTotal line amountc_cashplanline.LineTotalAmt numeric
Amount
ProjectFinancial ProjectA Project allows you to track and control internal or external activities.c_cashplanline.C_Project_ID numeric(10)
Table Direct
ActivityBusiness ActivityActivities indicate tasks that are performed and used to utilize Activity based Costingc_cashplanline.C_Activity_ID numeric(10)
Table Direct
CampaignMarketing CampaignThe Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.c_cashplanline.C_Campaign_ID numeric(10)
Table Direct
Trx OrganizationPerforming or initiating organizationThe organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.c_cashplanline.AD_OrgTrx_ID numeric(10)
Table
User Element List 1User defined list element #1The user defined element displays the optional elements that have been defined for this account combination.c_cashplanline.User1_ID numeric(10)
Search
User Element List 2User defined list element #2The user defined element displays the optional elements that have been defined for this account combination.c_cashplanline.User2_ID numeric(10)
Search