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