1 |
ACCRUAL_METHOD |
计提计算方法ID |
VARCHAR2 |
8 |
0 |
Y |
|
|
|
|
Accrual Calculation Method ID - 计提计算方法ID |
2 |
ACCRUED_AMOUNT |
应计金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Amount to be accrued - 应计金额 |
3 |
ACR_ID |
应计计算运行ID |
VARCHAR2 |
50 |
0 |
Y |
|
|
|
|
Accrual Calculation Run ID - 应计计算运行ID |
4 |
ACR_PERIOD |
会计年度/期间 |
VARCHAR2 |
7 |
0 |
Y |
|
|
|
|
Fiscal Year / Period - 会计年度/期间 |
5 |
BP_DESC |
业务伙伴简称 |
VARCHAR2 |
50 |
0 |
Y |
|
|
|
|
Short name of business partner - 业务伙伴简称 |
6 |
BP_GUID |
业务伙伴GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
Business Partner GUID - 业务伙伴GUID |
7 |
BP_ID |
业务伙伴编号 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Business Partner Number - 业务伙伴编号 |
8 |
CHANGED_BY |
用户主记录中的用户名 |
VARCHAR2 |
12 |
0 |
Y |
|
|
|
|
User Name in User Master Record - 用户主记录中的用户名 |
9 |
CHANGED_ON |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
10 |
CREATED_BY |
用户主记录中的用户名 |
VARCHAR2 |
12 |
0 |
Y |
|
|
|
|
User Name in User Master Record - 用户主记录中的用户名 |
11 |
CREATED_ON |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
12 |
CURRENCY |
货币密钥 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency Key - 货币密钥 |
13 |
CUST_NODE_DESC |
层次结构节点的描述 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Description of a Hierarchy Node - 层次结构节点的描述 |
14 |
CUST_NODE_GUID |
层次结构节点的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID of Hierarchy Node - 层次结构节点的GUID |
15 |
CUST_NODE_ID |
层次结构节点ID |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Hierarchy Node ID - 层次结构节点ID |
16 |
EMPLOYEE_DESC |
业务伙伴简称 |
VARCHAR2 |
50 |
0 |
Y |
|
|
|
|
Short name of business partner - 业务伙伴简称 |
17 |
EMPLOYEE_ID |
业务伙伴编号 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Business Partner Number - 业务伙伴编号 |
18 |
EXPENSE_TYPE |
费用类型 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Expense Type - 费用类型 |
19 |
FU_HEAD |
贸易促进:资金使用标题GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
Trade Promotion: Fund Usage Header GUID - 贸易促进:资金使用标题GUID |
20 |
FU_HEAD_ID |
贸易促进:资金使用ID |
VARCHAR2 |
24 |
0 |
Y |
|
|
|
|
Trade Promotion: Fund Usage ID - 贸易促进:资金使用ID |
21 |
FU_ITEM |
TFM资金使用:资金使用项目Guid |
RAW |
16 |
0 |
Y |
|
|
|
|
TFM Fund Usage: Fund Usage Item Guid - TFM资金使用:资金使用项目Guid |
22 |
FU_ITEM_ID |
TFM资金用途:项目外部ID |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
TFM Fund Usage: ITEM External ID - TFM资金用途:项目外部ID |
23 |
FUND_ID |
基金ID |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Fund ID - 基金ID |
24 |
FUND_PLAN |
贸易促进:资金使用资金计划指南 |
RAW |
16 |
0 |
Y |
|
|
|
|
Trade Promotion: Fund Usage Funds Plan GUID - 贸易促进:资金使用资金计划指南 |
25 |
FUND_PLAN_ID |
资金计划ID |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Funds Plan ID - 资金计划ID |
26 |
FUND_TYPE |
基金类型 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Fund Type - 基金类型 |
27 |
FUND_TYPE_DESC |
基金类型说明 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Fund Type Description - 基金类型说明 |
28 |
MANUAL_CORRECTION |
布尔变量(X=真,-=假,空格=未知) |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Boolean Variable (X = True, - = False, Space = Unknown) - 布尔变量(X=真,-=假,空格=未知) |
29 |
MKT_ORG |
营销组织 |
VARCHAR2 |
14 |
0 |
Y |
|
|
|
|
Marketing Organization - 营销组织 |
30 |
MKT_ORG_DESC |
营销组织描述 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Marketing Organization Description - 营销组织描述 |
31 |
MPL_DESC |
语言相关短文本 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Language-Dependent Short Text - 语言相关短文本 |
32 |
MPL_ID |
外部标识 |
VARCHAR2 |
24 |
0 |
Y |
|
|
|
|
External Identification - 外部标识 |
33 |
PERIOD_VARIANT |
会计年度变量 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Fiscal Year Variant - 会计年度变量 |
34 |
PROD_CAT_DESC |
类别描述 |
VARCHAR2 |
80 |
0 |
Y |
|
|
|
|
Category Description - 类别描述 |
35 |
PROD_CATEG_GUID |
类别GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
Category GUID - 类别GUID |
36 |
PROD_CATEG_ID |
类别ID |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Category ID - 类别ID |
37 |
PROD_GROUP_DESC |
说明 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Description - 说明 |
38 |
PROD_GROUP_ID |
产品组1 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Product Group 1 - 产品组1 |
39 |
PRODUCT_DESC |
产品描述 |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Product Description - 产品描述 |
40 |
PRODUCT_GUID |
产品的内部唯一ID |
RAW |
16 |
0 |
Y |
|
|
|
|
Internal Unique ID of Product - 产品的内部唯一ID |
41 |
PRODUCT_ID |
产品ID |
VARCHAR2 |
40 |
0 |
Y |
|
|
|
|
Product ID - 产品ID |
42 |
REF_OBJKEY |
对象键 |
VARCHAR2 |
70 |
0 |
Y |
|
|
|
|
Object key - 对象键 |
43 |
REF_OBJTYPE |
对象类型 |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Object Type - 对象类型 |
44 |
SALES_ORG |
销售组织ID |
VARCHAR2 |
14 |
0 |
Y |
|
|
|
|
Sales Organization ID - 销售组织ID |
45 |
TERRITORY_GUID |
区域GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
Territory GUID - 区域GUID |