FCLM_BRM_BSB - Total of Bank Service Billing Statement

Total of Bank Service Billing Statement information is stored in SAP table FCLM_BRM_BSB.
It is part of development package FCLM_BRM in software component FIN-FSCM-CLM-BAM. This development package consists of objects that can be grouped under "Bank Relationship Management".

Fields for table FCLM_BRM_BSB

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
BSB_UUID	Bank Services Billing Statement UUID	X	FCLM_BRM_UUID	CHAR	72
REPORT_ID	Bank Services Billing Statement Report ID		FCLM_BRM_RPTID	CHAR	80
PAGE_NUMBER	Bank Fee Billing Statement Page Number		FCLM_BRM_PAGE_NUMBER	INT4	4
LAST_PAGE_INDICATOR	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
STATUS	Bank Fee Import Status		FCLM_BRM_IMPORT_STATUS	CHAR	4
GROUP_ID	Bank Services Billing Statement Group ID		FCLM_BRM_GRPID	CHAR	70
SENDER_ID	Statement Sender ID		FCLM_BRM_SENDER_ID	CHAR	70
SENDER_OTHER_ID	Statement Sender ID		FCLM_BRM_SENDER_ID	CHAR	70
SENDER_NAME	Statement Sender Name		FCLM_BRM_SENDER_NAME	CHAR	280
SENDER_COUNTRY	Country/Region Key		LAND1	CHAR	6
BANK_COUNTRY	Country/Region Key of Bank		BANKS	CHAR	6
BANK_KEY	Bank Keys		BANKK	CHAR	30
RECEIVER_ID	Statement Receiver ID		FCLM_BRM_RECEIVER_ID	CHAR	70
RECEIVER_NAME	Bank Service Billing Statement Receiver Name		FCLM_BRM_RECEIVER_NAME	CHAR	280
RECEIVER_COUNTRY	Country/Region Key		LAND1	CHAR	6
COMPANY_CODE	Company Code		BUKRS	CHAR	8
STATEMENT_ID	Billing Statement ID		FCLM_BRM_STMTID	CHAR	70
FROM_DATE	From Date		FCLM_BRM_FROM_DATE	DATS	16
TO_DATE	To Date		FCLM_BRM_TO_DATE	DATS	16
CREATION_DATE_TIME	Billing Statement Timestamp		FCLM_BRM_TIMESTAMP	DEC	8
CREATION_DATE	Bank Account Created On		FCLM_BAM_CREATED_ON	DATS	16
CREATION_TIME	Created At		FCLM_BAM_CREATED_AT	TIMS	12
STATEMENT_STATUS	Billing Statement Status		FCLM_BRM_STMT_STATUS	CHAR	12
ACCOUNT_LEVEL	Billing Statement Account Level		FCLM_BRM_ACCT_LVL	CHAR	12
ACCOUNT_ID_TYPE	Account ID Type		FCLM_BRM_ACCT_ID_TYPE	CHAR	2
ACCOUNT_ID	Bank Account Number		FCLM_BAM_ACC_NUM	CHAR	80
ACCOUNT_BAM_ID	Bank Account Technical ID		FCLM_BAM_ACC_ID	NUMC	20
ACCOUNT_TYPE	Account Type		FCLM_BRM_ACCT_TYPE	CHAR	12
ACCOUNT_CURRENCY	Currency Key		WAERS	CUKY	10
ACCOUNT_NAME	Account Name		FCLM_BRM_ACCT_NAME	CHAR	140
ACCOUNT_SERVICER_ID	Bank Account Servicer ID		FCLM_BRM_ACCOUNT_SERVICER_ID	CHAR	70
ACCOUNT_SERVICER_NAME	Bank Account Servicer Name		FCLM_BRM_ACCOUNT_SERVICER_NAME	CHAR	280
ACCOUNT_SERVICER_BRANCH_ID	Bank Account Servicer Branch ID		FCLM_BRM_ACCT_BRANCH_ID	CHAR	70
ACCOUNT_SERVICER_BRANCH_NAME	Bank Account Servicer Branch Name		FCLM_BRM_ACCT_BRANCH_NAME	CHAR	280
PARENT_ACCOUNT_LEVEL	Billing Statement Account Level		FCLM_BRM_ACCT_LVL	CHAR	12
PARENT_ACCOUNT_ID_TYPE	Account ID Type		FCLM_BRM_ACCT_ID_TYPE	CHAR	2
PARENT_ACCOUNT_ID	Bank Account Number		FCLM_BAM_ACC_NUM	CHAR	80
PARENT_ACCOUNT_BAM_ID	Bank Account Technical ID		FCLM_BAM_ACC_ID	NUMC	20
PARENT_ACCOUNT_TYPE	Account Type		FCLM_BRM_ACCT_TYPE	CHAR	12
PARENT_ACCOUNT_CURRENCY	Currency Key		WAERS	CUKY	10
PARENT_ACCOUNT_NAME	Account Name		FCLM_BRM_ACCT_NAME	CHAR	140
PARENT_ACCOUNT_SERVICER_ID	Bank Account Servicer ID		FCLM_BRM_ACCOUNT_SERVICER_ID	CHAR	70
PARENT_ACCOUNT_SERVICER_NAME	Bank Account Servicer Name		FCLM_BRM_ACCOUNT_SERVICER_NAME	CHAR	280
PARENT_ACCT_SERVICER_BRANCH_ID	Bank Account Servicer Branch ID		FCLM_BRM_ACCT_BRANCH_ID	CHAR	70
PARENT_ACCT_SVCR_BRANCH_NAME	Bank Account Servicer Branch Name		FCLM_BRM_ACCT_BRANCH_NAME	CHAR	280
COMPENSATION_METHOD	Compensation Method		FCLM_BRM_COMPSTN_MTD	CHAR	12
DEBIT_ACCOUNT_ID_TYPE	Account ID Type		FCLM_BRM_ACCT_ID_TYPE	CHAR	2
DEBIT_ACCOUNT_ID	Bank Account Number		FCLM_BAM_ACC_NUM	CHAR	80
DEBIT_ACCOUNT_BAM_ID	Bank Account Technical ID		FCLM_BAM_ACC_ID	NUMC	20
DELAYED_DEBIT_DATE	Bank Fee Statement Delayed Debit Date		FCLM_BRM_DELAYED_DEBIT_DATE	DATS	16
SETTLEMENT_ADVICE	Text field of length 120		FCLM_BRM_TEXT120	CHAR	240
ACCOUNT_BALANCE_CURRENCY	Currency Key		WAERS	CUKY	10
SETTLEMENT_CURRENCY	Currency Key		WAERS	CUKY	10
HOST_CURRENCY	Currency Key		WAERS	CUKY	10
TAX_CALCULATION_METHOD	Billing Tax Calculation Method		FCLM_BRM_TAX_CLCTN_MTD	CHAR	12
TAX_REGION	Tax Region Number		FCLM_BRM_TAX_REGION_NUMBER	CHAR	80
TAX_AREA	Bank Service Billing Statement Tax Area		FCLM_BRM_TAX_AREA	CHAR	70
RATE_ID	Billing Statement Rate ID		FCLM_BRM_RATE_ID	CHAR	70
RATE_VALUE	Billing Statement Percentage		FCLM_BRM_PERCENTAGE	DEC	8
DAYS_IN_PERIOD	2 Byte Signed Integer		INT2	INT2	2
DAYS_IN_YEARS	2 Byte Signed Integer		INT2	INT2	2
EXCHANGE_SOURCE_CCY	Currency Key		WAERS	CUKY	10
EXCHANGE_TARGET_CCY	Currency Key		WAERS	CUKY	10
EXCHANGE_RATE	Exchange Rate in BSB file		FCLM_BRM_XCHGRATE	DEC	8
EXCHANGE_DESCRIPTION	Description field of length 40		FCLM_BRM_TEXT40	CHAR	80
EXCHANGE_UNIT_CURRENCY	Currency Key		WAERS	CUKY	10
EXCHANGE_COMMENT	Description field of length 70		FCLM_BRM_TEXT70	CHAR	140
EXCHANGE_QUOTATION_DATETIME	Billing Statement Timestamp		FCLM_BRM_TIMESTAMP	DEC	8
EXCHANGE_QUOTATION_DATE	Date		DATUM	DATS	16
EXCHANGE_QUOTATION_TIME	Field of type TIMS		TIMS	TIMS	12
BALANCE_TYPE	Billing Balance Type		FCLM_BRM_BAL_TYPE	CHAR	70
BALANCE_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
BALANCE_CURRENCY	Currency Key		WAERS	CUKY	10
BALANCE_CURRENCY_TYPE	Currency Type		FCLM_BRM_CCY_TYPE	CHAR	12
COMPENSATION_TYPE	Billing Compensation Type		FCLM_BRM_COMPSTN_TYPE	CHAR	70
COMPENSATION_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
COMPENSATION_CURRENCY	Currency Key		WAERS	CUKY	10
COMPENSATION_CURRENCY_TYPE	Currency Type		FCLM_BRM_CCY_TYPE	CHAR	12
SERVICE_ID	Billing Service ID		FCLM_BRM_SVC_ID	CHAR	70
SERVICE_DESCRIPTION	Description field of length 70		FCLM_BRM_TEXT70	CHAR	140
SUB_SERVICE_ISSUER	SubService Issuer ID		FCLM_BRM_SUB_SVC_ISSUER_ID	CHAR	70
SUB_SERVICE_ID	Billing Sub Service ID		FCLM_BRM_SUB_SVC_ID	CHAR	70
SERVICE_COMMON_CODE_ISSUER	Bank Service Common Code Issuer		FCLM_BRM_SVC_COMMON_CD_ISSUER	CHAR	12
SERVICE_COMMON_CODE	Bank Service Common Code		FCLM_BRM_SVC_COMMON_CODE	CHAR	16
SERVICE_TYPE	Billing Service Type		FCLM_BRM_SVC_TYPE	CHAR	24
SERVICE_VOLUME	Bank Service Volume		FCLM_BRM_VOLUME	DEC	8
SERVICE_UNIT_PRICE	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SERVICE_UNIT_PRICE_CURRENCY	Currency Key		WAERS	CUKY	10
BILLING_CHARGE_METHOD	Billing Charge Method		FCLM_BRM_CHARGE_METHOD	CHAR	12
SERVICE_PRICING_RULE	Billing Service Price Rule		FCLM_BRM_SVC_PRICE_RULE	CHAR	40
PAYMENT_METHOD	Billing Service Payment Method		FCLM_BRM_PAYMENT_METHOD	CHAR	12
ORIGINAL_CHARGE_PRICE	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
ORIGINAL_CHANGE_PRICE_CURRENCY	Currency Key		WAERS	CUKY	10
ORIGINAL_CHARGE_SETTLEMENT_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
ORIGINAL_CHARGE_SETTLEMENT_CCY	Currency Key		WAERS	CUKY	10
BALANCE_REQUIRED_ACCOUNT_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
BALANCE_REQUIRED_ACCOUNT_CCY	Currency Key		WAERS	CUKY	10
TAX_DESIGNATION_CODE	Service Tax Designation Code		FCLM_BRM_TAX_DSGNT_CODE	CHAR	12
TAX_DESIGNATION_REGION	Tax Region Number		FCLM_BRM_TAX_REGION_NUMBER	CHAR	80
TAX_REASON_CODE	Tax Reason Code		FCLM_BRM_TAX_REASON_CODE	CHAR	20
TAX_REASON_EXPLANATION	Text field of length 120		FCLM_BRM_TEXT120	CHAR	240
TAX_SERVICE_CHARGE_HOST_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_SERVICE_CHARGE_HOST_CCY	Currency Key		WAERS	CUKY	10
TAX_SERVICE_TAX_HOST_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_SERVICE_TAX_HOST_CURRENCY	Currency Key		WAERS	CUKY	10
TAX_SERVICE_TAX_PRICING_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_SERVICE_TAX_PRICING_CCY	Currency Key		WAERS	CUKY	10
TAX_TOTAL_CHARGE_HOST_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_TOTAL_CHARGE_HOST_CURRENCY	Currency Key		WAERS	CUKY	10
TAX_TOTAL_CHARGE_STTLM_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_TOTAL_CHARGE_STTLM_CCY	Currency Key		WAERS	CUKY	10
TAX_TOTAL_CHARGE_PRICG_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_TOTAL_CHARGE_PRICG_CCY	Currency Key		WAERS	CUKY	10
TAX_REGION_NUMBER	Tax Region Number		FCLM_BRM_TAX_REGION_NUMBER	CHAR	80
TAX_REGION_NAME	Tax Region Name		FCLM_BRM_TAX_REGION_NAME	CHAR	80
TAX_REGION_CUSTOMER_TAX_ID	Customer Tax Identification		FCLM_BRM_CUSTOMER_TAX_ID	CHAR	80
TAX_REGION_POINT_DATE	Date on which the tax calculation was performed		FCLM_BRM_POINT_DATE	DATS	16
TAX_REGION_SENDING_FI_VAT_NB	Bank Fee Statement VAT Registration Number		FCLM_BRM_VAT_REG_NUMBER	CHAR	70
TAX_REGION_SENDING_FI_TAX_NB	Bank Fee Statement Tax Registration Number		FCLM_BRM_TAX_REG_NUMBER	CHAR	70
TAX_REGION_INVOICE_NUMBER	Billing Statement Invoice Number		FCLM_BRM_INVOICE_NUMBER	CHAR	80
TAX_CALCULATION_HOST_CURRENCY	Currency Key		WAERS	CUKY	10
TOTAL_TAXABLE_SVC_CHRG_HST_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TOTAL_TAXABLE_SVC_CHRG_HST_CCY	Currency Key		WAERS	CUKY	10
TAX_ID_TOTAL_TAX_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_ID_TOTAL_TAX_CURRENCY	Currency Key		WAERS	CUKY	10
TAX_REGION_SETTLEMENT_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_REGION_SETTLEMENT_CURRENCY	Currency Key		WAERS	CUKY	10
TAX_DUE_TO_REGION_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
TAX_DUE_TO_REGION_CURRENCY	Currency Key		WAERS	CUKY	10
BALANCE_ADJUSTMENT_TYPE	Balance Adjustment Type		FCLM_BRM_BAL_ADJUSTMENT_TYPE	CHAR	12
BALANCE_ADJUSTMENT_DESCRIPTION	Text field of length 120		FCLM_BRM_TEXT120	CHAR	240
BALANCE_ADJUSTMENT_BALANCE_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
BALANCE_ADJUSTMENT_BALANCE_CCY	Currency Key		WAERS	CUKY	10
BALANCE_ADJUSTMENT_AVERAGE_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
BALANCE_ADJUSTMENT_AVERAGE_CCY	Currency Key		WAERS	CUKY	10
BALANCE_ADJUSTMENT_ERROR_DATE	Error Date		FCLM_BRM_ERROR_DATE	DATS	16
BALANCE_ADJUSTMENT_POSTING_DT	Posting Date		FCLM_BRM_POSTING_DATE	DATS	16
BALANCE_ADJUSTMENT_DAYS	2 Byte Signed Integer		INT2	INT2	2
BALANCE_EARNINGS_ADJSTMNT_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
BALANCE_EARNINGS_ADJSTMNT_CCY	Currency Key		WAERS	CUKY	10
SERVICE_ADJUSTMENT_TYPE	Service Adjustment Type		FCLM_BRM_SVC_ADJUSTMENT_TYPE	CHAR	12
SERVICE_ADJUSTMENT_DESCRIPTION	Text field of length 120		FCLM_BRM_TEXT120	CHAR	240
SERVICE_ADJUSTMENT_AMOUNT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SERVICE_ADJUSTMENT_CURRENCY	Currency Key		WAERS	CUKY	10
SVC_ADJSTMNT_BALANCE_REQRD_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SVC_ADJSTMNT_BALANCE_REQRD_CCY	Currency Key		WAERS	CUKY	10
SERVICE_ADJUSTMENT_ERROR_DATE	Error Date		FCLM_BRM_ERROR_DATE	DATS	16
SVC_ADJUSTMENT_SERVICE_ID	Billing Service ID		FCLM_BRM_SVC_ID	CHAR	70
SVC_ADJUSTMENT_SUB_SVC_ISSUER	SubService Issuer ID		FCLM_BRM_SUB_SVC_ISSUER_ID	CHAR	70
SVC_ADJUSTMENT_SUB_SERVICE_ID	Billing Sub Service ID		FCLM_BRM_SUB_SVC_ID	CHAR	70
SVC_ADJSTMNT_PRICE_CHANGE_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SVC_ADJSTMNT_PRICE_CHANGE_CCY	Currency Key		WAERS	CUKY	10
SVC_ADJSTMNT_ORGNL_PRICE_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SVC_ADJSTMNT_ORGNL_PRICE_CCY	Currency Key		WAERS	CUKY	10
SVC_ADJSTMNT_NEW_PRICE_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SVC_ADJSTMNT_NEW_PRICE_CCY	Currency Key		WAERS	CUKY	10
SVC_ADJSTMNT_VOLUME_CHANGE	Bank Service Volume		FCLM_BRM_VOLUME	DEC	8
SVC_ADJSTMNT_ORIGINAL_VOLUME	Bank Service Volume		FCLM_BRM_VOLUME	DEC	8
SVC_ADJSTMNT_NEW_VOLUME	Bank Service Volume		FCLM_BRM_VOLUME	DEC	8
SVC_ADJSTMNT_ORGNL_CHRG_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SVC_ADJSTMNT_ORGNL_CHRG_CCY	Currency Key		WAERS	CUKY	10
SVC_ADJSTMNT_NEW_CHRG_AMT	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
SVC_ADJSTMNT_NEW_CHRG_CCY	Currency Key		WAERS	CUKY	10
VALIDATION_STATUS	Service pricing status		FCLM_BRM_SERVICE_PRICING_STS	CHAR	2
CALCD_PRICE	Billing Amount		FCLM_BRM_AMOUNT	CURR	13
CONDAREA	Condition Area		BKK_CONDAR	CHAR	8
COND	Condition ID		BKK_CON	CHAR	20
VALIDFROM	From Date		FCLM_BRM_FROM_DATE	DATS	16