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?
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
- Previous article:How does FDA get in?
- Next article:What are the train and bus fares from Hankou to Xiaochang?
- Related articles
- How about Dalian Puxin Tongfang Training School?
- Who can provide a plan to grow tall and long hair? I am 24 years old.
- Brief introduction of Weinan talent network
- How about Sihong Xingfu Kindergarten?
- Does SF still recruit drivers?
- How about Changsha Julang Electromechanical Equipment Co., Ltd.?
- Is it reliable to pull shrimp tails in Hubei?
- I am a sophomore in Jiangnan University. I want to find a part-time job. I don't know what I can do. Besides, where can I find a job?
- Does Flantz Joseph love Princess Cece?
- What is the treatment of CGNPC Guangxi Fangchenggang Nuclear Power Station?