Module List > Module COMPANY..SOP tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 SOP00100Sales Process Holds Master
 SOP00200Sales Prospect Master
 SOP00300Sales Customer Item Substitute

This table contains Customer item substitute information for Inventory Items.

Freq
Used
 Display Name
SOP10100Sales Transaction Work

This file stores all unpostede transaction information until it is posted. Records in this file relate to a specific record in the Batch_Headers file.
This table contains the identifying document information for all sales documents entered using the Sales Transaction Entry window (and also the Quotes, Orders, Invoices, and Returns windows). Transaction line item-related records are stored in the SOP_LINE_WORK table. Each record represents a document that has been entered using the Sales Transaction Entry window or created through the transfer process using the Sales Transfer Documents window.
SOP and MC

The following describes changes made as a result of SOP MC. The focus of this discussion is on a non-MC SOP transaction. In SBF, multiple currencies are not supported.
Currency ID-This should be blank for non-MC SOP transactions.
Currency Index-This should be the 'Functional Currency Index' of globals for non-MC SOP transactions.
Rate Type ID-This should be blank for non-MC SOP transactions.
Exchange Table ID-This should be blank for non-MC SOP transactions.
Exchange Rate-This should be blank for non-MC SOP transactions.
Exchange Date-This should be blank for non-MC SOP transactions.
Time-This should be blank for non-MC SOP transactions.
Rate Calculation Method-This should be blank for non-MC SOP transactions.

"Originating" values-The originating currency values (typically in the format "Originating ") are the primary currency values used for a SOP transaction. The corresponding functional currency values (typically in the format "") are calculated from the corresponding originating currency value. For a non-MC SOP transaction, the originating and functional currency values will be the same. Leaving either the originating currency value or the functional currency value blank for a non-MC SOP transaction is not allowed. If the value is not being used, both the originating and functional currency values should be blank.

Optional:
Tax Date - Required for VAT.
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro.
Display Name Sales Transaction Work

 SOP10101Sales Commissions Work and History
 SOP10102Sales Distribution Work and History
 SOP10103Sales Payment Work and History
This table contains payment information for unposted and historical transactions.  Each unposted record in the table is associated with one record in the SOP_HDR_WORK table.


Comments:
The TRX Source is an internally assigned audit trail code that will be saved with the record when a transaction is posted.  The TRX Source field is used to separate the posted and unposted records.  If the TRX Source field has an entry, the record has been posted.


We strongly recommend that you avoid importing historical data into this table.


SOP and MC:
The following describes changes made as a result of SOP MC. The focus of this discussion is on a non-MC SOP transaction.


Currency ID-This should be blank for non-MC SOP transactions. Currency Index-This should be the 'Functional Currency Index' of globals for non-MC SOP transactions. "Originating" values-The originating currency values (typically in the format "Originating ") are the primary currency values used for a SOP transaction. The corresponding functional currency values (typically in the format "") are calculated from the corresponding originating currency value. For a non-MC SOP transaction, the originating and functional currency values will be the same. Leaving either the originating currency value or the functional currency value blank for a non-MC SOP transaction is not allowed. If the value is not being used, both the originating and functional currency values should be blank.

The following fields must be imported regardless of if Multi-Currency is registered.


Orig Amount Paid: If the transaction is not a multi-currency transaction, import same amount as the Amount Paid field.  If the transaction is a multi-currency transaction, import the originating currency credit amount.


Orig Amount Remaining: Contains the originating amount remaining of the payment that has not yet been applied to an invoice.


 SOP10104Sales Process Holds Work and History
 SOP10105Sales Taxes Work and History
 SOP10106Sales User-Defined Work History
 SOP10107Sales Tracking Numbers Work History
 SOP10108Extended Pricing Price Group Header
 SOP10109Extended Pricing Price Book Header
 SOP10110Extended Pricing Price Sheet Header
 SOP10111Sales Picking Instruction Master
 SOP10112Sales Workflow Work and History
SOP10200Sales Transaction Amounts Work

Table Description:
This table contains transaction information for each line item on an unposted transaction. Each record in this table represents one line item and is associated with one record in the SOP_HDR_WORK table. If the line item is serial numbered or lot numbered, records for the serial or lot numbers are added to the SOP_Serial_Lot_WORK_HIST table.

Comments:
The TRX Source is an internally assigned audit trail code that will be saved with the record when a transaction is posted.

SOP and MC
The following describes changes made as a result of SOP MC. The focus of this discussion is on a non-MC SOP transaction.
Currency Index-This should be the 'Functional Currency Index' of globals for non-MC SOP transactions.

"Originating" values-The originating currency values (typically in the format "Originating ") are the primary currency values used for a SOP transaction. The corresponding functional currency values (typically in the format "") are calculated from the corresponding originating currency value. For a non-MC SOP transaction, the originating and functional currency values will be the same. Leaving either the originating currency value or the functional currency value blank for a non-MC SOP transaction is not allowed. If the value is not being used, both the originating and functional currency values should be blank.

 SOP10201Sales Serial/Lot Work and History
 SOP10202Sales Line Comment Work and History
 SOP10203Sales Order Bin Quantities Work and History
 SOP10204Extended Pricing Promotion Work
 SOP10205Extended Pricing Price Book Work
 SOP10206Sales Bulk Print Header
 SOP10207Sales Bulk Print Line
 VAT10100RM Class Intrastat MSTR
 VAT10101RM Customer Intrastat MSTR
Work Tables
Freq
Used
 Display Name
 SOP30100Sales Batch History
SOP30200Sales Transaction History
 SOP30201Sales Deposit History
SOP30300Sales Transaction Amounts History
Freq
Used
 Display Name
 SOP40100Sales Setup
 SOP40101Sales Workflow Setup
 SOP40200Sales Type ID Setup
 SOP40201Sales Default Process Holds Setup
 SOP40300Sales Document Setup
 SOP40400Sales User Defined Table Setup
This table holds static values for the SOP USRTAB01 and USRTAB02 fields. The index points to which field (1 or 2)
 SOP40500Sales Master Number Setup
 SOP40600Sales Non-IV Item Currency Setup
 SOP40700Extended Pricing Customer Price Report
 SOP40701Extended Pricing Price List Report
 SOP40702Extended Pricing Base Prices
 SOP40703Extended Pricing Quantity Breaks
 SOP40704Extended Pricing Quantity Breaks For Price S
 SOP40705Extended Pricing Generate Dates
 SOP40706Extended Pricing Price Book Prices
 SOP40708Extended Pricing Base Currencies
 SOP40709Extended Pricing Group Currencies
 SOP50100Sales Process Documents Temp
 SOP50200Sales Document Header Temp
 SOP50300Sales Document Line Temp
 SOP50400Extended Pricing Promotion Inquiry Temp
 SOP50401Extended Pricing Promotion Report Temp
 SOP50500Sales Holds Processing
 SOP50600Sales ID Setup Temp
 SOP50700Sales Error Log Temp
 SOP60100SOP_POPLink
 SOP60200Sales Picking Instruction Cross Reference
 SOP60300Sales Customer Item Cross Reference

This table contains Customer item information for Inventory Items.

 SOP70100Sales Inquiry Restrictions
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3