stschedule
Tables (12)
TB_SCHDAssignedVSL
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- UserID — varchar(50) — NOT NULL
- UserDESC — varchar(50) — NOT NULL
- VSLName — char(25) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDFavoriteVSL
- UserID — varchar(50) — NOT NULL
- VSLCode — char(3) — NOT NULL
- VSLName — char(25) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDITNRTMPL
- RegionCode — char(5) — NOT NULL
- RUTCode — char(5) — NOT NULL
- SEQ — decimal(3, 0) — NOT NULL
- POTCode — char(5) — NOT NULL
- TerminalCode — char(6) — NOT NULL
- ArrivalDate — date — NOT NULL
- ArrivalTime — time — NOT NULL
- DepartureDate — date — NOT NULL
- DepartureTime — time — NOT NULL
- ActivityCode — char(2) — NOT NULL
- POLTag — char(1) — NOT NULL
- PODTag — char(1) — NOT NULL
- TemplateDESC — varchar(50) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDMasterHistory
- HistoryDate — decimal(8, 0) — NOT NULL
- HistorySEQ — decimal(3, 0) — NOT NULL
- VYGCode — char(8) — NOT NULL
- VSLCode — char(3) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- VSLName — char(25) — NOT NULL
- OperatedBy — char(5) — NOT NULL
- StartDate — date — NOT NULL
- StartTime — time — NOT NULL
- EndDate — date — NOT NULL
- EndTime — time — NOT NULL
- DurationStartDate — date — NOT NULL
- DurationStartTime — time — NOT NULL
- DurationEndDate — date — NOT NULL
- DurationEndTime — time — NOT NULL
- StartDateGMT — date — NOT NULL
- StartTimeGMT — time — NOT NULL
- EndDateGMT — date — NOT NULL
- EndTimeGMT — time — NOT NULL
- DurationStartDateGMT — date — NOT NULL
- DurationStartTimeGMT — time — NOT NULL
- DurationEndDateGMT — date — NOT NULL
- DurationEndTimeGMT — time — NOT NULL
- Duration — decimal(4, 2) — NOT NULL
- SeaDay — decimal(4, 2) — NOT NULL
- POTDay — decimal(4, 2) — NOT NULL
- RUT — char(6) — NOT NULL
- InputPerson — char(10)
- InputDate — date
- UpdatePerson — char(10)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDNoteDetail
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- POTCode — char(5) — NOT NULL
- PotID — decimal(10, 0) — NOT NULL
- SEQ — decimal(3, 0) — NOT NULL
- SubSEQ — decimal(3, 0) — NOT NULL
- ActivityCode — char(1) — NOT NULL
- ActivityDESC — varchar(30) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDNoteDetailHistory
- HistoryDate — decimal(8, 0) — NOT NULL
- HistorySEQ — decimal(3, 0) — NOT NULL
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- POTCode — char(5) — NOT NULL
- PotID — decimal(10, 0) — NOT NULL
- SEQ — decimal(3, 0) — NOT NULL
- SubSEQ — decimal(3, 0) — NOT NULL
- ActivityCode — char(1) — NOT NULL
- ActivityDESC — varchar(30) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDNoteMaster
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- POTCode — char(5) — NOT NULL
- PotID — decimal(10, 0) — NOT NULL
- SEQ — decimal(3, 0) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- Title — varchar(30) — NOT NULL
- DelayDateFrom — date — NOT NULL
- DelayDateTo — date — NOT NULL
- DelayDuration — decimal(4, 2) — NOT NULL
- Note — varchar(500) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDNoteMasterHistory
- HistoryDate — decimal(8, 0) — NOT NULL
- HistorySEQ — decimal(3, 0) — NOT NULL
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- POTCode — char(5) — NOT NULL
- PotID — decimal(10, 0) — NOT NULL
- SEQ — decimal(3, 0) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- Title — varchar(30) — NOT NULL
- DelayDateFrom — date — NOT NULL
- DelayDateTo — date — NOT NULL
- DelayDuration — decimal(4, 2) — NOT NULL
- Note — varchar(500) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDPort
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- POTCode — char(5) — NOT NULL
- POTID — decimal(10, 0) — NOT NULL
- DCALLSEQ — decimal(2, 0) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- TargetArrivalDate — date — NOT NULL
- TargetArrivalTime — time — NOT NULL
- TargetDepartureDate — date — NOT NULL
- TargetDepartureTime — time — NOT NULL
- ActualArrivalDate — date — NOT NULL
- ActualArrivalTime — time — NOT NULL
- ActualDepartureDate — date — NOT NULL
- ActualDepartureTime — time — NOT NULL
- VSLArrivalDate — date — NOT NULL
- VSLArrivalTime — time — NOT NULL
- VSLDepartureDate — date — NOT NULL
- VSLDepartureTime — time — NOT NULL
- TargetArrivalDateGMT — date — NOT NULL
- TargetArrivalTimeGMT — time — NOT NULL
- TargetDepartureDateGMT — date — NOT NULL
- TargetDepartureTimeGMT — time — NOT NULL
- ActualArrivalDateGMT — date — NOT NULL
- ActualArrivalTimeGMT — time — NOT NULL
- ActualDepartureDateGMT — date — NOT NULL
- ActualDepartureTimeGMT — time — NOT NULL
- VSLArrivalDateGMT — date — NOT NULL
- VSLArrivalTimeGMT — time — NOT NULL
- VSLDepartureDateGMT — date — NOT NULL
- VSLDepartureTimeGMT — time — NOT NULL
- POTDay — decimal(4, 2) — NOT NULL
- SeaDay — decimal(4, 2) — NOT NULL
- CALLReason — char(2) — NOT NULL
- Distance — decimal(5, 0) — NOT NULL
- DelayType — char(1) — NOT NULL
- DelayTime — decimal(4, 2) — NOT NULL
- ICSPOTTag — char(1) — NOT NULL
- POTNation — char(2) — NOT NULL
- MasterName — char(30) — NOT NULL
- Speed — decimal(3, 1) — NOT NULL
- POTRotationSEQ — decimal(3, 0) — NOT NULL
- TimeZone — decimal(2, 0) — NOT NULL
- SEFlag — char(1) — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDPortHistory
- HistoryDate — decimal(8, 0) — NOT NULL
- HistorySEQ — decimal(3, 0) — NOT NULL
- VYGCode — char(8) — NOT NULL
- VSLCode — char(3) — NOT NULL
- POTCode — char(5) — NOT NULL
- POTID — decimal(10, 0) — NOT NULL
- DCALLSEQ — char(2) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- TargetArrivalDate — date — NOT NULL
- TargetArrivalTime — time — NOT NULL
- TargetDepartureDate — date — NOT NULL
- TargetDepartureTime — time — NOT NULL
- ActualArrivalDate — date — NOT NULL
- ActualArrivalTime — time — NOT NULL
- ActualDepartureDate — date — NOT NULL
- ActualDepartureTime — time — NOT NULL
- VSLArrivalDate — date — NOT NULL
- VSLArrivalTime — time — NOT NULL
- VSLDepartureDate — date — NOT NULL
- VSLDepartureTime — time — NOT NULL
- TargetArrivalDateGMT — date — NOT NULL
- TargetArrivalTimeGMT — time — NOT NULL
- TargetDepartureDateGMT — date — NOT NULL
- TargetDepartureTimeGMT — time — NOT NULL
- ActualArrivalDateGMT — date — NOT NULL
- ActualArrivalTimeGMT — time — NOT NULL
- ActualDepartureDateGMT — date — NOT NULL
- ActualDepartureTimeGMT — time — NOT NULL
- VSLArrivalDateGMT — date — NOT NULL
- VSLArrivalTimeGMT — time — NOT NULL
- VSLDepartureDateGMT — date — NOT NULL
- VSLDepartureTimeGMT — time — NOT NULL
- POTDay — decimal(4, 2) — NOT NULL
- SeaDay — decimal(4, 2) — NOT NULL
- CALLReason — char(2) — NOT NULL
- Distance — decimal(5, 0) — NOT NULL
- DelayType — char(1) — NOT NULL
- DelayTime — decimal(4, 2) — NOT NULL
- ICSPOTTag — char(1) — NOT NULL
- POTNation — char(2) — NOT NULL
- MasterName — char(30) — NOT NULL
- Speed — decimal(3, 1) — NOT NULL
- POTRotationSEQ — decimal(3, 0) — NOT NULL
- TimeZone — decimal(2, 0) — NOT NULL
- SEFlag — char(1) — NOT NULL
- InputPerson — char(10)
- InputDate — date
- UpdatePerson — char(10)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDTerminal
- VSLCode — char(3) — NOT NULL
- VYGCode — char(8) — NOT NULL
- POTCode — char(5) — NOT NULL
- POTID — decimal(10, 0) — NOT NULL
- TerminalCode — char(6) — NOT NULL
- TerminalID — decimal(10, 0) — NOT NULL
- DCALLSEQ — decimal(2, 0) — NOT NULL
- TerminalCALLSEQ — decimal(2, 0) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- TargetArrivalDate — date — NOT NULL
- TargetArrivalTime — time — NOT NULL
- TargetDepartureDate — date — NOT NULL
- TargetDepartureTime — time — NOT NULL
- ActualArrivalDate — date — NOT NULL
- ActualArrivalTime — time — NOT NULL
- ActualDepartureDate — date — NOT NULL
- ActualDepartureTime — time — NOT NULL
- TargetArrivalDateGMT — date — NOT NULL
- TargetArrivalTimeGMT — time — NOT NULL
- TargetDepartureDateGMT — date — NOT NULL
- TargetDepartureTimeGMT — time — NOT NULL
- ActualArrivalDateGMT — date — NOT NULL
- ActualArrivalTimeGMT — time — NOT NULL
- ActualDepartureDateGMT — date — NOT NULL
- ActualDepartureTimeGMT — time — NOT NULL
- TargetCMCDate — date — NOT NULL
- TargetCMCTime — time — NOT NULL
- TargetCompleteDate — date — NOT NULL
- TargetCompleteTime — time — NOT NULL
- ActualCMCDate — date — NOT NULL
- ActualCMCTime — time — NOT NULL
- ActualCompleteDate — date — NOT NULL
- ActualCompleteTime — time — NOT NULL
- TargetCMCDateGMT — date — NOT NULL
- TargetCMCTimeGMT — time — NOT NULL
- TargetCompleteDateGMT — date — NOT NULL
- TargetCompleteTimeGMT — time — NOT NULL
- ActualCMCDateGMT — date — NOT NULL
- ActualCMCTimeGMT — time — NOT NULL
- ActualCompleteDateGMT — date — NOT NULL
- ActualCompleteTimeGMT — time — NOT NULL
- InputPerson — varchar(50)
- InputDate — date
- UpdatePerson — varchar(50)
- UpdateDate — date
- NOT — NULL — NOT NULL
TB_SCHDTerminalDetailHistory
- HistoryDate — decimal(8, 0) — NOT NULL
- HistorySEQ — decimal(3, 0) — NOT NULL
- VYGCode — char(8) — NOT NULL
- VSLCode — char(3) — NOT NULL
- POTCode — char(5) — NOT NULL
- POTID — decimal(10, 0) — NOT NULL
- TerminalCode — char(6) — NOT NULL
- TerminalID — decimal(10, 0) — NOT NULL
- DCALLSEQ — decimal(2, 0) — NOT NULL
- TerminalCALLSEQ — decimal(2, 0) — NOT NULL
- VSLVYGCode — char(12) — NOT NULL
- TargetArrivalDate — date — NOT NULL
- TargetArrivalTime — time — NOT NULL
- TargetDepartureDate — date — NOT NULL
- TargetDepartureTime — time — NOT NULL
- ActualArrivalDate — date — NOT NULL
- ActualArrivalTime — time — NOT NULL
- ActualDepartureDate — date — NOT NULL
- ActualDepartureTime — time — NOT NULL
- TargetArrivalDateGMT — date — NOT NULL
- TargetArrivalTimeGMT — time — NOT NULL
- TargetDepartureDateGMT — date — NOT NULL
- TargetDepartureTimeGMT — time — NOT NULL
- ActualArrivalDateGMT — date — NOT NULL
- ActualArrivalTimeGMT — time — NOT NULL
- ActualDepartureDateGMT — date — NOT NULL
- ActualDepartureTimeGMT — time — NOT NULL
- TargetCMCDate — date — NOT NULL
- TargetCMCTime — time — NOT NULL
- TargetCompleteDate — date — NOT NULL
- TargetCompleteTime — time — NOT NULL
- ActualCMCDate — date — NOT NULL
- ActualCMCTime — time — NOT NULL
- ActualCompleteDate — date — NOT NULL
- ActualCompleteTime — time — NOT NULL
- TargetCMCDateGMT — date — NOT NULL
- TargetCMCTimeGMT — time — NOT NULL
- TargetCompleteDateGMT — date — NOT NULL
- TargetCompleteTimeGMT — time — NOT NULL
- ActualCMCDateGMT — date — NOT NULL
- ActualCMCTimeGMT — time — NOT NULL
- ActualCompleteDateGMT — date — NOT NULL
- ActualCompleteTimeGMT — time — NOT NULL
- InputPerson — char(10)
- InputDate — date
- UpdatePerson — char(10)
- UpdateDate — date
- NOT — NULL — NOT NULL