Name: MAFGIS.Sales_CRM

Display Field: DEVELOPMENTNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DEVELOPMENTNAME ( type: esriFieldTypeString, alias: DevelopmentName, length: 25 )
• PROPERTYNAME ( type: esriFieldTypeString, alias: PropertyName, length: 250 )
• UNITNUMBER ( type: esriFieldTypeString, alias: UNITNUMBER, length: 50 )
• FLOORNUMBER ( type: esriFieldTypeString, alias: BlockNumber, length: 100 )
• BEDROOMS ( type: esriFieldTypeDouble, alias: Bedrooms )
• CARPARK ( type: esriFieldTypeSmallInteger, alias: CARPARK )
• POOL ( type: esriFieldTypeString, alias: Pool, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• BLOCKNUMBER ( type: esriFieldTypeString, alias: BlockNumber, length: 25 )
• STUDY ( type: esriFieldTypeString, alias: Study, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• MAIDSROOM ( type: esriFieldTypeString, alias: MaidsRoom, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• UNITMODEL ( type: esriFieldTypeString, alias: UnitModel, length: 25 )
• UNITCATEGORY ( type: esriFieldTypeString, alias: UnitCategory, length: 25 , Coded Values: [0: Villa] , [2: Apartment] , [3: Boutique Villa] , ...6 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [0: Available] , [1: Sold] , [2: Blocked] , ...1 more... )
• CUSTOMERNAME ( type: esriFieldTypeString, alias: CustomerName, length: 250 )
• CUSTOMERCONTACTNUMBER ( type: esriFieldTypeDouble, alias: CustomerContactNumber )
• CUSTOMEREMAIL ( type: esriFieldTypeString, alias: CustomerEmail, length: 250 )
• SALEVALUE ( type: esriFieldTypeDouble, alias: SaleValue )
• SALEDATE ( type: esriFieldTypeDate, alias: SaleDate, length: 8 )
• UPDATED ( type: esriFieldTypeString, alias: Updated, length: 10 )
• UPDATEDBY ( type: esriFieldTypeString, alias: UpdatedBy, length: 50 )
• BUILTUPAREA_SQM ( type: esriFieldTypeDouble, alias: BuiltUpArea_SQM )
• PLOTAREA_SQM ( type: esriFieldTypeDouble, alias: PlotArea_SQM )
• BUILTUPAREA_SQFT ( type: esriFieldTypeDouble, alias: BuiltUpArea_SQFT )
• MODELTYPE ( type: esriFieldTypeString, alias: ModelType, length: 50 )
• COMMUNITYNAME ( type: esriFieldTypeString, alias: CommunityName, length: 100 )
• UNIQUEBLDID ( type: esriFieldTypeString, alias: UniqueBldID, length: 250 )
• STUDIO ( type: esriFieldTypeString, alias: STUDIO, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• ADDRESSNUMBER ( type: esriFieldTypeString, alias: Address Number, length: 50 )
• HANDOVER ( type: esriFieldTypeString, alias: HANDOVER, length: 50 )

Relationships:

• MAFP_Buildings2D (1) -- Related To: Buildings (0)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata