Table Abbreviation Description Module Activity code
BP1099PRN B9R 1099 print table Financials S1099

Key Description Duplicates Activity code
B9R0 YR1099+CPY+BPSNUM+NUMLIG No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AMT1099 1099 amount 20 MD1          
AUUID Single identifier   AUUID          
BOXALPHA 1099 box alpha 20 A 1        
BPSNUM Supplier   BPS     [BPS]BPS0=[B9R]BPSNUM Other  
CLED1 Date 1   D          
CLED2 Date 2   D          
CPY Company   CPY     [CPY]CPY0=[B9R]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[B9R]CREUSR Other  
FILCHK FATCA filing   A 10        
FRM1099 1099 form   M 15 3601      
NUMLIG Line no.   L 8        
NUMREQ Query no.   L 8        
POSS Possession   A 20        
RESALE Resale   A 10        
RPTCOD Report code   ARP     [ARP]ARP0=[B9R]RPTCOD Other  
SEQREQ Sequence   L 8        
STATEID State ID   A 15        
TEL Telephone   TEL          
TINCHK 2nd TIN not.   A 10        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[B9R]UPDUSR Other  
USR Operator   AUS     [AUS]CODUSR=[B9R]USR Other  
YR1099 Year   C 4