KIS專(zhuān)業(yè)版數(shù)據(jù)庫(kù)及字段描述_第1頁(yè)
KIS專(zhuān)業(yè)版數(shù)據(jù)庫(kù)及字段描述_第2頁(yè)
KIS專(zhuān)業(yè)版數(shù)據(jù)庫(kù)及字段描述_第3頁(yè)
KIS專(zhuān)業(yè)版數(shù)據(jù)庫(kù)及字段描述_第4頁(yè)
KIS專(zhuān)業(yè)版數(shù)據(jù)庫(kù)及字段描述_第5頁(yè)
已閱讀5頁(yè),還剩1514頁(yè)未讀, 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說(shuō)明:本文檔由用戶(hù)提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

FtableID,FFieldName,FfieldType,Fdescription,FfieldNote,Ftype,Fsefdefsign,Fdescription_Cht,Fdescription_En,FfieldNote_Cht,FfieldNote_En

1,FDetailID,INTEGER,核算項(xiàng)目,核算項(xiàng)目使用ID,0為不下設(shè)核算項(xiàng)目,0,0,核算項(xiàng)目,Anls.Item,核算項(xiàng)目使用ID,0為不下設(shè)核算項(xiàng)目,"Anls.ItemUseID,0:w/t.CalculationSubitems"

1,FTransNo,STRING,業(yè)務(wù)號(hào),業(yè)務(wù)號(hào),0,0,業(yè)務(wù)號(hào),BusinessNo.,業(yè)務(wù)號(hào),BusinessNo.

1,FSettleNo,STRING,結(jié)算號(hào),結(jié)算號(hào),0,0,結(jié)算號(hào),SettleNo.,結(jié)算號(hào),SettleNo.

1,FMeasureUnitID,INTEGER,單位內(nèi)碼,計(jì)量單位ID,0,0,單位內(nèi)碼,UnitISN,計(jì)量單位ID,UoMID

1,FResourceID,INTEGER,項(xiàng)目資源內(nèi)碼,項(xiàng)目資源ID,0,0,項(xiàng)目資源內(nèi)碼,ItemResourceISN,項(xiàng)目資源ID,ItemResourceID

6,FpreAcctID,INTEGER,預(yù)付賬款科目代碼,預(yù)付賬款科目代碼,0,0,預(yù)付賬款科目代碼,PrepaymentAccountCode,預(yù)付賬款科目代碼,PrepaymentAccountCode

56,FInterID,INTEGER,,,1,0,,,,

56,FtranType,INTEGER,,,1,0,,,,

56,FICMOInterID,INTEGER,生產(chǎn)任務(wù)單內(nèi)碼:,生產(chǎn)任務(wù)單內(nèi)碼:,0,0,生產(chǎn)任務(wù)單內(nèi)碼:,MOISN:,生產(chǎn)任務(wù)單內(nèi)碼:,MOISN:

56,FICMONO,STRING,生產(chǎn)任務(wù)單號(hào):,生產(chǎn)任務(wù)單號(hào):,0,0,生產(chǎn)任務(wù)單號(hào):,MONo.:,生產(chǎn)任務(wù)單號(hào):,MONo.:

56,FBrNO,STRING,,,1,0,,,,

56,FItemID,INTEGER,產(chǎn)品代碼:,產(chǎn)品代碼:,0,0,產(chǎn)品代碼:,Prod.Code:,產(chǎn)品代碼:,Prod.Code:

56,FOriginWBID,INTEGER,原工序計(jì)劃單編號(hào):,原工序計(jì)劃單編號(hào):,0,0,原工序計(jì)畫(huà)單編號(hào):,OriginalOperationPlanSN:,原工序計(jì)畫(huà)單編號(hào):,OriginalOperationPlanSN:

56,FUnitID,INTEGER,單位:,單位:,0,0,單位:,UOM:,單位:,UOM:

57,FPlanEndDate,DATETIME,工序計(jì)劃完工日期,工序計(jì)劃完工日期,0,0,工序計(jì)畫(huà)完工日期,Op.PlannedFinish,工序計(jì)畫(huà)完工日期,Op.PlannedFinish

57,FAutoOF,INTEGER,自動(dòng)移轉(zhuǎn),自動(dòng)移轉(zhuǎn),0,0,自動(dòng)移轉(zhuǎn),Automatictransfer,自動(dòng)移轉(zhuǎn),Automatictransfer

57,FRepReceiveQty,FLOAT,,,1,0,,,,

57,FAuxQtyTaskDispAck,FLOAT,派工執(zhí)行數(shù)量,派工執(zhí)行數(shù)量,0,0,派工執(zhí)行數(shù)量,DispatchQty,派工執(zhí)行數(shù)量,DispatchQty

57,FTimeSetup,FLOAT,準(zhǔn)備時(shí)間,準(zhǔn)備時(shí)間,0,0,準(zhǔn)備時(shí)間,SetupTM,準(zhǔn)備時(shí)間,SetupTM

57,FQtyBack,FLOAT,,,1,0,,,,

57,FqualityChkID,INTEGER,檢驗(yàn)方式,檢驗(yàn)方式,0,0,檢驗(yàn)方式,Insp.Mode,檢驗(yàn)方式,Insp.Mode

57,FAutoTD,INTEGER,自動(dòng)派工,自動(dòng)派工,0,0,自動(dòng)派工,Auto-dispatching,自動(dòng)派工,Auto-dispatching

57,FAuxQualifiedReprocessedQty,FLOAT,返修合格數(shù)量,返修合格數(shù)量,0,0,返修合格數(shù)量,Returntoqualifiedquantities,返修合格數(shù)量,Returntoqualifiedquantities

57,FCancellation,INTEGER,,,1,0,,,,

57,FAuxQtyHandOverSel,FLOAT,移交選單數(shù)量,移交選單數(shù)量,0,0,移交選單數(shù)量,<NotMatched>,移交選單數(shù)量,<NotMatched>

57,FMoveQty,FLOAT,基本單位移動(dòng)批量,基本單位移動(dòng)批量,0,0,基本單位移動(dòng)批量,Movebatchofbasicunit,基本單位移動(dòng)批量,Movebatchofbasicunit

57,FAuxQtyScrap,FLOAT,因工報(bào)廢數(shù)量,因工報(bào)廢數(shù)量,0,0,因工報(bào)廢數(shù)量,OperationScraps,因工報(bào)廢數(shù)量,OperationScraps

57,FQtyPlan,FLOAT,,,1,0,,,,

57,FFManagerID,INTEGER,檢驗(yàn)員,檢驗(yàn)員,0,0,檢驗(yàn)員,Inspector,檢驗(yàn)員,Inspector

57,FitemID,INTEGER,產(chǎn)品代碼:,產(chǎn)品代碼:,0,0,產(chǎn)品代碼:,Prod.Code:,產(chǎn)品代碼:,Prod.Code:

57,FResourceCount,INTEGER,資源數(shù),資源數(shù),0,0,資源數(shù),Numberofresource,資源數(shù),Numberofresource

57,FIsOut,INTEGER,是否外協(xié),是否外協(xié),0,0,是否外協(xié),Subcontract,是否外協(xié),Subcontract

57,FSupplyID,INTEGER,加工單位,加工單位,0,0,加工單位,Subcntr,加工單位,Subcntr

57,FStatus,INTEGER,狀態(tài),狀態(tài),0,0,狀態(tài),Status,狀態(tài),Status

57,FCheckerID,INTEGER,審核人,審核人,0,0,審核人,Approver,審核人,Approver

57,FWBInterID,INTEGER,工序計(jì)劃單內(nèi)碼,工序計(jì)劃單內(nèi)碼,0,0,工序計(jì)畫(huà)單內(nèi)碼,Op.PlanSlipISN,工序計(jì)畫(huà)單內(nèi)碼,Op.PlanSlipISN

57,FPriority,INTEGER,,,1,0,,,,

57,FBrNo,INTEGER,,,1,0,,,,

