表格模板-采购管理系统数据表 精品.xls

《表格模板-采购管理系统数据表 精品.xls》由会员分享，可在线阅读，更多相关《表格模板-采购管理系统数据表 精品.xls（42页珍藏版）》请在第一文库网上搜索。

1、返回总览采购管理系统数据表序序号号表表名名表表描描述述1 ICPurchase购货发票表2 ICPurchaseEntry购货发票分录表3 POInStock收料通知表4 POInStockEntry收料通知单分录表5 POOrder采购订单表6 POOrderEntry采购订单分录表7 PORequest采购申请表8 PORequestEntry采购申请单分录表9 t_Supply供应商供货表10 t_SupplyEntry供应商供货明细表11 ICBatchNoRule物料批号管理12 ICItemMapping物料对应表13 vwICBill_25采购申请单（视图）14 vwICBill

2、_26采购订单（视图）15 vwICBill_27收料通知单（视图）16 vwICBill_28退料通知单（视图）17 vwICBill_42购货发票（视图）18 vwICBill_21费用发票（视图）19 ICExpensesEntry费用发票分录表20 ICExpenses费用发票表21 vwICBill_81检验单(视图)返回采购管理系统目录表结构字字段段名名类类型型描描述述FCheckStatusINTEGER核销状态FAccountSTRING银行账号FAcctIDINTEGER贷方科目FCurCheckLevelINTEGER当前审核级别FAddressSTRING地址FAdjus

3、tAmountFLOAT累计调汇金额FDateDATETIME单据日期FAdjustExchangeRateFLOAT调整汇率FDeptIDINTEGER部门FEmpIDINTEGER业务员FExchangeRateFLOAT汇率FArApStatusINTEGER状态FFincDateDATETIME财务日期FFreeItem1STRING应收应付发票自由项FFreeItem2STRING应收应付发票自由项FFreeItem3STRING应收应付发票自由项FFreeItem4STRING应收应付发票自由项FHookerIDINTEGER钩稽人FHookInterIDINTEGER钩稽单据内码

4、FBillerIDINTEGER制单人FInterIDINTEGER购货发票内码FInvStyleINTEGER业务类型fitemclassidINTEGER核算项目内码FBillerNameSTRING开票人FBillNoSTRING购货发票号FBrIDINTEGER制单机构FCussentAcctIDINTEGERFCurrencyIDINTEGER币别FMultiCheckDate5DATETIME五级审核日期FMultiCheckDate6DATETIME六级审核日期FMultiCheckLevel1INTEGER一审FMultiCheckLevel2INTEGER二审FMultiCh

5、eckLevel3INTEGER三审FMultiCheckLevel4INTEGER四审FMultiCheckLevel5INTEGER五审FMultiCheckLevel6INTEGER六审FNoteSTRING备注FOffsetTaxFLOAT抵扣费用FOffsetTaxForFLOAT抵扣费用(原币)FOrderAmountForFLOAT订单金额FOrderIDINTEGER订单IDFOrgBillInterIDINTEGER源单内码FOuterIDINTEGER外部单据内码FPayStyleINTEGER付款方式FPeriodINTEGER日期FPlanPriceVchTplIDIN

6、TEGERFPlanVchTplIDINTEGERFPostedINTEGER是否过账FPosterIDINTEGER记账人FPOStyleINTEGER采购方式FRemainAmountFLOATFRemainAmountForFLOATFResourceIDINTEGER资源内部IDFROBINTEGER红蓝字FRSCBillNoSTRING原费用发票号FSelTranTypeINTEGER源单类型FStatusINTEGER状态FSubSystemIDINTEGER子系统内码FSupplyIDINTEGER供应商内码FTaskIDINTEGER任务IDFTaxNumSTRING税务登记号

7、FTotalCostFLOAT总成本额（本位币）FTotalCostForFLOAT总成本额原币FTotalExpenseFLOAT采购费用FTotalExpenseForFLOAT采购费用(原币)FTranStatusINTEGER传输标志FTranTypeINTEGER单据类型FVchInterIDINTEGER凭证内码FVoucherIDINTEGER凭证内码FYearINTEGER年份FYearPeriodSTRING钩稽期间FYtdIntRateFLOAT年利率(%)FActPriceVchTplIDINTEGERFActualVchTplIDINTEGERFMultiCheckDa

8、te1DATETIME一级审核日期FDCINTEGERFExplanationSTRING摘要FHookStatusINTEGER钩稽标志FBankSTRING开户银行FManagerIDINTEGER主管FMultiCheckDate2DATETIME二级审核日期FMultiCheckDate3DATETIME三级审核日期FMultiCheckDate4DATETIME四级审核日期FBrNoSTRING公司机构内码FBudgetAmountForFLOAT预算金额FCancellationINTEGER作废FCheckAmountFLOATFCheckAmountForFLOATFCheck

