Manuale Kimo
  • Piacere, sono Kimo
  • Introduzione
    • Finalità di Kimo
    • Moduli e App
      • Kimo SFA
      • Kimo B2B
      • Console di Amministrazione
    • Architettura
  • Installazione
    • Requisiti minimi di sistema
    • Check-list per il deploy
    • Installare Kimo SFA su iPad
    • Installare Kimo B2B su device
    • Tool accessori
      • SyncThing
  • Impostazioni
    • Utenti
      • Ricercare utenti
      • Creare un utente per SFA
        • Modificare codice Agente associato all'utente
      • Console di Amministrazione: Creare un utente per B2B
      • Web App: Creare un utente per B2B
      • API: Creare un utente per B2B
      • Creare un utente di tipo Direzionale
      • Cambiare codice agente per un utente di Kimo
      • Attivare un utente
      • Riattivare un utente
      • Criteri di definizione delle password
      • Reset della password
      • Cancellare e ripristinare un utente
      • Eliminare un profilo utente dall'App SFA
      • Impersonificare un utente
    • Ruoli e autorizzazioni
    • Business Rules
      • Account
      • Activity
      • Api
      • B2b\Account
      • B2b
      • B2b\Cart
      • B2b\Document
      • B2b\ErpDocument
      • B2b\Help
      • B2b\Item
      • B2b\Password
      • B2b\Price
      • B2b\Promotion
      • B2b\QuantitySelector
      • B2b\UserProfile
      • Barcode
      • Budgets
      • Cart
      • Communication
      • CompanyNews
      • Contact
      • Crm
      • Custom
      • Discount
      • Document
      • DocumentLine
      • DocumentMail
      • DocumentNotification
      • DocumentSearch
      • DocumentTransformation
      • Elly
      • Entity
      • Erp
      • ErpDocument
      • ErpDocumentLinesReport
      • ErpDocumentMail
      • ErpDocumentType
      • FreeField
      • Fulfillment
      • Idrolab
      • ilDataPool
      • ItemAvailability
      • Item
      • ItemImage
      • ItemPriceListFile
      • ItemUom
      • ManualItem
      • MapAccounts
      • MarketingForm
      • MobileWarehouseAvailability
      • Opportunity
      • Password
      • PendingEdits
      • Pinaxo
      • PointsPerSaleBalance
      • PointsPerSale
      • PowerBI
      • PriceCalculation
      • PricePerCustomerCsvMail
      • Promotion
      • PromotionLine
      • Reassortment
      • ReceivableBook
      • ReceivableBookMail
      • ReceivableInstallment
      • Rma
      • SalesControl
      • SalesControlDocument
      • SalesControlDocumentLine
      • Shipment
      • ShippingCharge
      • SmartBI
      • Sync
      • VariableMatrix
      • Vat
      • WelcomeWizard
    • Impostazioni di sistema
    • Metadati sulle entità
    • Valori di default
    • FreeLookup
    • Stati Erp
    • Import/Export
    • Tipo Report
      • Document Data Model
    • Motore di template (Template Engine)
    • Impostazione chiave Google (Geocoding)
    • Timeframe (periodi temporali)
  • Interfaccia utente
    • SFA
      • Layout
        • Elenco
          • AccountActivitiesTableRow
          • AccountsSearch
          • ActivitiesSearch
          • ActivityEditor
          • ActivityToPlan
          • BankAccountEditor
          • BankAccountsSearch
          • BudgetLineEditor
          • BudgetLinePickerEditor
          • BudgetLinesForAccount
          • BudgetLineTableRow
          • BudgetsDrillDownTableRow
          • CartEditor
          • CartLineTableRowEditor
          • CartsSearch
          • CommunicationsSearch
          • ContactEditor
          • ContactForm
          • ContactsSearch
          • CustomerEditor
          • CustomerForm
          • CustomerScheduledPaymentsTableRow
          • DocumentAlternatives
          • DocumentArchiving
          • DocumentConfirmation
          • DocumentHeaderEditor
          • DocumentLineEditor
          • DocumentLineGroupHeader
          • DocumentLineTableRowEditor
          • DocumentLineVariableEditor
          • DocumentReport
          • DocumentReportRecipient
          • DocumentsSearch
          • ErpDocumentArchiving
          • ErpDocumentHeaderEditor
          • ErpDocumentLineEditor
          • ErpDocumentLinesReport
          • ErpDocumentLineTableRowEditor
          • ErpDocumentLineVariableEditor
          • ErpDocumentsSearch
          • ItemForm
          • ItemLotAvailabilitiesSearch
          • ItemsDrillDownTableRow
          • ItemsSearch
          • ItemWarehouseAvailabilitiesSearch
          • MobileWarehouseAvailabilitiesSearch
          • PromotionActivationByItemHeader
          • PromotionActivationLineTableRow
          • PromotionActivationTableRow
          • PromotionDirectActivationHeader
          • PromotionEditorLineTableRow
          • PromotionInfoHeader
          • PromotionLineEditor
          • PromotionLineSelector
          • Reassortment
          • ReceivableBook
          • ReceivableInstallmentEditor
          • ReceivableInstallmentsMultipleCashEditor
          • ReceivablesBookReport
          • ReceivablesBookReportRecipient
          • SalesConditionForDocumentLineSelector
          • ShipmentSiteEditor
          • Signature
          • SmartBIDrillDownTableRow
      • Scenari
      • Immagine di sfondo su Home Page
      • Immagine personalizzata per login
    • B2B
      • Risorse grafiche per Kimo B2B
  • Integrazione
    • Kimo integrator
      • Integrator System Settings
      • Funzioni di trasformazione "speciali"
    • Database schema
      • Account
      • AccountAccountingInfo
      • AccountBank
      • AccountFilter
      • AccountPerPromotionCustomerGroup
      • Activity
      • ActivityAssignee
      • ActivityType
      • AvailabilityRule
      • AvailabilityRuleParamsPerDocument
      • Bank
      • BankAgency
      • Budget
      • BudgetLine
      • BudgetLineActual
      • BudgetPerSalesAgent
      • BusinessRuleFromErp
      • Carrier
      • CatalogPriceList
      • CompanyRole
      • Contact
      • ContactPerOpportunity
      • Country
      • Currency
      • CustomerDiscountGroup
      • CustomerDiscountGroupTranslation
      • CustomerGroup
      • CustomerGroupTranslation
      • CustomerPriceGroup
      • CustomerPriceGroupTranslation
      • DeliveryDateType
      • DeliveryRoute
      • DiagnosticPriceTestCase
      • DiscountsPerHierarchy
      • DiscountsPerItemGroup
      • DiscountsPerItemSeries
      • Document
      • DocumentArchivingReason
      • DocumentLine
      • EntitySyncReferenceForAccount
      • EntitySyncReferenceForActivity
      • EntitySyncReferenceForBudgetLine
      • EntitySyncReferenceForContact
      • EntitySyncReferenceForEntityGeoposition
      • EntitySyncReferenceForMarketingForm
      • EntitySyncReferenceForOpportunity
      • EntitySyncReferenceForReceivableInstallment
      • EntitySyncReferenceForRma
      • ErpDocument
      • ErpDocumentLine
      • ErpDocumentPerSalesAgent
      • FreeLookup
      • FreeLookupTranslation
      • GoodsAspect
      • IndicatorThreshold
      • InvoiceDiscount
      • InvoiceDiscountParams
      • Item
      • ItemAssociated
      • ItemAttachment
      • ItemCharge
      • ItemChargeType
      • ItemClassification
      • ItemCollection
      • ItemCollectionTranslation
      • ItemCost
      • ItemCrossReference
      • ItemDiscountGroup
      • ItemGender
      • ItemGroup
      • ItemGroupTranslation
      • ItemImage
      • ItemLine
      • ItemLineTranslation
      • ItemListPrice
      • ItemLotOfflineAvailability
      • ItemOfflineAvailability
      • ItemSeries
      • ItemSeriesTranslation
      • ItemSpecificationField
      • ItemSpecificationFieldPerGroup
      • ItemSpecificationFieldTranslation
      • ItemSpecificationFieldValue
      • ItemSpecificationGroup
      • ItemSpecificationGroupTranslation
      • ItemSpecificationItemPerGroup
      • ItemSpecificationValue
      • ItemTranslation
      • ItemUom
      • ItemUrl
      • ItemVariable
      • Language
      • LogisticArea
      • LogisticAreaDeliveryDays
      • Manufacturer
      • ManufacturerImage
      • ManufacturerTranslation
      • MaritalStatus
      • MarketingForm
      • MarketingFormFamily
      • MarketingFormField
      • MarketingFormFieldValue
      • MarketingFormLine
      • MarketingFormType
      • MichelangeloSalesCondition
      • MichelangeloSalesMultiplierCondition
      • NavFashionDocumentDiscounts
      • NavSalesLineDiscount
      • NavSalesPrice
      • NonStockItem
      • NonStockItemUom
      • Opportunity
      • OpportunityLeavingReason
      • OpportunityPhase
      • OpportunityReferralSource
      • PaymentMethod
      • PaymentTerm
      • PaymentType
      • PointsPerSale
      • PointsPerSaleBalance
      • PriceList
      • PricePerQuantityRange
      • PriceRounding
      • Promotion
      • PromotionCustomerGroup
      • PromotionFilter
      • PromotionImage
      • PromotionLine
      • Reassortment
      • ReassortmentLine
      • ReassortmentPerSalesAgent
      • ReceivableInstallment
      • RegistrationDocumentType
      • ResponsibleForTransport
      • Rma
      • RmaAttachment
      • SalesAgent
      • SalesAgentPerAccount
      • SalesConditionPriority
      • SalesControl
      • SalesControlLine
      • SalesDiscountCategory
      • SaleTypePerItem
      • Season
      • SeasonGroup
      • SeasonPerSeasonGroup
      • ShipmentMethod
      • ShipmentParamsPerDocument
      • ShippingCharge
      • SirioItemSalesClassification
      • SirioSalesCondition
      • StatisticClass
      • StatisticClassTranslation
      • StatisticReport
      • Title
      • Trademark
      • TrademarkImage
      • TrademarkPerAccount
      • TrademarkPerUser
      • TrademarkTranslation
      • TransportMode
      • UomTranslation
      • Variable
      • VariableValue
      • VatRate
      • VisibilityFilter
      • VisibilityFilterPerAccount
      • VisibilityFilterPerItem
      • VisibilityFilterPerSalesAgent
      • Warehouse
      • WarehousePerSalesAgent
      • Zone
    • Come schedulare Import/Export
    • Task personalizzati import/export
  • Funzionalità e ruoli
    • Catalogo
      • Articolo
      • Articolo a variante
      • Articoli associati
      • Listini per catalogo
      • Catalogo PDF (SFA)
      • Idrolab
    • Documenti di vendita
      • Riga documento
      • Tipi Vendita
      • Controlli commerciali
      • Report
    • Promozioni
    • Articoli manuali
    • Documenti aziendali e personali
    • Statistiche
    • Comunicazioni
      • Public API
    • Partite aperte
    • Account (Clienti/Prospect/Destinazioni Merci)
      • Clienti
      • Prospect
      • Destinazioni Merci
    • B2B
      • Promozioni - layout a card
      • Funzioni attivabili da link
      • Caricamento carrello da file Excel
    • Modalità evasione
    • Disponibilità Online
    • CRM
      • Attività
      • Schede marketing
      • Contatti
    • Gestione avanzata dei preventivi
  • Supporto
