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.