Laomahakandmised XML: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
(Uus lehekülg: '{| class="wikitable" !Välja nimi !Välja kirjeldus !Field description !Lenght, type |- |SerNr |Laomahakandmise nr |Serial no | |- | | | | |}')
 
Resümee puudub
6. rida: 6. rida:
|-
|-
|SerNr
|SerNr
|Laomahakandmise nr
|Number
|Serial no
|No.
|0, Value with No Decimals
|-
|TransDate
|Kande kp
|Trans date
|0, In Dataformat Order
|-
|CostAcc
|Kulukonto
|Cost A/C
|10, Code String
|-
|OKFlag
|Kinnita
|OK
|0, As Bool but displayed as a Checkbox
|-
|Location
|Ladu
|Location
|10, Code String
|-
|PRCode
|Projekt
|Project
|20, Code String
|-
|Comment
|Kommentaar
|Cimment
|60, String
|-
|Objects
|Objektid
|Objects
|60, Capital Characters Only
|-
|ExportedFlag
|Eksporditud
|Exported
|0, Small Value with No Decimals
|-
|TotQty
|Kogus kokku
|Tot. Qty
|0, Value with minimum Decimals
|-
|LocOKNr
|Asukoha kin. nr
|Location OK nr
|0, Value with minimum Decimals
|-
|IntORNo
|Sisetellimuse nr
|Internal order no
|0, Value with No Decimals
|-
|SDClass
|Klass
|Class
|10, Code String
|-
|ACShort
|Lühikood
|Short code
|5, Code String
|-
|RefStr
|Viide
|Reference
|60, String
|-
|Invalid
|Suletud
|Closed
|0, Small Value with No Decimals
|-
|InvalidDate
|Suletud kuupäev
|Closed date
|0, In Dataformat Order
|-
|Reason
|Põhjus
|Reason
|20, Code String
|-
|AcceptanceStatus
|Kinnituse hetkeseis
|Appr. status
|0, Small Value with No Decimals
|-
|AcceptanceBy
|Kinnitaja
|Appr. by
|200, Comma separated List
|-
|AcceptanceFYI
|Infoks
|FYI
|200, Comma separated List
|-
|Sign
|Koostaja
|Sign
|10, Code String
|-
|SalesGroup
|Müügigupp
|Sales group
|5, Code String
|-
| colspan="4" |'''MAATRIKS'''
|-
|ArtCode
|
|
|20, Code String
|-
|Spec
|
|
|100, String
|-
|SerialNr
|
|
|60, String
|-
|Qty
|
|
|0, Value with minimum Decimals
|-
|FIFO
|
|
|0, Value with All Decimals
|-
|Location
|
|
|10, Code String
|-
|Recepy
|
|
|20, Code String
|-
|VARList
|
|
|30, Capital Characters Only
|-
|Objects
|
|
|60, Capital Characters Only
|-
|CostAcc
|
|
|10, Code String
|-
|FIFORowVal
|
|
|0, Value with All Decimals
|-
|Coefficient
|
|
|0, Value with All Decimals
|-
|BasePrice
|
|
|0, Value with 2 or 3 Decimals
|-
|IntORRow
|
|
|0, Value with No Decimals
|-
|UnitXval
|
|
|0, Value with minimum Decimals
|-
|UnitYval
|
|
|0, Value with minimum Decimals
|-
|UnitZval
|
|
|0, Value with minimum Decimals
|-
|PRCodeRow
|
|
|20, Code String
|-
|PosCode
|
|
|20, Code String
|-
|ACShort
|
|
|
|5, Code String
|-
|-
|
|
15. rida: 227. rida:
|
|
|}
|}
<syntaxhighlight lang="xml">
<?xml version='1.0' encoding='UTF-8' standalone='yes'?>
<data  register="SDVc" sequence="4742528" systemversion="8.5.33.321">
    <SDVc>
        <SerNr>1019</SerNr>
        <Math></Math>
        <TransDate>2020-01-21</TransDate>
        <CostAcc>1026</CostAcc>
        <OKFlag>0</OKFlag>
        <Location>PL</Location>
        <PRCode></PRCode>
        <Comment></Comment>
        <Objects>10010,ABIVAHEND,ANNIKA</Objects>
        <ExportedFlag>0</ExportedFlag>
        <TotQty>12</TotQty>
        <LocOKNr></LocOKNr>
        <IntORNo></IntORNo>
        <SDClass>DONE</SDClass>
        <ACShort>LK</ACShort>
        <RefStr>1212</RefStr>
        <Invalid>0</Invalid>
        <InvalidDate></InvalidDate>
        <Reason>KP</Reason>
        <AcceptanceStatus>0</AcceptanceStatus>
        <AcceptanceBy></AcceptanceBy>
        <AcceptanceFYI></AcceptanceFYI>
        <Sign>KAUPO</Sign>
        <SalesGroup></SalesGroup>
        <rows>
            <row rownumber="0">
                <ArtCode>001</ArtCode>
                <Spec>Minu Esimene Excelis asuv Artikkel</Spec>
                <SerialNr></SerialNr>
                <Qty>12</Qty>
                <FIFO>212.00</FIFO>
                <Location></Location>
                <Recepy></Recepy>
                <VARList></VARList>
                <Objects></Objects>
                <CostAcc>1025</CostAcc>
                <FIFORowVal>2544.00</FIFORowVal>
                <Coefficient></Coefficient>
                <BasePrice>19.90</BasePrice>
                <IntORRow></IntORRow>
                <UnitXval></UnitXval>
                <UnitYval></UnitYval>
                <UnitZval></UnitZval>
                <PRCodeRow></PRCodeRow>
                <PosCode></PosCode>
                <ACShort></ACShort>
            </row>
        </rows>
    </SDVc>
