金蝶數(shù)據(jù)字典

子系統(tǒng)ID,表ID,表名,表描述,表說(shuō)明,萬(wàn)能報(bào)表,字段名,字段類(lèi)型,字段描述,字段說(shuō)明,字段是否萬(wàn)能報(bào)表

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FDescription,STRING,描述,描述,0

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FDate,datetime,日期,日期,0

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FStockID,INTEGER,倉(cāng)庫(kù)內(nèi)碼,倉(cāng)庫(kù)內(nèi)碼,0

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FStockName,STRING,倉(cāng)庫(kù)名稱(chēng),倉(cāng)庫(kù)名稱(chēng),0

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FItemName,STRING,報(bào)表項(xiàng)目名稱(chēng),報(bào)表項(xiàng)目名稱(chēng),0

0,53,CalculateLog,計(jì)算記錄表,計(jì)算記錄表,0,FBatchNo,STRING,批號(hào),批號(hào)（關(guān)鍵字四）,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FScreenID,STRING,單據(jù)模板內(nèi)碼,,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FCreatorName,STRING,創(chuàng)建人,創(chuàng)建人,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FCreateDate,datetime,創(chuàng)建日期,創(chuàng)建日期,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FData,UnKnown,套打設(shè)置數(shù)據(jù),套打設(shè)置數(shù)據(jù),0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FNewBillType,INTEGER,新單據(jù)類(lèi)型,,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FName,STRING,名稱(chēng),名稱(chēng),0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FModifierName,STRING,修改人,修改人,0

0,54,COM_Note,套打數(shù)據(jù)表,套打數(shù)據(jù)表,0,FModifyDate,datetime,修改日期,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FInEntry,BOOLEAN,當(dāng)前字段是否是分錄,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FIsMoney,BOOLEAN,是否是金額,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FIsSum,BOOLEAN,是否要合計(jì),,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FCitationName_CHT,其它,,,1

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FNoteTypeID,INTEGER,套打類(lèi)型ID,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FTableName,STRING,表名,表名,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FTemplateID,STRING,模板內(nèi)碼,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FCode,STRING,編碼,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FCitationName,STRING,套打模板取數(shù)名稱(chēng),,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FCtlIndex,INTEGER,在單據(jù)中的位置,,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FRelationID,smallint,屬性標(biāo)識(shí),：表頭2：表體3：匯總4：擴(kuò)展表頭5：主計(jì)量單位6：主計(jì)量單位數(shù)量7：主計(jì)量單位單價(jià)8：擴(kuò)展分錄,0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FKeyFieldName,STRING,擴(kuò)展字段,表示要取FtableName表中的FextFieldName字段，通過(guò)FkeyFieldName字段與當(dāng)前字段關(guān)聯(lián),0

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FExtFieldName,STRING,,,1

0,61,GLNoteCitation,單據(jù)套打關(guān)系表,單據(jù)套打關(guān)系表,0,FCitationName_EN,其它,,,1

0,126,GLNoteType,單據(jù)套打表,單據(jù)套打表,0,FNoteType_CHT,STRING,套打類(lèi)型,,0

0,126,GLNoteType,單據(jù)套打表,單據(jù)套打表,0,FNoteType_EN,STRING,套打類(lèi)型,,0

0,126,GLNoteType,單據(jù)套打表,單據(jù)套打表,0,FTemplateID,STRING,模板內(nèi)碼,,0

0,126,GLNoteType,單據(jù)套打表,單據(jù)套打表,0,FNoteType,STRING,套打類(lèi)型,,0

0,126,GLNoteType,單據(jù)套打表,單據(jù)套打表,0,FNoteTypeID,INTEGER,套打類(lèi)型內(nèi)碼,,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYear,INTEGER,會(huì)計(jì)年度,會(huì)計(jì)年度（關(guān)鍵字一）,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYtdCredit,FLOAT,本年發(fā)出金額,本年發(fā)出金額,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FEndQty,FLOAT,期末結(jié)存數(shù)量,期末結(jié)存數(shù)量,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FBegBal,FLOAT,期初余額,期初余額,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FBatchNo,STRING,批號(hào),批號(hào)（關(guān)鍵字四）,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FPeriod,INTEGER,會(huì)計(jì)期間,會(huì)計(jì)期間（關(guān)鍵字二）,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYtdSend,FLOAT,本年發(fā)出數(shù)量,本年累計(jì)發(fā)出數(shù)量,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYtdReceive,FLOAT,本年收貨數(shù)量,本年累計(jì)收貨數(shù)量,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYtdDebit,FLOAT,本年收入金額,本年收入金額,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FSendDiff,FLOAT,本期發(fā)出成本差異,本期發(fā)出材料成本差異,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FSend,FLOAT,本期發(fā)出數(shù)量,本期發(fā)出數(shù)量,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FReceiveDiff,FLOAT,本期收入成本差異,本期收入材料成本差異,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FReceive,FLOAT,本期收貨數(shù)量,本期收貨數(shù)量,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FEntryID,INTEGER,序號(hào),序號(hào),0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FEndDiff,FLOAT,期末結(jié)存成本差異,期末結(jié)存材料成本差異,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FEndBal,FLOAT,期末余額,期末余額,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FDebit,FLOAT,本期收入金額,本期收入金額,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FCredit,FLOAT,本期發(fā)出金額,本期發(fā)出金額,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FBegQty,FLOAT,期初結(jié)存數(shù)量,期初結(jié)存數(shù)量,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FBegDiff,FLOAT,期初結(jié)存成本差異,期初結(jié)存材料成本差異,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FBillInterID,INTEGER,順序號(hào),順序號(hào),0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FStockGroupID,INTEGER,倉(cāng)庫(kù)組內(nèi)碼,倉(cāng)庫(kù)組內(nèi)碼,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYtdReceiveDiff,FLOAT,本年收入差異,本年收入差異,0

