NTOS统计某个航线下某条船历史箱量信息

COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_NO IS '集装箱号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.VESSEL_IE IS '航向I/E';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_OPERATOR_CODE IS '箱主';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_TYPE IS '箱类型（在COD_SIZE_TYPE 维护）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_SIZE IS '箱尺寸（在COD_SIZE_TYPE 维护）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_STATUS IS '箱状态(F:重箱，E:空箱)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_CATEGORY IS '箱类别(R:倒箱；E:出口箱；I:进口箱；M：倒箱)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TARE_WEIGHT IS '箱皮重（取自COD_SIZE_TYPE 表的皮重）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_WEIGHT IS '箱总重（出口箱：闸口TQ时写入，TARE_WEIGHT+提单表的货重，）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_HEIGHT IS '集装箱高度（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_NO1 IS '铅封号1';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_NO2 IS '铅封号2（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_NO3 IS '（无用）铅封号3';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DOOR_DIRECTION IS '集装箱门方向(F/B)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FORWARDER_CODE IS '货代(货方费用收取对象)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OD_FLAG IS '超限标记(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.HAZARD_FLAG IS '危险品标记(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.REEFER_FLAG IS '温控箱标记(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DAMAGE_FLAG IS '残损箱标记(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CARGO_CODE IS '货物代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRANSFER_PORT_CODE IS '中转港代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.GROUP_ID IS '组号 FPX--废品箱处理; JTT--集团集卡提箱;ZMT--转码头; HT--海铁 CFS;GKX--管空; CFC--海关（商检）查验箱; LD--直装 ; 后面的没在用 CFW：卫生处理箱；CFR：CFS进箱：包括从检查桥进箱、大场地移入；CFD：做好CFS场地空/重箱归位申请时，自动改变集装箱Group为CFD；';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SPARCS_HOLDS IS 'TOS系统扣留标记(D/T/P/N)（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DESTINATION_PORT_CODE IS '目的港代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OPT_DIS_PORT_CODE IS '第一选港代码（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.LOAD_PORT_CODE IS '装货港代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.REMARKS IS '说明';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRADE_NW IS 'N：内贸；W：外贸';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ACTUAL_POSITION_QUALIFER IS '位置类型(C/T/Y/V)，实例集装箱进场：C->T->Y';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ACTUAL_LOCATION IS '存放集装箱的堆场名称(码头或堆场名称)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ACTUAL_POSITION_BLOCK IS '实际堆场名称(1A堆场)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ACTUAL_SLOT_POSITION IS '场箱位Bay-Row_Tier';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_WEIGHT_UP IS '检查口称重';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.HISTORY_FLAG IS '可转移到历史库标记(Y)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RELEASE_FLAG IS '出口码头放行(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RELEASE_METHOD IS '放行方式(D：双信息放行，E：EDI放行；H：人工放行)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_WEIGHT_CRANE IS '（无用）吊机称重';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RELEASE_USERID IS '放行用户ID/取消放行用户ID（根据放行标记判断）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRUCK_NO_IN IS '进场集卡编号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RELEASE_TIME IS '放行时间/取消放行时间（根据放行标记判断）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRUCK_NO_OUT IS '出场集卡编号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTER_DIRECTION IS '验封结果（A表示已经验封，I表示未验封）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.POSITION_ON_TRUCK IS '集卡上位置(1:车头小箱 2:车尾小箱 4:大箱)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_NO1 IS '子箱号1';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_NO2 IS '无用';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.PLAN_POSITION_BLOCK IS '计划场箱位区域(Location_Type=Y)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_NO3 IS '无用';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SPECIAL_STOW_CODE IS '箱分组标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CARRIER IS '进口船舶参考号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SG_FLAG IS 'Y--SG疏港箱（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.STOW_REQUIREMENT_FLAG IS 'Sparcs系统装载要求(无用)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FIRST_INQUAY_USERID IS '首次进码头操作用户ID(卡口用户或者桥旁边理货)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_NO4 IS '子箱号4（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FIRST_QUARY_POSITION IS '首次进码头操作位置';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FP_FLAG IS 'Y--FP废品箱 R--可再生金属';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RETURN_TRANSHIP_FLAG IS 'R--退运箱；T-中转(转码头进场)；O-出场转码头进场；C-转关箱出场；L-溢卸箱；E-进口改出口；Y-转场标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_RELEASE IS '进口码头放行(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.PLAN_POSITION_QUALIFER IS '计划位置类型(C/T/Y/V)，实例集装箱进场：C->T->Y';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.EXIT_CUSTOM IS '退关标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CARRIER IS '出口船舶参考号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.PLAN_LOCATION IS '计划位置所属堆场';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.LAST_OUTQUAY_USERID IS '最后出码头的操作用户(卡口或者桥边理货)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.PLAN_SLOT_POSITION IS '计划位置SLOT';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.LAST_OUTQUAY_POSITION IS '最后出码头的操作位置(卡口或者桥边理货)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DISCHARGE_PORT_CODE IS '卸货港代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CATEGORY IS '进港类别：VV / TV / VY / TY';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CATEGORY IS '出港类别： VV / VT / YV / YT';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FIRST_INQUAY_TIME IS '首次进港时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FIRST_INYARD_TIME IS '首次进场时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INGATE_RECEIVE_TIME IS '进箱集卡出门时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INGATE_DELIVERY_TIME IS '提箱TQ时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRANSFER_FLAG IS '(无用，合并到RETURN_TRANSHIP_FLAG)中转标记：T--国内中转；Z--国际中转；E--退运';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.LAST_OUTYARD_TIME IS '最后出场时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.LAST_OUTQUAY_TIME IS '最后出港口时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTOS_HOLD1 IS '（无用）CTOS扣留标记1(海关没有放行，自动Hold)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTOS_HOLD2 IS '（无用）CTOS扣留标记2(在CFS堆场自动Hold，当集装箱进入CFS堆场时，被自动Hold，出CFS堆场自动释放。)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTOS_HOLD3 IS '（无用）CTOS扣留标记3(海关查验自动Hold，得到海关查验指令后，自动加Hold。)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RELEASE_LOCATION IS '当做单箱billowner火车用(放行地点无用)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CUSTOM_RELEASE_FLAG IS '海关EDI放行(Y/N)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTOS_HOLD4 IS '（无用）CTOS扣留标记4(国检查验自动Hold，得到国检查验指令后，自动加Hold。)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTOS_HOLD5 IS '（无用）CTOS扣留标记5(人工Hold，人工Hold，人工释放。)T、D、Y:人工扣留';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.EQUIPMENT_RECEIPT_NO IS '（无用）设备交接单号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CFS_FLAG IS '（无用）Y：纯CFS标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRADEFREE_FLAG IS '（无用）Y：保税区货物；N：非保税区货物(Not Used)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CHANGE_CTN_DIRECTION IS '调箱门标志';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.PROCESS_STATUS IS '检查桥处理状态。A：Apply直装预约；T：TQ向Sparcs请求位置(T：发送TQ/00：接收到Sparcs返回成功/01-06：Sparcs返回失败)；I：TIP(Pass检查桥放行)；B：Buffer缓冲区等待；C：Cancel；D：落地；O：出检查口。';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RF_TO_GP IS '（无用）Y:温控箱作为干货箱使用(GP)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.BILLING_STATUS IS '（无用）费收状态';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.BOOKING_NUMBER IS '（无用）定舱单号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_MATERIAL IS '（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DIRECT_FLAG IS '直装标记：Y/N';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.STUFFING_NO IS '（无用）装箱单号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RECEIVE_BOOKING_NO IS '进箱预约号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RECEIVE_BOK_METHOD IS '（无用）进箱预约方式';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DELIVERY_BOOKING_NO IS '提箱预约号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DELIVERY_BOK_METHOD IS '（无用）提箱预约方式';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RECEIVE_DELIVERY_FLAG IS 'D/R进提箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ACTUAL_INBOUND_POSITION IS '实际进口船箱位';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ACTUAL_OUTBOUND_POSITION IS '实际出口船箱位';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.BOOKING_NO IS '预约号:直装进箱预约发送；成组提重箱发送Booking_NO；单个提空箱发送Booking_NO(特殊注意取消操作)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INSPECTION_ID IS '查验标记(TOIN or FRIN)(KXCY:空箱查验；KXTZ:空箱退租)CFSY:纯CFS进箱';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INSPECTION_FLAG IS '查验状态(Y:已经检查完成)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ASSIGN_EMPTY_VESSEL IS '（无用）Y：Sparcs空箱船名/航次指定';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FROM_SOURCE IS 'FROM_S:来自拆箱标记；TO_S:被拆箱标记；FROM_L:来自装箱标记；To_L:被装箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CFS_YARD IS '去的港外CFS场';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.JOB_TYPE IS '（无用）BX:驳箱';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DELIVERY_INUSERID IS '提箱进检查桥用户ID';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SENDER_ID IS '送单人ID（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.REEFER_KX IS '（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ISONETRUCKTWOCTNS IS '一车两箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FROM_TERMINAL IS '当tt_flag=Y时，表示来源地码头代码（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TO_TERMINAL IS '当tt_flag=Y时，表示目的地码头代码（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TT_FLAG IS '转码头箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.COSTCO_NO IS '电子装箱单编号(存储易港通计划号)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_CUST IS '海关铅封（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_CIQ IS '（无用）国检铅封';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SHWL_FLAG IS '（无用）四海物流提箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SHWL_SEND_FLAG IS '（无用）四海物流装箱单发送标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ID IS '主键';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FB_FLAG IS '特殊箱标记(F：分拨箱，S：属地箱) ';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INSERT_TIME IS '数据插入时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.UPDATE_TIME IS '数据修改时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUT_CTN_WEIGHT_UP IS '出卡口地磅称重';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.LOAD_FLAG IS '准装标记默认H， R：允许装船';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SIGN_TRANSFER IS '内转外标记(进口取船图报文，出口取装箱单报文)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.BARGE_FLAG IS '甬舟专用，驳支标志（BI）进口转驳支，（BE）驳支转出口，（BO）水路退关';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTQUAY_TIME IS '甬舟专用，对面码头出场时间（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INQUAY_TIME IS 'TIP时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OW_TYPE IS '超重类型1,2,3';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OD_TYPE IS '超限类型1,2,3';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RESTORE_TAG IS '倒箱原因A 船方,C货方,M码头原因';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RESTORE_CAT IS '倒箱类型 P计划内, T临时';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.IRON_FLAG IS '海铁箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_OPERATOR IS '箱经营人(Y:沿海捎带箱)';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.VGM_WEIGHT IS 'VGM箱总重';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRADE_X IS '虚拟进出门标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.YD_FLAG IS '（无用）液袋箱标记（Y：是；N：不是）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TQ_TIME IS 'TQ时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INSERT_USER IS '数据插入用户';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.UPDATE_USER IS '数据修改用户';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ORG_ID IS '组织ID';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CARRIER_NAMEC IS '进口船中文名';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CARRIER_NAMEE IS '进口船英文名';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CARRIER_UNCODE IS '进口船UnCode';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CARRIER_NAMEC IS '进口船中文名';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CARRIER_NAMEE IS '出口船英文名';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CARRIER_UNCODE IS '出口船UnCode';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CARRIER_INVOYAGE IS '进口船进口航次';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.INBOUND_CARRIER_VESSELCODE IS '进口船舶代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CARRIER_VESSELCODE IS '出口船代码';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OUTBOUND_CARRIER_OUTVOYAGE IS '出口航次';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTOS_HOLD IS '扣留标记，只要CTN_HOLD表中有数据就为Y';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CARGO_FLAG IS '货物标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.VERSION IS '版本号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.VGM_METHOD IS 'VGM称重方法';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.VGM_SIGNATURE IS 'VGM申报人签名';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_NO_SUFFIX IS '箱号的数字后缀（用于查询）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.POSITION_CHANGE IS '位置变化';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.MSDS_URL IS '危险品MSDS，多个逗号隔开';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.ZB_FLAG IS '浙北箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_RESULT IS '施封结果';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SEAL_TIME IS '施封时间';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.WB_FLAG IS '危险品箱危标审核标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.JDX_FLAG IS '危险品箱接地线审核标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FHZ_FLAG IS '危险品箱防火罩审核标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CARGO_URL IS '货物说明书URL地址';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.DRIVER_CERT IS '司机证件（URL）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SUPER_CERT IS '押运员证件（URL）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.TRUCK_CERT IS '车辆证件（URL）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.RAILWAY_FLAG IS '铁路箱标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.OTHER_FLAG IS '万能标记：KZ代表捆扎箱。HT代表海铁 KN:困难箱';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FLAG IS '状态位（无用）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.REL_ACT_ID IS '虚拟进出门ID';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.MESSAGEID IS '报文编号';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FILLER1 IS '预留字段';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FILLER2 IS '预留字段（北一用于进箱预约时间）';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FILLER3 IS '预留字段';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FILLER4 IS '预留字段';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.FILLER5 IS '预留字段';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.CTN_RANGE_GROUP IS '箱分组标记';
COMMENT ON COLUMN HOSTDB.ACT_INVENTORY.SPECIAL_STOW IS '箱分组标记';

请求参数

Body 参数application/json

示例

{"serviceName":"containerService","methodName":"searchServiceLineVoyage","rpcParams":["B1","HHX","E",[{"condition":"andEq","column":"ctn_operator_code","v1":"CMA"},
{"condition":"andEq","column":"trade_nw","v1":"W"},
{"condition":"andEq","column":"ctn_size","v1":"22"},
{"condition":"andEq","column":"ctn_type","v1":"GP"}]],"uuid":"c982a668-ba02-4324-85dd-e246612b5b1e","to":"60000"}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

application/json

Body

示例

成功示例异常示例

{
    "checkValue": "",
    "logError": true,
    "responseData": {
        "resultData": 10,
        "statusCode": 0
    },
    "tailInfos": {},
    "uuid": "c982a668-ba02-4324-85dd-e246612b5b1e"
}

NTOS统计某个航线下某条船历史箱量信息

请求参数

请求示例代码

返回响应