1. 1. QAD Enterprise Applications Enterprise Edition Technical Reference Database Definitions 70-3158-2013.1EE QAD Enterprise Applications 2013.1 Enterprise Edition September 2013
2. 2. This document contains proprietary information that is protected by copyright and other intellectual property laws. No part of this document may be reproduced, translated, or modified without the prior written consent of QAD Inc. The information contained in this document is subject to change without notice. QAD Inc. provides this material as is and makes no warranty of any kind, expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. QAD Inc. shall not be liable for errors contained herein or for incidental or consequential damages (including lost profits) in connection with the furnishing, performance, or use of this material whether based on warranty, contract, or other legal theory. QAD and MFG/PRO are registered trademarks of QAD Inc. The QAD logo is a trademark of QAD Inc. Designations used by other companies to distinguish their products are often claimed as trademarks. In this document, the product names appear in initial capital or all capital letters. Contact the appropriate companies for more information regarding trademarks and registration. Copyright 2013 by QAD Inc. DatabaseDefinitions_TR_v2013_1EE.pdf/mat/mat QAD Inc. 100 Innovation Place Santa Barbara, California 93108 Phone (805) 566-6000 http://www.qad.com
3. 3. Contents Change Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii About This Guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Introduction ............................................................................................................................................... 2 How This Book Is Organized .................................................................................................................... 2 Symbols and Conventions ........................................................................................................................ 3 AAA_F_20121217 Generated Finance Info........................................................................ 5 abscc_det Sales Order Detail Container Charges................................................. 5 absc_det Shipment Carrier Detail........................................................................ 6 absd_det Shipment Line Item Detail .................................................................... 6 absi_mstr Shipper Information Master.................................................................. 6 absl_det Shipment Detail Line Charges.............................................................. 7 abspli_ref Purchase Order Shipper/Invoice Cross Reference .............................. 8 absp_det Subshipper PO Cross Reference......................................................... 8 absr_det Shipment Requirement Detail .............................................................. 8 abssc_det Shipper Validation Error Log ................................................................ 9 abssi_det Shipment Signature Detail.................................................................. 10 abss_det Shipment Sequence Detail................................................................. 10 absw_det ABS Lot/Serial Detail.......................................................................... 12 absx_det Subcontract Shipper PO Shipper Cross Reference ........................... 12 abs_mstr ASN/BOL/Shipper Master .................................................................. 13 AcctIF Chinese Accounting Interface ............................................................ 15 AcctIFFilter Chinese Accounting Interface Filter ................................................... 16 acdf_mstr Account Default Master...................................................................... 16 acm_mstr Co-product/By-product Average Cost Master .................................... 17 acod_mstr Application Code Master .................................................................... 17 actf_mstr Info on table and the related account, sub-account, cc field names .. 18 act_mstr Alternate Container Master ................................................................ 19 ac_mstr Account Master .................................................................................. 19 adc_ctrl Address Control.................................................................................. 20 Address Address .............................................................................................. 20 AddressType Address Type ..................................................................................... 22 adx_det External Address Cross-Reference Detail.......................................... 23 ad_mstr Address Master .................................................................................. 24 Agent Salesperson ....................................................................................... 25 AIMW Warehousing Work Table................................................................... 26 ald_det Allocation Account Detail.................................................................... 27 AlgoAssD Warehousing Algorithm Assignment Detail........................................ 27 AlgoAssM Warehousing Algorithm Assignment Master ...................................... 28 AlgoM Warehousing Algorithm Master.......................................................... 29 AlgoTypeM Warehousing Algorithm Type Master................................................. 30 Allocation Allocation Definition............................................................................ 31 AllocationBatch Allocation Batch.................................................................................. 31 AllocationBatchLine Allocation Batch Line.......................................................................... 32 AllocationLayer Allocation Layer.................................................................................. 32 AllocationPosting Allocation Posting............................................................................... 33
4. 4. iv Database Definitions AllocationProportional Proportional Allocation ....................................................................... 33 alm_mstr Automatic Lot Master ......................................................................... 33 AltCOAGroup Alternate COA Group ......................................................................... 34 AltCOAStruct Alternate COA Structure..................................................................... 35 AltCOAStructDet Alternate COA .................................................................................... 36 AltTaskM Warehousing Alternate Task Master.................................................. 37 AltUMD Warehousing Alternate Unit of Measure Detail .................................. 37 AltUMM Warehousing Alternate Unit of Measure Master ................................ 38 al_mstr Allocation Account Master.................................................................. 39 anl_det Analysis Code Link Detail................................................................... 39 ans_det Analysis Code Selection Detail .......................................................... 40 anx_det Analysis Code Exploded Detail .......................................................... 40 an_mstr Analysis Code Master ........................................................................ 41 apc_ctrl Accounts Payable Control.................................................................. 41 APMatching Accounts Payable Matching............................................................... 42 APmatchingLn Accounts Payable Matching Line ....................................................... 43 APMatchingLnRevTax Accounts Payable Matching Line Rev Tax......................................... 45 APMatchingLnTax Accounts Payable Matching Line Tax Detai....................................... 46 APMatchingLnWHT Accounts Payable Matching Line Tax Detail...................................... 47 apmr_mstr Advanced Pricing Management Customer Relationship Master........ 48 apm_ctrl Advanced Pricing Management Control............................................. 49 ApproveStatusTrans Approve Status Transition.................................................................. 49 aprm_mstr Application Parameter Master............................................................ 50 apr_mstr Application Registry............................................................................ 50 arc_ctrl Accounts Receivable Control ............................................................. 52 art_mstr Application Return Code Master ........................................................ 53 atdcd_det Audit Trail Database Connection Detail ............................................. 54 atdc_mstr Audit Trail Database Connection Master............................................ 54 atg_mstr Audit Trail Group Master .................................................................... 54 atp_det Available-to-Promise Detail................................................................ 55 att_mstr Audit Trail Table Master ..................................................................... 55 aud_det Audit Detail......................................................................................... 56 AutoNumber Automatic Numbering......................................................................... 56 avatax_ctrl Settings required to communicate with Avatax tax engine................. 57 BankAccFormat Bank Account Format......................................................................... 57 BankAccFormatSect Bank Account Format Section............................................................ 58 BankFileFormat Bank File Format................................................................................ 58 BankFileFormatTransType Bank File Format Transaction Type ................................................... 58 BankImp Bank Statement Import....................................................................... 59 BankImpLine Bank Statement Import Line............................................................... 59 BankImpLineLog Bank Statement Import Line Log........................................................ 60 BankNumber Bank Number ..................................................................................... 61 BankNumberPayCode Bank Number Payment Format Code ................................................ 62 BankPayFormat Bank Payment Format........................................................................ 62 BankState Bank Statement.................................................................................. 63 BankStateAlloc Bank Statement Allocation ................................................................. 64 BankStateAllocColl Bank Statement Selection Allocation ................................................. 65 BankStateImport Import Bank Statements..................................................................... 66 BankStateLine Bank Statement Line.......................................................................... 67 BankStateStageAlloc Bank Statement Stage Allocation....................................................... 68 BatchPickC Warehousing Batch Picking Contol.................................................... 68 BatchPickD Warehousing Batch Picking Detail ..................................................... 70 BatchPickM Warehousing Batch Picking Master ................................................... 71 bcd_det Batch Control Detail ........................................................................... 73 bc_mstr Batch Control Master.......................................................................... 73 bdld_det Batch Data Load Detail ...................................................................... 74 bdl_mstr Batch Data Load Master..................................................................... 74 bdp_det Bank Driver Payment Detail ............................................................... 74 bic_ctrl Service/Support Contract Billing Control............................................ 75
5. 5. Contents v BLWIGroup BLWI Group........................................................................................ 75 bl_ctrl Master Bill of Lading Control .............................................................. 76 bom_mstr Product Structure (Bill of Material) Master ......................................... 76 Box1099 1099 Box ............................................................................................ 77 Box1099PurchaseTypeLink 1099 Box Purchase Type Link ........................................................... 78 btb_det Enterprise Material Transfer Primary Business Unit Detail ................ 78 btrd_det Blocked Transaction Detail................................................................. 78 btr_mstr Blocked Transaction Master............................................................... 79 Budget Budget................................................................................................ 79 BudgetCompany Budget Entity...................................................................................... 81 BudgetFDS Budget COA ....................................................................................... 81 BudgetGroup Budget Group..................................................................................... 81 BudgetLink Budget Posting Commitment Link...................................................... 82 BudgetLinkAcc Budget Accumulation by Period ......................................................... 82 BudgetLinkAccDet Budget Accumulation by Sub-ledger.................................................. 83 BudgetLinkActual Budget Posting Link ........................................................................... 83 BudgetLinkCommit Budget Commitment Link................................................................... 84 BudgetPeriod Budget Period..................................................................................... 85 BudgetReport Budget Report .................................................................................... 86 BudgetReportDetail Budget Report Detail.......................................................................... 86 BudgetVersion Budget Version................................................................................... 87 BudgetVersionFig Budget Version Figures...................................................................... 88 BudgetVersionGLFig Budget Version GL Figures................................................................ 92 BudgetWBS Budget Topic ...................................................................................... 96 BudgetWBSBusComponent Budget Topic Component Link........................................................... 98 BudgetWBSRoster Budget Topic Forecast ....................................................................... 98 BulkPickC Warehousing Bulk Pick Control.......................................................... 99 BulkPickD Warehousing Bulk Pick Detail .......................................................... 100 BulkPickDH Warehousing Bulk Pick Detail History.............................................. 101 BulkPickM Warehousing Bulk Pick Master ........................................................ 103 BusArea Business Area .................................................................................. 103 BusAreaComponent Business Area - Business Component Link ..................................... 104 BusinessRelation Business Relation............................................................................. 104 BusRelationSafDefault Business Relation Saf Default.......................................................... 106 cac_ctrl Service/Support Call Master Control................................................ 106 cah_hist Service/Support Call History ............................................................ 107 cald_det Calendar Detail................................................................................. 108 CalendarD Warehousing Calendar Detail .......................................................... 109 CalendarM Warehousing Calendar Master......................................................... 109 calh_det Calendar Holiday Detail.................................................................... 110 calm_mstr Calendar Master............................................................................... 110 cals_det Shift Detail........................................................................................ 111 cal_det Calendar Detail................................................................................. 112 caq_mstr Service/Support Call Queue Master................................................. 112 CashGroup Cash Group...................................................................................... 113 CashReport Cash Report ..................................................................................... 113 CashReportGL Cash Report Account ....................................................................... 114 CashReportGLLine Cash Report Account Line ............................................................... 114 cas_mstr Service/Support Call Status Master ................................................. 115 ca_mstr Service/Support Call Master............................................................. 115 CBalance Supplier Balance .............................................................................. 118 ccc_ctrl Credit Card Control .......................................................................... 120 ccd_mstr Service/Support Call Fault Code Master.......................................... 120 cclscd_det Ship-To/Container Price List Detail .................................................. 121 cclsc_mstr Ship-To/Container Master ................................................................ 121 ccls_mstr Container/Line Charge Ship-From/Ship-To Control Master ............. 122 ccl_ctrl Container/Line Charge Control......................................................... 122 CCollection Supplier PaymentSelection .............................................................. 123 cctr_hist Credit Card Transaction History....................................................... 124
6. 6. vi Database Definitions cct_mstr Container Charge Type Master........................................................ 125 cc_mstr Cost Center Master .......................................................................... 126 cdf_mstr Service/Support Call Default Master ................................................ 126 CDocInvoiceXrefStage Supplier Payment Invoice Xref Stage............................................... 127 CDocument Supplier Payment............................................................................. 127 CDocumentInvoiceXref Supplier Payment Invoice Xref......................................................... 129 CDocumentPostingLine Supplier Payment Posting Line ........................................................ 130 CDocumentStatus Supplier Payment Status.................................................................. 130 cd_det Master Comments............................................................................ 131 ChargesD Warehousing Shipment Detail Charges ........................................... 131 chg_mstr Line Changeover Master.................................................................. 132 CHist Supplier Balance History.................................................................. 132 chm_mstr Service/Support Call History Master ................................................ 134 cild_det Correction Invoice Link Detail........................................................... 137 cil_mstr Correction Invoice Link Master......................................................... 137 CInvoice Supplier Invoice................................................................................ 138 CInvoiceBank Supplier Invoice Bank Records ........................................................ 142 CInvoiceBankPayCode Supplier invoice Bank Payment Code.............................................. 142 CInvoiceMovement Supplier Invoice Movements ............................................................ 142 CInvoicePO Supplier Invoice PO Matching Link .................................................. 144 CInvoicePosting Supplier Invoice Posting Link ........................................................... 144 CInvoiceStage Supplier Invoice Stage Payment ...................................................... 144 CInvoiceVat Supplier Invoice Tax Records .......................................................... 145 CInvoiceWHT Supplier Invoice Withholding Tax..................................................... 146 clatd_det UDF Attribute Value Detail ............................................................... 148 clat_mstr UDF Attribute Master........................................................................ 148 clc_ctrl Compliance Control.......................................................................... 149 ClientCache client cache ...................................................................................... 149 clsd_det UDF Class Table Detail.................................................................... 150 clsf_mstr Classification Master ........................................................................ 150 CMask Period Closing Mask ........................................................................ 150 CMaskJournal Closing Mask Journal....................................................................... 151 CMaskJrnlGroup Closing Mask Journal Group............................................................ 152 cmc_ctrl Customer Control ............................................................................. 153 cmd_det Enterprise Material Transfer Change Management Detail............... 154 cmf_mstr Enterprise Material Transfer Change Management Master ............. 154 cmh_hist Customer Sales History.................................................................... 154 cmt_det Transaction Comments .................................................................... 155 cm_mstr Customer Master.............................................................................. 156 cncix_mstr Consigned Shipment Inventory Cross-Reference Master................ 158 cncs_mstr Customer Consignment Ship-To/Item Master.................................. 159 cncud_det Customer Consignment Shipment Usage Detail.............................. 160 cncu_mstr Customer Consignment Shipment Usage Master............................ 160 cnc_ctrl Customer Consignment Control....................................................... 161 cnsix_mstr Supplier Consignment Receipt Inventory Master............................. 162 cnss_mstr Supplier Consignment Supplier/Item Master.................................... 163 cnsud_det Supplier Consignment Receipt Usage Detail ................................... 163 cnsu_mstr Supplier Consignment Receipt Usage Master ................................. 164 cns_ctrl Supplier Consignment Control ......................................................... 164 CnvXref Temporary Table used for converting SCBA.................................... 165 COACrossRef COA Cross Reference...................................................................... 165 COACrossRefDet Cross Reference Detail .................................................................... 166 COAMaskCC COA Mask Cost Center.................................................................... 166 COAMaskCCDiv COA Mask Cost Center Range GL .................................................. 167 COAMaskCCGL COA Mask Cost Center Range GL .................................................. 167 COAMaskDiv COA Mask Sub-Account .................................................................. 168 COAMaskDivGL COA Mask Sub-Account Range GL Account................................... 168 COAMaskProj COA Mask Project............................................................................ 169 COAMaskProjCC COA Mask Project Range Cost Center............................................ 170
7. 7. Contents vii COAMaskProjDiv COA Mask Project Range Sub-Account........................................... 170 COAMaskProjGL COA Mask Project Range GL .......................................................... 170 code_mstr Generalized Code Master ................................................................ 171 comd_det Commodity Code Detail ................................................................... 171 Company Entity ................................................................................................ 172 CompanyProperty Entity Property.................................................................................. 172 CompanySharedSet Company Shared Set....................................................................... 175 com_mstr Commodity Code Master.................................................................. 175 ConCheck Consistency Check........................................................................... 175 ConCheckLine Consistency Check Line................................................................... 176 ConCheckLineDet Consistency Check Line Detail......................................................... 177 Consolid Consolidation.................................................................................... 178 ConsolidCycle Consolidation Cycle.......................................................................... 179 ConsolidCycleCompany Entity Consolidation Cycle................................................................ 179 ConsolidCycleSaf Consolidation Cycle Saf ................................................................... 180 ConsolidDump Consolidation Export ........................................................................ 180 ConsolidLayer Consolidation Layer.......................................................................... 181 ConsolidPeriodXref Consolidation Period Cross-reference ............................................. 181 ConsolidPostingXref Consolidation Posting Cross-Reference .......................................... 182 Contact Contact............................................................................................. 182 cont_mstr Container Type Master..................................................................... 183 CorporateGroup Corporate Group .............................................................................. 185 CostCentre Cost Center ...................................................................................... 185 CostCentreSafDefault Cost Center SAF Default.................................................................. 187 cost_cal Cost Set Calendar............................................................................ 187 Country Country............................................................................................. 188 CountryVatFormat Country Tax Format ......................................................................... 189 County County.............................................................................................. 189 co_ctrl General Ledger (Company) Control................................................. 190 CPay Supplier Payment............................................................................. 191 cpcd_det Customer Period Calendar Detail..................................................... 191 cpc_mstr Customer Period Calendar Master................................................... 191 cph_hist Customer/Item Sales History............................................................ 192 cp_mstr Customer Item Master...................................................................... 193 crc_ctrl Carrier Control.................................................................................. 193 crd_det Call Reminder Detail Table .............................................................. 194 Creditor Supplier ............................................................................................ 194 CreditorSafDefault Supplier SAF Default........................................................................ 196 CreditorType Supplier Type ................................................................................... 197 CreditorVat Supplier Tax ..................................................................................... 197 cref_mstr Service/Support Cross-Reference Master........................................ 198 csa_mstr Controlled Substance Authority Master............................................ 198 cscp_det Link table between Period, currency, cost set for Periodic Costing . 198 csc_mstr Controlled Substance Customer Master .......................................... 200 csd_det Service/Support Call Skill Detail....................................................... 200 csid_det Controlled Substance Item Detail..................................................... 201 csil_mstr Controlled Substance Individual License Master ............................. 201 csim_mstr Controlled Substance Item Master................................................... 202 csld_det Controlled Substance Individual License Detail ............................... 202 cslm_mstr Controlled Substance General License Master................................ 203 cssi_det Site Cost Detail................................................................................. 203 css_mstr Controlled Substance Site Master.................................................... 204 cst_mstr Fixed Asset Custodian Master ......................................................... 204 cs_mstr Cost Set Master................................................................................ 205 ctd_det Credit Terms Detail .......................................................................... 205 ctg_mstr Category Master............................................................................... 205 ctry_mstr Country Master................................................................................. 206 ct_mstr Credit Terms Master......................................................................... 206 Currency Currency........................................................................................... 207
8. 8. viii Database Definitions CustInventM Warehousing Customer/Inventory Status Master............................. 208 CustPartM Warehousing Customer/Item Master................................................ 209 cu_mstr Currency Master............................................................................... 210 CyGroup Company Group............................................................................... 210 CyGroupCompany Company Group............................................................................... 211 dald_det Destination Application List Detail.................................................... 212 dal_mstr Destination Application List Master .................................................. 213 DBalance Customer Balance............................................................................ 214 dbs_mstr Database Revision Control Master................................................... 214 DCollection Customer Payment Selection........................................................... 214 DCollectionExport Customer Payment Selection Export ............................................... 216 dc_mstr Database Connection Master........................................................... 216 DDocInvoiceXrefStage Customer Payment Invoice Xref Stage ............................................ 217 DDocument Customer Payment........................................................................... 217 DDocumentInvoiceXref Customer Payment Invoice Cross-Reference.................................. 219 DDocumentPayCode Customer Payment Payment Code.................................................. 219 DDocumentPostingLine Customer Payment Posting Line...................................................... 220 DDocumentStatus Customer Payment Status ............................................................... 220 Debtor Customer.......................................................................................... 220 DebtorCreditRating Customer Credit Rating.................................................................... 223 DebtorEndUser Customer End User.......................................................................... 223 DebtorSafDefault Customer SAF Default ..................................................................... 224 DebtorShipTo Customer Ship-To ............................................................................ 225 DebtorType Customer Type................................................................................. 226 decl_mstr Declarant Master.............................................................................. 226 DeductionCat Deduction Category.......................................................................... 227 DeductionCatLine Deduction Category Line.................................................................. 228 DeductionCatLineSaf Deduction Category Line Saf ........................................................... 229 ded_det Data Entry Detail .............................................................................. 230 deed_det Data Entry Extension Detail ............................................................. 230 dee_mstr Data Entry Extension Master............................................................ 231 defc_det Data Entry Frame Sequence Condition Detail ................................. 232 defd_det Data Entry Frame Detail................................................................... 232 deff_det Data Entry Frame Field Detail.......................................................... 233 defl_det Data Entry Field Detail ..................................................................... 233 defr_det Service Contract Deferred/Accrued Revenue Detail........................ 234 defs_det Data Entry Frame Sequence Detail.................................................. 235 DeliveryCond Delivery Condition ............................................................................ 235 delt_mstr Delivery Time Master ....................................................................... 236 dep_mstr Data Entry Profile Master ................................................................. 236 deu_det Data Entry User Detail...................................................................... 237 de_mstr Data Entry Master ............................................................................ 237 df_mstr Document Print Format Master ........................................................ 238 DHist Customer Balance History................................................................ 238 DInvoice Customer Invoice ............................................................................. 239 DInvoiceBank Customer Invoice Bank Records...................................................... 243 DInvoiceBankPayCode Customer Invoice Bank Payment Code ........................................... 243 DInvoiceDeduction Deduction of Invoice......................................................................... 244 DInvoiceMovement Customer Invoice Movements.......................................................... 245 DInvoiceOpInfo Customer Invoice Operational Info................................................... 246 DInvoicePosting Customer Invoice Posting Link......................................................... 247 DInvoiceShipper Customer Invoice Shipper References............................................. 248 DInvoiceStage Customer Invoice Stage Payment.................................................... 248 DInvoiceVat Customer Invoice Tax Records........................................................ 248 Division Sub-Account..................................................................................... 249 dmw_wkfl Draft Management Work Table ........................................................ 251 DomainProperty Domain Property .............................................................................. 251 Domains Domain............................................................................................. 252 DomainSharedSet Domain Shared Set.......................................................................... 253
9. 9. Contents ix dom_mstr Domain Master................................................................................. 253 dosr_det Depot Order Shipment/Receipt Table .............................................. 253 DPay Customer Payment........................................................................... 254 DPaySel Customer Payment Selection........................................................... 254 DPaySelLine Customer Payment Selection Payment Code.................................. 255 DPaySelLineStg Customer Payment Selection Payment Code.................................. 256 DPaySelPayCode Customer Payment Selection Payment Code.................................. 256 DPaySelPayRef Customer Payment Selection Payment Code.................................. 257 dpt_mstr Department Master........................................................................... 257 drp_ctrl Distribution Requirements Planning Control .................................... 258 dsd_det Distributed Site Requisition Detail.................................................... 259 dsr_mstr Distributed Site Requisition Master .................................................. 260 dss_mstr Distributed Site Order Master........................................................... 260 ds_det Distributed Site Order Detail............................................................. 262 dvfv_det Data Validation Field Value Detail.................................................... 263 dvf_det Data Validation Field Detail.............................................................. 263 dvshx_ref Data Validation Rule Cross Reference............................................. 264 dv_mstr Data Validation Master..................................................................... 264 dybs_mstr Daybook Set Master......................................................................... 264 dyd_mstr General Ledger Default Daybook Master......................................... 265 dy_mstr General Ledger Daybook Master ..................................................... 265 ea_mstr Earnings Master ............................................................................... 266 eca_mstr Engineering Change Approval Master ............................................. 266 ecd1_det Engineering Change Product Structure Detail ................................. 267 ecd2_det Engineering Change Routing Detail................................................. 268 ecd3_det Engineering Change Text File Detail................................................ 268 ecd4_det Product Change Control Test Results Detail.................................... 269 ecd5_det Product Change Control Item Routing Detail ................................... 269 ecd9_det Engineering Change Approval Detail ............................................... 270 ecd_det Engineering Change Item Detail ...................................................... 271 ecl_list Engineering Change Master Lists .................................................... 271 ecm_mstr Engineering Change Master............................................................. 272 ect_mstr Engineering Change Type Master.................................................... 273 ecx_ref External Order Cross-Reference...................................................... 273 edlg_hist Export Delivery Log.......................................................................... 274 ega_mstr Service/Support Engineer Availability Master .................................. 275 egc_ctrl Service/Support Engineer Schedule Control.................................... 275 egd_det Service/Support Engineer Schedule Detail ...................................... 276 egs_det Service/Support Engineer Problem/Skills Detail .............................. 278 egt_mstr Service/Support Engineer Tracking Master...................................... 278 egw_wkfl Service/Support Engineer Selection Work Table ............................. 280 elg_hist Export Document Log....................................................................... 280 emap_det Mapped Export Document Detail ..................................................... 282 emg_msg Export Document Message.............................................................. 283 Employee Employee ......................................................................................... 283 emp_mstr Employee Master ............................................................................. 285 emsg_mstr Service/Support Engineer Message Master..................................... 286 em_mstr E-mail Master ................................................................................... 287 EngineC Warehousing Engine Processing Control......................................... 288 EngineH Warehousing Engine Processing History......................................... 289 EngineW Warehousing Engine Work Table..................................................... 290 eng_mstr Service/Support Engineer Master .................................................... 292 en_mstr Entity Master .................................................................................... 293 ERAssD Warehousing External Routing Assignment Detail........................... 293 eraw_det Raw Export Document Detail ........................................................... 294 ERD Warehousing External Routing Detail .............................................. 295 ERM Warehousing External Routing Master............................................. 296 ERS Evaluated Receipt Settlement History.............................................. 297 ERSLine Evaluated Receipts Settlement History De ...................................... 297
10. 10. x Database Definitions ers_mstr Evaluated Receipts Settlement Master ............................................ 298 esapfc_det E-Signature Activated Profile Filter Criteria...................................... 298 esapfil_det E-Signature Activated Profile Filter .................................................. 299 esapfs_det E-Signature Activated Profile Filter Set............................................ 299 esapf_det E-Signature Activated Profile Field................................................... 299 esapmp_ref E-Signature Activated Profile Menu Program Cross-Reference ...... 300 esaps_det E-Signature Activated Profile Structure............................................ 300 esap_mstr E-Signature Activated Profile ........................................................... 301 escat_mstr E-Signature Category Master........................................................... 301 escd_det E-Signature Category Detail............................................................. 301 escf_ref E-Signature Category Filter Cross-Reference.................................. 302 escx_det E-Signature Category XML Detail .................................................... 302 esc_ctrl Service/Support Escalation Control.................................................. 303 esfil_mstr E-Signature Filter ............................................................................. 303 esgc_ref E-Signature Group Category Cross-Reference................................ 303 esh_mstr Service/Support Engineer Schedule Master .................................... 304 esig_mstr E-Signature Master .......................................................................... 305 esp_mstr Export Document Specification Master ............................................ 305 esrec_det E-Signature Record List ................................................................... 307 ess_mstr Service/Support Engineer Status Master ......................................... 307 eswpfc_det E-Signature Workbench Profile Filter Criteria .................................. 307 eswpfil_det E-Signature Workbench Profile Filter............................................... 308 eswpfs_det E-Signature Workbench Profile Filter Set......................................... 308 eswpf_det E-Signature Workbench Profile Field ............................................... 309 eswpmp_ref E-Signature Workbench Profile Menu Program Cross-Reference... 309 eswps_det E-Signature Workbench Profile Structure ........................................ 309 eswp_mstr E-Signature Workbench Profile........................................................ 310 es_mstr Service/Support Escalation and Repair Master................................ 311 et_ctrl EMU Control..................................................................................... 312 euc_ctrl Service/Support End User Control ................................................... 313 eud_det Service/Support End User Detail...................................................... 313 eus_mstr Service/Support End User Schedule Master.................................... 314 eu_mstr Service/Support End User Master.................................................... 314 EventDaemon Event daemon .................................................................................. 316 ExchangeRate Exchange Rate................................................................................. 316 ExchangeRateType Exchange Rate Type........................................................................ 317 ExpenseCode Expense Code.................................................................................. 318 ExpenseGLMatrix Expense GL Matrix........................................................................... 318 ExpNoteCInvoice Expense Note Supplier Invoice ........................................................ 319 ExpNoteLineSaf Expense Note Line Saf..................................................................... 319 exr_rate Exchange Rate Master..................................................................... 320 faadj_mstr Fixed Asset Adjustment Master........................................................ 320 FAAssetBookDeprec Asset Book Depreciations ................................................................ 322 FAAssetGLSaf Asset Book Account SAF ................................................................. 322 FAAssetSaf Asset Saf.......................................................................................... 322 FAAssetTypeFABook Fixed Asset Type-Book Cross-Reference........................................ 323 faba_det Fixed Asset Account Detail .............................................................. 323 fabchd_det Fixed Asset Batch Detail .................................................................. 324 fabch_mstr Fixed Asset Batch Master ................................................................ 325 fabdy_det FA Book and Daybook link detail table............................................. 325 fabd_det Fixed Asset Book Depreciation Detail.............................................. 326 fabk_mstr Fixed Asset Book Master ................................................................. 327 fab_det Fixed Asset Book Detail ................................................................... 328 FACapitalAssetBook Fixed Asset Capitalization Asset Book............................................. 329 facd_det Fixed Asset Class Account Detail .................................................... 329 facld_det Fixed Asset Calendar Detail............................................................. 329 facls_mstr Fixed Asset Class Master................................................................. 330 facl_cal Fixed Asset Calendar Master........................................................... 330 fact_ctrl Fixed Asset Control.......................................................................... 331
11. 11. Contents xi fac_ctrl Final Assembly Control .................................................................... 332 FADepreciationDetSaf Depreciation Detail SAF................................................................... 333 FADepreciationPosting Depreciation Posting ........................................................................ 333 fadf_mstr Fixed Asset Book Default Master..................................................... 333 FADisposalDetSaf Fixed Asset Disposal Detail Saf ....................................................... 334 fad_det Fixed Asset Component Detail......................................................... 334 faloc_mstr Fixed Asset Location Master............................................................ 335 fal_mstr Fixed Asset Location Code Master .................................................. 335 famtd_det Fixed Asset Custom Table Detail..................................................... 336 famtrd_det Fixed Asset Meter Detail .................................................................. 336 famtr_mstr Fixed Asset Meter Master ................................................................ 337 famt_mstr Fixed Asset Method Master.............................................................. 337 FARevalDetSaf Fixed Asset Revaluation Detail SAF ................................................ 338 FARevalPosting Fixed Asset Revaluation Posting...................................................... 339 fas_ctrl Fixed Asset System Control............................................................. 339 fauop_det Fixed Assets UOP Forecast Detail................................................... 339 FavBusComponent Favorites........................................................................................... 340 fa_mstr Fixed Asset Master........................................................................... 340 fcc_mstr Service/Support Charge Code Product Line Master ........................ 342 fcDraftInstanceData draft instance.................................................................................... 343 fcd_mstr Service/Support Default Charge Code Master................................. 343 fcg_mstr Service/Support Charge Code Master ............................................. 343 fcIdmObject IDOM document ............................................................................... 344 fcInstance State................................................................................................. 345 fcl_mstr Item Fiscal Class Master.................................................................. 345 fcs_sum Forecast Summary........................................................................... 345 fct_mstr Service/Support Call Type Master.................................................... 346 fc_det Seasonal Build Detail ....................................................................... 346 ff_mstr Simulated Forecast Master .............................................................. 347 fh_mstr Family Hierarchy Master .................................................................. 347 fis_mstr Invoice Sort Master .......................................................................... 348 fkt_mstr Service/Support Kit Master............................................................... 349 flcrh_hist Flow Line Capacity Rate History ...................................................... 350 flcr_mstr Flow Line Capacity Rate Master ...................................................... 350 fldattr_mstr Field Attribute Master ....................................................................... 351 fldf_mstr Field Default Master ......................................................................... 351 flff_mstr Flow Flex Fence Master................................................................... 353 flh_mstr Field Help Program Master .............................................................. 353 flpw_mstr Field Security Master........................................................................ 354 flp_plan Family Line Plan............................................................................... 354 flscd_det Flow Schedule Code Detail.............................................................. 354 flsc_mstr Flow Schedule Code Master ............................................................ 355 flsd_det Flow Schedule Detail........................................................................ 356 fnd_det Service/Support Field Notification Detail.......................................... 357 fnh_hist Service/Support Field Notification History........................................ 358 fn_mstr Service/Support Field Notification Master ........................................ 359 fp1_plan Family Production Backlog and Cost Plan ....................................... 360 fp2_plan Family Production Inventory and Order Plan ................................... 361 fp3_plan Family Production and Shipment Plan ............................................. 362 fpci_mstr Service/Support Price Indexing Master............................................ 362 fpc_mstr Service/Support Pricing Master........................................................ 363 fpd_cost Family Item Cost Detail .................................................................... 364 fpst_mstr Return Status Master ....................................................................... 365 frcd_det Freight Charge Detail ....................................................................... 365 frd_det Freight Rate Detail ........................................................................... 366 frm_mstr Freight Rate Master.......................................................................... 366 FRWAnCode Report Analysis Code....................................................................... 367 FRWAnCodeElem Analysis Code COA Element ........................................................... 368 FRWAnCodeElemDet Analysis Code COA Element Detail ................................................. 369
12. 12. xii Database Definitions FRWBuildLog Cube Build Log................................................................................. 369 FRWChart Report Chart..................................................................................... 371 FRWCol Report Column Group ...................................................................... 372 FRWColDet Financial Report Writer Column GroupDetail................................... 373 FRWCompany Report Chart Entity........................................................................... 374 FRWCrossRef Report Chart Linked COA Cross Ref ............................................... 375 FRWCube Report Cube..................................................................................... 376 FRWCubeCy Report Cube Entity........................................................................... 378 FRWCubeDim Report Cube Dimension................................................................... 379 FRWCubeGLPd GL Period Linked to Report Period .................................................. 382 FRWCubeHistLink Report Cube Balance link to GL History........................................... 383 FRWCubeLayer Cube Layer Relation table................................................................ 384 FRWCubeMeas Report Cube Balance....................................................................... 385 FRWCubePeriod Report Cube Period.......................................................................... 387 FRWRepMstr Financial Report Writer Column Group ............................................ 388 FRWRepMstrRole Financial Report Writer Security Roles for Report ........................... 389 FRWShSetComb Report Chart Combination of Shared Sets....................................... 390 FRWTreeNode Report Tree Node............................................................................. 391 FRWTreeView Report Tree View ............................................................................. 392 FRWUsrDefault Financial Report Writer User Default Settings.................................. 394 frzd_det Freight Zone Detail........................................................................... 394 fr_mstr Freight List Master............................................................................ 395 fsc_mstr Service Category Master.................................................................. 395 fsd_det Service/Support Call Activity Detail.................................................. 396 fsh_mstr Service/Support Holiday Master....................................................... 397 fslp_pln Simulation Line Plan......................................................................... 398 fsp1_pln Family Simulation Backlog and Cost Plan........................................ 399 fsp2_pln Family Simulation Inventory and Order Plan.................................... 399 fsp3_pln Family Simulation Production and Shipment Plan ........................... 400 fspd_det Service/Support Parts List Detail...................................................... 400 fsu_mstr Service/Support User Preference Master......................................... 401 ftch_hist Service/Support Trace History ......................................................... 401 ft_mstr Freight Terms Master....................................................................... 402 fwk_mstr Service/Support Work Code Master................................................. 403 genfldd_det Generic Field Detail.......................................................................... 403 giap_mstr Application Definition Master............................................................ 404 gimd_mstr Model Definition Master.................................................................... 404 gip_det Table Attribute Detail........................................................................ 405 gisi_mstr Site/Item Model Definition Master .................................................... 405 GL GL Account....................................................................................... 406 GLCalendar GL Calendar..................................................................................... 408 glccp_detglcd_det General Ledger Calendar Detail....................................................... 409 GLConsolidCy GL Consolidation Company RateTypes........................................... 410 glcor_ctrl GL Correction Control File................................................................ 411 glc_cal General Ledger Calendar................................................................. 411 GLMirror GL Account Mirror ............................................................................ 412 GLOpenItem GL Open Item................................................................................... 412 GLOpenItemMovement GL Open Item Movement................................................................. 414 GLReportLink GL Report Link ................................................................................. 414 GLSafDefault GL Account SAF Default .................................................................. 414 GLSystemType GL Account System Type................................................................. 415 gltsaf_det GL Account SAF Detail .................................................................... 415 gltw_wkfl General Ledger Work Table............................................................. 416 GLType GL Account Type.............................................................................. 416 glt_det General Ledger Unposted Transaction Detail.................................. 417 gl_ctrl System/Account Control................................................................... 418 grac_det GL Report Writer Account Balances ................................................ 422 grad_det GL Report Writer Analysis Code Detail............................................ 424 gral_det GL Report Writer Analysis Code Link-File Detail ............................. 424
13. 13. Contents xiii gras_det GL Report Writer Selection Detail .................................................... 425 gra_mstr GL Report Writer Analysis Code Master .......................................... 425 grbg_det GL Report Writer Budgeted Account Balance Detail........................ 426 grcd_det GL Report Writer Column Group Detail............................................ 427 grc_mstr GL Report Writer Column Group Master.......................................... 428 grdf_mtx GL Report Writer Definition Matrix ................................................... 428 grhd_det GL Report Writer Group Row/Column Sequence Detail .................. 429 grib_det GL Report Writer Break Group Detail............................................... 429 gric_det GL Report Writer Image Column Detail............................................ 430 grid_det GL Report Writer Report Image Detail ............................................. 430 grig_mtx GL Report Writer Report Image Matrix............................................. 431 grit_wkf GL Report Writer Analysis Code and Item Type Work Table........... 432 gri_mstr GL Report Writer Report Image Master ........................................... 432 GrossIncAcc Gross Income Accounting ................................................................ 433 grqd_det GL Report Writer Fiscal Quarter Calendar....................................... 434 grrd_det GL Report Writer Row Group Detail................................................. 434 grr_mstr GL Report Writer Row Group Master............................................... 435 grtx_det GL Report Writer Text String Detail.................................................. 436 grv_det GL Report Writer Account Balance Detail........................................ 436 grx1_wkfl GL Report Writer Analysis Code Explosion Work Table .................. 437 grx2_wkfl GL Report Writer Row/Column Explosion (Separate) Work Table... 437 grx3_wkfl GL Report Writer Row/Column Explosion (Hier.) Work Table.......... 438 grx_mstr GL Report Writer Report Content Master......................................... 439 gr_ctrl GL Report Writer Control.................................................................. 439 gtidh_hist Golden Tax Invoice History Detail.................................................... 440 gtih_hist Golden Tax Invoice History Master .................................................. 441 gtnbr_det Golden Tax Invoice Cross Reference .............................................. 441 gt_ctrl Golden Tax Control .......................................................................... 442 hd_mstr Holiday Master ................................................................................. 442 hlp_mstr Help Master...................................................................................... 442 HoldM Warehousing Hold Master................................................................ 443 iach_hist Inventory Consumption History ........................................................ 445 iac_ctrl Obsolete Inventory Control Parameters........................................... 445 iad_mstr Obsolete Inventory Depreciation Rate Master ................................. 445 iaod_det Output File Field Detail..................................................................... 446 iao_mstr Output File Master............................................................................ 446 iasd_det Obsolete Inventory Control Site Detail ............................................. 447 iatd_det Inventory Type Field Detail............................................................... 447 iat_mstr Inventory Type Master...................................................................... 447 ibh_hist Sales Order Configuration Bill History.............................................. 448 ib_det Service/Support Installed Configuration Detail................................. 449 icc_ctrl Inventory Control.............................................................................. 449 idhlc_hist Invoice History Line Charge Detail................................................... 450 idhr_hist Invoice History Relationship Detail................................................... 451 idh_hist Invoice History Detail........................................................................ 452 iec_ctrl Import/Export Control ....................................................................... 455 ied_det Import/Export Detail.......................................................................... 456 ieh_hist Import/Export History........................................................................ 457 iepl_ctrl Poland Intrastat Declaration Control ................................................ 459 ie_mstr Import/Export Master........................................................................ 459 ifs_mstr Interface Session Master.................................................................. 460 ihcc_hist Invoice History Credit Card Master .................................................. 461 ihr_hist Invoice History Relationship Master................................................. 462 ih_hist Invoice History Master...................................................................... 462 ild_det Item Location Detail.......................................................................... 465 ilg_hist Import Document Log....................................................................... 466 imap_det Import Document Map Detail............................................................ 467 img_msg Import Document Message .............................................................. 468 im_mstr Inventory Movement Code Master ................................................... 469
14. 14. xiv Database Definitions Industry Industry............................................................................................. 469 ind_det Independent Demand Detail............................................................. 470 insd_det Invoice Schedule Detail.................................................................... 471 InspC Warehousing Inspection Control ...................................................... 471 InspH Warehousing Inspection History....................................................... 472 InspInvD Warehousing Inspected Inventory Detail.......................................... 474 InstallNetImport Install Net Import .............................................................................. 475 ins_mstr Invoice Schedule Master.................................................................. 475 InterWLGM Warehousing Inter Work Location Group Master............................. 476 InventHM Warehousing Inventory History Master ............................................ 477 InventM Warehousing Inventory Master ........................................................ 478 in_mstr Inventory Master............................................................................... 479 ipd_det Item Specification Detail................................................................... 480 iph_hist Pricing History .................................................................................. 481 ip_mstr Master Specification Test Results.................................................... 482 IRAssD Warehousing Internal Routing Assignment Detail............................ 482 iraw_det Raw Import Document Detail ........................................................... 483 IRD Warehousing Internal Routing Detail................................................ 484 IRGroupM Warehousing Internal Routing Group Master................................... 485 IRM Warehousing Internal Routing Master.............................................. 486 iro_det Item Routing Cost Detail .................................................................. 487 isb_mstr Service/Support Installed Base Item Master .................................... 489 isd_det Inventory Status Detail ..................................................................... 491 isp_mstr Import Document Specification Master ............................................ 491 iss_mstr Service/Support Installed Base Structure......................................... 492 isvc_mstr Statistical Value Calculation Master................................................. 493 is_mstr Inventory Status Master ................................................................... 493 itmh_hist Service/Support Call Item History .................................................... 494 itm_det Service/Support Call Item Detail ...................................................... 496 itsd_det Item Site Load Detail........................................................................ 498 its_mstr Item Site Load Master ...................................................................... 499 ivs_ctrl Invoice Schedule Control ................................................................. 499 Journal Daybook ........................................................................................... 500 JournalGroup Daybook Group ................................................................................ 501 JournalType Daybook Type .................................................................................. 501 kbc_ctrl Kanban Control ................................................................................ 502 kbdt_mstr Kanban Demand Template Master .................................................. 503 kbmd_mstr Kanban Maximum Demand Master.................................................. 503 kbpp_mstr Kanban Planning Period Master....................................................... 504 kbtrd_det Kanban Transaction History Detail................................................... 504 kbtrr_det Kanban Transaction Reject Detail.................................................... 505 kbtr_hist Kanban Transaction History............................................................. 505 kenb_det Ending Inventory Balance and Cost by Location.............................. 507 kia_mstr Inventory Account Change Master................................................... 508 knbadc_hist Kanban Average Demand Calculation History................................. 508 knbcd_det Kanban Cards Dispatch History ....................................................... 509 knbdd_mstr Kanban Document Definition Master................................................ 511 knbd_det Kanban Card Detail.......................................................................... 512 knbfd_det Kanban FIFO Process Detail............................................................ 513 knbism_det Kanban Item Supermarket Detail ..................................................... 513 knbi_mstr Kanban Item Master......................................................................... 514 knble_det Kanban Loop Event Detail................................................................ 515 knbl_det Kanban Loop Detail.......................................................................... 515 knbrs_mstr Kanban Dispatch Release Schedule................................................ 517 knbsm_mstr Kanban Supermarket Master ........................................................... 517 knbs_det Kanban Source Detail ...................................................................... 518 knb_mstr Kanban Master................................................................................. 518 knpd_det Kanban Process Item Detail............................................................. 519 knp_mstr Kanban Process Master................................................................... 519
15. 15. Contents xv kstc_det Ending Inventory Balance by Site .................................................... 520 LabourC Warehousing Labour Management Control ..................................... 521 lacd_det Logistics Accounting Charge Detail.................................................. 521 lacod_det Logistic Accounting Charge Detail by Order Line............................. 522 lac_ctrl Logistics Accounting Control............................................................ 523 lad_det Location Allocation Detail................................................................. 523 LaneAssD Warehousing Lane Assignment Detail ............................................. 524 LaneAssM Warehousing Lane Assignment Master ........................................... 525 LaneGroupD Warehousing Lane Group Detail...................................................... 525 LaneGroupM Warehousing Lane Group Master .................................................... 526 LaneM Warehousing Lane Master ............................................................... 527 Layer Layer ................................................................................................ 528 lblc_ctrl Label Control.................................................................................... 530 lcpr_mstr Logistics Charge Price List............................................................... 530 lc_mstr Logistics Accounting Charge Code Master ...................................... 531 ld_det Location Detail.................................................................................. 531 lgdc_ctrl Legal Document Control................................................................... 532 lgddl_det This is a link table between two legal document detail..................... 533 lgdd_det Legal Document Detail Table........................................................... 533 lgdfcb_det Legal Document Fiscal Control Balance Detail................................ 535 lgdfcd_det Fiscal Control Definition Detail ......................................................... 535 lgdfc_mstr Fiscal Control Definition Master ....................................................... 536 lgdnr_det Legal Document Address and Sequence ID Detail.......................... 536 lgdtx_det Legal Document Tax Usage of Simultaneous Op Setup Detail........ 537 lgd_mstr Legal Document Master ................................................................... 537 lgsi_det Logistics Site Detail.......................................................................... 539 lgs_mstr Logistics Master ............................................................................... 540 lna_det Production Line Allocation Detail...................................................... 541 lnd_det Production Line Detail ...................................................................... 542 lnf_det Flow Production Line Preference Detail........................................... 542 Lng Language ......................................................................................... 543 lngd_det Language Detail ............................................................................... 543 lng_mstr Language Master ............................................................................. 544 ln_mstr Line Master....................................................................................... 544 LoadD Warehousing Load Detail................................................................. 545 LoadM Warehousing Load Master ............................................................... 546 LoadMasterM Warehousing Load Master Master ................................................... 548 LoadSAddrD Warehousing Load Setup Address Detail ........................................ 549 LoadSetupM Warehousing Load Setup Master..................................................... 550 LoadSItemD Warehousing Load Setup Item Detail............................................... 550 LocalExitC Warehousing Local Exit Routine Control.......................................... 551 locc_det Reserved Locations Detail ............................................................... 552 LocDefD Warehousing Location Definition Detail ........................................... 553 LocDefM Warehousing Location Definition Master.......................................... 554 locd_det Ending Inventory Balance of a cost calculation period..................... 554 LocForD Warehousing Location Forecast Detail ............................................ 555 LocM Warehousing Location Master.......................................................... 556 locpd_det FiFo/LiFo history of unconsumed quantity onhand per period. ........ 557 LocUMM Warehousing Location Unit of Measure Master ............................... 558 LocW Warehousing Location Work Table .................................................. 559 loc_mstr Location Master................................................................................ 560 lotw_wkfl Lot Number Work Table ................................................................... 560 lot_mstr Lot Master ........................................................................................ 561 ls_mstr Address List Detail ........................................................................... 561 ltrenvd_det Logistics Trade Environment Detail.................................................. 562 ltrenv_mstr Logistics Trade Environment............................................................ 563 ltrznd_det Logistics Trade Zones Detail............................................................ 563 ltrzn_mstr Logistics Trade Zones...................................................................... 564 maxt_det Maximum Table Detail...................................................................... 565
16. 16. xvi Database Definitions max_mstr Maximums Master............................................................................ 565 ma_mstr Mirror Account Master...................................................................... 566 MessageD Warehousing Messaging Detail........................................................ 566 MessageM Warehousing Messaging Master...................................................... 567 mfc_ctrl Control Work Table .......................................................................... 568 mfrel_mstr Master Table Relationships.............................................................. 568 mfscl_mstr used for logging the changes made for MFS related tables............. 569 mfsc_ctrl QAD Mobile Field Service Control.................................................... 570 mfsd_det QAD Mobile Field Service User Detail ............................................. 570 mfslsd_det MFS Last Sync Detail....................................................................... 571 mfssld_det MFS Sync Log Detail........................................................................ 571 mfsu_mstr MFS User Master ............................................................................. 572 MirroringGL Mirror Account.................................................................................. 572 MirroringJournal Mirror Daybook................................................................................. 573 mnd_det Menu Detail ...................................................................................... 574 mnp_det Service/Support Custom Program Detail ......................................... 574 mnt_det Menu Title Detail .............................................................................. 575 mpd_det Master Specification Detail............................................................... 575 mph_hist Master Specification Test History..................................................... 576 mpp_det Service/Support Custom Program Parameter Detail........................ 576 mps_mstr Master Production Schedule ............................................................ 577 mp_mstr Master Specification......................................................................... 578 mrpc_ctrl Material Requirements Planning Control.......................................... 578 mrpp_det Material Requirements Planning Pegging Detail.............................. 578 mrp_det Material Requirements Planning Detail............................................ 579 MsgBrokerSetting Message Broker Setting................................................................... 580 msg_mstr Message Master............................................................................... 580 mu_mstr Monetary Union Master.................................................................... 580 ncc_ctrl Net Commerce Control..................................................................... 581 nfd_det Nota Fiscal Detail ............................................................................. 582 nfecs_det Electronic Nota Fiscal Configuration by Site .................................... 582 nfelg_hist Electronic Nota Fiscal Log................................................................ 583 nfews_mstr Electronic Nota Fiscal Web Service Master ..................................... 583 nf_mstr Nota Fiscal Master ........................................................................... 583 Nomenclature Nomenclature................................................................................... 584 nrh_hist Number Range History..................................................................... 585 nr_mstr Number Range Master..................................................................... 586 nsoc_ctrl Non-Sales Order Control.................................................................. 586 oa_det Action Message Detail...................................................................... 587 ObjectStatus Object Status.................................................................................... 587 ocm_mstr Service/Support On Call Master....................................................... 588 OIAdjust Open Item Adjustment...................................................................... 588 OIAdjustLn Open Item Adjustment Line.............................................................. 589 opc_ctrl Shop Floor Operation History Control .............................................. 592 opgl_det Shop Floor Operation General Ledger Detail................................... 592 opm_mstr Standard Operation Master.............................................................. 593 ops_ctrl Operations Plan Control................................................................... 594 op_hist Operation Transaction History.......................................................... 594 OrdAllocD Warehousing Order Allocation Detail ............................................... 596 OrdAllocH Warehousing Order Allocation History ............................................. 597 OrderD Warehousing Order Detail................................................................ 598 OrderM Warehousing Order Master.............................................................. 600 OrderSelD Warehousing Order Batch Selection Detail...................................... 601 OrderSelM Warehousing Order Batch Selection Master.................................... 603 pac_mstr Purchase Approval Code Master ..................................................... 604 pald_det Pallet Detail ...................................................................................... 604 pal_mstr Pallet Master .................................................................................... 605 PartSLGM Warehousing Item/Storage Location Group Master......................... 605 PartWhseM Warehousing Item/Warehouse Master............................................. 606
17. 17. Contents xvii PayFormatCode Payment Format Code ..................................................................... 607 PayFormatGroup Payment Format Group.................................................................... 608 PayFormatType Payment Format Type...................................................................... 608 PaymentCondition Credit Terms..................................................................................... 609 PaymentConditionStaged Staged Payment............................................................................... 610 PaymentGroup Payment Group ................................................................................ 610 PaySel Payment Selection ........................................................................... 611 PaySelHistory Payment Selection History ............................................................... 612 PaySelLine Payment Selection Line.................................................................... 612 PaySelLineStage Payment Selection Line Stage ......................................................... 614 PaySelPayCode Payment Selection Payment Code................................................... 614 PaySelPrepay Payment Selection Prepayment....................................................... 614 pcc_ctrl Product Change Control................................................................... 615 pcd_det Purchase Order Line Cost Element Detail ....................................... 615 pcld_det Product Change Control Group Detail.............................................. 616 pcl_mstr Product Change Control Group Master............................................ 616 pcsc_ctrl Control file to help setup parameters for Periodic Costing.............. 617 pctrop_det Periodic costing side table................................................................ 617 pct_mstr Product Change Control Type Master.............................................. 617 pc_mstr Price List Master............................................................................... 618 Period GL Period ......................................................................................... 619 PeriodMark Period Mark...................................................................................... 620 pfc_det Production Forecast Detail............................................................... 621 pfd_det Service/Support Item-Site Detail ...................................................... 621 pgc_ctrl Service/Support Paging Control....................................................... 622 pgh_hist Service/Support Paging History ....................................................... 623 pgm_det Program Detail ................................................................................. 623 pic_ctrl Pricing Control.................................................................................. 624 pid_det Price List Detail ................................................................................ 624 pigc_det Price List Group Customer Detail..................................................... 625 pigp_det Price List Group Item Detail ............................................................. 626 pig_mstr Price List Group Master.................................................................... 626 pih_hist Pricing History .................................................................................. 627 pi_mstr Price List Master............................................................................... 629 pjc_ctrl Project Realization Control............................................................... 630 pjd_det Project Realization Subproject Detail............................................... 631 pjsh_hist Project Realization Transaction History ........................................... 632 pjsx_det Project Structure Cross-Reference Detail ........................................ 633 pjs_mstr Project Realization Structure Master................................................ 634 pjt_mstr Project Realization Project Type Master .......................................... 635 pj_mstr Project Master .................................................................................. 636 pk_det Pick List Work Table......................................................................... 636 pld_det Product Line Detail........................................................................... 637 pliabs_ref Legal Document Cross-Reference................................................... 637 plid_det Purchase Ledger Invoice Detail ....................................................... 638 pli_mstr Purchase Ledger Invoice Master...................................................... 638 plsd_det Product Line Sales Detail................................................................. 639 plt