21,210001,ICBal,存貨余額表,存貨收發(fā)存數(shù)量、金額,0,FYtdSendDiff,FLOAT,本年發(fā)出差異,本年發(fā)出差異,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FCurNo,INTEGER,當(dāng)前單號(hào),,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FBillName_CHT,STRING,單據(jù)名稱(chēng),,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FBillName_EN,STRING,單據(jù)名稱(chēng),,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FDesc,STRING,描述,描述,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FIsAutoFillNo,SMALLINT,是否自動(dòng)填充單據(jù)號(hào),,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FAutoZeroFlag,SMALLINT,是否自動(dòng)以0補(bǔ)全,,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FSufLetter,STRING,后綴,,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FCanAlterBillNo,SMALLINT,是否允許修改單據(jù)號(hào),,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FCheckAfterSave,SMALLINT,是否自動(dòng)審核,,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FUseBillCodeRule,SMALLINT,是否使用編碼規(guī)則,,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FFormat,STRING,格式,格式,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FBillName,STRING,單據(jù)名稱(chēng),,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FBillID,INTEGER,單據(jù)內(nèi)部ID,單據(jù)內(nèi)部ID,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FPreLetter,STRING,前綴,,0

0,62,ICBillNo,單據(jù)編碼表,單據(jù)編碼表,0,FPos,INTEGER,位置,,0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FBillId,INTEGER,單據(jù)內(nèi)部ID,單據(jù)內(nèi)部ID,0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FName,STRING,名稱(chēng),名稱(chēng),0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FData,STRING,套打設(shè)置數(shù)據(jù),套打設(shè)置數(shù)據(jù),0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FDate,datetime,日期,日期,0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FId,INTEGER,內(nèi)碼,內(nèi)碼,0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FBillType,INTEGER,單據(jù)類(lèi)型,單據(jù)類(lèi)型,0

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FPrintSet,其它,,,1

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FBillTypeSub,STRING,,,1

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FSel,INTEGER,,,1

0,186,ICBillNote,單據(jù)套打表,單據(jù)套打表,0,FPreparerId,INTEGER,制單人,制單人,0

21,210017,ICBillType,單據(jù)類(lèi)型表,單據(jù)類(lèi)型表,0,FAcctID,INTEGER,會(huì)計(jì)科目,會(huì)計(jì)科目,0

21,210017,ICBillType,單據(jù)類(lèi)型表,單據(jù)類(lèi)型表,0,FSystemic,INTEGER,是否系統(tǒng)預(yù)設(shè),0：否1：是,0

21,210017,ICBillType,單據(jù)類(lèi)型表,單據(jù)類(lèi)型表,0,FNote,STRING,備注,備注,0

21,210017,ICBillType,單據(jù)類(lèi)型表,單據(jù)類(lèi)型表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

21,210017,ICBillType,單據(jù)類(lèi)型表,單據(jù)類(lèi)型表,0,FNumber,STRING,編碼,編碼,0

21,210017,ICBillType,單據(jù)類(lèi)型表,單據(jù)類(lèi)型表,0,FName,STRING,名稱(chēng),名稱(chēng),0

25,250000,ICBOM,BOM表,,0,FYield,FLOAT,成品率,成品率,0

25,250000,ICBOM,BOM表,,0,FStatus,INTEGER,狀態(tài),狀態(tài),1

25,250000,ICBOM,BOM表,,0,FCheckID,INTEGER,新建人員,新建人員,0

25,250000,ICBOM,BOM表,,0,FParentID,INTEGER,BOM上級(jí)代碼,BOM上級(jí)代碼,0

25,250000,ICBOM,BOM表,,0,FUseStatus,INTEGER,使用狀態(tài),使用狀態(tài),0

25,250000,ICBOM,BOM表,,0,FVersion,STRING,版本號(hào),版本號(hào),0

25,250000,ICBOM,BOM表,,0,FCustItemID,INTEGER,客戶(hù)物料內(nèi)碼,客戶(hù)物料內(nèi)碼,0

25,250000,ICBOM,BOM表,,0,FEcnInterID,INTEGER,ECN內(nèi)碼,ECN內(nèi)碼,0

25,250000,ICBOM,BOM表,,0,FEnterTime,DATETIME,最近修改時(shí)間,最近修改時(shí)間,0

25,250000,ICBOM,BOM表,,0,FTranType,INTEGER,模版類(lèi)型,模版類(lèi)型,0

25,250000,ICBOM,BOM表,,0,FunitID,INTEGER,單位,單位,0

25,250000,ICBOM,BOM表,,0,FQty,FLOAT,數(shù)量,數(shù)量,0

25,250000,ICBOM,BOM表,,0,FRoutingID,INTEGER,工藝路線,工藝路線,0

25,250000,ICBOM,BOM表,,0,FInterID,INTEGER,BOM內(nèi)碼,BOM內(nèi)碼,0

