StoneRiver accepts and BriteCore supports the following files and record types:
- TransactionRecord
- Description: The primary record is required by exported transactions.
- Code: T
- Uses: Claim payments, commission payments, claim payments, and commission payments
- DistributionRecord
- Description: A record that stores vendor and accounting information, such as FEIN and account numbers.
- Code: D
- Uses: Claim payments and commission payments
- PayeeAddressRecord
- Description: A record that stores address information printed on the check.
- Code: A
- Uses: Return premiums and claim payments
- CheckDescriptionRecord
- Description: Free-form description records that add additional printable information to a check.
- Code: F
- Uses: 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))