Information Systems:UDF - User Data Files

Overview

These are files that make it possible to add any kind of field without changing a file layout.

ITUSDAP	ITM -- Item Level User Data Items
CVUSDAP	CVU -- Customer/Vendor User Data Items
SOHDDAP	ORU -- ASW Order Header User Data Items         
SOLIDAP	ORU -- ASW Order and Line User Data Items

These files contain a link to the ASW file (item number, partner number, sales order number, line number), element name (code for the data field), then four fields, one of which will hold the data (short alpha, long alpha, number, or date).

The data element names and attributes are in file UDELMAP (User Data -- Detailed Data Elements Master).

Adding new user-defined fields

It is a major task to add a field to an existing data file. You have to change the source, compile the new file, copy the old file into the new format, and compile every single program that uses it. That last option can be virtually impossible when it comes to a file that is used a lot; like an ASW file. The only feasible option is to build an extension file. That works if you are adding a bunch of related fields, but what if you are only adding one? We have ‘user defined file’ for partners, items, and sales orders. We assign a description and data type for the field we want, and add it.

To do this, go to -

Unity / Start uniPharm Extensions / VA Company / System Administration / Extension Data Control / Maintain User Data Elements

 5/02/14  09:45:51    uniPHARM --Volume test               UDRIQ050/LISTCTL    
                        USER DATA -- List of Files         VOLUME        60    
Display Order                                Field      Test Values            
FILE  By file name                                                             
                                         AND                                   
Limit to                                 AND                                   
File Name    Added by                                                          
                                                                                
MA=Main Info   PU=Purge   EL=Element                                           
CP=Copy                   FO=Forms                                             
   File Name  Description                    ADDED BY   ADD DATE   ADD TIME    
__ CNCVDAP    Customer/Contact User Data     ANDYK      OCT 21 03  10:45 AM    
__ CNUSDAP    Contact Nam Level User Data    ANDYK      SEP 18 03  12:54 PM    
__ CVUSDAP    Customer/Vendor Level U Data   ANDYK      SEP 18 03  12:30 PM    
EL ITUSDAP    Item Level User Data           ANDYK      SEP 27 03   7:58 AM    
__ ITWHDAP    Item/Warehouse Level User Data PATP       MAY 14 08   2:28 PM    
__ SOHDDAP    Sales Order Header extensions  HKOETHLER  MAR 01 04   3:22 PM    
__ SOLIDAP    ASW Sales Order Line Extension ANDYK      MAR 01 04  11:33 AM    
                                                                               
                                                                 F21=Scrn Reset
 F3=Exit   F5=Refresh      F6=Add     F12=Previous               F24=Scrn Save 

This shows the user defined files we have. Key “EL” beside ITUSDAP to see the fields we have defined for items.

 5/02/14  09:48:36    uniPHARM --Volume test               UDRIQ070/LISTCTL    
                        USER DATA -- List of Elements      VOLUME        60    
Display Order                                Field      Test Values            
FILE  By file, then element nam                                                
                                         AND                                   
Limit to                                 AND                                   
File Name   Added by    Element Name Func. Athor.  Alph Date Numb Long Alpha   
ITUSDAP                                                                        
                                                                               
MA=Main Info   PU=Purge  FA=Authority   TB=Table Values                        
CP=Copy                  FO=Forms                                              
   Element    Element Description            TABLE NAME FA NAME    USE ALPHA   
__ BONUS PACK Bonus Pack                     ITEM BONUS            Y           
__ COLOUR     Colour Of Item                 ITEM COLOU            Y           
__ COST SOURC Cost Source                                          Y           
__ ECU CA SIZ ECU Case Size                                        N           
__ ECU CASE   ECU Case Flag                  YESNO                 Y           
__ EDL        EDL flag                       YESNO                 Y           
__ EDLFLAG    EDL Flag                                             Y           
__ FLAVOUR    Item Flavour                   ITEM FLAV             Y           
__ NARCOTIC   Narcotics Flag                 NARCOTIC              Y         + 
                                                                 F21=Scrn Reset
 F3=Exit   F5=Refresh      F6=Add     F12=Previous               F24=Scrn Save 

Press F6 to add a new field.

 1/10/08  15:58:34    uniPHARM -- PRODUCTION               UDRIU080/UPDATE 
UPDATE                User Data -- Enter/update Element    PRODUCTION    60
                                                                           
File Name   File Description                                               
ITUSDAP     Item Level User Data                                           
                                                                           
Element     Element Description              *DEFAULT Seq.                 
NPN         Natural Product Number                                         
                                                                           
Uses Table Validation   Uses Functional Authority                          
N                       N                                                  
                                                                           
Use Alpha  Use Date  Use Number Use Long Alpha                             
    Y          N         N          N                                      

The ‘element name’ is written to file ITUSDAP to identify the data in the record. By using a table, the user selects an option from that table instead of keying something in. (See the UWD Tables for information). There are four fields on the record; we select which one this data will use. ‘Alpha’ is a ten character field, ‘Date’ is century / year / month / day, ‘Number’ is 15 digits with 4 decimal places, and ‘Long Alpha’ is 256 characters.

The information here is written to file UDELMAP in library RCSUTILPRD. InfoNet item maintenance reads it to control the entry of user defined fields.