Trung

Tables (99)

AUDIT_LOG_01

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_02

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_03

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_04

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_05

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_06

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_07

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_08

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_09

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_10

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_11

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

AUDIT_LOG_12

  • LogID — varchar(100) — NOT NULL
  • ScreenID — varchar(50)
  • TableName — varchar(100)
  • FieldName — varchar(100)
  • UpdatedRecID — varchar(50)
  • UserName — varchar(50)
  • LastUpdDate — datetime
  • OldValue — nvarchar(250)
  • NewValue — nvarchar(250)
  • LogDesc — varchar(100)

ActionHis

  • ActionHisID — varchar(20)
  • ActionReqID — varchar(20)
  • DocID — varchar(20)
  • DocType — varchar(50)
  • StorageCode — nvarchar(50)
  • RegNo — varchar(50)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • BusinessLine — varchar(10)
  • What — nvarchar(200)
  • Who — nvarchar(200)
  • Where — nvarchar(200)
  • Why — nvarchar(200)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • ChassisNo — varchar(50)
  • MrcCode — varchar(50)

ActionReq

  • ActionReqID — varchar(20)
  • What — nvarchar(200)
  • Who — nvarchar(200)
  • Where — nvarchar(200)
  • Why — nvarchar(200)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

BOSTORAGE

  • RegNo — float
  • ContractNo — nvarchar(255)
  • DueDate — float
  • CustomerName — nvarchar(255)
  • BusinessLine — nvarchar(255)
  • StorageCode — nvarchar(255)
  • AssignedUser — varchar(50)

BOSTORAGE_INCPF

  • RegNo — float
  • ContractNo — nvarchar(255)
  • DueDate — float
  • CustomerName — nvarchar(255)
  • BusinessLine — nvarchar(255)
  • StorageCode — nvarchar(255)

BOSTORAGE_MRC

  • STT — float
  • No — float
  • ContractNo — nvarchar(255)
  • IndusSignDate — datetime
  • IndusTerminationDate — datetime
  • DueDay — float
  • IndusDisbDate — datetime
  • CustomerName — nvarchar(255)
  • POS — nvarchar(255)
  • DateReceiveMRC — datetime
  • PlateNumber — nvarchar(255)
  • MRCCode — varchar(200)
  • ContractStatus — nvarchar(255)
  • StatusOfMRCRF — nvarchar(255)
  • NewCode — nvarchar(255)
  • PendingDate — datetime
  • Remark — nvarchar(255)
  • CODE — MT
  • CODE — ET
  • F20 — nvarchar(255)
  • F21 — datetime
  • F22 — datetime
  • BusinessLine — varchar(50)
  • AssignedUser — varchar(50)

CAMRequest

  • CAMRequestID — varchar(20) — NOT NULL
  • SenderID — varchar(20) — NOT NULL
  • FromScreen — nvarchar(50)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • BusinessLine — varchar(10)
  • DocumentName — nvarchar(100)
  • DisbDone — varchar(10)
  • CPFMistakeID — varchar(20)
  • CPFMistakeDesc — nvarchar(100)
  • CPFMistakeSol — nvarchar(200)
  • PosCode — varchar(50)
  • PosOrder — varchar(20)
  • NextUser — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)

CONSO_DOC

  • ConSoDocID — varchar(20) — NOT NULL
  • SenderID — varchar(20) — NOT NULL
  • FromScreen — nvarchar(50)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • PosCode — varchar(50)
  • PosOrder — varchar(20)
  • TransferedDate — datetime
  • LoanContract — varchar(10)
  • CAMCorrRequest — varchar(10)
  • NotMRCToCus — varchar(10)
  • OriginalMRC — varchar(10)
  • TKLetter — varchar(10)
  • ET — varchar(10)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • ConSoPosID — varchar(20)

CONSO_POS

  • ConSoPosID — varchar(20) — NOT NULL
  • PosCode — varchar(50)
  • PosOrder — varchar(20)
  • ConSoDone — varchar(10)
  • ToPos — varchar(50)
  • DateToSend — datetime
  • Deliveried — varchar(10)
  • Channel — nvarchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)

