Deposit Control Staging
You must create a deposit control staging record for each batch of payments to be uploaded into the system. The name of this table is CI_DEP_CTL_ST . The following table describes each column on this table.
Column Name | Length | Req'd | Data Type | Comments |
---|---|---|---|---|
EXT_SOURCE_ID | 30 | Y | A/N | This must correspond with an external source ID on one of the defined tender sources. Refer to Setting Up Tender Sources for more information. |
EXT_TRANSMIT_ID | 30 | Y | A/N | This is the unique identifier of the transmission from the external source. This must be a unique value for each transmission from the source. |
DEP_CTL_STG_ST_FLG | 2 | Y | A/N | This must be set to 20 (20 is the lookup value that corresponds with the Pending state) |
DEP_CTL_ID | 10 | N | N | Leave this column blank. It will be assigned by the system when it creates a deposit control record. |
TRANSMIT_DTTM | 15 | Y | DateTime | Date and time that the file was transmitted. |
CURRENCY_CD | 3 | Y | A/N | This must be a valid currency code (this would be USD for United States dollars). |
TOT_TNDR_CTL_AMT | 13.2 | Y | N | This column must equal the sum of the payment amounts on the tender control staging records associated with this deposit control staging. |
TOT_TNDR_CTL_CNT | 10 | Y | N | This column must equal the number of tender control staging records associated with this deposit control staging. |
LAST_UPDATE_INST | 10 | N | N | This field is populated during the upload. It is the process scheduler instance ID of the process performing the upload. |
You must create one or more Tender Control Staging for this deposit control staging record.