CASH RECEIPT SYSTEM TECHNICAL DOCUMENTATION

CASH RECEIPT SYSTEM TECHNICAL DOCUMENTATION Table of Content 1. 2. 3. 4. 5. Page System Overview …………………………………………….. 3 Security ………………………………………………...
Author: Spencer Powers
0 downloads 0 Views 484KB Size
CASH RECEIPT SYSTEM

TECHNICAL DOCUMENTATION

Table of Content 1. 2. 3. 4. 5.

Page System Overview …………………………………………….. 3 Security ………………………………………………………. 3 Software Requirements ………………………………………. 3 Program List ………………………………………………….. 4 Program Description ………………………………………….. 5 5.1. Acrobat Form ………………………………………….. 5 5.1.1. CR_Form_CAD_2.pdf ………………………….. 5 5.1.2. CR_Form_CAD_3.pdf ………………………….. 5 5.1.3. CR_Form_USD_2.pdf ………………………….. 5 5.1.4. CR_Form_USD_3.pdf …………………………… 5 5.2. PL/SQL Procedure ……………………………………… 6 5.2.1. CR_Confirmation ………………………………… 6 5.2.2. CR_Entry ………………………………………… 7 5.2.3. CR_Forward …………………………………….. 9 5.2.4. CR_Help ………………………………………… 10 5.2.5. CR_Home ……………………………………….. 11 5.2.6. CR_Print ………………………………………… 12 5.2.7. CR_Reprint_Qry ………………………………… 13 5.2.8. CR_Reprint_Search ……………………………… 14 5.2.9. CR_Reset_Entry …………………………………. 15 5.2.10.CR_Speedchart ………………………………….. 16 5.3. PeopleSoft Project …… ………………………………… 17 5.3.1. UBC_RTA_CASH_RECEIPTS ....…………………. 17 5.3.2. UBCFMS08900 …………………………………. 19 5.4. SQR Program …………………………………………… 20 5.4.1. FMS08900 ……………………………………….. 20

Appendix A. Flat file in FMS08900 …………………………………………..… B. PS_UBC_CAS_REC_HDR ……..………………………………. C. PS_UBC_CAS_REC_CHQ ………………………………………. D. PS_UBC_CAS_REC_JRN ……………………………………….. E. PS_UBC_CAS_REC_SRC ……..………………………………… F. PS_UBC_FMS08900 ……….……………………………………..

2

22 24 25 26 27 28

1. SYSTEM OVERVIEW The Cash Receipt System allows user to fill in a cash receipt form on the web and submit the form on-line. User enters bank deposit and journal information (cash receipt transaction) on the cash receipt form for each Canadian/US dollars deposit. The system performs calculation, formats and validates data entered on the form. If all the data entered is valid and consistent, a reference number will be generated for the form, the form will be printed and all the data will be saved in FMIS system. Journal information will then be extracted from FMIS system and saved to a flat by FMS08900.sqr. The flat file will be passed to fms01600.sqr and gls9002.sqr for further processing. Note: If any amount of the cash receipt transaction is charged to Specific Purpose or Research funds, the transaction can be checked or changed in PeopleSoft system by Research & Trust group before the transaction is processed by FMS08900.sqr. 2. SECURITY Only user with valid user id and password is allowed to submit the cash receipt form on the web. Cash receipt transaction can only be accessed on the web by the user who created it. The id and name of the user who submits the cash receipt form and the date when the form is submitted are saved in FMIS system. The operator id of the user who changes the cash receipt transaction in PeopleSoft system and the date when the transaction is changed are saved in FMIS system. 3. SOFTWARE REQUIREMENTS -

Adobe Acrobat version 5 Web browser

3

4. PROGRAM LIST The Cash Receipt System is composed of the following forms/procedures/projects and program: Acrobat Form: - CR_Form_CAD_2.pdf - CR_Form_CAD_3.pdf - CR_Form_USD_2.pdf - CR_Form_USD_3.pdf PL/SQL Procedure: - CR_Confirmation - CR_Entry - CR_Forward - CR_Help - CR_Home - CR_Print - CR_Reprint_Qry - CR_Reprint_Search - CR_Reset_Entry - CR_Speedchart PeopleSoft Project: - UBC_RTA_CASH_RECEIPTS - UBCFMS08900 Sqr Program: - Fms08900

