Table Abbreviation Description Module Activity code
BANK BAN Bank accounts Common Data  

Key Description Duplicates Activity code
BAN0 BAN No  
BAN1 CPY+FLDFIFCP+FLDSDA Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ABANUM ABA number   A 9       KUS
ACCCOD Accounting code   CAC     [CAC]CAC0=13;ACCCOD;[V]GSUPCLE Block  
ACS Access code   ACS     [ACS]ACS0=[BAN]ACS Block  
ADDLIG Address 3 A 35        
AUUID Single identifier   AUUID          
BACS BACS reference   A 30       KUK
BAN Code   BAN     [BAN]BAN0=[BAN]BAN Delete  
BANACC Account   GAC     [GAC]GAC0=COA;BANACC Block  
BANBPR BP code   BPR     [BPR]BPR0=[BAN]BANBPR Block  
BANCSH Bank or cash   M 15 653      
BANFIL Bank file   A 10       KPO
BANTRA Bank transit   A 9       CHQMG
BANTRM Bank terms   A 10        
BICCOD BIC code   A 11        
BIDEXS Bank account no.   BID          
BIDNUM Bank acct. number   BID          
BNKPROBALCTL Balance control   M 4 1      
BSIREFBAN Bank statement ID   A 50       BSI
BVRCUSTID Customer ID ISR   A 12       KSW
BVRNUM ISR customer no.   A 11       KSW
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CFOEXD Cash excluded   M 4 1     CFOM
CHGDAT Euro changeover date   D          
CHGTYP Rate type   M 15 202      
CHKACC Checking account   A 17       CHQMG
CHKCOD Reconciliation   A 5        
CHKFMT Format   M 15 2760     CHQMG
CHQTYPFLG O/L check remit.   M 4 1      
COA Chart code   COA     [COA]COA0=[BAN]COA Block  
CPY Company   CPY     [CPY]CPY0=[BAN]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CRN Site tax ID no.   CRT          
CRY Country   CRY     [TCY]TCY0=[BAN]CRY Block  
CRYNAM Country name   A 30        
CTY City   CTY          
CUR Currency   CUR     [TCU]TCU0=[BAN]CUR Block  
CUREXS Expense currency   CUR     [TCU]TCU0=[BAN]CUREXS Block  
DEPRAT Early discount rate   RAT          
DES Description   DES          
DESSHO Short description   SHO          
DIE Dimension type code   DIE     [DIE]DIE0=[BAN]DIE Block ANA
EXPNUM Export number   L 8        
FAX Fax   TEL          
FCY Site   FCY     [FCY]FCY0=[BAN]FCY Block  
FILEXT File extension   A 3        
FLDFIFCP FIFO conversion process   M 4 1     FIFRC
FLDSDA Start date   D         FIFRC
FRMDUDFLG Deposit by due date   M 4 1      
GTE Entry type 10 GTE     [GTE]GTE0=GTE(indice);[V]GSUPCLE Block  
HMRC HMRC refunds 5 M 4 1     KUK
IBACOD IBAN code   A 34        
INPAYTRA Incoming payment transaction   A 10       REGBC
JOU Journal 10 JOU     [JOU]JOU0=JOU(indice);[V]GSUPCLE Block  
JOUTYP Journal type 10 M 15 660      
MCRPRT MICR printing   M 4 1     CHQMG
NBRJOU Number of journals   C 2        
NXTSEQ Next check no.   A 15       CHQMG
OLDCUR Old currency   A 3        
OUTPAYTRA Outgoing payment transaction   A 10       REGBC
PAB1 Paying bank 1   A 30        
PAB2 Paying bank 2   A 30        
PABDUDFLG Payment order by due date   M 4 1      
PAYTPY Provisional payment   MD1          
POSCOD Postal code   POS          
POSPAYFIL Bank file   A 10       CHQMG
QRCIBACOD QR-IBAN   A 34       KSW
RECCPT Addi recording   M 4 1      
ROLLNUM B/Soc roll no   A 30       KUK
SAT State   SAT          
SCTPROLOT Processing by batch   M 4 1      
SENNUM Credit transfer issuer no.   A 50        
SENNUM2 Direct debit issuer no.   A 20        
SGLIDACH ACH individual ID   A 15       KUS
SGLIDMTS MTS individual ID   A 15       KUS
SRTCOD Sort code 5 A 8       KUK
SUN Service reference number   A 6       KUK
TEL Telephone   TEL          
TREACC Account 10 GAC     [GAC]GAC0=COA;TREACC(indice) Block  
TRECOD Treasury interface   A 12        
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
WEB Internet address   A 50