UF U8 database table structure

UF database table name reference table

1 Accessaries Kit Table

2 accinformation set of account parameters table

3 Adjustpvouch

4 Adjustpvouchs

5 Ap_alarmset Unit Alarm Classification Setting table

6 Ap_billage Aging Interval table

7 Ap_cancel Verification Status table

8 Ap_cancelno Generate Auto Sequence number

9 Ap_closebill Payment Settlement form

Ap_ctrlcode Control Account Setup table

One ap_detail receivable/Shuming Fine Account

Ap_digset

Ap_dispset Query display column Settings table

Chart of accounts in Ap_inputcode

Ap_invcode Inventory Account Setup table

Ap_lock Operation Mutex Table

Ap_midexch

Ap_mytableset Query Condition Store table

Ap_note Bill Register

Ap_note_sub Bill registration Book settlement form

Chart of accounts of Ap_sstylecode settlement method

Ap_sum/payable General Ledger form

Ap_vouch Payables/Receipts Master Table

The association table for the main table of the Ap_vouchs payable/Received Form

Ap_vouchtype Document Type Table

Ar_badage Bad debt account aging Period table

List of parameters for Ar_badpara bad account

Arrivalvouch arrival order, quality control Sheet Master * * *

Arrivalvouchs arrival list, quality inspection list * * *

Assemvouch assembly, Disassembly, form conversion Single master table

Assemvouchs assembly, Disassembly, form conversion list

Bank and account number of the enterprise account

CA_ACR by product production about when the distribution rate table

The allocation method table of CA_ALLMT allocation rate

Ca_amoct various cost-cost tables

The internal fixed distribution rate table of CA_ASDIF Auxiliary Department

Supplementary cost consumption table for Panax Notoginseng CA_ASSCW

CA_ASSMP Auxiliary Unit Plan Unit Price table

CA_AWPC various cost consumption schedules

Ca_batchmx_temp

Ca_batchmxhy_tmp

Ca_batchmxhy_tmp1

Ca_bmmx_tmp

Ca_cbsys System Setup table

Ca_classdef Product Category Definition

CA_COMPD Completed product processing table

Ca_comps Completed product statistics

Ca_control Ca_control

CA_COSTCD Fee Detail Definition Table

Ca_dacps finished product production Day report

CA_DAMBW materials and purchased semi-finished products daily report

Ca_daytis Hours Daily Report

CA_DEPCF Department Forecast Entry Form

Ca_depcs Depreciation Expense Table

Ca_depdf Department Attribute table

CA_DEPFR Department Forecast Results table

CA_DEPHC Department History cost table

CA_DEPPMA Department plan labor cost rate table

Ca_dirma Direct Labor expense table

Ca_distrinput

Ca_distritem

CA_ENMMC Monthly Department share material Inventory form

Ca_enmom month at the end of the product raw material inventory form

Ca_enmop end of month in the product inventory form

A list of out-of-library categories for direct material

charges in Ca_idmac

CA_MABSW materials and purchased semi-finished products consumption table

CA_MANCT Manufacturing Expense Table

CA_MAPC Manual cost Staff category table

CA_MATDF Material Definition Table

Ca_menudef

Ca_onlia Other Fee Schedule

CA_ONPB at the beginning of the product

The monthly change of CA_ONPCE in the product table

Ca_onpqu in the product about when the coefficient table

Ca_onpquo in the Product quota table

Ca_planc Plan Cost table

CA_PPUDR Process product Lead-in day report

CA_PREDF Operation Definition Table

CA_PROCF Product Cost Forecast table

CA_PRONB Product lot Number List

The plan labor expense rate table of Bayi CA_PROPMA process

Ca_propt Process Product Attribute table

Ca_propu Process product lead-in table

Ca_quo Quota Table

Ca_rptadd Cost Report custom add-ons

CA_RPTFLD Cost report Custom column table

Ca_rpthzbtmp

Ca_rptsub Cost Report Custom Subtract

Ca_rptsum Cost Summary table

Ca_rptsys Cost Summary Report system backup

CA_SAMOCT Service project cost cost table

CA_SERPRI Service Price List

Ca_spdf carry-over voucher definition table

94 Ca_timst Hours Statistics

Ca_userproperty Operator Authority table

CA_WASPR Waste Recycling Table

Checkvouch Inventory Single Main Table

98 Checkvouchs Inventory List

List of Code accounts

ColumnSet

101 Costjustvouch Plan price/price adjustment Main Table

102 Costjustvouchs Plan price/price adjustment Sub-table

103 Costobj Cost Object Table

104 Currentstock present Stock table

Customer profile

106 Customerclass Customer classification system

107 Cw_codeplan Account Plan initial (code plan)

108 Cw_codeplus Account Additional program (code Plus)

