Adjustment Staging Control
You must create an adjustment staging control record for each batch of adjustments to be uploaded into the system. The name of this table is CI_ADJ_STG_CTL.
| Column Name | Length | Req'd | Data Type | Comments |
|---|---|---|---|---|
| ADJ_STG_CTL_ID | 12 | Y | N | This is the unique identifier of the adjustment staging control record. This key is a sequential number so you can use a database function to assign the value when populating the table. |
| CRE_DTTM | 15 | Y | DateTime | This is the date / time on which the adjustment staging control record was created. This must be populated with the current date / time. |
| ADJ_STG_CTL_STATUS_FLG | 4 | Y | A/N | This must be set to P for Pending. |
| ADJ_STG_UP_REC_CNT | 10 | Y | N | This is the total number of adjustment upload staging records that are linked to this adjustment staging control. |
| TOT_ADJ_AMT | 13.2 | Y | N | This column must equal the sum of adjustment amounts on the adjustment upload staging records that are linked to this adjustment staging control. |
| CURRENCY_CD | 3 | Y | A/N | This must be a valid currency code in the system. Refer to Defining Currency Codes for more information. |
| MESSAGE_CATEGORY | 5 | N | N | Leave this blank. The adjustment upload preprocessor populates this when an error occurs during upload. |
| MESSAGE_NBR | 5 | N | N | Leave this blank. The adjustment upload preprocessor populates this when an error occurs during upload. |