Bank account

{

Attribute

Data type

Description

pk

PK

book_pk

Book PK

name

Text

Bank Account Name

bank_name

Text

Bank Name

account_number

Text

Bank Account Number

account_type

Bank Account Type

account_category

Bank Account Category

account_holder

List of strings

Name(s) of Bank Account Holder

holder_address_1
holder_address_2
holder_city
holder_state
holder_zip
holder_country

Text

Address of Bank Account Holder

activity_info

Activity Info

A series of date ranges indicating periods of activity
and inactivity in a Bank Account

periods

List of Periods

List of Statement Periods captured for this Bank Account

}

Activity info

{

Attribute

Data type

Description

active

List of Date Part Ranges

Series of date ranges during which this Bank Account shows activity.

missing

List of Date Part Ranges

Series of date ranges during which this Bank Account does not show activity.

}

{
  "active": [
    {
      "start": { "year": 2018, "day":  1, "month": 6 },
        "end": { "year": 2018, "day": 30, "month": 6 }
    },
    {
      "start": { "year": 2018, "day":  1, "month": 10 },
        "end": { "year": 2018, "day": 31, "month": 10 }
    }
  ],
  "missing": [
    {
      "start": { "year": 2018, "day": 30, "month": 6  },
        "end": { "year": 2018, "day":  1, "month": 10 }
    }
  ]
}

Date part range

{

Attribute

Data type

Description

start

Date Parts

end

Date Parts

}

{
  "start": { "year": 2018, "day":  1, "month": 6 },
    "end": { "year": 2018, "day": 30, "month": 6 }
}

Date parts

{

Attribute

Data type

Description

year

Integer

4-digit year

month

Integer

Month value between 1-12

day

Integer

Day of month

}


Did this page help you?