Job Recruitment Website - Job information - Can you describe the tables and fields in the butterfly database for me?

Can you describe the tables and fields in the butterfly database for me?

Butterfly database? Can you make it clear?

System ID table ID table name En table name Chs description

0 6 t_Supplier supplier table supplier data

0 20t _ Department Table Department

0 34 t_CodeTypeFP coding rule allocation table coding rule allocation table

0 47 t_VoucherTplType voucher transaction table voucher transaction table

0 54 t_StockPlace location table location

1 10003t _ automatic transfer entry table automatic transfer entry table

110017 t _ note collection table.

110031t _ transinitbalance transaction initial balance table transaction initial balance table

110050t _ glff _ budgeouterbill main table extrabudgetary bill main table

110064t _ glbaddights Generate Bad Debt Record Table The function of confirming bad debts is to generate vouchers and post them for write-off, and finally record the written-off voucher ID and entry ID in this table.

2 20007 t_PA_ItemClass salary basic item category table salary basic item category table

2 20020 t_PA_taxpamaRef income tax rate table income tax rate table

2 20034t _ pa fund _ calcschemedetail fund withdrawal scheme list fund withdrawal scheme list

2 20047 t_PATrans The payroll system keeps two tables, and the payroll system keeps two tables.

3 300 17 t_FABalance balance table balance information main table, corresponding to change table t_FaAlter.

330029T _ Faschmotion option setting table stores the option settings in the display scheme.

3 30035t _ FaexpenseDetailMulalter Depreciation Expense Distribution Details Multiple Changes Table stores the depreciation expense distribution details when the card is changed many times.

3 30047 t_FaTmpCard card temporary table stores temporary cards.

4 400 13 cn_yhrjz deposit journal, deposit journal

5 50015t _ RP _ New Receive Bill Receipt Doc

5 50028 t_RP_SystemProfile system parameter table system parameter table

5 50035 t_rp_AdjustRate

6 60006 t_rp_bill_discount Discount keeps the discount record of each bill.

6 60019t _ rpcontractdetail contract receipt list contract receipt information. FRP= 1- A/R: FRP = 0- A/P。

6 60033 t_rp_AdjustRate

7 700 16 t _ RPT _ Propeitem2 Report Category Item Table Report Category Item Table

9 90004 T_CFSet Report Scheme Set Report Scheme Set

1010006t _ scintloan loan interest table loan interest details, including penalty interest.

10100019t _ scpay loan schedule loan plan

10100033t _ scloanext loan extension table loan extension

11110009t _ cs industry nature

11110023t _ csright Customize report permissions.

11110037cr _ currency currency

11110050cr _ invest balance statement equity investment balance statement

11110065cr _ rptdate dynamic table data list dynamic table data list

11110077cr _ schematetem The list of customized schemes for consolidated reports records the project attributes in all customized schemes of consolidated reports.

20 200009 t_SupplyEntry supplier supply details supplier supply details information

21210002 icinvbackup counts the backup data first, and then the backup table.

21210015 zsstockbilling virtual warehouse receipt/issue document entry table virtual warehouse receipt/issue document entry table

21210029 vwicbill _ 4 virtual warehouse receipt (view) virtual warehouse receipt (view)

22 220007 ICVoucherTpl voucher template voucher template

23 230007 SEOutStockEntry delivery notice entry table sales delivery notice entry

23 230027 iccreditinstantry real-time data material list credit summary real-time data material list

25 25000 1 ICBOMCHILD BOM entry list

25 250008 t_WorkType production type table production type table

25 250022t _ ictteamtimeentry Schedule Details Schedule Details

26 260006 ICSerialFlow serial number flow record table

27 270009 cbmakedisiributeinfo manufacturing expense allocation table manufacturing expense allocation table

27 270030 cbWCalInfo waste repairable cost calculation; single waste repairable cost calculation.

27 270042 CBCPVTargetProfit Volume Profit Target Input Table Volume Profit Target Input.

27 270048 CBOrderCostHisData Order Cost Historical Cost Data Forecast Table

44 440003t _ QY _ userptclass EIS User Report Folder Table User Personalized Report Folder

46 460009 t_GR_MergeExecPlan group consolidated accounting schedule records the implementation plan of group consolidated accounting.

47 47000 1 PPBom production feeding sheet production feeding sheet

48 480005 t_MgItem accounting item relationship table accounting item relationship table

48 4800 12t _ Management Center Responsibility Center Structure Table Responsibility Center Structure Table

48 480026t _ mgmultichecklelevel Multi-level Approval Definition Table Multi-level Approval Definition Table

48 480039T _ Mg _ receive budget receiving history table

54 5400 12 t_pm_ProjectDoc project document table project document table

1281280002v _ report _ dimissionempworkinfo Employee Job Information Employee Job Information

128128041kloc-0/t _ pa _ personpchs salary and personnel change data table

1281280418t _ pabankpayfile keeps a table in the payroll system.

1281280432t _ pa fund _ calcset fund accrual standard definition table fund accrual standard definition table

0 0 t_VoucherGroup Voucher Word List Voucher Receipt and Payment Classification Words

0 1 t_VoucherEntry voucher entry table voucher entry

0 2t _ Voucher Voucher Table Voucher

0 3 t_User system user information table system user information table

0 4 t_UnitGroup unit category table unit category

0 5 t_SystemProfile system parameter list, company name and other system control parameters.

1281280445t _ pazeroset salary deduction setting table salary deduction setting table

1281280459hm _ em _ files employee files employee files

1291290314 hm _ em _ code _ professional category table

1291290327 hm _ em _ health _ code health code

1291290334hm _ em _ sex _ code gender code

1291290348wf _ biz _ resignation type resignation category table

1311310163ad _ objective _ roleSchema Target Appraisal Role Scheme Table Target Appraisal Role Scheme Table

1341340168wf _ biz _ fireinfo dismissal information table

139 1390008 Item substitution list entry Item substitution list entry

1431430000 view _ icmorpht _ j11task list report view task list report view

143 1430007 PPBOM production feeding sheet production feeding sheet

144 1440006 PPBOM production material list production material list

1451450005 shprocprtman process report process report

146 1460004 equipment certification equipment accident registration form entry equipment accident registration form entry

1461460017 icdevicemaintainplan equipment maintenance plan

1461460030 icdevicepayrecord equipment maintenance record

1461460043 icdeviceinspection data equipment inspection program

146 1460056 view _ icdeviceInspection plan view equipment inspection plan view

200 2000130 org _ companyatch company information table company information table

2012010219 rec _ app _ skills information table for candidates.

2012010232 rec _ interview opinion _ user dept. opinions

2012010245rec _ req recruitment movement recruitment notice form recruitment notice form

202 2020 285 rec _ code _ attchinfotopic additional information subject code table additional information subject code table

202 2020 298 rec _ code _ healthstatus health status code table health status code table

202 2020311rec _ code _ politics status code table political outlook code table

202 2020320 REC_Code_Sex gender code table gender code table

202 2020 334 REC _ Code _ years annual salary code table annual salary code table

203 2030292 HR_TR_ClassChannel Training Course Channel Relationship Table Training Course Channel Relationship Table

203 2030299 HR_TR_ExamPaper Test Paper Table

203 2030305 HR_TR_PaperItem title table title table

2032030291hr _ tr _ bookcategory book category table