4

5. PROGRAM DESCRIPTION 5.1. Acrobat Form 5.1.1. CR_Form_CAD_2.pdf – CAD Cash Receipt Entry Form - Developed in Adobe Acrobat Version 5. - A web-based form consists of a bank deposit slip and a journal entry form for Canadian dollar deposit. - Stored in fs06. - Most of the fields on the form can be entered/altered. - Perform calculation, format & validate data entered. 5.1.2. CR_Form_CAD_3.pdf – CAD Cash Receipt Print Form - Developed in Adobe Acrobat Version 5. - A web-based form consists of two bank deposit slips and a journal entry form for Canadian dollar deposit. - Stored in fs06. - All the fields on the form are display only. - Perform calculation and format data. 5.1.3. CR_Form_USD_2.pdf – USD Cash Receipt Entry Form - Developed in Adobe Acrobat Version 5 - A web-based form consists of a bank deposit slip and a journal entry form for US dollar deposit. - Stored in fs06. - Most of the fields on the form can be entered/altered. - Perform calculation, format & validate data entered. 5.1.4. CR_Form_USD_3.pdf – USD Cash Receipt Print Form - Developed in Adobe Acrobat Version 5 - A web-based form consists of two bank deposit slips and a journal entry form for US dollar deposit. - Stored in fs06 - All the fields on the form are display only. - Perform calculation and format data.

5

5.2. PL/SQL Procedure 5.2.1. CR_Confirmation Purpose: This procedure works with CR_Forward procedure to prevent user from going back to previous web page once the cash receipt form is submitted successfully. Location: - fm7ver - fmprod Parameter: - p_time Input Table: - ps_ubc_cas_rec_hdr Process: - Retrieve from ps_ubc_cas_rec_hdr table the reference number of the last cash receipt transaction created by the user. - Display ‘The form has been submitted successfully and assigned Reference No. …’ message. - Display ‘Print Cash Receipt Form’ button. - Execute CR_Print procedure when ‘Print Cash Receipt Form’ button is clicked.

6

5.2.2. CR_Entry Purpose: This procedure validates data entered on the cash receipt entry form and saves the data in FMIS system. Location: - fm7ver - fmprod Parameter: - All the fields entered on cash receipt entry form. Input Table: - sec_users - ps_speedtyp_tbl - ps_gl_account_tbl - ps_fund_tbl - ps_org_tbl - ps_program_tbl - ps_project_header - ps_cur_rt_tbl Input/Output: - ps_ubc_cas_rec_hdr - ps_ubc_cas_rec_chq - ps_ubc_cas_rec_jrn Form: - CR_Form_CAD_2.pdf - CR_Form_USD_2.pdf Process: - Check if all the mandatory fields on the cash receipt form are entered and the fields entered are valid and consistent. - Check if total deposit > 0 and total deposit = total credit. - Validate speedchart against ps_speedtyp_tbl table if speedchart is entered. - Validate account against ps_gl_account_tbl table if account is entered. - Validate fund against ps_fund_tbl table if fund is entered. - Validate dept id against ps_org_tbl table if dept id is entered. - Validate program against ps_program_tbl table if program is entered. - Validate project/grant against ps_project_header table if project/grant is entered.

7

-

-

Validate the combination of project/grant, dept id and fund against ps_project_header table if project/grant is entered. For CAD Cash Receipt Entry Form: - Currency rate type = ‘ ‘ - Currency exchange rate = 1.00. For USD Cash Receipt Entry Form: - If total deposit >= 10000, then currency rate type = ‘COMM’, else currency rate type = ‘AVG’. - Retrieve currency exchange rate from ps_cur_rt_tbl table. - Calculate CAD equivalent for USD amounts. Execute CR_Speedchart procedure to retrieve the chartfields for the speedchart entered. If all the data entered on the form is valid and consistent, then - Generate reference number. - Save cash receipt header, cheque and journal information into Ps_ubc_cas_rec_hdr, ps_ubc_cas_rec_chq and ps_ubc_cas_rec_jrn tables respectively. Set uploaded flag in ps_ubc_cas_rec_hdr to ‘N’. - Display ‘The form has been submitted successfully and assigned Reference No. …’ message. - Display ‘Print Cash Receipt Form’ button. - Execute CR_Print procedure when ‘Print Cash Receipt Form’ button is clicked. - Execute CR_Forward procedure.

