1 |
ACTIVEFLAG |
单字符标志 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Single-Character Flag - 单字符标志 |
2 |
ALTERNATESUPPLIERID |
卖方或债权人账号 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Account Number of Vendor or Creditor - 卖方或债权人账号 |
3 |
ALTERNATESUPPLIERNAME |
名称1 |
CHAR |
35 |
0 |
Y |
|
|
|
|
Name 1 - 名称1 |
4 |
ALTERNATEVENDORINDICATOR |
布尔变量(X=真,-=假,空格=未知) |
CHAR |
1 |
0 |
Y |
|
|
|
|
Boolean Variable (X = True, - = False, Space = Unknown) - 布尔变量(X=真,-=假,空格=未知) |
5 |
AVAILABILITYCHART |
地址 |
CHAR |
43 |
0 |
Y |
|
|
|
|
Address - 地址 |
6 |
BASEQUANTITYPRECISION |
四舍五入小数位数 |
INTEGER |
5 |
0 |
Y |
|
|
|
|
No. of decimal places for rounding - 四舍五入小数位数 |
7 |
CONTACTPERSON |
创建对象的人员的姓名 |
CHAR |
12 |
0 |
Y |
|
|
|
|
Name of Person who Created the Object - 创建对象的人员的姓名 |
8 |
CONVERSIONFACTOR |
转换因子 |
FLOAT |
13 |
3 |
Y |
|
|
|
|
CONVERSIONFACTOR - 转换因子 |
9 |
CONVERSIONFACTORDESC |
换算系数说明 |
CHAR |
40 |
0 |
Y |
|
|
|
|
Conversion Factor Description - 换算系数说明 |
10 |
CURRENCYKEY |
货币密钥 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency Key - 货币密钥 |
11 |
CURRENCYKEYPRECISION |
小数位数 |
INTEGER |
3 |
0 |
Y |
|
|
|
|
Number of decimal places - 小数位数 |
12 |
DELIVERYDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
13 |
DELIVERYINWORKDAYS |
工作日抵销 |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Offset in work days - 工作日抵销 |
14 |
DUMMY_MRP_MATERIAL_ORDER |
长度为1的虚拟函数 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Dummy function in length 1 - 长度为1的虚拟函数 |
15 |
EMAILADDRESS |
电子邮件地址 |
CHAR |
241 |
0 |
Y |
|
|
|
|
E-Mail Address - 电子邮件地址 |
16 |
EXPECTEDAVAILABILITYDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
17 |
EXPECTEDDELIVERYDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
18 |
GROSSWEIGHT |
毛重 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Gross weight - 毛重 |
19 |
GROSSWEIGHTUNITPRECISION |
四舍五入小数位数 |
INTEGER |
5 |
0 |
Y |
|
|
|
|
No. of decimal places for rounding - 四舍五入小数位数 |
20 |
MATERIALABCCLASSIFICATION |
ABC指示器 |
CHAR |
1 |
0 |
Y |
|
|
|
|
ABC Indicator - ABC指示器 |
21 |
MATERIALBASEUOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
22 |
MATERIALEXTERNALID |
材料编号 |
CHAR |
40 |
0 |
Y |
|
|
|
|
Material Number - 材料编号 |
23 |
MATERIALGOODSRECEIPTDURATION |
收货处理时间(天) |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Goods receipt processing time in days - 收货处理时间(天) |
24 |
MATERIALGROUP |
材料组 |
CHAR |
9 |
0 |
Y |
|
|
|
|
Material Group - 材料组 |
25 |
MATERIALGROUPNAME |
物料组描述 |
CHAR |
20 |
0 |
Y |
|
|
|
|
Material Group Description - 物料组描述 |
26 |
MATERIALID |
材料编号 |
CHAR |
40 |
0 |
Y |
|
|
|
|
Material Number - 材料编号 |
27 |
MATERIALNAME |
材料描述 |
CHAR |
40 |
0 |
Y |
|
|
|
|
Material description - 材料描述 |
28 |
MATERIALPURCHASEUOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
29 |
MATERIALSAFETYSTOCKQTY |
安全库存 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Safety stock - 安全库存 |
30 |
MATERIALSHORTAGEDEFINITIONID |
文本搜索 |
CHAR |
15 |
0 |
Y |
|
|
|
|
Textsearch - 文本搜索 |
31 |
MATERIALSHORTAGEDEFINITIONNAME |
材料短定义名称 |
CHAR |
40 |
0 |
Y |
|
|
|
|
MATERIALSHORTAGEDEFINITIONNAME - 材料短定义名称 |
32 |
MATERIALSHORTAGEDEFINITIONTYPE |
材料短定义类型 |
CHAR |
1 |
0 |
Y |
|
|
|
|
MATERIALSHORTAGEDEFINITIONTYPE - 材料短定义类型 |
33 |
MATERIALSHORTAGETHRESHOLDTYPE |
材料短缺阈值类型 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Material Shortage Threshold Type - 材料短缺阈值类型 |
34 |
MATERIALTYPE |
材料类型 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Material type - 材料类型 |
35 |
MATERIALTYPENAME |
物料类型说明 |
CHAR |
25 |
0 |
Y |
|
|
|
|
Description of Material Type - 物料类型说明 |
36 |
MATSHORTAGEDEFEVALHORIZONDAYS |
4字节有符号整数 |
INTEGER |
10 |
0 |
Y |
|
|
|
|
4 Byte Signed Integer - 4字节有符号整数 |
37 |
MATSHORTAGEDEFEVALHRZNENDEDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
38 |
MAXIMUMORDERQUANTITY |
最大采购订单数量 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Maximum Purchase Order Quantity - 最大采购订单数量 |
39 |
MAXPROPOSEDQUANTITY |
最大建议数量。 |
NUMBER |
21 |
3 |
Y |
|
|
|
|
Max. Proposed Qty. - 最大建议数量。 |
40 |
MAXPROPOSEDQUANTITYCHECK |
最大建议数量检查 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Max. Proposed Quantity Check - 最大建议数量检查 |
41 |
MAXPROPOSEDQUANTITYUOM |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
42 |
MINIMUMORDERQUANTITY |
最小采购订单数量 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Minimum Purchase Order Quantity - 最小采购订单数量 |
43 |
MRPPLANT |
植物 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Plant - 植物 |
44 |
MRPPLANTNAME |
姓名 |
CHAR |
30 |
0 |
Y |
|
|
|
|
Name - 姓名 |
45 |
MRPAREA |
MRP区域 |
CHAR |
10 |
0 |
Y |
|
|
|
|
MRP Area - MRP区域 |
46 |
MRPAREATEXT |
MRP区域文本 |
CHAR |
40 |
0 |
Y |
|
|
|
|
MRP Area Text - MRP区域文本 |
47 |
MRPGROUP |
原文:MRPGROUP |
CHAR |
4 |
0 |
Y |
|
|
|
|
MRP Group - 原文:MRPGROUP |
48 |
MRPGROUPNAME |
文本,40个字符长 |
CHAR |
40 |
0 |
Y |
|
|
|
|
Text, 40 Characters Long - 文本,40个字符长 |
49 |
MRPTYPE |
MRP类型 |
CHAR |
2 |
0 |
Y |
|
|
|
|
MRP Type - MRP类型 |
50 |
MRPTYPENAME |
物料需求计划类型描述 |
CHAR |
60 |
0 |
Y |
|
|
|
|
Material Requirements Planning Type Description - 物料需求计划类型描述 |
51 |
PURCHASINGGROUP |
采购组 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Purchasing Group - 采购组 |
52 |
PURCHASINGGROUPNAME |
采购组描述 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Description of purchasing group - 采购组描述 |
53 |
MRPCONTROLLER |
生产物料计划 |
CHAR |
3 |
0 |
Y |
|
|
|
|
MRP Controller - 生产物料计划 |
54 |
MRPCONTROLLERNAME |
MRP控制员姓名 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Name of MRP controller - MRP控制员姓名 |
55 |
MRPPURCHASINGORG |
采购组织 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Purchasing organization - 采购组织 |
56 |
MRPPLANNINGSEGMENTTYPE |
物料需求计划部分 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Material requirements planning segment - 物料需求计划部分 |
57 |
MRPPLANNINGSEGMENTNUMBER |
规划段编号 |
CHAR |
20 |
0 |
Y |
|
|
|
|
Planning segment number - 规划段编号 |
58 |
MRPSAFETYDURATIONENDDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
59 |
MRPSAFETYDURATION |
版本号的组件 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Component of the Version Number - 版本号的组件 |
60 |
ORDERDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
61 |
ORDERINWORKDAYS |
工作日抵销 |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Offset in work days - 工作日抵销 |
62 |
REPLENISHMENTDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
63 |
REPLENISHMENTINWORKDAYS |
工作日抵销 |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Offset in work days - 工作日抵销 |
64 |
VENDORTYPEFLAG |
供应商类型(标准或配额) |
CHAR |
1 |
0 |
Y |
|
|
|
|
Vendor Type (Standard or Quota) - 供应商类型(标准或配额) |
65 |
PREFERREDSUPPLIERID |
卖方或债权人账号 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Account Number of Vendor or Creditor - 卖方或债权人账号 |
66 |
PREFERREDSUPPLIERNAME |
名称1 |
CHAR |
35 |
0 |
Y |
|
|
|
|
Name 1 - 名称1 |
67 |
RECEIPTDAYSSUPPLY |
总补货提前期(工作日) |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Total replenishment lead time (in workdays) - 总补货提前期(工作日) |
68 |
PLANNEDDELVRYDAYS |
计划交货时间(天) |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Planned Delivery Time in Days - 计划交货时间(天) |
69 |
VOLUME |
体积 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Volume - 体积 |
70 |
WEIGHTUNIT |
重量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Weight Unit - 重量单位 |
71 |
VOLUMEUNIT |
体积单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Volume unit - 体积单位 |
72 |
PURCHASEPRICE |
采购信息记录中的净价 |
NUMBER |
11 |
2 |
Y |
|
|
|
|
Net Price in Purchasing Info Record - 采购信息记录中的净价 |
73 |
NEXTORDERDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
74 |
NEXTORDERINWORKDAYS |
工作日抵销 |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Offset in work days - 工作日抵销 |
75 |
NEXTREPLENISHMENTDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
76 |
NEXTREPLENISHMENTINWORKDAYS |
工作日抵销 |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Offset in work days - 工作日抵销 |
77 |
NEXTDELIVERYDATE |
UTC时间戳缩写(YYYYMMDDhhmmss) |
FLOAT |
15 |
0 |
Y |
|
|
|
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) - UTC时间戳缩写(YYYYMMDDhhmmss) |
78 |
NEXTDELIVERYINWORKDAYS |
工作日抵销 |
FLOAT |
3 |
0 |
Y |
|
|
|
|
Offset in work days - 工作日抵销 |
79 |
PROPOSEDQUANTITYPURCHASE |
建议数量采购 |
NUMBER |
21 |
3 |
Y |
|
|
|
|
PROPOSEDQUANTITYPURCHASE - 建议数量采购 |
80 |
PROPOSEDQUANTITYBASE |
建议数量基数 |
NUMBER |
21 |
3 |
Y |
|
|
|
|
PROPOSEDQUANTITYBASE - 建议数量基数 |
81 |
PURCHASEVALUE |
采购信息记录中的净价 |
NUMBER |
11 |
2 |
Y |
|
|
|
|
Net Price in Purchasing Info Record - 采购信息记录中的净价 |
82 |
TELEPHONENUMBER |
电话号码:拨码+号码 |
CHAR |
30 |
0 |
Y |
|
|
|
|
Telephone no.: dialling code+number - 电话号码:拨码+号码 |
83 |
PRICEUNIT |
价格单位 |
FLOAT |
5 |
0 |
Y |
|
|
|
|
Price unit - 价格单位 |
84 |
ORDERPRICEUNIT |
订单价格单位(采购) |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Order Price Unit (Purchasing) - 订单价格单位(采购) |
85 |
ORDERPRICEUNITPRECISION |
四舍五入小数位数 |
INTEGER |
5 |
0 |
Y |
|
|
|
|
No. of decimal places for rounding - 四舍五入小数位数 |
86 |
VOLUMEUNITPRECISION |
四舍五入小数位数 |
INTEGER |
5 |
0 |
Y |
|
|
|
|
No. of decimal places for rounding - 四舍五入小数位数 |
87 |
PURCHASEQUANTITYPRECISION |
四舍五入小数位数 |
INTEGER |
5 |
0 |
Y |
|
|
|
|
No. of decimal places for rounding - 四舍五入小数位数 |
88 |
PURCHASEREQUISITION |
请购单编号 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Purchase Requisition Number - 请购单编号 |
89 |
PURCHASEREQUISITIONITEM |
请购单料号 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Item number of purchase requisition - 请购单料号 |
90 |
ORDERQUANTITYUNIT |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
91 |
ORDERQUANTITYUNITPRECISION |
四舍五入小数位数 |
INTEGER |
5 |
0 |
Y |
|
|
|
|
No. of decimal places for rounding - 四舍五入小数位数 |
92 |
ROUNDINGVALUE |
采购订单数量的舍入值 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Rounding value for purchase order quantity - 采购订单数量的舍入值 |
93 |
ROUNDINGPROFILE |
原文:ROUNDINGPROFILE |
CHAR |
4 |
0 |
Y |
|
|
|
|
Rounding Profile - 原文:ROUNDINGPROFILE |
94 |
VERSION |
版本号的组件 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Component of the Version Number - 版本号的组件 |
95 |
ORDERUNIT |
3字节字段 |
CHAR |
3 |
0 |
Y |
|
|
|
|
3-Byte field - 3字节字段 |