\-- pflt_und610: returns flat-file data for the und 610

\-- (6653_uaal \-- Undisbursed Appropriation Account Ledger) report.

\--

\-- Input:

\-- \@appl_user_id: user identifier; if null or blank, superuser access.

\-- \@acctng_year: YYYY format; \[if null, all are selected.?\]

\-- \@acctng_month: MM format; \[if null, all are selected.?\]

\-- \@dept_number: department number; \[if null, all are selected.?\]

\-- \@distr_code: distribution code; \[if null or blank, all are
selected.\]

\--

\-- Output:

\-- Header Row:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'H\'

\-- IAS ID 2 9 8 \'IAS00610\'

\-- Version 10 15 6 \'VER001\'

\-- Date-Time 16 38 23 \'CCYY-MM-DDThh:mi:ss.mmm\'

\--

\-- Detail Rows:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'D\'

\-- acctng_year+month 2 7 6 yyyymm

\-- dept_number+distr_code 8 11 4 9999

\-- dept_regular 12 13 2 99

\-- dept_transfer 14 15 2 99

\-- fiscal_year 16 19 4 9999

\-- main_acct 20 23 4 9999

\-- sub_acct_sym 24 26 3 \[999\|blank if 000\]

\-- rec_type 27 27 1 9

\-- trans_code 28 29 2 99

\-- sub_class 30 31 2 99

\-- trans_alc 32 39 8 999999999

\-- ref_num 40 47 8 XXXXXXXX

\-- fwd_bal 48 65 18 999999999999999.99

\-- cy_approp 66 83 18 999999999999999.99

\-- nonexp_trans 84 101 18 999999999999999.99

\-- net_disb 102 119 18 999999999999999.99

\-- end_bal 120 137 18 999999999999999.99

\--

\-- Example:

\-- HIAS00610VER0012001-05-07T21:45:00.980

\--
Dyyyymm99999999999999999999999999999999XXXXXXXX999999999999999.99999999999999999.99999999999999999.99999999999999999.99999999999999999.99

\-- Dyyyymm9999999999999999
9999999999999XXXXXXXX999999999999999.99999999999999999.99999999999999999.99999999999999999.99999999999999999.99

\--

\-- Sort order:

\-- acctng_year, acctng_month,

\-- dept_number, distr_code,

\-- dept_regular, dept_transfer, main_acct, sub_acct_sym, fiscal_year,

\-- rec_type, counter

\--

\-- Notes:

\--

\-- History:

\-- 01.13.01, Created. Robert Connolly (rc).

\-- 01.15.01, Added Header row. rc.

\-- 01.23.01, Implemented All distr_codes\'s selection when

\-- \@distr_code = blank or \@distr_code is null. rc.

\-- 02.05.01, Added parameter \@appl_user_id. rc.

\-- 05.07.01, Modified Header. rc.

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-- pflt_und611: returns flat-file data for the und 611

\-- (6654_uaatb \-- Undisbursed Appropriation Account Trial Balance)
report.

\--

\-- Input:

\-- \@appl_user_id: user identifier; if null or blank, superuser access.

\-- \@acctng_year: YYYY format; \[if null, all are selected.?\]

\-- \@acctng_month: MM format; \[if null, all are selected.?\]

\-- \@dept_number: department number; \[if null, all are selected.?\]

\-- \@distr_code: distribution code; \[if null or blank, all are
selected.\]

\--

\-- Output:

\-- Header Row:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'H\'

\-- IAS ID 2 9 8 \'IAS00611\'

\-- Version 10 15 6 \'VER001\'

\-- Date-Time 16 38 23 \'CCYY-MM-DDThh:mi:ss.mmm\'

\--

\-- Detail Rows:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'D\'

\-- acctng_year+month 2 7 6 yyyymm

\-- dept_number+distr_code 8 11 4 9999

\-- dept_regular 12 13 2 99

\-- dept_transfer 14 15 2 99

\-- fiscal_year 16 19 4 9999

\-- main_acct 20 23 4 9999

\-- sub_acct_sym 24 26 3 \[999\|blank if 000\]

\-- fwd_bal 27 44 18 999999999999999.99

\-- cy_approp 45 62 18 999999999999999.99

\-- nonexp_trans 63 80 18 999999999999999.99

\-- net_disb 81 98 18 999999999999999.99

\-- end_bal 99 116 18 999999999999999.99

\-- last_activ_date 117 122 6 yyyymm

\--

\-- Example:

\-- HIAS00611VER0012001-05-07T21:45:00.980

\--
Dyyyymm9999999999999999999-99999999999999.99999999999999999.99999999999999999.99999999999999999.99999999999999999.99yyyymm

\-- Dyyyymm9999999999999999
999999999999999.99999999999999999.99999999999999999.99999999999999999.99999999999999999.99yyyymm

\--

\-- Sort order:

