1 |
CEAN |
国际货号(EAN/UPC) |
CHAR |
18 |
0 |
Y |
|
|
|
|
International Article Number (EAN/UPC) - 国际货号(EAN/UPC) |
2 |
CEANTRIB |
全球贸易项目编号 |
CHAR |
14 |
0 |
Y |
|
|
|
|
Global Trade Item Number - 全球贸易项目编号 |
3 |
CEXPORTADOR |
出口代码 |
CHAR |
60 |
0 |
Y |
|
|
|
|
Code of the Export Company - 出口代码 |
4 |
CFABRICANTE |
系统中的外国生产商代码 |
CHAR |
60 |
0 |
Y |
|
|
|
|
Code of the foreign producer in the system - 系统中的外国生产商代码 |
5 |
CFOP |
CFOP代码和扩展 |
CHAR |
10 |
0 |
Y |
|
|
|
|
CFOP Code and Extension - CFOP代码和扩展 |
6 |
CPROD |
物料编号(18个字符) |
CHAR |
18 |
0 |
Y |
|
|
|
|
Material Number (18 Characters) - 物料编号(18个字符) |
7 |
DDESEMB |
货物放行日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Date when goods have been released - 货物放行日期 |
8 |
DDI |
DI/DSI/DA注册日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Registration date of the DI/DSI/DA - DI/DSI/DA注册日期 |
9 |
EXTIPI |
原文:EXTIPI |
CHAR |
3 |
0 |
Y |
|
|
|
|
EXTIPI - 原文:EXTIPI |
10 |
GENERO |
NCM代码的前2位数字 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Firtst 2 digits of NCM code - NCM代码的前2位数字 |
11 |
I_ANOFAB |
生产年份 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Production Year - 生产年份 |
12 |
I_ANOMOD |
制造年份型号 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Year of Manufacturing Model - 制造年份型号 |
13 |
I_CHASSI |
车辆底盘 |
CHAR |
17 |
0 |
Y |
|
|
|
|
Vehicle Chassis - 车辆底盘 |
14 |
I_CM3 |
CM3(功率) |
CHAR |
4 |
0 |
Y |
|
|
|
|
CM3 (Power) - CM3(功率) |
15 |
I_CMKG |
厘米千克 |
CHAR |
9 |
0 |
Y |
|
|
|
|
CMKG - 厘米千克 |
16 |
I_CMOD |
代码品牌模型 |
CHAR |
6 |
0 |
Y |
|
|
|
|
Code Brand Model - 代码品牌模型 |
17 |
I_CONDVEIC |
车辆状况 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Condition of the Vehicle - 车辆状况 |
18 |
I_COR |
每个装配厂的代码 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Code for Each Assembly Plant - 每个装配厂的代码 |
19 |
I_DIST |
车轴间距 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Distance Between Axles,车轴间距 |
20 |
I_ESPVEIC |
车的种类 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Sort of Vehicle - 车的种类 |
21 |
I_NMOTOR |
发动机编号 |
CHAR |
21 |
0 |
Y |
|
|
|
|
Engine Number - 发动机编号 |
22 |
I_NSERIE |
Serial (s脙漏rie) |
CHAR |
9 |
0 |
Y |
|
|
|
|
Serial (s脙漏rie) |
23 |
I_PESOB |
毛重 |
CHAR |
9 |
0 |
Y |
|
|
|
|
Gross Weight - 毛重 |
24 |
I_PESOL |
净重 |
CHAR |
9 |
0 |
Y |
|
|
|
|
Net Weight - 净重 |
25 |
I_TPOP |
操作类型 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Type of Operation - 操作类型 |
26 |
I_XCOR |
颜色描述 |
CHAR |
40 |
0 |
Y |
|
|
|
|
Color Description - 颜色描述 |
27 |
I_POT |
发动机功率 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Engine Power - 发动机功率 |
28 |
I_TPCOMB |
燃料类型 |
CHAR |
8 |
0 |
Y |
|
|
|
|
Type of Fuel,燃料类型 |
29 |
I_RENAVAM |
雷诺 |
CHAR |
9 |
0 |
Y |
|
|
|
|
RENAVAM - 雷诺 |
30 |
I_TPPINT |
油漆类型 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Type of Painting - 油漆类型 |
31 |
I_TPVEIC |
车辆类型 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Type of Vehicle - 车辆类型 |
32 |
I_VIN |
车辆识别号状况 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Condition of VIN - 车辆识别号状况 |
33 |
K_TPARMA |
枪械型号指示器 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Indicator of Firearm Type - 枪械型号指示器 |
34 |
K_NSERIE |
枪序列号 |
VARCHAR2 |
9 |
0 |
Y |
|
|
|
|
Gun Serial number - 枪序列号 |
35 |
K_NCANO |
桶序列号 |
VARCHAR2 |
9 |
0 |
Y |
|
|
|
|
Barrel Serial Number - 桶序列号 |
36 |
K_DESCR |
枪的完整描述 |
CHAR |
256 |
0 |
Y |
|
|
|
|
Full Description of the Gun - 枪的完整描述 |
37 |
L1_00_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
38 |
L1_00_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
39 |
L1_00_MODBC |
基本判定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule - 基本判定规则 |
40 |
L1_00_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
41 |
L1_00_PICMS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
42 |
L1_00_VICMS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
43 |
L1_10_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
44 |
L1_10_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
45 |
L1_10_MODBC |
基本确定规则ICMS |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule ICMS - 基本确定规则ICMS |
46 |
L1_10_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
47 |
L1_10_PICMS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
48 |
L1_10_VICMS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
49 |
L1_10_MODBCST |
基本确定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule ICMSST - 基本确定规则 |
50 |
L1_10_PMVAST |
附加费费率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Surcharge rate - 附加费费率 |
51 |
L1_10_PREDBCST |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
52 |
L1_10_VBCST |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
53 |
L1_10_PICMSST |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
54 |
L1_10_VICMSST |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
55 |
L1_20_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
56 |
L1_20_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
57 |
L1_20_MODBC |
基本判定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule - 基本判定规则 |
58 |
L1_20_PREDBC |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
59 |
L1_20_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
60 |
L1_20_PICMS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
61 |
L1_20_VICMS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
62 |
L1_30_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
63 |
L1_30_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
64 |
L1_30_MODBCST |
基本判定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule - 基本判定规则 |
65 |
L1_30_PMVAST |
附加费费率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Surcharge rate - 附加费费率 |
66 |
L1_30_PREDBCST |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
67 |
L1_30_VBCST |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
68 |
L1_30_PICMSST |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
69 |
L1_30_VICMSST |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
70 |
L1_40_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
71 |
L1_40_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
72 |
INFADPROD |
原文:INFADPROD |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
INFADPROD - 原文:INFADPROD |
73 |
NITEM |
项目数量 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Number of items - 项目数量 |
74 |
NCM |
原文:NCM |
CHAR |
16 |
0 |
Y |
|
|
|
|
Control code for consumption taxes in foreign trade - 原文:NCM |
75 |
NDI |
进口报关单号DI/DSI/DA |
CHAR |
10 |
0 |
Y |
|
|
|
|
Import declaration number DI/DSI/DA - 进口报关单号DI/DSI/DA |
76 |
NADICAO |
加法数 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Number of the addition - 加法数 |
77 |
NSEQADIC |
加法中项目的序号 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Sequential number of the item in the addition - 加法中项目的序号 |
78 |
L1_ICMS |
标记ICMS |
CHAR |
1 |
0 |
Y |
|
|
|
|
Tag ICMS - 标记ICMS |
79 |
L1_51_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
80 |
L1_51_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
81 |
L1_51_MODBC |
基本判定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule - 基本判定规则 |
82 |
L1_51_PREDBC |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
83 |
L1_51_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
84 |
L1_51_PICMS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
85 |
L1_51_VICMS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
86 |
L1_60_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
87 |
L1_60_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
88 |
L1_60_VBCST |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
89 |
L1_60_VICMSST |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
90 |
L1_70_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
91 |
L1_70_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
92 |
L1_70_MODBC |
基本确定规则ICMS |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule ICMS - 基本确定规则ICMS |
93 |
L1_70_PREDBC |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
94 |
L1_70_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
95 |
L1_70_PICMS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
96 |
L1_70_VICMS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
97 |
L1_70_MODBCST |
基本确定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule ICMSST - 基本确定规则 |
98 |
L1_70_PMVAST |
附加费费率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Surcharge rate - 附加费费率 |
99 |
L1_70_PREDBCST |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
100 |
L1_70_VBCST |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
101 |
L1_70_PICMSST |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
102 |
L1_70_VICMSST |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
103 |
L1_90_ORIG |
材料来源 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Origin of the material - 材料来源 |
104 |
L1_90_CST |
税收情况 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Tax situation - 税收情况 |
105 |
L1_90_MODBC |
基本确定规则ICMS |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule ICMS - 基本确定规则ICMS |
106 |
L1_90_PREDBC |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
107 |
L1_90_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
108 |
L1_90_PICMS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
109 |
L1_90_VICMS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
110 |
L1_90_MODBCST |
基本确定规则 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Base Determination rule ICMSST - 基本确定规则 |
111 |
L1_90_PMVAST |
附加费费率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Surcharge rate - 附加费费率 |
112 |
L1_90_PREDBCST |
基本还原率 |
FLOAT |
5 |
2 |
Y |
|
|
|
|
Base reduction rate - 基本还原率 |
113 |
L1_90_VBCST |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
114 |
L1_90_PICMSST |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
115 |
L1_90_VICMSST |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
116 |
N_IPI |
原文:N_IPI |
CHAR |
1 |
0 |
Y |
|
|
|
|
N_IPI - 原文:N_IPI |
117 |
N_CLENQ |
IPI类 |
CHAR |
5 |
0 |
Y |
|
|
|
|
IPI class - IPI类 |
118 |
N_CNPJPROD |
税号1 |
CHAR |
16 |
0 |
Y |
|
|
|
|
Tax Number 1 - 税号1 |
119 |
N_CSELO |
来自selo的IPI控制代码 |
CHAR |
60 |
0 |
Y |
|
|
|
|
IPI control code from selo - 来自selo的IPI控制代码 |
120 |
N_QSELO |
来自selo控制的数量 |
VARCHAR2 |
12 |
0 |
Y |
|
|
|
|
Quantity from selo control - 来自selo控制的数量 |
121 |
N_CENQ |
Enquadramento代码 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Enquadramento code - Enquadramento代码 |
122 |
N1_CST |
IPI的子结构代码 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Subtrib code for IPI - IPI的子结构代码 |
123 |
N1_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
124 |
N1_QUNID |
贫民数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Pauta quantity - 贫民数量 |
125 |
N1_VUNID |
保塔单位价值 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Pauta unit value - 保塔单位价值 |
126 |
N1_PIPI |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
127 |
N1_VIPI |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
128 |
N2_CST |
IPI的子结构代码 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Subtrib code for IPI - IPI的子结构代码 |
129 |
O_II |
标签II |
CHAR |
1 |
0 |
Y |
|
|
|
|
Tag II - 标签II |
130 |
O_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
131 |
O_VDESPADU |
海关费用金额 |
FLOAT |
15 |
2 |
Y |
|
|
|
|
Customs Expenses Amount - 海关费用金额 |
132 |
O_VII |
进口税额 |
FLOAT |
15 |
2 |
Y |
|
|
|
|
Import Tax Amount - 进口税额 |
133 |
O_VIOF |
金融业务税金额 |
FLOAT |
15 |
2 |
Y |
|
|
|
|
Tax on Financial Operations Amount - 金融业务税金额 |
134 |
P_PIS |
标签PIS |
CHAR |
1 |
0 |
Y |
|
|
|
|
Tag PIS - 标签PIS |
135 |
P1_CST |
PIS子肋骨代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for PIS - PIS子肋骨代码 |
136 |
P1_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
137 |
P1_PPIS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
138 |
P1_VPIS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
139 |
P2_CST |
PIS子肋骨代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for PIS - PIS子肋骨代码 |
140 |
P2_QBCPROD |
销售数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Sold quantity - 销售数量 |
141 |
P2_VALIQPROD |
Pis率(单位:雷亚尔) |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Pis rate in reais - Pis率(单位:雷亚尔) |
142 |
P2_VPIS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
143 |
P3_CST |
PIS子肋骨代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for PIS - PIS子肋骨代码 |
144 |
P4_CST |
PIS子肋骨代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for PIS - PIS子肋骨代码 |
145 |
P4_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
146 |
P4_PPIS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
147 |
P4_QBCPROD |
销售数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Sold quantity - 销售数量 |
148 |
P4_VALIQPROD |
Pis率(单位:雷亚尔) |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Pis rate in reais - Pis率(单位:雷亚尔) |
149 |
P4_VPIS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
150 |
P5_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
151 |
P5_PPIS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
152 |
P5_QBCPROD |
销售数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Sold quantity - 销售数量 |
153 |
P5_VALIQPROD |
Pis率(单位:雷亚尔) |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Pis rate in reais - Pis率(单位:雷亚尔) |
154 |
P5_VPIS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
155 |
P5_CST |
原文:P5_CST |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
P5_CST,原文:P5_CST |
156 |
Q_COFINS |
标记Cofins |
CHAR |
1 |
0 |
Y |
|
|
|
|
Tag Cofins - 标记Cofins |
157 |
Q1_CST |
COFINS的子结构代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for COFINS - COFINS的子结构代码 |
158 |
Q1_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
159 |
Q1_PCOFINS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
160 |
Q1_VCOFINS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
161 |
Q2_CST |
COFINS的子结构代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for COFINS - COFINS的子结构代码 |
162 |
Q2_QBCPROD |
销售数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Sold quantity - 销售数量 |
163 |
Q2_VALIQPROD |
雷亚尔辅酶率 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
COFINS rate in reais - 雷亚尔辅酶率 |
164 |
Q2_VCOFINS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
165 |
Q3_CST |
COFINS的子结构代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for COFINS - COFINS的子结构代码 |
166 |
Q4_CST |
COFINS的子结构代码 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Subtrib code for COFINS - COFINS的子结构代码 |
167 |
Q4_PCOFINS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
168 |
Q4_QBCPROD |
销售数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Sold quantity - 销售数量 |
169 |
XPROD |
材料文本 |
CHAR |
120 |
0 |
Y |
|
|
|
|
Material Text - 材料文本 |
170 |
UTRIB |
基本计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Base Unit of Measure - 基本计量单位 |
171 |
UCOM |
销售单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Sales unit - 销售单位 |
172 |
QTRIB |
数量 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Quantity - 数量 |
173 |
QCOM |
实际交付数量(销售单位) |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Actual quantity delivered (in sales units) - 实际交付数量(销售单位) |
174 |
VPROD |
总价值,包括所有税金 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Total value including all taxes - 总价值,包括所有税金 |
175 |
VFRETE |
含税运价 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Freight value including taxes - 含税运价 |
176 |
VSEG |
含税保险价值 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Insurance value including taxes - 含税保险价值 |
177 |
VDESC |
含税折现值 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Discount value including taxes - 含税折现值 |
178 |
VUNCOM |
商业单位价值 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Commercial Unit Value - 商业单位价值 |
179 |
VUNTRIB |
计税单位价值 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Taxation Unit Value - 计税单位价值 |
180 |
XLOCDESEMB |
货物放行地点 |
CHAR |
60 |
0 |
Y |
|
|
|
|
Location where goods are released - 货物放行地点 |
181 |
UFDESEMB |
货物放行地区 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Region where the goods have been released - 货物放行地区 |
182 |
VDESCDI |
DI项目的折扣值-添加 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Discount value of the DI item - addition - DI项目的折扣值-添加 |
183 |
Q4_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
184 |
Q4_VALIQPROD |
雷亚尔辅酶率 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
COFINS rate in reais - 雷亚尔辅酶率 |
185 |
Q4_VCOFINS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
186 |
Q5_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
187 |
Q5_PCOFINS |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
188 |
Q5_QBCPROD |
销售数量 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
Sold quantity - 销售数量 |
189 |
Q5_VALIQPROD |
雷亚尔辅酶率 |
FLOAT |
15 |
4 |
Y |
|
|
|
|
COFINS rate in reais - 雷亚尔辅酶率 |
190 |
Q5_VCOFINS |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
191 |
Q5_CST |
问题5_ CST |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Q5_CST - 问题5_ CST |
192 |
X_VBC |
基本金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Base amount - 基本金额 |
193 |
X_VALIQ |
税率 |
FLOAT |
6 |
2 |
Y |
|
|
|
|
Tax Rate - 税率 |
194 |
X_VISSQN |
税额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Tax value - 税额 |
195 |
X_CMUNFG |
市政代码 |
VARCHAR2 |
7 |
0 |
Y |
|
|
|
|
Municipio Code - 市政代码 |
196 |
X_CLISTSERV |
根据法律LC 116/03,ISS服务类型代码 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
ISS service type code according to law LC 116/03 - 根据法律LC 116/03,ISS服务类型代码 |