8

5.2.3. CR_Forward Purpose: This procedure works with CR_Confirmation procedure to prevent user from going back to previous web page once the cash receipt form is submitted successfully. Location: - fm7ver - fmprod Parameter: - p_time Process: - Execute CR_Confirmation procedure.

9

5.2.4. CR_Help Purpose: This procedure displays instructions for completing Cash Receipt form. Location: - fs06 Process: - Displays instructions for completing Cash Receipt form.

10

5.2.5. CR_Home Purpose: This procedure displays a list of menu options related to Cash Receipt module for user to select. Locaton: - fs06 Process: - Displays a list of menu options related to Cash Receipt module.

11

5.2.6. CR_Print Purpose: This procedure retrieves cash receipt transaction from FMIS system for the specified reference number and displays the transaction on the cash receipt print form for printing. Location: - fs06 Parameter: - reference no Input Table: - ps_ubc_cas_rec_hdr - ps_ubc_cas_rec_chq - ps_ubc_cas_rec_jrn Form: - CR_Form_CAD_3.pdf - CR_Form_USD_3.pdf Process: - Check if the user has privilege to print the cash receipt transaction with the specified reference number. - If the user has privilege to print the transaction, then - Retrieve the transaction from ps_ubc_cas_rec_hdr, ps_ubc_cas_rec_chq and ps_ubc_cas_rec_jrn tables. - Display the transaction on a cash receipt print form.

12

5.2.7. CR_Reprint_Qry Purpose: This procedure prompts user to enter reference number of the cash receipt transaction he/she wants to print. Location: - fs06 Process: - Prompt user to enter reference number of the cash receipt transaction he/she wants to print. - Execute CR_Reprint_Search procedure when ‘Submit Query’ button is clicked.

13

5.2.8. CR_Reprint_Search Purpose: This procedure displays a list of existing cash receipt reference numbers that begin with the specified reference number. User can then select the reference number of the cash receipt transaction he/she wants to print from the list. Location: - fs06 Parameter: - reference number Input Table: - ps_ubc_cas_rec_hdr Process: - Retrieve ps_ubc_cas_rec_hdr record with reference number begins with the specified reference number. - Display the following fields for each record retrieved. - Reference number - Username - Entry date - Currency - Uploaded flag - Description - Execute CR _PRINT procedure if a reference number is selected.

14

5.2.9. CR_Reset_Entry Purpose: This procedure displays the cash receipt entry form and initializes most of the fields on the form. Location: - fs06 Parameter: - currency - reset Input Table: - ps_ubc_cas_rec_hdr Form: - CR_Form_CAD_2.pdf - CR_Form_USD_2.pdf Process: - Display the cash receipt entry form. - Initialize all the fields on the form except the following fields. - Direct queries to - Phone no. - Filing location - Dept. name - Dept. address - Authorized by

15

5.2.10. CR_Speedchart Purpose: This procedure retrieves chartfields from speedtype table for the speedchart entered on the cash receipt entry form and displays the chartfields on the form. Location: - fs06 Parameter: - All the fields on the cash receipt form (including speedcharts). Input Table: - ps_ubc_cas_rec_hdr - ps_speedtyp_tbl Form: - CR_Form_CAD_2.pdf - CR_Form_USD_2.pdf Process: - Retrieve chartfields from ps_speedtyp_tbl table for the specified speedcharts. - Display the chartfields and all the other fields on the cash receipt entry form.

16

5.3. PeopleSoft Project 5.3.1. UBC_RTA_CASH_RECEIPTS Purpose: This project allows Research and Trust group to check and change cash receipt transactions before the transactions are processed by fms08900.sqr. Menu: - UBC_RTA_Reporting Panel Group: - UBC_Cas_Rec_Chq Panel Name: - CR_Budget_Inc_1 (Cash Receipt S and R funds Check – Header Information) - CR_Budget_Inc_2 (Cash Receipt S and R funds Check – Detail Information) Record: - ps_ubc_cas_rec_hdr - ps_ubc_cas_rec_chq - ps_ubc_cas_rec_jrn Search Record: - ps_ubc_cas_rec_src Process: - Retrieve & display cash receipt transactions that have not been processed by fms08900.sqr (i.e. uploaded flag in ps_ubc_cas_rec_hdr record = ‘N’) and has fund charged to Specific Purpose or Research Funds (i.e. S or R funds). - Only budget increase flag, account, fund, dept id, project id, program and amount fields can be modified. Note: Journal line that is debited to bank account is display only. - Check if total deposit = total credit. - Restricted accounts (499999, 500000, 501000, 509000) are not allowed. - Validate account against ps_gl_account_tbl table. - Validate fund against ps_fund_tbl table. - Validate dept id against ps_org_tbl table. - Validate program against ps_program_tbl table. - Validate project/grant against ps_project_header table.