109 Cw_deptplan Department Plan initial (department plan)

Cw_deptplus Division Additional Program (department plus)

111 Cw_profplan Profit Plan initial (profit plan)

Cw_profplus profit addition plan (profit Plus)

113 Cw_projplan Project plan inception (project plan)

Cw_projplus Project Add-on program (projects Plus)

Cw_widedeptcode extensive departmental program control account (wide department code)

Cw_wideprojcode extensive project planning control account (wide project code)

117 Dep_auth

118 Department Department Archives

119 Dispatchlist Invoice, consignment settlement single Main Table

Dispatchlists Shipping list, consignment settlement statement

121 Districtclass Regional Classification system

122 Dsign Voucher Category table

123 Dsigns voucher Category Sub-table

124 dtproperties

Dyntemplet Print Layout Temp table template

126 Endispatch entrusted Consignment Invoice Main Table

127 Endispatchs Consignment Consignment List

Exch Exchange Rate Table

129 ExpenseItem Sales Expense Project

The main table of the cost of Expensevouch mat

131 Expensevouchs Fee Sub-table

fa_assetattached 17_ Accessory Equipment

133 Fa_assettypes 06_ Asset class

134 Fa_cards 16_ Card

135 fa_cardssheets 34_ Card sheets table

136 Fa_control 30_ Record Mutex

137 fa_departments 07_ Department

138 Fa_depreciations 11_ Depreciation method

139 Fa_deprlist 34_ Depreciation Journal

Fa_deprtransactions 19_ Depreciation

141 Fa_deprvouchermain 23_ Depreciation Distribution voucher Main Table

142 fa_deprvouchers 24_ Depreciation Distribution voucher

143 Fa_deprvouchers_pre 24_ Depreciation Distribution Voucher _ preparation

144 fa_dictionary 12_ Common Reference Dictionary

145 Fa_uatemain 21_ Evaluation Single Main Table

146 Fa_uatevouchers 22_ Evaluation Sheet

147 Fa_items 12_ Project

148 Fa_itemsmanual 32_ Custom Project

149 Fa_itemsofmodel 14_ corresponding to each style of the project

Fa_itemsofquery 35_ Query Project

151 Fa_jkitemset Data Interface Settings table

Fa_jkset data Interface file format table

153 Fa_log 33_ Log

154 Fa_models 13_ Style

155 Fa_msg 29_ Info

156 fa_objects 03_ Object Table

157 fa_operators 02_ operator

158 fa_origins 09_ Increase and decrease mode

159 fa_queryfilters 05_ Query criteria

Fa_querys 04_ Query

161 Fa_reporttemp

162 Fa_status 10_ Use status

163 Fa_total 31_ Summary table

164 Fa_vouchers 20_ Change Order

165 Fa_workload 18_ Workload

166 fa_zwvouchers external voucher temporary table

167 fd_accdef Account Definition Table

168 Fd_accset Account Setup table

169 Fd_accsum Cumulative Class account general Ledger table

The definition table of Fd_accunit account unit

171 FD_CADACR Rollover Interest Document table

172 Fd_cadset Date Setting table

173 Fd_cadsets Date Setting sub-table

174 Fd_class Document Category table

175 FD_CREACRRCP Loan Interest Repayment document form

176 fd_cred Loan Form

177 FD_DZD Statement

178 Fd_dzdunit Statement Unit

179 Fd_fetch Withdrawal Form

Fd_hasten Collection Form

181 Fd_intra rate Setting table

182 Fd_intras Interest rate setting sub-table

183 Fd_item Project large class definition table

184 Fd_items Project Definition Table

185 FD_ITEMSS Project account, Project accounts table

186 Fd_option Options

187 Fd_return Repayment Form

188 Fd_sav Deposit Form

189 Fd_settacc Settlement Form

FD_UNWACRRCP Loan Interest Repayment document form

191 Fd_unwdeb Internal borrowing form

192 Fd_unwret internal borrowing repayment form

193 Fd_vouch voucher Loan Party Account definition table

194 Fitem Project Big class

195 Fitemgrademode Project Classification definition template

196 Fitemstructure Project Structure definition

197 fitemstrumode Project Catalog definition Template

198 Foreigncurrency Currency table

199 Gl_accass Auxiliary General Ledger

Gl_accsum Account General Ledger

201 Gl_accvouch Voucher and detail account

202 gl_bage Current Account age interval definition

203 Gl_bautotran Automatic Transfer definition

204 Gl_bdigest Common Summary table

205 Gl_bfreq Common voucher

206 GL_BMULTI Multi-column definition

207 Gl_bmultigroup

208 Gl_btext Letter Card information

209 Gl_cashtable

Gl_digestdisp

211 Gl_mccontrol account concurrency control Table