9、DateDATETIME审核日期FCheckerIDINTEGER审核人FConnectFlagINTEGER关联标志FChildrenINTEGER关联标识FClassTypeIDINTEGER新单据类型IDFClosedINTEGER是否关闭FCOMINVIDINTEGER商业发票内码FCompactNoSTRING合同号键表键键名名类类型型PK_ICPurchase主键索引表索索引引名名字字段段PK_ICPurchaseFBrNoIX_ICPurchase_FBillNoFInterIDIX_ICPurchase_FDateFBillNoIX_ICPurchase_FHookInterI

10、DFTranTypeIX_ICPurchase_FInterIDFDateIX_ICPurchase_FVchInterIDFVoucherID触发器表触触发发器器名名描描述述返回采购管理系统目录表结构字字段段名名类类型型FAllAmountFLOATFAllHookAmountFLOATFAllHookQTYFLOATFCheckQtyFLOATFAddCostFLOATFAddCostForFLOATFContractInterIDINTEGERFCurrentHookAmountFLOATFCurrentHookQTYFLOATFDeductTaxFLOATFDetailIDINTEGE

11、RFDiscountRateFLOATFCOMINVIDINTEGERFEntryID_SRCINTEGERFFreeItem1STRINGFFreeItem2STRINGFCommitQtyFLOATFAmountFLOATFAmountExFLOATFAmountincludetaxFLOATFAuxCommitQtyFLOATFAuxOrderPriceFLOATFNoMustFLOATFNoteSTRINGFAuxPriceFLOATFAuxQtyFLOATFOrderInterIDINTEGERFOrderPriceFLOATFOrgBillEntryIDINTEGERfauxqty

12、_baseFLOATFAuxTaxPriceFLOATFPayApplyQuantityFLOATFPriceFLOATFBatchNoSTRINGFCheckAmountFLOATFCheckAmountForFLOATFClassID_SRCINTEGERFRemainAmountFLOATFRemainAmountForFLOATFRemainQtyFLOATFEntryIDINTEGERFFreeItem4STRINGFsecCoefficientFLOATFSecCommitQtyFLOATFSecQtyFLOATFSecUnitIDINTEGERFSourceBillNoSTRIN

13、GFSourceEntryIDINTEGERFSourceInterIdINTEGERFSourceTranTypeINTEGERFSplitSecQtyFLOATFStdAllHookAmountFLOATFStdAmountFLOATFStdAmountincludetaxFLOATFStdAmtDiscountFLOATFStdCurrentHookAmountFLOATFStdTaxAmountFLOATFTaxFLOATFTaxAmountFLOATFTaxPriceFLOATFTaxRateFLOATFUnitIDINTEGERFFreeItem3STRINGFInterIDINT

14、EGERFContractBillNoSTRINGFItemIDINTEGERFAmount_CommitFLOATFMapNameSTRINGFAmountFor_CommitFLOATFMapNumberSTRINGFAmountMustFLOATFAmtDiscountFLOATFOrderBillNoSTRINGFOrderEntryIDINTEGERFPayApplyAmountForFLOATFAuxPriceDiscountFLOATFAuxPropIDINTEGERFPayApplyAmountFLOATFPriceDiscountFLOATFQtyFLOATFQuantity

15、PayApply_CommitFLOATFBrNoSTRINGFQuantityReceive_CommitFLOATFSaleSecCommitQtyFLOATFContractEntryIDINTEGERFSaleCommitQtyFLOAT键表键键名名类类型型PK_icpurchaseEntry主键索引表索索引引名名字字段段PK_icpurchaseEntryFBrNoidx_ICPurchaseEntry_FContractInterIDFInterIDidx_ICPurchaseEntry_FOrderInterIDFEntryIDidx_ICPurchaseEntry_FSourc

16、eTranTypeNFSourceInterIdFDetailIDIX_ICPurchaseEntry_FContractEntryIDFItemIDIX_ICPurchaseEntry_FDetailIDFQtyIX_ICPurchaseEntry_FInterIDFPriceIX_ICPurchaseEntry_FItemIDFAmountIX_ICPurchaseEntry_FSourceInterIdFTaxRate触发器表触触发发器器名名描描述述描描述述价税合计已钩稽金额已钩稽数量附加费本币附加费原币合同内码本期钩稽金额本期钩稽数量运费税金分录内码折扣率商业发票内码关联源单分录ID应收应付发票自由项应收应付发票自由项提交数量金额金额辅助提交数量辅助订单单价不计成本费用(本位币)备注辅助单价辅助数量订单内码订单单价拆单源单行号辅助基本数量含税价二单价批次关联源单类型分录号应收应付发票自由项换算率辅助执行数量辅助数量辅助单位源单号原分录号源单内码源单类型拆分辅助数量已钩稽金额(本位币)金额（本位币）金额（本位币）折扣额(本位币)本期钩稽金额(本位币)税额（本位币）税额含税价税率单