17

-

Validate the combination of project/grant, dept id and fund against ps_project_header table. Once the ‘Save’ button is clicked, - Modified data are updated to ps_ubc_cas_rec_hdr and ps_ubc_cas_rec_jrn records. - Operator id and check date are updated to ps_ubc_cas_rec_hdr record.

18

5.3.2. UBCFMS08900 Purpose: This project allows Data Management to submit fms08900.sqr to run. Menu: - Process_Journals Panel Group: - UBC_FMS08900 Panel Name: - UBC_FMS08900 (Generate Web Cash Receipts) Record: - ubc_cr_hdr_vw - ubc_fms08900 Process: - Prompt user to enter directory & name of the flat file to be output in fms08900.sqr.

19

5.4. SQR PROGRAM 5.4.1. FMS08900.SQR – Generate web cash receipts Purpose: This program extracts journal data from cash receipt header and journal detail tables for the cash receipt transactions that needed to be processed. It then generates journals from the data extracted and writes the journals to a flat file. Parameter: - directory of the output file - name of the output file Input Table: - ps_ubc_fms08900 - ps_ubc_cas_rec_jrn - ps_cal_detp_tbl - ps_bu_led_grp_tbl - ps_speedtyp_tbl - ps_set_cntrl_rec View: - ubc_cr_hdr_vw Input/Output: - ps_ubc_fms08900 - ps_ubc_cas_rec_hdr Output file: - flat file with name in glcas-.d format whereas yyyymmdd = current date, xxx = last 3 digits of the process instance. Process: - Retrieve cash receipt header record from ps_ubc_cas_rec_hdr table and its journal detail records from ps_ubc_cas_rec_jrn table. - If the cash receipt header record and its journal detail records fulfilled any one of the following 3 conditions, 1. uploaded flag in ps_ubc_cas_rec_hdr record = ‘N’ and funds in all its ps_ubc_cas_rec_jrn records are not S and R funds.

20

2. uploaded flag in ps_ubc_cas_rec_hdr record = ‘N’, fund in any of its ps_ubc_cas_rec_jrn records is S or R funds and operator id and check date in ps_ubc_cas_rec_hdr are not null. 3. uploaded flag in ps_ubc_cas_rec_hdr record = ‘N’, fund in any of its ps_ubc_cas_rec_jrn records is S or R funds, operator id and check date in ps_ubc_cas_rec_hdr record are null and deposit date in ps_ubc_cas_rec_hdr record is at least 11 days prior to today’s date. then -

Create 1 header record, n number of line records (where n = number of journal detail records) and 1 control record from the data in the cash receipt header and journal detail records (see Appendix A for details). Make sure CAD equivalent of the total debit = CAD equivalent of the total credit. Write the header, line and control records to a flat file. Print control totals. Set uploaded flag and upload date in ps_ubc_cas_rec_hdr to ‘Y’ and today’s date respectively.

Parameters are updated to ps_ubc_fms08900 record.

21

Appendix A. Flat file in FMS08900 Header Record Field Name Record Type Business Unit Journal Id Journal Date Ledger Group Reversal Code Reversal Date Source Transaction Reference Number Description Currency Code

Data Type Char Char Char Numeric Char Char Numeric Char Char Char Char

Length 1 5 10 8 10 1 8 3 8 30 3

Format

Currency Rate Type Currency Effective Date Currency Exchange Rate

Char Numeric Numeric

5 8 16

Interfund_Trns_Typ Long Description

Char Char

1 254

Field Name Record Type Business Unit Journal Line Number Ledger Account Fund

Data Type Char Char Char Char Char Char

