Brazilian regulatory files

You can use Pismo-generated files for Brazilian Central Bank (BCB) required reports. You need to adjust these files and the information they contain according to government and bank requirements before sending them in.

📘

More files available

The files listed below do not constitute a comprehensive list. Contact your Pismo representative if there's something else you require or would like to see.

CADOC 3040


title: "JOB CADOC 3040"
slug: "job-cadoc-3040"
hidden: false
createdAt: "2020-03-13T17:54:55.596Z"
updatedAt: "2020-08-20T18:14:13.852Z"


Sample payload
The files contain JSON data with the following format:

{
    "Org_ID": "TN-55317847-57cd-45a3-8aed-a8dadd63cc6b",
    "RefDate": "2019-12-25",
    "Type": "03",
    "Program_ID": 10,
    "ProgramName": "PROGRAM NAME",
    "Account_ID": 12345678,
    "Name": "SOMEONE'S NAME",
    "EntityType_ID": 1,
    "DocumentNumber": "99999999999",
    "CreationDate": "2019-12-25",
    "OpenDueDate": "2019-12-24",
    "Amount": 136.38,
    "OperationDate": "2019-12-24",
    "OperationDueDate": "2019-12-24",
    "PrincipalAmount": 136.38,
    "NumberOfInstallments": 1,
    "Installment": 1,
    "InstallmentAmount": 0,
    "InterestRate": 9.9
}

Field formatting (dtypes)

[
    ('Org_ID', 'string'), 
    ('efDate', 'date'), 
    ('Type', 'string'), 
    ('Program_ID', 'int'), 
    ('ProgramName', 'string'), 
    ('Account_ID', 'int'), 
    ('Name', 'string'), 
    ('EntityType_ID', 'int'), 
    ('DocumentNumber', 'string'), 
    ('CreationDate', 'timestamp'), 
    ('OpenDueDate', 'date'), 
    ('Amount', 'double'), 
    ('OperationDate', 'date'), 
    ('OperationDueDate', 'date'), 
    ('PrincipalAmount', 'double'), 
    ('NumberOfInstallments', 'int'), 
    ('Installment', 'int'), 
    ('InstallmentAmount', 'int'), 
    ('InterestRate', 'decimal(3,2)')
]

Bucket path
reports/cadoc3040/type=<type>/ partitioned by date year=YYYY/month=MM/day=DD.

Type field

  • 01 - Invoice installment
    Rule: Sum of balance transactions (TransactionBalance) of type 702 REFINANCING INSTALLMENT created before file generation and with a due date in the future.

  • 02 - Interest-free installments
    Rule: Sum of balance transactions (TransactionBalance) of type 112 INSTALLMENT WITHOUT INTEREST created before the generation of the file and with a future due date.

  • 03 - Delayed rotary
    Rule: Accounts with open invoices, with overdue transactions and with a balance > 0 and whose OpenDueDate < current date, that is, the customer has not yet paid the minimum invoice amount.

  • 04 - Revolving up-to-date
    Rule: Accounts with current invoices, with overdue transactions and with a balance > 0 and whose OpenDueDate > current date, that is, transactions are overdue but paid the minimum amount on the last invoice. It can be between cut and expiration.

  • 09 - National withdrawal
    Rule: Sum of balance transactions (TransactionBalance) of type 123 WITHDRAWAL created before the generation of the file and with a future due date.

  • 10 - The view
    Rule: Sum of balance transactions (TransactionBalance) other than types 112, 123, 122, 702 created before file generation and with a future due date.

  • 13 - Limits
    Rule: Brings generic data about the account (Account ID, program name, creation date, etc.) and some data about account limits, such as AvailableCreditLimit and TotalCreditLimit.

CADOC 3050


title: "JOB CADOC 3050"
slug: "job-cadoc-3050"
excerpt: "Contains registries of contracts with interest and/or debt that are yet to come due."
hidden: false
createdAt: "2020-03-13T17:56:22.683Z"
updatedAt: "2020-06-08T22:11:30.996Z"