Powered by GitBook
On this page

Was this helpful?

  1. Integrazione
  2. Database schema

BudgetLine

Riga di un budget

Chiavi

  • Id

Campo
Descrizione
Tipo
Dimensione

AccountId

Id del cliente

text

50

Amount

Importo

dec

BudgetId

Id del budget

text

50

CreationDate

Data di creazione

dt

CreatorId

Id dell'agente che ha creato il record

text

50

Campo che definisce lo stato del record

enum

ErpStatusId1

text

50

ErpStatusId2

text

50

ErpStatusId3

text

50

FreeBoolean1

Campo booleano libero

bool

FreeBoolean2

Campo booleano libero

bool

FreeBoolean3

Campo booleano libero

bool

FreeDateTime1

Campo datetime libero

date

FreeDateTime2

Campo datetime libero

date

FreeDateTime3

Campo datetime libero

date

FreeDecimal1

Campo decimale libero

dec

FreeDecimal2

Campo decimale libero

dec

FreeDecimal3

Campo decimale libero

dec

FreeDecimal4

Campo decimale libero

dec

FreeDecimal5

Campo decimale libero

dec

FreeDecimal6

Campo decimale libero

dec

FreeLookup1

Id per dato tabellato

text

50

FreeLookup2

Id per dato tabellato

