|
| | SOP00100 | Sales Process Holds Master |
|
|
| | SOP00200 | Sales Prospect Master |
|
|
| | SOP00300 | Sales Customer Item Substitute |
|
This table contains Customer item substitute information for Inventory Items.
|
|
|
|
 | SOP10100 | Sales 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
|
| | SOP10101 | Sales Commissions Work and History |
|
|
| | SOP10102 | Sales Distribution Work and History |
|
|
| | SOP10103 | Sales 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.
|
| | SOP10104 | Sales Process Holds Work and History |
|
|
| | SOP10105 | Sales Taxes Work and History |
|
|
| | SOP10106 | Sales User-Defined 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 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.
|
| | 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 |
|
|
| | VAT10100 | RM Class Intrastat MSTR |
|
|
| | VAT10101 | RM Customer Intrastat MSTR |
|
|
|
|
| | 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 |
|
This table holds static values for the SOP USRTAB01 and USRTAB02 fields. The index points to which field (1 or 2)
|
| | SOP40500 | Sales Master Number Setup |
|
|
| | SOP40600 | Sales Non-IV Item Currency Setup |
|
|
| | SOP40700 | Extended Pricing Customer Price Report |
|
|
| | SOP40701 | Extended Pricing Price List Report |
|
|
| | SOP40702 | Extended Pricing Base Prices |
|
|
| | SOP40703 | Extended Pricing Quantity Breaks |
|
|
| | SOP40704 | Extended Pricing Quantity Breaks For Price S |
|
|
| | 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 |
|
|
| | SOP50500 | Sales Holds Processing |
|
|
| | SOP50600 | Sales ID Setup Temp |
|
|
| | SOP50700 | Sales Error Log Temp |
|
|
| | SOP60100 | SOP_POPLink |
|
|
| | SOP60200 | Sales Picking Instruction Cross Reference |
|
|
| | SOP60300 | Sales Customer Item Cross Reference |
|
This table contains Customer item information for Inventory Items.
|
| | SOP70100 | Sales Inquiry Restrictions |
|
|
|