Table > Module Financials > Table General balance

Table BALANCE

Table	Abbreviation	Description	Module	Activity code
BALANCE	BAL	General balance	Financials

Key	Description	Duplicates	Activity code
BAL0	LEDTYP+CPY+FCY+FIY+ACC+BPR+CUR	No
BAL1	ACCNUM	No
BAL2	LEDTYP+CUR+CPY+FCY+ACC+BPR+FIY	No

Column	Normal title	Dim.	Type	Length	Menu	Link expression	Cancellation	Act
ACC	Account		GAC			[GAC]GAC0=COA;ACC	Block
ACCNUM	Unique number		UNQ
AUUID	Single identifier		AUUID
BPR	BP		BPR			[BPR]BPR0=[BAL]BPR	Block
CDT	Credit		MD1					PER
CDTLED	Ledger credit		MD1					PER
COA	Chart code		COA			[COA]COA0=[BAL]COA	Delete
CPY	Company		CPY			[CPY]CPY0=[BAL]CPY	Block
CREDATTIM	Date time		ADATIM
CREUSR	User		AUS			[AUS]CODUSR=[BAL]CREUSR	Other
CUR	Currency		CUR			[TCU]TCU0=[BAL]CUR	Block
CURLED	Ledger currency		CUR			[TCU]TCU0=[BAL]CURLED	Block
DEB	Debit		MD1					PER
DEBLED	Ledger debit		MD1					PER
FCY	Site		FCY			[FCY]FCY0=[BAL]FCY	Block
FIY	Fiscal year		C	2
LED	Ledger		LED			[LED]LED0=[BAL]LED	Delete
LEDTYP	Ledger type		M		2644
UPDDATTIM	Date time		ADATIM
UPDUSR	User		AUS			[AUS]CODUSR=[BAL]UPDUSR	Other