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

Display all Hide all

Table Abbreviation Description Module Activity code
TMPCNSBAN TCB Bank inquiry A/P-A/R accounting  

Key Description Duplicates Activity code
TCB0 TCBNUM No  
TCB1 USRCRE+ADXNUM Yes  
TCB2 ACCNUM Yes  
TCB3 NUMPAY+USRCRE+ADXNUM Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCDAT Accounting date   D          
ACCNUM Unique number   UNQ          
ADXNUM No.   L 8        
AMTBAN Bank amount   MD1          
AMTCUR Amount in currency   MD1          
AUUID Single identifier   AUUID          
BANDAT Bank date   D         KIT
BID Bank account number   BID          
BIDCRY Bank acct. country   CRY     [TCY]TCY0=[TCB]BIDCRY Block  
BILDAT Date created   D          
BOLLATO Bollato sequence number   VCR         KIT
BPR BP   BPR     [BPR]BPR0=[TCB]BPR Block  
BPRDATVCR Document date   D          
BPRREF Drawee reference   A 10        
BPRSAC Control   SAC          
BPRVCR Source document   A 20        
CHQNUM Check number   A 15        
COLOR Color   C 1        
CRDNUM Bank card number   A 16        
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[TCB]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[TCB]CUR Block  
DES Description   DES          
DUDDAT Due date   D          
ENTDAT Entry date   D          
FCY Site   FCY     [FCY]FCY0=[TCB]FCY Block  
JOU Journal   JOU     [JOU]JOU0=JOU;[V]GSUPCLE Block  
NUM Order no.   VCR          
NUMPAY Payment no.   VCR          
ORIDAT Source date   D          
PAM Payment method   TAM     [TAM]TAM0=PAM;[V]GSUPCLE Block  
PAYLOT Batch code   VCR          
PAYTYP Transaction   TPY     [TPY]TPY0=PAYTYP;[V]GSUPCLE Block  
RATCUR Currency rate   RCU          
RATDAT Rate date   D          
RATRPT Reporting rate   RCU          
REF Reference   REF          
SNS Sign   M 15 632      
STA Status   M 30 689      
TCBNUM Internal number   L 8        
TYP Entry type   GTE     [GTE]GTE0=TYP;[V]GSUPCLE Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[TCB]UPDUSR Other  
USRCRE User   AUS     [AUS]CODUSR=[TCB]USRCRE Block  
VALDAT Value date   D