CPF

  • CpfID — varchar(20) — NOT NULL
  • EnvelopeDeID — varchar(20)
  • ContractNo — varchar(50)
  • Qualified — varchar(10)
  • Status — varchar(50)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • SipCode — varchar(50)
  • AWB — varchar(50)
  • ChannelName — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • Quality — varchar(50)
  • Active — varchar(1)
  • AssignedGroup — varchar(50)

CPFComStorage

  • CPFComStorageID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • BusinessLine — varchar(10)
  • StorageCode — nvarchar(50)
  • RegNo — varchar(50)
  • DueDate — varchar(50)
  • ContractStatus — varchar(50)
  • ContractEndDate — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CPFDetailCheck

  • CPFDetailCheckID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • CPFCategoryID — varchar(20)
  • CPFCategoryName — nvarchar(100)
  • Received — varchar(1)
  • CPFDocumentID — varchar(100)
  • CPFDocumentName — nvarchar(100)
  • CPFQualityID — varchar(100)
  • CPFQualityName — nvarchar(100)
  • Remark — nvarchar(200)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

CPFDirect

  • CPFDirectID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • BusinessLine — varchar(10)
  • RegisterNo — varchar(50)
  • ResidenceAdd — nvarchar(200)
  • CPFProviderID — varchar(20)
  • CPFProviderName — nvarchar(100)
  • Status — varchar(50)
  • DeliveryDate — datetime
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • CPFDocumentID — varchar(20)
  • CPFDocumentName — nvarchar(100)
  • OfficeAdd — nvarchar(200)

CPFDirect_BK

  • CPFDirectID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • BusinessLine — varchar(10)
  • RegisterNo — varchar(50)
  • ResidenceAdd — nvarchar(200)
  • CPFProviderID — varchar(20)
  • CPFProviderName — nvarchar(100)
  • Status — varchar(50)
  • DeliveryDate — datetime
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • CPFDocumentID — varchar(20)
  • CPFDocumentName — nvarchar(100)
  • OfficeAdd — nvarchar(200)

CPFDisbursement

  • CPFDisbID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • DisbDone — varchar(10)
  • DisbDate — datetime
  • NextUser — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Note — varchar(100)
  • Transfered — varchar(5)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

CPFFurtherCheck

  • CPFFurtherID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • Quality — varchar(50)
  • Status — varchar(50)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • SipCode — varchar(50)
  • AWB — varchar(50)
  • ChannelName — varchar(50)
  • Transfered — varchar(1)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • NextUserStore — varchar(50)
  • NextUserCAM — varchar(50)

CPFFurtherCheck_BK

  • CPFFurtherID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • Quality — varchar(50)
  • Status — varchar(50)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • SipCode — varchar(50)
  • AWB — varchar(50)
  • ChannelName — varchar(50)
  • Transfered — varchar(1)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • NextUserStore — varchar(50)
  • NextUserCAM — varchar(50)

CPFInComStorage

  • CPFInComStorageID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • BusinessLine — varchar(10)
  • StorageCode — nvarchar(50)
  • RegNo — varchar(50)
  • DueDate — varchar(50)
  • ContractStatus — varchar(50)
  • ContractEndDate — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

CPFIndirect

  • CPFIndirectID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • CPFDocumentID — varchar(20)
  • CPFDocumentName — nvarchar(100)
  • SipCode — varchar(50)
  • BusinessLine — varchar(10)
  • PosOrder — varchar(5)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • NextUser — varchar(50)

CPFIndirect_BK

  • CPFIndirectID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • CPFDocumentID — varchar(20)
  • CPFDocumentName — nvarchar(100)
  • SipCode — varchar(50)
  • BusinessLine — varchar(10)
  • PosOrder — varchar(5)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • NextUser — varchar(50)

CPFMistakeDetect

  • CPFMiskateDetectID — varchar(20)
  • CPFDetailID — varchar(20)
  • CPFDocumentID — varchar(20)
  • CPFMistakeID — varchar(20)
  • CPFMistakeName — nvarchar(100)
  • Note — varchar(100)

