WA_CACU_DATA
返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ADDTYPECHAR1     
2BEGINDATECHAR10     
3CACU_VALUENUMBER318  0 
4CHAR_VALUEVARCHAR2256     
5CREATORVARCHAR220     
6CURMONTHWAGENUMBER318  0 
7CURRENCYRATENUMBER318    
8DEDUCTIONRATENUMBER318    
9DERATEPTGNUMBER318  0 
10DRNUMBER100  0 
11ENDDATECHAR10     
12EXPENSE_DEDUCTIONNUMBER318    
13FSTMONWAGEDAYSNUMBER380    
14FSTMONWAGEDAYS4TANUMBER380    
15ISCACUCHAR1    'N'  
16ISCACU4PSNCHGCHAR1   'N' 
17ISDERATECHAR1     
18ISNDEBUCTCHAR1     
19LSTMONWAGEDAYSNUMBER380    
20LSTMONWAGEDAYS4TANUMBER380    
21NQUICKDEBUCTNUMBER318    
22PERIODTIMESNUMBER318  12 
23PK_CACU_DATACHAR20     
24PK_PSNDOCVARCHAR220      
25PK_TA_ORGCHAR20     
26PK_WA_CLASSVARCHAR220      
27PK_WA_DATAVARCHAR220      
28PREADJUSTDATECHAR10     
29PSNAGENUMBER380   0  
30REDATANUMBER318    
31REDATALASTTAXNUMBER318    
32REDATALASTTAXBASENUMBER318    
33REDATAMODENUMBER380    
34RETAXEDNUMBER318    
35TAPERIODCHAR2     
36TAX_BASENUMBER318    
37TAXABLE_INCOMENUMBER318    
38TAXEDNUMBER318    
39TAXEDBASENUMBER318    
40TAXRATENUMBER318    
41TAXTABLEIDVARCHAR220     
42TAXTYPECHAR1     
43TAYEARCHAR4     
44TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
45UNITAGENUMBER380   0  
46WAGEDAYSNUMBER380  0 
47WORKAGENUMBER380   0  
48WORKORGCHAR20