StoneRiver has four record types: T, D, A, and F. See Table 1.
Table 1: Files and record types StoneRiver accepts and BriteCore supports.
Code | Name | Description | Uses |
T | TransactionRecord | The primary record required by exported transactions. | Return premiums Claim payments Commission payments |
D | DistributionRecord | A record that stores vendor and accounting information, such as FEIN and account numbers. | Claim payments Commission payments |
A | PayeeAddressRecord | A record that stores address information printed on the check. | Return premiums Claim payments |
F | CheckDescriptionRecord | Free-form description records that add additional printable information to a check. | Claim payments |
StoneRiver record layouts
Each StoneRiver record type has a different layout.
T Record
(‘RecordID’, 1, COBOL_str(1)),
(‘RecordGroupCode’, 4, COBOL_num(4)),
(‘VendorID’, 10, COBOL_str(10)),
(‘CheckType’, 1, COBOL_str(1)),
(‘RemitToVendorId’, 10, COBOL_str(10)),
(‘TransactionType’, 1, COBOL_str(1)),
(‘SelectionGroup’, 3, COBOL_str(3)),
(‘PrintingGroupCode’, 3, COBOL_str(3)),
(‘UserDefinedField’, 24, COBOL_str(24)),
(‘InvoiceNumber’, 12, COBOL_str(12)),
(‘AppliesToInvoiceNumber’, 12, COBOL_str(12)),
(‘InvoiceDate’, 8, COBOL_num(8)),
(‘InvoiceAmount’, 11, COBOL_num_trailing(11,2)),
(‘NonDiscountAmount’, 11, COBOL_num_trailing(11,2)),
(‘TermsCode’, 3, COBOL_str(3)),
(‘DueDate’, 8, COBOL_num(8)),
(‘DiscountDate’, 8, COBOL_num(8)),
(‘DiscountPercent’, 4, COBOL_num(4,2)),
(‘DiscountAmount’, 11, COBOL_num_trailing(11,2)),
(‘JobCode’, 6, COBOL_str(6)),
(‘Sundry’, 30, COBOL_str(30)),
(‘VoucherReference’, 30, COBOL_str(30)),
(‘PrePaymentBankCode’, 3, COBOL_str(3)),
(‘PrePaymentCheckNumber’, 10, COBOL_num(10)),
(‘PrePaymentCheckDate’, 8, COBOL_num(8)),
(‘UseTaxVendorId’, 10, COBOL_str(10)),
(‘UseTaxDueDate’, 8, COBOL_num(8)),
(‘UseTaxPercent’, 4, COBOL_num(4,2)),
(‘UseTaxAdjustment’, 11, COBOL_num_trailing(11,2)),
(‘UseTaxAmount’, 11, COBOL_num_trailing(11,2)),
(‘UCPPropertyID’, 5, COBOL_str(5)),
(‘OptionalVoucherDate’, 8, COBOL_str(8)), # is a num in spec, use str because it’s
“optional”
(‘Filler’, 111, COBOL_str(111)),
D Record
(‘RecordID’, 1, COBOL_str(1)),
(‘RecordGroupCode’, 4, COBOL_num(4)),
(‘VendorID’, 10, COBOL_str(10)),
(‘InvoiceNumber’, 12, COBOL_str(12)),
(‘SequenceNumber’, 3, COBOL_num(3)),
(‘DistributionType1’, 1, COBOL_str(1)),
(‘AccountNumber1’, 24, COBOL_str(24)),
(‘Source1’, 6, COBOL_str(6)),
(‘AllocationCode1’, 6, COBOL_str(6)),
(‘Suspense1’, 15, COBOL_str(15)),
(‘DistributionAmount1’, 11, COBOL_num_trailing(11, 2)),
(‘TaxAmount1’, 11, COBOL_num_trailing(11, 2)),
(‘Description1’, 30, COBOL_str(30)),
(‘Filler1’, 1, COBOL_str(1)),
(‘DistributionType2’, 1, COBOL_str(1)),
(‘AccountNumber2’, 24, COBOL_str(24)),
(‘Source2’, 6, COBOL_str(6)),
(‘AllocationCode2’, 6, COBOL_str(6)),
(‘Suspense2’, 15, COBOL_str(15)),
(‘DistributionAmount2’, 11, COBOL_num_trailing(11, 2)),
(‘TaxAmount2’, 11, COBOL_num_trailing(11, 2)),
(‘Description2’, 30, COBOL_str(30)),
(‘Filler2’, 1, COBOL_str(1)),
(‘DistributionType3’, 1, COBOL_str(1)),
(‘AccountNumber3’, 24, COBOL_str(24)),
(‘Source3’, 6, COBOL_str(6)),
(‘AllocationCode3’, 6, COBOL_str(6)),
(‘Suspense3’, 15, COBOL_str(15)),
(‘DistributionAmount3’, 11, COBOL_num_trailing(11, 2)),
(‘TaxAmount3’, 11, COBOL_num_trailing(11, 2)),
(‘Description3’, 30, COBOL_str(30)),
(‘Filler3’, 1, COBOL_str(1)),
(‘Filler’, 55, COBOL_str(55)),
A Record
(‘RecordID’, 1, COBOL_str(1)),
(‘RecordGroupCode’, 4, COBOL_num(4)),
(‘VendorID’, 10, COBOL_str(10)),
(‘InvoiceNumber’, 12, COBOL_str(12)),
(‘Name’, 50, COBOL_str(50)),
(‘Address1’, 50, COBOL_str(50)),
(‘Address2’, 50, COBOL_str(50)),
(‘Address3’, 50, COBOL_str(50)),
(‘Address4’, 50, COBOL_str(50)),
(‘ABA Number’, 9, COBOL_str(9)),
(‘BankAccountNumber’, 17, COBOL_str(17)),
(‘BankAccountType’, 1, COBOL_str(1)),
(‘EFTStartDate’, 8, COBOL_num(8)),
(‘Filler’, 88, COBOL_str(88)),
F Record
(‘RecordID’, 1, COBOL_str(1)),
(‘RecordGroupCode’, 4, COBOL_num(4)),
(‘VendorID’, 10, COBOL_str(10)),
(‘InvoiceNumber’, 12, COBOL_str(12)),
(‘SequenceNumber’, 3, COBOL_num(3)),
(‘Description1’, 66, COBOL_str(66)),
(‘Amount1’, 11, COBOL_num_trailing(11,2)),
(‘Filler’, 1, COBOL_str(1)),
(‘Description2’, 66, COBOL_str(66)),
(‘Amount2’, 11, COBOL_num_trailing(11,2)),
(‘Filler’, 1, COBOL_str(1)),
(‘Description3’, 66, COBOL_str(66)),
(‘Amount3’, 11, COBOL_num_trailing(11,2)),
(‘Filler’, 1, COBOL_str(1)),
(‘Description4’, 66, COBOL_str(66)),
(‘Amount4’, 11, COBOL_num_trailing(11,2)),
(‘Filler’, 1, COBOL_str(1)),
(‘Filler’, 58, COBOL_str(58)),