用友財務軟件主要數據表字段含義

?

?

/*rdrecords??? : 收發記錄子表
AutoID???????? :?? auto ID????????????????????? 自動編號???????????????? automatism identification(identity)
ID???????????? :?? ID?????????????????????????? 與收發記錄主表關聯項
cInvCode?????? :?? c? invoice code????????????? 存貨編號???????????????? inventroy
iNum?????????? :?? i? number??????????????????? 件數
iQuantity????? :?? i? quantity????????????????? 數量
iUnitCost????? :?? i? unit cost???????????????? 單價
iPrice???????? :?? i? price???????????????????? 金額
iAPrice??????? :?? i? appraise price??????????? 暫估金額
iPUnitCost???? :?? i? plan unit cost??????????? 計劃單價/售價
iPPrice??????? :?? i? plan price??????????????? 計劃金額/售價金額
cBatch???????? :?? c? batch???????????????????? 批號
cObjCode?????? :?? c? object code?????????????? 成本對象（材料出庫單）
cVouchCode???? :?? c? voucher code????????????? 對應入庫單子表自動編號
cFree1???????? :?? c? free 1??????????????????? 自由項1
cFree2???????? :?? ......
iFlag????????? :?? i? flag????????????????????? 標志（存貨核算用 0-未暫估未報銷 1-暫估 2-報銷）
dSDate???????? :?? d? settle date?????????????? 結算日期
iTax?????????? :?? i? tax?????????????????????? 稅額（采購用）
iSQuantity???? :?? i? settle quantity?????????? 結算數量（受托代銷）
iSNum????????? :?? i? settle number???????????? 累計結算件數（受托代銷）
iMoney???????? :?? i? money???????????????????? 累計結算金額
iSOutQuantity? :?? i? send out quantity???????? 累計出庫數量
iSOutNum?????? :?? i? sent out number?????????? 累計出庫件數
iFNum????????? :?? i? fact number?????????????? 實際件數
iFQuantity???? :?? i? fact quantity???????????? 實際數量
dVDate???????? :?? d? *** date????????????????? 失效日期*/
-------------------------------------------------------------------------------------------------------------------
/*salebillvouch: 銷售發票主表
SBVID????????? :?? sale bill(voucher) ID??????? 銷售發票ID
cSBVCode?????? :?? c? sale bill(voucher) code?? 發票號
cVouchType???? :?? c? voucher type????????????? 單據類型(26,27,28,29)
cSTCode??????? :?? c? sale type code??????????? 銷售類型
dDate????????? :?? d? date????????????????????? 日期
cSaleOut?????? :?? c? sale out????????????????? 銷售出庫單號字符串
cRdCode??????? :?? c? receive & deliver code??? 收發類別編號
cDepCode?????? :?? c? department code?????????? 部門編號
cPersonCode??? :?? c? person code?????????????? 職員編號
cSOCode??????? :?? c? sale order code?????????? 銷售訂單號
cCusCode?????? :?? c? customer code???????????? 客戶編碼
cPayCode?????? :?? c? payment code????????????? 付款條件編碼
cexch_name???? :?? c? *** name????????????????? 外幣名稱???????????????? exoteric(extra) cash
cMemo????????? :?? c? memo????????????????????? 備注
iExchRate????? :?? c? exchange rate???????????? 匯率
iTaxRate?????? :?? i? tax rate????????????????? 稅率
bReturnFlag??? :?? b? return flag?????????????? 負發票標志（TRUE-負發票 FALSE-正發票）
cBCode???????? :?? c? bank code???????????????? 本單位開戶銀行編號
cBillVer?????? :?? c? bill version????????????? 發票版別
cVoucherType?? :?? c? voucher type????????????? 憑證類別
cVoucherCode?? :?? c? voucher code????????????? 憑證號
cMaker???????? :?? c? maker???????????????????? 制單
cInvalider???? :?? c? invalider???????????????? 作廢
cVerifier????? :?? c? verifier????????????????? 審核
cBusTupe?????? :?? c? business type???????????? 業務類型（普通/受托）
bFirst???????? :?? b? first???????????????????? 是否期初 TRUE-是期初
bInvalid?????? :?? b? invalid?????????????????? 是否有效 TRUE-有效
bVisible?????? :?? b? visible?????????????????? 是否可見 TRUE-可見
iNetLock?????? :?? i? net lock????????????????? 網絡控制字段
citem_class??? :?? i? item class??????????????? 項目大類編號
citemcode????? :?? c? item code???????????????? 項目編碼
cHeadCode????? :?? c? head code???????????????? 科目編碼
bDisFlag?????? :?? b? discount flag???????????? 整單打折標志
cDefine1?????? :?? c? define 1????????????????? 自定義字段1
......
cDefine10????? :?? ......
bPayMent?????? :?? b? payment?????????????????? 是否現結? */
-------------------------------------------------------------------------------------------------------------------
/*salebillvouchs: 銷售發票子表
SBVID????????? :?? sale bill(voucher) ID??????? 銷售發票主表ID
AutoID???????? :?? auto ID????????????????????? 自動編號???????????????? automatism identification(identity)
cWhCode??????? :?? c? warehouse code??????????? 倉庫編號
cInvCode?????? :?? c? invoice code????????????? 存貨編碼???????????????? inventroy
iQuantity????? :?? i? quantity????????????????? 數量
iNum?????????? :?? i? number??????????????????? 件數
iQuotePrice??? :?? i? quote price?????????????? 報價（單價，是否含稅參看帳套參數）
iUnitPrice???? :?? i? unit price??????????????? 單價（原幣，無稅）
iTaxUnitPrice? :?? i? tax unit price??????????? 含稅單價（原幣）
iMoney???????? :?? i? money???????????????????? 金額（原幣，無稅）
iTax?????????? :?? i? tax?????????????????????? 稅額（原幣）
iSum?????????? :?? i? sum?????????????????????? 價稅合計（原幣）
iDisCount????? :?? i? discount????????????????? 折扣額（原幣）
iNatUnitPrice? :?? i? native unit price???????? 單價（本幣，無稅）
iNatMoney????? :?? i? native money????????????? 金額（本幣，無稅）
iNatTax??????? :?? i? native tax??????????????? 稅額（本幣）
iNatSum??????? :?? i? native sum??????????????? 價稅合計（本幣）
iNatDisCount?? :?? i? native discount?????????? 折扣額（本幣）
iSBVID???????? :?? i? sale bill(voucher) ID???? 原銷售單（發票）主表ID號
iMoneySum????? :?? i? money sum???????????????? 本幣累計收款
iExchSum?????? :?? i? *** sum?????????????????? 原幣累計收款
cClue????????? :?? c? clue????????????????????? 總帳系統線索號
cIncomeSub???? :?? c? income subject??????????? 銷售收入科目編號
cTaxSub??????? :?? c? tax subject?????????????? 銷售稅金科目編號
dSignDate????? :?? d? sign date???????????????? 憑證日期
cMemo????????? :?? c? memo????????????????????? 備注
iBatch???????? :?? i? batch???????????????????? 批號（收發記錄主表ID）
cBatch???????? :?? c? batch???????????????????? 批號
bsettleall???? :?? b? settle all??????????????? 是否收款結算完畢
cFree1???????? :?? c? free 1??????????????????? 自由項1
cFree2???????? :?? ......? */
-------------------------------------------------------------------------------------------------------------------
/al_closebill? : 收付款結算表
AutoID???????? :?? auto ID????????????????????? 自動編號
cVouchType???? :?? c? voucher type????????????? 單據類型("48":收款單，"49":付款單)
cVouchID?????? :?? c? voucher ID??????????????? 結算單號
dVouchDate???? :?? d? voucher date????????????? 收/付款日期
iPeriod??????? :?? i? period??????????????????? 收/付款期間
cDwCode??????? :?? c? *** code????????????????? 客戶/供應商編碼
cDepCode?????? :?? c? department code?????????? 部門編號
cPersonCode??? :?? c? person code?????????????? 職員編號
citem_class??? :?? i? item class??????????????? 項目大類編號
citemcode????? :?? c? item code???????????????? 項目編碼
cSSCode??????? :?? c? sale settle code????????? 結算方式
cNoteNo??????? :?? c? note no.????????????????? 應收應付票據編號
cCoVouchType?? :?? c? corresponding voucher type對應票據類型("50","51")
cCoVouchID???? :?? c? corresponding voucher ID? 對應應收應付票據號
dCoVouchDate?? :?? d? *** voucher date????????? 支票發生日期(此字段用于總帳) check occur
cDigest??????? :?? c? digest??????????????????? 摘要
cBankAccount?? :?? c? bank account????????????? 銀行帳號
cexch_name???? :?? c? *** name????????????????? 幣種
iExchRate????? :?? c? exchange rate???????????? 匯率
iAmount??????? :?? i? amount??????????????????? 本幣金額
iAmount_f????? :?? i? amount_former???????????? 原幣金額???
iRAmount?????? :?? i? remainder amount????????? 本幣余額
iRAmount_f???? :?? i? remainder amount_former?? 原幣余額????
cOperator????? :?? c? operator????????????????? 錄入人
cCancelMan???? :?? c? cancel man??????????????? 核銷人
cRPMan???????? :?? c? recieve & pay man???????? 出納人簽字
bPrePay??????? :?? b? previous pay????????????? 預收預付標志 (True:預收或預付, False:結算單)? pre-
bStartFlag???? :?? b? start flag??????????????? 期初標志 (True:期初, False:否)
cOrderNo?????? :?? c? order no.???????????????? 訂單號(用于業務模塊)
cCode????????? :?? c? code????????????????????? 科目編碼(結算科目)
cPreCode?????? :?? c? previous code???????????? 預收/付科目編碼?????????????????????????????? pre-
iPayForOther?? :?? i? pay for other???????????? 代付標志（0:正常；1：代他人付款 ；2：被代付）
cSrcFlag?????? :?? c? source flag?????????????? 結算單來源 (""或NULL:出納錄入,"A":應收應付錄入,"C"表示票據編號為
cPzID????????? :?? c? Pz(拼音“憑證”) ID?????? 生成憑證時的線索號
cFlag????????? :?? c? flag????????????????????? 應收應付標志 ("AR":應收,"AP":應付,空:其他)
-------------------------------------------------------------------------------------------------------------------
/*code???????? : 科目表
i_id?????????? :?? i? id??????????????????????? 自動編號(用于編輯時的唯一標識)
cclass???????? :?? c? class???????????????????? 科目類型(根據企業類型定義科目分類)
cclass_engl??? :?? c? class english???????????? 科目類型英文名稱
cclassany????? :?? c? class analysis??????????? 財務分析類型
cclassany_engl :?? c? class analysis english??? 財務分析類型英文名稱
ccode????????? :?? c? code????????????????????? 科目編碼(按科目編碼原則進行編碼,<主表關聯項>)
ccode_name???? :?? c? code name???????????????? 科目名稱
ccode_engl???? :?? c? code english????????????? 科目英文名稱
igrade???????? :?? i? grade???????????????????? 科目級次(必須與科目編碼相匹配)
bproperty????? :?? b? property????????????????? 科目性質(False：來源True:占用)
cbook_type???? :?? c? book type???????????????? 帳頁格式(金額式,數量金額式,外幣金額式,數量外幣式)
cbook_type_engl:?? c? book type english???????? 帳頁格式英文名稱
chelp????????? :?? c? help????????????????????? 科目助記碼
cexch_name???? :?? c? *** name????????????????? 外幣名稱(與外幣主表關聯)??? exchange
cmeasure?????? :?? c? mersure?????????????????? 計量單位
bperson??????? :?? b? person??????????????????? 個人往來核算(不能與其他輔助核算同時設置)
bcus?????????? :?? b? customer????????????????? 客戶往來核算(可與部門,項目核算同時設置)
bsup?????????? :?? b? supporter???????????????? 供應商往來核算(可與部門,項目核算同時設置)
bdept????????? :?? b? department??????????????? 部門核算(可與客戶,供應商,項目核算同時設置)
bitem????????? :?? b? item????????????????????? 項目核算(可與客戶,供應商,部門核算同時設置)
cass_item????? :?? class item?????????????????? 項目大類(與項目大類主表_item關聯,當bitem=True)
br???????????? :?? ***????????????????????????? 日記帳????????????????????? book of account
be???????????? :?? ***????????????????????????? 銀行帳????????????????????? ???
cgather??????? :?? c? gather??????????????????? 是否匯總打印(打印憑證)(Null_不匯總,其它為本級或上級匯總科目)
bend?????????? :?? b? end?????????????????????? 是否末級科目
bexchange????? :?? b? exchange????????????????? 是否參與匯兌損益計算
bcash????????? :?? b? cash????????????????????? 是否出納(現金)科目(可指定上級科目,自動對下級科目設置此屬性)
bbank????????? :?? b? bank????????????????????? 是否出納(銀行)科目(可指定上級科目,自動對下級科目設置此屬性)
bused????????? :?? b? used????????????????????? 銀行帳科目是否啟用
bd_c?????????? :?? b? direction???????????????? 銀行帳科目對帳方向 True:借方, False:貸方
dbegin???????? :?? d? begin???????????????????? 銀行帳科目啟用時間
dend?????????? :?? d? end?????????????????????? 銀行帳科目對帳截止日期
itrans???????? :?? i? trans?? 期間損益:1_本年利潤,銷售成本:2_庫存商品/3_銷售收入/4_銷售成本,匯兌損益:5_入帳科目?? transaction
bclose???????? :?? b? close???????????????????? 科目是否封存(已封存科目不能制單)
cother???????? :?? c? other???????????????????? 受控科目(科目受其他系統的控制,系統ID名,受控科目是否可制單由帳套參數決定)
iotherused???? :?? i? other used??????????????? 其它系統是否使用(由其它系統填寫,0_未使用,非0_已使用)
bcDefine1????? :?? b? c define 1??????????????? 自定義字段1
......
bcDefine10???? :?? ......? */
----------------------------------------------------------------------------------------------------------------
/*gl_accsum??? : 科目總賬
i_id?????????? :?? i? id??????????????????????? 自動編號(期初錄入時的唯一標識)
ccode????????? :?? c? code????????????????????? 科目編碼(與科目主表關聯)
cexch_name???? :?? c? *** name????????????????? 外幣幣名(與外幣主表關聯)
iperiod??????? :?? i? period??????????????????? 會計期間(1-12)
cbegind_c????? :?? c? begin direction?????????? 金額期初方向(借,貸,mb=0時為平)
cbegind_c_engl :?? c? begin direction english?? 金額期初方向(英文)
mb???????????? :?? money begin????????????????? 金額期初(空時寫0,mb>=0)
md???????????? :?? money debit????????????????? 金額借方合計(空時寫0)
mc???????????? :?? money credit???????????????? 金額貸方合計(空時寫0)
cendd_c??????? :?? c? end direction???????????? 金額期末方向(借,貸,me=0時為平)
cendd_c_engl?? :?? c? end direction english???? 金額期末方向(英文)
me???????????? :?? money end??????????????????? 金額期末(空時寫0,me>=0)
mb_f?????????? :?? money begin foreign????????? 外幣期初(空時寫0,mb<>0時:mb_f>=0_外幣與金額同方向,mb_f<0_外幣與金額反方向)
md_f?????????? :?? money debit foreign????????? 外幣借方合計(空時寫0)
mc_f?????????? :?? money credit foreign???????? 外幣貸方合計(空時寫0)
me_f?????????? :?? money end foreign??????????? 外幣期末(空時寫0,me<>0時:me_f>=0_外幣與金額同方向,me_f<0_外幣與金額反方向)
nb_s?????????? :?? number begin???????????????? 數量期初(空時寫0,mb<>0時:nb_s>=0_數量與金額同方向,nb_s<0_數量與金額反方向)
nd_s?????????? :?? number debit???????????????? 數量借方合計(空時寫0)
nc_s?????????? :?? number credit??????????????? 數量貸方合計(空時寫0)
ne_s?????????? :?? number end?????????????????? 數量期末(空時寫0,me<>0時:ne_s>=0_數量與金額同方向,ne_s<0_數量與金額反方向) */
----------------------------------------------------------------------------------------------------------------
/*gl_accvouch? : 憑證及明細賬
i_id?????????? :?? i? id??????????????????????? 自動編號(錄入時的唯一標識)
iperiod??????? :?? i? period? 會計期間,0為期初往來明細帳,21為期初待核銀行帳,20為銀行帳科目調整前余額,1-12為憑證及明細帳
csign????????? :?? c? sign????????????????????? 憑證類別字(由于期初可輸入未定義憑證類別,故未與憑證主表關聯)
isignseq?????? :?? i? sign sequence???????????? 憑證類別排序號(由系統賦值,期初時可為null)
ino_id???????? :?? i? no. id??????????????????? 憑證號(由系統分配憑證號,期初時可為null)
inid?????????? :?? i? n id????????????????????? 行號(由系統賦值,期初時為1)
dbill_date???? :?? d? bill date???????????????? 制單日期(可提供日期在有限范圍內的修改)
idoc?????????? :?? i? document????????????????? 附單據數
cbill????????? :?? c? bill????????????????????? 制單人
ccheck???????? :?? c? check???????????????????? 審核人
cbook????????? :?? c? book????????????????????? 記帳人
ibook????????? :?? i? book????????????????????? 是否記帳(0_cbook空/未記帳,1_cbook非空/已記帳,建索引用)
ccashier?????? :?? c? cashier?????????????????? 出納人
iflag????????? :?? i? flag????????????????????? 標志:null_有效憑證,1_作廢憑證,2_有錯憑證(作廢憑證可取消作廢/進行憑證整理)
ctext1???????? :?? c? text 1??????????????????? 憑證頭自定義項 1
ctext2???????? :?? c? text 2??????????????????? 憑證頭自定義項2
cdigest??????? :?? c? digest??????????????????? 摘要
ccode????????? :?? c? code????????????????????? 科目編碼(與科目主表關聯)
cexch_name???? :?? c? *** name????????????????? 外幣名稱(與外幣主表關聯)
md???????????? :?? money debit????????????????? 金額借方
mc???????????? :?? money credit???????????????? 金額貸方
md_f?????????? :?? money debit foreign????????? 外幣借方金額(若無外幣,寫0)
mc_f?????????? :?? money credit foreign???????? 外幣貸方金額(若無外幣,寫0)
nfrat????????? :?? n? foreign rate????????????? 匯率(若無外幣,寫0)
nd_s?????????? :?? number debit???????????????? 數量借方(若無數量,寫0)
nc_s?????????? :?? number credit??????????????? 數量貸方(若無數量,寫0)
csettle??????? :?? c? settle??????????????????? 結算方式(由于期初可輸入未定義結算方式,故未與結算方式主表關聯)
cn_id????????? :?? c? note id?????????????????? 票號
dt_date??????? :?? d? take place date?????????? 票號發生日期
cdept_id?????? :?? c? department id???????????? 部門編碼(與部門目錄表關聯)
cperson_id???? :?? c? person id???????????????? 個人編碼(與職員目錄表關聯)
ccus_id??????? :?? c? customer id?????????????? 客戶編碼(與客戶目錄表關聯)
csup_id??????? :?? c? supporter id????????????? 供應商編碼(與供應商目錄表關聯)
citem_id?????? :?? c? item id?????????????????? 項目編碼(與項目目錄表關聯)
citem_class??? :?? c? item class??????????????? 項目大類(與大類主表關聯)
cname????????? :?? c? name????????????????????? 業務員
ccode_equal??? :?? c? code equal??????????????? 對方科目
iflagbank????? :?? i? flag bank???????????????? 銀行帳兩清標志(Null_未達,<1-12> =自動兩清期間 <13-24> -12=手工兩清期間)
iflagPerson??? :?? i? flag person?????????????? 往來帳兩清標志(Null_未達,<1-12> =自動兩清期間 <13-24> -12=手工兩清期間)
bdelete??????? :?? b? delete??????????????????? 銀行帳核銷標志
coutaccset???? :?? c? out account set?????????? 外部憑證帳套號
ioutyear?????? :?? i? out year????????????????? 外部憑證會計年度
coutsysname??? :?? c? out system name?????????? 外部憑證系統名稱(ID)
coutsysver???? :?? c? out system version??????? 外部憑證系統版本號
doutbilldate?? :?? d? out bill date???????????? 外部憑證制單日期
ioutperiod???? :?? i? out period??????????????? 外部憑證會計期間
coutsign?????? :?? c? out sign????????????????? 外部憑證業務類型
coutno_id????? :?? c? out note id?????????????? 外部憑證業務號
doutdate?????? :?? d? out date????????????????? 外部憑證單據日期
coutbillsign?? :?? c? out bill sign???????????? 外部憑證單據類型
coutid???????? :?? c? out id??????????????????? 外部憑證單據號
bvouchedit???? :?? b? voucher eidt????????????? 憑證是否可修改(True_可修改,False_不可修改)
bvouchAddordele:?? b? voucher add or delete???? 憑證分錄是否可增刪(True_可增刪,False_不可增刪)
bvouchmoneyhold:?? b? voucher money hold??????? 憑證合計金額是否保值(True_必須保值,False_可不保值)
bvalueedit???? :?? b? value edit??????????????? 分錄數值(金額/數量/外幣)是否可修改(True_可修改,False_不可修改)
bcodeedit????? :?? b? code edit???????????????? 分錄科目是否可修改(True_可修改,False_不可修改)
ccodecontrol?? :?? c? code control????????????? 分錄受控科目(Null_均不可用,****_均可用,!_指定不可用,ID_指定可用)
bPCSedit?????? :?? b? person customer supporter edit 分錄往來項(個人/客戶/供應商)是否可修改(True_可修改,False_不可修改)
bDeptedit????? :?? b? department edit?????????? 分錄部門是否可修改(True_可修改,False_不可修改)
bItemedit????? :?? b? item edit???????????????? 分錄項目是否可修改(True_可修改,False_不可修改)
bCusSupInput?? :?? b? customer supporter input? 分錄往來項(客戶/供應商)是否必輸(True_必輸,False_不必輸)
cDefine1?????? :?? b? c define 1??????????????? 自定義字段1
...... 2?????? :?? ......
?????? 3
?????? 5
?????? 7
?????? 8
?????? 9
cDefine10????? :?? ......? */
-------------------------------------------------------------------------------------------------------------------
注：?????????????? c? 文本型
?????????????????? i? 數值型
?????????????????? d? 日期型
?????????????????? b? 布爾型?????????????????????????????????????????????????????????????????? （資料整理：劉博宇）
-------------------------------------------------------------------------------------------------------------------

弄得不咋好,大家一起來探討與修正吧!

轉載于:https://www.cnblogs.com/linbaba/archive/2009/01/13/1375064.html

總結

以上是生活随笔為你收集整理的用友财务软件主要数据表字段含义的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。