1 |
ARREARS_12_WEEKS_OVERDUE |
拖欠指标 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Arrears Indicator - 拖欠指标 |
2 |
BIWEEKLY_WITHHOLDING_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
3 |
CASE_IDENTIFIER |
IWO案例标识符 |
VARCHAR2 |
15 |
0 |
Y |
|
|
|
|
IWO Case Identifier - IWO案例标识符 |
4 |
CATEGORY |
装饰文件类别 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Garnishment document category - 装饰文件类别 |
5 |
CCPA_LIMIT |
可以扣缴的最高收入百分比 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
The highest percentage of income that can be withheld - 可以扣缴的最高收入百分比 |
6 |
CHILD1_BIRTH_DATE |
孩子出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Child Birth Date - 孩子出生日期 |
7 |
CHILD1_FIRST_NAME |
孩子的名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child First Name - 孩子的名字 |
8 |
CHILD1_LAST_NAME |
孩子姓 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child Last Name - 孩子姓 |
9 |
CHILD2_BIRTH_DATE |
孩子出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Child Birth Date - 孩子出生日期 |
10 |
CHILD2_FIRST_NAME |
孩子的名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child First Name - 孩子的名字 |
11 |
CHILD2_LAST_NAME |
孩子姓 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child Last Name - 孩子姓 |
12 |
CHILD3_BIRTH_DATE |
孩子出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Child Birth Date - 孩子出生日期 |
13 |
CHILD3_FIRST_NAME |
孩子的名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child First Name - 孩子的名字 |
14 |
CHILD3_LAST_NAME |
孩子姓 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child Last Name - 孩子姓 |
15 |
CHILD4_BIRTH_DATE |
孩子出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Child Birth Date - 孩子出生日期 |
16 |
CHILD4_FIRST_NAME |
孩子的名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child First Name - 孩子的名字 |
17 |
CHILD4_LAST_NAME |
孩子姓 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child Last Name - 孩子姓 |
18 |
CHILD5_BIRTH_DATE |
孩子出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Child Birth Date - 孩子出生日期 |
19 |
CHILD5_FIRST_NAME |
孩子的名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child First Name - 孩子的名字 |
20 |
CHILD5_LAST_NAME |
孩子姓 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child Last Name - 孩子姓 |
21 |
CHILD6_BIRTH_DATE |
孩子出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Child Birth Date - 孩子出生日期 |
22 |
CHILD6_FIRST_NAME |
孩子的名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child First Name - 孩子的名字 |
23 |
CHILD6_LAST_NAME |
孩子姓 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Child Last Name - 孩子姓 |
24 |
CONTROL_NUMBER_INBOUND |
订单控制号 |
VARCHAR2 |
22 |
0 |
Y |
|
|
|
|
Control Number for Order - 订单控制号 |
25 |
CONTROL_NUMBER_OUTBOUND |
订单控制号 |
VARCHAR2 |
22 |
0 |
Y |
|
|
|
|
Control Number for Order - 订单控制号 |
26 |
CURRENT_CASH_MEDICAL_SUP_AMT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
27 |
CURRENT_CASH_MEDICAL_SUP_FREQ |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
28 |
CURRENT_CHILD_SUPPORT_AMT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
29 |
CURRENT_CHILD_SUPPORT_FREQ |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
30 |
CURRENT_SPOUSAL_SUPPORT_AMT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
31 |
CURRENT_SPOUSAL_SUPPORT_FREQ |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
32 |
DEDUCTION_AMOUNT |
装饰单扣减 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Garnishment order deduction - 装饰单扣减 |
33 |
MANDT |
顾客 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Client - 顾客 |
34 |
ORDER_IDENTIFIER |
IWO订单标识符 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
IWO Order Identifier - IWO订单标识符 |
35 |
SEQUENTIAL_NUMBER |
订单明细记录序号 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Sequence Number for Order Detail Record - 订单明细记录序号 |
36 |
UUID_PDF |
22 EIWO字符 |
VARCHAR2 |
22 |
0 |
Y |
|
|
|
|
22 char UUID for EIWO - 22 EIWO字符 |
37 |
UUID_XML_INBOUND |
22 EIWO字符 |
VARCHAR2 |
22 |
0 |
Y |
|
|
|
|
22 char UUID for EIWO - 22 EIWO字符 |
38 |
UUID_XML_OUTBOUND |
22 EIWO字符 |
VARCHAR2 |
22 |
0 |
Y |
|
|
|
|
22 char UUID for EIWO - 22 EIWO字符 |
39 |
DOCUMENT_ACTION_CODE |
IWO文件类型 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Type of IWO document - IWO文件类型 |
40 |
MANUAL_OVERRIDE |
手动 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Manual override - 手动 |
41 |
EVALUATED_STATUS |
系统评估的订单状态 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Order Status Evaluated by the System - 系统评估的订单状态 |
42 |
RECORD_REASON |
确认原因代码 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Acknowledgment Reason Code - 确认原因代码 |
43 |
ORDER_RECEIVED_DATE |
IWO接收日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
IWO Received Date - IWO接收日期 |
44 |
PAYROLL_AREA |
工资核算范围 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Payroll Area - 工资核算范围 |
45 |
PERNR |
人员编号 |
VARCHAR2 |
8 |
0 |
Y |
|
|
|
|
Personnel Number - 人员编号 |
46 |
GROUPING_VALUE |
人员分配的分组值 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Grouping Value for Personnel Assignments - 人员分配的分组值 |
47 |
EMPLOYEE_SSN |
社会保险号码 |
VARCHAR2 |
11 |
0 |
Y |
|
|
|
|
Social Security Number - 社会保险号码 |
48 |
REMITTANCE_IDENTIFIER |
IWO汇款标识符 |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
IWO Remittance Identifier - IWO汇款标识符 |
49 |
JURISDICTION |
配饰文件管辖权 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Garnishment document jurisdiction - 配饰文件管辖权 |
50 |
MULTI_IWO_STATE_CODE |
e-IWO多州代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
e-IWO Multi State Code - e-IWO多州代码 |
51 |
ORDER_TYPE |
装饰订单类型 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Garnishment order type - 装饰订单类型 |
52 |
VENDOR_NUMBER |
装饰供应商 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Garnishment vendor - 装饰供应商 |
53 |
REMITTANCE_RULE |
汇款规则 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Remittance Rule - 汇款规则 |
54 |
DEDUCTION_UNIT |
装饰单扣除单位 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Garnishment order deduction unit - 装饰单扣除单位 |
55 |
GARNISHMENT_RULE |
非免税金额计算规则 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Rule for calculating the non-exempt amount - 非免税金额计算规则 |
56 |
SERVICE_CHARGE |
服务收费规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Service charge rule - 服务收费规则 |
57 |
EMPLOYER_ID_ORDER |
e-IWO雇主识别号 |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
e-IWO Employer Identification Number - e-IWO雇主识别号 |
58 |
EMPLOYER_ID_CORRECT |
正确的雇主识别号 |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Correct Employer Identification Number - 正确的雇主识别号 |
59 |
DOCUMENT_IMAGE_TEXT |
文档图像文本 |
VARCHAR2 |
25 |
0 |
Y |
|
|
|
|
Document Image Text - 文档图像文本 |
60 |
DOCUMENT_TRACKING_NUMBER |
订单跟踪号 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Order Tracking Number - 订单跟踪号 |
61 |
EMPLOYEE_LAST_NAME |
员工姓氏 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Employee Last Name - 员工姓氏 |
62 |
EMPLOYEE_FIRST_NAME |
员工名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Employee First Name - 员工名字 |
63 |
EMPLOYEE_BIRTH_DATE |
员工出生日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Employee Birth Date - 员工出生日期 |
64 |
SEND_EMPLOYEE_COPY_INDICATOR |
授权发送副本 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Authorization to Send Copy - 授权发送副本 |
65 |
OBLIGEE_LAST_NAME |
债权人姓氏 |
VARCHAR2 |
57 |
0 |
Y |
|
|
|
|
Obligee Last Name - 债权人姓氏 |
66 |
OBLIGEE_FIRST_NAME |
债权人名字 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Obligee First Name - 债权人名字 |
67 |
PAYEE_NAME |
收款人名称 |
VARCHAR2 |
57 |
0 |
Y |
|
|
|
|
Payee Name - 收款人名称 |
68 |
PAYEE_REMITTANCE_FIPS_CODE |
汇款FIPS代码 |
VARCHAR2 |
7 |
0 |
Y |
|
|
|
|
Remittance FIPS Code - 汇款FIPS代码 |
69 |
PAYEE_ADDRESS_LINE_1 |
地址行 |
VARCHAR2 |
25 |
0 |
Y |
|
|
|
|
Address Line - 地址行 |
70 |
PAYEE_ADDRESS_LINE_2 |
地址行 |
VARCHAR2 |
25 |
0 |
Y |
|
|
|
|
Address Line - 地址行 |
71 |
PAYEE_ADDRESS_CITY_NAME |
城市名称 |
VARCHAR2 |
22 |
0 |
Y |
|
|
|
|
City Name - 城市名称 |
72 |
PAYEE_ADDRESS_STATE_CODE |
收款人国家代码 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Payee State Code - 收款人国家代码 |
73 |
PAYEE_ADDRESS_ZIP_CODE |
邮政编码 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Zip Code - 邮政编码 |
74 |
PAYEE_ADDRESS_ZIP_CODE_EXT |
邮政编码扩展 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Zip Code Extention - 邮政编码扩展 |
75 |
PAST_DUE_CHILD_SUPPORT_AMT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
76 |
PAST_DUE_CHILD_SUPPORT_FREQ |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
77 |
PAST_DUE_CASH_MEDICAL_SUP_AMT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
78 |
PAST_DUE_CASH_MEDICAL_SUP_FREQ |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
79 |
PAST_DUE_SPOUSAL_SUPPORT_AMT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
80 |
PAST_DUE_SPOUSAL_SUPPORT_FREQ |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
81 |
OTHER_SUPPORT_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
82 |
OTHER_SUPPORT_FREQUENCY |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
83 |
OTHER_SUPPORT_DESCRIPTION |
其他支持说明 |
VARCHAR2 |
35 |
0 |
Y |
|
|
|
|
Other Support Description - 其他支持说明 |
84 |
TOTAL_ORDER_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
85 |
TOTAL_ORDER_FREQUENCY |
支付频率 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Pay Frequency - 支付频率 |
86 |
LUMP_SUM_PAYMENT_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
87 |
WEEKLY_WITHHOLDING_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
88 |
SEMIMONTHLY_WITHHOLDING_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
89 |
MONTHLY_WITHHOLDING_AMOUNT |
支付金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pay Amount - 支付金额 |
90 |
LOG_NUMBER |
e-IWO日志号 |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
e-IWO Log Number - e-IWO日志号 |
91 |
PROCESS_ORDER_TIMESTAMP |
e-IWO-处理订单时间戳 |
FLOAT |
15 |
0 |
Y |
|
|
|
|
e-IWO - Process Order Timestamp - e-IWO-处理订单时间戳 |
92 |
LUMP_SUM_PAYMENT_DATE |
一次性付款日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Lump Sum Payment Date - 一次性付款日期 |