CPFOutFlow

  • CPFOutFlowID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • BusinessLine — varchar(10)
  • NextUser — varchar(50)
  • Delivery — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Note — varchar(100)
  • Transfered — varchar(5)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

CPFStamping

  • CPFStampingID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • StampingDone — varchar(10)
  • StampingDate — datetime
  • FurtherCheck — varchar(10)
  • NextUser — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Note — varchar(100)
  • Transfered — varchar(1)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime
  • NextUserStore — varchar(50)

CaMistake

  • MistakeID — varchar(20) — NOT NULL
  • EnvelopeDeID — varchar(20)
  • MistakeTypeID — varchar(20)
  • MistakeTypeName — nvarchar(50)
  • ContractNo — varchar(50)
  • Qualified — varchar(10)
  • Status — varchar(20)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • Comment — nvarchar(255) — varchar(255) NUL
  • SipCode — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • F10 — nvarchar(100)

CaMistake_BK

  • MistakeID — varchar(20) — NOT NULL
  • EnvelopeDeID — varchar(20)
  • MistakeTypeID — varchar(20)
  • MistakeTypeName — nvarchar(50)
  • ContractNo — varchar(50)
  • Qualified — varchar(10)
  • Status — varchar(20)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • Comment — nvarchar(255) — varchar(255) NUL
  • SipCode — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • F10 — nvarchar(100)

CpfDetail

  • CpfDetailID — varchar(20) — NOT NULL
  • CpfID — varchar(20)
  • ContractNo — varchar(50)
  • Doc — nvarchar(50)
  • Status — varchar(50)
  • ReceptionDate — datetime
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)

DOCTOSEND

  • RequestUser — varchar(50)
  • DocToSendID — varchar(20)
  • BillNo — nvarchar(50)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PlateNo — nvarchar(50)
  • ToPos — varchar(50)
  • Document — nvarchar(100)
  • OrgMRC — varchar(10)
  • AssignedUser — varchar(50)
  • DateToSend — varchar(50)
  • Channel — nvarchar(50)
  • Branch — nvarchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • UplFileName — nvarchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)

ENVELOPE

  • EnvelopeID — varchar(100) — NOT NULL
  • AWB — varchar(50)
  • ChannelID — varchar(20)
  • ChannelName — varchar(50)
  • SipCode — varchar(50)
  • Comment — nvarchar(255) — varchar(255) NUL
  • ReceptionDate — datetime
  • NextUser — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • Active — varchar(5)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • Notepad — nvarchar(255)

ET

  • EtID — varchar(20) — NOT NULL
  • EnvelopeDeID — varchar(20)
  • ContractNo — varchar(50)
  • Qualified — varchar(10)
  • Status — varchar(20)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • Comment — nvarchar(255) — varchar(255) NUL
  • EtFutureCap — numeric(18, 0)
  • UnPaidAmount — numeric(18, 0)
  • BrokenPeriodInterest — numeric(18, 0)
  • LatePaymentPenalty — numeric(18, 0)
  • EtFee — numeric(18, 0)
  • VatEtFee — numeric(18, 0)
  • ExcessAmount — numeric(18, 0)
  • TotalEtAmount — numeric(18, 0)
  • SipCode — varchar(50)
  • AWB — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)

EnvelopeDetail

  • EnvelopeDeID — varchar(20) — NOT NULL
  • EnvelopeID — varchar(20)
  • AWB — varchar(50)
  • DocTypeID — varchar(20)
  • DocTypeName — varchar(50)
  • ContractNo — varchar(50)
  • MrcQuantity — int
  • ReceptionDate — datetime
  • SipCode — varchar(50)
  • NextUser — varchar(50)
  • PreviousUser — varchar(50)
  • Comment — nvarchar(100) — varchar(100) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • Active — varchar(5)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • ScanPos — varchar(1)
  • IndusPos — varchar(50)

