You must create an adjustment characteristic upload staging record for each characteristic that you would like to link to the adjustment upload staging and copied to the resulting adjustment. The name of this table is CI_ADJ_STG_UP_CHAR. The following describes each column on this table.
Column Name |
Length |
Req'd |
Data Type |
Comments |
ADJ_STG_UP_ID |
12 |
Y |
N |
This must correspond with the prime key of the related CI_ADJ_STG_UP record. |
CHAR_TYPE_CD |
8 |
Y |
A/N |
This must correspond with a characteristic type that is defined as valid for Adjustment. And must be defined as valid for the adjustment type. Refer to Adjustment Type Controls Adjustment Characteristics for more information. |
SEQ_NUM |
3 |
Y |
N |
This should be set to 10 unless you have multiple values for a given adjustment upload staging and characteristic type. |
CHAR_VAL |
16 |
N |
A/N |
Populate this field if your characteristic type is predefined. |
ADHOC_CHAR_VAL |
254 |
N |
A/N |
Populate this field if your characteristic type is ad-hoc or file location. |
CHAR_VAL_FK1 - CHAR_VAL_FK5 |
50 each |
N |
A/N |
Populate these fields if your characteristic type is foreign key reference. Up to five columns of 50 bytes each are provided to accommodate compound keys. |
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.