EBS: 发运(WSH)表清单
EBS 发运WSH模块表清单
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 | SELECT * FROM WSH.WSH_ACTIVITY_GROUPS SELECT * FROM WSH.WSH_CALENDAR_ASSIGNMENTS -- -- N:OM>>设置>>发运>>承运人,成本类型>>承运人 SELECT * FROM APPS.WSH_CARRIERS_V WC WHERE CARRIER_ID = 800774 -- N:OM>>设置>>发运>>承运人,成本类型>>承运人 SELECT * FROM WSH.WSH_CARRIERS WC WHERE CARRIER_ID = 800774 -- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 服务。 SELECT * FROM WSH.WSH_CARRIER_SERVICES WHERE CARRIER_ID = 800774 -- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 发运方法 SELECT * FROM WSH.WSH_CARRIER_SHIP_METHODS WHERE CARRIER_ID = 800774 -- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 地点 SELECT * FROM WSH.WSH_CARRIER_SITES -- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 运输工具类型 SELECT * FROM WSH.WSH_CARRIER_VEHICLE_TYPES SELECT * FROM WSH.WSH_CC_ADAPTER_STATUS SELECT * FROM WSH.WSH_CC_DENIED_PARTIES SELECT * FROM WSH.WSH_CC_PARAMETER_SETUPS_B SELECT * FROM WSH.WSH_CC_PARAMETER_SETUPS_TL SELECT * FROM WSH.WSH_CC_REQUEST_SETUPS SELECT * FROM WSH.WSH_CC_RESPONSE_HEADERS SELECT * FROM WSH.WSH_CC_RESPONSE_LINES SELECT * FROM WSH.WSH_CC_SERVICE_SETUPS SELECT * FROM WSH.WSH_CC_TRANS_CONTROL SELECT * FROM WSH.WSH_CC_TRANS_HEADERS SELECT * FROM WSH.WSH_CC_TRANS_LINES SELECT * FROM WSH.WSH_CC_USER_SETUPS SELECT * FROM WSH.WSH_CONSOL_BATCHES SELECT * FROM WSH.WSH_CONSOL_GROUPING_RULES SELECT * FROM WSH.WSH_CONSTRAINT_DLEG_TMP SELECT * FROM WSH.WSH_CONTAINER_ITEMS SELECT * FROM WSH.WSH_CUSTOMIZED_ACTIVITY_MSGS SELECT * FROM WSH.WSH_DD_TXNS -- N:OM>>发运>>事务处理 SELECT * FROM WSH.WSH_DELIVERY_ASSIGNMENTS -- N:OM>>发运>>事务处理 SELECT * FROM WSH.WSH_DELIVERY_DETAILS SELECT * FROM WSH.WSH_DELIVERY_LEGS SELECT * FROM WSH.WSH_DELIVERY_LEG_ACTIVITIES SELECT * FROM WSH.WSH_DELIVERY_LEG_DETAILS SELECT * FROM WSH.WSH_DEL_ASSGN_INTERFACE SELECT * FROM WSH.WSH_DEL_DETAILS_INTERFACE SELECT * FROM WSH.WSH_DEL_LEGS_INTERFACE SELECT * FROM WSH.WSH_DEL_WV_UPGRADE_TMP SELECT * FROM WSH.WSH_DETAIL_SSHIPUNITS SELECT * FROM WSH.WSH_DOCUMENT_INSTANCES --N:OM>>设置>>发运>>文档>>单据类别。 SELECT * FROM WSH.WSH_DOC_SEQUENCE_CATEGORIES --N:OM>>设置>>发运>>文档>>单据类别。 SELECT * FROM apps.wsh_doc_sequence_categories_v -- 发运例外 SELECT * FROM WSH.WSH_EXCEPTIONS SELECT * FROM WSH.WSH_EXCEPTION_DEFINITIONS_B SELECT * FROM WSH.WSH_EXCEPTION_DEFINITIONS_TL SELECT * FROM WSH.WSH_FOLDER_CUSTOM_ACTIONS SELECT * FROM WSH.WSH_FOLDER_EXTENSIONS --N: OM>>设置>>发运>>承运人>>承运人,成本类型>>运费成本类型。 SELECT * FROM WSH.WSH_FREIGHT_COSTS SELECT * FROM WSH.WSH_FREIGHT_COSTS_EFC SELECT * FROM WSH.WSH_FREIGHT_COSTS_INTERFACE --N: OM>>设置>>发运>>承运人>>承运人,成本类型>>运费成本类型。 SELECT * FROM WSH.WSH_FREIGHT_COST_TYPES WFCT WHERE WFCT. NAME LIKE 'OTM Freight Cost' SELECT * FROM APPS.wsh_freight_cost_types_v SELECT * FROM WSH.WSH_FTE_COMP_CLASSES SELECT * FROM WSH.WSH_FTE_COMP_CONSTRAINTS -- N:OM>>设置>>发运>>全局参数 SELECT * FROM WSH.WSH_GLOBAL_PARAMETERS -- N:OM>>设置>>发运>>权限和职责定义>>权限 SELECT * FROM WSH.WSH_GRANTS WG SELECT * FROM APPS.wsh_grants_v WG SELECT * FROM WSH.WSH_GTC_RESPONSE_RULES SELECT * FROM WSH.WSH_INBOUND_DEL_LINES_TEMP SELECT * FROM WSH.WSH_INBOUND_TXN_HISTORY -- 发运接口错误信息表 SELECT * FROM WSH.WSH_INTERFACE_ERRORS SELECT * FROM WSH.WSH_ITM_ADAPTER_STATUS SELECT * FROM WSH.WSH_ITM_DENIED_PARTIES SELECT * FROM WSH.WSH_ITM_ITEMS SELECT * FROM WSH.WSH_ITM_PARAMETER_SETUPS_B SELECT * FROM WSH.WSH_ITM_PARAMETER_SETUPS_TL SELECT * FROM WSH.WSH_ITM_PARTIES SELECT * FROM WSH.WSH_ITM_PARTY_CONTACTS SELECT * FROM WSH.WSH_ITM_REQUEST_CONTROL SELECT * FROM WSH.WSH_ITM_RESPONSE_HEADERS SELECT * FROM WSH.WSH_ITM_RESPONSE_LINES SELECT * FROM WSH.WSH_ITM_RESPONSE_RULES SELECT * FROM WSH.WSH_ITM_SERIAL_NUMBERS SELECT * FROM WSH.WSH_ITM_SERVICE_PARAMETERS SELECT * FROM WSH.WSH_ITM_SERVICE_PREFERENCES SELECT * FROM WSH.WSH_ITM_USER_SETUPS SELECT * FROM WSH.WSH_ITM_VENDORS SELECT * FROM WSH.WSH_ITM_VENDOR_PARAMETERS SELECT * FROM WSH.WSH_ITM_VENDOR_SERVICES SELECT * FROM WSH.WSH_ITM_VENDOR_STYLESHEETS SELECT * FROM WSH.WSH_LOCATIONS SELECT * FROM WSH.WSH_LOCATION_DATA_EXT SELECT * FROM WSH.WSH_LOCATION_OWNERS SELECT * FROM WSH.WSH_LPN_PURGE_TMP SELECT * FROM WSH.WSH_MESSAGE_ATTACHMENT -- N:OM>>发运>>事务处理 -- 挑库发运交货表 SELECT * FROM WSH.WSH_NEW_DELIVERIES WND -- 挑库发运交货接口表 SELECT * FROM WSH.WSH_NEW_DEL_INTERFACE SELECT * FROM WSH.WSH_ORG_CARRIER_SERVICES SELECT * FROM WSH.WSH_ORG_CARRIER_SITES SELECT * FROM WSH.WSH_OTM_LOCATIONS_GTMP SELECT * FROM WSH.WSH_OTM_LOC_CONTACTS_GTMP SELECT * FROM WSH.WSH_OTM_SYNC_REF_DATA SELECT * FROM WSH.WSH_OTM_SYNC_REF_DATA_LOG -- -- N:OM>>发运>>事务处理 SELECT * FROM WSH.WSH_PICKING_BATCHES -- N:OM>>设置>>发运>>挑库>>定义发放规则表单 -- 挑库规则 SELECT * FROM WSH.WSH_PICKING_RULES -- N:OM>>设置>>发运>>挑库>>定义挑库单分组规则 -- 挑库组规则 SELECT * FROM WSH.WSH_PICK_GROUPING_RULES -- N:OM>>设置>>发运>>挑库>>定义发放序列规则 -- 挑库序号规则 SELECT * FROM WSH.WSH_PICK_SEQUENCE_RULES SELECT * FROM WSH.WSH_PR_HEADER_HOLDS SELECT * FROM WSH.WSH_PR_WORKERS WPW WHERE WPW.ORGANIZATION_ID = 101 SELECT * FROM WSH.WSH_QUERY_ASSIGNMENTS -- N:OM>>设置>>发运>>区域和地区>>区域和地区 SELECT * FROM WSH.WSH_REGIONS SELECT * FROM WSH.WSH_REGIONS_GLOBAL SELECT * FROM WSH.WSH_REGIONS_GLOBAL_DATA -- N:OM>>设置>>发运>>区域和地区>>区域接口 SELECT * FROM WSH.WSH_REGIONS_INTERFACE SELECT * FROM WSH.WSH_REGIONS_TL SELECT * FROM WSH.WSH_REGIONS_TL_INTERFACE SELECT * FROM WSH.WSH_REGION_LOCATIONS SELECT * FROM WSH.WSH_REPORT_PRINTERS -- -- N:OM>>设置>>发运>>区域和地区>>中转时间 之 发运方法 SELECT * FROM APPS.MTL_INTERORG_SHIP_METHODS --N: OM>>设置>>发运>>文档>>单据集 -- 单据集 SELECT * FROM WSH.WSH_REPORT_SETS --N: OM>>设置>>发运>>文档>>单据集 -- 单据集 之单据行 SELECT * FROM WSH.WSH_REPORT_SET_LINES -- 发运规则 -- N:OM>>设置>>发运>>权限和职责定义>>定义职责 SELECT * FROM WSH.WSH_ROLES WR where WR. NAME LIKE '一键式发运权限' SELECT * FROM WSH.WSH_ROLE_PRIVILEGES WRP WHERE WRP.ROLE_ID = 24 SELECT * FROM WSH.WSH_SAVED_QUERIES_B SELECT * FROM APPS.wsh_lookups WHERE MEANING LIKE '延交' -- '自动创建交货' SELECT * FROM WSH.WSH_SAVED_QUERIES_TL SELECT * FROM WSH.WSH_SERIAL_NUMBERS SELECT * FROM WSH.WSH_SHIPMENT_BATCHES -- N:OM>>设置>>发运>>发运参数 SELECT * FROM WSH.WSH_SHIPPING_PARAMETERS SELECT * FROM WSH.WSH_SHIPPING_PARAMETER_VALUES -- -- N:OM>>设置>>发运>>全局参数 SELECT * FROM WSH.WSH_GLOBAL_PARAMETERS -- N:OM>>设置>>发运>>发运确认规则 -- 发运确认规则 SELECT * FROM WSH.WSH_SHIP_CONFIRM_RULES SELECT * FROM WSH.WSH_TMP SELECT * FROM WSH.WSH_TMS_BATCHES SELECT * FROM WSH.WSH_TMS_SUB_BATCHES SELECT * FROM WSH.WSH_TRANSACTIONS_HISTORY SELECT * FROM WSH.WSH_TRIPS SELECT * FROM WSH.WSH_TRIPS_INTERFACE SELECT * FROM WSH.WSH_TRIP_STOPS SELECT * FROM WSH.WSH_TRIP_STOPS_INTERFACE SELECT * FROM WSH.WSH_UPGRADE_LOG SELECT * FROM WSH.WSH_UPGRADE_PLD_TMP SELECT * FROM WSH.WSH_UPGRADE_SITE_TMP SELECT * FROM WSH.WSH_UPGRADE_TMP SELECT * FROM WSH.WSH_WMS_SYNC_TMP SELECT * FROM WSH.WSH_ZONE_REGIONS |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了