CommsRequestFieldDetail

Field Name Type Nullable? Comment
CommsRequestID (PK/FK)     Autogenerated
Comms FieldCode (PK) VARCHAR(20)    
Sequence (PK) Number (3)   Allows for recurring fields e.g. a list of billable assets
TextValue VARCHAR(20) Nullable  
DateTimeValue TIMESTAMP Nullable  
MonetaryValue Numeric (9,2) Nullable  
AuditProcess      
AuditTimeStamp DateTime    
AuditUser