|
Column
|
Description
|
Changes
|
Missing or Invalid Values
|
Notes
|
|
Trans_ID
|
Transaction Identifier
|
None
|
N/A
|
Primary Key
|
|
Account_ID
|
Identification of the account transaction made on
|
None
|
N/A
|
Foreign Key
|
|
Date
|
Date of transaction
|
Format changed from YYMMDD to MM/DD/YYYY
|
Ignore
|
|
|
Type
|
+/- transaction
|
Translated Values:
- PRIJEM = Credit
- VYDAJ = Withdrawal
|
Replaced with "Withdrawal"
|
Each missing value had a corresponding "Withdrawal in Cash" for the Operation attribute
|
|
Operation
|
Mode of transaction
|
Translated values:
- VYBER KARTOU = Credit Card Withdrawal (CCW)
- VKLAD = Credit in Cash (CRC)
- PREVOD Z UCTU = Collection from Another Bank (CAB)
- VYBER = Withdrawal in Cash (WC)
- PREVOD NA UCET = Remittance to Another Bank (RAB)
|
Flag record - Do not use
|
|
|
Amount
|
Amount of transaction
|
None
|
Flag record - Do not use
|
|
|
Balance
|
Balance of account after transaction
|
None
|
Flag record - Do not use
|
|
|
K_Symbol
|
Characterization of transaction
|
Translated Values:
- POJISTNE = Insurance Payment (IP)
- SLUZBY = Payment on Statement (PS)
- UROK = Interest Credited (ICR)
- SANKC. UROK - Sanction Interest (SI)
- SIPO - Household (H)
- DUCHOD - Old-age Pension (OP)
- UVER - Loan Payment (LP)
|
Flag record - Do not use
|
Translated for ease of use
|
|
Bank
|
Bank of the partner
|
None
|
Flag record - Do not use
|
|
|
Account
|
Account of the partner
|
None
|
Flag record - Do not use
|
|
