Dictionary >  Module A/P-A/R accounting >  Table Bank accounts  

Display all Hide all

Table Abbreviation Description Module Activity code
BANK BAN Bank accounts A/P-A/R accounting  

Key Description Duplicates Activity code
BAN0 BAN No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
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          
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        
FRMDUDFLG Deposit by due date   M 4 1      
GTE Entry type 10 GTE     [GTE]GTE0=GTE(indice);[V]GSUPCLE Block  
IBACOD IBAN code   A 34        
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        
PAB1 Paying bank 1   A 30        
PAB2 Paying bank 2   A 30        
PABDUDFLG Paying bank notice 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      
SAT State   SAT          
SCTPROLOT Processing by batch   M 4 1      
SENNUM Credit transfer issuer no.   A 10        
SENNUM2 Direct debit issuer no.   A 10        
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