DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 1 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 BATCH FILE MAINTENANCE TRANSACTION LISTING ....V....1....V....2....V....3....V....4....V....5....V....6....V....7....V....8 PGM=XBA050,DATE=04/18/96,SYSTEM=FRS DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 2 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT $$$ BATCH HEADER CARD F 128 000 .................................................................................................................................. . 11111111111111111111111111111. . 11111111112222222222333333333344444444445555555555666666666677777777778888888888999999999900000000001111111111222222222. .12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678. . . .AAABBBBBBCCCCCCDDDDDDDDDDDDDDDEFFGGGGGHHHHHHHHHHHIII JJJJJJJJKKLMNOP QQQRRSS . . . .................................................................................................................................. DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN A TRANSACTION CODE REQUIRED. MUST BE '$$$'. 001 03 (001-003) B FZ060 BATCH ID 004 06 000 000 X 00 0 (004-009) Required. Alphanumeric code which forms a unique key to this batch along with the batch date. Typically, the first three positions are alphabetic, and the last three characters are numeric. C FZ080 BATCH DATE 010 06 000 000 X 00 0 (010-015) Required. mmddyy, where mm is between 01 and 12, dd is between 01 and 31, and yy is a valid, two-digit number. D FZ100 BATCH DESC 016 15 000 000 X 00 0 (016-030) Optional. Fifteen alphanumeric characters to describe the type of transactions in this batch. This description prints on the Daily Diagnostics Report. E FZ110 BATCH LIST OPT 031 01 000 000 X 00 0 (031-031) Optional. This flag does not apply to on-line processing. Possible values are: Y,* List all transactions in the batch on the Daily Diagnostics Report (produced by VBD010 or FBD010) whether the batch is in or out of balance. (CONTINUED) DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 3 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT $$$ BATCH HEADER CARD F 128 000 (CONTINUED) DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN N List the transactions in the batch on the report only if the batch is out of balance. blank Defaults to N. F FZ126 BATCH USER CODE 032 02 000 000 X 00 0 (032-033) * Change Log: 06/16/94 lw: SCT TOS FRIBM151 Identifies the FRS application to which the batch belongs: FA, AP or FX. The FRS Data Collect Separator (FBA900) uses this value to separate FRS Data Collect batches by application. If FBA900 does not recognize the User Code, it consigns the batch to FA. G FZ104 BATCH TRANS CNT 034 05 000 000 N 00 0 (034-038) Optional. Number of transactions in this batch. Right justified. The system compares this count with its calculation of the number of trans- actions in this batch. If the counts are not equal, the batch is out of balance. H FZ102 BATCH TRANS AMT 039 11 000 000 N 00 0 (039-049) Optional. Gross dollar amount of all dollar transactions in this batch. Right justified. The system compares its calculation of the absolute amount with the entered hash amount. If the amounts are not equal, the batch is out of balance. I FZ108 BATCH SUSP ID 050 03 000 000 X 00 0 (050-052) Not used in AP but is optional in FA. Distinguishes this as a payroll or miscellaneous batch. (CONTINUED) DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 4 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT $$$ BATCH HEADER CARD F 128 000 (CONTINUED) DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN Valid values are: PRL - Payroll. MIS - Miscellaneous (default). This defines which of two suspense accounts the system should use to direct invalid entries in this batch. J FZ124 BATCH ORIGINATOR 054 08 000 000 X 00 0 (054-061) Optional. Person responsible for this batch. K FZ106 BATCH BANK NO 062 02 000 000 X 00 0 (062-063) * Change Log: 09/01/93 l3w SCT TOS FRIBM122 Optional. Two-digit bank number affected by the transactions in this batch. In AP, specific voucher transactions TC=140-189 allow the user to override the default by specifying the bank on those trans- actions. For both FA and AP the system allows bank numbers 1-98. An entry not in this range defaults to 30. L FZ127 BATCH HOLD FLAG 064 01 000 000 X 00 0 (064-064) Optional. For AP only. This flag determines whether to put the vouchers in this batch on Hold Payment status. Y All vouchers in this batch will be journalized but not paid. N All vouchers in this batch will be journalized and paid when due. blank Defaults to N. M FZ128 BATCH FAS FEED FLAG 065 01 000 000 X 00 0 (065-065) Optional. For AP only. Specifies (CONTINUED) DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 5 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT $$$ BATCH HEADER CARD F 128 000 (CONTINUED) DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN whether the system generates FA transactions via the Accounting Feed Generator Program (VBD020) for transactions in this AP batch. Feed may be on an accrual or cash basis. Valid values are: Y Generate FA transactions. N Do not feed FA for any vouchers, credit memos, or prepaids in this batch. Voucher delete and voids may or may not feed FA, based on the original Input Batch flags. blank Defaults to Y. N FZ129 BATCH VCHR FEED FLAG 066 01 000 000 X 00 0 (066-066) Optional. For AP only. Indicates whether the system generates FA transactions according to cash accrual basis accounting methods in this AP batch. Valid values are: Y (Accrual basis accounting). The system generates entries to FA for all vouchers, credit memos, prepaids, and voids in the batch. N (Cash basis accounting). Only prepaids and voids are fed directly to accounting. Other vouchers and credit memos are not fed until they process through the Check Cycle. blank Defaults to Y. O FZ130 BATCH ACPT OUT OF BA 067 01 000 000 X 00 0 (067-067) Optional. For AP only. This flag does not apply to on-line processing. Valid values are: Y The system accepts a batch for which the absolute dollar (CONTINUED) DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 6 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT $$$ BATCH HEADER CARD F 128 000 (CONTINUED) DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN amount and/or the record count on the batch header record does not agree with the system's calculation. N If the batch is out of balance, it is rejected. blank Defaults to Y. P FZ137 BATCH ACCTG FEED IND 068 01 000 000 X 00 0 (068-068) Optional. For FX only. This flag does not apply to FA or AP processing. Valid values are: D Feed accounting detail transactions for each asset record capitalized. Each fixed assets transaction that has an accounting implication and is for an asset being capitalized will generate a separate transaction to accounting. S Feed summary transactions to accounting for transactions to assets that are being capitalized. Each fixed assets transaction that has an accounting implication and is for an asset being capitalized will have its dollars for each unique combination of debit and credit account aggregated with dollars from other assets. There will be only one transaction per feed to accounting for all asset transactions marked for a summary feed and having the same debit and credit accounts. N Do not feed accounting at all due to those transactions to fixed assets that are contained within this batch. blank Defaults to the value on the fixed assets system control record. Q FZ136 BATCH SPECIAL PROCES 087 03 000 000 X 00 0 (087-089) Optional. For FA only. The value (CONTINUED) DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 7 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT $$$ BATCH HEADER CARD F 128 000 (CONTINUED) DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN CJE indicates that this is a Compound Journal Entry batch and that all edits and processing related to this type of transaction need to take place. R FZ138 BATCH FY 090 02 000 000 X 00 0 Y (090-091) Optional. This field indicates to which year the transactions in the batch pertain. (Some transactions are not FY specific.) If the FY is not input, then the current FY will be obtained from the FA system control record. If input, then it must be a valid, active year. S FZ140 BATCH CAMPUS CODE 092 02 000 000 X 00 0 Y (092-093) Optional. This field need not be input unless the multi-campus processing option is in effect. It indicates to which campus the transactions in the batch belong. The default and other valid values are loaded to the system via the FBI005 table load option. DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 8 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT 00A GL ATTRIBUTE RECORDS F 128 FG 000 .................................................................................................................................. . 11111111111111111111111111111. . 11111111112222222222333333333344444444445555555555666666666677777777778888888888999999999900000000001111111111222222222. .12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678. . . .AAABBBBBBBBBBCCCCCCCCCCCCCCCCCCCCDDDDDDDDDDDDDDDDDDDDEEEEEEEEEEEEEEEEEEEEF . . . .................................................................................................................................. DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN A TRANSACTION CODE REQUIRED. MUST BE '00A'. 001 03 (001-003) B FG009 ACCOUNT NUMBER 004 10 000 000 N 00 0 Y (004-013) Required. Ten-digit GL account being created. The first six digits must be a valid numeric GL six-digit account number. Digit one must be 0 for all GL accounts. The last four digits must be 0000. C FG042 DESCRIPTION 014 20 000 000 X 00 0 (014-033) Optional. Twenty positions to describe the nature of the GL account. D FG043 RESP PERSON 034 20 000 000 X 00 0 (034-053) Optional. Twenty characters to fill in the name of the person respon- sible for this account. E FG044 ADDRESS 054 20 000 000 X 00 0 (054-073) Optional. Address of the office to which reports about this account are sent. F FG045 YEAR END PROCESS 074 01 000 000 X 00 0 (074-074) Optional. One alphanumeric position to indicate whether this account is on a fiscal year cycle or a project cycle. Valid values are F (Fiscal), P (Project), and Y (Project). (CONTINUED) DATE RUN 04/18/96 AUBURN UNIVERSITY REPORT PAGE 9 TIME RUN 15:00:39 DATA BASE DEFINITION SYSTEM PROGRAM ID XBA050 FINANCIAL RECORDS SYSTEM BATCH FILE MAINTENANCE TRANSACTION LISTING TRAN TRANSACTION TRANSACTION TRANS FILE CODE DESCRIPTION PURPOSE TYPE LENGTH CODE SEGMENT 00A GL ATTRIBUTE RECORDS F 128 FG 000 (CONTINUED) DE DATA ELEMENT START SGN FCN SUB EDT SPC PRIOR KEY LTR ID DESCRIPTION COMMENTS POS LEN POS POS POS CLS EDT ITY MEMO ELMN