Dictionary >  Module A/P-A/R accounting >  Table File FMT940 (lines)  

Display all Hide all

Table Abbreviation Description Module Activity code
RELMT940D RLD File FMT940 (lines) A/P-A/R accounting  

Key Description Duplicates Activity code
RLD0 FILNUM+TRFNUM+SEQNUM+LIN No  
RLD1 BAN+FILNUM Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AMTCUR Amount   MD1          
AUUID Single identifier   AUUID          
BAN Bank   BAN     [BAN]BAN0=[RLD]BAN Block  
BIDNUM Bank account number   BID          
BPRINV Bill-to BP   BPR     [BPR]BPR0=[RLD]BPRINV Block  
BPRPAY BP   BPR     [BPR]BPR0=[RLD]BPRPAY Block  
BPRREF BP reference 5 A 30        
CPY Company   CPY     [CPY]CPY0=[RLD]CPY Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[RLD]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[RLD]CUR Block  
DES Reference   DES          
DUDDAT Due date   D          
DUDLIG Due date number   C 2        
DUDNUM Internal number   UNQ          
FCYLIN Site   FCY     [FCY]FCY0=[RLD]FCYLIN Block  
FILNUM File number   VCR          
FLGCRE Creation flag   C 1        
FREREF Free reference 10 A 30        
LET Code   A 1        
LIN Line number   C 3        
NUM Invoice no.   VCR          
NUMREG Payment no. generated   VCR          
PAYTYP Payment type   TPY     [TPY]TPY0=PAYTYP;[V]GSUPCLE Block  
SEQNUM Sequence number   A 12        
SNS Sign   A 2        
TRFNUM Transaction number   A 20        
TYP Entry type   GTE     [GTE]GTE0=TYP;[V]GSUPCLE Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[RLD]UPDUSR Other  
VALDAT Value date   D