Database Table "hyp_Price Index Linkage Definition"

Table Description

List of indices used by the company.

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes json
Index ID Integer 0 Edit Read Only
Key Field		 IndexID
Country String 40 SelectEdit Mandatory Country
Index Title String 50 Edit Mandatory IndexTitle
Manual Bool 0 Select Manual
Jump to tables index

Database Table "SYE Price Index Linkage Rates"

Table Description

List of rates of each index

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes json
SYE Index Code Integer 0 Edit Hidden
Read Only
Key Field		 SYEIndexCode
Publish Date Date 0 SelectEdit Mandatory
Key Field		 PublishDate
Rate Real 0 Edit Mandatory Rate
Change % Money 0 Edit Change
For Month Month 0 SelectEdit ForMonth
Jump to tables index

Database Table "SYE Price Index Linkage API"

Table Description

Table of indexes stored on SYE server and can be imported automatically

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes json
SYE Index Code Integer 0 Edit Read Only
Key Field		 SYEIndexCode
Country String 40 SelectEdit Mandatory Country
Index Title String 50 Edit Mandatory IndexTitle
API Code Int Integer 0 Edit Mandatory /G:1 APICodeInt
API Code Str String 50 Edit Mandatory /G:1 APICodeStr
Last Sync Date 0 SelectEdit Read Only LastSync
Last Data Date 0 SelectEdit Read Only LastData
Jump to tables index