A collection of logically related tables and records.
Characteristics of the database schema, including field names, table names, validation expressions, labels, initial values, and others.
A collection of programs that enables you to store, modify, and extract information from a database.
Can refer to either the Progress software task that supports multi-user access to a database or the machine on which the database is located.
A set of databases that forms a logical group. QDT uses the concept of database sets to generate server and client startup and shutdown scripts and icons. The standard EAM database set consists of a main database and additional support databases.
A file that defines the structure of a Progress database. A database structure file contains the definition of each storage area and the extents within those storage areas that make up the database. A database structure file has an .st extension.
A .df file containing the database table, field, and index definitions that make up the schema of a specific database.
A language used to describe changes to the schema to the Progress DBMS. Progress provides tools for reading and writing these command files. All schema changes are in this form.
Conversion of data into a form that cannot be easily intercepted by unauthorized people.
A collection of related data records organized in a specific manner in a computer system.
A business UI component that displays the fields the user edits or views. The fields exist in the application’s primary table; that is, the table with the fields the application requires to perform its business function.
The smallest element of data in a database.
A collection of related data items.
The records comprising each electronic business document implemented in EDI eCommerce in a standards neutral format (SNF). These record definitions are used for both the exchange files and the document repository.
In GL Report Writer, either an analysis code or a basic GL item (account, sub-account, and so on) used to extract data from GL tables. Used in data rows, actual or budget columns, and in report records. A set of data retrieval codes, including one of each GL type, constitutes a query specification.
A data placeholder associated with a process that persists through the entire process and defines the information flow of the business process in Business Process Management (BPM).
The synchronization of static data such as information on suppliers, items, customers, and bills of material among distributed, multi-site, multi-domain company implementations.
A unique nine-digit sequence recognized as the universal standard for identifying and tracking businesses worldwide. It is used in EDI transactions to recognize the issuer or receiver of an electronic data interchange.
A displayed value in an NRM numbering sequence that depends on the transaction effective date or the fiscal period corresponding to the effective date. The effective date is supplied by the program using NRM. The format is a compound string that allows for optional display of date components (year, month, week, day), including delimiters between components; for example, 06:15:97. Each sequence can have one date-driven segment, or none, but not more than one.
Also known as journals. Method of grouping GL transactions for satisfying legal reporting requirements or for organizing GL reporting in a manner consistent with common business practices. Multiple daybooks can exist at any time. Transactions can be grouped in daybooks by transaction type and transaction- document type. A daybook can be composed of multiple journal entries.
Groups of daybooks used in transaction processing. Used by the system to determine the daybook to apply to the invoice at invoice print.
The amount of product calculated to meet customer demand between replenishments.
The normal length of time quoted prices are good for. After this time, a quote expires, and renegotiated prices are required.
A database supplied by IBM. The database is available for all platforms and operating systems including UNIX, Linux, Win NT/2000, and OS/400.
In TrM, the sum of the financial aspects of a promotion. Each deal is identified by a deal code. Deals can consist of anywhere from one to four deal types. Each deal type has two parts: the deal category and the pricing method. Deal categories cannot be repeated in a deal, but pricing methods can be repeated as often as necessary. For example, OI$CU$ (off invoice dollar, coupon dollar) is a valid deal while OI$OIN (off invoice dollar, off invoice net) is not.
The class of promotion discount, for example, off invoice, coupon, or free goods. Pairings of deal categories and pricing methods form deal types, which in turn are the building blocks for deal codes.
The code identifier for a deal, consisting of up to four deal types. Deals are specified on promotions by deal code.
Pairings of deal categories and pricing methods; for example, off invoice-dollar off, off invoice-percent off, or coupon-dollar off. A promotion deal, identified by a deal code, is comprised of a combination of up to four deal types.
A record of indebtedness. Debits are entered on the left-hand side of an account, and constitute an addition to an expense or asset account or a deduction from a revenue, net worth, or liability account.
Separate views that are available for users to see debit and credit.
A company address that is responsible for reporting Intrastat transactions.
An accelerated depreciation method that provides higher depreciation charges in the earlier years of asset life and lower depreciation charges in the later years. The annual depreciation is calculated by using a constant depreciation percentage rate and multiplying it by the remaining net book value each year of the asset’s service life. This method does not depreciate an asset to zero.
A declining-balance method that switches to the straight-line method when the depreciation calculated by straight-line is greater than the depreciation calculated by the declining-balance method. This method fully depreciates the asset.
Picking area locations that always store the same item. Also called home locations.
Information used or action taken by the system if a user does not specify different information.
The domain a user typically works in. Each user is assigned a default domain that displays during login.
The data that initially populates the menu, messages, printers, language code, and other default data files.
A promotion deal category (DC), also known as billback, chargeback, or post-billed. The discount is claimed from the manufacturer after the event. If there are only wholesale or both wholesale and retail components on the promotion, the deferred claim discount is taken off the wholesale component.
In deferred accounting, collected revenue that is held in a deferred account and posted periodically. Deferred revenue is a billing option for service contracts that are billed at the beginning of the service duration.
A user or group selected to perform tasks in place of the initial user assigned to the tasks in Business Process Management (BPM).
Fields used to identify deleted records in the audit database. Initially, the primary index fields for each database table are defined as delete event keys. Users can add additional keys as needed.
A number used by international customers to group several line items together for shipping purposes.
The required and agreed time or rate of delivery of goods or services purchased for a future period.
A need for a product or a component. Can come from a customer order, forecast, and so on.
Seasonal pattern of demand such as summer, fall, and Christmas.
In kanban, the percent of total item demand required by each supermarket. This percentage is relevant when a source (process, supplier, or supermarket) supplies a kanban item to multiple supermarkets, and a kanban loop has been defined between each supermarket and the process.
The triggering of material movement to a work center only when that work center is ready to begin the next job.
A denomination of a currency is a way of expressing that currency, while retaining its link with the originating currency. For example, during the transition to the euro, the French franc was considered a denomination of the euro.
A grouping of work centers for reporting, planning, and accounting. Every work center must belong to exactly one department. CRP calculates capacity and load by department. Labor, burden, and cost of production are tracked in the general ledger by department.
(1) Calculated demand, not forecast, for component items and raw materials that are directly related to production of higher-level assemblies or end products. (2) In operations planning, refers to end-item demands exploded from a family plan. For example, a family consists of end items A (25% of family forecast) and B (75%). If the family forecast is 100 cases, the dependent demand is 25 cases of A and 75 of B.
Tangible item of value used by a business to produce income that uses depreciation to allocate its cost to periods in its service life.
Value used for calculating depreciation as the depreciation base. The depreciable basis is the fixed-asset acquisition cost minus any salvage value.
The allocation of a fixed asset’s cost to periods in its service life. The system supports the following depreciation methods:
Sum of the Years’ Digits
Book used for tracking a fixed asset’s depreciation. It can be the posting book that posts to the GL.
A method for averaging depreciation in the first and last year of a fixed asset’s life. It is required because assets are not always acquired on the first day of the year or disposed of on the last day of the year. The system supports the following conventions:
Modified Half Year Version 1
Modified Half Year Version 2
An exchange rate that is derived from one or two other exchange rates.
An exchange rate derived from the established rates of two different currencies and a common third currency, such as a union currency.
An activity that lets you customize the UI by providing an interface to remove or insert UI components in the current view. Design mode can be used to control access to functionality and is typically controlled by the system administrator.
An interface that lets users access QAD Enterprise Applications using a Web browser. The Desktop is designed for use over a company intranet or wide-area network.
A list of application IDs registered with Q/LinQ that can be used for publishing, sending, and deleting or archiving documents. Destination lists create only one copy of a document for management and storage, minimizing disk space and performance requirements.
The act of reserving exact items of inventory at a specific location by specifying lot and/or serial numbers, expiration dates, sites and/or locations.
Any piece of hardware available to the computer, such as a disk or a printer.
A compilation of records pertaining to the production of a finished device. These records are typically retained for seven years and possibly reviewed in audits by the FDA.
A device master record is a compilation of records pertaining to the specifications and procedures of a finished device. These records are typically retained for seven years and possibly reviewed in audits by the FDA.
An easy way to compare a time-series variable over time. It is obtained by subtracting the current value of a variable by a past value.
A customer type. The direct customer buys goods directly from the manufacturer and sells them to the consumer.
A mechanism whereby raw business object event data is passed to QXO and directly published by the message publisher.
One of two possible delivery methods using Enterprise Material Transfer (EMT). The supplier delivers goods directly to the end customer, bypassing the ordering entity. The other is Transshipment.
An exchange rate explicitly defined between two currencies.
Labor particularly applied to a product being manufactured or utilized in the performance of a service.
The material used in the manufacturing process to make the end product from a purchasing point.
The capability for a buyer to enter a transaction directly into the seller's system through dialup or Internet connection.
Cash, checks, and wire transfers sent by a customer.
A method of delivering product from a distributor directly to the retail store, bypassing a retailer’s warehouse. The vendor manages the product from order to shelf. Major DSD categories include greeting cards, beverages, baked goods, snacks, pharmaceuticals, and so on.
Decomposition, separation, or processing of an item into parts, pieces, or subunits that consist of co-products and by-products. An example is the processing of meat and poultry.
Physical issuance and reporting of the movement of raw material, components, or other items from a storage room or warehouse.
A practice in which tax is based on sales or purchase amount minus credit terms discounts. Discounts at invoice are calculated at order entry.
A practice in which tax is based on sales or purchase amount minus credit terms discounts taken. Discounts at payment are calculated when payments are received or generated.
A document that can be discounted to another party, often the bank. Because a draft is an unconditional payment order, it is regularly used in this context. The financial risk remains with the initial beneficiary of the draft.
The order of the discount amount allocation when multiple price lists are combined.
A separate, distinct item.
An order quantity that represents an integer number of periods of demand. See also Lot for Lot (LFL)
The individual who assigns calls to engineers. If paging is used, can notify an engineer of an incoming call.
(1) A listing of all manufacturing orders by priority. Contains information on priority, location, quantity, and capacity requirements of an order by operation. Typically generated daily and sorted by work center. (2) In kanban environments, a list used to move empty containers back to a supply source.
Date of permanent removal of a depreciable asset from income-producing activity. Often referred to as the Retirement Date.
Reason for disposal of an asset and required input at time of disposal. Reasons include sold, stolen, destroyed, donated, and impaired.
Items that one site supplies to another site.
The balancing of supply and demand for items transferred between sites by calculating item requirements, creating planned orders, and managing shipment schedules and transportation.
The extension of distribution requirements planning into the planning of the key resources contained in a distribution system: warehouse space, work force, money, trucks, freight cars.
A business that does not manufacture its own products but purchases and resells these products. Such a business usually maintains a finished goods inventory. For Collaborative Planning, Forecasting, and Replenishment (CPFR), the term distributor is intended to include retailers.
In TrM, the first structure in the business structure hierarchy, followed by regions, areas, and zones. Divisions can have multiple and overlapping regions; for example, a national region probably overlaps north and south regions.
A server used by Internet access providers to map the domain names in Internet requests or forward them to other servers in the Internet.
An adjunct to customer ship-to sites. Multiple docks are possible per ship-to. The dock is assigned in the customer schedule setup process.
The specific printable data and form layout of a document associated with a business transaction, such as a shipment. It can be dictated by locale, reason for transaction, legal requirements, or common business practice.
Engineering departments must have strict control over all documents related to product design to protect company confidentiality and to ensure that all documentation is current and up-to-date. Only authorized personnel can have access to view or change documents.
A programming interface specification being developed by the W3C that lets a programmer create and modify HTML pages and XML documents as program objects, rather than data structures.
A set of tables containing all electronic business documents exchanged with trading partners using EDI eCommerce. This intermediate repository holds trading partner documents and allows them to be formatted into a state acceptable for gateway processing during import. It also allows for the consolidation of all required trading partner document data during the export process.
A category identifying the type of business transaction that a printed document describes. Valid document types include shippers, invoices, credit notices, and material receivers.
A specification that accompanies an XML document and identifies the specific functions of the XML markup.
A template for businesses that use the same base currency, chart of accounts, and GL calendar. You can have multiple domains per database and can change to another domain from within the application, provided you are an authorized user for that domain.
The way that Internet domain names are located and translated into Internet Protocol addresses. A domain name is a meaningful and easy-to-remember handle for an Internet address.
Any time when a resource scheduled for operation is not producing.
A negotiable security signed and dated by its issuer (the drawer). Similarly to a promissory note, it contains an unconditional order or instruction for the drawee to pay a fixed sum of money on the agreed due date. The debtor accepts the draft by signing it.
A type of browse that is available from a menu or associated with other browse fields. You can filter, graph, and print from drill-down browses. Compare with Look-Up Browse.
A functionality that lets warehouse staff drop off boxes at consolidation areas or shipping lanes before they complete picking for an order.
A distribution arrangement where the seller serves as a selling agent by collecting orders without maintaining inventories. The manufacturer then ships orders directly to customers.
A function that allows various financial documents, such as sales orders and invoices, to be expressed in two currencies. The second currency is for informational purposes only.
(1) On work orders: The date a product is available for issue to a shop or shipment to a customer. (2) On purchase orders: The date a product is due to arrive from a vendor. (3) On sales orders: The date an order is due to ship.
A provider of business-to-business credit and business-related information for both publicly and privately held companies.
A nine-digit number used as an identifier in Electronic Data Interchange (EDI) and global electronic commerce transactions. The numbers are assigned and maintained by Dun & Bradstreet. Suppliers doing business with your organization using EDI can submit their D&B number as part of the registration and transaction processes. This number eliminates errors in electronic transactions and serves as a consistent trading partner identifier in business transactions. It is a recognized standard by global industry and trade associations.
Packing material used to protect a shippable assembly unit from damage during transport. Dunnage count and weight are calculated during shipment and package processing.
A letter sent to a customer showing all open accounts receivable transactions that meet selection criteria. Severity of language in each letter sent typically increases with the length of time an AR item is unpaid.
Code used to determine the appropriate dunning letter to issue a customer. Tracks the number of letters that have been sent to a customer and the number of times each AR item has been listed in the letters.
A statistic used to test for auto-correlation within the errors. Auto-correlation occurs when there is dependence between the successive error values, which is also called a serial correlation. Durbin Watson is the most widely used statistic to determine random errors.
Product Information Management’s method for automating the cleansing, rationalization, importation, and publishing of product content.
The process in which peg quantities are unpegged from unconfirmed shippers and pegged to ship lines on newly created shippers for the same order line number.