📚 SAP Business One SDK Help

Table Name: CUDV

Table Description: User-Defined Values

Field Description Type Size Related Default Value Constraints
FormID Form ID nVarChar 100 -      
ItemID Field nVarChar 52 -      
ColID Column ID nVarChar 128 - -1    
ActionT Action Int 6 - 0 0  
            1 Filtered List
            2 Formula
QueryId Query ID Int 11 OUQR      
IndexID Index Int 11 -      
Refresh Refresh VarChar 1 - N Y Yes
            N No
FieldID Field nVarChar 60 -      
FrceRfrsh Force Refresh VarChar 1 - N Y Yes
            N No
ByField By Field VarChar 1 - N Y When Field Changes
            N When Exiting Altered Column
            C When Column Value Changes
ViewCmplt Allow to View Full List VarChar 1 - N Y Yes
            N No
ExpId Formula ID Int 11 CUVE      
BObject B Object nVarChar 254 -      
DObject DB Object Name nVarChar 52 -      
CreateTS Create Time Int 11 -      
UpdateTS Update Time Int 11 -      
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
CreateDate Creation Date Date 8 -      
UpdateDate Date of Update Date 8 -      
Key Unique Field
PRIMARY Yes IndexID
DETAILS Yes FormID
    ItemID
    ColID