\-- acctng_year, acctng_month,

\-- dept_number, distr_code,

\-- dept_regular, dept_transfer, main_acct, sub_acct_sym, fiscal_year,

\-- counter

\--

\-- Notes:

\--

\-- History:

\-- 01.13.00, Created. Robert Connolly (rc).

\-- 01.15.00, Added Header row. rc.

\-- 01.23.00, Implemented All distr_codes\'s selection when

\-- \@distr_code = blank or \@distr_code is null. rc.

\-- 02.05.01, Added parameter \@appl_user_id. rc.

\-- 05.07.01, Modified Header; changed column to last_activ_date. rc.

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-- pflt_und612: returns flat-file data for the und 612

\-- (6655_ral \-- Receipt Account Ledger) report.

\--

\-- Input:

\-- \@appl_user_id: user identifier; if null or blank, superuser access.

\-- \@acctng_year: YYYY format; \[if null, all are selected.?\]

\-- \@acctng_month: MM format; \[if null, all are selected.?\]

\-- \@dept_number: department number; \[if null, all are selected.?\]

\--

\-- Output:

\-- Header Row:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'H\'

\-- IAS ID 2 9 8 \'IAS00612\'

\-- Version 10 15 6 \'VER001\'

\-- Date-Time 16 38 23 \'CCYY-MM-DDThh:mi:ss.mmm\'

\--

\-- Detail Rows:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'D\'

\-- acctng_year+month 2 7 6 yyyymm

\-- dept_number 8 9 2 99

\-- dept_regular 10 11 2 99

\-- main_acct 12 15 4 9999

\-- sub_acct_sym 16 18 3 \[999\|blank if 000\]

\-- rec_type 19 19 1 9

\-- trans_code 20 21 2 99

\-- trans_alc 22 29 8 999999999

\-- amt 30 47 18 999999999999999.99

\-- ref_num 48 55 8 XXXXXXXX

\-- rptng_date 56 61 6 yyyymm

\-- type_ind 62 62 1 \[A\|blank\]

\--

\-- Example:

\-- HIAS00612VER0012001-05-07T21:45:00.980

\-- Dyyyymm9999999999999999999999-99999999999999.99XXXXXXXXyyyymmA

\-- Dyyyymm99999999 99999999999999999999999999.99XXXXXXXXyyyymm

\--

\-- Sort order:

\-- acctng_year, acctng_month,

\-- dept_number,

\-- dept_regular, main_acct, sub_acct_sym,

\-- rec_type, counter

\--

\-- Notes:

\--

\-- History:

\-- 01.13.01, Created. Robert Connolly (rc).

\-- 01.15.01, Added Header row. rc.

\-- 02.05.01, Implemented All dept_number\'s selection when

\-- \@dept_number = blank or \@dept_number is null. rc.

\-- 02.05.01, Added parameter \@appl_user_id. rc.

\-- 05.07.01, Modified Header. rc.

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-- pflt_und613: returns flat-file data for the und 613

\-- (6655_ratb \-- Receipt Account Trial Balance) report.

\--

\-- Input:

\-- \@appl_user_id: user identifier; if null or blank, superuser access.

\-- \@acctng_year: YYYY format; \[if null, all are selected.?\]

\-- \@acctng_month: MM format; \[if null, all are selected.?\]

\-- \@dept_number: department number; \[if null, all are selected.?\]

\--

\-- Output:

\-- Header Row:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'H\'

\-- IAS ID 2 9 8 \'IAS00613\'

\-- Version 10 15 6 \'VER001\'

\-- Date-Time 16 38 23 \'CCYY-MM-DDThh:mi:ss.mmm\'

\--

\-- Detail Rows:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'D\'

\-- acctng_year+month 2 7 6 yyyymm

\-- dept_number 8 9 2 99

\-- dept_regular 10 11 2 99

\-- main_acct 12 15 4 9999

\-- sub_acct_sym 16 18 3 \[999\|blank if 000\]

\-- ytd_ttl_amt 19 36 18 999999999999999.99

\-- cmo_ttl_amt 37 54 18 999999999999999.99

\-- last_activ_date 55 60 6 yyyymm

\-- type_ind 61 61 1 \[A\|blank\]

\--

\-- Example:

\-- HIAS00613VER0012001-05-07T21:45:00.980

\-- Dyyyymm9999999999999999999999-99999999999999.99XXXXXXXXyyyymmA

\-- Dyyyymm99999999 99999999999999999999999999.99XXXXXXXXyyyymm

\--

\-- Sort order:

\-- acctng_year, acctng_month,

\-- dept_number,

\-- dept_regular, main_acct, sub_acct_sym,

\-- last_activ_date, type_ind

\--

\-- Notes:

\--

\-- History:

\-- 01.13.01, Created. Robert Connolly (rc).

\-- 01.15.01, Added Header row. rc.