Sample payload
The files contain JSON data with the following format:

{
    "Org_ID": "TN-55317847-57cd-45a3-8aed-a8dadd63cc6b",
    "RefDate": "2020-01-06",
    "Account_ID": 12345678,
    "OperationType": "InterestPurchase",
    "PrincipalAmount": 316.82,
    "ContractAmount": 338.25,
    "IOFAmount": 2.31,
    "EventDate": 4.5357426177557e+25,
    "DueDate": "2020-03-19",
    "InterestRate": 5.99,
    "Installment": 3,
    "NumberOfInstallments": 3,
    "DueDays": 3
}

Field formatting (dtypes)

 [
    ('Org_ID', 'string'),
    ('RefDate', 'date'), 
    ('Account_ID', 'int'), 
    ('OperationType', 'string'), 
    ('PrincipalAmount', 'double'), 
    ('ContractAmount', 'double'), 
    ('IOFAmount', 'double'), 
    ('EventDate', 'timestamp'), 
    ('DueDate', 'date'), 
    ('InterestRate', 'double'), 
    ('Installment', 'int'), 
    ('NumberOfInstallments', 'int'), 
    ('DueDays', 'int')
]

Bucket path
reports/cadoc3050/type=<type>/ partitioned by date year=YYYY/month=MM/day=DD.

DECRED


title: "JOB DECRED"
slug: "job-decred"
hidden: false
createdAt: "2020-03-13T17:35:57.729Z"
updatedAt: "2020-08-20T18:14:47.823Z"


Sample payload
The files contain JSON data with the following format:

{
    "Org_ID": "TN-55317847-57cd-45a3-8aed-a8dadd63cc6b",
    "RefDate": "2019-12-25",
    "Account_ID": 12345678,
    "DocumentNumber": "12345678900",
    "Program_ID": 10,
    "ProgramName": "PROGRAM NAME",
    "Name": "SOMEONE'S NAME",
    "YearAmount": 2019,
    "MonthAmount": 12,
    "Amount": 82.4
}

Field formatting (dtypes)

[
    ('Org_ID', 'string'), 
    ('RefDate', 'date'), 
    ('Account_ID', 'int'), 
    ('DocumentNumber', 'string'), 
    ('Program_ID', 'int'), 
    ('ProgramName', 'string'), 
    ('Name', 'string'), 
    ('YearAmount', 'bigint'), 
    ('MonthAmount', 'bigint'), 
    ('Amount', 'double')
]

Bucket path
reports/decred/type=<type>/ partitioned by date year=YYYY/month=MM/day=DD.

DOC 5816


title: "JOB DOC 5816"
slug: "job-doc-5816"
hidden: false
createdAt: "2020-03-13T17:37:39.144Z"
updatedAt: "2020-08-20T18:15:02.432Z"


Sample payload
The files contain JSON data with the following format:.

 {
    "Org_ID": "TN-55317847-57cd-45a3-8aed-a8dadd63cc6b",
    "RefDate": "2019-12-25",
    "Account_ID": 12345678,
    "DocumentNumber": "12345678900",
    "Program_ID": 10,
    "ProgramName": "PROGRAM NAME",
    "Name": "SOMEONE'S NAME",
    "AccountingDate": "2019-12-25",
    "MerchantName": "Merchant's Name",
    "BRLAmount": 55.48,
    "USDAmount": 13.13
}

Field formatting (dtypes)

[
    ('Org_ID', 'string'), 
    ('RefDate', 'date'), 
    ('Account_ID', 'int'), 
    ('DocumentNumber', 'string'), 
    ('Program_ID', 'int'), 
    ('ProgramName', 'string'), 
    ('Name', 'string'), 
    ('AccountingDate', 'date'), 
    ('MerchantName', 'string'), 
    ('BRLAmount', 'double'), 
    ('USDAmount', 'double'),
]

Bucket path
reports/doc5816/type=<type>/ partitioned by date year=YYYY/month=MM/day=DD.


Did this page help you?