Table Abbreviation Description Module Activity code
BSIIMPD BSIIMPD Bank statement import detail A/P-A/R accounting BSI

Key Description Duplicates Activity code
BSIIMPD0 STMCOD+LIN No  
BSIIMPD1 BAN+STMCOD Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC Account   GAC     [GAC]GAC0=[BSIIMPD]ACC BSRA  
AMTCUR Amount   MD1          
AUUID Single identifier   AUUID          
BAN Bank   BAN     [BAN]BAN0=[BSIIMPD]BAN Block  
BPAINV Billing address   ADR          
BPRINV Bill-to BP   BPR     [BPR]BPR0=[BSIIMPD]BPRINV Block  
BPRNAM Company name 2 NAM          
BPRPAY BP   BPR     [BPR]BPR0=[BSIIMPD]BPRPAY Block  
BPRREF BP reference 5 A 80        
BPRTYP BP type   M 15 644      
CPY Company   CPY     [CPY]CPY0=[BSIIMPD]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[BSIIMPD]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[BSIIMPD]CUR Block  
DENCOD Destination   CDA     [CDA]CDA0=[BSIIMPD]DENCOD BSRA  
DEP Discount   MD1          
DEPAMT Discount amount   MD1          
DES Reference   DES          
DSP Distribution   DSP     [DSP]DSP0=DSP;1 Block  
DUDDAT Due date   D          
DUDLIG Due date number   C 2        
DUDNUM Internal number   UNQ          
FCYLIN Site   FCY     [FCY]FCY0=[BSIIMPD]FCYLIN Block  
FILFMT File format   BSIBFF     [BSIFFM]BSIFFM0=FILFMT Block  
FLGAMT Amount   M 4 1      
FLGBIDNUM BP bank account number   M 4 1      
FLGBPR BP   M 4 1      
FLGBPRNAM BP name   M 4 1      
FLGBPRTOT BP total   M 4 1      
FLGBPRVCR Source document   M 4 1      
FLGBVRREFNUM Reference number   M 4 1      
FLGCRE Creation flag   M 15 3690      
FLGINVNUM Invoice number   M 4 1      
FLGPAYREF Payment ref   M 4 1      
FLGREFLIS Use search term list   M 4 1      
FLGSOHNUM Order number   M 4 1      
FREREF Free reference 10 A 80        
LEG Legislation   ADI     [ADI]CODE=909;LEG Block  
LET Matching flag   A 3        
LIN Line number   C 3        
OPEDAT Operation date   D          
OVERPAY Overpayment   MD1          
PAYREF Payment ref   A 80        
REF Reference   REF          
REM Comment   A 250        
SAC Control   SAC          
SNS Sign   A 2        
STMCOD Statement code   VCR          
TRS Transaction   A 10        
TYPMTC Matching type   A 3        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[BSIIMPD]UPDUSR Other  
VALDAT Value date   D          
VAT Tax   VAT     [TVT]TVT0=[BSIIMPD]VAT BSRA