System Resources Budget Category

• List of all different Budget Categories.

• Fields

• Add New Budget Category
• Remove Rows
• Copy Rows
• Cut Rows
• Paste Rows
• Undo
• Load Budget Category File
• Save Budget Category File
• Save Budget Category
• Close Budget Category
• Refresh Budget Category

• General Comments
• See Also

Fields

• Category No is the unique database number of the Budget Category.
• Category Name is the name of the Budget Category.

Add New Budget Category

This adds a new row to the Budget Category resource table.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Add New Budget Category.

Note

• The table must be saved before changes in the database occur.

Remove Rows

This removes the selected rows from the Budget Category resource table.

1. Make the Budget Category window active in the Board.
2. Select one or more rows in the table.
3. On the Budget Category menu click Remove Rows.

Note

• The table must be saved before changes in the database occur.

Copy Rows

This copies the data in the selected rows of the Budget Category resource table to local clipboard.

1. Make the Budget Category window active in the Board.
2. Select one or more rows in the table.
3. On the Budget Category menu click Copy Rows.

Note

• The table must be saved before changes in the database occur.

Cut Rows

This removes the selected rows of the Budget Category resource table and copies them to local clipboard.

1. Make the Budget Category window active in the Board.
2. Select one or more rows in the table.
3. On the Budget Category menu click Cut Rows.

Note

• The table must be saved before changes in the database occur.

Paste Rows

This adds the rows in local clipboard to the Budget Category resource table.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Paste Rows.

Note

• The table must be saved before changes in the database occur.

Undo

This cancels the last change to the Budget Category resource table.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Undo.

Note

• The table must be saved before changes in the database occur.

Load Budget Category File

This loads a comma separated value file and adds the data to the Budget Category resource table.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Load Budget Category File.
3. In the folder list, locate and open the folder that contains the file.
4. Click the file, and then click Open.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.
• To see the exact file format, do a save file for a table with entries.
• The data in the table will be replaced with the data in the file.
• The table must be saved before changes in the database occur.

Save Budget Category File

This saves the Budget Category resource table as a comma separated value file.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Save Budget Category File.
3. If you want to save the file in a different folder, locate and open the folder.
4. In the File Name box, type a name for the file.
5. Click Save.

Note

• The CSV file consists of the header row followed by rows that contain comma separated data.

Save Budget Category

This saves the Budget Category in the database.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Save Budget Category, or click the Save Budget Category button in the button bar.

Note

• This will replace the information for the current Budget Category in the database.

Close Budget Category

This closes the window.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Close Budget Category, or click the X button on the window's Title bar.

Note

• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

Refresh Budget Category

This reverts the data for the Budget Category to the version in the database.

1. Make the Budget Category window active in the Board.
2. On the Budget Category menu click Refresh Budget Category.

Note

• This will reload the Budget Category from the database.
• If the content of the View has been modified since the last Save operation, the user will be given an option to proceed and discard the changes, or to cancel the operation.

General Comments

• To open the Budget Category window in the Board, on the Options menu select System Resources then click Budget Category.
• This System Resource is maintained by a Sesame user, usually a Sesame administrator, with a Can Do privilege.
• To give the Can Do privilege for this resource to user JoeSmith, execute the following SQL statement:
  insert into candothis values ('JoeSmith', 'SYS_RSC_BUDGETCATEGORY', 'Sesame', 'SYS');
• To revoke the Can Do privilege for this resource from user JoeSmith, execute the following SQL statement:
  delete from candothis where user_name='JoeSmith' and what='SYS_RSC_BUDGETCATEGORY' and ass_name='Sesame' and ass_type='SYS';

See also

Copyright © 1999-2009 Zsolt Zolnai, and the University of Wisconsin - Madison