57,FFinishTime,FLOAT,人工實(shí)作工時(shí),人工實(shí)作工時(shí),0,0,人工實(shí)作工時(shí),ActualMan-hours,人工實(shí)作工時(shí),ActualMan-hours

57,FReadyTime,FLOAT,機(jī)臺(tái)準(zhǔn)備工時(shí),機(jī)臺(tái)準(zhǔn)備工時(shí),0,0,機(jī)臺(tái)準(zhǔn)備工時(shí),MachinePrep.Hours,機(jī)臺(tái)準(zhǔn)備工時(shí),MachinePrep.Hours

57,FQtyLost,FLOAT,,,1,0,,,,

57,FAuxQtyRecive,FLOAT,接收數(shù)量,接收數(shù)量,0,0,接收數(shù)量,ReceivedQty,接收數(shù)量,ReceivedQty

10,FStatus,INTEGER,狀態(tài),狀態(tài),0,0,狀態(tài),Status,狀態(tài),Status

17,FOutMachFee,FLOAT,單位委外加工費(fèi),,0,0,單位委外加工費(fèi),SubcontractCharge,,

17,FCUUnitID,INTEGER,常用計(jì)量單位,常用計(jì)量單位,0,0,常用計(jì)量單位,CUoM,常用計(jì)量單位,CUoM

22,FLoan,INTEGER,貸款科目,0-不是,1-是貸款科目,0,0,貸款科目,LoanAccount,0-不是,1-是貸款科目,0-No.1-Yes

32,FCodeRuleNO,INTEGER,編碼規(guī)則序號(hào),編碼規(guī)則序號(hào),1,0,編碼規(guī)則序號(hào),CodingRuleSN,編碼規(guī)則序號(hào),CodingRuleSN

47,FBadDebtsRate,FLOAT,壞賬計(jì)提比率,壞賬計(jì)提比率,0,0,壞賬計(jì)提比率,BadDebtWithdrawalRate,壞賬計(jì)提比率,BadDebtWithdrawalRate

47,FClientID,INTEGER,,,1,0,,,,

47,FSuperiorID,INTEGER,,,1,0,,,,

47,FName,STRING,分支機(jī)構(gòu)名稱(chēng),,0,0,分支機(jī)搆名稱(chēng),BranchName,,

49,FBlob,UnKnown,數(shù)據(jù),數(shù)據(jù),1,0,數(shù)據(jù),Data,數(shù)據(jù),Data

50,FOperID,INTEGER,操作人ID,操作人ID,1,0,操作人ID,OperatorID,操作人ID,OperatorID

50,FPriorityID,INTEGER,,,1,0,,,,

47,FItemID,INTEGER,分支機(jī)構(gòu)ID,分支機(jī)構(gòu)ID,1,0,分支機(jī)搆ID,BranchID,分支機(jī)搆ID,BranchID

50,FCarryingAOS,INTEGER,默認(rèn)運(yùn)輸提前期(天),默認(rèn)運(yùn)輸提前期(天),0,0,默認(rèn)運(yùn)輸提前期(天),DefaultShippingLeadTime(day),默認(rèn)運(yùn)輸提前期(天),DefaultShippingLeadTime(day)

50,FBank,STRING,開(kāi)戶(hù)銀行,開(kāi)戶(hù)銀行,0,0,開(kāi)戶(hù)銀行,OpeningBank,開(kāi)戶(hù)銀行,OpeningBank

50,FCity,STRING,城市,城市,0,0,城市,City,城市,City

50,FStatus,INTEGER,狀態(tài),狀態(tài),0,0,狀態(tài),Status,狀態(tài),Status

50,FTaxNum,STRING,稅務(wù)登記號(hào),稅務(wù)登記號(hào),0,0,稅務(wù)登記號(hào),TaxRegistrationNo.,稅務(wù)登記號(hào),TaxRegistrationNo.

33,FValue,STRING,當(dāng)前值,當(dāng)前值,1,0,當(dāng)前值,CurrentValue,當(dāng)前值,CurrentValue

35,FActualSize,INTEGER,實(shí)際尺寸,實(shí)際尺寸,1,0,實(shí)際尺寸,ActualDimensions,實(shí)際尺寸,ActualDimensions

35,FMaxPrecision,INTEGER,最大精度,數(shù)據(jù)類(lèi)型的最大精度,1,0,最大精度,MaxAccuracy,資料類(lèi)型的最大精度,DataTypeMaxAccuracy

35,FDataType,INTEGER,數(shù)據(jù)類(lèi)型ID,系統(tǒng)數(shù)據(jù)類(lèi)型ID,1,0,資料類(lèi)型ID,DataTypeID,系統(tǒng)資料類(lèi)型ID,SysDataTypeID

44,FTableID,INTEGER,表ID,表ID,1,0,表ID,SheetID,表ID,SheetID

50,FpreAcctID,INTEGER,預(yù)收賬款科目代碼,預(yù)收賬款科目代碼,0,0,預(yù)收賬款科目代碼,PrecollectionAccountCode,預(yù)收賬款科目代碼,PrecollectionAccountCode

32,FFormat,STRING,是否格式化,是否格式化,1,0,是否格式化,FormatIt,是否格式化,FormatIt

40,FForbidden,INTEGER,功能ID,功能ID,1,0,功能ID,FunctionID,功能ID,FunctionID

42,FSystem,STRING,系統(tǒng)名,系統(tǒng)名,1,0,系統(tǒng)名,SysName,系統(tǒng)名,SysName

46,FDescription,STRING,描述,描述,1,0,描述,Descr.,描述,Descr.

50,FFax,STRING,傳真號(hào),傳真號(hào),0,0,傳真號(hào),Fax,傳真號(hào),Fax

50,FMinPOValue,FLOAT,,,1,0,,,,

36,moduelname,STRING,模塊名稱(chēng),數(shù)據(jù)灌入模塊名稱(chēng),1,0,模組名稱(chēng),Modulename,資料灌入模組名稱(chēng),DataInfusingModuleName

37,tablename,STRING,中間表名稱(chēng),中間表名稱(chēng),1,0,中間表名稱(chēng),MiddleSheetName,中間表名稱(chēng),MiddleSheetName

37,cname,STRING,中文名稱(chēng),字段的中文名稱(chēng),1,0,中文名稱(chēng),ChineseName,欄位的中文名稱(chēng),FieldChineseName

41,FDeleteDate,DATETIME,上次禁用日期,上次禁用日期,0,0,上次禁用日期,LastDisablingDate,上次禁用日期,LastDisablingDate

43,FType,INTEGER,枚舉類(lèi)別,枚舉類(lèi)別,1,0,枚舉類(lèi)別,EnumerationCategory,枚舉類(lèi)別,EnumerationCategory

46,FTableID,INTEGER,表ID,表ID,1,0,表ID,SheetID,表ID,SheetID

33,FPrefix,STRING,前綴,前綴,1,0,首碼,Prefix,首碼,Prefix

33,FCodeRuleID,INTEGER,編碼規(guī)則內(nèi)碼,編碼規(guī)則內(nèi)碼,1,0,編碼規(guī)則內(nèi)碼,CodingRuleISN,編碼規(guī)則內(nèi)碼,CodingRuleISN

46,FFieldName,STRING,字段名,字段名,1,0,欄位名,FieldName,欄位名,FieldName

47,FModifyTime,UnKnown,,,1,0,,,,

50,FAddress,STRING,地址,地址,0,0,地址,Address,地址,Address

50,FminForeReceiveRate,FLOAT,最小預(yù)收比率(%),最小預(yù)收比率(%),0,0,最小預(yù)收比率(%),Min.AdvanceClctRatio(%),最小預(yù)收比率(%),Min.AdvanceClctRatio(%)

38,ispkey,INTEGER,是主關(guān)鍵字,是主關(guān)鍵字,1,0,是主關(guān)鍵字,MasterKeyword,是主關(guān)鍵字,MasterKeyword

39,FName,STRING,表名,表名,1,0,表名,SheetName,表名,SheetName

