1 |
ADDRNUMBER |
地址号码 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Address Number - 地址号码 |
2 |
ALLOC_PERCENT |
Gen Rep-分配百分比 |
FLOAT |
9 |
8 |
Y |
|
|
|
|
Gen Rep - Allocation Percentage - Gen Rep-分配百分比 |
3 |
API_NUMBER |
Roy 2.0 CO井API编号 |
CHAR |
12 |
0 |
Y |
|
|
|
|
Roy 2.0 CO - Well API Number - Roy 2.0 CO井API编号 |
4 |
BUKRS |
公司代码 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Company Code - 公司代码 |
5 |
CHANGE_TIMESTAMP |
上次更改的时间戳 |
FLOAT |
15 |
0 |
Y |
|
|
|
|
Last Changed Timestamp - 上次更改的时间戳 |
6 |
CHANGE_USER |
上次更改者 |
CHAR |
12 |
0 |
Y |
|
|
|
|
Last Changed By - 上次更改者 |
7 |
COUNC |
原文:COUNC |
CHAR |
3 |
0 |
Y |
|
|
|
|
County Code - 原文:COUNC |
8 |
CT_NO |
合同编号 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Contract Number - 合同编号 |
9 |
DECIMAL_INT |
罗伊2.0芒聙聯 小数利息 |
FLOAT |
9 |
8 |
Y |
|
|
|
|
Roy 2.0 CO 芒聙聯 Decimal Interest - 罗伊2.0芒聙聯 小数利息 |
10 |
DISB_DECIMAL |
支付小数 |
FLOAT |
9 |
8 |
Y |
|
|
|
|
Disbursement Decimal - 支付小数 |
11 |
DN_NO |
传送网络号 |
CHAR |
20 |
0 |
Y |
|
|
|
|
Delivery network number - 传送网络号 |
12 |
DOC_NO |
价值文件编号 |
CHAR |
20 |
0 |
Y |
|
|
|
|
Val. document number - 价值文件编号 |
13 |
DOC_YEAR |
文件年份 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Document year - 文件年份 |
14 |
DOI_NO |
利益分配 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Division of interest (DOI) - 利益分配 |
15 |
ENERGY_UOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
16 |
ENTITY_ID |
Gen Rep-代理实体ID |
CHAR |
20 |
0 |
Y |
|
|
|
|
Gen Rep - Agency Entity ID - Gen Rep-代理实体ID |
17 |
ENTITY_LINK_GUID |
32个字符的16字节UUID(十六进制编码) |
CHAR |
32 |
0 |
Y |
|
|
|
|
16 Byte UUID in 32 Characters (Hexadecimal Encoded) - 32个字符的16字节UUID(十六进制编码) |
18 |
ENTY_CD |
实体代码 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Entity Code - 实体代码 |
19 |
GRAVITY |
Gen Rep-标准/基本条件下的油/气密度 |
FLOAT |
16 |
16 |
Y |
|
|
|
|
Gen Rep - Oil/gas density at standard/base conditions - Gen Rep-标准/基本条件下的油/气密度 |
20 |
GROSS_ENERGY |
总能量 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Gross Energy - 总能量 |
21 |
GROSS_PTR |
总PTR |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Gross PTR - 总PTR |
22 |
GROSS_PVR |
总PVR |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Gross PVR - 总PVR |
23 |
GROSS_VAL |
总值 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Gross value - 总值 |
24 |
GROSS_VOL |
总体积 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Total Gross Volume - 总体积 |
25 |
HEAT_VAL |
热值 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Heating value - 热值 |
26 |
HEAT_VAL_UOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
27 |
INTERFACE_FL |
将军旗 |
CHAR |
1 |
0 |
Y |
|
|
|
|
General Flag - 将军旗 |
28 |
KOSTL |
成本中心 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Cost Center - 成本中心 |
29 |
LAND1 |
国家密钥 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Country Key - 国家密钥 |
30 |
MANDT |
顾客 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Client - 顾客 |
31 |
MASTER_LEVEL |
德州主数据级 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Texas Master Data Level - 德州主数据级 |
32 |
MASTER_LINK_GUID |
32个字符的16字节UUID(十六进制编码) |
CHAR |
32 |
0 |
Y |
|
|
|
|
16 Byte UUID in 32 Characters (Hexadecimal Encoded) - 32个字符的16字节UUID(十六进制编码) |
33 |
MP_NO |
测量点编号 |
CHAR |
20 |
0 |
Y |
|
|
|
|
Measurement point number - 测量点编号 |
34 |
NET_VAL |
所有者净值 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Owner Net Value - 所有者净值 |
35 |
RUN_ID |
进程2.0-运行ID |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Proc 2.0 - Run ID - 进程2.0-运行ID |
36 |
ROYTXN_GUID |
32个字符的16字节UUID(十六进制编码) |
CHAR |
32 |
0 |
Y |
|
|
|
|
16 Byte UUID in 32 Characters (Hexadecimal Encoded) - 32个字符的16字节UUID(十六进制编码) |
37 |
PROC_ID |
进程2.0-进程ID |
CHAR |
10 |
0 |
Y |
|
|
|
|
Proc 2.0 - Process ID - 进程2.0-进程ID |
38 |
SALES_DT |
销售日期/月 |
DATE |
8 |
0 |
Y |
|
|
|
|
Sales Date / Month - 销售日期/月 |
39 |
PDCD |
全三个字符。产品代码(主要和详细产品) |
CHAR |
3 |
0 |
Y |
|
|
|
|
Full three char. product code (Major and Detail Products) - 全三个字符。产品代码(主要和详细产品) |
40 |
WL_NO |
油井识别号 |
CHAR |
15 |
0 |
Y |
|
|
|
|
Well ID number - 油井识别号 |
41 |
WC_NO |
完井编号 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Well Completion Number - 完井编号 |
42 |
VNAME |
合资企业 |
CHAR |
6 |
0 |
Y |
|
|
|
|
Joint venture - 合资企业 |
43 |
VL_TYPE_CD |
卷类型代码 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Volume type code - 卷类型代码 |
44 |
OWN_NO |
审慎监管局所有人 |
CHAR |
10 |
0 |
Y |
|
|
|
|
PRA owner - 审慎监管局所有人 |
45 |
OWN_INT_TYPE_CD |
参与者兴趣类型 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Participant Interest Type - 参与者兴趣类型 |
46 |
OWN_ISQ_NO |
所有者权益序号 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Owner Interest Sequence Number - 所有者权益序号 |
47 |
REV_BOOK_ADJ_IND |
冲销/预订/调整 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Reversal/Booking/Adjustment - 冲销/预订/调整 |
48 |
UNIT_VNAME |
单位风险投资 |
CHAR |
6 |
0 |
Y |
|
|
|
|
Unit venture - 单位风险投资 |
49 |
OPERATED_FL |
操作旗 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Operated flag - 操作旗 |
50 |
REGIO |
地区(州、省、县) |
CHAR |
3 |
0 |
Y |
|
|
|
|
Region (State, Province, County) - 地区(州、省、县) |
51 |
PRI_GEO_LOC |
主要地理位置。位置) |
CHAR |
2 |
0 |
Y |
|
|
|
|
Primary geographical location (PRI geo. loc.) - 主要地理位置。位置) |
52 |
SAKNR |
总账账号 |
CHAR |
10 |
0 |
Y |
|
|
|
|
G/L Account Number - 总账账号 |
53 |
PAY_CD |
支付代码 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Pay Code - 支付代码 |
54 |
WAERS |
货币密钥 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency Key - 货币密钥 |
55 |
VOL_UOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
56 |
PRES_UOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
57 |
PS_BASE_QY |
压力底座 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Pressure Base - 压力底座 |
58 |
NRI_DECIMAL |
净收入利息百分比 |
FLOAT |
9 |
8 |
Y |
|
|
|
|
Net Revenue Interest Percent - 净收入利息百分比 |
59 |
OPTION1 |
单字符标志 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Single-Character Flag - 单字符标志 |
60 |
OPTION2 |
单字符标志 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Single-Character Flag - 单字符标志 |
61 |
OPTION3 |
单字符标志 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Single-Character Flag - 单字符标志 |
62 |
OOS_FL |
将军旗 |
CHAR |
1 |
0 |
Y |
|
|
|
|
General Flag - 将军旗 |
63 |
NET_VOL |
所有者净体积 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Owner Net Volume - 所有者净体积 |
64 |
OWNER_ENERGY |
业主能源 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Owner Energy - 业主能源 |
65 |
OWN_PVR |
所有者PVR |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Owner PVR - 所有者PVR |
66 |
OWN_PTR |
业主PTR |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Owner PTR - 业主PTR |
67 |
OWNER_GROSS_VAL |
业主总价值 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Owner Gross Value - 业主总价值 |
68 |
PROF_LINK_GUID |
32个字符的16字节UUID(十六进制编码) |
CHAR |
32 |
0 |
Y |
|
|
|
|
16 Byte UUID in 32 Characters (Hexadecimal Encoded) - 32个字符的16字节UUID(十六进制编码) |
69 |
PRODUCT_CODE |
Gen Rep-代理产品代码 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Gen Rep - Agency Product Code - Gen Rep-代理产品代码 |
70 |
REFERENCE_RUN_ID |
进程2.0-运行ID |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Proc 2.0 - Run ID - 进程2.0-运行ID |
71 |
TOT_GROSS_MKT_AM |
Gen Rep-总营销 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Gross Marketing - Gen Rep-总营销 |
72 |
TOT_GROSS_RMB_AM |
Gen Rep-总营销报销 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Gross Marketing Reimbursement - Gen Rep-总营销报销 |
73 |
TOT_GROSS_TAX_AM |
Gen Rep-总税金 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Gross Tax - Gen Rep-总税金 |
74 |
TOT_GROSS_TX_RMB |
Gen Rep-总报税总额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Gross Tax Reimbursement - Gen Rep-总报税总额 |
75 |
TOT_OWNER_MKT_AM |
Gen Rep-总拥有者营销 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Owner Marketing - Gen Rep-总拥有者营销 |
76 |
TOT_OWNER_RMB_AM |
Gen Rep-所有者营销报销总额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Owner Marketing Reimbursement - Gen Rep-所有者营销报销总额 |
77 |
TOT_OWNER_TAX_AM |
Gen Rep-所有者税总额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Owner Tax - Gen Rep-所有者税总额 |
78 |
TOT_OWNER_TX_RMB |
Gen Rep-业主报税总额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Owner Tax Reimbursement - Gen Rep-业主报税总额 |
79 |
TOT_OTHER_DED_AM |
Gen Rep-其他扣除总额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Gen Rep - Total Other Deduct - Gen Rep-其他扣除总额 |
80 |
WELL_NAME |
好名字 |
CHAR |
35 |
0 |
Y |
|
|
|
|
Well name - 好名字 |
81 |
UNIT_LEASE_FLAG |
Roy 2.0共同单元租赁标志 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Roy 2.0 CO - Unit Lease flag - Roy 2.0共同单元租赁标志 |
82 |
PERCENT |
百分比 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
PERCENT - 百分比 |