FIAPPTD_BALANCE - Table to store the Balances for Vendor/Customer/Bank Account

Table to store the Balances for Vendor/Customer/Bank Account information is stored in SAP table FIAPPTD_BALANCE.
It is part of development package ID-FI-PT in software component FI-LOC-FI-PT. This development package consists of objects that can be grouped under "Add-On Development - FI - Portugal".

Fields for table FIAPPTD_BALANCE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
REPORTING_YEAR	Fiscal Year	X	GJAHR	NUMC	8
PERIOD	Fiscal period	X	MONAT	NUMC	4
RUN_ID	Run ID	X	FIAPPT_RUN_ID	CHAR	40	FIAPPTD_RUNID
ACCOUNT	Account Number	X	FIAPPT_ACCOUNT_NO	CHAR	20
KOART	Account type	X	KOART	CHAR	2
WAERS	Currency Key	X	WAERS	CUKY	10
WRBTR	Amount		FIAPPT_AMOUNT	CURR	13
ORIGIN_RUN_ID	Run ID		FIAPPT_RUN_ID	CHAR	40
REFERENCE_DATE	Document Date in Document		BLDAT	DATS	16
REGISTER_ID	ID of the Register		FIAPPT_REG_ID	CHAR	2
SCB_IND	SCB Indicator		FIAPPT_SCB_IND	CHAR	10
NPC2	Entity ID		FIAPPT_NPC2	NUMC	18
VALUE_TYPE	CBR Value Type		FIAPPT_VALUE_TYPE	CHAR	2
BANK_ACC_TYPE	Bank Account Type		FIAPPT_BANK_ACC_TYPE	CHAR	2
BANK_ID	Bank ID		FIAPPT_BANKID	CHAR	8
PAIS_CONTA	Foreign Account Country/Region		FIAPPT_PAIS_CONTA	CHAR	6
PAIS_CONTRAPARTE	Customer/Vendor Country/Region		FIAPPT_PAIS_CONTRAPARTE	CHAR	6
PAIS_ATIVO	Financial Active Entity		FIAPPT_PAIS_ATIVO	CHAR	6
DUE_DATE	Due Date		FIAPPT_DUEDATE	DATS	16
STCEG	Counterpart ID or VAT Registration Number		FIAPPT_VAT_REG_NO	CHAR	40
OBSERVATIONS	Observations		FIAPPT_TEXT	CHAR	240
ISOCD	ISO currency code		ISOCD	CHAR	6