2023年7月13日发(作者：)

出入库单据表ICStockBill索引名称索引描述包含的字段字段4ICStockBillnonclustereFTranType, FDate字段5字段6字段7字段8字段9顺序号字段名称字段描述字段备注字段类型字段长度字段精度小数位数允许为空1FAcctID科目内码科目IDint42FActPriceVchTplIDint43FActualVchTplIDint44FAutoCreTypetinyint15FBackFlushe倒冲标志倒冲标志bit16FBillerID制单人制单人int47FBillNo入库单号入库单号nvarchar5108FBillTypeID单据类别单据类别int49FBrID制单机构制单机构int410FBrNo公司机构内码公司机构内码varchar1011FCancellati作废0-未作废,1-bit112FCheckDate审核日期审核日期datetime813FCheckerID审核人审核人int414FCheckSelectsmallint215FChildren关联标识关联标识int416FConfirmDatedatetime817FConfirmerint418FConfirmMemnvarchar51019FConfirmStatussmallint220FConsignee收货方收货方nvarchar51021FCurCheckLe当前审核级别当前审核级别int422FCurrencyID币别币别int423FCussentAcctIDint424FDate单据日期单据日期datetime825FDCStockID收入库房收入库房IDint426FDeptID部门部门int427FDrpRelateTranTypeint428FEmpID业务员业务员int429FExplanatio摘要摘要nvarchar51030FFetchAdd交货地点交货地点nvarchar51031FFetchDate交货日期交货日期datetime832FFManagerID验收人验收人int433FHeadSelfA0是否进口是否进口int434FHeadSelfA0riqiriqidatetime835FHeadSelfA0客户客户int436FHeadSelfA0是否进口是否进口int437FHeadSelfA0合同号合同号varchar25538FHeadSelfA0是否进口是否进口int439FHeadSelfA9是否进口是否进口int440FHeadSelfB0船期船期datetime841FHeadSelfB0目的港目的港int442FHeadSelfB0是否进口是否进口int443FHeadSelfB0合同号合同号varchar25544FHeadSelfB0是否进口是否进口int445FHeadSelfB0是否进口是否进口int446FHeadSelfB0是否进口是否进口int447FHeadSelfC0是否进口是否进口int448FHeadSelfC0是否进口是否进口int449FHeadSelfD0客户客户int4Page 0100100是否否否否是否是是否否是是是否是否否否是是是否是是是否是否否是是是是是是是是是是是是是是是是是是是出入库单据表ICStockBill50FHolisticDi整单折扣率整单折扣率decimal1351FHookInterI钩稽单据钩稽单据IDint452FHookStatus钩稽标志钩稽标志smallint253FImport引入标志1－引入int454FInterID单据内码单据ID(关键int455FInventoryT盘点类型盘点类型int456FLSSrcInter源单内码零售源单内码零售int457FManagerID主管主管int458FManageType保税监管类型保税监管类型int459FMarketingS销售业务类型销售业务类型int460FMultiCheck一级审核日期一级审核日期datetime861FMultiCheck二级审核日期二级审核日期datetime862FMultiCheck三级审核日期三级审核日期datetime863FMultiCheck四级审核日期四级审核日期datetime864FMultiCheck五级审核日期五级审核日期datetime865FMultiCheck六级审核日期六级审核日期datetime866FMultiCheck一审一审int467FMultiCheck二审二审int468FMultiCheck三审三审int469FMultiCheck四审四审int470FMultiCheck五审五审int471FMultiCheck六审六审int472FNote备注备注varchar25573FObjectItem工程项目工程项目int474FOperDate时间戳时间戳timestamp875FOrderAffir确认标志确认标志int476FOrgBillInt源单内码原单IDint477FPayBillID应付单内码应付单IDint478FPlanPriceVchTplIDint479FPlanVchTplIDint480FPOMode采购模式采购模式int481FPOOrdBillN对方单据号对方单据号nvarchar51082FPOSNamePOS机名称POS机名称varchar25583FPosted过账0-未过账,1-smallint284FPosterID记账人记账人int485FPOStyle采购方式采购方式int486FPrintCount打印次数打印次数smallint287FProcIDint488FPurposeID领料类型生产领料单=int489FRefType调拨类型调拨类型int490FRelateBrID分支机构内码分支机构内码int491FRelateInvo关联发票号关联发票号int492FResourceIDint493FReturnBill退货单号退货单号int494FROB红蓝字1-蓝字,-1-红smallint295FRSCBillNo已废弃varchar3096FSaleStyle销售方式销售方式int497FSCBillNo已废弃varchar3098FSCStockID发出库房发库库房IDint499FSelTranTyp源单类型源单类型int4100FSettleDate收付款日期收付款日期datetime8101FSManagerID保管人保管人int4102FStatus状态0-未审核,1-smallint2103FSupplyID供应商内码供应商IDint4104FSystemType系统类型系统类型int4Page 228855100否是否是否否否否是否是是是是是是是是是是是是是否是是否否否否是是否否是是否否否否是否是是否是是是是否是是否是是出入库单据表ICStockBill113FTaskID应付单号码应付单号码int4FTranStatus传输状态传输状态int4FTranType单据类型单据类型smallint2FUpStockWhe更新库存0-审核时,1-bit1FUse用途用途varchar255FUUID唯一标识uniqueident16FVchInterID凭证内码凭证IDint4FVIPCardIDVIP卡VIP卡int4FVIPScoreVIP积分VIP积分decimal1310是否是否是否是否否114FWBInterID工序计划单内工序计划单内int115FWorkShiftI班次ID班次IDint116FZanGuCount暂估数量暂估数量bit117FZPBillInte赠品单据内码赠品单据内码int41041011410Page 30否0否0否0是