Length 1 5 6 10 6 5

Department Id

Char

10

Program

Char

5

Sub Classification Budget Year Project ID

Char Numeric Char

5 4 15

Affiliate Statistics Code Transaction Currency Code

Char Char Char

5 3 3

Transaction Monetary Amount

Numeric

16

S9(13).99

Statistics Amount Journal Line Reference Journal Line Description Foreign Currency Rate Type Foreign Currency Exchange Rate Base Currency Amount

Numeric

S9(13).99

Numeric

16 10 30 5 16

S9(13).99

Numeric

16

S9(13).99

MMDDYYYY

MMDDYYYY

MMDDYYYY

Mapping Field = “H” = “UBC” = “NEXT” = Deposit date in ps_ubc_cas_rec_hdr = “ACTUALS” = “N” = “” = Source in ps_ubc_cas_rec_hdr = Reference number in ps_ubc_cas_rec_hdr = “Cash Receipt From Web” = Currency code in ps_ubc_cas_rec_hdr if it is not blank = ‘CAD’ if currency code in ps_ubc_cas_rec_hdr is blank = Currency rate type in ps_ubc_cas_rec_hdr = Journal Date = currency exchange rate in ps_ubc_cas_rec_hdr if it is non-zero = 1 if currency exchange rate in ps_ubc_cas_rec_hdr = 0 =““ = concatenation of direct queries, phone no, filing location, dept name and description fields in ps_ubc_cas_rec_hdr

Line Record Format

22

Mapping Field = “L” = “UBC” = “NEXT” = “ACTUALS” = account in ps_ubc_cas_rec_jrn = fund in ps_ubc_cas_rec_jrn if fund and dept id in ps_ubc_cas_rec_jrn are not blank = fund in ps_speedtyp_tbl if fund or dept id in ps_ubc_cas_rec_jrn is blank and speedchart in ps_ubc_cas_rec_jrn is not blank = dept id in ps_ubc_cas_rec_jrn if fund and dept id in ps_ubc_cas_rec_jrn are not blank = dept id in ps_speedtyp_tbl if fund or dept id in ps_ubc_cas_rec_jrn is blank and speedchart in ps_ubc_cas_rec_jrn is not blank = program in ps_ubc_cas_rec_jrn if fund and dept id in ps_ubc_cas_rec_jrn are not blank = program in ps_speedtyp_tbl if fund or dept id in ps_ubc_cas_rec_jrn is blank and speedchart in ps_ubc_cas_rec_jrn is not blank Blank = Fiscal year of the deposit date in ps_ubc_cas_rec_hdr = project id in ps_ubc_cas_rec_jrn if fund and dept id in ps_ubc_cas_rec_jrn are not blank = project id in ps_speedtyp_tbl if fund or dept id in ps_ubc_cas_rec_jrn is blank and speedchart in ps_ubc_cas_rec_jrn is not blank Blank Blank = Currency code in ps_ubc_cas_rec_hdr if it is not blank = ‘CAD’ if currency code in ps_ubc_cas_rec_hdr is blank = amount in ps_ubc_cas_rec_jrn if line num in ps_ubc_cas_rec_jrn = 1 = -1 * amount in ps_ubc_cas_rec_jrn if line num in ps_ubc_cas_rec_jrn 1 =0 = reference number in ps_ubc_cas_rec_jrn = “Cash Receipt From Web” = currency rate type in ps_ubc_cas_rec_hdr = currency exchange rate in ps_ubc_cas_rec_hdr if it is non-zero = 1 if currency exchange rate in ps_ubc_cas_rec_hdr = 0 = CAD equivalent of transaction monetary amount

Control Record Field Name Record Type Control Business Unit Ledger Base Currency Code Transaction Currency Code

Data Type Char Char Char Char Char

Length 1 5 10 3 3

Format

Journal Control Base Currency Debits Journal Control Base Currency Credits Journal Control Transaction Currency Debits Journal Control Transaction Currency Credits Journal Control Statistical Units Journal Control Lines

Numeric

16

S9(13).99

Mapping Field = “C” = “UBC” = “ACTUALS” = “CAD” = Currency code in ps_ubc_cas_rec_hdr if it is not blank = ‘CAD’ if currency code in ps_ubc_cas_rec_hdr is blank = Sum of the +ve base currency amounts in line records

