Pakkumised kirjeldus

Allikas: Excellent || Opendoc
Redaktsioon seisuga 1. juuni 2023, kell 10:12 kasutajalt Kaupo (arutelu | kaastöö)
Mine navigeerimisribale Mine otsikasti
  • Registri nimi eesti keeles: Pakkumised
  • Register name in English: Quotations
  • funktsioon API päringus: /api/1/QTVc

Väljade kirjeldus

Välja kood Kirjeldus Description Tüüp, pikkus (Type, lenght)
SerNr Nr No Value with No Decimals, 0
QTDate Kuupäev In Dataformat Order, 0
CustCode Klient Code String, 20
Addr0 Nimi String, 60
Addr1 Tänav/Maja String, 60
Addr2 Küla/Linnaosa String, 60
Addr3 Linn/Vald String, 60
OurContact Meie Esindaja String, 20
CustContact Nende Esindaja String, 60
ExportFlag Käibemaksutsoon Small Value with No Decimals, 0
PayDeal Tasumistingimus Code String, 2
CustCat Kliendi klass Code String, 5
Objects Objektid Capital Characters Only, 60
ShipMode Lähtusviis Code String, 5
PlanShip Planeeritud lähetuse kuupäev String, 10
SalesMan Müügimees Capital Characters Only, 60
Sign Pakkumise koostaja Code String, 10
ShipDeal Lähetustingimus Code String, 5
ShipAddr0 Lähetusaadress 1 String, 60
ShipAddr1 Lähetusaadress 2 String, 60
ShipAddr2 Lähetusaadress 3 String, 60
ShipAddr3 Lähetusaadress 4 String, 60
CurncyCode Valuuta Code String, 5
LangCode Keel Code String, 5
InvoiceToCode Arve Saaja Code String, 20
ToRateB1 Value with 6 Decimals, 0
Closed Suletud Small Value with No Decimals, 0
BuildOn Small Value with No Decimals, 0
PRCode Projekti kood Code String, 20
Comment Kommentaar String, 100
OrderNr Tellimuse nr Value with No Decimals, 0
ValidUntilDate Kehtiv kuni String, 20
InvOnlyOnFull Ära luba arveldada rohkem kui pakutud Small Value with No Decimals, 0
PriceList Hinnakiri Code String, 20
InclVAT Hinnad koos KMiga Small Value with No Decimals, 0
Sum0 Value 2 or 3 Decimals, 0
Sum1 Vahesumma Value 2 or 3 Decimals, 0
Sum2 Value 2 or 3 Decimals, 0
Sum3 KM summa Value 2 or 3 Decimals, 0
Sum4 KOKKU Value 2 or 3 Decimals, 0
QuoteClass Pakkumise klass Code String, 5
CustVATCode Kliendi KM kood Code String, 10
RebCode Hinnaalandusmaatriksi kood Code String, 5
VATNr KMKR number String, 20
Phone Telefon String with phone-number, 20
Fax Faks String, 20
MakeContactDate Võta Ühendust String, 20
BaseSum4 KOKKU baasvaluutas Value 2 or 3 Decimals, 0
FrRate Kurss Value with 6 Decimals, 0
ToRateB2 Baasvaluuta 1 Value with 6 Decimals, 0
BaseRate1 Baasvaluuta 1 Value with 6 Decimals, 0
BaseRate2 Baasvaluuta 2 Value with 6 Decimals, 0
DiscPerc Allahindluse protsent (peidetud väli päises) Value with minimum Decimals, 0
DiscSum Allahindluse summa (peidetud väli päises) Value 2 or 3 Decimals, 0
TotGP Müügikate kokku Value 2 or 3 Decimals, 0
DaysToDelivery Päevi tarnimiseks Value with No Decimals, 0
Probability Tõenäosus Value with One Decimal, 0
GPProc Müügikatte protsent Value with One Decimal, 0
SalesGroup Müügigrupp Capital Characters Only, 30
Sorting Teekond String, 20
Location Ladu Code String, 10
TotQty Kogus kokku Value with minimum Decimals, 0
TotWeight Kaal kokku Value with minimum Decimals, 0
TotVolume Maht kokku Value with minimum Decimals, 0
FrPrice Transport Value 2 or 3 Decimals, 0
FrBase Transpordi baashind Value 2 or 3 Decimals, 0
FrItem Transpordi artikkel Code String, 20
FrVATCode Transpordi KM kood Code String, 10
FrObjects Transpordi objekt Capital Characters Only, 60
InvAddr3 Arve aadress rida 4 String, 60
InvAddr4 Arve aadress rida 5 String, 60
DelAddr3 Lähetusaadress rida 4 String, 60
DelAddr4 Lähetusaadress rida 5 String, 60
DelAddrCode Lähetusaadressi kood Code String, 20
Rejected Tagasi lükatud Small Value with No Decimals, 0
RejectDate Tagasilükkamise kuupäev In Dataformat Order, 0
Markup Juurdehindlus , 10
BudTime Aeg Arvel: Tegelik / Nagu pakutud Small Value with No Decimals, 0
SumTime Kokku aeg Value 2 or 3 Decimals, 0
BudOther Ostud Arvel: Tegelik / Nagu pakutud Small Value with No Decimals, 0
SumOther Kokku ostud Value 2 or 3 Decimals, 0
BudStocked Laoartiklid Arvel: Tegelik / Nagu pakutud Small Value with No Decimals, 0
SumStocked Kokku laoartiklid Value 2 or 3 Decimals, 0
BudMaterial Materjal Arvel: Tegelik / Nagu pakutud Small Value with No Decimals, 0
SumMaterial Kokku materjal Value 2 or 3 Decimals, 0
TAX1Sum Maksud kokku baasvaluutas 1 Value 2 or 3 Decimals, 0
AcceptDate Akstepteeritud kp In Dataformat Order, 0
Priority Tähtsus Value with No Decimals, 0
PlanShipDate Planeeritud lähetus In Dataformat Order, 0
Region Regioon Code String, 20
RefStr Viide String, 60
TAX2Sum Maksu summa baasvaluutas 2 Value 2 or 3 Decimals, 0
NoTax1 Ilma lisamaksuta summa, baasvaluutas 1 Small Value with No Decimals, 0
NoTax2 Ilma lisamaksuta summa, baasvaluutas 2 Small Value with No Decimals, 0
BranchID Filiaal Code String, 20
NoTAXonVAT Value with No Decimals, 0
TotalwoTAX Small Value with No Decimals, 0
OrgCust Code String, 20
AcceptanceStatus Small Value with No Decimals, 0
CustTaxTemplateCode Code String, 10
InvCountry Code String, 5
DelCountry Code String, 5
AcceptanceBy Comma separated List, 200
DisallowInvoicemorethanQuoted Small Value with No Decimals, 0
ProformaOfficialSerNr String, 100
Hash String, 255
HashKeyVersion Small Value with No Decimals, 0
RegDate In Dataformat Order, 0
RegTime Hour:Min:Secs, 0
LocalMachineCode Code String, 20
AcceptanceFYI Comma separated List, 200
BankCode Code String, 10
SVOSerNr Value with No Decimals, 0
Comment2 String, 100
Comment3 String, 100
Comment4 String, 100
InvCountryName String, 100
DelCountryName String, 100
ProformaOfficialSerNrSerie String, 30
RecipientGLN String, 20
DelRecipientGLN String, 20
IntrastatTransCode Code String, 20
ContractStartDate In Dataformat Order, 0
OYNr Value with No Decimals, 0
OYDescription String, 200
RvrsVAT Value 2 or 3 Decimals, 0
PromotionCodes Comma separated List, 200
AccountDimension String, 255
TenderReference String, 255
ContractNr String, 255
ProcessOrigin Int represented by a Set of String, 700
AvalaraCityCode String, 15
AvalaraCountryCode String, 15
AvalaraStateCode String, 15
DelAvalaraCityCode String, 15
DelAvalaraCountryCode String, 15
DelAvalaraStateCode String, 15
DelPhone String, 255
DelEmail String, 255
WithholdingMode Internal Set of Strings, 701
WithholdingTax Value 2 or 3 Decimals, 0
SpecSituation Internal Set of Strings, 703
AdminProcessNo String, 30
PubHighwayServ Small Value with No Decimals, 0
AddedTax Value 2 or 3 Decimals, 0
SubstractedTax Value 2 or 3 Decimals, 0
,
stp Small Value with No Decimals, 0
ArtCode Code String, 20
Quant Value with minimum Decimals, 0
Price Value with 2 or 3 Decimals, 0
Sum Value 2 or 3 Decimals, 0
vRebate Value with One Decimal, 0
SalesAcc Code String, 10
Objects Capital Characters Only, 60
BasePrice Value 2 or 3 Decimals, 0
rowGP Value 2 or 3 Decimals, 0
VATCode Code String, 10
PlanShip String, 10
SerialNr String, 60
PriceFactor Value with All Decimals, 0
Spec String, 100
VARList Capital Characters Only, 30
Recepy Code String, 20
UnitCode Code String, 5
UnitFactQuant Value with minimum Decimals, 0
UnitFactPrice Value with 2 or 3 Decimals, 0
UnitXval Value with minimum Decimals, 0
UnitYval Value with minimum Decimals, 0
UnitZval Value with minimum Decimals, 0
VECode Code String, 20
EMCode Code String, 10
Markup , 10
TimeClass Code String, 5
InvAfter In Dataformat Order, 0
Invoiced Value with No Decimals, 0
InvDate In Dataformat Order, 0
ItemType Small Value with No Decimals, 0
RowType Int represented by a Set of String, 12
BudType Int represented by a Set of String, 13
JobGroup Code String, 5
TAX2Code Code String, 5
TAX2Prc Value with 2 or 3 Decimals, 0
TAX2Reb Value 2 or 3 Decimals, 0
TAX1Reb Value 2 or 3 Decimals, 0
TAX2Acc Code String, 10
PRStage Code String, 10
TaxTemplateCode Capital Characters Only, 60
TaxMatrix Packed Matrix, base64 data, 0
VATCode Code String, 10
VATSum Value with All Decimals, 0
VATRate Value with 2 or 3 Decimals, 0
BaseSum Value 2 or 3 Decimals, 0
CalcBase Int represented by a Set of String, 453
TaxDesc String, 255
Jurisdiction String, 255
TaxType Internal Set of Strings, 719
TaxImpact Int represented by a Set of String, 721
Region Code String, 20
Perceptions Small Value with No Decimals, 0
MotherArtCode Code String, 20
RecipeQuant Value with minimum Decimals, 0
Invd Value with minimum Decimals, 0
CustArtCode Code String, 20
Salesmen Capital Characters Only, 60
UnitComment String, 200
DiscApprovedBy Code String, 10
ServiceDelDate In Dataformat Order, 0
RvrsVATCode Code String, 10
OtherCost Value 2 or 3 Decimals, 0
FreightCost Value 2 or 3 Decimals, 0
Insurance Value 2 or 3 Decimals, 0
UntaxedOtherCost Value 2 or 3 Decimals, 0

Kaart

Pakkumise kaart.png