47,FRegionID,INTEGER,區(qū)域,區(qū)域,0,0,區(qū)域,Region,區(qū)域,Region

50,FminReserverate,FLOAT,最小訂金比率(%),最小訂金比率(%),0,0,最小訂金比率(%),Min.DepositRatio(%),最小訂金比率(%),Min.DepositRatio(%)

51,FReportClassID,INTEGER,報(bào)表類(lèi)別ID,,1,0,報(bào)表類(lèi)別ID,ReportCategoryID,,

54,FParentID,INTEGER,上級(jí)代碼,,0,0,上級(jí)代碼,Relate-upCode,,

34,FStart,INTEGER,起始值,起始值,1,0,起始值,StartingVal,起始值,StartingVal

35,FActualType,INTEGER,實(shí)際數(shù)據(jù)類(lèi)型,ADO標(biāo)準(zhǔn)數(shù)據(jù)類(lèi)型,1,0,實(shí)際資料類(lèi)型,ActualDataType,ADO標(biāo)準(zhǔn)資料類(lèi)型,ADOStandardDataType

41,FCreateUser,STRING,創(chuàng)建人,創(chuàng)建人,0,0,創(chuàng)建人,Creator,創(chuàng)建人,Creator

47,FTrade,INTEGER,行業(yè),行業(yè),0,0,行業(yè),Industry,行業(yè),Industry

47,FOwnershipID,INTEGER,所有制,所有制,0,0,所有制,OwnershipSystem,所有制,OwnershipSystem

47,FShortNumber,STRING,短代碼,短代碼,0,0,短代碼,ShorCode,短代碼,ShorCode

33,FLevel,INTEGER,層級(jí),層級(jí),1,0,層級(jí),Layer,層級(jí),Layer

37,id,FLOAT,自動(dòng)步長(zhǎng)編碼,自動(dòng)步長(zhǎng)編碼,1,0,自動(dòng)步長(zhǎng)編碼,AutoStepLengthNo.,自動(dòng)步長(zhǎng)編碼,AutoStepLengthNo.

37,description,STRING,描述,字段取值的描述信息,1,0,描述,Descr.,欄位取值的描述資訊,FieldValueDescription

43,FKeyChar,STRING,字符串關(guān)鍵字,字符串關(guān)鍵字,1,0,字串關(guān)鍵字,CharacterStringKeyword,字串關(guān)鍵字,CharacterStringKeyword

54,FNumber,STRING,費(fèi)用代碼,,0,0,費(fèi)用代碼,ExpCd,,

55,FSPID,INTEGER,倉(cāng)位ID,,0,0,倉(cāng)位ID,BinID,,

38,benull,INTEGER,允許為空,是否允許為空,1,0,允許為空,Allowedtobenull,是否允許為空,VacancyAllowed

41,FLastModUser,STRING,修改人,修改人,0,0,修改人,Editor,修改人,Editor

43,FKeyInt,INTEGER,整數(shù)關(guān)鍵字,整數(shù)關(guān)鍵字,1,0,整數(shù)關(guān)鍵字,IntegralKeyword,整數(shù)關(guān)鍵字,IntegralKeyword

44,FTableName,STRING,表名,表名,1,0,表名,SheetName,表名,SheetName

44,FSubSystemID,INTEGER,子系統(tǒng)ID,子系統(tǒng)ID,1,0,子系統(tǒng)ID,SubsysID,子系統(tǒng)ID,SubsysID

44,FDescription,STRING,描述,描述,1,0,描述,Descr.,描述,Descr.

35,FTypeName,STRING,描述名稱(chēng),數(shù)據(jù)類(lèi)型的描述名稱(chēng),1,0,描述名稱(chēng),DescriptionName,資料類(lèi)型的描述名稱(chēng),DataTypeDescriptionName

37,moduelname,STRING,模塊名,數(shù)據(jù)灌入模塊名稱(chēng),1,0,模組名,ModuleName,資料灌入模組名稱(chēng),DataInfusingModuleName

38,cname,STRING,中文名稱(chēng),字段中文名稱(chēng),1,0,中文名稱(chēng),ChineseName,欄位中文名稱(chēng),FieldName(inChinese)

41,FLastModDate,DATETIME,上次修改日期,上次修改日期,0,0,上次修改日期,LastEditionDate,上次修改日期,LastEditionDate

43,FValue,STRING,取值,取值,1,0,取值,Acquisition,取值,Acquisition

44,FType,INTEGER,是否萬(wàn)能報(bào)表使用,是否萬(wàn)能報(bào)表使用,1,0,是否萬(wàn)能報(bào)表使用,ApplicableToUniversalReport,是否萬(wàn)能報(bào)表使用,ApplicableToUniversalReport

34,FTypeID,INTEGER,類(lèi)型代號(hào),類(lèi)型代號(hào),1,0,類(lèi)型代號(hào),TypeCode,類(lèi)型代號(hào),TypeCode

34,FEnd,INTEGER,終止值,終止值,1,0,終止值,EndingValue,終止值,EndingValue

35,FMinScale,INTEGER,最小長(zhǎng)度,數(shù)據(jù)類(lèi)型的最小長(zhǎng)度,1,0,最小長(zhǎng)度,MinLength,資料類(lèi)型的最小長(zhǎng)度,DataTypeMinLength

41,FCreateDate,DATETIME,創(chuàng)建日期,創(chuàng)建日期,0,0,創(chuàng)建日期,CreationDate,創(chuàng)建日期,CreationDate

56,FStatus,INTEGER,狀態(tài),狀態(tài),0,0,狀態(tài),Status,狀態(tài),Status

56,FCheckerID,INTEGER,審核人,審核人,0,0,審核人,Approver,審核人,Approver

36,id,INTEGER,編碼ID,自動(dòng)步長(zhǎng)編碼,1,0,編碼ID,CodeID,自動(dòng)步長(zhǎng)編碼,AutoStepLengthNo.

38,type,STRING,數(shù)據(jù)類(lèi)型,SQL數(shù)據(jù)類(lèi)型,1,0,資料類(lèi)型,DataType,SQL資料類(lèi)型,SQLDataType

41,FDeleteUser,STRING,禁用人,禁用人,0,0,禁用人,Disabler,禁用人,Disabler

41,FSeqID,FLOAT,唯一序號(hào),唯一序號(hào),0,0,唯一序號(hào),UniqueSN,唯一序號(hào),UniqueSN

41,FItemID,FLOAT,核算項(xiàng)目ID,核算項(xiàng)目ID,0,0,核算項(xiàng)目ID,AnalysisItemID,核算項(xiàng)目ID,AnalysisItemID

45,FRptName,STRING,報(bào)表名,報(bào)表名,1,0,報(bào)表名,ReportName,報(bào)表名,ReportName

33,FCodeRuleNO,INTEGER,編碼規(guī)則序號(hào),編碼規(guī)則序號(hào),1,0,編碼規(guī)則序號(hào),CodingRuleSN,編碼規(guī)則序號(hào),CodingRuleSN

38,description,STRING,描述,字段描述信息,1,0,描述,Descr.,欄位描述資訊,FieldDescriptionInfo

47,FCorCustomer,INTEGER,對(duì)應(yīng)客戶(hù),,0,0,對(duì)應(yīng)客戶(hù),CorrespondingCustomer,,

49,FID,INTEGER,內(nèi)部ID,內(nèi)部ID,1,0,內(nèi)部ID,InternalID,內(nèi)部ID,InternalID

55,FNumber,STRING,倉(cāng)位代碼,,0,0,倉(cāng)位代碼,BinNo.,,

56,FCancellation,INTEGER,,,1,0,,,,

32,FLevel,INTEGER,層級(jí),層級(jí),1,0,層級(jí),Layer,層級(jí),Layer

38,id,FLOAT,字段步長(zhǎng)編碼,字段步長(zhǎng)編碼,1,0,欄位步長(zhǎng)編碼,FieldStepLengthNo.,欄位步長(zhǎng)編碼,FieldStepLengthNo.

