Column Name | Length | Req'd | Data Type | Comments |
ADJ_STG_UP_ID | 12 | Y | N | This is the unique identifier of the adjustment upload staging record. This key is a sequential number so you can use a database function to assign the value when populating the table. |
ADJ_STG_CTL_ID | 12 | Y | N | The ID of the adjustment staging control that is linked to this adjustment upload staging record. |
ADJ_TYPE_CD | 8 | Y | A/N | This must correspond to the prime key of one of your adjustment types. Refer to Setting up Adjustment Types for more information. |
ADJ_STG_UP_STATUS_FLG | 4 | Y | A/N | This must be set to P for Pending. |
CREATE_DT | 10 | Y | Date | The date when the adjustment occurred. |
ADJ_AMT | 13.2 | Y | N | The amount of the adjustment. |
ADJ_SUSPENSE_FLG | 4 | Y | N | This must be set to NSUS for Not In Suspense. |
SA_ID | 10 | N | A/N | This must correspond to a valid service agreement in the system. If you leave this blank and opt to let the system find the SA during adjustment upload preprocessing, a Determine SA algorithm must be plugged in on the associated adjustment type. This plug-in is meant to derive the SA ID based on supplied miscellaneous information - e.g. information supplied via adjustment characteristic upload staging. |
ADJ_ID | 10 | N | A/N | Leave this blank. The adjustment upload process populates this. |
SUSPENSE_ADJ_ID | 10 | N | A/N | Leave this blank. The adjustment upload process populates this. |
MESSAGE_CATEGORY | 5 | N | N | Leave this blank. The adjustment upload background processes populate this when an error occurs during upload. |
MESSAGE_NBR | 5 | N | N | Leave this blank. The adjustment upload background processes populate this when an error occurs during upload. |