Numeric

16

S9(13).99

= Sum of the -ve base currency amounts in line records

Numeric

16

S9(13).99

= Sum of the +ve transaction monetary amounts in line records

Numeric

16

S9(13).99

= Sum of the -ve transaction monetary amounts in line records

Numeric

16

=0

Numeric

6

= Number of line records

23

APPENDIX B. PS_UBC_CAS_REC_HDR Name UBC_REFERENCE_NO UBC_ACCOUNT_NO UBC_USER_ID UBC_USER_NAME EMPLID UBC_ENTRY_DATE CURRENCY_CD CUR_EXCHNG_RT CUR_RT_TYPE UBC_DIRECT_QUERIES UBC_PHONE_NO UBC_DEPOSIT_DATE UBC_DEPT_NAME UBC_DEPT_ADDRESS UBC_AUTHORIZED_BY UBC_ONE UBC_TWO UBC_FIVE UBC_TEN UBC_TWENTY UBC_FIFTY UBC_HUNDRED UBC_NO_OF_BILLS UBC_BILLS UBC_TOTAL_COINS UBC_TOTAL_OTHERS UBC_TOTAL_CASH UBC_TOTAL_CHEQUES UBC_TOTAL_DEPOSIT UBC_CAD_EQUIVALENT LEDGER_GROUP SOURCE UBC_BUDGET_INCR UBC_ACCRUAL UBC_UPLOADED UBC_UPLOAD_DATE UBC_EMAILED UBC_DESCRIPTION_1 UBC_FILING_LOC OPERATOR UBC_CHECK_DATE

Null? NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

24

Type VARCHAR2(8) VARCHAR2(25) VARCHAR2(20) VARCHAR2(30) VARCHAR2(11) DATE VARCHAR2(3) NUMBER(15,8) VARCHAR2(5) VARCHAR2(30) VARCHAR2(20) DATE VARCHAR2(30) VARCHAR2(84) VARCHAR2(30) NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER(15,2) NUMBER(15,2) NUMBER(15,2) NUMBER(15,2) NUMBER(15,2) NUMBER(15,2) VARCHAR2(10) VARCHAR2(3) VARCHAR2(3) VARCHAR2(1) VARCHAR2(1) DATE VARCHAR2(1) VARCHAR2(100) VARCHAR2(20) VARCHAR2(8) DATE

APPENDIX C. PS_UBC_CAS_REC_CHQ Name UBC_REFERENCE_NO UBC_LINE_NUM UBC_CHEQUE_NO

Null? NOT NULL NOT NULL NOT NULL

Type VARCHAR2(8) NUMBER VARCHAR2(15)

UBC_PAYER

NOT NULL

VARCHAR2(46)

AMOUNT

NOT NULL

NUMBER(15,2)

25

APPENDIX D. PS_UBC_CAS_REC_JRN Name UBC_REFERENCE_NO UBC_LINE_NUM UBC_SPEEDCHART ACCOUNT UBC_FUND DEPTID PROGRAM_CODE PROJECT_ID AMOUNT UBC_REFERENCE

Null? NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

26

Type VARCHAR2(8) NUMBER VARCHAR2(6) VARCHAR2(6) VARCHAR2(5) VARCHAR2(10) VARCHAR2(5) VARCHAR2(15) NUMBER(15,2) VARCHAR2(10)

APPENDIX E. PS_UBC_CAS_REC_SRC Name UBC_REFERENCE_NO UBC_DIRECT_QUERIES BUSINESS_UNIT

Null? NOT NULL NOT NULL NOT NULL

Type VARCHAR2(8) VARCHAR2(30) VARCHAR2(5)

NOT NULL NOT NULL NOT NULL

VARCHAR2(3) NUMBER(15,2)

UBC_DEPOSIT_DATE CURRENC_CD UBC_TOTAL_DEPOSIT OPERATOR UBC_CHECK_DATE

DATE

27

VARCHAR2(8) DATE

APPENDIX F. PS_UBC_FMS08900 Name OPRID RUN_CNTL_ID FILE_DIRECTORY FILENAME

Null? NOT NULL NOT NULL NOT NULL NOT NULL

Type VARCHAR2(8) VARCHAR2(30) VARCHAR2(80) VARCHAR2(80)

28