42,FProcName,STRING,存儲(chǔ)過(guò)程名,存儲(chǔ)過(guò)程名,1,0,存儲(chǔ)過(guò)程名,SavingProcessName,存儲(chǔ)過(guò)程名,SavingProcessName

45,FSubSystemID,INTEGER,子系統(tǒng)ID,子系統(tǒng)ID,1,0,子系統(tǒng)ID,SubsysID,子系統(tǒng)ID,SubsysID

54,FUnit,STRING,計(jì)量單位,,0,0,計(jì)量單位,UoM,,

55,FDescription,STRING,備注,,0,0,備註,Remarks,,

32,FIncrement,INTEGER,步長(zhǎng),步長(zhǎng),1,0,步長(zhǎng),StepLength,步長(zhǎng),StepLength

32,FInitValue,STRING,初始值,初始值,1,0,初始值,InitialValue,初始值,InitialValue

35,FMaxScale,INTEGER,最大長(zhǎng)度,數(shù)據(jù)類(lèi)型的最大長(zhǎng)度,1,0,最大長(zhǎng)度,MaxLength,資料類(lèi)型的最大長(zhǎng)度,DataTypeMaxLength

38,tablename,STRING,所屬表名稱(chēng),所屬中間表名稱(chēng),1,0,所屬表名稱(chēng),SheetName,所屬中間表名稱(chēng),MiddleSheetName

40,FFuncID,INTEGER,功能ID,功能ID,1,0,功能ID,FunctionID,功能ID,FunctionID

44,FTableNote,STRING,表描述,表描述,1,0,表描述,Sheet,表描述,Sheet

32,FCodeRuleID,INTEGER,編碼規(guī)則內(nèi)碼,編碼規(guī)則內(nèi)碼,1,0,編碼規(guī)則內(nèi)碼,CodingRuleISN,編碼規(guī)則內(nèi)碼,CodingRuleISN

34,FDesc,STRING,描述,描述,1,0,描述,Descr.,描述,Descr.

35,FBindType,INTEGER,綁定類(lèi)別,綁定類(lèi)別,1,0,綁定類(lèi)別,BindingCategory,綁定類(lèi)別,BindingCategory

39,FStep,INTEGER,步長(zhǎng),步長(zhǎng),1,0,步長(zhǎng),StepLength,步長(zhǎng),StepLength

40,FType,INTEGER,互斥類(lèi)型,互斥類(lèi)型,1,0,互斥類(lèi)型,ExclusionType,互斥類(lèi)型,ExclusionType

54,FRemark,STRING,備注,,0,0,備註,Remarks,,

32,FFixLength,INTEGER,是否定長(zhǎng),是否定長(zhǎng),1,0,是否定長(zhǎng),Fixedlength,是否定長(zhǎng),Fixedlength

38,fieldname,STRING,字段名稱(chēng),字段實(shí)際名稱(chēng),1,0,欄位名稱(chēng),FieldName,欄位實(shí)際名稱(chēng),FieldActualName

39,FNext,INTEGER,下一個(gè)新增值,下一個(gè)新增值,1,0,下一個(gè)新增值,NextNewVal,下一個(gè)新增值,NextNewVal

41,FTypeID,FLOAT,數(shù)據(jù)類(lèi)別ID,數(shù)據(jù)類(lèi)別ID,0,0,數(shù)據(jù)類(lèi)別ID,DataCtgyID,數(shù)據(jù)類(lèi)別ID,DataCtgyID

55,FDeleted,INTEGER,是否禁用,,1,0,是否禁用,Disable,,

56,FBillNO,STRING,編號(hào):,編號(hào):,0,0,編號(hào):,No.:,編號(hào):,No.:

22,FGroupID,INTEGER,科目類(lèi)別內(nèi)碼,會(huì)計(jì)科目類(lèi)別ID,0,0,科目類(lèi)別內(nèi)碼,AccountTypeISN,會(huì)計(jì)科目類(lèi)別ID,AccountTitleTypeID

22,FIsBudget,INTEGER,是否預(yù)算科目,是否預(yù)算科目,0,0,是否預(yù)算科目,BudgetaryItem,是否預(yù)算科目,BudgetaryItem

24,FUserID,INTEGER,用戶(hù)ID,用戶(hù)ID,1,0,用戶(hù)Id,UserID,用戶(hù)Id,UserID

26,FIndex,INTEGER,索引,索引,1,0,索引,Index,索引,Index

56,FBillType,INTEGER,類(lèi)型:,類(lèi)型:,0,0,類(lèi)型:,Type:,類(lèi)型:,Type:

56,FOperShiftBillID,INTEGER,工序移轉(zhuǎn)單編號(hào):,工序移轉(zhuǎn)單編號(hào):,0,0,工序移轉(zhuǎn)單編號(hào):,OperationTransferSlipNo.,工序移轉(zhuǎn)單編號(hào):,OperationTransferSlipNo.

22,FName,STRING,科目名稱(chēng),會(huì)計(jì)科目名稱(chēng),0,0,科目名稱(chēng),AccountName,會(huì)計(jì)科目名稱(chēng),AccountingItemName

22,FAcnt,INTEGER,核算項(xiàng)目,"0-不,1-要下設(shè)核算項(xiàng)目",0,0,核算項(xiàng)目,Anls.Item,"0-不,1-要下設(shè)核算項(xiàng)目",0-No.1-Yes

30,FName,STRING,表名,表名,1,0,表名,SheetName,表名,SheetName

47,FRecvCode,STRING,,,1,0,,,,

55,FName,STRING,倉(cāng)位名,,0,0,倉(cāng)位名,BinName,,

56,FBillerID,INTEGER,制單人:,制單人:,0,0,制單人:,Prep.by:,制單人:,Prep.by:

22,FNumber,STRING,科目代碼,會(huì)計(jì)科目代碼,0,0,科目代碼,AccountCode,會(huì)計(jì)科目代碼,AccountTitleCode

22,FIsBusi,INTEGER,,,1,0,,,,

23,FObjectID,INTEGER,系統(tǒng)明細(xì)對(duì)象ID,系統(tǒng)明細(xì)對(duì)象ID,1,0,系統(tǒng)明細(xì)對(duì)象ID,SysDetailedObjectID,系統(tǒng)明細(xì)對(duì)象ID,SysDetailedObjectID

26,FObjectType,INTEGER,對(duì)象類(lèi)型,對(duì)象類(lèi)型,1,0,對(duì)象類(lèi)型,ObjectType,對(duì)象類(lèi)型,ObjectType

26,FObjectID,INTEGER,對(duì)象ID,對(duì)象ID,1,0,對(duì)象ID,ObjectID,對(duì)象ID,ObjectID

56,FCheckDate,DATETIME,審核日期,審核日期,0,0,審核日期,Aprv.DT,審核日期,Aprv.DT

22,FTradeNum,STRING,集團(tuán)控制科目代碼,集團(tuán)控制科目代碼,0,0,集團(tuán)控制科目代碼,GroupControlledAccountCode,集團(tuán)控制科目代碼,GroupControlledAccountCode

22,FViewMsg,INTEGER,,,1,0,,,,

27,FObjectID,INTEGER,對(duì)象ID,對(duì)象ID,1,0,對(duì)象ID,ObjectID,對(duì)象ID,ObjectID

28,FName,STRING,對(duì)象名稱(chēng),對(duì)象名稱(chēng),1,0,對(duì)象名稱(chēng),ObjectName,對(duì)象名稱(chēng),ObjectName

28,FObjectID,INTEGER,對(duì)象ID,對(duì)象ID,1,0,對(duì)象ID,ObjectID,對(duì)象ID,ObjectID

54,FDeleted,INTEGER,是否禁用,,1,0,是否禁用,Disable,,

22,FAcntID,INTEGER,賬號(hào),賬號(hào),0,0,賬號(hào),A/CNo.,賬號(hào),A/CNo.

22,FBrNo,STRING,公司代碼,公司代碼,1,0,公司代碼,CompanyNo.,公司代碼,CompanyNo.

