Need help with a specific integration?

StoneRiver record types and layouts

StoneRiver has four record types: T, D, A, and F. See Table 1.

Table 1: Files and record types StoneRiver accepts and BriteCore supports.

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)),

Additional information

Need help with a specific integration?

Related topics

Need help with a specific integration?