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. The following describes each column on this table.
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. |