\-- 02.05.01, Implemented All dept_number\'s selection when

\-- \@dept_number = blank or \@dept_number is null. rc.

\-- 02.05.01, Added parameter \@appl_user_id. rc.

\-- 05.07.01, Modified Header; changed column to last_activ_date. rc.

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-- pflt_und614: returns flat-file data for the und 614

\-- (6655_urt \-- Report of Unavailable Receipt Transactions) report.

\--

\-- Input:

\-- \@appl_user_id: user identifier; if null or blank, superuser access.

\-- \@acctng_year: YYYY format; \[if null, all are selected.?\]

\-- \@acctng_month: MM format; \[if null, all are selected.?\]

\-- \@dept_number: department number; \[if null, all are selected.?\]

\-- \@distr_code: distribution code; \[if null or blank, all are
selected.\]

\--

\-- Output:

\-- Header Row:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'H\'

\-- IAS ID 2 9 8 \'IAS00614\'

\-- Version 10 15 6 \'VER001\'

\-- Date-Time 16 38 23 \'CCYY-MM-DDThh:mi:ss.mmm\'

\--

\-- Detail Rows:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'D\'

\-- acctng_year+month 2 7 6 yyyymm

\-- dept_number+distr_code 8 11 4 9999

\-- dept_regular 12 13 2 99

\-- main_acct 14 17 4 9999

\-- sub_acct_sym 18 20 3 \[999\|blank if 000\]

\-- rec_type 21 21 1 9

\-- trans_alc 22 29 8 999999999

\-- amt 30 47 18 999999999999999.99

\-- ref_num 48 55 8 XXXXXXXX

\-- rptng_date 56 61 6 yyyymm

\--

\-- Example:

\-- HIAS00614VER0012001-05-07T21:45:00.980

\-- Dyyyymm9999999999999999999999-99999999999999.99XXXXXXXXyyyymm

\-- Dyyyymm9999999999 999999999999999999999999.99XXXXXXXXyyyymm

\--

\-- Sort order:

\-- acctng_year, acctng_month,

\-- dept_number, distr_code,

\-- dept_regular, main_acct, sub_acct_sym,

\-- rec_type, counter

\--

\-- Notes:

\--

\-- History:

\-- 01.13.00, Created. Robert Connolly (rc).

\-- 01.15.00, Added Header row. rc.

\-- 01.23.00, Implemented All distr_codes\'s selection when

\-- \@distr_code = blank or \@distr_code is null. rc.

\-- 02.05.01, Added parameter \@appl_user_id. rc.

\-- 05.07.01, Modified Header. rc.

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--

\-- pflt_aw810: returns flat-file data for appropriation warrants 810
report.

\--

\-- Input:

\-- \@appl_user_id: user identifier; if null or blank, superuser access.

\-- \@dept_number: agency identifier; if null or blank, all are
selected.

\-- \@distr_code: office identifier; if null or blank, all are selected.

\-- \@acctng_begin: acctng_date (YYYYMM); if null, select from earliest.

\-- \@acctng_end: acctng_date (YYYYMM); if null, select through latest.

\-- \@treas_acct_sym: if null, selects all accounts.

\--

\-- Output:

\-- Header Row:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'H\'

\-- IAS ID 2 9 8 \'IAS00810\'

\-- Version 10 15 6 \'VER001\'

\-- Date-Time 16 38 23 \'CCYY-MM-DDThh:mi:ss.mmm\'

\--

\-- Detail Rows:

\-- Field Name Start End Length Format/Data

\-- Indicator 1 1 1 \'D\'

\-- acctng_date 2 7 6 yyyymm

\-- post_date 8 15 8 yyyymmdd

\-- ref_num 16 23 8 XXXXXXXX

\-- legal_citation 24 78 55 X\...X

\-- sub_class 79 80 2 99

\-- dept_regular 81 82 2 99

\-- dept_transfer 83 84 2 99

\-- fiscal_year 85 88 4 XXXX

\-- main_acct 89 92 4 9999

\-- sub_acct_sym 93 95 3 \[999\|blank if 000\]

\-- trans_amt 96 118 23 99999999999999999999.99

\--

\-- Example:

\-- HIAS00810VER0012001-05-07T21:45:00.980

\--
DyyyymmyyyymmddXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX999999XXXX999999999999999999999999999.99

\--
DyyyymmyyyymmddXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX999999XXXX9999999-9999999999999999999.99

\--
DyyyymmyyyymmddXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX999999XXXX9999
99999999999999999999.99

\--

\--

\-- Notes:

\--

\-- History:

\-- 01.30.01, Created. Robert Connolly (rc).

\-- 02.01.01, Added parameter \@appl_user_id. rc.

\-- 02.05.01, Changed post_date to yyyymmdd from yyyymm. rc.

\-- 05.07.01, Modified Header. rc.

\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\--