Laomahakandmised XML: erinevus redaktsioonide vahel

Allikas: Excellent || Opendoc
Mine navigeerimisribale Mine otsikasti
Resümee puudub
Resümee puudub
 
8. rida: 8. rida:
|Number
|Number
|No.
|No.
|0, Value with No Decimals
|''0, Value with No Decimals''
|-
|-
|TransDate
|TransDate
|Kande kp
|Kande kp
|Trans date
|Trans date
|0, In Dataformat Order
|''0, In Dataformat Order''
|-
|-
|CostAcc
|CostAcc
|Kulukonto
|Kulukonto
|Cost A/C
|Cost A/C
|10, Code String
|''10, Code String''
|-
|-
|OKFlag
|OKFlag
|Kinnita
|Kinnita
|OK
|OK
|0, As Bool but displayed as a Checkbox
|''0, As Bool but displayed as a Checkbox''
|-
|-
|Location
|Location
|Ladu
|Ladu
|Location
|Location
|10, Code String
|''10, Code String''
|-
|-
|PRCode
|PRCode
|Projekt
|Projekt
|Project
|Project
|20, Code String
|''20, Code String''
|-
|-
|Comment
|Comment
|Kommentaar
|Kommentaar
|Cimment
|Cimment
|60, String
|''60, String''
|-
|-
|Objects
|Objects
|Objektid
|Objektid
|Objects
|Objects
|60, Capital Characters Only
|''60, Capital Characters Only''
|-
|-
|ExportedFlag
|ExportedFlag
|Eksporditud
|Eksporditud
|Exported
|Exported
|0, Small Value with No Decimals
|''0, Small Value with No Decimals''
|-
|-
|TotQty
|TotQty
|Kogus kokku
|Kogus kokku
|Tot. Qty
|Tot. Qty
|0, Value with minimum Decimals
|''0, Value with minimum Decimals''
|-
|-
|LocOKNr
|LocOKNr
|Asukoha kin. nr
|Asukoha kin. nr
|Location OK nr
|Position OK nr
|0, Value with minimum Decimals
|''0, Value with minimum Decimals''
|-
|-
|IntORNo
|IntORNo
|Sisetellimuse nr
|Sisetellimuse nr
|Internal order no
|Internal order no
|0, Value with No Decimals
|''0, Value with No Decimals''
|-
|-
|SDClass
|SDClass
|Klass
|Klass
|Class
|Class
|10, Code String
|''10, Code String''
|-
|-
|ACShort
|ACShort
|Lühikood
|Lühikood
|Short code
|Short code
|5, Code String
|''5, Code String''
|-
|-
|RefStr
|RefStr
|Viide
|Viide
|Reference
|Reference
|60, String
|''60, String''
|-
|-
|Invalid
|Invalid
|Suletud
|Suletud
|Closed
|Closed
|0, Small Value with No Decimals
|''0, Small Value with No Decimals''
|-
|-
|InvalidDate
|InvalidDate
|Suletud kuupäev
|Suletud kuupäev
|Closed date
|Closed date
|0, In Dataformat Order
|''0, In Dataformat Order''
|-
|-
|Reason
|Reason
|Põhjus
|Põhjus
|Reason
|Reason
|20, Code String
|''20, Code String''
|-
|-
|AcceptanceStatus
|AcceptanceStatus
|Kinnituse hetkeseis
|Kinnituse hetkeseis
|Appr. status
|Appr. status
|0, Small Value with No Decimals
|''0, Small Value with No Decimals''
|-
|-
|AcceptanceBy
|AcceptanceBy
|Kinnitaja
|Kinnitaja
|Appr. by
|Appr. by
|200, Comma separated List
|''200, Comma separated List''
|-
|-
|AcceptanceFYI
|AcceptanceFYI
|Infoks
|Infoks
|FYI
|FYI
|200, Comma separated List
|''200, Comma separated List''
|-
|-
|Sign
|Sign
|Koostaja
|Koostaja
|Sign
|Sign
|10, Code String
|''10, Code String''
|-
|-
|SalesGroup
|SalesGroup
|Müügigupp
|Müügigupp
|Sales group
|Sales group
|5, Code String
|''5, Code String''
|-
|-
| colspan="4" |'''MAATRIKS'''
| colspan="4" |'''MAATRIKS'''
|-
|-
|ArtCode
|ArtCode
|
|Artikkel
|
|Item
|20, Code String
|''20, Code String''
|-
|-
|Spec
|Spec
|
|Kirjeldis
|
|Description
|100, String
|''100, String''
|-
|-
|SerialNr
|SerialNr
|
|Seerianumber
|
|Serial No
|60, String
|''60, String''
|-
|-
|Qty
|Qty
|
|Kogus
|
|Qty
|0, Value with minimum Decimals
|''0, Value with minimum Decimals''
|-
|-
|FIFO
|FIFO
|
|FIFO
|
|FIFO
|0, Value with All Decimals
|''0, Value with All Decimals''
|-
|-
|Location
|Location
|
|Ladu
|
|Location
|10, Code String
|''10, Code String''
|-
|-
|Recepy
|Recepy
|
|Retsept
|
|Recipe
|20, Code String
|''20, Code String''
|-
|-
|VARList
|VARList
|
|N/A
|
|N/A
|30, Capital Characters Only
|''30, Capital Characters Only''
|-
|-
|Objects
|Objects
|
|Objektid
|
|Tags/Objects
|60, Capital Characters Only
|''60, Capital Characters Only''
|-
|-
|CostAcc
|CostAcc
|
|Kulukonto
|
|Cost A/C
|10, Code String
|''10, Code String''
|-
|-
|FIFORowVal
|FIFORowVal
|
|Rea FIFO
|
|Row FIFO
|0, Value with All Decimals
|''0, Value with All Decimals''
|-
|-
|Coefficient
|Coefficient
|
|Koef
|
|Coeff
|0, Value with All Decimals
|''0, Value with All Decimals''
|-
|-
|BasePrice
|BasePrice
|
|Baashind
|
|Base Price
|0, Value with 2 or 3 Decimals
|''0, Value with 2 or 3 Decimals''
|-
|-
|IntORRow
|IntORRow
|
|Sisetellimuse rea nr
|
|Internal order row no
|0, Value with No Decimals
|''0, Value with No Decimals''
|-
|-
|UnitXval
|UnitXval
|
|Laius
|
|Width
|0, Value with minimum Decimals
|''0, Value with minimum Decimals''
|-
|-
|UnitYval
|UnitYval
|
|Kürgus
|
|Height
|0, Value with minimum Decimals
|''0, Value with minimum Decimals''
|-
|-
|UnitZval
|UnitZval
|
|Sügavus
|
|Depth
|0, Value with minimum Decimals
|''0, Value with minimum Decimals''
|-
|-
|PRCodeRow
|PRCodeRow
|
|Projekt
|
|Project
|20, Code String
|''20, Code String''
|-
|-
|PosCode
|PosCode
|
|Asukoha kood
|
|Position code
|20, Code String
|''20, Code String''
|-
|-
|ACShort
|ACShort
|
|Lühikood
|
|Short code
|5, Code String
|''5, Code String''
|-
|
|
|
|
|}
|}
<syntaxhighlight lang="xml">
<syntaxhighlight lang="xml">

Viimane redaktsioon: 21. jaanuar 2020, kell 11:52

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 Position 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 Artikkel Item 20, Code String
Spec Kirjeldis Description 100, String
SerialNr Seerianumber Serial No 60, String
Qty Kogus Qty 0, Value with minimum Decimals
FIFO FIFO FIFO 0, Value with All Decimals
Location Ladu Location 10, Code String
Recepy Retsept Recipe 20, Code String
VARList N/A N/A 30, Capital Characters Only
Objects Objektid Tags/Objects 60, Capital Characters Only
CostAcc Kulukonto Cost A/C 10, Code String
FIFORowVal Rea FIFO Row FIFO 0, Value with All Decimals
Coefficient Koef Coeff 0, Value with All Decimals
BasePrice Baashind Base Price 0, Value with 2 or 3 Decimals
IntORRow Sisetellimuse rea nr Internal order row no 0, Value with No Decimals
UnitXval Laius Width 0, Value with minimum Decimals
UnitYval Kürgus Height 0, Value with minimum Decimals
UnitZval Sügavus Depth 0, Value with minimum Decimals
PRCodeRow Projekt Project 20, Code String
PosCode Asukoha kood Position code 20, Code String
ACShort Lühikood Short code 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=1034"