EnvelopeDetail_BK

  • EnvelopeDeID — varchar(20) — NOT NULL
  • EnvelopeID — varchar(20)
  • AWB — varchar(50)
  • DocTypeID — varchar(20)
  • DocTypeName — varchar(50)
  • ContractNo — varchar(50)
  • MrcQuantity — int
  • ReceptionDate — datetime
  • SipCode — varchar(50)
  • NextUser — varchar(50)
  • PreviousUser — varchar(50)
  • Comment — nvarchar(100) — varchar(100) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • Active — varchar(5)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)

INDUS_CONTRACT

  • ContractNo — varchar(50) — Primary key — NOT NULL
  • CustomerName — nvarchar(200)
  • CustomerAddress — nvarchar(250)
  • DisbursementDate — varchar(50)
  • ContractSignedDate — varchar(50)
  • ContractMaturityDate — varchar(50)
  • ContractLastPaymentDate — varchar(50)
  • SipCode — varchar(50)
  • CaCode — varchar(50)
  • CaName — nvarchar(200)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • ContractStatus — varchar(50)
  • ImportedDate — varchar(50)
  • UserDatetime — varchar(50)
  • InsStartDate — varchar(50)
  • InsEndDate — varchar(50)
  • CycleDay — varchar(10)
  • OFAddress — nvarchar(200)
  • LastEngineNo — varchar(10)
  • Model — nvarchar(100)
  • SchemeCode — varchar(50)
  • PrintDate — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

INDUS_ETCONTRACT

  • ContractNo — varchar(50) — Primary key — NOT NULL
  • CustomerName — nvarchar(200)
  • CustomerAddress — nvarchar(250)
  • DisbursementDate — varchar(50)
  • ContractSignedDate — varchar(50)
  • ContractETDate — varchar(50)
  • ContractLastPaymentDate — varchar(50)
  • SipCode — varchar(50)
  • CaCode — varchar(50)
  • CaName — nvarchar(200)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • ContractStatus — varchar(50)
  • ImportedDate — varchar(50)
  • UserDatetime — varchar(50)
  • InsStartDate — varchar(50)
  • InsEndDate — varchar(50)
  • CycleDay — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

INDUS_LIVECONTRACT

  • ContractNo — varchar(50) — Primary key — NOT NULL
  • CustomerName — nvarchar(200)
  • CustomerAddress — nvarchar(250)
  • DisbursementDate — varchar(50)
  • ContractSignedDate — varchar(50)
  • ContractETDate — varchar(50)
  • ContractLastPaymentDate — varchar(50)
  • SipCode — varchar(50)
  • CaCode — varchar(50)
  • CaName — nvarchar(200)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • ContractStatus — varchar(50)
  • ImportedDate — varchar(50)
  • UserDatetime — varchar(50)
  • InsStartDate — varchar(50)
  • InsEndDate — varchar(50)
  • CycleDay — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

INDUS_MATURECONTRACT

  • ContractNo — varchar(50) — Primary key — NOT NULL
  • CustomerName — nvarchar(200)
  • CustomerAddress — nvarchar(250)
  • DisbursementDate — varchar(50)
  • ContractSignedDate — varchar(50)
  • ContractMaturityDate — varchar(50)
  • ContractLastPaymentDate — varchar(50)
  • SipCode — varchar(50)
  • CaCode — varchar(50)
  • CaName — nvarchar(200)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • ContractStatus — varchar(50)
  • ImportedDate — varchar(50)
  • UserDatetime — varchar(50)
  • InsStartDate — varchar(50)
  • InsEndDate — varchar(50)
  • CycleDay — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

INDUS_NOTYETCONTRACT

  • ContractNo — varchar(50) — Primary key — NOT NULL
  • CustomerName — nvarchar(200)
  • CustomerAddress — nvarchar(250)
  • ContractSignedDate — varchar(50)
  • SipCode — varchar(50)
  • CaCode — varchar(50)
  • CaName — nvarchar(200)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • ContractStatus — varchar(50)
  • ImportedDate — varchar(50)
  • UserDatetime — varchar(50)
  • InsStartDate — varchar(50)
  • InsEndDate — varchar(50)
  • CycleDay — varchar(10)
  • OFAddress — nvarchar(200)
  • LastEngineNo — varchar(10)
  • Model — nvarchar(100)
  • SchemeCode — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

