个人财务管理系统说明书
财务管理手册说明书
SAMPLE FINANCIALPROCEDURES MANUALApproved by ___________ (organization’s) Board of Directors on ____________ (date)I. GENERAL1. The Board of Directors formulates financial policies, delegates administration of thefinancial policies to the Executive Director and reviews operations and activities.2. The Executive Director has management responsibility including financial management.3. Current job descriptions will be maintained for all employees, indicating financial dutiesand responsibilities.4. Financial duties and responsibilities must be separated so that no one employee hassole control over cash receipts; disbursements; payroll; reconciliation of bank accounts;etc.5. All employees involved with financial procedures shall take vacations or leaves of 5consecutive work days each year. During such periods, back-up personnel who havebeen cross-trained in their duties will perform their tasks.6. A blanket employee dishonesty coverage in the amount of $_________ shall bemaintained.7. Professional financial service providers will be established annually. For _______ (year)these include ___________ (accounting software), __________ (payroll services), the___________ (insurance), ____________ (banking), _______________ (restrictedinvestments and retirement services), and ______________ (auditors).8. The ___________ (staff position) will maintain a current and accurate log of the chart ofaccounts, job accounts and accounting classes.9. These policies and procedures will be reviewed bi-annually by the ___________ (BoardCommittee)II. CASH RECEIPTS (includes checks)1. The ____________ (staff position) opens any mail addressed to _____________(organization name) or without specific addressee. The receipt of checks or cash will berecorded in the accounting system. All other checks or cash will be immediatelyforwarded to the _________________ (staff position).2. The ___________ (staff position) will endorse all checks by rubber stamp to read asfollows:PAY TO THE ORDER OF________ BankAccount #FOR DEPOSIT ONLYOrganization NameAccount NumberThe endorsement stamp will specify into which corporate account (savings, checking) the deposit will be made.3. A report will be printed that includes the source and amount of the receipt as well as thetotal daily deposit amount.4. The checks and cash will then be forwarded to the _______________ (staff position), whowill complete deposit slips in duplicate. Receipts and deposit slip will be placed in an envelope for __________ (Bank).5. If no cash is present, the envelope may be sealed and sent through the US mail. If cashis present, the _______________ (staff position) will verify deposited funds prior tosealing the envelope and making the deposit in person.6. Documentation for all receipts (a copy of check, letter, etc.) will be attached to theduplicate slip and filed chronologically.7. All receipts will be deposited intact. No disbursements will be made from cash or checkreceipts prior to deposit.8. The ______________ (staff position) will record each cash payment received in a numberreceipt book with a duplicate for the payer. Cash shall be locked in a secure location until taken to the bank.9. The Executive Director will receive a copy of all deposit reports for review.10. Checks received at the _______ (other office) location will be endorsed as in #2 aboveand mailed to the mail office for processing. Receipts will be given for cash as in #8 above. Cash will be brought to the main office by a staff or board member.III. CASH DISBURSEMENTSA. CHECK AUTHORIZATION1. All invoices will be immediately forwarded to the ______________ (staff position) who willreview all invoices for mathematical accuracy, validity, conformity to the budget (or other board authorization) and compliance with bid requirements.2. Prior to payment, all invoices will be approved (indicated by initialing) by the________________ (staff position), who will code the invoice with an appropriateexpense or other chart of accounts line item number, class and job number (whereapplicable).a. By approving an invoice, the ______________ (staff position) indicates that it hasbeen reviewed by the ______________ (staff position) and authorizes a check.b. The _____________ (staff position) will ensure that all conditions and specificationson a contract or order have been satisfactorily fulfilled, including inventorying itemsreceived against packing slip counts. The ______________ (staff position) isresponsible for timely follow-up on discrepancies and payment.3. Approved invoices will be entered into the accounting system using the “Enter Bills”screen.4. The __________________ (staff position) will prepare checks on a weekly basis.5. Authorized signers on _____________ (organziation’s) accounts include the ExecutiveDirector, Chair and Treasurer of the Board.B. CHECKS1. The ________________ (staff position) will be responsible for all blank checks.2. All checks, including payroll checks (with the exception of direct deposit payroll items)will be signed by the Executive Director or designated members of the Board ofDirectors.3. The _______________ (staff position) will generate checks for approved invoices throughthe accounting system using “Pay Bills” and/or “Write Checks” screens whereappropriate.4. Voided checks will have "VOID" written boldly in ink on the face and have the signatureportion of the check torn out. Voided checks will be kept on file.5. In no event will:a. invoices be paid unless approved by an authorized signerb. blank checks (checks without a date or payee designated) be signed in advancec. checks be made out to "cash", "bearer", "petty cash", etc.d. checks be prepared on verbal authorization, unless approved by the ExecutiveDirector.6. In the event that it is necessary to issue a duplicate check for checks in an amount over$15, a stop payment will be ordered at the bank on the original check.C. BANK RECONCILIATIONS1. Bank statements will be received directly and opened by the _______________ (staffposition).2. The ________________ (staff position) will reconcile the bank statement monthly.3. The Treasurer of the Board will receive monthly statements of checks paid on allaccounts.4. The Executive Director shall verify the reconciliation of the bank accounts on at least aquarterly basis.5. On all checks outstanding over 90 days, the _____________ (staff position) should takeappropriate action.IV. PURCHASINGA. PURCHASES UNDER $5,0001. All purchases over $500 must be approved in advance by the Executive Director.2. The Project Director is responsible to know if the item ordered is within the budget andguidelines.3. If purchase is less than $150, persons authorized by the Project Director for immediatepurchase and delivery can make the purchase. When this is done, invoice copies are to be turned into the Project Director.B. PURCHASES OVER $5,0001. All purchases including services over $500 must be approved in advance by theExecutive Director.2. Purchases over $5000 will be required to undergo a competitive bid procedure.3. All bid requests will contain clear specifications and will not contain features which undulyrestrict competition.4. The Project Director will be responsible to ensure that all conditions and specifications ofa contract, bid, or order have been satisfactorily fulfilled and will be responsible fortimely follow-up of these purchases.5. The Project Director will obtain at least 3 bids wherever possible unless prior approvalby Executive Committee has been obtained.6. Purchases of over $5000 will not be fragmented or reduced to components of less than$5,000 to avoid the bid process.V. PAYROLLA. TIME SHEETS1. Each hourly employee will be responsible for completing a time sheet on a biweeklybasis.2. Completed time sheets will be dated and signed by the employee, time cards will bestapled to the back, and both will be submitted to the _____________ (staff position) atthe end of the last working day of each pay period.3. No payroll checks will be issued without a completed time sheet and time card ifrequired.4. Incomplete time sheets and cards will be returned to the employee for correction.5. The _______________ (staff position) will verify the accuracy of the time sheets andaddition.6. Employees will be paid every two weeks, deductions are itemized on each paycheck.B. PAYROLL1. The __________ (vendor name) Payroll System will enter payroll, print payroll checks,make direct deposit transfers print payroll reports and send reports to the ____________ (staff position).2. The _____________ (staff position) will review the payroll checks before they aredistributed.3. The ____________ (staff position) will distribute the payroll checks to the employees.Checks will not be issued to any person other than the employee without writtenauthorization from the employee.4. The _____________ (staff position) is responsible for entering payroll reports into theaccounting system.5. Voluntary terminations will be paid at regular pay date. Involuntary terminations will bepaid on day of separation.C. PAYROLL TAXES1. _______________ (staff position) will prepare and transmit the payroll tax reports, W-2forms, and 1099 forms.2. The _______________ (staff position) will verify payroll tax preparation on a quarterlybasis.D. BENEFITS1. Payroll will be prepared in accordance with the personnel policies and benefit plan. VI. TRAVEL & EXPENSES1. Each employee will complete an expense voucher if any traveling is done. Vouchershould include all expenses including credit card charges. Voucher will reflectreimbursement sources other than _____________ (organization).2. Mileage to and from residence will not be paid by _____________ (organization), exceptfor board members traveling from outside the Twin Cities to board meetings.3. The expense voucher will be submitted within 60 days for payment, with a total, signedby the employee, authorized for payment by the Executive Director.4. Reimbursement will be based upon current travel policies. Receipts must be attachedto the expense voucher for lodging, common carrier transportation, and receipts formeals where required.5. Incomplete expense vouchers will be returned.6. Employees and board members will be reimbursed for travel and other relatedexpenses at the rate set by the Board. The Executive Director must approve employee travel and workshop expenditures prior to their occurrence. The organization willreimburse no more than the standard mileage rate for the business use of a car asestablished by the IRS. _____________ (organization) will reimburse meal expensesincurred in direct connection with _____________ (organization) employment, or a perdiem rate of $___ per day. The mileage rate and per diem rate will be establishedannually by the board.VII. CONSULTANTS1. Consideration will be made of internal capabilities to accomplish services beforecontracting for them.2. Written contracts clearly defining work to be performed, terms and conditions will bemaintained for all consultant and contract services.3. The qualifications of the consultant and reasonableness of fees will be considered inhiring consultants.4. Consultant services will be paid for as work is performed or as delineated in the contract.5. The Board of Directors will approve audit and other significant contracts.6. The ________________ (staff position) will prepare 1099 returns for consultants at year-end.VIII. PROPERTYA. EQUIPMENT1. Equipment shall be defined as all items (purchased or donated) with a unit cost of $500or more and a useful life of more than one year.2. The _______________ (staff position) will maintain an inventory log; which shall list adescription of the item, date of purchase or acquisition, price or fair value of the item and its location.3. A depreciation schedule shall be prepared at least annually for the audited financialstatements.4. The _____________ (staff position) will record all equipment in the accounting system.An entry must be made whenever property is disposed of or acquired.IX. LEASESA. REAL ESTATE1. The Executive Director will review leases prior to submission to the Board of Directorsfor approval.2. All leases, clearly delineating terms and conditions, will be approved by the Board ofDirectors and signed by the Board Chair.3. The Executive Director will keep a copy of each lease on file.4. The Consulting Accountant will be notified of each lease and lease specifications, andwill make proper general journal entries for same.B. EQUIPMENT1. The Executive Director will review all leases.2. All leases, clearly delineating terms and conditions, will be approved and signed by theExecutive Director.3. The Executive Director will keep a copy of each lease on file.4. The Consulting Accountant will be notified of each lease and lease specifications, andwill make proper general journal entries for same.X. INSURANCE1. Reasonable, adequate coverage will be maintained to safeguard the assets of thecorporation. Such coverage will include property and liability, worker’s compensation, employee dishonesty and other insurance deemed necessary.2. The Executive Director will carefully review insurance policies before renewal.3. The Executive Director will maintain insurance policies in insurance files.4. Insurance policies will correspond to the calendar year whenever possible.5. The __________________ (staff position) will prepare and maintain an insurance register. XI. TELEPHONE1. Personal long distance or cellular phone calls made on _____________ (organization’s)telephones by employees must be logged with the _______________(staff position),indicating that it is a personal call. Employees will be billed on these calls.2. _____________ (organization) business calls from phones outside the office should bebilled to the _____________ (organization’s) telephone account.XII. BOOKS OF ORIGINAL ENTRY1. _____________ (organization will utilize a double entry system for accounting for allfunds.2. Adequate documentation will be maintained to support all general entries.3. At the end of each month, the ____________ (staff position) will prepare a BalanceSheet, Statement of Activities, and Statement of Activities by Project that will bereviewed by the Executive Director.4. The Statement of Activities report will include a comparison to the budget.5. _____________ (organization will maintain its accounting records on the accrual basis ina manner that facilitates the preparation of audited financial statements conforming togenerally accepted accounting principles.XIII. GRANTS AND CONTRACTS1. The Executive Director will carefully review each award and contract to ensurecompliance with all financial and programmatic provisions. The ____________ (staffposition) will maintain originals of all grants and contracts in a file. The ConsultingAccountant will prepare initial entries as appropriate to record each award.2. The ______________ (staff position) will prepare and maintain on a current basis aGrant/Contract Summary form for each grant or contract awarded to _____________(organization). This form shall include the name, address, contact person, and phonenumber for the funding organization; the time period applicable to expenditures; allsignificant covenants (such as bonding or liability insurance requirements) andrestrictions on expenditures; all require financial and program report and due dates; and the chart of accounts line item number for the revenue deposited.3. Payments for projects for which _____________ (organization serves as fiscal agentshall be paid out within one week.4. The Consulting Accountant will prepare financial reports to funding sources as required.5. The Executive Director will review and approve all reports to funding sources.6. It will be the responsibility of the Executive Director to insure that all financial reports aresubmitted on a timely basis.XIV. BUDGETS1. The Executive Director and the _______________(staff position) will prepare thefinancial budget.2. The __________________ (staff position) will insure that budgets are on file.3. The Board of Directors must approve proposed changes in the budget, should theyexceed $______ or _______% of the line item, whichever is greater.XV. LOANS1. The Board of Directors will approve loans.2. A promissory note will be prepared and signed by the Board Chair and another officerof the Board before funds are borrowed.XVI. OTHERA. MINUTES OF MEETINGS1. The Secretary of the Board will prepare accurate minutes of all meetings of the Board ofDirectors and committees.2. The Executive Director will note all items in the minutes relating to finance and takeappropriate action.B. NON-PROGRAM INCOME1. Donations of cash and non-program related income will be separately accounted for.C. ACCOUNTS RECEIVABLE1. Documentation will be maintained for accounts receivable.2. Accounts receivable will be recorded in the books and collected on a timely basis.D. FINANCIAL PROCEDURES1. Financial procedures will be reviewed bi-annually by the Finance Committee. TheBoard of Directors must approve changes to the financial procedure manual prior toimplementation.E. FORM 9901. 1.The Board of Directors in conjunction with the audit will authorize preparation of Form990. Form 990 will be signed by an officer of the Board.2. Copies of Form 990 will be files in the _____________ (staff position)’s files, and a copyof the _____________ (organization’s) Form 990 and Form 1023 shall be located at thefront desk for public inspection and/or copying.F. AUDITS1. The Board of Directors shall annually contract with an independent auditing firm a fullaudit of the books, to be completed prior to the following first of September.G. PERSONNEL FILES1. The _______________ (staff position) will maintain a personnel file for each employee,containing appropriate documents, such as the signed compensation agreement,approval of changes in compensation, an I-9 immigration form, and withholding forms for taxes, benefits, deferred compensation, and charitable contributions.H. FISCAL AGENT STATUS1. The _____________ (organization) executive committee must authorize all fiscalsponsorship arrangements, which are then approved by the board.2. All fiscal sponsorship arrangements will begin with a written agreement, stating the termsof the relationship and the purpose for the use of funds.3. Fiscal sponsorships will be limited to projects for which the _____________(organization’s) executive committee determines that the project is charitable andconsistent with the _____________ (organization’s) mission of strengthening the nonprofit sector, and that no real or perceived conflicts of interest exist with board or executivecommittee members.4. The _____________ (organization) will negotiate with the sponsored project a rate forindirect or direct costs to cover the _____________ (organization’s) expenses ofadministering the temporarily restricted fund.5. Sponsored projects will be required to submit full and complete quarterly and year endreports to the _____________ (organization) by the end of the _____________(organization’s)fiscal year, (date)_____________,: and must include:• detailed expenses using budget categories for original grant;• program accomplishments and activities;• lobbying expenditures; and• amount of remaining funds.6. Any changes in the purpose for which grant funds are spent must be approved in writingby the _____________ (organization) before implementation. The _____________(organization) retains the right, if sponsored project’s breaches the fiscal sponsorshipagreement, or if a sponsored project jeopardizes the _____________ (organization) legal or tax status, to withhold, withdraw, or demand immediate return of grant funds.7. The _____________ (organization’s) executive director will submit quarterly reports to theExecutive Committee, to be circulated to the entire board, on the status of active fiscal sponsorships.8. The _____________ (organization) will file appropriate tax forms for sponsored projects,including IRS form 1099.。
Oracle银行财务管理系统发布14.4.0.0.0版本说明书
Development Workbench - Notifications Oracle Banking Treasury ManagementRelease 14.4.0.0.0[April] [2020]Contents1Preface (3)1.1Audience (3)2Introduction (3)How to use this Guide (3)3Notification – Getting started (4)3.1What is Notification (4)3.2Notification Trigger (4)4Notification Development (4)4.1Pre-request for Notification development and testing (4)4.2Notification specification (5)4.3Notification XML development (5)4.4Notification Process (5)4.5Development process in Development Workbench (5)4.6Notification Trigger (6)4.7Notifications (12)5Deploy Notification (18)5.1Notification - Workbench related deployment (18)5.2Notification Trigger deployment (18)6Test Notification (18)6.1Notification flow (19)6.2Scheduler based notification (19)6.3MDB based notification flow (20)6.4Triggering notification and testing (21)1PrefaceThis document describes the steps to develop the notification XML and notification trigger using Oracle FLEXCUBE Development Workbench for Universal Banking.1.1AudienceThe Development Workbench Notification Development book is intended for theFLEXCUBE Application Developers who perform the following tasks:▪Develop new Notification2IntroductionHow to use this GuideThe information in this guide includes:▪Chapter 3, “Introduction”▪Chapter 4, “Notification - Getting started”▪Chapter 5, “Notification Development”▪Chapt er 6, “Deploy Notification”▪Chapt er 7, “Test Notification”3 Notification – Getting started3.1 What is NotificationNotification framework in FLEXCUBE UBS is used to communicate the business event happened in FLEXCUBE UBS to external systems. Depending upon the event, the XML message is pushed to external system ’s asynchronous Queues for their consumption.3.2 Notification TriggerNotification Triggers is developed to recognize the event and then invoke the notification process. This trigger is developed using Development Workbench. 4 Notification Development4.1 Pre-request for Notification development and testingFollowing are pre-request for notification development:∙ Target FLEXCUBE Environment with Notification framework installed ∙ Development Workbench link mapped to the FLEXCUBE environment ∙ Required Query Web services developed and testedFig 5.1.1: Development of NotificationsPrepare Specification DevelopNotification XML in WorkbenchDevelopNotification Trigger in Workbench Deploy the units in Target Test Notification4.2Notification specificationIdentify the notification requirement as below∙What is the Notification function ID name for RAD XML (Third character should be N)?∙What is the Notification code?∙What is the Base table in FLEXCUBE UBS that triggers the notification?o What operation at base table triggers (insert/update/delete)?o What is the where clause for filter?∙What is the query Web service to be used?o What is the operation?o What are the tags required?Example;∙Notification function ID name –STNCUMOD∙Notification code –NOTIF_CA_CUSTACC_MOD∙Base table - STTM_CUST_ACCOUNTo Operation –DELETEo Filter –Account class type in ( S , U )∙Web service to be used –FCUBSAccServiceo Operation –QueryCustAcco Request node –Cust-Account-IO4.3Notification XML developmentNotification RAD XML development creates the following files:∙RAD XML∙SPC∙SQL∙Static Data4.4Notification ProcessThere will be one trigger for the base table of notification and in case of multiplenotifications sharing the same base table, there will be no new triggers created. Instead the same trigger created on the base table will be reused. This approach reduces the number of triggers being used for notifications.4.5Development process in Development WorkbenchThe notification development process in Workbench is split into two steps:1.Notification Triggers2.Notification Filter ProcedureThe first step is to create notification triggers for base tables. The trigger generated from Workbench will be inserting key details into a static notification log table. The following details will be captured:∙Trigger code: A unique value to for a notification trigger.∙Base Table: The base table on which, the trigger is built.∙When Clause: A simple when clause for the notification trigger.The second step is to capture details of notifications and generate the notification filter procedure. The following details are captured:∙Notification code: A unique value to identify a notification.∙Description: Meaningful description of the notification.∙Gateway Service:4.6Notification TriggerAfter successful login to Development Workbench click on Notification Trigger option in the tree as shown below:Fig 4.6.1: Notification triggerFig 4.6.2: Notification trigger optionsNotification Trigger we have two options - Add a new Trigger or Modify Existing one. New:Fig 4.6.3: Notification trigger: New optionTrigger Code: A unique value to for a notification trigger. Follow the naming conversion it should start with TRG_XXXX.This is mandatory field. This attribute signifies the trigger code created as part of trigger creation step in OTD. Each notification will be linked to a trigger code.Description : Information field. Meaningful description of Trigger is to be given.Firing Time : Specify when trigger needs to fired. We can create only BEFORE and AFTER triggers for tables. (INSTEAD OF triggers are only available for views; typically they are used to implement view updates.) (After/Before). Each Record: specify for each row required or not. If FOR EACH ROW option is specified, the trigger is row-level; otherwise, the trigger is statement-level. (Yes/No)Base Table: The base table on which, the trigger is built. This is mandatory field. Select a valid table from available LOV next to the field.Pk Cols: Enter Primary key fields of table in tilde (~) separated format. This is mandatory field.Pk Types: Enter Primary key type of the corresponding primary key field. This is mandatory field.Selected Columns and Data Types: DefunctTrigger When Clause: A simple when clause for the notification trigger. A trigger restriction can be specified in the WHEN clause, enclosed by parentheses. The trigger restriction is a SQL condition that must be satisfied in order for Oracle to fire the trigger. This condition cannot contain sub queries. Without the WHEN clause, the trigger is fired for each row.Notification Codes: If the trigger is associated with a specific notification code, then the particular notification code has to be provided in the field. If the trigger is shared across many Notifications, field can be left emptyFig 4.6.4: Notification trigger: GenerationOn successful save Notification Trigger will generate two files (gwtr#_<trg-code>.trg and GWTM_NOTIFICATION_TRIGGERS__<trg-code>.INC) user needs to compile them in FLEXCUBE schema.Modify:Fig 4.6.5: Notification trigger: ModificationFig 4.6.6: Notification trigger: Modification- Selecting Trigger nameFig 4.6.7: Notification trigger: Modification- Entering valuesFig 4.6.8: Notification trigger: Modification- Entering valuesFig 4.6.9: Notification trigger: Modification- Successful Generation4.7NotificationsNotifications Screen will be used to create new notification or modify existingnotification; here we capture notification information for notification codes. We savenotification details into xml.Fig 4.7.1: Notification ScreenAction:. We can choose either new or Load action. New to create a new notification and Load is used to modify the existing one.Save Xml Path: Specify the path to save notification xml. This would be considered only if the Save Mode is Client and Work Directory is specified as $CURRENT_DIRECTORY Notification Function: Specify the notification function-id name.Conventions:Maximum 8 chars. 3rd letter must be ‘N’.Example: FTNCONONNotification Code: Enter the notification code to which we need to capture values. This is Mandatory field.Recommended Convention for Notification Codes:NOTIF_<Module Code>_<Description>Example:NOTIF_LD_CONTRACTThis is the notification indicating that a LD contract has been created/modified Description: Information field. Meaningful description of the Notification has to be provided in the fieldModule: This attribute signifies the module on which the notification is based.Module Description: Information field. Module Description which would be defaulted from Module LOVNotification XSD: Notification XSD name will have to be provided in the corresponding Field. Naming convention to be followed while naming Notification XSD is as follows [Module Name] – [Notification Description] – Notif.xsdExample: FT-Contract-Notif.xsdNotification XSD has to be provided only if no Gateway Web Service Query Operation is configured to the NotificationBase Table: Select the base table on which trigger needs to be applied.Firing Time: Indicates the Operation on the base Table for which Notifications has to be sent. Options available are Insert, Update or BothFilter Type: This attribute can take the following values.1.Where clause2.Plsql blockPk Cols: Enter Primary key columns of the Base Table.Pk Types: Enter Primary key field Data Types.Provide details of Gateway Service, Operation, Type XSD Name and Full Screen Reply if a Query Web Service has to be mapped to the NotificationGateway Operation: The gateway operation name to execute query for the mentioned Service.Gateway Service: The gateway service to be used to get the full screen response. Gateway IO Request: The gateway IO request node to be used in querying operation.Type XSD Name: This field has to be entered if Notification is mapped to a Service and Request. Name of the Master Type XSD for the service and operation has to be provided here. This can be found in include portion of the Request Msg XSD of particular Service-OperationExample: LC-Contract-Types.xsdFull screen Reply: This attribute decides whether full screen or primary key notification response to be sent. This is applicable only if gateway Service details are providedHO only: This attribute is used to send notification only from head office.Filter Logic: The filter logic which decides whether the notification needs to be sent or not. This can be a simple where-clause on base table or a complex pl/sql block.Web service Tags: The columns selected from base table as part of web service tags, will be used to send the full screen notification response. These tags defines the elements of Notification Xml when no Query service is mapped to it:Fig 4.7.2: Notification Screen generationFig 4.7.3: Notification Screen Generation SuccessfulModifying an Existing Notification RADXMLThe process of modifying an existing Notification RADXML is illustrated in the images belowFig 4.7.4: Notification Screen LoadingFig 4.7.5: Notification Screen LoadedFig 4.7.6: Notification Screen Loaded and Modified5Deploy Notification5.1Notification - Workbench related deploymentCompile the following files in Target FLEXCUBE UBS Database schema•Notification Main Package generated from ODT•Hook Packages•GWTM_NOTIFICATION_TAG_MAP___<Notification Function ID>_.INC •GWTM_NOTIFICATIONS_MASTER___<Notification Function ID>_.INC 5.2Notification Trigger deploymentCompile the following files in Target FLEXCUBE UBS Database schema•GWTM_NOTIFICATION_TRIGGERS__TRIG_CONTRACT.INC•GWTR#_TRIG_CONTRACT.TRG6Test NotificationThis section explains the run time notification flow and testing steps.6.1Notification flowThe notification process occurs as two parts:1.Oracle JOBs created using FCJ Scheduler framework that sends data required fornotification to an internal JMS queue.2.Gateway MBD that lists on internal JMS queue, that picks the notification XMLs andprepare full web service response and send to external system queues.6.2Scheduler based notificationThe Notification Process in FLEXCUBE can be done using the jobs scheduler as follows: The trigger generated from Workbench will be inserting key details into a staticnotification log (STTB_NOTIFICATION)Once Job is triggered, a request is sent to EJB layer from job execution class and thenotification log table will be polled for unprocessed records.Each unprocessed record is locked.The record is verified against the notification maintenance and checked whethernotification is to be sent or not.If notification is to be sent, pre notification message xml is built and it is sent to internal NOTIFY_QUEUE(JMS queue) configured in Gateway layer.The job is then rescheduled to fire next time based on the previous execution.Refer Gateway Installation documents on how to setup the Queues.Flow Chart for Notification Flow in Scheduler6.3MDB based notification flowNotification processes in MDB are as follows:1.Notification MDB listens on the internal NOTIFY_QUEUE(JMS queue)2.On any message received, the MDB identifies which schema to connect using theJNDI name being present as part of the message xml.3.Gateway notification processing package is called from MDB to build notifications.4.In MDB, the notifications built is processed and sent to the destination specified incorresponding notification.5.In case of exception the transaction is rolled back.6.If all notifications are successfully processed, transaction is committed.Flow Chart for Notification Flow in MDB6.4Triggering notification and testingFollow the below steps to test notification:∙Simulate a case where base table under goes data change.∙Check record populated at STTB_NOTIFICATION table∙Check Notification messageGWTBS_NOTIFICATIONS_LOG.NOTIFICATION_MESSAGE21 Development Workbench - Notifications22Development Workbench - Notifications Development Workbench - Notifications [April ] [2020] Version 14.4.0.0.0Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon (East) Mumbai, Maharashtra 400 063 IndiaWorldwide Inquiries: Phone: +91 22 6718 3000 Fax:+91 22 6718 3001 /financialservices/Copyright © 2007, 2020, Oracle and/or its affiliates. All rights reserved.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。
财务人员岗位职责说明书(共6篇)
财务人员岗位职责说明书〔共6篇〕第1篇：财务部岗位职责说明书1 财务部职能和职责1.1部门职能：根据企业会计准那么等相关法律法规和公司财务管理制度，履行财务制度体系建立、全面预算管理、会计核算管理、资金管理、应收账款控制、资产管理、本钱管理、税务管理和票务管理等财务工作职能，为实现企业战略目的和年度经营方案提供强有力的财务保障。
1.2部门职责：1.2.1严格执行各项财务管理制度。
1.2.2制定详细的会计核算标准、核算标准制度。
1.2.3开展决算、清算、汇算等会计核算工作。
1.2.4组织编制、审核各类财务报表、附注及财务分析^p 报告，编制、审核公司的会计凭证。
1.2.5牵头组织公司全面预算管理工作，审核各项超预算工程与预算外工程合规性、合理性。
1.2.6组织编制年度资金需求方案，拟定年度融资方案及财务费用预算表。
1.2.7建立和维护融资渠道，选择融资方式并制定公司融资方案，降低融资本钱。
1.2.8调度公司经营资金，制定和审批年度、月度运营资金使用方案。
1.2.9汇总、编制公司资金收支方案，合理调配资金，定期对资金使用情况进展分析^p 、反应。
编制应收账款明细，催促各项资金的回收。
1.2.10参与建立客户信誉体系建立。
根据客户的信誉等级，按合同条款及客户赊销信誉政策，审核、控制经营部的发货。
1.2.11制定存货、固定资产等资产盘点方案，并组织开展年度1 盘点工作。
1.2.12跟踪在建工程完工进度，及时对开工工程进展核对并完成相应的固定资产结转。
1.2.13审核存货收发业务单据、报表。
审核存货及资产报废。
1.2.14协助外部审计部门、税务部门完成固定资产盘点工作。
1.2.15组织公司税务筹划、税务申报与缴纳工作。
配合完成税务局对公司的税务检查。
1.2.16结合公司的实际需要，购置各种支票、收据、有价证券等相关单据。
1.2.17建立、完善部门各类管理规章制度、流程，并严格执行。
做好财税方面有关证照的年检，加强财务人员的培训和部门建立。
财务管理系统说明书
财务管理系统说明书一、概述财务管理系统是一款专门为企业开发的软件，旨在提供全面的财务管理功能，支持企业的财务核算、报表统计、预算控制以及财务分析等工作。
本系统通过集成企业各个部门的财务数据，实现了财务信息的集中管理和共享，提高了财务管理效率，为企业决策提供了可靠的依据。
二、系统功能2.1 财务核算本系统提供了完善的财务核算功能，包括以下子模块：2.1.1 总账管理：用于管理企业的资产负债表、利润表和现金流量表等财务报表，支持多级科目的设置和科目余额的查询。
2.1.2 应收应付：用于管理企业的应收账款和应付账款信息，支持账龄分析和逾期提醒功能，帮助企业及时催收款项。
2.1.3 成本核算：用于管理企业的成本信息，包括直接成本和间接成本的计算和分配，支持成本效益分析。
2.1.4 固定资产：用于管理企业的固定资产信息，包括购置、折旧和报废等操作，支持固定资产的清查和统计。
2.2 报表统计本系统提供了灵活的报表统计功能，包括以下子模块：2.2.1 现金流量表：用于统计企业的现金流量情况，包括经营活动、投资活动和筹资活动的流入流出情况，分析企业的现金流量状况。
2.2.2 利润表：用于统计企业的利润情况，包括销售收入、成本支出和利润分配等指标，帮助企业评估经营绩效。
2.2.3 资产负债表：用于统计企业的资产和负债情况，包括流动资产、固定资产和所有者权益等指标，反映企业的财务状况。
2.3 预算控制本系统提供了强大的预算控制功能，包括以下子模块：2.3.1 预算编制：支持企业的预算编制工作，包括收入预算和支出预算的制定，提供预算编制模板和预算执行跟踪功能。
2.3.2 预算执行：用于监控企业的预算执行情况，包括预算执行进度和预算偏差的分析，提供预算执行报告和异常预警功能。
2.4 财务分析本系统提供了全面的财务分析功能，包括以下子模块：2.4.1 财务比率分析：用于计算和分析企业的财务比率，包括流动比率、速动比率和资产负债率等指标，帮助企业评估财务风险和盈利能力。
c语言个人财务管理系统[1]
![c语言个人财务管理系统[1]](https://img.taocdn.com/s3/m/e19c22d1de80d4d8d05a4f9a.png)
个人财政支出管理付欣05计算机四班指导老师：梁新元一、问题描述及分析 (1)二、实验程序设计思想及功能描述 (2)3、主要函数模块的设计思想和具体实现 (3)三、实验程序测试 (7)1、程序开始执行时系统的所显示的页面： (7)2、选择退出系统： (7)3、选择登陆，并且输入的帐号和密码都正确： (7)4、用户输入的帐号不正确： (8)5、用户输入的帐号正确，密码不正确： (8)四、实验程序自我评价 (9)五、课程设计创新 (10)六、课程设计总结 (10)七、参考书目： (10)八、实验程序源代码 (10)一、问题描述及分析编写一个个人财政支出管理系统，主要解决的问题是作为一个系统而言，它所要面对不只是某一个人而言，而是要面对很多的用户。
那么想要解决这一问题，就必须要求这个系统能够存储许多用户的基本信息和记录。
同时也要求系统能够对不同的用户的身份进行查找和验证。
在验证通过之后，在对其进行用户所要求的操作。
作为一个财政支出系统，那么就要求对于用户关于金钱的每一项操作都要有相应的记录，同时并允许用户对于每一条整体的记录进行操作，例如可以根据时间来查找某一确定日期是否进行了收入或者支出的操作，也可以根据特定的需要来删除某一条整体的记录。
但不允许对每条记录的单项数据进行更改，因为不管是收入还是支出，所涉及的金额都是固定的，时间也是固定的，所以系统不允许用户对其进行操作。
除此之外，还必须有足够大的空间来存储新的记录。
所以此程序就是基于这个思想而编写出来的，基本满足了用户对于一个财政支出管理系统所要求的相关功能。
二、实验程序设计思想及功能描述根据前面对于编写一个个人财政支出管理系统的程序的问题描述和分析，确定了此程序的基本思想和相关功能。
1、基本思想首先定义一个结构体数组，这个数组的功能便是用来所有用户的所有信息。
它的成员为每个用户的帐号（account）、密码（code）、姓名(name)、记录(record rec[max])，以及记录的条数(rec_len)。
财务管理操作说明书
财务管理操作说明书在主窗体界面单击财务管理显示此登录界面：输入用户和密码后(初始用户和密码为SYS)，用户和密码都是必输项，单击＂确定＂按钮或者组合键(ALT+O),进入此部门选择和帐套选择界面，否则退出。
部门(此信息在基本信息设置系统中建立), 帐套(此信息在基本信息设置系统中建立)。
单击＂确定＂按钮或者组合键(ALT+O),进入此财务管理界面：财务管理能直接反映公司的财务支出和盈利等信息,包括财务操作和财务报表两大部分。
1、财务操作：主要是对财务基本信息的操作和数据整理。
包括科目信息维护、科目初始设置、凭证录入、科目余额统计和会计月结统计。
1.1、科目信息维护：主要设置财务基本的会计科目。
操作方法与基本设置中相同。
具体界面如下：1.2、科目初始设置：主要设置财务基本的会计科目。
操作方法与基本设置中相同。
具体界面如下：1.2、凭证录入：主要是帐款凭证的录入。
具体界面如下：如果需要新增一张凭证,先选择相应的凭证录入种类,然后点击＂确定＂按钮进入录入界面,如下图：图（一）如果在凭证录入界面点＂凭证查询＂按钮，则进入如下界面：图（二）1.3、科目余额统计：主要对科目余额的汇总。
具体界面如下：选择正确的截止日期，然后点＂确定＂按钮进入报表界面，否则跳出下面的界面。
1.4、会计月结统计：主要对财务帐款进行月结汇总。
具体界面如下：具体操作如科目余额统计。
2、财务报表：主要对财务帐款数据分类汇总。
具体分支如下：2.1、试算平衡表，截面如下：设置好报表条件，然后点＂确定＂按钮进入报表界面：具体每个报表的操作方法基本相同,参照如上图方法即可。
系统功能说明书模板
系统功能说明书模板一、概述本系统功能说明书旨在为使用者提供关于系统的详细说明，包括系统的功能、特点、操作方式、维护方法等。
本说明书将帮助使用者更好地理解、使用和维护该系统。
二、系统功能说明1、功能介绍本系统的主要功能是，通过使用先进的技术，实现功能，提高效率。
2、功能特点本系统具有以下特点：（1）易于操作：界面友好，操作简单，用户只需经过简单的培训即可熟练使用。
（2）高效稳定：采用先进的技术，确保系统运行稳定，提高数据处理效率。
（3）安全可靠：数据传输和存储均采用加密技术，确保用户信息安全。
（4）智能提示：系统具备智能提示功能，帮助用户快速解决问题，提高工作效率。
三、操作说明1、登录与退出用户通过输入用户名和密码进行登录，登录成功后即可进入系统主界面。
如需退出系统，请点击主界面右上角的“退出”按钮。
2、主要功能操作本系统主要功能包括等，下面分别进行说明：（1）操作：进入界面，输入相关参数，然后点击“确定”按钮即可完成操作。
（2）操作：进入界面，选择要操作的数据项，然后点击“编辑”按钮进行修改。
修改完成后，点击“保存”按钮即可完成操作。
四、维护说明为确保系统的正常运行，请定期进行以下维护操作：（1）定期备份数据：建议每周对系统数据进行备份，以防止意外情况造成的数据丢失。
（2）更新程序：请定期检查并更新系统的最新版本，以确保系统的稳定性和安全性。
（3）清理缓存：定期清理系统缓存，以提高系统运行速度和稳定性。
（4）检查硬件设备：定期检查硬件设备是否正常运行，如有问题请及时报修。
五、常见问题及解决方案在使用本系统的过程中，可能会遇到一些常见问题，下面列出并给出相应的解决方案：（1）问题一：无法登录系统。
解决方案：检查用户名和密码是否正确，确认无误后再次尝试登录。
如仍有问题，请技术支持人员。
（2）问题二：无法完成某项功能。
解决方案：请检查系统是否正常运行，如有异常情况，请技术支持人员进行处理。
如因用户操作不当导致的问题，请参考操作说明进行修正。
财务情况说明书范文8篇｜财务情况说明书范文三篇
【实习报告】账务是指实现会计处理进行原始单证的收集、整理、记载、计算、结报等会计处理的具体事务，它要求规范、准确，保证会计核算，会计监督和会计准则的有效实施。
下面是分享的财务人员现实表现材料。
供大家参考！财务情况说明书范文财务情况说明书是对企业一定会计期间内生产经营、资金周转和利润实现及分配等情况的综合性说明，是财务会计报告的重要组成部分。
它全面扼要地提供企业和其他单位生产经营、财务活动情况，分析总结经营业绩和存在的不足，是财务会计报告使用者了解和考核有关单位生产经营和业务活动开展情况的重要资料。
企业会计制度规定，财务情况说明书至少应对下列情况作出说明①企业生产经营的基本情况;②利润实现和分配情况资金增减和周转情况;③对企业财务状况、经营成果和现金流量有重大影响的其他事项。
(1)企业生产经营的基本情况。
企业通常需要反映以下有关企业生产经营的基本情况;企业主营业务范围及经营情况;企业所处的行业以及在本行业中的地位，如按销售额排列的名次;企业员工的数量和专业素质情况;经营中出现的问题与困难及解决方案;对企业业务有影响的知识产权的有关情况;经营环境的变化;新年度的业务发展计划，如生产经营的总目标及措施;开发、在建项目的预期进度;配套资金的筹措计划;需要披露的其他业务情况与事项。
(2)利润实现和分配情况利润实现和分配情况，主要是指企业本年度实现的净利润及其分配情况，如，实现的净利润是多少;在利润分配中提取法定盈余公积金和法定公益金各有多少;累计可分配利润有多少;此外，企业还应反映资本公积金转增实收资本(或股本下同)的情况;等等。
如果在本年度内没有发生利润分配情况或资本公积金转增实收资本情况，则企业需要在财务情况说明书中明确说明。
企业利润的实现和分配情况，对于判断企业未来发展前景至关重要，所以，需要企业披露有关利润实现和分配情况方面的信息。
(3)资金增减和周转情况资金增减和周转情况主要反映年度内企业各项资产、负债、所有者权益、利润构成项目的增减情况及其原因这对于财务会计报告使用者了解企业的资金变动情况具有非常重要的意义。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
个人财务管理系统说明书标准化文件发布号：（9312-EUATWW-MWUB-WUNN-INNUL-DQQTY-摘要Visual FoxPro是一种用于数据库设计、创建和管理的软件，利用它可以对各种事务管理工作中的大量数据进行有效的管理并满足数据检索的需要。
本系统就是根据公司现阶段的需要，通过Visual FoxPro开发一个公司信息管理系统来实现对公司信息准确、高效的管理和维护。
整个系统从符合操作简便、界面友好、灵活、实用、安全的要求出发，完成工资管理的全过程，包括员工信息、工资信息、员工信息和工资信息的添加、修改、删除等管理工作以及用户管理权限的改变等。
本文主要介绍了本课题的开发背景，所要完成的功能和开发的过程。
重点说明了系统的设计思路、总体设计、各个功能模块的设计与实现方法。
关键词：个人财务管理系统， Visual FoxPro目录功能需求分析 .................................... 错误!未定义书签。
系统模块划分 .................................... 错误!未定义书签。
系统模块结构图 ................................ 错误!未定义书签。
3 数据库设计 ...........................................错误!未定义书签。
逻辑设计 ........................................... 错误!未定义书签。
物理设计 ........................................... 错误!未定义书签。
表结构设计 ..................................错误!未定义书签。
4系统详细设计 .......................................错误!未定义书签。
系统封面设计 .................................... 错误!未定义书签。
系统登陆面设计 ................................. 错误!未定义书签。
系统主界面设计 ................................. 错误!未定义书签。
添加收入界面和添加支出界面设计 ... 错误!未定义书签。
修改密码界面设计............................. 错误!未定义书签。
系统主程序......................................... 错误!未定义书签。
5 系统连编与运行 ....................................错误!未定义书签。
连编................................................... 错误!未定义书签。
运行................................................... 错误!未定义书签。
参考文献..................................................错误!未定义书签。
1 需求分析当前生活节奏加快，人们生活水平不断提高，收入和支出越来越趋于多样化，传统的人工方式记录和管理家庭或自己的财务情况的记录方式不仅不便于长期保存，还有一些不可避免的缺点。
开发一个能管理个人财务收支的软件系统已经很有必要。
这样可以减轻人们在个人财务统计和其他财务管理的负担。
能够克服传统方法的多个缺点。
数据需求分析本系统的主要数据信息有个人财务收入表、个人财务支出表和修改表。
个人财务收入表包括:年月，姓名，基本工资，奖金，提成等。
个人财务支出表包括：年月，姓名，水电等基本支出，送礼和买衣服等。
修改表包括：姓名，年月等。
功能需求分析本系统主要实现对个人财务进行管理，需要实现以下几个方面的管理功能：（1）收入管理：收入的查询，添加新的收入。
（2）支出管理：支出的查询，添加新的支出。
（3）修改：对用户的密码等进行修改。
2 系统总体设计系统模块划分本系统主要是对个人财务的管理，包括了有关数据的查询、修改、添加、删除等功能。
整个系统分为以下几个模块。
1、主界面模块本模块提供财务管理系统的主菜单界面，供用户选择与执行各项管理工作。
同时在本模块中还将核对进入本系统操作人员的用户名和密码。
2、查询模块本模块用于用户查询各项信息，例如收入信息查询、支出信息查询等。
系统模块结构图根据系统功能设计，对应的系统模块结构图如图1所示3 数据库设计逻辑设计根据数据需求分析以及关系数据库设计原则，本系统创建了一个数据库，并在该库中建立了收入信息表(收入.dbf)及密码信息表（密码表.dbf）个人支出表（支出.dbf）等数据表。
各表的关系模式如下：（1）密码表（密码）。
（2）收入表（年月，姓名，基本工资，奖金，提成）。
（3）支出表（年月，姓名，水电等支出）。
（4）情况统计表（编号，销售量，进货量，药品名称）。
物理设计根据各表的关系模式，建立表的物理结构。
3.2.1 表结构设计药店药品信息表，密码，排行榜表，情况统计表。
这四个表的表结构如表1、表2、表3、表4所示。
表1 收入表结构表2 支出表结构4系统详细设计系统封面设计创建如图2所示的个人财务管理系统系统登陆表单，并设定为顶层表单，以文件名首页.scx存盘。
该表单在运行后，由用户单击表单上的相应的命令按钮进入相应的功能界面。
图2 个人财务管理系统登陆界面此表单的具体设计步骤如下：（1）单击文件－新建－表单，单击新建文件，进入表单设计器窗口。
在表FORM1中添加一个Label1、Label2，两个命令按钮command1、command2，一个计时器Timer1，并调整它们的大小和位置，设置各控件的属性。
（2）为使本表单作为顶层表单，始终处于屏幕中央，不出现表单的标题栏，并以一幅指定的图像作为其背景，需要设置变淡FORM1的Autocenter属性值为.T.，picture属性值为图像文件……，Titlebar属性值为“0-关闭”，Showwindow属性值为“2-作为顶层表单”。
（3）设置Lablel1的caption属性值为“个人财务管理系统”，BackStyle 属性值为“0-透明”；设置label2的caption属性值为“08计七—李森”Backstyle属性值为“0-透明”。
（4）为使本表单在显示1秒后自动关闭并启动验证程序验证.scx，需要设置计时器Timer1的Interval属性值为1000毫秒，同时为Timer1的Timer事件编写如下代码do form 验证.scx系统登陆面设计登陆界面是为了防止非管理人员的操作，要求将登陆界面设计成如图3所示的界面。
图3 登录界面此表单的具体设计步骤如下：（1）在“项目1”项目器窗口中，单击“文档”选项卡，选择“表单”，单击“新建”按钮，打开“表单设计器”窗口，设计出如图4所示的表单。
（2）在表单中一个标签Label1，一个文本框Text1，三个命令按钮Command1，Command2,Command3并调整它们的位置和大小，设置各控件的属性。
（3）编写Command1的代码如下：Command1的click代码如下：i=i+1if i<3if "123"messagebox("密码正确，欢迎进入本系统")do form 主表单.scxelsemessagebox("密码错误，重新输入！")""endifelsemessagebox("密码错误，禁止进入本系统！")=.f.endif && 关闭本表单Command2的click代码如下：""的代码如下：quit系统主界面设计个人财务管理系统的主界面提供进入系统其他功能模块的方法，使用户能方便地调用收入信息查询、支出信息查询、管理维护等操作界面，实施个人财务的基本管理。
要求将个人财务管理系统的应用程序主界面设计成如图4所示的界面。
图4主系统界面此表单的具体设计步骤如下：（1）在“项目1”项目器窗口中，单击“文档”选项卡，选择“表单”，单击“新建”按钮，打开“表单设计器”窗口，设计出如图5所示的表单。
（2）在表单上添加一个标签Label1，一个页框Pageframe1，调整它们的大小，并设置属性。
将页框设置如图所示，分别为收入查询、支出查询、管理维护。
（3）在Page1收入查询页面内添加两个形状Shape1、Shape2，四个命令按钮command1,command2，command3,command4,调整它们的大小，并设置属性。
编写command1的click代码如下：close alldo form 收入.scx编写command2的click代码如下：close alldo form 添加收入.scx编写command3的click代码如下编写command4的click代码如下quit（4）在Page2支出查询页面添加，两个形状Shape1、Shape2，四个命令按钮command1、command2，command3,command4调整它们的大小，并设置属性。
编写command1的click代码如下：close alldo form 支出.scx编写command2的click代码如下：close alldo form 添加支出.scxcommand3,command4的click代码同收入查询的command3和command4。
（5）在Page3管理维护页面添加一个标签Label1，一个形状Shape1，一个命令按钮command1调整它们的大小，并设置属性。
编写command1的click代码如下：DO FORM 修改密码添加收入界面和添加支出界面设计添加收入和添加支出界面显示了收入的具体信息，要其详细信息界面设计成如图5和图6所示。
图5添加收入界面步骤如下(1)在“项目1”项目器窗口中，单击“文档”选项卡，选择“表单”，单击“新建”按钮，打开“表单设计器”窗口，设计出如图7所示的表单。
（2）在表单中添加两个命令按钮框command1和command2（3）把command1和command2的fontsize都改为14，fontcolor都改为255,0，0。
把command1的caption属性改为“添加收入”，把command2的caption属性值改为“返回”。
（4）编写command1的click代码如下：go bottomappend blankeditreturn编写command2的click代码如下图6添加支出界面步骤如下(1)在“项目1”项目器窗口中，单击“文档”选项卡，选择“表单”，单击“新建”按钮，打开“表单设计器”窗口，设计出如图7所示的表单。