FCLM_BRM_BSB

Total of Bank Service Billing Statement | #transactional | Component: Bank Account Management
Column Name Description
MANDT Client
BSB_UUID Bank Services Billing Statement UUID
Column Name Description
💲 Currency Key (BALANCE_CURRENCY):
BALANCE_AMOUNT Billing Amount
💲 Currency Key (COMPENSATION_CURRENCY):
COMPENSATION_AMOUNT Billing Amount
💲 Currency Key (SERVICE_UNIT_PRICE_CURRENCY):
SERVICE_UNIT_PRICE Billing Amount
💲 Currency Key (ORIGINAL_CHANGE_PRICE_CURRENCY):
ORIGINAL_CHARGE_PRICE Billing Amount
CALCD_PRICE Billing Amount
💲 Currency Key (ORIGINAL_CHARGE_SETTLEMENT_CCY):
ORIGINAL_CHARGE_SETTLEMENT_AMT Billing Amount
💲 Currency Key (BALANCE_REQUIRED_ACCOUNT_CCY):
BALANCE_REQUIRED_ACCOUNT_AMT Billing Amount
💲 Currency Key (TAX_SERVICE_CHARGE_HOST_CCY):
TAX_SERVICE_CHARGE_HOST_AMOUNT Billing Amount
💲 Currency Key (TAX_SERVICE_TAX_HOST_CURRENCY):
TAX_SERVICE_TAX_HOST_AMOUNT Billing Amount
💲 Currency Key (TAX_SERVICE_TAX_PRICING_CCY):
TAX_SERVICE_TAX_PRICING_AMT Billing Amount
💲 Currency Key (TAX_TOTAL_CHARGE_HOST_CURRENCY):
TAX_TOTAL_CHARGE_HOST_AMOUNT Billing Amount
💲 Currency Key (TAX_TOTAL_CHARGE_STTLM_CCY):
TAX_TOTAL_CHARGE_STTLM_AMT Billing Amount
💲 Currency Key (TAX_TOTAL_CHARGE_PRICG_CCY):
TAX_TOTAL_CHARGE_PRICG_AMT Billing Amount
💲 Currency Key (TOTAL_TAXABLE_SVC_CHRG_HST_CCY):
TOTAL_TAXABLE_SVC_CHRG_HST_AMT Billing Amount
💲 Currency Key (TAX_ID_TOTAL_TAX_CURRENCY):
TAX_ID_TOTAL_TAX_AMOUNT Billing Amount
💲 Currency Key (TAX_REGION_SETTLEMENT_CURRENCY):
TAX_REGION_SETTLEMENT_AMOUNT Billing Amount
💲 Currency Key (TAX_DUE_TO_REGION_CURRENCY):
TAX_DUE_TO_REGION_AMOUNT Billing Amount
💲 Currency Key (BALANCE_ADJUSTMENT_BALANCE_CCY):
BALANCE_ADJUSTMENT_BALANCE_AMT Billing Amount
💲 Currency Key (BALANCE_ADJUSTMENT_AVERAGE_CCY):
BALANCE_ADJUSTMENT_AVERAGE_AMT Billing Amount
💲 Currency Key (BALANCE_EARNINGS_ADJSTMNT_CCY):
BALANCE_EARNINGS_ADJSTMNT_AMT Billing Amount
💲 Currency Key (SERVICE_ADJUSTMENT_CURRENCY):
SERVICE_ADJUSTMENT_AMOUNT Billing Amount
💲 Currency Key (SVC_ADJSTMNT_BALANCE_REQRD_CCY):
SVC_ADJSTMNT_BALANCE_REQRD_AMT Billing Amount
💲 Currency Key (SVC_ADJSTMNT_PRICE_CHANGE_CCY):
SVC_ADJSTMNT_PRICE_CHANGE_AMT Billing Amount
💲 Currency Key (SVC_ADJSTMNT_ORGNL_PRICE_CCY):
SVC_ADJSTMNT_ORGNL_PRICE_AMT Billing Amount
💲 Currency Key (SVC_ADJSTMNT_NEW_PRICE_CCY):
SVC_ADJSTMNT_NEW_PRICE_AMT Billing Amount
💲 Currency Key (SVC_ADJSTMNT_ORGNL_CHRG_CCY):
SVC_ADJSTMNT_ORGNL_CHRG_AMT Billing Amount
💲 Currency Key (SVC_ADJSTMNT_NEW_CHRG_CCY):
SVC_ADJSTMNT_NEW_CHRG_AMT Billing Amount
Column Name Description
Column Name Description
FROM_DATE From Date
TO_DATE To Date
CREATION_DATE Bank Account Created On
CREATION_TIME Created At
DELAYED_DEBIT_DATE Bank Fee Statement Delayed Debit Date
EXCHANGE_QUOTATION_DATE Date
EXCHANGE_QUOTATION_TIME Field of type TIMS
TAX_REGION_POINT_DATE Date on which the tax calculation was performed
BALANCE_ADJUSTMENT_ERROR_DATE Error Date
BALANCE_ADJUSTMENT_POSTING_DT Posting Date
SERVICE_ADJUSTMENT_ERROR_DATE Error Date
VALIDFROM From Date
Column Name Description
LAST_PAGE_INDICATOR Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
STATUS Bank Fee Import Status Show values
STATEMENT_STATUS Billing Statement Status Show values
ACCOUNT_LEVEL Billing Statement Account Level Show values
ACCOUNT_ID_TYPE Account ID Type Show values
ACCOUNT_TYPE Account Type Show values
PARENT_ACCOUNT_LEVEL Billing Statement Account Level Show values
PARENT_ACCOUNT_ID_TYPE Account ID Type Show values
PARENT_ACCOUNT_TYPE Account Type Show values
COMPENSATION_METHOD Compensation Method Show values
DEBIT_ACCOUNT_ID_TYPE Account ID Type Show values
TAX_CALCULATION_METHOD Billing Tax Calculation Method Show values
BALANCE_CURRENCY_TYPE Currency Type Show values
COMPENSATION_CURRENCY_TYPE Currency Type Show values
SUB_SERVICE_ISSUER SubService Issuer ID Show values
BILLING_CHARGE_METHOD Billing Charge Method Show values
PAYMENT_METHOD Billing Service Payment Method Show values
TAX_DESIGNATION_CODE Service Tax Designation Code Show values
BALANCE_ADJUSTMENT_TYPE Balance Adjustment Type Show values
SERVICE_ADJUSTMENT_TYPE Service Adjustment Type Show values
SVC_ADJUSTMENT_SUB_SVC_ISSUER SubService Issuer ID Show values
VALIDATION_STATUS Service pricing status Show values
Column Name Description Domain name
REPORT_ID Bank Services Billing Statement Report ID CHAR40
PAGE_NUMBER Bank Fee Billing Statement Page Number INT4
GROUP_ID Bank Services Billing Statement Group ID CHAR35
SENDER_ID Statement Sender ID CHAR35
SENDER_OTHER_ID Statement Sender ID CHAR35
SENDER_NAME Statement Sender Name TEXT140
SENDER_COUNTRY Country/Region Key LAND1
BANK_COUNTRY Country/Region Key of Bank LAND1
BANK_KEY Bank Keys BANKK
RECEIVER_ID Statement Receiver ID CHAR35
RECEIVER_NAME Bank Service Billing Statement Receiver Name TEXT140
RECEIVER_COUNTRY Country/Region Key LAND1
COMPANY_CODE Company Code BUKRS
STATEMENT_ID Billing Statement ID CHAR35
CREATION_DATE_TIME Billing Statement Timestamp TZNTSTMPS
ACCOUNT_ID Bank Account Number FCLM_BAM_ACC_NUM
ACCOUNT_BAM_ID Bank Account Technical ID NUM10
ACCOUNT_NAME Account Name TEXT70
ACCOUNT_SERVICER_ID Bank Account Servicer ID CHAR35
ACCOUNT_SERVICER_NAME Bank Account Servicer Name TEXT140
ACCOUNT_SERVICER_BRANCH_ID Bank Account Servicer Branch ID CHAR35
ACCOUNT_SERVICER_BRANCH_NAME Bank Account Servicer Branch Name TEXT140
PARENT_ACCOUNT_ID Bank Account Number FCLM_BAM_ACC_NUM
PARENT_ACCOUNT_BAM_ID Bank Account Technical ID NUM10
PARENT_ACCOUNT_NAME Account Name TEXT70
PARENT_ACCOUNT_SERVICER_ID Bank Account Servicer ID CHAR35
PARENT_ACCOUNT_SERVICER_NAME Bank Account Servicer Name TEXT140
PARENT_ACCT_SERVICER_BRANCH_ID Bank Account Servicer Branch ID CHAR35
PARENT_ACCT_SVCR_BRANCH_NAME Bank Account Servicer Branch Name TEXT140
DEBIT_ACCOUNT_ID Bank Account Number FCLM_BAM_ACC_NUM
DEBIT_ACCOUNT_BAM_ID Bank Account Technical ID NUM10
SETTLEMENT_ADVICE Text field of length 120 TEXT120
TAX_REGION Tax Region Number CHAR40
TAX_AREA Bank Service Billing Statement Tax Area CHAR35
RATE_ID Billing Statement Rate ID CHAR35
RATE_VALUE Billing Statement Percentage FCLM_BRM_PERCENTAGE
DAYS_IN_PERIOD 2 Byte Signed Integer INT2
DAYS_IN_YEARS 2 Byte Signed Integer INT2
EXCHANGE_RATE Exchange Rate in BSB file FCLM_BRM_XCHGRATE
EXCHANGE_DESCRIPTION Description field of length 40 TEXT40
EXCHANGE_COMMENT Description field of length 70 TEXT70
EXCHANGE_QUOTATION_DATETIME Billing Statement Timestamp TZNTSTMPS
BALANCE_TYPE Billing Balance Type CHAR35
COMPENSATION_TYPE Billing Compensation Type CHAR35
SERVICE_ID Billing Service ID CHAR35
SERVICE_DESCRIPTION Description field of length 70 TEXT70
SUB_SERVICE_ID Billing Sub Service ID CHAR35
SERVICE_COMMON_CODE_ISSUER Bank Service Common Code Issuer CHAR6
SERVICE_COMMON_CODE Bank Service Common Code CHAR8
SERVICE_TYPE Billing Service Type CHAR12
SERVICE_VOLUME Bank Service Volume FCLM_BRM_VOLUME
SERVICE_PRICING_RULE Billing Service Price Rule CHAR20
TAX_DESIGNATION_REGION Tax Region Number CHAR40
TAX_REASON_CODE Tax Reason Code TEXT10
TAX_REASON_EXPLANATION Text field of length 120 TEXT120
TAX_REGION_NUMBER Tax Region Number CHAR40
TAX_REGION_NAME Tax Region Name TEXT40
TAX_REGION_CUSTOMER_TAX_ID Customer Tax Identification CHAR40
TAX_REGION_SENDING_FI_VAT_NB Bank Fee Statement VAT Registration Number CHAR35
TAX_REGION_SENDING_FI_TAX_NB Bank Fee Statement Tax Registration Number CHAR35
TAX_REGION_INVOICE_NUMBER Billing Statement Invoice Number CHAR40
BALANCE_ADJUSTMENT_DESCRIPTION Text field of length 120 TEXT120
BALANCE_ADJUSTMENT_DAYS 2 Byte Signed Integer INT2
SERVICE_ADJUSTMENT_DESCRIPTION Text field of length 120 TEXT120
SVC_ADJUSTMENT_SERVICE_ID Billing Service ID CHAR35
SVC_ADJUSTMENT_SUB_SERVICE_ID Billing Sub Service ID CHAR35
SVC_ADJSTMNT_VOLUME_CHANGE Bank Service Volume FCLM_BRM_VOLUME
SVC_ADJSTMNT_ORIGINAL_VOLUME Bank Service Volume FCLM_BRM_VOLUME
SVC_ADJSTMNT_NEW_VOLUME Bank Service Volume FCLM_BRM_VOLUME
CONDAREA Condition Area BKK_CONDAR
COND Condition ID BKK_CON