Table Abbreviation Description Module Activity code
BPS1099PAY B9P Supplier 1099 payments Financials S1099

Key Description Duplicates Activity code
B9P0 YR1099+CPY+BPSNUM+PAYNUM+PAYLIN No  
B9P1 YR1099+CPY+BPSNUM+FRM1099+BOX1099 Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AMT1099 1099 amount   MD1          
AUUID Single identifier   AUUID          
BOX1099 1099 box   A 4        
BPSNUM Supplier   BPS     [BPS]BPS0=[B9P]BPSNUM Delete  
CPY Company   CPY     [CPY]CPY0=[B9P]CPY Delete  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[B9P]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[B9P]CUR Delete  
FRM1099 1099 form   M 15 3601      
INVNUM Invoice number   VCR          
PAYLIN Line   C 4        
PAYNUM Payment number   VCR          
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[B9P]UPDUSR Other  
YR1099 Year   C 4