GP Tables

Sales

48 tables in this module

Sales Order Processing (SOP) tables manage the full sales lifecycle from quotes through invoices. Receivables Management (RM) tables track customer balances, payments, and aging. These modules work together to handle all revenue-side transactions.

Table Description
DO03100 DO Credit Card Setup
DO10100 DO Credit Card Services Activity
DO40100 DO Setup
IVC10100 Invoicing Transaction Work
IVC10101 Invoicing Transaction Amounts Work
IVC10102 Invoicing Serial and Lot Number Work
IVC10103 Invoicing Line Comments
IVC10200 Invoicing Payments Work
IVC10300 Invoicing Distributions
IVC10400 Invoicing Commissions
IVC10500 Invoicing Taxes
IVC30100 Invoicing Batch History
IVC30101 Invoicing Transaction History
IVC30102 Invoicing Transaction Amounts History
IVC40100 Invoicing Setup
IVC40101 Invoicing Document Setup
IVC50100 Invoicing Document Header Temp
PA00001 Customer Vendor Master
RM00101 RM Customer MSTR
RM00103 Customer Master Summary
RM00302 Salesperson Master Summary File
RM00305 Sales Territory Master Summary
RM10201 RM Cash Receipts Work File
RM10301 RM Sales Work File
RM20101 RM Open File
RM20201 RM Apply Open File
RM30101 RM History File
RM30202 RM Apply Reprint Journal File
RM40101 RM Module Setup File
RM40401 Document Type Setup File
RM50100 RM History Removal Tempoary File
RM50103 RM Email Statements Header Temporary File
RM50104 RM Email Statements Transactions Temporary File
SOP10100 Sales Transaction Work
SOP10101 Sales Commissions (Work & History)
SOP10102 Sales GL Distributions (Work & History)
SOP10103 Sales Payments (Work & History)
SOP10104 Sales Process Holds (Work & History)
SOP10105 Sales Taxes (Work & History)
SOP10106 Sales User Defined (Work & History)
SOP10107 Sales Tracking Numbers (Work & History)
SOP10200 Sales Transaction Line Detail (Work)
SOP10201 Sales Serial/Lot (Work & History)
SOP10202 Sales Line Comments (Work & History)
SOP30200 Sales Transaction History
SOP30300 Sales Transaction Line History
SOP60100 SOP-POP Link
SOP60300 Customer Item Numbers