INDUS_POS

  • BranchCode — varchar(30)
  • BranchName — nvarchar(500)
  • HeadOffice — varchar(10)
  • BranchAddress — nvarchar(2000)
  • Active — varchar(10)

INDUS_REQUEST

  • RequestID — varchar(20) — NOT NULL
  • RequestedDate — datetime
  • RequestedFile — nvarchar(100) — NOT NULL
  • EvidenceFile — nvarchar(100) — NOT NULL
  • Approved — varchar(5) — NOT NULL
  • RequestedUser — varchar(20)
  • ApprovedUser — varchar(20)
  • ApprovedDate — datetime
  • Comment — nvarchar(200) — varchar(200) NUL
  • CreatedDate — datetime
  • LastUpdDate — datetime

INDUS_REQUEST_DETAILS

  • RequestID — varchar(20) — NOT NULL
  • ContractNo — varchar(20) — NOT NULL
  • AddressType — varchar(20) — NOT NULL
  • UpdatedKey — nvarchar(50) — NOT NULL
  • UpdatedValue — nvarchar(100) — NOT NULL
  • ResultCode — varchar(20)
  • ResultMessage — nvarchar(200)
  • CreatedDate — datetime
  • LastUpdDate — datetime

MRC

  • MrcID — varchar(20) — NOT NULL
  • EnvelopeDeID — varchar(20)
  • ContractNo — varchar(20)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • CavetNo — varchar(50)
  • Status — varchar(50)
  • StorageCode — varchar(50)
  • SgvfReceivedDate — datetime
  • NotarizedReceivedDate — datetime
  • ReceptionDate — datetime
  • SipCode — varchar(50)
  • PreviousUser — varchar(50)
  • AWB — varchar(50)
  • MrcQuantity — int
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • F10 — nvarchar(100)
  • NextUser — varchar(50)

MRCDETAIL

  • MrcDeID — varchar(20)
  • MrcID — varchar(20)
  • MrcCode — varchar(50)
  • CustomerName — nvarchar(100)
  • EngineNo — varchar(50)
  • Comment — nvarchar(100) — varchar(100) NUL
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • ChassisNo — varchar(50)
  • ContractNo — varchar(50)
  • RsAddress — nvarchar(250)
  • PlateNo — varchar(50)

MRCDETAIL_BK

  • MrcDeID — varchar(20) — NOT NULL
  • MrcID — varchar(20)
  • MrcCode — varchar(50)
  • CustomerName — nvarchar(100)
  • EngineNo — varchar(50)
  • Comment — nvarchar(100) — varchar(100) NUL
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • ChassisNo — varchar(50)
  • ContractNo — varchar(50)
  • RsAddress — nvarchar(250)
  • PlateNo — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MRCExport

  • MrcExportID — varchar(20) — NOT NULL
  • MrcReqID — varchar(20) — NOT NULL
  • ContractNo — varchar(20)
  • CustomerName — nvarchar(100)
  • ContractStatus — varchar(50)
  • PosCode — varchar(50)
  • DocumentName — nvarchar(100)
  • Requester — varchar(50)
  • RequestDate — datetime
  • Reason — nvarchar(100)
  • MrcStored — varchar(10)
  • MrcExported — varchar(10)
  • MrcExportedDate — datetime
  • NextUser — varchar(50)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • WF — varchar(10)

MRCIac

  • MrcIacID — varchar(20) — NOT NULL
  • MrcID — varchar(20) — NOT NULL
  • MrcDeID — varchar(20) — NOT NULL
  • ContractNo — varchar(20)
  • CustomerName — nvarchar(100)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • IacDone — varchar(10)
  • DateOfIac — datetime
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)