text

50

FreeLookup3

Id per dato tabellato

text

50

FreeText1

Campo testo libero

text

text

FreeText2

Campo testo libero

text

text

FreeText3

Campo testo libero

text

text

Id

Id

text

50

IsDeleted

Indica se il record è stato cancellato

bool

LastModifiedTimeStamp

Data dell'ultima modifica

dt

LastModifiedUserId

Id dell'agente che ha effettuato l'ultima modifica

text

50

Locked

Bloccato

bool

LockedFields

Campi bloccati, non modificabili

text

text

Quantity

Quantità

dec

RevisedAmount

Importo revisionato

dec

RevisedQuantity

Quantità revisionata

dec

SyncReference

Riferimento

text

50

UomId

Unità di misura

text

10

UploadToServerTimeStamp

dt

EntityStatus

  • 0: ImportedFromErp

  • 1: ExportedToErp

  • 2: ImportedByErp

  • 3: ExportingToErp

  • 4: Deleted

  • 5: CommittingExportToErp

  • 6: ToExportToErp

  • 7: Editing

  • 8: UploadedToServer

  • 9: StartedUploadToServer

  • 10: EditingPending

  • -1: Undefined

PreviousBudgetNextBudgetLineActual

Last updated 2 years ago

Was this helpful?

EntityStatus