Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
165 Cards in this Set
- Front
- Back
|
Sales
IVC10100 |
Invoicing Transaction Work
|
|
|
Sales
IVC10101 |
Invoicing Transaction Amounts Work
|
|
|
Sales
IVC10102 |
Invoicing Serial and Lot Number Work
|
|
|
Sales
IVC10103 |
Invoicing Line Comments
|
|
|
Sales
IVC10200 |
Invoicing Payments Work
|
|
|
Sales
IVC10300 |
Invoicing Distributions
|
|
|
Sales
IVC10400 |
Invoicing Commissions
|
|
|
Sales
IVC10500 |
Invoicing Taxes
|
|
|
Sales
IVC30100 |
Invoicing Batch History
|
|
|
Sales
IVC30101 |
Invoicing Transaction History
|
|
|
Sales
IVC30102 |
Invoicing Transactions Amounts History
|
|
|
Sales
IVC40100 |
Invoicing Setup
|
|
|
Sales
IVC40101 |
Invoicing Document Setup
|
|
|
Sales
MC020102 |
Multicurrency Receivables Transactions
|
|
|
Sales
MC020104 |
Multicurrency RM Revaluation Activity
|
|
|
Sales
MC10101 |
Multicurrency RM Distribution Temp File
|
|
|
Sales
PA00001 |
Customer Vendor Master (Refund Checks)
|
|
|
Sales
PA00002 |
Customer Checks Setup
(Refund Checks) |
|
|
Sales
PA00010 |
Bank Account Master
|
|
|
Sales
PA50100 |
Customer Checks Work (Refund Checks Work)
|
|
|
Sales
MC10101 |
Multicurrency RM Distribution Temp File
|
|
|
Sales
PA00001 |
Customer Vendor Master (Refund Checks)
|
|
|
Sales
PA00002 |
Customer Checks Setup
(Refund Checks) |
|
|
Sales
PA00010 |
Bank Account Master
|
|
|
Sales
PA50100 |
Customer Checks Work (Refund Checks Work)
|
|
|
Sales
PA50102 |
Customer RM Applied Work
|
|
|
Sales
PA50103 |
Vendor PM Applied Work
|
|
|
Sales
PA50105 |
RMPMOpen
|
|
|
Sales
RM00101 |
RM Customer Master
|
|
|
Sales
RM00102 |
Customer Master Address File
|
|
|
Sales
RM00103 |
Customer Master Summary
|
|
|
Sales
RM00104 |
Customer Period Summary
|
|
|
Sales
RM00105 |
RM National Accounts Master
|
|
|
Sales
RM00106 |
RM Statements E-mail Addresses
|
|
|
Sales
RM00201 |
RM Class Master
|
|
|
Sales
RM00301 |
RM Salesperson Master
|
|
|
Sales
RM00302 |
Salesperson Master Summary file
|
|
|
Sales
RM00303 |
Sales Territory Master file
|
|
|
Sales
RM00305 |
Sales Territory Master Summary
|
|
|
Sales
RM00401 |
RM Key File
|
|
|
Sales
RM00500 |
Extended Pricing Price Sheet Links
|
|
|
Sales
RM00700 |
RM Report Options
|
|
|
Sales
RM10101 |
RM Distribution Work file
|
|
|
Sales
RM10201 |
RM Cash Receipts Work File
|
|
|
Sales
RM10301 |
RM Sales Work File
|
|
|
Sales
RM10501 |
RM Commission Work File
|
|
|
Sales
RM10504 |
RM Unpaid Removed Commissions
|
|
|
Sales
RM10601 |
RM Tax Work File
|
|
|
Sales
RM10901 |
RM Aging Reconcile Control
|
|
|
Sales
RM20101 |
RM Open File
|
|
|
Sales
RM20102 |
RM Realtime Posting File
|
|
|
Sales
RM20201 |
RM Apply Open File
|
|
|
Sales
RM20400 |
RM Scheduled Payment Header
|
|
|
Sales
RM20401 |
RM Scheduled Payment Line
|
|
|
Sales
RM30101 |
RM History File
|
|
|
Sales
RM30201 |
RM Apply History File
|
|
|
Dynamics.exe
|
GP engine
-used to run GP and Utilities |
|
|
DPS.EXE
|
Process Server Engine
|
|
|
DPM.EXE
|
installed on 1 computer if using services
|
|
|
CONTAIN.EXE
|
Store OLE objects that can be attached to GP notes
|
|
|
DEX.DIC
|
Dexterits dictionary...fields tables, windows and reports used by Dexterity
|
|
|
DYNAMICS.SET
|
launch file
contains paths to dictionaries |
|
|
REPORTS.DIC
|
Created when accessing Report Writer for the first time
|
|
|
FORMS.DIC
|
Created when accessing Modifier for first time
|
|
|
DYNUTILS.DIC
|
utilities dictionary
|
|
|
DYNUTILS.SET
|
launch file for utilities
|
|
|
DEX.INI
|
defaults file. setup and operating information about GP.
Stored first in GP folder Then in the Windows folder |
|
|
Auto Update Statistics
|
Checked
|
|
|
Auto Close
|
NOT checked
|
|
|
Auto Create Statistics
|
checked
|
|
|
Auto Shrink
|
NOT checked
|
|
|
Recursive triggers
|
NOT checked
|
|
|
ANSI NULL default
|
NOT checked
|
|
|
Torn Page Detection
|
checked
|
|
|
Use quoted identifiers
|
NOT checked
|
|
|
SIMPLE recovery model?
|
-DB to be recovered to most recent backup
-Specifying transaction log is truncated when the checkpoint checking process occurs in SQL |
|
|
BULK-logged?
|
Bulk operations are not logged.
Only transaction log backups not allowed. |
|
|
Full Recovery Model
|
allows point in time recovery.
If choosing full, then we must do regular backups of the transaction log in order to clean it out. |
|
|
Differential backup?
|
All changes since the last FULL db backup are backed up.
|
|
|
Transaction log backup?
|
All info in the log with a commited status are backed up
|
|
|
What needs to be backed up? 4 things
|
FORMS.DIC
REPORTS.DIC DYNAMICS.DIC Each company database |
|
|
When to back up? 4 times
|
1) Creating a db
2) Performing non-logged operation 3) SQL DB Maintenance Procedures 4) Before and after Check Links and Reconcile - Data Recovery Procedures |
|
|
RECOMPILE
|
re-optimizes stored procedures
|
|
|
UPDATE STATISTICS
|
used to update statistics on the distribution of key values in each index.
Improves decisions about which index to use in a query. |
|
|
DROP/CREATE TABLE
|
recreates table
|
|
|
DROP/CREATE AUTO PROCEDURE
|
recreate sprocs that become damaged
|
|
|
DBCC CHECKDB
|
checks all tables to ensure indexes and data pages are correctly linked.
|
|
|
DBCC CHECKDB with repair option
|
Puts db in single user mode
|
|
|
DBCC CHECKCATALOG
|
checks consistency in system tables
|
|
|
DBCC REINDEX
|
-rebuilds an index for a table
-good for pages that become full and then split |
|
|
Reorganize Data and Index Pages = ?
|
DBCC REINDEX
reduces page splitting, improves data modification performance |
|
|
RM30202
|
RM Apply Reprint Journal File
|
|
|
RM30301
|
Receivables GL Distribution History
|
|
|
RM30401
|
RM Scheduled Payment Header History History
|
|
|
RM30501
|
Commission History
|
|
|
RM30502
|
RM Batch History
|
|
|
RM30601
|
RM Tax History File
|
|
|
RM30701
|
RM Reprint Statements Header File
|
|
|
RM30702
|
RM Reprint Statements Transaction File
|
|
|
RM40101
|
RM Module Setup File
|
|
|
RM40102
|
RM Reprint Statments Identifier File
|
|
|
RM40201
|
RM Period Setup
|
|
|
RM40401
|
Document Type Setup File
|
|
|
RM40501
|
RM Statements Options File
|
|
|
RM40601
|
RM Statement Messages Setup File
|
|
|
RM50100
|
RM History Removal Temporary File
|
|
|
RM50101
|
Statements Emailed Header Temp
|
|
|
RM50102
|
Statements Emailed Recipients Temp
|
|
|
RM50103
|
RM Email Statements Header Temporary File
|
|
|
RM50104
|
RM Email Statements Transactions Temp File
|
|
|
RMV0100
|
RM Scheduled Payment Header Window
|
|
|
SOP00100
|
Sales Process Holds Master
|
|
|
SOP00200
|
Sales Prospect Master
|
|
|
SOP00300
|
Sales Customer Item Substitute
|
|
|
SOP10100
|
Sales Transaction Work
|
|
|
SOP10101
|
Sales Commission Work and History
|
|
|
SOP10102
|
Sales Distribution Work and History
|
|
|
SOP10103
|
Sales Payment Work and History
|
|
|
SOP10104
|
Sales Process Holds Work and History
|
|
|
SOP10105
|
Sales Taxes Work and History
|
|
|
SOP10106
|
Sales User-Definied Work History
|
|
|
SOP10107
|
Sales Tracking Numbers Work History
|
|
|
SOP10108
|
Extended Pricing Price Group Header
|
|
|
SOP10109
|
Extended Pricing Price Book Header
|
|
|
SOP10110
|
Extended Pricing Price Sheet Header
|
|
|
SOP10111
|
Sales Picking Instruction Master
|
|
|
SOP10112
|
Sales Workflow Work and History
|
|
|
SOP10200
|
Sales Transaction Work Amounts
|
|
|
SOP10201
|
Sales Serial/Lot Work and History
|
|
|
SOP10202
|
Sales Line Comment Work and History
|
|
|
SOP10203
|
Sales Order Bin Quantities Work and History
|
|
|
SOP10204
|
Extended Pricing Promotion Work
|
|
|
SOP10205
|
Extended Pricing Price Book Work
|
|
|
SOP10206
|
Sales Bulk Print Header
|
|
|
SOP10207
|
Sales Bulk Print Line
|
|
|
SOP30100
|
Sales Batch History
|
|
|
SOP30200
|
Sales Transaction History
|
|
|
SOP30201
|
Sales Deposit History
|
|
|
SOP30300
|
Sales Transaction Amounts History
|
|
|
SOP40100
|
Sales Setup
|
|
|
SOP40101
|
Sales Workflow Setup
|
|
|
SOP40200
|
Sales Type ID Setup
|
|
|
SOP40201
|
Sales Default Process Holds Setup
|
|
|
SOP40300
|
Sales Document Setup
|
|
|
SOP40400
|
Sales User Defined Table Setup
|
|
|
SOP40500
|
Sales Master Number Setup
|
|
|
SOP40600
|
Sales Non-IV Item Currency Setup
|
|
|
SOP40700
|
Extended Pricing Customer Price Support
|
|
|
SOP40701
|
Extended Pricing Price List Report
|
|
|
SOP40702
|
Extended Pricing Base Prices
|
|
|
SOP40703
|
Extended Pricing Quantity Breaks
|
|
|
SOP40704
|
Extended Pricing Quantity Breaks
|
|
|
SOP40705
|
Extended Pricing Generate Dates
|
|
|
SOP40706
|
Extended Pricing Price Book Prices
|
|
|
SOP40708
|
Extended Pricing Base Currencies
|
|
|
SOP40709
|
Extended Pricing Group Currencies
|
|
|
SOP50100
|
Sales Process Documents Temp
|
|
|
SOP50200
|
Sales Document Header Temp
|
|
|
SOP50300
|
Sales Document Line Temp
|
|
|
SOP50400
|
Extended Pricing Promotion Inquiry Temp
|
|
|
SOP50401
|
Extended Pricing Promotion Report Temp
|
|
|
SOP60100
|
SOP_POPLink
|
|
|
SOP60200
|
Sales Picking Instruction Cross Reference
|
|
|
SOP60300
|
Sales Customer Item Cross Reference
|
|
|
SOP70100
|
Sales Inquiry Restrictions
|
