Auto Reconciliation

Dataset Descriptions

Entity: BATCH-TOTALS
Batch-Totals is used to store dollar totals by Transaction Code for all transaction types processed by AM11200 (batch balance) and reported on report AM11409-002.

	01  BATCH-TOTALS STANDARD DATA SET
	    BT-ACCT-MONTH SET OF BATCH-TOTALS 	KEYS ARE
			BIENNIUM-IND,ACCOUNTING-MONTH, RUN-NUMBER,
			TRANSACTION-CODE, ENTRY-TYPE
	    BT-DATE-RUN SET OF BATCH-TOTALS	KEYS ARE
			BIENNIUM-IND,PROCESS-DATE, RUN-NUMBER,
                        TRANSACTION-CODE, ENTRY-TYPE
	    02  BT-KEY-DATA.
		03  BIENNIUM-IND		PIC X(04).
		03  ACCOUNTING-MONTH		PIC 9(02)	COMP-2.
		03  PROCESS-DATE		PIC 9(08)	COMP-2.
		03  RUN-NUMBER			PIC X(03).
		03  TRANSACTION-CODE		PIC X(02).
		03  ENTRY-TYPE			PIC X(20).
	    02  BT-AMOUNT			PIC S9(11)V99	COMP-2.

Entity: Report-Totals

The Report-Totals data set is used to store transaction journal totals processed by AM12000 (explosion) and reported on reports AM18009-007 through AM18009-025, ledger activity totals processed by AM14103, AM14203, AM14303, and AM14403 and reported on reports AM18009-030 through AM18009-039, as well as variety of month end report totals to support the monthly reconcilication of the Financial Accounting System.

	01  REPORT-TOTALS STANDARD DATA SET
            RT-ACCT-MONTH SET OF DAILY-ACTIVITY   KEYS ARE
                        BIENNIUM-IND,ACCOUNTING-MONTH, RUN-NUMBER,
                        REPORT-NUMBER, ENTRY-TYPE
            RT-DATE-RUN SET OF DAILY-ACTIVITY     KEYS ARE
                        BIENNIUM-IND,PROCESS-DATE, RUN-NUMBER,
                        REPORT-NUMBER, ENTRY-TYPE
            02  RT-KEY-DATA.
                03  BIENNIUM-IND                PIC X(04).
                03  ACCOUNTING-MONTH            PIC 9(02)       COMP-2.
                03  PROCESS-DATE                PIC 9(08)       COMP-2.
                03  RUN-NUMBER                  PIC X(03).
                03  REPORT-NUMBER               PIC X(17).
                03  ENTRY-TYPE                  PIC X(20).
            02  RT-AMOUNT                       PIC S9(11)V99   COMP-2.

Entity: FUND-TOTALS

The Fund-Totals dataset is used to store fund summary totals as processed by the ledger update program and reported on reports AM18009-040 through AM18009-049.

	01  FUND-TOTALS STANDARD DATA SET 
            FT-ACCT-MONTH SET OF FUND-TOTALS   KEYS ARE
                        BIENNIUM-IND,ACCOUNTING-MONTH, RUN-NUMBER,
                        REPORT-NUMBER, FUND, ENTRY-TYPE
            FT-DATE-RUN SET OF FUND-TOTALS     KEYS ARE
                        BIENNIUM-IND,PROCESS-DATE, RUN-NUMBER,
                        RUN-NUMBER, FUND, ENTRY-TYPE
            02  FT-KEY-DATA.
                03  BIENNIUM-IND                PIC X(04).
                03  ACCOUNTING-MONTH            PIC 9(02)       COMP-2.
                03  PROCESS-DATE                PIC 9(08)       COMP-2.
                03  RUN-NUMBER                  PIC X(03).
                03  REPORT-NUMBER               PIC X(17).
		03  FUND			PIC X(03).
                03  ENTRY-TYPE                  PIC X(20).
            02  FT-AMOUNT                       PIC S9(11)V99   COMP-2.

Entity: FUND-ADJUSTMENTS

The Fund-Adjustments data set is used to store dollar amounts entered by accounting to correct descrepancies between the subsidiary ledgers and the General Ledger control accounts.

	01  FUND-ADJUSTMENTS STANDARD DATA SET
	    FUND-ADJUST-SET OF FUND-ADJUSTMENTS   KEYS ARE
			BIENNIUM-IND, REPORT-NUMBER, FUND, ENTRY-TYPE.
	    02  FA-KEY-DATA.
		03  BIENNIUM-IND 		PIC X(04).
		03  REPORT-NUMBER		PIC X(17).
		03  FUND			PIC X(03).
		03  ENTRY-TYPE			PIC X(20).
	    02  BEGIN-RUN-NUMBER		PIC X(03).
	    02  END-RUN-NUMBER			PIC X(03).
	    02  FA-AMOUNT			PIC S9(11)V99   COMP-2.
	    02  FA-COMMENTS			PIC X(300).