25,250000,ICBOM,BOM表,,0,FCheckerID,INTEGER,審核人,審核人,0

25,250000,ICBOM,BOM表,,0,FCustID,INTEGER,客戶(hù)代碼,客戶(hù)代碼,0

25,250000,ICBOM,BOM表,,0,FBomType,INTEGER,BOM單類(lèi)型,"0-普通,1-配置類(lèi),2-生產(chǎn)規(guī)劃類(lèi),3-客戶(hù)BOM,4-特征類(lèi)",0

25,250000,ICBOM,BOM表,,0,FBrNo,STRING,機(jī)構(gòu)代碼,無(wú)用,0

25,250000,ICBOM,BOM表,,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

25,250000,ICBOM,BOM表,,0,FNote,STRING,備注,備注,0

25,250000,ICBOM,BOM表,,0,FOperatorID,INTEGER,最近修改人,最近修改人,0

25,250000,ICBOM,BOM表,,0,FCheckDate,DATETIME,新建時(shí)間,新建時(shí)間,0

25,250000,ICBOM,BOM表,,0,FCancellation,INTEGER,作廢標(biāo)志,,1

25,250000,ICBOM,BOM表,,0,FAccessories,INTEGER,附件代碼,附件代碼,0

25,250000,ICBOM,BOM表,,0,FAudDate,DATETIME,審核時(shí)間,審核時(shí)間,0

25,250000,ICBOM,BOM表,,0,FAuxQty,FLOAT,數(shù)量,數(shù)量,0

25,250000,ICBOM,BOM表,,0,FBOMNumber,STRING,BOM單號(hào),BOM單號(hào),0

25,250000,ICBOM,BOM表,,0,FBOMSkip,SMALLINT,跳層,跳層,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FHasChar,SMALLINT,是否有特性,是否有特性,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FMarshalType,INTEGER,配置屬性,缺省為通用,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FAuxQty,FLOAT,顯示用量,顯示用量,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FBackFlush,INTEGER,是否倒沖,是否倒沖,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FBeginDay,DATETIME,生效日期,生效日期,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FEntryID,INTEGER,BOM單分錄號(hào),BOM單分錄號(hào),1

25,250001,ICBOMCHILD,BOM分錄表,,0,FOperSN,INTEGER,工序號(hào),工序號(hào),0

25,250001,ICBOMCHILD,BOM分錄表,,0,FPercent,FLOAT,計(jì)劃百分比,計(jì)劃百分比,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FQty,FLOAT,用量,標(biāo)準(zhǔn)單位,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FEndDay,DATETIME,失效日期,失效日期,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FInterID,INTEGER,所屬BOM內(nèi)碼,所屬BOM內(nèi)碼,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FMaterielType,INTEGER,物料類(lèi)型,缺省為普通類(lèi),0

25,250001,ICBOMCHILD,BOM分錄表,,0,FUnitID,INTEGER,單位內(nèi)碼,,1

25,250001,ICBOMCHILD,BOM分錄表,,0,FSPID,INTEGER,發(fā)料倉(cāng)位,發(fā)料倉(cāng)位,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FStockID,INTEGER,發(fā)料倉(cāng)庫(kù),發(fā)料倉(cāng)庫(kù),0

25,250001,ICBOMCHILD,BOM分錄表,,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FMachinePos,STRING,缺省工位,缺省工位,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FBrNo,STRING,機(jī)構(gòu)代碼,無(wú)用,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FNote,STRING,備注信息,備注信息,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FOffSetDay,FLOAT,提前期偏置,提前期偏置,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FOperID,INTEGER,工序,工序,0

25,250001,ICBOMCHILD,BOM分錄表,,0,FSupply,INTEGER,來(lái)源,來(lái)源,1

25,250001,ICBOMCHILD,BOM分錄表,,0,FScrap,FLOAT,BOM內(nèi)碼,損耗率,0

25,250002,ICBOMGROUP,BOM組別表,,0,FName,STRING,組別名稱(chēng),,0

25,250002,ICBOMGROUP,BOM組別表,,0,FBootID,INTEGER,BOM根組內(nèi)碼,,1

25,250002,ICBOMGROUP,BOM組別表,,0,FInterID,INTEGER,組別內(nèi)碼,,0

25,250002,ICBOMGROUP,BOM組別表,,0,FNumber,STRING,編碼,編碼,0

25,250002,ICBOMGROUP,BOM組別表,,0,FParentID,INTEGER,上級(jí)組內(nèi)碼,,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FBillNo,STRING,單據(jù)號(hào),單據(jù)號(hào),0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FDate,datetime,日期,日期,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FClassTypeID,INTEGER,事務(wù)類(lèi)型,,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FTranType,INTEGER,單據(jù)類(lèi)型,單據(jù)類(lèi)型,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FNote,STRING,備注,備注,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FCheckerID,INTEGER,審核人,審核人,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FEmpID,INTEGER,關(guān)聯(lián)職員ID,關(guān)聯(lián)職員ID,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FStatus,INTEGER,狀態(tài),狀態(tài),0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FDeptID,INTEGER,部門(mén)內(nèi)碼,部門(mén)內(nèi)碼,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FCurrencyID,INTEGER,幣別,幣別ID,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FCheck,INTEGER,是否驗(yàn)證,,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FBillerID,INTEGER,制模板人,,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FCheckDate,datetime,核銷(xiāo)日期,核銷(xiāo)日期,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FFee,FLOAT,單位成本（元）,,0

