1 |
ACCOUNT_HIER_NODE_DESC |
层次结构节点的描述 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Description of a Hierarchy Node - 层次结构节点的描述 |
2 |
ACCOUNT_HIERARCHY_NODE |
层次结构节点ID |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Hierarchy Node ID - 层次结构节点ID |
3 |
ACCOUNT_ID |
业务伙伴编号 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Business Partner Number - 业务伙伴编号 |
4 |
ACCRUAL_BALANCE |
应计余额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Accrual Balance - 应计余额 |
5 |
ACCRUAL_END_DT |
计提结束日期(查询) |
DATE |
8 |
0 |
Y |
|
|
|
|
Accrual End Date (For Query ) - 计提结束日期(查询) |
6 |
ACCRUAL_START_DT |
计提开始日期(查询) |
DATE |
8 |
0 |
Y |
|
|
|
|
Accrual Start Date (For Query) - 计提开始日期(查询) |
7 |
APPROVED_CLAIM |
批准的索赔 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Approved Claim - 批准的索赔 |
8 |
AVAILABLE_TO_DISTR |
可供分发 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Available-to-Distribute - 可供分发 |
9 |
AVAILABLE_TO_PLAN |
可预订 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Available-to-Reserve - 可预订 |
10 |
AVAILABLE_TO_SPEND |
可供消费 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Available-to-Spend - 可供消费 |
11 |
BP_DESC |
业务伙伴简称 |
VARCHAR2 |
50 |
0 |
Y |
|
|
|
|
Short name of business partner - 业务伙伴简称 |
12 |
BP_GUID |
业务伙伴GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
Business Partner GUID - 业务伙伴GUID |
13 |
BPH_GUID |
层次结构节点的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID of Hierarchy Node - 层次结构节点的GUID |
14 |
BUDGET |
预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Budget - 预算 |
15 |
BUDGET_EARNED |
绩效预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Earned Performance Budget - 绩效预算 |
16 |
BUDGET_FIXED |
固定预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Fixed Budget - 固定预算 |
17 |
BUDGET_PERF |
绩效预算关键数字 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Performance Budget Key figure - 绩效预算关键数字 |
18 |
BUDGET_PERF_MAN |
绩效预算手册更新关键数字 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Performance Budget Manual Update Key figure - 绩效预算手册更新关键数字 |
19 |
BUDGET_PERF_TOTAL |
总绩效预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Total Performance Budget - 总绩效预算 |
20 |
CHARGEBACK_BAL |
退单余额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Chargeback Balance - 退单余额 |
21 |
COMMITMENT |
坚信的 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Committed - 坚信的 |
22 |
CREATED_BY |
FM资金用途:用户名 |
VARCHAR2 |
12 |
0 |
Y |
|
|
|
|
FM Fund Usage: User Name - FM资金用途:用户名 |
23 |
CREATED_ON |
创建的资金使用情况(用于查询) |
DATE |
8 |
0 |
Y |
|
|
|
|
Fund Usage Created On (For Query) - 创建的资金使用情况(用于查询) |
24 |
DESCRIPTION |
资金管理:资金使用说明 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Funds Management: Fund Usage Description - 资金管理:资金使用说明 |
25 |
EXP_APPROVED_CLA |
已过期的批准索赔 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Expired Approved Claim - 已过期的批准索赔 |
26 |
EXPENSE_TYPE |
费用类型 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Expense Type - 费用类型 |
27 |
EXPENSE_TYPE_DESC |
费用类型说明 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Expense Type Description - 费用类型说明 |
28 |
EXPENSED |
费用化 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Expensed - 费用化 |
29 |
EXPIRED |
期满 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Expired - 期满 |
30 |
EXT_SETTLED |
对外结算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Externally Settled - 对外结算 |
31 |
EXTERNAL_ID |
贸易促进:资金使用ID |
FLOAT |
24 |
0 |
Y |
|
|
|
|
Trade Promotion: Fund Usage ID - 贸易促进:资金使用ID |
32 |
FM_CURRENCY |
货币密钥 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency Key - 货币密钥 |
33 |
FU_H_DUMMY |
长度为1的虚拟函数 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Dummy function in length 1 - 长度为1的虚拟函数 |
34 |
PEND_BUDG_REDUCT |
待削减预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pending Budget Reduction - 待削减预算 |
35 |
PEND_CHARGEBACK |
待决退单 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pending Chargeback - 待决退单 |
36 |
PEND_PPAY_REDUCT |
待处理预付款减少 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pending Prepayment Reduction - 待处理预付款减少 |
37 |
PEND_PREPAYMENT |
等待預付款 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pending Prepayment - 等待預付款 |
38 |
PEND_WRITEOFF |
待核销 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pending Write-Off - 待核销 |
39 |
PENDING_CLAIM |
未决索赔 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Pending Claim - 未决索赔 |
40 |
PREPAID |
预付款的 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Prepaid - 预付款的 |
41 |
PREPAID_BALANCE |
预付余额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Prepaid Balance - 预付余额 |
42 |
PRERESERVED |
预先保留 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Prereserved - 预先保留 |
43 |
REF_LOGSYS |
逻辑系统 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Logical system - 逻辑系统 |
44 |
REF_OBJ_DESC |
引用对象描述 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Reference Object Description - 引用对象描述 |
45 |
REF_OBJ_ID |
引用对象ID |
VARCHAR2 |
70 |
0 |
Y |
|
|
|
|
Reference Object ID - 引用对象ID |
46 |
REF_OBJKEY |
对象键 |
VARCHAR2 |
70 |
0 |
Y |
|
|
|
|
Object key - 对象键 |
47 |
REF_OBJTYPE |
资金使用参照对象类型 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Fund Usage Reference Object Type - 资金使用参照对象类型 |
48 |
REF_OBJTYPE_DESC |
资金使用类型说明 |
VARCHAR2 |
70 |
0 |
Y |
|
|
|
|
Fund Usage Type Description - 资金使用类型说明 |
49 |
RELEASED_SETTLE |
释放以解决 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Released-to-Settle - 释放以解决 |
50 |
REMAINING_CASH |
剩余现金 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Remaining Cash - 剩余现金 |
51 |
STATUS_DESC |
对象状态 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Object status - 对象状态 |
52 |
RESERVED |
保留 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Reserved - 保留 |
53 |
UNCONSUMEDBUDGET |
未消耗预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Unconsumed Budget - 未消耗预算 |
54 |
SETTLED |
解决了 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Settled - 解决了 |
55 |
WRITTEN_OFF |
注销 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Written Off - 注销 |
56 |
TO_BE_DISTRIB |
待分配 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
To be Distributed - 待分配 |
57 |
VAR_REQUESTED |
要求的过度消费 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Requested Overconsumption - 要求的过度消费 |
58 |
VAR_APPROVED |
批准的过度消费 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Approved Overconsumption - 批准的过度消费 |
59 |
VAR_NEGATIVE |
未消耗预算 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Unconsumed Budget - 未消耗预算 |
60 |
REMAINING_RESERVED |
保留 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Remaining Reserved - 保留 |