23,FObjectType,INTEGER,系統(tǒng)一級(jí)對(duì)象代碼,系統(tǒng)一級(jí)對(duì)象代碼,1,0,系統(tǒng)一級(jí)對(duì)象代碼,SysLevel-1ObjectCode,系統(tǒng)一級(jí)對(duì)象代碼,SysLevel-1ObjectCode

29,FFileSize,INTEGER,文件大小,文件大小,1,0,文件大小,FileSize,文件大小,FileSize

52,FParentClassID,INTEGER,上級(jí)類(lèi)別ID,,1,0,上級(jí)類(lèi)別ID,Relate-upTypeID,,

53,FReportRight,INTEGER,報(bào)表權(quán)限,,1,0,報(bào)表許可權(quán),ReportAuthority,,

22,FMessage,STRING,,,1,0,,,,

22,FLevel,INTEGER,科目級(jí)次,會(huì)計(jì)科目級(jí)次,0,0,科目級(jí)次,AccountLevels,會(huì)計(jì)科目級(jí)次,AccountTitleLevels

29,FFile,UnKnown,文件,文件,1,0,文件,File,文件,File

50,FCIQNumber,STRING,海關(guān)代碼,海關(guān)代碼,0,0,海關(guān)代碼,CustomsCode,海關(guān)代碼,CustomsCode

53,FReportID,INTEGER,報(bào)表ID,,1,0,報(bào)表Id,ReportID,,

56,FDate,DATETIME,日期:,日期:,0,0,日期:,Date:,日期:,Date:

22,FParentID,INTEGER,上級(jí)科目?jī)?nèi)碼,上級(jí)科目ID,0,0,上級(jí)科目?jī)?nèi)碼,Relate-upAccountISN,上級(jí)科目ID,Relate-upAccountID

23,FAccessType,INTEGER,權(quán)限主碼,權(quán)限主碼,1,0,許可權(quán)主碼,AuthMainCode,許可權(quán)主碼,AuthMainCode

46,FFieldType,STRING,字段數(shù)據(jù)類(lèi)型,字段數(shù)據(jù)類(lèi)型,1,0,欄位資料類(lèi)型,FieldDataType,欄位資料類(lèi)型,FieldDataType

47,FInvestRate,FLOAT,投資比例,投資比例,0,0,投資比例,InvestmentProportion,投資比例,InvestmentProportion

54,FShortNumber,STRING,費(fèi)用簡(jiǎn)碼,,0,0,費(fèi)用簡(jiǎn)碼,ExpensesCode,,

55,FModifyTime,UnKnown,時(shí)間戳,,1,0,時(shí)間戳,TimeStamp,,

22,FIsCash,INTEGER,現(xiàn)金類(lèi)科目,0-不是,1-是現(xiàn)金類(lèi)科目,0,0,現(xiàn)金類(lèi)科目,CashAccount,0-不是,1-是現(xiàn)金類(lèi)科目,0-No.1-Yes

22,FDC,INTEGER,借貸方向,1-借方-1-貸方,0,0,借貸方向,Credit/Debit,1-借方-1-貸方,1-Debit-1-Credit

23,FUserID,INTEGER,用戶(hù)ID,用戶(hù)ID,1,0,用戶(hù)Id,UserID,用戶(hù)Id,UserID

27,FIndex,INTEGER,索引號(hào),索引號(hào),1,0,索引號(hào),IndexNo.,索引號(hào),IndexNo.

54,FItemID,INTEGER,費(fèi)用內(nèi)碼,,0,0,費(fèi)用內(nèi)碼,ExpensesISN,,

55,FLevel,INTEGER,倉(cāng)位級(jí)次,,0,0,倉(cāng)位級(jí)次,BinLevel,,

22,FDetail,INTEGER,明細(xì)科目,0-不是,1-是最明細(xì)科目,0,0,明細(xì)科目,Detailedaccount,0-不是,1-是最明細(xì)科目,0-No.1-Yes

25,FSubSys,STRING,子系統(tǒng)名,子系統(tǒng)名,1,0,子系統(tǒng)名,Sub-systemName,子系統(tǒng)名,Sub-systemName

27,FName,STRING,使用屬性名稱(chēng),使用屬性名稱(chēng),1,0,使用屬性名稱(chēng),UseAttributeName,使用屬性名稱(chēng),UseAttributeName

29,FTypeID,INTEGER,類(lèi)型代號(hào),類(lèi)型代號(hào),1,0,類(lèi)型代號(hào),TypeCode,類(lèi)型代號(hào),TypeCode

51,FReportName,STRING,報(bào)表名稱(chēng),,1,0,報(bào)表名稱(chēng),ReportName,,

52,FReportClassName,STRING,類(lèi)別名稱(chēng),,1,0,類(lèi)別名稱(chēng),CategoryName,,

22,FintRate,FLOAT,利息率,利息率,0,0,利息率,InterestRate,利息率,InterestRate

22,FHelperCode,STRING,助記碼,助記碼,0,0,助記碼,S/N,助記碼,S/N

22,FAcctint,INTEGER,是否計(jì)息,"0-不,1-要計(jì)息",0,0,是否計(jì)息,Interest,"0-不,1-要計(jì)息",0-No.1-Yes

24,FGroupID,INTEGER,用戶(hù)組ID,用戶(hù)組ID,1,0,用戶(hù)組ID,UsergroupID,用戶(hù)組ID,UsergroupID

54,FName,STRING,費(fèi)用名稱(chēng),,0,0,費(fèi)用名稱(chēng),ExpName,,

55,FShortNumber,STRING,短代碼,,0,0,短代碼,ShorCode,,

22,FRootID,INTEGER,上級(jí)科目?jī)?nèi)碼,最上級(jí)科目ID,0,0,上級(jí)科目?jī)?nèi)碼,Relate-upAccountISN,最上級(jí)科目ID,Top-levelAccountID

27,FObjectType,INTEGER,對(duì)象類(lèi)型編碼,對(duì)象類(lèi)型編碼,1,0,對(duì)象類(lèi)型編碼,ObjectTypeSN,對(duì)象類(lèi)型編碼,ObjectTypeSN

31,FCodeRuleName,STRING,編碼規(guī)則名稱(chēng),編碼規(guī)則名稱(chēng),1,0,編碼規(guī)則名稱(chēng),CodingRuleName,編碼規(guī)則名稱(chēng),CodingRuleName

47,FSuperDeptID,INTEGER,上級(jí)主管,上級(jí)主管,0,0,上級(jí)主管,Supervisor,上級(jí)主管,Supervisor

56,FCoefficient,FLOAT,換算比例:,換算比例:,0,0,換算比例:,Conversionratio,換算比例:,Conversionratio

56,FGMPBatchNo,STRING,批號(hào):,批號(hào):,0,0,批號(hào):,LotNo.:,批號(hào):,LotNo.:

25,FMask,INTEGER,權(quán)限碼,權(quán)限碼,1,0,許可權(quán)碼,AuthCode,許可權(quán)碼,AuthCode

25,FAccess,STRING,權(quán)限,權(quán)限,1,0,許可權(quán),Auth.,許可權(quán),Auth.

30,FNext,INTEGER,下一個(gè)新增值,下一個(gè)新增值,1,0,下一個(gè)新增值,NextNewVal,下一個(gè)新增值,NextNewVal

47,FDeleted,INTEGER,是否禁用,是否禁用,1,0,是否禁用,Disable,是否禁用,Disable

51,FReportBlob,UnKnown,報(bào)表Blob,,1,0,報(bào)表Blob,ReportBlob,,

52,FSubSysID,INTEGER,子系統(tǒng)ID,,1,0,子系統(tǒng)ID,SubsysID,,

22,UUID,UnKnown,,,1,0,,,,

22,FIsBank,INTEGER,銀行類(lèi)科目,0-不是,1-是銀行存款類(lèi)科目,0,0,銀行類(lèi)科目,BankAccount,0-不是,1-是銀行存款類(lèi)科目,0-No.1-Yes