0,55,ICChange,轉(zhuǎn)換單表,轉(zhuǎn)換單表,0,FExchangeRate,FLOAT,匯率,匯率,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FColWidth,INTEGER,列寬,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FName,STRING,名稱(chēng),名稱(chēng),0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FControl,INTEGER,該字段類(lèi)型,0 普通字段1 憑證字段2 帶有Action字段的字段4，5 數(shù)量、金額7 關(guān)閉標(biāo)志,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FControlType,INTEGER,控件類(lèi)型,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FMode,INTEGER,,,1

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FFormatType,INTEGER,格式類(lèi)型,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FPrecisionField,STRING,精度字段,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FAlign,INTEGER,對(duì)方方式,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FEditable,BOOLEAN,是否可編輯,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FStatistical,smallint,統(tǒng)計(jì),,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FMergeable,smallint,當(dāng)前列是否需要將同一張單據(jù)中相同的數(shù)據(jù)合并,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FVisForOrder,BOOLEAN,是否作為排序字段，0--否，1--是,是否作為排序字段，0--否，1--是,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FColCaption_CHT,STRING,對(duì)應(yīng)的庫(kù)表字段別名,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FColCaption_EN,STRING,對(duì)應(yīng)的庫(kù)表字段別名,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FCtlIndex,INTEGER,在單據(jù)中的位置,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FTableAlias,STRING,表別名,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FAction,STRING,作用,作用,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FNeedCount,BOOLEAN,是否需要合計(jì)，0--不需要，1--需要,是否需要合計(jì)，0--不需要，1--需要,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FIsPrimary,INTEGER,是否主鍵,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FCountPriceType,INTEGER,金額是否可見(jiàn),,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FFormat,STRING,格式,格式,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FLogicAction,STRING,邏輯動(dòng)作,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FTableName,STRING,對(duì)應(yīng)的庫(kù)表名,表名,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FColType,smallint,列類(lèi)型,0 日期1 文本2 數(shù)量（帶小數(shù)）3 整數(shù)4 金額5 折扣率6 單價(jià)8 工時(shí)（損耗率）9 匯率10 年利率11 稅率12 規(guī)格上下限,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FVisible,smallint,是否可見(jiàn),,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FItemClassID,INTEGER,核算項(xiàng)目類(lèi)別內(nèi)碼,核算項(xiàng)目類(lèi)別內(nèi)部ID，關(guān)聯(lián)t_ItemClass表FItemClassID,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FVisForQuest,smallint,該列是否可作為過(guò)濾條件,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FReturnDataType,smallint,通過(guò)F7查詢(xún)所返回的數(shù)據(jù)的類(lèi)型,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FInterID,INTEGER,內(nèi)碼,內(nèi)碼(關(guān)鍵字),0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FTypeID,INTEGER,模板代碼,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FColCaption,STRING,列頭,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FHeadSecond,STRING,二級(jí)模板表頭,,0

0,57,ICChatBillTitle,序時(shí)薄模板表,序時(shí)薄模板表,0,FColName,STRING,對(duì)應(yīng)的庫(kù)表字段別名,,0

0,64,ICConstDesc,靜態(tài)字段描述表,靜態(tài)字段描述表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,64,ICConstDesc,靜態(tài)字段描述表,靜態(tài)字段描述表,0,FName,STRING,名稱(chēng),名稱(chēng),0

0,64,ICConstDesc,靜態(tài)字段描述表,靜態(tài)字段描述表,0,FValue,STRING,參數(shù)值,鍵值代碼對(duì)應(yīng)的值,0

0,64,ICConstDesc,靜態(tài)字段描述表,靜態(tài)字段描述表,0,FDesc,STRING,描述,描述,0

0,66,ICFont,字體表,字體表,0,FBold,BOOLEAN,加粗,,0

0,66,ICFont,字體表,字體表,0,FSize,smallint,大小,大小,0

0,66,ICFont,字體表,字體表,0,FItalic,BOOLEAN,斜體,,0

0,66,ICFont,字體表,字體表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,66,ICFont,字體表,字體表,0,FColor,INTEGER,顏色,,0

0,66,ICFont,字體表,字體表,0,FName_CHT,STRING,名稱(chēng),,0

0,66,ICFont,字體表,字體表,0,FName,STRING,名稱(chēng),名稱(chēng),0

0,66,ICFont,字體表,字體表,0,FName_EN,STRING,名稱(chēng),,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FBillInterID,INTEGER,順序號(hào),順序號(hào),0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FPrice,FLOAT,單價(jià),單價(jià),0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FAmount,FLOAT,金額,金額,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FKFPeriod,FLOAT,保質(zhì)期(天),保質(zhì)期(天),0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FQty,FLOAT,鎖庫(kù)數(shù)量,鎖庫(kù)數(shù)量,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FSecCoefficient,FLOAT,換算率,,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FSecQty,FLOAT,輔助數(shù)量,輔助數(shù)量,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FDestDate,STRING,有效期至,,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FStockInDate,STRING,入庫(kù)日期,,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FBrNo,STRING,代碼,代碼,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FBatchNo,STRING,批號(hào),批號(hào)（關(guān)鍵字四）,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FKFDate,STRING,生產(chǎn)日期,生產(chǎn)日期,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FPeriod,smallint,會(huì)計(jì)期間,會(huì)計(jì)期間,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FSPID,INTEGER,缺省倉(cāng)位,缺省倉(cāng)位,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FAuxPropID,INTEGER,輔助屬性?xún)?nèi)碼,輔助屬性?xún)?nèi)碼,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FSNListID,INTEGER,流水號(hào),[已停用],0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FStockID,INTEGER,倉(cāng)庫(kù)內(nèi)碼,倉(cāng)庫(kù)內(nèi)碼,0

0,68,ICInvInitial,初始化數(shù)據(jù)表,,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

26,260001,ICItemAuxProp,物料輔助屬性?huà)旖颖?記錄物料已經(jīng)登記的可以在業(yè)務(wù)中使用的輔助屬性,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

26,260001,ICItemAuxProp,物料輔助屬性?huà)旖颖?記錄物料已經(jīng)登記的可以在業(yè)務(wù)中使用的輔助屬性,0,FAuxPropID,INTEGER,輔助屬性?xún)?nèi)碼,,0

26,260001,ICItemAuxProp,物料輔助屬性?huà)旖颖?記錄物料已經(jīng)登記的可以在業(yè)務(wù)中使用的輔助屬性,0,FTimeStamp,UnKnown,時(shí)間戳,,1

0,69,ICMaxNum,最大號(hào)碼表,最大號(hào)碼表,0,FTableName,STRING,表名,表名,0

0,69,ICMaxNum,最大號(hào)碼表,最大號(hào)碼表,0,FMaxNum,INTEGER,最大號(hào)碼,,0

0,70,ICPrintCount,打印次數(shù)表,打印次數(shù)表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,70,ICPrintCount,打印次數(shù)表,打印次數(shù)表,0,FInterID,INTEGER,資料內(nèi)碼,資料內(nèi)碼(關(guān)鍵字),0

0,70,ICPrintCount,打印次數(shù)表,打印次數(shù)表,0,FPrintCount,INTEGER,打印次數(shù),,0

0,71,ICPrintCountEntry,打印次數(shù)分錄表,打印次數(shù)分錄表,0,FPrintTime,datetime,打印時(shí)間,,0

0,71,ICPrintCountEntry,打印次數(shù)分錄表,打印次數(shù)分錄表,0,FUserID,INTEGER,用戶(hù)內(nèi)碼,用戶(hù)內(nèi)部ID,0

0,71,ICPrintCountEntry,打印次數(shù)分錄表,打印次數(shù)分錄表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,71,ICPrintCountEntry,打印次數(shù)分錄表,打印次數(shù)分錄表,0,FInterID,INTEGER,資料內(nèi)碼,資料內(nèi)碼(關(guān)鍵字),0

0,71,ICPrintCountEntry,打印次數(shù)分錄表,打印次數(shù)分錄表,0,FPrintCopies,INTEGER,打印數(shù)量,,0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FPrintMaxCount,INTEGER,打印最大數(shù)量,,0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FPos,INTEGER,打印位置,,0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FPrintControlOrNo,INTEGER,是否打印控制,,0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FName_CHT,STRING,名稱(chēng),,0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FName,STRING,名稱(chēng),名稱(chēng),0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FName_EN,STRING,名稱(chēng),,0

0,72,ICPrintMaxCount,最大打印數(shù)量表,最大打印數(shù)量表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,154,ICRelations,[未知],,0,FDate,datetime,日期,日期,0

0,154,ICRelations,[未知],,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,154,ICRelations,[未知],,0,FEntry,INTEGER,單據(jù)體順序號(hào),,0

0,154,ICRelations,[未知],,0,FGroupNo,INTEGER,鉤稽序號(hào),,0

0,154,ICRelations,[未知],,0,FClassTypeID,INTEGER,事務(wù)類(lèi)型,,0

0,154,ICRelations,[未知],,0,FBillTypeID,INTEGER,明細(xì)類(lèi)型,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FSum,STRING,合計(jì)字段名,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FBillType,STRING,單據(jù)類(lèi)型,單據(jù)類(lèi)型,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FDetailRptName_EN,STRING,詳細(xì)報(bào)表名稱(chēng),,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FEObjectID,INTEGER,[已停用],,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FVis,smallint,[已停用],,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FTemplateID,INTEGER,模板內(nèi)碼,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FObjectID,INTEGER,系統(tǒng)明細(xì)對(duì)象ID,系統(tǒng)明細(xì)對(duì)象ID,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FInterID,INTEGER,資料內(nèi)碼,資料內(nèi)碼(關(guān)鍵字),0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FEObjectType,INTEGER,[已停用],,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptGrpID,INTEGER,報(bào)表組內(nèi)碼,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FObjectType,INTEGER,系統(tǒng)一級(jí)對(duì)象代碼,系統(tǒng)一級(jí)對(duì)象代碼,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptName_CHT,STRING,報(bào)表名,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptName_EN,STRING,報(bào)表名,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FDetailRptName_CHT,STRING,詳細(xì)報(bào)表名稱(chēng),,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FCountPriceType,smallint,金額是否可見(jiàn),,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FMergeCol,smallint,[已停用],,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptType,smallint,報(bào)表類(lèi)型,報(bào)表類(lèi)型,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptProperty,smallint,報(bào)表類(lèi)型,1：明細(xì)表；2：匯總表；3：統(tǒng)計(jì)表,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptStyle,smallint,報(bào)表樣式,,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FProcedure,STRING,報(bào)表實(shí)例名稱(chēng),,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FMProcedureEx,STRING,[已停用],,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FNote,STRING,備注字段名,備注,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FMProcedure,STRING,[已停用],,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FRptName,STRING,報(bào)表名,報(bào)表名,0

