Another question for egroup types or other gurus:

Doing ebase customization.

Am puzzled by six (STORED) calc fields in Paymnts.102 , SCDef1Key . . . 
SCDef6Key.  These contain the number 1 through 6 followed by the 
appropriate part of the source code for the payment.  My question is: why 
do these fields have to be stored?  They are used in six relationships 
which allow the description text for the six source code value pairs to pop 
up when you choose a SC.  But for this they don't need to be stored.  There 
are also relationships from SCDEFS back to Paymnts, but I can't see where 
these relationships are used...  Can anyone help?  We've got a large data 
set and are trying to pare down unneccessary fields.

Also - is there a reason why SCPos1...SCPos6 in Paymnts are lookups instead 
of calced text functions of the Source Code field?  Seems like lookups 
would be slower.

Thanks,

Matthew Scholtz
San Francisco, CA


Reply via email to