Table: SignatureDocument

Database schema and system attributes for SignatureDocument.

AppliesToPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

AssignedToPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

BinaryFileId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CompletionEmailSentDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

CreatedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

DocumentKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 400

EntityId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

EntityTypeId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignGuid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

ForeignId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

Guid

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

Id

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

InviteCount

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

LastInviteDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

LastStatusDate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

ModifiedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ModifiedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Name

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 500

SignatureDataEncrypted

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

SignatureDocumentTemplateId

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

SignatureVerificationHash

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 80

SignedByEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 150

SignedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

SignedClientIp

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 256

SignedClientUserAgent

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

SignedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

SignedDocumentText

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

SignedName

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 500

Status

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4