Kingdee table description (for developers)

Used for testing kispro and k310.4 in other versions

Select distinct ID from Table Name

Distinct filters out duplicate records   Field info table Select * From ictransactiontype Select * From ictemplate Select * From ictemplateentry   Ictransactiontype main business document table Ictemplate document header field description Ictemplateentry table body field description The associated information is ictransactiontype. ftemplateid = ictemplate. FID = ictemplateentry. FID Icchatbilltitle document sequence book template table Glnotecitation template table T_tabledescription table description T_fielddescription table field description T_systemprofile System Parameters Cl -- General Ledger IC -- business startperiod -- enable currentperiod -- current period currentyear -- current year startyear -- enable annual icbal inventory balance table
Inventory balance table of icinvbal warehouse
Icinventory inventory table
Icinvinitial inventory initial data table DBO. t_rp_billtype -- types of receivables and payables
T_rp_newreceivebill prepayment receipt form   1 -- Document Type Select t1.fid, t1.fname, t1.fnumber, t1.fnote, t1.facctid, t2.fnumber as facctnumber From icbilltype T1 left join t_account T2 on t1.facctid = t2.faccountid order by t1.fid 2 --- Transaction type corresponding to the document Select fbillid, fbillname as fbillname, fcanalterbillno, fcheckaftersave, fusebillcoderule From icbillno where fbillid> 0 order by fbillid 3 --- Document settings (Encoding Rules) Select fbillname as fbillname, fdesc, (Case fcanalterbillno when 1 then 'is 'else' no' end) fcanalterbillno, (Case fcheckaftersave when 1 then' is 'else' no' end) fcheckaftersave, (Case fusebillcoderule when 1 then 'is 'else' no' end) fusebillcoderule from icbillno where fbillid in (select ABS (FID) from icclasstype where fcontrol & 32> 0) order by FPOs

Partial stored procedure description

T_rpt_content custom report

T_rpt_leaderaudit Report Approval Information table

T_rpt_multiacct multi-account set setting table

T_rpt_multiacctentry information table

T_rpt_multiacctright

T_rpt_profile report parameter settings table

T_rpt_propclass report attribute category table

T_rpt_propitem Report category project table

 

Partial stored procedure description

T_rpt_content custom report

T_rpt_leaderaudit Report Approval Information table

T_rpt_multiacct multi-account set setting table

T_rpt_multiacctentry information table

T_rpt_multiacctright

T_rpt_profile report parameter settings table

T_rpt_propclass report attribute category table

T_rpt_propitem Report category project table

T_rpt_right report authorization information table

T_rpt_view report view setting table

T_rpt_leaderaudit2 Report Approval Information table

T_rpt_multiacct2 multiple sets of books

T_rpt_multiacctentry2 sets of information table

T_rpt_multiacctright2 sets of authorization information table

T_rpt_profile2 report parameter settings table

T_rpt_propclass2 report attribute category table

T_rpt_propitem2 Report category project table

T_rpt_right2 report authorization information table

T_rpt_view2 report view setting table

 

Document Status Value

What does each value in fstatus mean? 0 1 2 3
0 not reviewed
1. Review
2 associated
3. write off or close

 

-- K312.1 keyword-related information
-- Type
Select fitemclassid, fnumber, fname as fname, ''as ffieldname from t_itemclass where FTYPE = 1 and fitemclassid not in (6, 7, 2023) and fitemclassid> 0
Select *, fname_chs as fname
From icclasstype where FID> 0 and fbilltypeid = 1 and fcontrol & 1 = 1
Order by fname_chs
Select * From icclassactionlist T1 left Outer Join icclassaction T2 on (t1.fclassactionid = t2.fid) Where t1.fclasstypeid = 1001303 order by t1.forder
Select distinct ftypeid, fname from t_submestype order by ftypeid
-- Keyword table
Select fcaption as fcaption, finterid, fkeyword, fvaluetype, fdatasource, fbasefield, fsourcesql, fsourcefield, fisallowenter, fisneed from icreportkeywords where fkeywordtype = 0 order by finterid ASC

K312.1 stored procedures related to the certificate receivable Template
Select count (1) as recordcount from syscolumns where id = (select ID from sysobjects where name = 't_ log ')

Select fnotetrantype, fbilltimestamp from icvouchertpltype
Where finterid = 5001

Select ftimestamp, * From icclasstype where FID = 1000000.

-- Exec p_rp_updatevouchertpl, 5001, '0x00000000000922f5'