回答編集履歴

1

編集

2019/04/18 02:33

投稿

raccoondog
raccoondog

スコア77

test CHANGED
@@ -28,27 +28,7 @@
28
28
 
29
29
  FROM_FACTORY_CODE,
30
30
 
31
- FROM_ORG_CODE,
32
-
33
- FROM_SUBINV_CODE,
34
-
35
- FROM_VALUE_CODE,
36
-
37
- FROM_OPERATOR_NAME,
38
-
39
- TO_FACTORY_CODE,
40
-
41
- TO_ORG_CODE,
31
+    中略
42
-
43
- TO_SUBINV_CODE,
44
-
45
- TO_VALUE_CODE,
46
-
47
- TO_OPERATOR_NAME,
48
-
49
- SUB_SYSTEM_TYPE1,
50
-
51
- CANCEL_FLAG,
52
32
 
53
33
  ACT_CREATION_DATE,
54
34
 
@@ -60,135 +40,7 @@
60
40
 
61
41
  ERROR_STATUS,
62
42
 
63
- DESCRIPTION,
43
+
64
-
65
- LOCATION,
66
-
67
- REVISION_NO,
68
-
69
- OPE_CODE,
70
-
71
- BOX_KIND,
72
-
73
- DEMAND_NO,
74
-
75
- (CAST(SUB_NO AS NUMERIC)) AS SUB_NO,
76
-
77
- TRAFFIC_NO,
78
-
79
- IF_FLAG,
80
-
81
- SELL_BUY_DATA_FLAG,
82
-
83
- (CAST(SOURCE_ORDER_NO AS NUMERIC)) AS SOURCE_ORDER_NO,
84
-
85
- (CAST(FT_DEFINE_ID AS NUMERIC)) AS FT_DEFINE_ID,
86
-
87
- (CAST(FROM_SELL_BUY_ID AS NUMERIC)) AS FROM_SELL_BUY_ID,
88
-
89
- (CAST(TO_SELL_BUY_ID AS NUMERIC)) AS TO_SELL_BUY_ID,
90
-
91
- CREATION_DATE,
92
-
93
- CREATED_BY,
94
-
95
- LAST_UPDATE_DATE,
96
-
97
- LAST_UPDATED_BY,
98
-
99
- (CAST(UPDATE_REQUEST_ID AS NUMERIC)) AS UPDATE_REQUEST_ID,
100
-
101
- TIME_STAMP,
102
-
103
- INV_UPDATE_FLAG,
104
-
105
- ISSUE_SEQ,
106
-
107
- (CAST(SOUMEI_ID AS NUMERIC)) AS SOUMEI_ID,
108
-
109
- GCPCS_IF_FLAG,
110
-
111
- GCPCS_IF_CREATION_DATE,
112
-
113
- RECIEPT_CODE,
114
-
115
- DELIV_BIN_NO,
116
-
117
- DELIV_NO,
118
-
119
- RECV_BIN_NO,
120
-
121
- SUB_SYSTEM_TYPE2,
122
-
123
- SHIP_DATE,
124
-
125
- C_NO,
126
-
127
- T_NO,
128
-
129
- RECV_OFFICE_CODE,
130
-
131
- SR_IF_FLAG,
132
-
133
- SR_IF_CREATION_DATE,
134
-
135
- PS_IF_FLAG,
136
-
137
- PS_IF_CREATION_DATE,
138
-
139
- CUSTOMER_CODE,
140
-
141
- KS_TYPE,
142
-
143
- SUPPLY_SECTION,
144
-
145
- MANAGE_NO,
146
-
147
- SEND_OFFICE_CODE,
148
-
149
- SOUMEI_SLIP_NO,
150
-
151
- SOUMEI_ITEM_NO,
152
-
153
- PS_YAZAKI_HINBAN,
154
-
155
- (CAST(INVOICE_CASE_INFO_NO AS NUMERIC)) AS INVOICE_CASE_INFO_NO,
156
-
157
- GYK_SITE_CODE,
158
-
159
- (CAST(CASE_NO AS NUMERIC)) AS CASE_NO,
160
-
161
- (CAST(CASE_SUB_NO AS NUMERIC)) AS CASE_SUB_NO,
162
-
163
- FROM_LOCATION,
164
-
165
- TO_LOCATION,
166
-
167
- GYK_TRAN_TYPE,
168
-
169
- INV_INFO_UPDATE_FLAG,
170
-
171
- RS_NAME,
172
-
173
- FACTORY_NAME,
174
-
175
- ORG_NAME,
176
-
177
- FROM_FACTORY_NAME,
178
-
179
- FROM_ORG_NAME,
180
-
181
- FROM_SUBINV_NAME,
182
-
183
- TO_FACTORY_NAME,
184
-
185
- TO_ORG_NAME,
186
-
187
- TO_SUBINV_NAME,
188
-
189
- OPE_CODE_NAME,
190
-
191
- SUB_SYSTEM_NAME1,
192
44
 
193
45
  CANCEL_NAME,
194
46