View In:   ArcGIS Online Map Viewer

Name: DBO.cvis_vanloadingHDR

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 676ff97437f84f7fa504964c4f098ff7

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1.3978095928000003E7
YMin: 793876.1328000017
XMax: 1.3994408528099999E7
YMax: 1016771.5810000002
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [57, 127, 51, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ChecklistHdrID ( type: esriFieldTypeInteger, alias: ChecklistHdrID, editable: true, nullable: true, defaultValue: null, modelName: ChecklistHdrID )
• DatePrepared ( type: esriFieldTypeDate, alias: DatePrepared, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DatePrepared )
• WayBillNo ( type: esriFieldTypeString, alias: WayBillNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WayBillNo )
• TripNo ( type: esriFieldTypeString, alias: TripNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TripNo )
• From_ ( type: esriFieldTypeString, alias: From, editable: true, nullable: true, length: 50, defaultValue: null, modelName: From_ )
• To_ ( type: esriFieldTypeString, alias: To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: To_ )
• ContainerNo ( type: esriFieldTypeString, alias: ContainerNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContainerNo )
• Destination ( type: esriFieldTypeString, alias: Destination, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Destination )
• Departure ( type: esriFieldTypeString, alias: Departure, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Departure )
• Arrival ( type: esriFieldTypeString, alias: Arrival, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Arrival )
• Started ( type: esriFieldTypeString, alias: Started, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Started )
• Finished ( type: esriFieldTypeString, alias: Finished, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Finished )
• PreparedBy ( type: esriFieldTypeString, alias: PreparedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreparedBy )
• CheckedBy ( type: esriFieldTypeString, alias: CheckedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CheckedBy )
• EnteredBy ( type: esriFieldTypeString, alias: EnteredBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EnteredBy )
• DateEntered ( type: esriFieldTypeDate, alias: DateEntered, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateEntered )
• IsShipped ( type: esriFieldTypeInteger, alias: IsShipped, editable: true, nullable: true, defaultValue: null, modelName: IsShipped )
• Temperature ( type: esriFieldTypeString, alias: Temperature, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Temperature )
• LoadingTag ( type: esriFieldTypeString, alias: LoadingTag, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LoadingTag )
• HatchDeck ( type: esriFieldTypeString, alias: HatchDeck, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HatchDeck )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Remarks )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• IsDispatchToPort ( type: esriFieldTypeSmallInteger, alias: isSubmit, editable: true, nullable: true, defaultValue: 0, modelName: IsDispatchToPort )
• NextPHNo ( type: esriFieldTypeString, alias: NextPHNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NextPHNo )
• IsMobileInput ( type: esriFieldTypeSmallInteger, alias: IsMobileInput, editable: true, nullable: true, defaultValue: 0, modelName: IsMobileInput )
• VanLoadSysID ( type: esriFieldTypeInteger, alias: VanLoadSysID, editable: true, nullable: true, defaultValue: null, modelName: VanLoadSysID )
• TempRecorderNo ( type: esriFieldTypeString, alias: TempRecorderNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TempRecorderNo )
• Consignee ( type: esriFieldTypeString, alias: Consignee, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Consignee )
• VLS_no ( type: esriFieldTypeString, alias: VLS_no, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VLS_no )
• DriverSysID ( type: esriFieldTypeInteger, alias: DriverSysID, editable: true, nullable: true, defaultValue: null, modelName: DriverSysID )
• HaulerSysID ( type: esriFieldTypeInteger, alias: HaulerSysID, editable: true, nullable: true, defaultValue: null, modelName: HaulerSysID )
• PlateNo ( type: esriFieldTypeString, alias: PlateNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PlateNo )
• TruckNo ( type: esriFieldTypeString, alias: TruckNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TruckNo )
• Terminal ( type: esriFieldTypeString, alias: Terminal, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Terminal )

Templates:

• Name: DBO.cvis_vanloadingHDR
  Description:
  Prototype:
  TruckNo: null
  PlateNo: null
  ChecklistHdrID: null
  DatePrepared: null
  WayBillNo: null
  TripNo: null
  From_: null
  To_: null
  ContainerNo: null
  Destination: null
  Departure: null
  Arrival: null
  Started: null
  Finished: null
  PreparedBy: null
  CheckedBy: null
  EnteredBy: null
  DateEntered: null
  IsShipped: null
  Temperature: null
  LoadingTag: null
  HatchDeck: null
  Remarks: null
  Terminal: null
  IsDispatchToPort: 0
  NextPHNo: null
  IsMobileInput: 0
  VanLoadSysID: null
  TempRecorderNo: null
  Consignee: null
  VLS_no: null
  DriverSysID: null
  HaulerSysID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• DBO.cvis_vanloadingDTL (0) -- Related To: DBO.cvis_vanloadingDTL (1)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata