GP tables

Start Studying!

Terms

undefined, object

copy deck

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 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

Start Studying!

Deck Info

Number of cards 160