采购管理系统数据表

返回总览采购管理系统数据表序号表名表描述1ICPurchase购货发票表2ICPurchaseEntry购货发票分录表3POInStock收料通知表4POInStockEntry收料通知单分录表5POOrder采购订单表6POOrderEntry采购订单分录表7PORequest采购申请表8PORequestEntry采购申请单分录表9t_Supply供应商供货表10t_SupplyEntry供应商供货明细表11ICBatchNoRule物料批号管理12ICItemMapping物料对应表13vwICBill_25采购申请单（视图）14vwICBill_26采购订单（视图）15vwICBill_27收料通知单（视图）16vwICBill_28退料通知单（视图）17vwICBill_42购货发票（视图）18vwICBill_21费用发票（视图）19ICExpensesEntry费用发票分录表20ICExpenses费用发票表21vwICBill_81检验单(视图)返回采购管理系统目录表结构字段名类型描述FCheckStatusINTEGER核销状态FAccountSTRING银行账号FAcctIDINTEGER贷方科目FCurCheckLevelINTEGER当前审核级别FAddressSTRING地址FAdjustAmountFLOAT累计调汇金额FDateDATETIME单据日期FAdjustExchangeRateFLOAT调整汇率FDeptIDINTEGER部门FEmpIDINTEGER业务员FExchangeRateFLOAT汇率FArApStatusINTEGER状态FFincDateDATETIME财务日期FFreeItem1STRING应收应付发票自由项FFreeItem2STRING应收应付发票自由项FFreeItem3STRING应收应付发票自由项FFreeItem4STRING应收应付发票自由项FHookerIDINTEGER钩稽人FHookInterIDINTEGER钩稽单据内码FBillerIDINTEGER制单人FInterIDINTEGER购货发票内码FInvStyleINTEGER业务类型fitemclassidINTEGER核算项目内码FBillerNameSTRING开票人FBillNoSTRING购货发票号FBrIDINTEGER制单机构FCussentAcctIDINTEGERFCurrencyIDINTEGER币别FMultiCheckDate5DATETIME五级审核日期FMultiCheckDate6DATETIME六级审核日期FMultiCheckLevel1INTEGER一审FMultiCheckLevel2INTEGER二审FMultiCheckLevel3INTEGER三审FMultiCheckLevel4INTEGER四审FMultiCheckLevel5INTEGER五审FMultiCheckLevel6INTEGER六审FNoteSTRING备注FOffsetTaxFLOAT抵扣费用FOffsetTaxForFLOAT抵扣费用(原币)FOrderAmountForFLOAT订单金额FOrderIDINTEGER订单IDFOrgBillInterIDINTEGER源单内码FOuterIDINTEGER外部单据内码FPayStyleINTEGER付款方式FPeriodINTEGER日期FPlanPriceVchTplIDINTEGERFPlanVchTplIDINTEGERFPostedINTEGER是否过账FPosterIDINTEGER记账人FPOStyleINTEGER采购方式FRemainAmountFLOATFRemainAmountForFLOATFResourceIDINTEGER资源内部IDFROBINTEGER红蓝字FRSCBillNoSTRING原费用发票号FSelTranTypeINTEGER源单类型FStatusINTEGER状态FSubSystemIDINTEGER子系统内码FSupplyIDINTEGER供应商内码FTaskIDINTEGER任务IDFTaxNumSTRING税务登记号FTotalCostFLOAT总成本额（本位币）FTotalCostForFLOAT总成本额原币FTotalExpenseFLOAT采购费用FTotalExpenseForFLOAT采购费用(原币)FTranStatusINTEGER传输标志FTranTypeINTEGER单据类型FVchInterIDINTEGER凭证内码FVoucherIDINTEGER凭证内码FYearINTEGER年份FYearPeriodSTRING钩稽期间FYtdIntRateFLOAT年利率(%)FActPriceVchTplIDINTEGERFActualVchTplIDINTEGERFMultiCheckDate1DATETIME一级审核日期FDCINTEGERFExplanationSTRING摘要FHookStatusINTEGER钩稽标志FBankSTRING开户银行FManagerIDINTEGER主管FMultiCheckDate2DATETIME二级审核日期FMultiCheckDate3DATETIME三级审核日期FMultiCheckDate4DATETIME四级审核日期FBrNoSTRING公司机构内码FBudgetAmountForFLOAT预算金额FCancellationINTEGER作废FCheckAmountFLOATFCheckAmountForFLOATFCheckDateDATETIME审核日期FCheckerIDINTEGER审核人FConnectFlagINTEGER关联标志FChildrenINTEGER关联标识FClassTypeIDINTEGER新单据类型IDFClosedINTEGER是否关闭FCOMINVIDINTEGER商业发票内码FCompactNoSTRING合同号键表键名类型PK_ICPurchase主键索引表索引名字段PK_ICPurchaseFBrNoIX_ICPurchase_FBillNoFInterIDIX_ICPurchase_FDateFBillNoIX_ICPurchase_FHookInterIDFTranTypeIX_ICPurchase_FInterIDFDateIX_ICPurchase_FVchInterIDFVoucherID触发器表触发器名描述返回采购管理系统目录表结构字段名类型FAllAmountFLOATFAllHookAmountFLOATFAllHookQTYFLOATFCheckQtyFLOATFAddCostFLOATFAddCostForFLOATFContractInterIDINTEGERFCurrentHookAmountFLOATFCurrentHookQTYFLOATFDeductTaxFLOATFDetailIDINTEGERFDiscountRateFLOATFCOMINVIDINTEGERFEntryID_SRCINTEGERFFreeItem1STRINGFFreeItem2STRINGFCommitQtyFLOATFAmountFLOATFAmountExFLOATFAmountincludetaxFLOATFAuxCommitQtyFLOATFAuxOrderPriceFLOATFNoMustFLOATFNoteSTRINGFAuxPriceFLOATFAuxQtyFLOATFOrderInterIDINTEGERFOrderPriceFLOATFOrgBillEntryIDINTEGERfauxqty_baseFLOATFAuxTaxPriceFLOATFPayApplyQuantityFLOATFPriceFLOATFBatchNoSTRINGFCheckAmountFLOATFCheckAmountForFLOATFClassID_SRCINTEGERFRemainAmountFLOATFRemainAmountForFLOATFRemainQtyFLOATFEntryIDINTEGERFFreeItem4STRINGFsecCoefficientFLOATFSecCommitQtyFLOATFSecQtyFLOATFSecUnitIDINTEGERFSourceBillNoSTRINGFSourceEntryIDINTEGERFSourceInterIdINTEGERFSourceTranTypeINTEGERFSplitSecQtyFLOATFStdAllHookAmountFLOATFStdAmountFLOATFStdAmountincludetaxFLOATFStdAmtDiscountFLOATFStdCurrentHookAmountFLOATFStdTaxAmountFLOATFTaxFLOATFTaxAmountFLOATFTaxPriceFLOATFTaxRateFLOATFUnitIDINTEGERFFreeItem3STRINGFInterIDINTEGERFContractBillNoSTRINGFItemIDINTEGERFAmount_CommitFLOATFMapNameSTRINGFAmountFor_CommitFLOATFMapNumberSTRINGFAmountMustFLOATFAmtDiscountFLOATFOrderBillNoSTRINGFOrderEntryIDINTEGERFPayApplyAmountForFLOATFAuxPriceDiscountFLOATFAuxPropIDINTEGERFPayApplyAmountFLOATFPriceDiscountFLOATFQtyFLOATFQuantityPayApply_CommitFLOATFBrNoSTRINGFQuantityReceive_CommitFLOATFSaleSecCommitQtyFLOATFContractEntryIDINTEGERFSaleCommitQtyFLOAT键表键名类型PK_icpurchaseEntry主键索引表索引名字段PK_icpurchaseEntryFBrNoidx_ICPurchaseEntry_FContractInterIDFInterIDidx_ICPurchaseEntry_FOrderInterIDFEntryIDidx_ICPurchaseEntry_FSourceTranTypeNFSourceInterIdFDetailIDIX_ICPurchaseEntry_FContractEntryIDFItemIDIX_ICPurchaseEntry_FDetailIDFQtyIX_ICPurchaseEntry_FInterIDFPriceIX_ICPurchaseEntry_FItemIDFAmountIX_ICPurchaseEntry_FSourceInterIdFTaxRate触发器表触发器名描述描述价税合计已钩稽金额已钩稽数量附加费本币附加费原币合同内码本期钩稽金额本期钩稽数量运费税金分录内码折扣率商业发票内码关联源单分录ID应收应付发票自由项应收应付发票自由项提交数量金额金额辅助提交数量辅助订单单价不计成本费用(本位币)备注辅助单价辅助数量订单内码订单单价拆单源单行号辅助基本数量含税价二单价批次关联源单类型分录号应收应付发票自由项换算率辅助执行数量辅助数量辅助单位源单号原分录号源单内码源单类型拆分辅助数量已钩稽金额(本位币)金额（本位币）金额（本位币）折扣额(本位币)本期钩稽金额(本位币)税额（本位币）税额含税价税率单位内码应收应付发票自由项购货发票内码合同号物料内码收款关联金额(本币)对应名称收款关联金额(原币)对应代码应计费用折扣额订单号订单分录付款申请关