Pakkumised kirjeldus
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 |