212 Gl_mcodeauth Account Permission table

213 gl_mcodeused Account Common items

214 Gl_mend Checkout Status table

215 Gl_merror Reconciliation Error message

216 gl_mitemused Project Common items

217 Gl_mpostcond most recent accounting voucher

218 Gl_mpostcond1

219 Gl_msysname system name Comparison table

Gl_mvcontrol Credential concurrency Control Table

221 Gl_mvocontrol External credential concurrency control table

222 Gl_myaccount my account book.

223 Gl_mybooktype book cover format

224 gl_myoutput Output Column

225 Gl_viewitem

226 Gl_vouchsync

227 Gl_xmzcdetail

228 Gradedef Coding Rules Table

229 Ia_difratedef

Ia_headset Inventory Account Setup table

231 Ia_individual

232 Ia_invtdata Inventory temporary table

233 Ia_moneyplan Inventory Accounting Fund Occupancy planning Table

234 Ia_opphead

235 Ia_quecondition Query criteria

236 Ia_subsidiary Inventory Inventory Account

237 Ia_summary Inventory Accounting General Ledger

238 Ia_tblrcsetm

239 Ia_valuationass Inventory Accounting Valuation Auxiliary Data Sheet

Inventory Stock Catalogue

241 Inventoryclass Inventory Classification system

242 Invoiceitem Document Item definition

243 INVOICEITEM_ Document Item definition

244 INVOICEITEM_AP Document Item definition

245 INVOICEITEM_PRN Document Item definition

246 Invoiceitem_sal Document Item definition

247 INVOICEITEM_SALPRN Document Item definition

248 Invoiceitema Document Item definition

249 INVOICEITEMAPRN Document Item definition

Invposition

251 ITEMDEF user selectable Project table

252 Justinvouch out of storage adjustment single Main Table

253 Justinvouchs out of storage adjustment list

254 Kchsitem Document Item definition

255 KCHSITEMPRN Document Item definition

Lockvouch Document Locking Table

257 mainbatch Batch Master file

258 Matchvouch

259 Matchvouchs

260 Maxvouch Maximum Number table

261 Nowreceipt Cash Collection form

262 Overstockvouch sluggish backlog processing single master table

263 Overstockvouchs sluggish Backlog processing list

Paycondition Payment Terms

265 Person Staff profile

266 PO Purchase order definition

267 po_podetails Purchase order (details)

268 Po_pomain Purchase order (Main table)

269 po_quodetails Inquiry/quotation (detail)

Po_quomain Inquiry/quotation (main table)

271 Po_vendorprocucts Supplier Products

272 Position

273 Pp_imrpdetails Independent Demand Plan (detail)

274 Pp_imrpmain independent Demand plan (main table)

275 Pp_lock

276 pp_mpsdetails Production Plan (detail)

277 Pp_mpsmain Production plan (Main table)

278 Pp_period Planning Cycle

279 Pp_periodto

280 pp_ppcdetails Purchase Plan (details)

281 Pp_ppcmain Purchase Plan (main table)

282 Pp_pu Procurement Plan-Purchasing inventory table

283 Pp_relatexs

284 Pp_rmrpdetails related Demand plan (detail)

285 Pp_rmrpmain related requirements Plan (main table)

286 pricejustify price Adjustment record table

287 printdef Table Kinsoku Item definition

288 Printex

289 Productstructure product Structure Master table

290 Productstructures Product Structure Sub-table

291 PS Purchase Statement display definition

292 Pu_leftsum Purchase Balance list

293 Purbillvouch Purchase Invoice Main Table

294 Purbillvouchs Purchase Invoice sub-table

295 Purchasetype Procurement Type

296 Pursettlevouch Purchase settlement form Main Table

297 Pursettlevouchs Purchase Settlement list

298 Quotedpricevouch Quote Main Table

299 Quotedpricevouchs Quotation List

Rd_style Transceiver Category

301 Rdrecord Sending and receiving record master table

302 Rdrecords Transceiver Record sub-table

303 RP_BANKRECP Bank Statement (Bank Journal)

304 Rp_cheque Cheque Register

305 RPT_FLDDEF Report Query Item definition

306 Rpt_fltdef Filter Criteria Definition

307 Rpt_folder Account Folder management

308 RPT_GLBDEF report Query definition

309 RPT_GRPDEF Group Definition

310 Rpt_itmdef Report Cell options

311 rpt_reldef Relationship Definition

312 Sa_account Sales General Ledger

313 Sa_inimain

314 sa_inisub

315 Sa_saleplan Sales Planning Form

Sa_wraplease Package Rental Form

317 Salebillvouch Sales Invoice Main Table

318 Salebillvouchs Sales Invoice sub-table

319 Salepayvouch Sales Expense order Main Table

Salepayvouchs Sales Expense List

321 Saleprice Sales Price list

322 Salerelation Sales Association table

323 Salerelation_bak

324 Sales_control Sales Menu Table

325 Saletype Sales Type

326 Scrapvouch Scrap Single master table

327 Scrapvouchs Scrap List

328 Settlestyle Settlement method

329 Shippingchoice Shipping Method table

Sindexs

331 So_sodetails Sales Order sub-table

332 So_somain Sales Order Main Table

333 So_sotext Sales Order contract text

334 Srelations

335 St_totalaccount Inventory General Ledger

336 TableName

337 tablerelation Inter-table association description

338 Transvouch Transfer Single master table

339 Transvouchs Transfer List

340 Ua_account

341 Ua_account_sub

342 Ua_auth

343 Ua_control

344 Ua_holdauth

345 Ua_period

346 Ua_subsys

347 Ua_user

348 Uffa_model_accinfomation_init

349 Uffa_model_fa_assetattached_init

Uffa_model_fa_assettypes_init

351 Uffa_model_fa_cards_init

352 Uffa_model_fa_cardssheets_init

353 Uffa_model_fa_control_init

354 Uffa_model_fa_departments_init

355 Uffa_model_fa_depreciations_init

356 Uffa_model_fa_deprlist_init

357 Uffa_model_fa_deprtransactions_init

358 Uffa_model_fa_deprvouchermain_init

359 Uffa_model_fa_deprvouchers_init

Uffa_model_fa_deprvouchers_per_init

361 Uffa_model_fa_dictionary_init

362 Uffa_model_fa_uatemain_init

363 Uffa_model_fa_uatevouchers_init

364 Uffa_model_fa_items_init

365 Uffa_model_fa_itemsmanual_init

366 Uffa_model_fa_itemsofmodel_init

367 Uffa_model_fa_itemsofquery_init

368 Uffa_model_fa_log_init

369 Uffa_model_fa_models_init

370 Uffa_model_fa_msg_init

371 Uffa_model_fa_objects_init

372 Uffa_model_fa_operators_init

373 Uffa_model_fa_origins_init

374 Uffa_model_fa_queryfilters_init

375 Uffa_model_fa_querys_init

376 Uffa_model_fa_reporttemp_init

377 Uffa_model_fa_status_init

378 Uffa_model_fa_total_init

379 Uffa_model_fa_vouchers_init

380 Uffa_model_fa_workload_init

381 Uffa_model_fa_zwvouchers_init

382 userdef Custom Definition Table

383 Userdefine Custom Value table

384 Vendor Suppliers File

385 VendorClass Supplier Classification system

386 Vouchers Document definition

387 vouchformat Document Format Master table

388 Vouchformats Document Format Sub-table

389 vouchlist Document List Definition table

390 Vouchtype Document Type table

391 wa_account Payroll Category Management Table

392 Wa_auth

393 Wa_authority

394 Wa_bank Bank Setup table

395 Wa_bank_set Bank Format setting table

396 Wa_bankname Bank Name setting table

397 Wa_bankpar bank Statement of parameters

398 Wa_banktop Bank's first line definition table

399 wa_currency wage exchange rate table

Wa_dept Department table for each wage category

401 Wa_filterexplist Filter Project table

402 Wa_filtername Filter Name table

403 Wa_formula Calculation Formula setting table

404 wa_ft_km Payroll Scale table

405 wa_ft_sum Total Payroll allocation Parameter table

406 wa_ftdept Salary Sharing Department table

407 Wa_ftinfo

408 wa_ftname The name table of the assessed reference

409 Wa_grade Personnel category table

410 wa_gzbitemdept Table Project composition table (department)

411 WA_GZBITEMGRD Table Project composition table (category)

412 Wa_gzbitemtitle Table Project composition table (column)

413 wa_gzbname Table Name table

414 Wa_gzdata Payroll Data Sheet

415 wa_gzft Salary Assessment form

416 WA_GZHZB Salary Summary table

417 Wa_gzitem Wage category Payroll Project Setup table

418 Wa_gznamelist Payroll Project Reference Table

419 wa_gzsumcomcfg

420 Wa_gztblset Payroll Project Setup table

421 Wa_jkitemset Data Interface Settings table

422 Wa_jkset Data Interface file format table

423 WA_PSN Personnel Table

424 WA_PSNMSG Personnel additional information sheet

425 WA_SDS Income Tax Data Sheet

426 wa_sds_p Income Tax Setting table

427 WA_SDS_SL Income Tax rate table

428 Wa_selectmoney ticket denomination setting table

429 wa_state Data Processing status table

430 Wa_tblrcsetm

431 WA_TBLRCSETP

432 Warehauth

433 Warehouse Warehouse Archive

434 wastage

UF U8 database table structure