FIF Dynamic Combinations

This column contains the set of books ID for the dynamic segment combination.

This column contains the department for the dynamic segment combination.

This column contains the class for the dynamic segment combination.

This column contains the subclass for the dynamic segment combination.

This column contains the location for the dynamic segment combination.

This column contains the reference number for the dynamic segment combination.

This column contains the transaction code for the dynamic segment combination.

This column contains the level at which the dynamic segment records are joined. Valid values are DEPT(department), CLS(class), SCLS(subclass), LOC(location), GLRF(GL reference number), DCS(department, class, subclass). If DEPT, this record will contain all department dynamic segment records including location and reference number dynamic segments. If CLS, this record will contain all class dynamic segment records including location and reference number dynamic segments. If SCLS, this record will contain all subclass dynamic segment records including location and reference number dynamic segments. If DCS, this record will contain department/class/subclass dynamic segment records including location and reference number dynamic segments. If LOC, this record will contain all location dynamic segment records including reference number dynamic segments. If GLRF, this record will only contain reference number dynamic segment records. Dynamic segments must match by tran code or with a -1 tran code.

This column indicates a new dynamic segment combination or an updated mapped value for an existing record. Valid values are I(insert), U(update), or null.

This column contains the mapped value for the department and transaction code.

This column contains the mapped value for the class and transaction code.

This column contains the mapped value for the subclass and transaction code.

This column contains the mapped value for the location and transaction code.

This column contains the mapped value for the reference number and transaction code.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 1, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 2, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 3, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 4, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 5, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 6, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 7, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 8, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 9, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 10, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 11, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 12, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 13, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 14, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 15, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 16, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 17, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 18, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 19, this field will contain the MAPPED_VALUE_DEPT.

This column contains the mapped value for the dynamic segment in FIF_DYNAMIC_SEGMENT table for the set of books ID. For example, if DEPT dynamic segment is setup for SEGMENT_NUMBER = 20, this field will contain the MAPPED_VALUE_DEPT.

This column holds the user who created the record.

This column holds the record creation date.

This column holds the user who last updated the record.

This column holds the date time when the record was last updated.