MRCMatching

  • MrcMatchingID — varchar(20) — NOT NULL
  • MrcExportID — varchar(20) — NOT NULL
  • MrcReqID — varchar(20) — NOT NULL
  • ContractNo — varchar(20)
  • CustomerName — nvarchar(100)
  • DocumentName — nvarchar(100)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • Reason — nvarchar(100)
  • ReceptionDate — datetime
  • PreviousUser — varchar(50)
  • PosCode — varchar(50)
  • MatchingDone — varchar(10)
  • NextUser — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • WF — varchar(10)

MRCNotarization

  • MrcNotarizationID — varchar(20) — NOT NULL
  • MrcID — varchar(20) — NOT NULL
  • MrcDeID — varchar(20) — NOT NULL
  • ContractNo — varchar(20)
  • CustomerName — nvarchar(100)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • Messenger — varchar(50)
  • PreviousUser — varchar(50)
  • DateToMess — datetime
  • NotarizationDone — varchar(10)
  • ReturnDate — datetime
  • Comment — nvarchar(200) — varchar(200) NUL
  • NextUser_IAC — varchar(50)
  • NextUser_Storage — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)

MRCRequest

  • MrcReqID — varchar(20) — NOT NULL
  • ContractNo — varchar(20)
  • CustomerName — nvarchar(100)
  • ContractStatus — varchar(50)
  • EndDate — datetime
  • PosCode — varchar(50)
  • Reason — nvarchar(100)
  • DocumentName — nvarchar(100)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • NextUser — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • WF — varchar(10)

MRCToCus

  • MrcToCusID — varchar(20)
  • MrcID — varchar(20)
  • MrcDeID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • PreviousUser — varchar(50)
  • DocumentName — nvarchar(100)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • SipCode — varchar(50)
  • PosOrder — varchar(5)
  • NextUser — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

MRC_BK

  • MrcID — varchar(20) — Primary key — NOT NULL
  • EnvelopeDeID — varchar(20)
  • ContractNo — varchar(20)
  • EngineNo — varchar(50)
  • PlateNo — varchar(50)
  • CavetNo — varchar(50)
  • Status — varchar(50)
  • StorageCode — varchar(50)
  • SgvfReceivedDate — datetime
  • NotarizedReceivedDate — datetime
  • ReceptionDate — datetime
  • SipCode — varchar(50)
  • PreviousUser — varchar(50)
  • AWB — varchar(50)
  • MrcQuantity — int
  • Transfered — varchar(5)
  • Note — varchar(100)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • AssignedUser — varchar(50)
  • LastUpdDate — datetime
  • LastUpdUser — varchar(50)
  • F1 — nvarchar(100)
  • F2 — nvarchar(100)
  • F3 — nvarchar(100)
  • F4 — nvarchar(100)
  • F5 — nvarchar(100)
  • F6 — nvarchar(100)
  • F7 — nvarchar(100)
  • F8 — nvarchar(100)
  • F9 — nvarchar(100)
  • F10 — nvarchar(100)
  • NextUser — varchar(50)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

MST_CAM

  • Code — nvarchar(255)
  • Document — nvarchar(255)
  • Mistakes — nvarchar(255)
  • MistakeVN — nvarchar(255)
  • Penalty — float
  • NotDisb — nvarchar(255)
  • Disb — nvarchar(255)

MST_CHANNEL

  • ChannelID — varchar(20) — NOT NULL
  • ChannelName — nvarchar(100)
  • Active — varchar(50)

MST_CPFCategory

  • CPFCategoryID — varchar(20)
  • CPFCategoryName — nvarchar(100)
  • Active — varchar(1)
  • Note — varchar(100)

MST_CPFDelivery

  • CPFDeliveryID — varchar(20)
  • CPFDeliveryName — nvarchar(100)
  • Note — varchar(100)
  • Active — varchar(1)

MST_CPFDocument

  • CPFDocumentID — varchar(20)
  • CPFDocumentName — nvarchar(100)
  • CPFCategoryID — varchar(20)
  • Active — varchar(1)
  • Note — varchar(100)

