动软自动生成器数据库名:ILS表名:SHIPMENT_HEADER(订单出库总表)序号列名数据类型长度小数位标识主键允许空默认值说明1INTERNAL_SHIPMENT_NUMnumeric50是是否内部行号2warehousenvarchar250否仓库3SHIPPING_LOAD_NUMnumeric50是装载号4SHIPMENT_IDnvarchar250否订单号5LAUNCH_STEPnvarchar250是NULL6TRAILING_STSnumeric50否拖状态7TRAILING_STS_DATEdatetime83是拖动状态时间8TRAILING_STS_FAILEDnchar10否(拖)是否失败9ORDER_TYPEnvarchar250是订单类型(COD)10CONSOLIDATEDnchar10否11LEADING_STSnumeric50否主状态12LEADING_STS_DATEdatetime83是主状态时间13CARRIERnvarchar250是承运人14LEADING_STS_FAILEDnchar10否(主)是否失败15COMPANYnvarchar250是项目/货主16CARRIER_SERVICEnvarchar500是承运人服务17CARRIER_GROUPnvarchar250是承运人组18CARRIER_TYPEnvarchar250是承运人类型(TL)19FREIGHT_TERMSnvarchar250是运费条款20LIABILITY_TERMSnvarchar250是责任条款21CUSTOMERnvarchar250是客户22SHIP_TOnvarchar250是收件人23ROUTEnvarchar250是路线24STOPnvarchar250是停止25SHIP_TO_ADDRESS1nvarchar500是收件地址126CUSTOMER_NAMEnvarchar500是客户名称27SHIP_TO_ADDRESS2nvarchar500是收件地址228SHIP_TO_ADDRESS3nvarchar500是收件地址329SHIP_TO_CITYnvarchar300是收件城市30SHIP_TO_STATEnvarchar250是收件省份31SHIP_TO_COUNTRYnvarchar250是收件国家32SHIP_TO_POSTAL_CODEnvarchar250是邮编动软自动生成器