Adjustment

Adjustment Data Model

Contents

Adjustment - Main

The following data model illustrates the adjustment object.

Adjustment

Adjustment - FT

The following data model illustrates the FT that must be associated with an adjustment segment.

Adjustment FT

Adjustment Table Names

*Data Model Name*	*Table Name*	*Generated Keys*	*Referential Integrity Validation Batch Control*	*Key Assignment Batch Control*	*Insertion Batch Control*
Adjustment	CI_ADJ	Yes CI_ADJ_K	CIPVADJV	CIPVADJK Has dependencies	CIPVADJI
Adjustment A/P Request	CI_ADJ_APREQ	Yes CI_ADJ_APREQ_K	CIPVAPRV	CIPVAPRK Has dependencies	CIPVAPRI
Adjustment Calc Lines	CI_ADJ_CALC_LN	No. The key is adjustment id and a sequence number	CIPVACLV		CIPVACLI
Adjustment Calc Line Characteristics	CI_ADJ_CL_CHAR	No. The key is adjustment id, a sequence number and characteristic type	CIPVCLCV		CIPVCLCI
FT (financial transaction)	CI_FT	Yes CI_FT_K	CIPVFTFV	CIPVFTXK Has dependencies	CIPVFTFI See Optional FK Note below.
FT Characteristic	CI_FT_CHAR	No. The key is FT id, char type code and a sequence number	CIPVFTCV		CIPVFTCI
FT GL (FT general ledger)	CI_FT_GL	No. The key is FT id and a GL sequence number	CIPVFTGV		CIPVFTGI
FT Process	CI_FT_PROC	No. The key is FT id and a sequence number	CIPVFTPV		CIPVFTPI
Adjustment Characteristic	CI_ADJ_CHAR	No. The key is adjustment id, char type code and a sequence number	CIPVADCV		CIPVADCI

Adjustment Suggestions

Please populate the columns on the FT that's associated with the adjustment as follows:

CUR_AMT should be set equal to the adjustment amount
PAY_AMT should be set equal to the adjustment amount
CRE_DTTM should be set equal to the adjustment date / time
FREEZE_SW should be "Y"
FREEZE_DTTM should be set equal to the adjustment date / time
ARS_DT should be set equal to the adjustment date
CORRECTION_SW should be "N"
REDUNDANT_SW should be "N"
NEW_DEBIT_SW should be "N"
NOT_IN_ARS_SW should be set to "N"
SHOW_ON_BILL_SW should be set to "N" on all adjustments other than adjustments that have been generated since the last bill. For recent adjustments that you want to show on the next bill, this switch must be "Y"
ACCOUNTING_DT should be set to the current date
SCHED_DISTRIB_DT should be left blank
CURRENCY_CD should be the currency on the installation record
BAL_CTL_GRP_ID should be left blank
XFERRED_OUT_SW should be set to "Y"
PARENT_ID should be set to the adjustment's adjustment type
SIBLING_ID should be set to the adjustment ID
Do NOT create any GL details for the FT. If GL details are converted, ensure they are populated with the EXACT information the system would use to create them. This information is used to create the reversing GL entry when the adjustment is canceled.

Optional FK Note

FTs for adjustments have an optional foreign key BILL_ID to the Bill (CI_BILL) table. If your implementation is planning to convert financial transactions for adjustments, but does not plan to convert bills, the key generation program for Bill must still be run. Refer to The Big Picture of Key Assignment for more information.