MST_CPFMistake

  • CPFMistakeID — varchar(20)
  • CPFMistakeName — nvarchar(100)
  • CPFMistakeDesc — nvarchar(max)
  • CPFMistakeSol — nvarchar(max)
  • CPFCategoryID — varchar(20)
  • Active — varchar(1)
  • Note — varchar(100)
  • CPFCategoryName — nvarchar(100)
  • CPFMistakeDescVN — nvarchar(max)
  • Penalty — varchar(100)
  • NotDisb — varchar(100)
  • Disb — varchar(100)
  • RISK — nvarchar(100)

MST_CPFProvider

  • CPFProviderID — varchar(20)
  • CPFProviderName — nvarchar(100)
  • Note — varchar(100)
  • Active — varchar(1)

MST_CPFQuality

  • CPFQualityID — varchar(20)
  • CPFQualityName — nvarchar(100)
  • Active — varchar(1)
  • Note — varchar(100)

MST_DOCTYPE

  • DocTypeID — varchar(20) — NOT NULL
  • DocTypeName — nvarchar(100)
  • Active — varchar(50)

MST_GROUP_CPF

  • GroupCode — nvarchar(50)
  • GroupName — nvarchar(255)
  • Active — nvarchar(1)

MST_GROUP_USER_CPF

  • GroupCode — nvarchar(50)
  • UserName — varchar(50)
  • UserID — varchar(50)

MST_MESSENGER

  • MessengerUser — varchar(50)
  • MessengerName — nvarchar(100)
  • Active — varchar(1)

MST_MISTAKETYPE

  • MistakeTypeID — varchar(20)
  • MistakeTypeName — varchar(200)
  • MisDesc — nvarchar(200)

MST_POSORDER

  • PosCode — varchar(50)
  • PosOrder — varchar(20)
  • Batch — varchar(50)
  • BDS — nvarchar(100)
  • PosName — nvarchar(100)
  • PosAddress — nvarchar(200)
  • PosPhone — varchar(50)
  • SubPos — varchar(50)
  • Remark — nvarchar(200)
  • Region — varchar(50)
  • Active — varchar(1)
  • AMS — nvarchar(100)

MST_QUALIFIED

  • QualifiedID — varchar(20)
  • QualifiedName — varchar(50)

MST_SCAN_POS

  • PosCode — varchar(30)
  • Active — varchar(10)

MST_SCHEME

  • SchemeCode — varchar(50) — NOT NULL
  • SchemeName — nvarchar(100)
  • Active — varchar(10)

MST_STATUS

  • StatusID — varchar(20)
  • StatusName — varchar(50)

MST_TEMPLATE_CHECK

  • CPFDetailCheckID — varchar(20)
  • CPFID — varchar(20)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • CPFCategoryID — varchar(20)
  • CPFCategoryName — nvarchar(100)
  • Received — varchar(1)
  • CPFDocumentID — varchar(100)
  • CPFDocumentName — nvarchar(100)
  • CPFQualityID — varchar(100)
  • CPFQualityName — nvarchar(100)
  • Remark — nvarchar(200)
  • BusinessLine — varchar(10)

MrcStorage

  • MrcStorageID — varchar(20)
  • MrcNotarizationID — varchar(20)
  • MrcDeID — varchar(20)
  • MrcID — varchar(20)
  • PlateNo — varchar(50)
  • EngineNo — varchar(50)
  • ChassisNo — varchar(50)
  • MrcCode — varchar(50)
  • ContractNo — varchar(50)
  • CustomerName — nvarchar(100)
  • BusinessLine — varchar(10)
  • StorageCode — nvarchar(50)
  • RegNo — varchar(50)
  • DueDate — varchar(50)
  • ContractStatus — varchar(50)
  • ContractEndDate — varchar(50)
  • Comment — nvarchar(200) — varchar(200) NUL
  • PreviousUser — varchar(50)
  • NextUser — varchar(50)
  • Transfered — varchar(5)
  • Note — varchar(100)
  • AssignedUser — varchar(50)
  • CreatedUser — varchar(50)
  • CreatedDate — datetime
  • LastUpdUser — varchar(50)
  • LastUpdDate — datetime

and 19 more tables