</data>
</syntaxhighlight>

Redaktsioon: 21. jaanuar 2020, kell 11:42

Välja nimi Välja kirjeldus Field description Lenght, type
SerNr Number No. 0, Value with No Decimals
TransDate Kande kp Trans date 0, In Dataformat Order
CostAcc Kulukonto Cost A/C 10, Code String
OKFlag Kinnita OK 0, As Bool but displayed as a Checkbox
Location Ladu Location 10, Code String
PRCode Projekt Project 20, Code String
Comment Kommentaar Cimment 60, String
Objects Objektid Objects 60, Capital Characters Only
ExportedFlag Eksporditud Exported 0, Small Value with No Decimals
TotQty Kogus kokku Tot. Qty 0, Value with minimum Decimals
LocOKNr Asukoha kin. nr Location OK nr 0, Value with minimum Decimals
IntORNo Sisetellimuse nr Internal order no 0, Value with No Decimals
SDClass Klass Class 10, Code String
ACShort Lühikood Short code 5, Code String
RefStr Viide Reference 60, String
Invalid Suletud Closed 0, Small Value with No Decimals
InvalidDate Suletud kuupäev Closed date 0, In Dataformat Order
Reason Põhjus Reason 20, Code String
AcceptanceStatus Kinnituse hetkeseis Appr. status 0, Small Value with No Decimals
AcceptanceBy Kinnitaja Appr. by 200, Comma separated List
AcceptanceFYI Infoks FYI 200, Comma separated List
Sign Koostaja Sign 10, Code String
SalesGroup Müügigupp Sales group 5, Code String
MAATRIKS
ArtCode 20, Code String
Spec 100, String
SerialNr 60, String
Qty 0, Value with minimum Decimals
FIFO 0, Value with All Decimals
Location 10, Code String
Recepy 20, Code String
VARList 30, Capital Characters Only
Objects 60, Capital Characters Only
CostAcc 10, Code String
FIFORowVal 0, Value with All Decimals
Coefficient 0, Value with All Decimals
BasePrice 0, Value with 2 or 3 Decimals
IntORRow 0, Value with No Decimals
UnitXval 0, Value with minimum Decimals
UnitYval 0, Value with minimum Decimals
UnitZval 0, Value with minimum Decimals
PRCodeRow 20, Code String
PosCode 20, Code String
ACShort 5, Code String 
<?xml version='1.0' encoding='UTF-8' standalone='yes'?>
<data  register="SDVc" sequence="4742528" systemversion="8.5.33.321">
    <SDVc>
        <SerNr>1019</SerNr>
        <Math></Math>
        <TransDate>2020-01-21</TransDate>
        <CostAcc>1026</CostAcc>
        <OKFlag>0</OKFlag>
        <Location>PL</Location>
        <PRCode></PRCode>
        <Comment></Comment>
        <Objects>10010,ABIVAHEND,ANNIKA</Objects>
        <ExportedFlag>0</ExportedFlag>
        <TotQty>12</TotQty>
        <LocOKNr></LocOKNr>
        <IntORNo></IntORNo>
        <SDClass>DONE</SDClass>
        <ACShort>LK</ACShort>
        <RefStr>1212</RefStr>
        <Invalid>0</Invalid>
        <InvalidDate></InvalidDate>
        <Reason>KP</Reason>
        <AcceptanceStatus>0</AcceptanceStatus>
        <AcceptanceBy></AcceptanceBy>
        <AcceptanceFYI></AcceptanceFYI>
        <Sign>KAUPO</Sign>
        <SalesGroup></SalesGroup>
        <rows>
            <row rownumber="0">
                <ArtCode>001</ArtCode>
                <Spec>Minu Esimene Excelis asuv Artikkel</Spec>
                <SerialNr></SerialNr>
                <Qty>12</Qty>
                <FIFO>212.00</FIFO>
                <Location></Location>
                <Recepy></Recepy>
                <VARList></VARList>
                <Objects></Objects>
                <CostAcc>1025</CostAcc>
                <FIFORowVal>2544.00</FIFORowVal>
                <Coefficient></Coefficient>
                <BasePrice>19.90</BasePrice>
                <IntORRow></IntORRow>
                <UnitXval></UnitXval>
                <UnitYval></UnitYval>
                <UnitZval></UnitZval>
                <PRCodeRow></PRCodeRow>
                <PosCode></PosCode>
                <ACShort></ACShort>
            </row>
        </rows>
    </SDVc>
</data>
Pärit leheküljelt "https://kaust.excellent.ee/opendoc/index.php?title=Laomahakandmised_XML&oldid=1033"