0,117,ICReport,報(bào)表信息表,報(bào)表信息表,0,FDetailRptName,STRING,詳細(xì)報(bào)表名稱(chēng),,0

22,220001,ICReportFormat,報(bào)表格式保存,,1,FUserID,INTEGER,用戶(hù)ID,,1

22,220001,ICReportFormat,報(bào)表格式保存,,1,FProfile,UnKnown,格式字符串,,1

22,220001,ICReportFormat,報(bào)表格式保存,,1,FSection,STRING,章節(jié),,1

22,220001,ICReportFormat,報(bào)表格式保存,,1,FRptID,INTEGER,報(bào)表ID,,1

0,118,ICReportGroup,報(bào)表組,報(bào)表組,0,FParentID,INTEGER,上級(jí)內(nèi)碼,上級(jí)內(nèi)碼,0

0,118,ICReportGroup,報(bào)表組,報(bào)表組,0,FRptGrpID,INTEGER,報(bào)表組內(nèi)碼,,0

0,118,ICReportGroup,報(bào)表組,報(bào)表組,0,FRptType,INTEGER,報(bào)表類(lèi)型,報(bào)表類(lèi)型,0

0,118,ICReportGroup,報(bào)表組,報(bào)表組,0,FRptGrpName,STRING,報(bào)表組名稱(chēng),,0

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FCaption_CHT,其它,名稱(chēng),,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FCaption_EN,其它,名稱(chēng),,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FValueType,INTEGER,值類(lèi)型,,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FBaseField,INTEGER,取數(shù)字段,,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FDataSource,INTEGER,數(shù)據(jù)源,,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FInterID,INTEGER,內(nèi)碼,,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FSourceSql,STRING,取數(shù)sql,,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FCaption,STRING,名稱(chēng),,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FKeyword,STRING,關(guān)鍵字代碼,,1

22,220002,ICReportKeywords,直接SQL關(guān)鍵字,,1,FSourceField,STRING,取數(shù)字段,,1

0,155,ICReportProfile,報(bào)表設(shè)置表,報(bào)表設(shè)置表,0,FRptID,INTEGER,報(bào)表ID,報(bào)表ID,0

0,155,ICReportProfile,報(bào)表設(shè)置表,報(bào)表設(shè)置表,0,FUserID,INTEGER,用戶(hù)內(nèi)碼,用戶(hù)內(nèi)部ID,0

0,155,ICReportProfile,報(bào)表設(shè)置表,報(bào)表設(shè)置表,0,FStatus,INTEGER,狀態(tài),狀態(tài),0

0,155,ICReportProfile,報(bào)表設(shè)置表,報(bào)表設(shè)置表,0,FPlan,STRING,過(guò)濾器名稱(chēng),,0

0,155,ICReportProfile,報(bào)表設(shè)置表,報(bào)表設(shè)置表,0,FKey,STRING,鍵值代碼,鍵值代碼(關(guān)鍵字二),0

0,155,ICReportProfile,報(bào)表設(shè)置表,報(bào)表設(shè)置表,0,FValue,STRING,參數(shù)值,鍵值代碼對(duì)應(yīng)的值,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FDay,INTEGER,抵銷(xiāo)分錄日期,抵銷(xiāo)分錄日期,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FID,INTEGER,內(nèi)碼,內(nèi)碼,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FEntryID,INTEGER,分錄號(hào),分錄號(hào)(關(guān)鍵字二),0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FStockID,INTEGER,倉(cāng)庫(kù)內(nèi)碼,倉(cāng)庫(kù)內(nèi)碼,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FQty,FLOAT,鎖庫(kù)數(shù)量,鎖庫(kù)數(shù)量,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FAmount,FLOAT,本位幣金額,金額（本位幣）,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FClassTypeID,INTEGER,事務(wù)類(lèi)型,,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FBillTypeID,INTEGER,明細(xì)類(lèi)型,,0

0,60,ICSpeedBal,核算加速表,核算加速表,0,FTableName,STRING,表名,表名,0

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FTplType,INTEGER,事務(wù)類(lèi)型,,1

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FFieldName,STRING,科目對(duì)應(yīng)的字段名,,1

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FName,STRING,名稱(chēng),,1

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FName_EN,STRING,名稱(chēng),,1

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FDC,INTEGER,往來(lái)科目默認(rèn)借貸方向,,1

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FName_CHT,STRING,名稱(chēng),,1

22,220003,ICVoucherTAcct,憑證科目來(lái)源,憑證科目來(lái)源,1,FInterID,INTEGER,內(nèi)碼,,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FItemClassID,INTEGER,核算項(xiàng)目,,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FNumber,STRING,編碼,編碼,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FIsEntry,INTEGER,是否分錄字段,,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FEntryID,INTEGER,分錄號(hào),,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FInterID,INTEGER,憑證模板內(nèi)碼,,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FFieldName,STRING,核算項(xiàng)目對(duì)應(yīng)字段名,,1

22,220004,ICVoucherTAudit,憑證模板核算項(xiàng)目,憑證模板核算項(xiàng)目,1,FName,STRING,核算項(xiàng)目名稱(chēng),,1

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FAuditName_EN,STRING,核算字段名稱(chēng),,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FAuditName_CHT,STRING,核算字段名稱(chēng),,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FIsEntry,BOOLEAN,是否分錄字段,,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FIsUserDefine,BOOLEAN,是否用戶(hù)定義,,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FBillType,INTEGER,單據(jù)類(lèi)型,單據(jù)類(lèi)型,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FAuditName,STRING,核算字段名稱(chēng),,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FItemClassID,INTEGER,核算項(xiàng)目類(lèi)別內(nèi)碼,核算項(xiàng)目類(lèi)別內(nèi)部ID，關(guān)聯(lián)t_ItemClass表FItemClassID,0

0,158,ICVoucherTBill,憑證核算單據(jù)來(lái)源表,憑證核算單據(jù)來(lái)源表,0,FAuditField,STRING,核算字段,,0

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FUserDefineField,STRING,用戶(hù)定義取數(shù)SQL,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FAmountFor,STRING,本位幣取數(shù)SQL,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FField,STRING,取金額SQL,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FFieldName,STRING,名稱(chēng),,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FSampleAmount,FLOAT,驗(yàn)證憑證是否平,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FBillType,INTEGER,單據(jù)類(lèi)型,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FInterID,INTEGER,內(nèi)碼,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FTplType,INTEGER,事務(wù)類(lèi)型,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FCountPrice,INTEGER,計(jì)價(jià)類(lèi)型,,1

22,220006,ICVoucherTField,憑證金額來(lái)源,憑證金額來(lái)源,1,FIsUserDefine,INTEGER,是否用戶(hù)定義,,1

22,220011,ICVoucherTNote,憑證備注來(lái)源,憑證備注來(lái)源,1,FArgs,INTEGER,參數(shù),參數(shù),1

22,220011,ICVoucherTNote,憑證備注來(lái)源,憑證備注來(lái)源,1,FCaption,STRING,名稱(chēng),名稱(chēng),1

22,220011,ICVoucherTNote,憑證備注來(lái)源,憑證備注來(lái)源,1,FComponent,STRING,組件名稱(chēng),組件名稱(chēng),1

22,220011,ICVoucherTNote,憑證備注來(lái)源,憑證備注來(lái)源,1,FFunction,STRING,函數(shù)名,函數(shù)名,1

22,220011,ICVoucherTNote,憑證備注來(lái)源,憑證備注來(lái)源,1,FInterID,INTEGER,憑證類(lèi)型,憑證類(lèi)型,1

22,220011,ICVoucherTNote,憑證備注來(lái)源,憑證備注來(lái)源,1,FName,STRING,字段名,字段名,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FIsDefault,INTEGER,是否默認(rèn)模板,,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FDate,DATETIME,日期,日期,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FTplType,INTEGER,模板事務(wù)類(lèi)型,,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FBillerID,INTEGER,制模板人,,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FInterID,INTEGER,模板內(nèi)碼,,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FCountPrice,INTEGER,計(jì)價(jià)類(lèi)型,,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FGroupID,INTEGER,憑證字內(nèi)碼,憑證字ID（關(guān)鍵字）,0

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FName,STRING,模板名稱(chēng),,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FIsSystem,INTEGER,是否系統(tǒng)模板,,1

22,220007,ICVoucherTpl,憑證模板,憑證模板,1,FBillNo,STRING,單據(jù)號(hào),單據(jù)號(hào),1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FEntryID,INTEGER,分錄號(hào),,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FInterID,INTEGER,模板內(nèi)碼,,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FAccProperty,INTEGER,科目來(lái)源,,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FAmountFrom,INTEGER,金額來(lái)源,,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FAccDC,INTEGER,借貸方向,,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FNote,STRING,注釋,,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FReferenceAcct,STRING,參考科目,,1

22,220008,ICVoucherTplEntry,憑證模板明細(xì),憑證模板明細(xì),1,FAccID,INTEGER,科目?jī)?nèi)碼,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FSort,INTEGER,順序號(hào),,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FNoteTranType,STRING,備注事務(wù)類(lèi)型,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FName,STRING,事務(wù)類(lèi)型名稱(chēng),,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FExtComponent,STRING,處理模塊,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FGroupName,STRING,組名,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FInterID,INTEGER,內(nèi)碼,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FListID,INTEGER,過(guò)濾類(lèi)型,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FCountPrice,INTEGER,物料計(jì)價(jià)類(lèi)型,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FModuleID,INTEGER,模塊名,,1

22,220009,ICVoucherTplType,憑證事務(wù)類(lèi)型表,工業(yè)生成憑證的事務(wù)類(lèi)型,1,FTransDateGetSql,STRING,取日期SQL,,1

0,23,t_AccessControl,權(quán)限控制表,權(quán)限控制,1,FObjectID,INTEGER,系統(tǒng)明細(xì)對(duì)象ID,系統(tǒng)明細(xì)對(duì)象ID,1

0,23,t_AccessControl,權(quán)限控制表,權(quán)限控制,1,FAccessType,INTEGER,權(quán)限主碼,權(quán)限主碼,1

0,23,t_AccessControl,權(quán)限控制表,權(quán)限控制,1,FAccessMask,INTEGER,權(quán)限子碼,權(quán)限子碼,1

0,23,t_AccessControl,權(quán)限控制表,權(quán)限控制,1,FObjectType,INTEGER,系統(tǒng)一級(jí)對(duì)象代碼,系統(tǒng)一級(jí)對(duì)象代碼,1

0,23,t_AccessControl,權(quán)限控制表,權(quán)限控制,1,FUserID,INTEGER,用戶(hù)ID,用戶(hù)ID,1

0,29,t_Accessory,附件管理表,附件管理,1,FID,INTEGER,內(nèi)碼,內(nèi)碼,1

0,29,t_Accessory,附件管理表,附件管理,1,FDesc,STRING,描述,描述,1

0,29,t_Accessory,附件管理表,附件管理,1,FTypeID,INTEGER,類(lèi)型代號(hào),類(lèi)型代號(hào),1

0,29,t_Accessory,附件管理表,附件管理,1,FFileName,STRING,文件名,文件名,1

0,29,t_Accessory,附件管理表,附件管理,1,FFile,UnKnown,文件,文件,1

0,29,t_Accessory,附件管理表,附件管理,1,FItemID,INTEGER,項(xiàng)目?jī)?nèi)碼,項(xiàng)目?jī)?nèi)碼,1

0,29,t_Accessory,附件管理表,附件管理,1,FFileSize,INTEGER,文件大小,文件大小,1

0,29,t_Accessory,附件管理表,附件管理,1,FUploader,INTEGER,上傳者,,1

0,29,t_Accessory,附件管理表,附件管理,1,FUploadTime,DATETIME,上傳時(shí)間,,1

0,29,t_Accessory,附件管理表,附件管理,1,FChecker,INTEGER,審核者,,1

0,29,t_Accessory,附件管理表,附件管理,1,FIsPIC,BOOLEAN,是否圖片,,1

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FFromTable,STRING,權(quán)限控制表,,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FClassID,INTEGER,大類(lèi)內(nèi)碼,大類(lèi)ID,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FAccessType,INTEGER,權(quán)限主碼,權(quán)限主碼,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FMaskAccess,INTEGER,權(quán)限掩碼,,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FType,smallint,類(lèi)型,類(lèi)型,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FAccessTable,STRING,權(quán)限定義表,,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FAccessColName,STRING,權(quán)限控制字段,,0

0,159,t_AccessRowData,訪問(wèn)控制數(shù)據(jù)表,訪問(wèn)控制數(shù)據(jù)表,0,FUsed,INTEGER,是否初始化完畢,是否初始化完畢,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FDC,INTEGER,借貸方向,1-借方-1-貸方,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FSpecialType,FLOAT,特別類(lèi)型,,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FJournal,INTEGER,輸出明細(xì)賬,"0-不,1-要輸出明細(xì)賬",0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FLastintDate,DATETIME,計(jì)息時(shí)間,最新一次計(jì)息時(shí)間,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FControl,INTEGER,該字段類(lèi)型,,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FEarnAccountID,INTEGER,利潤(rùn)科目?jī)?nèi)碼,損益類(lèi)科目對(duì)應(yīng)的本年利潤(rùn)科目ID,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FHelperCode,STRING,助記碼,助記碼,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FAcnt,INTEGER,核算項(xiàng)目,"0-不,1-要下設(shè)核算項(xiàng)目",0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FIsCashFlow,INTEGER,現(xiàn)金等價(jià)物,"0-不,1-要計(jì)算",0

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

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FStatedDpst,INTEGER,活期存款,0-不是，1-是否活期存款科目,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FDetailID,INTEGER,核算項(xiàng)目?jī)?nèi)碼,核算項(xiàng)目使用ID,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FIsAcnt,INTEGER,是否賬號(hào),是否賬號(hào),0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FSystemType,INTEGER,系統(tǒng)標(biāo)示,,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FTradeNum,STRING,集團(tuán)控制科目代碼,集團(tuán)控制科目代碼,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,UUID,UnKnown,UUID,,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FParentID,INTEGER,上級(jí)科目?jī)?nèi)碼,上級(jí)科目ID,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FIsBudget,INTEGER,是否預(yù)算科目,是否預(yù)算科目,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FAdjustRate,INTEGER,期末調(diào)匯,"0-不,1-要進(jìn)行期末調(diào)匯",0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FDelete,INTEGER,是否禁用,0-可用，1-已經(jīng)禁用,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FInterest,INTEGER,是否利息科目,0-不是，1-是利息科目,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FRootID,INTEGER,上級(jí)科目?jī)?nèi)碼,最上級(jí)科目ID,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FCurrencyID,INTEGER,幣別內(nèi)碼,幣別ID,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FAcntID,INTEGER,賬號(hào),賬號(hào),0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FAcctint,INTEGER,是否計(jì)息,"0-不,1-要計(jì)息",0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FIsCash,INTEGER,現(xiàn)金類(lèi)科目,0-不是，1-是現(xiàn)金類(lèi)科目,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FFullName,STRING,全名,全名,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FBrNo,STRING,公司代碼,公司代碼,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FMeasureUnitID,INTEGER,單位內(nèi)碼,計(jì)量單位ID,0

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FAcntType,INTEGER,賬戶(hù)類(lèi)型,"0-普通科目,1-表外科目",0

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

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FModifyTime,UnKnown,時(shí)間戳,,1

0,22,t_Account,科目表,會(huì)計(jì)科目,0,FQuantities,INTEGER