MG_FLEX_FIELDS

(SQL Table)
Index Back

Agile Integration

4/29/03 Agile Enhancement - New record to maintain required fields mapping between PeopleSoft and Agile. These required fiels in PS current do not exist in Agile 8.0 or 8.5

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MG_PS_FIELD Character(1) VARCHAR2(1) NOT NULL 1/24/03 RML Added Cost Element and Cost Profile Group
1=Item Source Code
2=Item Unit of Measure
3=Operation Sequence
4=Cost Element
5=Cost Profile Group
2 MG_FLEXFLD_TYPE Character(1) VARCHAR2(1) NOT NULL 11/25/02 RML Agile Integration enhancement - Flex field type; Item or BOM; used on MFG Installation page
B=Bill of Material
I=Item

Default Value: I

3 MG_FIELD_NAME100 Character(100) VARCHAR2(100) NOT NULL 11/25/02 Agile Integration - Used on MG Installation page