Hausing - Register Kanded: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
(kannete sisu kirjeldus)
(lisatud kannete eestikeelne kirjeldus)
5. rida: 5. rida:
!Field Name
!Field Name
!Description
!Description
!Kirjeldus
!Field type
!Field type
!Max length
!Max length
|-
|-
|Number
|Number
|Value with No Decimals
|Value with No Decimals,
|Kande number
|M4Long
|M4Long
|0
|0
15. rida: 17. rida:
|RegDate
|RegDate
|In Dataformat Order
|In Dataformat Order
|Salvestamise kuupäev
|M4Date
|M4Date
|0
|0
20. rida: 23. rida:
|Comment
|Comment
|String
|String
|Selgitus
|M4Str
|M4Str
|60
|60
25. rida: 29. rida:
|TransDate
|TransDate
|In Dataformat Order
|In Dataformat Order
|Kande kuupäev
|M4Date
|M4Date
|0
|0
30. rida: 35. rida:
|Sign
|Sign
|Code String
|Code String
|Koostanud isik
|M4Code
|M4Code
|10
|10
35. rida: 41. rida:
|DSum
|DSum
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|Deebet Summa
|M4Val
|M4Val
|0
|0
40. rida: 47. rida:
|CSum
|CSum
|Negative Value
|Negative Value
|Kreedit Summa
|M4NegVal
|M4NegVal
|0
|0
45. rida: 53. rida:
|DiffVal
|DiffVal
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|deebeti ja kreediti vahe
|M4Val
|M4Val
|0
|0
50. rida: 59. rida:
|RefStr
|RefStr
|String
|String
|viide
|M4Str
|M4Str
|60
|60
55. rida: 65. rida:
|xMainf
|xMainf
|Small Value with No Decimals
|Small Value with No Decimals
|n/a
|M4Int
|M4Int
|0
|0
60. rida: 71. rida:
|IntYc
|IntYc
|Small Value with No Decimals
|Small Value with No Decimals
|arvestusaasta kood
|M4Int
|M4Int
|0
|0
65. rida: 77. rida:
|xBalf
|xBalf
|Small Value with No Decimals
|Small Value with No Decimals
|n/a
|M4Int
|M4Int
|0
|0
70. rida: 83. rida:
|Expf
|Expf
|Small Value with No Decimals
|Small Value with No Decimals
|
|M4Int
|M4Int
|0
|0
75. rida: 89. rida:
|ExportedFlag
|ExportedFlag
|Small Value with No Decimals
|Small Value with No Decimals
|kas on eksporditud jah/ei
|M4Int
|M4Int
|0
|0
80. rida: 95. rida:
|DSum2
|DSum2
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|deebet summa valuutas 2
|M4Val
|M4Val
|0
|0
85. rida: 101. rida:
|CSum2
|CSum2
|Negative Value
|Negative Value
|kreedit summa valuutas2
|M4NegVal
|M4NegVal
|0
|0
90. rida: 107. rida:
|Diff2Val
|Diff2Val
|Value 2 or 3 Decimals
|Value 2 or 3 Decimals
|vahe valuutas 2
|M4Val
|M4Val
|0
|0
95. rida: 113. rida:
|LastChangeDate
|LastChangeDate
|In Dataformat Order
|In Dataformat Order
|viimati muudetud kuupäev
|M4Date
|M4Date
|0
|0
100. rida: 119. rida:
|FileName
|FileName
|String
|String
|n/a
|M4Str
|M4Str
|20
|20
105. rida: 125. rida:
|TransNr
|TransNr
|Value with No Decimals
|Value with No Decimals
|n/a
|M4Long
|M4Long
|0
|0
110. rida: 131. rida:
|SeqNr
|SeqNr
|Value with No Decimals
|Value with No Decimals
|n/a
|M4Long
|M4Long
|0
|0
115. rida: 137. rida:
|RegTime
|RegTime
|Hour:Min:Secs
|Hour:Min:Secs
|salvestamise kellaaeg
|M4Time
|M4Time
|0
|0

Redaktsioon: 3. august 2018, kell 10:04

Hausing - Pealeht

Kohustuslikud väljad

Field Name Description Kirjeldus Field type Max length
Number Value with No Decimals, Kande number M4Long 0
RegDate In Dataformat Order Salvestamise kuupäev M4Date 0
Comment String Selgitus M4Str 60
TransDate In Dataformat Order Kande kuupäev M4Date 0
Sign Code String Koostanud isik M4Code 10
DSum Value 2 or 3 Decimals Deebet Summa M4Val 0
CSum Negative Value Kreedit Summa M4NegVal 0
DiffVal Value 2 or 3 Decimals deebeti ja kreediti vahe M4Val 0
RefStr String viide M4Str 60
xMainf Small Value with No Decimals n/a M4Int 0
IntYc Small Value with No Decimals arvestusaasta kood M4Int 0
xBalf Small Value with No Decimals n/a M4Int 0
Expf Small Value with No Decimals M4Int 0
ExportedFlag Small Value with No Decimals kas on eksporditud jah/ei M4Int 0
DSum2 Value 2 or 3 Decimals deebet summa valuutas 2 M4Val 0
CSum2 Negative Value kreedit summa valuutas2 M4NegVal 0
Diff2Val Value 2 or 3 Decimals vahe valuutas 2 M4Val 0
LastChangeDate In Dataformat Order viimati muudetud kuupäev M4Date 0
FileName String n/a M4Str 20
TransNr Value with No Decimals n/a M4Long 0
SeqNr Value with No Decimals n/a M4Long 0
RegTime Hour:Min:Secs salvestamise kellaaeg M4Time 0

Minimaalse XML päringu näide

Kõigi XML väljade kirjeldused

Näidis XML päring