22,FModifyTime,UnKnown,,,1,0,,,,

22,FAccountID,INTEGER,科目?jī)?nèi)碼,會(huì)計(jì)科目ID(關(guān)鍵字),0,0,科目?jī)?nèi)碼,AccountISN,會(huì)計(jì)科目ID(關(guān)鍵字),AccountTitleID(keyword)

24,FType,INTEGER,類(lèi)型,類(lèi)型,1,0,類(lèi)型,Type,類(lèi)型,Type

54,FModifyTime,UnKnown,時(shí)間戳,,1,0,時(shí)間戳,TimeStamp,,

22,FMeasureUnitID,INTEGER,單位內(nèi)碼,計(jì)量單位ID,0,0,單位內(nèi)碼,UnitISN,計(jì)量單位ID,UoMID

22,FLastintDate,DATETIME,計(jì)息時(shí)間,最新一次計(jì)息時(shí)間,0,0,計(jì)息時(shí)間,InterestTime,最新一次計(jì)息時(shí)間,LatestInterestTime

23,FAccessMask,INTEGER,權(quán)限子碼,權(quán)限子碼,1,0,許可權(quán)子碼,AuthSubcode,許可權(quán)子碼,AuthSubcode

26,FGroupID,INTEGER,對(duì)象組ID,對(duì)象組ID,1,0,對(duì)象組ID,ObjectGroupID,對(duì)象組ID,ObjectGroupID

50,FlastReceiveDate,DATETIME,最后收款日期,最后收款日期,0,0,最後收款日期,LastCollectionDate,最後收款日期,LastCollectionDate

51,FTimeStamp,UnKnown,時(shí)間戳,,1,0,時(shí)間戳,TimeStamp,,

22,FAcntType,INTEGER,賬戶(hù)類(lèi)型,"0-普通科目,1-表外科目",0,0,賬戶(hù)類(lèi)型,A/CType,"0-普通科目,1-表外科目","0-Ordinary,1-Off-balance-sheet"

22,FIsAcnt,INTEGER,是否賬號(hào),是否賬號(hào),0,0,是否賬號(hào),A/C,是否賬號(hào),A/C

25,FGroupID,INTEGER,用戶(hù)組ID,用戶(hù)組ID,1,0,用戶(hù)組ID,UsergroupID,用戶(hù)組ID,UsergroupID

27,FDescription,STRING,描述,描述,1,0,描述,Descr.,描述,Descr.

52,FReportClassID,INTEGER,類(lèi)別ID,,1,0,類(lèi)別ID,CategoryID,,

53,FUserID,INTEGER,用戶(hù)ID,,1,0,用戶(hù)Id,UserID,,

22,FDetailID,INTEGER,核算項(xiàng)目?jī)?nèi)碼,核算項(xiàng)目使用ID,0,0,核算項(xiàng)目?jī)?nèi)碼,AnalysisItemISN,核算項(xiàng)目使用ID,AnalysisItemUseID

22,FEarnAccountID,INTEGER,利潤(rùn)科目?jī)?nèi)碼,損益類(lèi)科目對(duì)應(yīng)的本年利潤(rùn)科目ID,0,0,利潤(rùn)科目?jī)?nèi)碼,ProfitAccountISN,損益類(lèi)科目對(duì)應(yīng)的本年利潤(rùn)科目ID,Profit&LossA/CcorrespdThisYearProfitItemID

22,FIsCashFlow,INTEGER,現(xiàn)金等價(jià)物,"0-不,1-要計(jì)算",0,0,現(xiàn)金等價(jià)物,CashEquivalent,"0-不,1-要計(jì)算","0-No,1-Yes"

27,FAccessMask,INTEGER,訪(fǎng)問(wèn)掩碼,訪(fǎng)問(wèn)掩碼,1,0,訪(fǎng)問(wèn)遮罩,VisitMask,訪(fǎng)問(wèn)遮罩,VisitMask

27,FAccessUse,INTEGER,使用屬性編碼,使用屬性編碼,1,0,使用屬性編碼,UseAttributeCode,使用屬性編碼,UseAttributeCode

28,FDescription,STRING,描述,描述,1,0,描述,Descr.,描述,Descr.

19,FHireDate,DATETIME,入職日期,入職日期,0,0,入職日期,Enrollmentdate,入職日期,Enrollmentdate

19,FItemDepID,INTEGER,部門(mén)號(hào),部門(mén)號(hào),0,0,部門(mén)號(hào),Dept.No.,部門(mén)號(hào),Dept.No.

22,FDpst,INTEGER,定期存款,0-不是,1-是定期存款科目,0,0,定期存款,TermDeposit,0-不是,1-是定期存款科目,0-No.1-Yes

47,FBondInvestAmt,FLOAT,投資金額,投資金額,0,0,投資金額,InvestmentAmount,投資金額,InvestmentAmount

51,FReportID,INTEGER,報(bào)表ID,,1,0,報(bào)表Id,ReportID,,

51,FModifyUser,INTEGER,修改人,,1,0,修改人,Editor,,

18,FItemID,INTEGER,資料內(nèi)碼,資料ID(關(guān)鍵字),0,0,資料內(nèi)碼,DataISN,資料ID(關(guān)鍵字),DataID(keyword)

19,FModifyTime,UnKnown,,,1,0,,,,

19,FCreditPeriod,INTEGER,信用期,信用期,1,0,信用期,CreditPeriod,信用期,CreditPeriod

20,FPhone,STRING,電話(huà),電話(huà),0,0,電話(huà),Tel,電話(huà),Tel

50,FDeleted,INTEGER,是否禁用,是否禁用,0,0,是否禁用,Disable,是否禁用,Disable

51,FReportCreator,INTEGER,報(bào)表創(chuàng)建人,,1,0,報(bào)表創(chuàng)建人,Createdby,,

17,FInspectionProject,INTEGER,檢驗(yàn)方案,檢驗(yàn)方案,0,0,檢驗(yàn)方案,Insp.Schm,檢驗(yàn)方案,Insp.Schm

17,FForSale,INTEGER,是否銷(xiāo)售,是否銷(xiāo)售,0,0,是否銷(xiāo)售,Sales,是否銷(xiāo)售,Sales

17,FStandardCost,FLOAT,單位標(biāo)準(zhǔn)成本,單位標(biāo)準(zhǔn)成本,0,0,單位標(biāo)準(zhǔn)成本,StandardCostPerUoM,單位標(biāo)準(zhǔn)成本,StandardCostPerUoM

19,FParentID,INTEGER,上級(jí)代碼,上級(jí)代碼,0,0,上級(jí)代碼,Relate-upCode,上級(jí)代碼,Relate-upCode

19,FBankAccount,STRING,銀行賬號(hào),銀行賬號(hào),0,0,銀行賬號(hào),BankA/C,銀行賬號(hào),BankA/C

50,FPostalCode,STRING,郵編,郵編,0,0,郵編,Postcode,郵編,Postcode

19,FJobTypeID,INTEGER,工種,,0,0,工種,TypeofWork,,

19,FDuty,INTEGER,職務(wù),職務(wù),0,0,職務(wù),Position,職務(wù),Position

21,FName,STRING,幣別名稱(chēng),幣別名稱(chēng),0,0,幣別名稱(chēng),Curr.Name,幣別名稱(chēng),Curr.Name

22,FCurrencyID,INTEGER,幣別內(nèi)碼,幣別ID,0,0,幣別內(nèi)碼,CurrencyISN,幣別Id,CurrID

50,FfavorPolicy,STRING,優(yōu)惠政策,優(yōu)惠政策,0,0,優(yōu)惠政策,PreferentialPolicy,優(yōu)惠政策,PreferentialPolicy

54,FFeeType,INTEGER,費(fèi)用類(lèi)型,,0,0,費(fèi)用類(lèi)型,ExpType,,

17,FPOHighPrice,FLOAT,采購(gòu)最高價(jià),采購(gòu)最高價(jià),0,0,採(cǎi)購(gòu)最高價(jià),CeilingPurchaseprice,採(cǎi)購(gòu)最高價(jià),CeilingPurchaseprice

18,FBrNo,STRING,公司代碼,公司代碼,1,0,公司代碼,CompanyNo.,公司代碼,CompanyNo.

19,FGender,INTEGER,性別,"1068-男,1069-女",0,0,性別,Gender,"1068-男,1069-女","1068-Male,1069-Female"

19,FCreditLevel,INTEGER,信用級(jí)次,信用級(jí)次,1,0,信用級(jí)次,Grade,信用級(jí)次,Grade

19,FAllotPercent,FLOAT,分配率,,0,0,分配率,AllocationRate,,

19,FItemID,INTEGER,職員內(nèi)碼,職員ID(關(guān)鍵字),0,0,職員內(nèi)碼,EmployeeISN,職員ID(關(guān)鍵字),EmployeeID(keyword)

18,FNumber,STRING,資料代碼,資料代碼,0,0,資料代碼,DataCode,資料代碼,DataCode

19,FLeaveDate,DATETIME,離職日期,離職日期,0,0,離職日期,ResignationDate,離職日期,ResignationDate

19,FBankID,INTEGER,銀行,銀行,0,0,銀行,Bank,銀行,Bank

19,FID,STRING,身份證號(hào)碼,身份證號(hào)碼,0,0,身份證號(hào)碼,IDCode,身份證號(hào)碼,IDCode

54,FBrNO,STRING,公司代碼,,1,0,公司代碼,CompanyNo.,,

55,FParentID,INTEGER,上級(jí)代碼,,0,0,上級(jí)代碼,Relate-upCode,,

17,FTrack,INTEGER,計(jì)價(jià)方法,"76-加權(quán)平均,77-移動(dòng)平均,78-先進(jìn)先出,79-后進(jìn)先出,80-分批認(rèn)定,81-計(jì)劃價(jià)",0,0,計(jì)價(jià)方法,PricingMethod,"76-加權(quán)平均,77-移動(dòng)平均,78-先進(jìn)先出,79-後進(jìn)先出,80-分批認(rèn)定,81-計(jì)畫(huà)價(jià)","76-WeightedAverage,77-MovingAverage,78-FIFO,79-LIFO,80-CertifybyLot,81-PlannedPrice"

19,FIsCreditMgr,INTEGER,是否進(jìn)行信用管理,是否進(jìn)行信用管理,1,0,是否進(jìn)行信用管理,CreditCtrl,是否進(jìn)行信用管理,CreditCtrl

19,FNote,STRING,備注,備注,0,0,備註,Remarks,備註,Remarks

19,FEmpGroup,INTEGER,職員組名稱(chēng),職員組名稱(chēng),0,0,職員組名稱(chēng),EmployeeGroupName,職員組名稱(chēng),EmployeeGroupName

19,FPhone,STRING,電話(huà),電話(huà),0,0,電話(huà),Tel,電話(huà),Tel

19,FBirthday,DATETIME,生日,生日,0,0,生日,Birthday,生日,Birthday

18,FName,STRING,資料名稱(chēng),資料名稱(chēng),0,0,資料名稱(chēng),DataName,資料名稱(chēng),DataName

19,FBrNO,STRING,公司代碼,公司代碼,1,0,公司代碼,CompanyNo.,公司代碼,CompanyNo.

19,FEmail,STRING,郵件地址,郵件地址,0,0,郵件地址,MailAdd,郵件地址,MailAdd

21,FScale,INTEGER,小數(shù)位數(shù),小數(shù)位數(shù),0,0,小數(shù)位數(shù),Decimals,小數(shù)位數(shù),Decimals

28,FObjectType,INTEGER,對(duì)象類(lèi)型編碼,對(duì)象類(lèi)型編碼,1,0,對(duì)象類(lèi)型編碼,ObjectTypeSN,對(duì)象類(lèi)型編碼,ObjectTypeSN

50,FPOGroupID,INTEGER,,,1,0,,,,

17,FIsSparePart,INTEGER,是否備件,,0,0,是否備件,SpareParts,,

18,FExp,STRING,資料內(nèi)容,資料內(nèi)容,0,0,資料內(nèi)容,DataContent,資料內(nèi)容,DataContent

18,FParentID,INTEGER,上級(jí)內(nèi)碼,上級(jí)ID,0,0,上級(jí)內(nèi)碼,Relate-upISN,上級(jí)ID,HigherLevelID

20,FParentID,INTEGER,上級(jí)部門(mén)內(nèi)碼,上級(jí)部門(mén)ID,0,0,上級(jí)部門(mén)內(nèi)碼,Higher-levelDeptISN,上級(jí)部門(mén)ID,Higher-levelDeptID

50,FTrade,INTEGER,行業(yè)代碼,行業(yè)代碼,0,0,行業(yè)代碼,tradeCode,行業(yè)代碼,tradeCode

51,FReportMark,INTEGER,修改標(biāo)記(暫時(shí)沒(méi)用),,1,0,修改標(biāo)記(暫時(shí)沒(méi)用),EditionMark(N/A),,

19,FDepartmentID,INTEGER,部門(mén)內(nèi)碼,部門(mén)ID,0,0,部門(mén)內(nèi)碼,DeptISN,部門(mén)ID,DeptID

19,FDeleted,INTEGER,是否禁用,是否禁用,1,0,是否禁用,Disable,是否禁用,Disable

22,FControl,INTEGER,,,1,0,,,,

22,FSystemType,INTEGER,系統(tǒng)標(biāo)示,,1,0,系統(tǒng)標(biāo)示,SysIdentity,,

22,FUnitGroupID,INTEGER,單位組內(nèi)碼,計(jì)量單位組別ID,0,0,單位組內(nèi)碼,UnitGroupISN,計(jì)量單位組別ID,UoMGroupID

50,FErpClsID,INTEGER,物料類(lèi)別,物料類(lèi)別,0,0,物料類(lèi)別,MtrlCatg.,物料類(lèi)別,MtrlCatg.

19,FAddress,STRING,地址,地址,0,0,地址,Address,地址,Address

21,FCurrencyID,INTEGER,幣別內(nèi)碼,幣別ID(關(guān)鍵字),0,0,幣別內(nèi)碼,CurrencyISN,幣別ID(關(guān)鍵字),CurrID(keyword)

29,FFileName,STRING,文件名,文件名,1,0,檔案名,FileName,檔案名,FileName

31,FCodeRuleNumber,STRING,編碼規(guī)則代號(hào),編碼規(guī)則代號(hào),1,0,編碼規(guī)則代號(hào),CodingRuleCode,編碼規(guī)則代號(hào),CodingRuleCode

55,FFullNumber,STRING,全名,,1,0,全名,FullName,,

56,FOriginWBNO,STRING,原工序計(jì)劃單編號(hào):,原工序計(jì)劃單編號(hào):,0,0,原工序計(jì)畫(huà)單編號(hào):,OriginalOperationPlanSN:,原工序計(jì)畫(huà)單編號(hào):,OriginalOperationPlanSN:

17,FPlanClass,INTEGER,計(jì)劃類(lèi)型,計(jì)劃類(lèi)型,0,0,計(jì)畫(huà)類(lèi)型,PlanType,計(jì)畫(huà)類(lèi)型,PlanType

19,FNumber,STRING,職員代碼,職員代碼,0,0,職員代碼,EmployeeNo.,職員代碼,EmployeeNo.

20,FDProperty,INTEGER,屬性,"1070-車(chē)間,1071-非車(chē)間",0,0,屬性,Attr,"1070-車(chē)間,1071-非車(chē)間","1070-Workshop,1071-Non-workshop"

20,FDStock,INTEGER,部門(mén)庫(kù)房,部門(mén)庫(kù)房,1,0,部門(mén)庫(kù)房,DeptStoreroom,部門(mén)庫(kù)房,DeptStoreroom

20,FShortNumber,STRING,部門(mén)簡(jiǎn)碼,部門(mén)簡(jiǎn)碼,0,0,部門(mén)簡(jiǎn)碼,DeptCode,部門(mén)簡(jiǎn)碼,DeptCode

