WA_DATAPOOL_B
薪资分摊子表返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1AMOORGVIDCHAR20    分摊组织版本
2DEPTIDCHAR20    部门主键
3DEPTVIDCHAR20    部门主键版本
4DRNUMBER100  0 
5FACTOR1CHAR20    自定义影响因素1
6FACTOR10CHAR20    自定义影响因素10
7FACTOR11CHAR20    自定义影响因素11
8FACTOR12CHAR20    自定义影响因素12
9FACTOR13CHAR20    自定义影响因素13
10FACTOR14CHAR20    自定义影响因素14
11FACTOR15CHAR20    自定义影响因素15
12FACTOR16CHAR20    自定义影响因素16
13FACTOR17CHAR20    自定义影响因素17
14FACTOR18CHAR20    自定义影响因素18
15FACTOR19CHAR20    自定义影响因素19
16FACTOR2CHAR20    自定义影响因素2
17FACTOR20CHAR20    自定义影响因素20
18FACTOR3CHAR20    自定义影响因素3
19FACTOR4CHAR20    自定义影响因素4
20FACTOR5CHAR20    自定义影响因素5
21FACTOR6CHAR20    自定义影响因素6
22FACTOR7CHAR20    自定义影响因素7
23FACTOR8CHAR20    自定义影响因素8
24FACTOR9CHAR20    自定义影响因素9
25FMNYNUMBER318  0金额
26FRATIONUMBER96   分摊比例
27PK_AMO_ORGCHAR20    分摊组织
28PK_PSNBASDOCCHAR20    人员基本主键
29PK_WA_DATAPOOLCHAR20    事务池PK
30PK_WA_DATAPOOL_BCHAR20    事务池子表主键
31PK_WA_ITEMCHAR20    薪资项目主键
32PSNCLIDCHAR20    人员类别主键
33PSNIDCHAR20    人员主键
34TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')