21,FBrNo,STRING,公司代碼,公司代碼,1,0,公司代碼,CompanyNo.,公司代碼,CompanyNo.

17,FInspectionLevel,INTEGER,檢驗(yàn)方式,檢驗(yàn)方式,0,0,檢驗(yàn)方式,Insp.Mode,檢驗(yàn)方式,Insp.Mode

19,FEmpGroupID,INTEGER,職員組代碼,職員組代碼,0,0,職員組代碼,EmployeeGroupCode,職員組代碼,EmployeeGroupCode

20,FItemID,INTEGER,部門(mén)內(nèi)碼,部門(mén)ID(關(guān)鍵字),0,0,部門(mén)內(nèi)碼,DeptISN,部門(mén)ID(關(guān)鍵字),DeptID(keyword)

22,FInterest,INTEGER,是否利息科目,0-不是,1-是利息科目,0,0,是否利息科目,InterestAccount,0-不是,1-是利息科目,0-No.1-Yes

50,FShortName,STRING,客戶(hù)簡(jiǎn)稱(chēng),客戶(hù)簡(jiǎn)稱(chēng),0,0,客戶(hù)簡(jiǎn)稱(chēng),CustomerAbbre.,客戶(hù)簡(jiǎn)稱(chēng),CustomerAbbre.

50,FHomePage,STRING,公司主頁(yè),公司主頁(yè),0,0,公司主頁(yè),Co.Homepage,公司主頁(yè),Co.Homepage

18,FDeleted,INTEGER,是否禁用,是否禁用,1,0,是否禁用,Disable,是否禁用,Disable

19,FName,STRING,姓名,姓名,0,0,姓名,Name,姓名,Name

22,FAdjustRate,INTEGER,期末調(diào)匯,"0-不,1-要進(jìn)行期末調(diào)匯",0,0,期末調(diào)匯,EOPEx.RTAdj.,"0-不,1-要進(jìn)行期末調(diào)匯",0-No.1-Yes

22,FFullName,STRING,全名,全名,1,0,全名,FullName,全名,FullName

50,FAPAccountID,INTEGER,,,1,0,,,,

50,FPriceClsID,INTEGER,單價(jià)類(lèi)別,單價(jià)類(lèi)別,0,0,單價(jià)類(lèi)別,U/PType,單價(jià)類(lèi)別,U/PType

18,FShortNumber,STRING,資料簡(jiǎn)碼,資料簡(jiǎn)碼,0,0,資料簡(jiǎn)碼,DataCode,資料簡(jiǎn)碼,DataCode

19,FProfessionalGroup,INTEGER,業(yè)務(wù)組,業(yè)務(wù)組,0,0,業(yè)務(wù)組,ServiceTeam,業(yè)務(wù)組,ServiceTeam

20,FBrNO,STRING,公司代碼,公司代碼,1,0,公司代碼,CompanyNo.,公司代碼,CompanyNo.

20,FName,STRING,部門(mén)名稱(chēng),部門(mén)名稱(chēng),0,0,部門(mén)名稱(chēng),Dept.NM,部門(mén)名稱(chēng),Dept.NM

50,FAccount,STRING,銀行賬號(hào),銀行賬號(hào),0,0,銀行賬號(hào),BankA/C,銀行賬號(hào),BankA/C

50,FParentID,INTEGER,上級(jí)內(nèi)碼,上級(jí)ID,0,0,上級(jí)內(nèi)碼,Relate-upISN,上級(jí)ID,HigherLevelID

17,FBatChangeEconomy,FLOAT,變動(dòng)提前期批量,,0,0,變動(dòng)提前期批量,LotSizeforDynamicLeadTime,,

19,FShortNumber,STRING,職員簡(jiǎn)碼,職員簡(jiǎn)碼,0,0,職員簡(jiǎn)碼,EmployeeCode,職員簡(jiǎn)碼,EmployeeCode

19,FDegree,INTEGER,文化程度,文化程度,0,0,文化程度,EducationDeg,文化程度,EducationDeg

20,FModifyTime,UnKnown,,,1,0,,,,

20,FCalID,INTEGER,工廠日歷,,0,0,工廠日曆,ShopCalendar,,

51,FModifyDate,DATETIME,修改日期,,1,0,修改日期,EditionDate,,

17,FLeadTime,FLOAT,提前期,提前期,0,0,提前期,LeadTime,提前期,LeadTime

17,FAPAcctID,INTEGER,應(yīng)付科目,應(yīng)付科目ID,0,0,應(yīng)付科目,APAccount,應(yīng)付科目ID,APAccountID

17,FARAcctID,INTEGER,應(yīng)收科目,應(yīng)收科目ID,0,0,應(yīng)收科目,ARAccount,應(yīng)收科目ID,ARAccountID

17,FProChkMde,INTEGER,產(chǎn)品檢驗(yàn)方式,,0,0,產(chǎn)品檢驗(yàn)方式,ProductInspectionMode,,

50,FIsCreditMgr,INTEGER,是否進(jìn)行信用管理,是否進(jìn)行信用管理,0,0,是否進(jìn)行信用管理,CreditCtrl,是否進(jìn)行信用管理,CreditCtrl

50,FendTradeDate,DATETIME,最后交易日期,,0,0,最後交易日期,LastBusinessDate,,

17,FSaleTaxAcctID,INTEGER,稅金科目,銷(xiāo)售稅金科目ID,0,0,稅金科目,TaxAccount,銷(xiāo)售稅金科目ID,SalesTaxesAccountID

17,FMaund,INTEGER,重量單位,重量單位,0,0,重量單位,WeightUnit,重量單位,WeightUnit

17,FOrderInterVal,INTEGER,訂貨間隔期(天),訂貨間隔期(天),0,0,訂貨間隔期(天),OrderPeriod(Days),訂貨間隔期(天),OrderPeriod(Days)

17,FLowestBomCode,INTEGER,低層碼,物料在產(chǎn)品結(jié)構(gòu)中的最低層次,0,0,低層碼,LowLevelCode,物料在產(chǎn)品結(jié)構(gòu)中的最低層次,LowestLeveloftheMaterialinProductStrc

17,FSalePriceFixingType,INTEGER,,,1,0,,,,

17,FTopID,INTEGER,最高級(jí),最高級(jí),0,0,最高級(jí),Highest,最高級(jí),Highest

17,FStdPayRate,FLOAT,標(biāo)準(zhǔn)工資率,,0,0,標(biāo)準(zhǔn)工資率,StandardWageRate,,

17,FNetWeight,FLOAT,凈重,凈重,0,0,淨(jìng)重,NetWeight,淨(jìng)重,NetWeight

17,FBrNo,STRING,公司代碼,公司代碼,1,0,公司代碼,CompanyNo.,公司代碼,CompanyNo.

17,FSalePrice,FLOAT,銷(xiāo)售單價(jià),銷(xiāo)售單價(jià),0,0,銷(xiāo)售單價(jià),SellingU/P,銷(xiāo)售單價(jià),SellingU/P

17,FIdentifier,INTEGER,檢驗(yàn)員,檢驗(yàn)員,0,0,檢驗(yàn)員,Inspector,檢驗(yàn)員,Inspector

17,FBatchQty,FLOAT,訂貨批量,訂貨、生產(chǎn)批量,0,0,訂貨批量,OrderLotSize,訂貨、生產(chǎn)批量,BatchOrderandProduction

17,FRP,INTEGER,收付標(biāo)志,收付標(biāo)志,0,0,收付標(biāo)誌,PaymentFlag,收付標(biāo)誌,PaymentFlag

17,FPlanPriceMethod,INTEGER,計(jì)劃方法,計(jì)劃方法,0,0,計(jì)畫(huà)方法,PlanMethod,計(jì)畫(huà)方法,PlanMethod

17,FIsListControl,INTEGER,,,1

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶(hù)所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶(hù)上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶(hù)上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶(hù)因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論