Assistente de Migração: desenvolvimentos com ficheiros Standard XML
O Assistente de Importação de Dados/Empresas foi desenvolvido para simplificar a migração de dados entre sistemas e para aumentar a produtividade. Adicionalmente, é possível desenvolver outros conetores com as mais variadas fontes de dados. Para cada uma das entidades a migrar, existe um formato específico para o mesmo. Também estão disponíveis no GitHub samples para cada uma das classes. Description: Alternative Address Code. Description: Entity Type #1. Description: Zone Code. Description: Location Code. Description: Country Code. Description: Unit Code to Convert. Description: Unit Code. Description: Table. Description: Field. Description: Account associated with the Treasury Movement. Description: Third Party Type Code. Description: Third Party Code. Description: Supplier Code. Description: SubFamily Code. Description: Item code. Description: Module of the Série. Description: Seller Code. Description: Mandates Code Description: Currency Code. Description: Item Code of the Line Description: Type of the Line Description: Document Type for Sale Description: Item Code of the Line Description: Defines the type of Retention Description: Line Type of the Line Description: Document Type for Purchase Description: Description of the Pending Line. Description: External Document Number. Description: Customer Code. Description: Item Code. Description: Zone Code. Description: Discount percentage until "UntilDays". Description: Payment Condition Code. Description: Model Code. Description: Language Code. Description: Language of the Description / Item. Description: Line Number Description: Unit (Empty for default/base) Description: Formula Code. Description: Language of the Description / Item. Description: Order of the Component Description: Country Code. Description: Item Code. Description: Family Code. Description: Zone Code. Description: Bank Account Code Description: Account Type. Description: Module of the Document Type. Description: Dimension Type Code. Description: Item Code. Description: Attach Type. Description: Currency Code. Description: Country Code. Description: Cost Group Code. Description: Contact Type Code. Description: Contact Code Description: Company Code. Description: Brand Code. Description: Represents a Bank/Cash Account Description: Language Code.AlternativeAddress
Property Name Type Description DefaultAddress bool Defines if Alternative Address is Default or not. Address1 string Address Line 1 Address2 string Address Line 2 Location string Address Location. DistrictCode string District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string District Description (for Check purboses). PostalCode string Address Postal Code. PostalCodeLocation string Address Location. Phone string Address Phone. Fax string Address Fax. CountryCode string Address Country Code. AssociatedEntity
Property Name Type Description EntityCodeA string Entity Code #1. EntityTypeB string Entity Type #2. EntityCodeB string Entity Code #2. Zone
Property Name Type Description TargetCode string Zone Code (Code redefined), for Codes bigger than 2 chars. Description string Zone Description. WarehouseLocation
Property Name Type Description Description string Description of the Location. Active bool Define if the Location is active or not. VatTax
Property Name Type Description TargetCode string Target Code (Code redefined). Description string Description of VAT Tax Tax double Tax of VAT ExemptionReason string Exemption Reason (description) ExemptionReasonCode string Exemption Reason (official code) TaxType string Tax type (NOR, RED, INT, ISE, NS, OUT) CountryCode string Country Code UnitConvertion
Property Name Type Description UnitCodeTo string Unit Code to be Converted. Factor double Factor of Conversion (From > To). UseFormula bool Use Formulas or not. Unit
Property Name Type Description Description string Unit Description. CodeUNECERec20 string UNECERec20 Code. Rounding int Decimal places Rounding. UDFConfig
Property Name Type Description Field string Field. Description string Description of the Field. Size int Size of the Field. Base bool Defines where the 'User Defined Field' exists in original ERP, or is inserted for another purposes. DbType UDFConfigDbType Database Type of the Field.
0 = String
1 = Integer
2 = Decimal
3 = Date
4 = BooleanUDF
Property Name Type Description Value string Value. Treasury
Property Name Type Description DocType string Document Type Value double Value / Total Currency string Currency Exchange double Exchange rate MovementDate DateTime Movement Date ValueDate DateTime Value Date of the movement Description string Description ThirdPartyType
Property Name Type Description TargetCode string Target Code (Code redefined). Description string Third Party Type Description. AvailableForCustomers bool Avaliable for Customers. AvailableForSuppliers bool Avaliable for Suppliers. AvailableForOtherDebtors bool Avaliable for Other Debtors. AvailableForOtherCreditors bool Avaliable for Other Creditors. AvailableForExternalEntities bool Avaliable for External Entities. ThirdParty
Property Name Type Description Name string Name of the Third Party. FiscalName string Fiscal Name of the Third Party. EntityType string EntityType of the Third Party (i.e. R-Creditor, D-Debtor, etc). Inactive bool Define if the Third Party is inactive or not. Currency string Currency of the Third Party. TaxPayerNumber string Tax Payer Number of the Third Party. TaxPayerNumberNonResidents string Tax Payer Number of the Third Party for Non Residents. Obs string Observations. MarketType MarketType European Market Type. DistrictCode string Third Partys District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string Third Partys District Description (for Check purboses). Address1 string Address line 1. Address2 string Address line 2. Location string Location of the Third Party. PostalCode string Postal Code of the Third Party. PostalCodeLocation string Postal Code Location of the Third Party. Phone string Phone of the Third Party. Fax string Fax of the Third Party. PaymentDay1 int Payment Day #1 PaymentDay2 int Payment Day #2 PaymentDay3 int Payment Day #3 SingularPerson bool If it´s a Singular Person, or a Company. CashAccountingVAT bool If it´s a Cash Accounting VAT protocol. VATRefundScheme int VAT Refund Scheme/protocol. CompanyActivity bool If it´s context of an Company Activity. CountryCode string Country Code of the Third Party. CommercialDescription string Commercial Description of the Third Party. PaymentConditionCode string Payment Condition Code ThirdPartyType string Third Party Type ThirdPartySegment string Defines the Third Party Segment. HasCreditLimit bool Has Credit Limit CreditLimit double Credit Limit HasAgeCreditLimit bool Has Age Credit Limit HasDaysCreditLimit int Has Days Credit Limit BalanceAmountLimit double Balance Amount Limit Email string Email of the Third Party. Webpage string Webpage of the Third Party. OperationType string Operation Type of the Third Party. OperationLocal string Operation Local for the Third Party PaymentMode string Payment Mode/Method ReceivingMode string Receiving Mode/Method NumberOfCopies int Number Of Copies in documents. ApplyRetentions bool Defines if Third Party Apply or not Retentions. ApplyOtherRetentions bool Defines if Third Party Apply or not other Retentions. ExcludedDueDateReminders bool Defines where customer is Excluded from invoice due date reminders. Contacts List List of Contacts. Retentions List List of Retentions. BankAccounts List List of Bank Accounts. UDFs List User defined Fields. Supplier
Property Name Type Description Name string Name of the Supplier. FiscalName string Fiscal Name of the Supplier. Inactive bool Define if the Supplier is inactive or not. Currency string Currency of the Supplier. TaxPayerNumber string Tax Payer Number of the Supplier. TaxPayerNumberNonResidents string Tax Payer Number of the Supplier for Non Residents. Obs string Observations. MarketType MarketType European Market Type. DistrictCode string Suppliers District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string Suppliers District Description (for Check purboses). Address1 string Address line 1. Address2 string Address line 2. Location string Location of the Supplier. PostalCode string Postal Code of the Supplier. PostalCodeLocation string Postal Code Location of the Supplier. Phone string Phone of the Supplier. Fax string Fax of the Supplier. PaymentDay1 int Payment Day #1 PaymentDay2 int Payment Day #2 PaymentDay3 int Payment Day #3 SingularPerson bool If it´s a Singular Person, or a Company. CashAccountingVAT bool If it´s a Cash Accounting VAT protocol. VATRefundScheme int VAT Refund Scheme/protocol. CompanyActivity bool If it´s context of an Company Activity. CountryCode string Country Code of the Supplier. CommercialDescription string Commercial Description of the Supplier. CommercialDiscount double Commercial Discount en (%). PaymentConditionCode string Payment Condition Code ThirdPartyType string Third Party Type ThirdPartySegment string Defines the Third Party Segment. HasCreditLimit bool Has Credit Limit CreditLimit double Credit Limit Email string Email of the Supplier. Webpage string Webpage of the Supplier. OperationType string Operation Type of the Supplier. OperationLocal string Operation Local for the Supplier Language string Language of the Supplier ExpeditionMode string Expedition Mode/Method PaymentMode string Payment Mode/Method ReceivingMode string Receiving Mode/Method DeliveryTime int Medium Delivery time (in days) NumberOfCopies int Number Of Copies in documents. ApplyRetentions bool Defines if Supplier Apply or not Retentions. ApplyOtherRetentions bool Defines if Supplier Apply or not other Retentions. AlternativeAddresses List List of Alternative Addresses. Contacts List List of Contacts. Retentions List List of Retentions. BankAccounts List List of Bank Accounts. UDFs List User defined Fields. SubFamily
Property Name Type Description TargetCode string Target Code (Code redefined), for Codes bigger than 10 chars. Description string SubFamily Description. StockInventory
Property Name Type Description Warehouse string Warehouse of the Inventory Location string Warehouse Location of the Inventory UnitCost double Unit Cost of the Item Quantity double Quantity of the Item Batch string Batch Code SerialNumber string Serial Number of the Item Serie
Property Name Type Description Code string Code of the Série. Description string Description of the Série. InitialDate DateTime Initial Date Range FinalDate DateTime Final Date Range DocumentType string Document Type of the Serie LowerLimit int Lower Limit (number) UpperLimit int Upper Limit (number) NumberOfCopies int Number of Copies EntryType string Entry type ChangeDate bool Change Date Origin int Origin of the Serie VatIncluded bool Defines if VAT is included or not SuggestSysDate bool Suggests the System Date DefaultSerie bool Defines if the Serie is the default one CommunicationType int Type of Communication AutoNumbering bool Defines if serie is Auto Numbering Preview bool Defines if the Serie has a Preview Numbering DescriptionCopy1 string Description of the Via #1 DescriptionCopy2 string Description of the Via #2 DescriptionCopy3 string Description of the Via #3 DescriptionCopy4 string Description of the Via #4 DescriptionCopy5 string Description of the Via #5 DescriptionCopy6 string Description of the Via #6 PrintConfig string Print Configuration SellerHierarchy
Property Name Type Description Commission double Sales commission (Hierarchical) SEPAMandate
Property Name Type Description Description string Mandate Description SignatureDate DateTime Signature Date Limit double Limite of the Mandate IBAN string IBAN of the mandate ExpeditionFormat int Expedition Format of the mandate State string State of the mandate Seller
Property Name Type Description TargetCode string Target Code (Code redefined). Name string Name of the Seller. Address1 string Address line 1. Address2 string Address line 2. Location string Location of the Seller. PostalCode string Postal Code of the Seller. PostalCodeLocation string Postal Code Location of the Seller. Phone string Phone of the Seller. MobilPhone string MobilPhone of the Seller. Fax string Fax of the Seller. Email string Email of the Seller. Currency string Main currency of the Seller. Commission double Commission of the Seller. SettlementCommission double Commission in Settlement (0% to 100%) versus Commission on sale. Obs string Observations Contacts List List of Contacts. HierarchicalCommissions List Hierarchical Commissions UDFs List User defined Fields. SaleLineComponent
Property Name Type Description Quantity double Quantity of the Item UnitPrice double Unit Price of the Item Warehouse string Warehouse Code of the Line Location string Warehouse Location of the Item SaleLine
Property Name Type Description ItemCode string Item Code of the Line Description string Description of the Line Warehouse string Warehouse Code of the Line Location string Warehouse Location of the Item Seller string Seller Code of the Line CommissionPercentage double Commission Percentage UnitPrice double Unit Price of the Item Quantity double Quantity of Items QtyFormula string Formula Applied QtyMeasure double Quantity to Use in the Formula Measure1 double Measure/Variable #1 Measure2 double Measure/Variable #2 Measure3 double Measure/Variable #3 DiscountPerc1 double Discount in Percentage #1 DiscountPerc2 double Discount in Percentage #2 DiscountPerc3 double Discount in Percentage #3 VatTaxCode string Item VAT Tax Code. VatTax double Item VAT Tax. Batch string Batch Code DeliveryDate DateTime Delivery Date SubjectToWithholding bool Subject to IRS Withholding SerialNumbers List Serial Numbers Components List Components UDFs List User defined Fields. Sale
Property Name Type Description Series string Document Séries for Sale DocumentNumber string Document Number for Sale Year string Year of the Document EntityType string Entity Type of the Document EntityCode string Entity Code of the Document EntityName string Entity Name of the Document TaxPayerNumber string Tax Payer Number of the Entity. OriginalDocTypeRef string Original Document Type Reference OriginalSeriesRef string Original Series Reference OriginalDocumRef string Original Document Reference ExternalNumber string External Number RequisitionNumber string Requisition Number DateTime DateTime Date / Time of the document TimeIsDefined bool Defines if Time is defined or not DistrictCode string Sale´s District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string Sale´s District Description (for Check purposes). Address1 string Address line 1. LicensePlate string License Plate LoadingPlace string Loading Place UnloadingPlace string Unloading Place LoadingAddress string Loading Address LoadingLocation string Loading Location LoadingPostalCode string Loading Postal Code LoadingCountry string Loading Country UnloadingAddress string Unloading Address UnloadingLocation string Unloading Location UnloadingPostalCode string Unloading Postal Code UnloadingCountry string Unloading Country LoadingDateTime DateTime Loading Date/Time Address2 string Address line 2. Location string Location of the Entity. PostalCode string Postal Code of the Entity. PostalCodeLocation string Postal Code Location of the Entity. Country string Country of the Entity Currency string Currency of the Document. Exchange double Exchange of the document State string State of Document CommercialDiscount double Commercial Discount FinancialDiscount double Financial Discount PaymentConditionCode string Payment Condition Code PaymentMode string Payment Mode ExpeditionMode string Expedition Mode Hash string Hash of the Document, for Certificate purposes CertificateNumber string Certificate Number Seller string Seller Code WithholdingRate double Withholding Rate CorrectiveInvoice bool Defines where Document is Corrective Invoice or not. Obs string Observations. FiscalSpace int Fiscal Space of the Document VATRefundScheme int VAT Refund Scheme/protocol. OperationType string Operation Type UDFs List User defined Fields. Lines List Document Lines PurchaseLineComponent
Property Name Type Description Quantity double Quantity of the Item UnitPrice double Unit Price of the Item Warehouse string Warehouse Code of the Line Location string Warehouse Location of the Item Retention
Property Name Type Description RetentionEntity string Retention Entity IncomeType string Defines type of income RetentionRate double Defines the retention rate VatIncluded bool Defines if VAT is included or not PendingToGenerate string Defines de Pending (Document Type) to Generate PendingForAnnulment string Defines de Pending (Document Type) for Annulments PurchaseLine
Property Name Type Description ItemCode string Item Code of the Line Description string Description of the Line Warehouse string Warehouse Code of the Line Location string Warehouse Location of the Item UnitPrice double Unit Price of the Item Quantity double Quantity of Items QtyFormula string Formula Applied QtyMeasure double Quantity to Use in the Formula Measure1 double Measure/Variable #1 Measure2 double Measure/Variable #2 Measure3 double Measure/Variable #3 DiscountPerc1 double Discount in Percentage #1 DiscountPerc2 double Discount in Percentage #2 DiscountPerc3 double Discount in Percentage #3 VatTaxCode string Item VAT Tax Code. VatTax double Item VAT Tax. Batch string Batch Code DeliveryDate DateTime Delivery Date SubjectToWithholding bool Subject to IRS Withholding SerialNumbers List Serial Numbers Components List Components UDFs List User defined Fields. Purchase
Property Name Type Description Series string Document Séries for Purchase DocumentNumber string Document Number for Purchase Year string Year of the Document EntityType string Entity Type of the Document EntityCode string Entity Code of the Document EntityName string Entity Name of the Document TaxPayerNumber string Tax Payer Number of the Entity. OriginalDocTypeRef string Original Document Type Reference OriginalSeriesRef string Original Series Reference OriginalDocumRef string Original Document Reference OriginalDateDocumRef DateTime Original Document Reference Date ExternalNumber string External Number RequisitionNumber string Requisition Number CashAccountingVAT bool If it´s a Cash Accounting VAT protocol. DateTime DateTime Date / Time of the document TimeIsDefined bool Defines if Time is defined or not CreationDate DateTime Creation Date of Document DistrictCode string Purchase´s District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string Purchase´s District Description (for Check purposes). Address1 string Address line 1. LicensePlate string License Plate LoadingPlace string Loading Place UnloadingPlace string Unloading Place LoadingAddress string Loading Address LoadingLocation string Loading Location LoadingPostalCode string Loading Postal Code LoadingCountry string Loading Country UnloadingAddress string Unloading Address UnloadingLocation string Unloading Location UnloadingPostalCode string Unloading Postal Code UnloadingCountry string Unloading Country LoadingDateTime DateTime Loading Date/Time Address2 string Address line 2. Location string Location of the Entity. PostalCode string Postal Code of the Entity. PostalCodeLocation string Postal Code Location of the Entity. Country string Country of the Entity Currency string Currency of the Document. Exchange double Exchange of the document State string State of Document CommercialDiscount double Commercial Discount FinancialDiscount double Financial Discount PaymentConditionCode string Payment Condition Code PaymentMode string Payment Mode ExpeditionMode string Expedition Mode Hash string Hash of the Document for Certificate purposes CertificateNumber string Certificate Number WithholdingRate double Withholding Rate CorrectiveInvoice bool Defines where Document is Corrective Invoice or not. Obs string Observations. FiscalSpace int Fiscal Space of the Document VATRefundScheme int VAT Refund Scheme/protocol. OperationType string Operation Type UDFs List User defined Fields. Lines List Document Lines PendingLine
Property Name Type Description VatTax double VAT Tax. VatTaxCode string VAT Tax Code. VatIncidence double VAT Incidence. VatValue double VAT Value. DeductibleVatPerc double Deductible VAT Percentage. Pending
Property Name Type Description DocumentDate DateTime Document Date. DueDate DateTime Due Date. Currency string Currency of the Document. FiscalSpace int Fiscal Space of the Document VATRefundScheme int VAT Refund Scheme/protocol. CashAccountingVAT bool Cash Accounting VAT ExchangeRate double Exchange rate. Obs string Observations Seller string Seller Code of Pending PaymentConditionCode string Payment Condition Code of Pending EntityType string Entity Type. Entity string Entity Code. TaxPayerNumber string Tax Payer Number. DocType string Document Type. Series string Series. PendingIRS double Pending IRS IRSTax double IRS Tax IRSType int IRS Type (0-IRC 1-IRS) Lines List Lines of the Pending. UDFs List User defined Fields. Customer
Property Name Type Description Name string Name of the Customer. FiscalName string Fiscal Name of the Customer. Inactive bool Define if the Customer is inactive or not. Currency string Currency of the Customer. TaxPayerNumber string Tax Payer Number of the Customer. TaxPayerNumberNonResidents string Tax Payer Number of the Customer for Non Residents. Obs string Observations. MarketType MarketType European Market Type. DistrictCode string Customers District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string Customers District Description (for Check purposes). Address1 string Address line 1. Address2 string Address line 2. Location string Location of the Customer. PostalCode string Postal Code of the Customer. PostalCodeLocation string Postal Code Location of the Customer. Phone1 string Phone 1 of the Customer. Phone2 string Phone 2 of the Customer. Fax string Fax of the Customer. PaymentDay1 int Payment Day #1 PaymentDay2 int Payment Day #2 PaymentDay3 int Payment Day #3 SingularPerson bool If it´s a Singular Person, or a Company. CashAccountingVAT bool If it´s a Cash Accounting VAT protocol. VATRefundScheme int VAT Refund Scheme/protocol. CompanyActivity bool If it´s context of an Company Activity. CountryCode string Country Code of the Customer. CommercialDescription string Commercial Description of the customer. Seller string Seller Code. Supplier string Supplier Code. CommercialDiscount double Commercial Discount en (%). PaymentConditionCode string Payment Condition Code ZoneCode string Zone Code of the Customer. PublicAdministration bool Defines if customer is Public Administration or not. EquivalenceTopUp bool Defines whether the customer is subject to an equivalence top-up. ExemptSCT bool Defines if customer is exempt from Special Consumption Tax. ProcessIntrastat bool Defines where the customer process Intrastat or not. ExcludedDueDateReminders bool Defines where customer is Excluded from invoice due date reminders. ThirdPartyType string Third Party Type ThirdPartySegment string Defines the Third Party Segment. HasCreditLimit bool Has Credit Limit CreditLimit double Credit Limit HasAgeCreditLimit bool Has Age Credit Limit HasDaysCreditLimit int Has Days Credit Limit BalanceAmountLimit double Balance Amount Limit Email string Email of the Customer. Webpage string Webpage of the Customer. OperationType string Operation Type of the Customer. OperationLocal string Operation Local for the Customer Language string Language of the Customer ExpeditionMode string Expedition Mode/Method PaymentMode string Payment Mode/Method ReceivingMode string Receiving Mode/Method LinePrices int Line of Prices (1..6) NumberOfCopies int Number Of Copies in documents. ApplyRetentions bool Defines if Customer Apply or not Retentions. ApplyOtherRetentions bool Defines if Customer Apply or not other Retentions. AlternativeAddresses List List of Alternative Addresses. Retentions List List of Retentions. Contacts List List of Contacts. BankAccounts List List of Bank Accounts. SEPAMandates List List of SEPA Mandates. UDFs List User defined Fields. Dimension
Property Name Type Description Description string Dimension Description. DimensionType string Type of Dimension. Lines List Lines (items) of Dimension. PaymentMode
Property Name Type Description TargetCode string Zone Code (Code redefined), for Codes bigger than 5 chars. Description string Zone Description. IsCredit bool Is Credit or else Is Debit ClearingDays int Number of Clearing Days Check bool Payment Mode is Check DepositAccount bool Payment Mode is a Deposit Account TermDepositAccount bool Payment Mode is a Term Deposit Account Cash bool Payment Mode is Cash CashAccount bool Payment Mode is a Cash Account CreditCard bool Payment Mode is Credit Card CreditCardAccount bool Payment Mode is a Credit Card Account EscrowCurrentAccount bool Payment Mode is a Escrow Current Account Other bool Payment Mode is Other than specified PaymentConditionDiscount
Property Name Type Description UntilDays int Limite of days to apply the Discount. PaymentCondition
Property Name Type Description TargetCode string Payment Condition Code (Code redefined), for Codes bigger than 2 chars. Description string Payment Condition Description. Discount double Discount percentage. DiscountVatIncluded bool VAT is included or not for the Discount. AvailableForCustomers bool Payment Condition avaliable for Customers. AvailableForSuppliers bool Payment Condition avaliable for Suppliers. AvailableForOtherDebtors bool Payment Condition avaliable for Other Debtors. AvailableForOtherCreditors bool Payment Condition avaliable for Other Creditors. SuggestDiscountForLiquidation bool Suggest Discount For Liquidation DaysToApplyDiscount int Days To Apply Discount ConditionType PaymentConditionType Condition Type InitialEntry double Initioal Entry InitialEntryDueDays int Initial Entry Due Days InstallmentsNumber int Number of Installments InstallmentsPeriodicity int Periodicity for Installments Discounts List Discounts limits. Model
Property Name Type Description TargetCode string Target Code (Code redefined), for Codes bigger than 10 chars. Description string Model Description. Language
Property Name Type Description TargetCode string Target Code (Code redefined), for Codes bigger than 2 chars. Description string Language's Description. ItemStockParam
Property Name Type Description MinimumStock double Minimum Stock MaximumStock double Maximum Stock SafetyStock double Safety Stock ItemPriceLine
Property Name Type Description UDFField string User Defined Field Name (Number = 0) RRP double Recommended Retail Price ItemPrice
Property Name Type Description Currency string Currency (Empty for default) Prices List Recomended Retail Price list. ItemFormula
Property Name Type Description Description string Formula Description Base DescriptionA string Formula Description 1 measure DescriptionB string Formula Description 2 measures DescriptionC string Formula Description 3 measures VariableNumber int Number of Variables FormulaText string Fórmula. ItemLang
Property Name Type Description Description string Description AbbrevDescription string Abbreviated Description Characteristics string Characteristics of the Item/Lang CommercialDescription string Commercial Description ItemComponent
Property Name Type Description Component string Item Code of the Component Quantity double Quantity of the Component in the composition CostType int Cost Type Warehouse string Warehouse of the Component Location string Location of the Component ItemCategory
Property Name Type Description TargetCode string Target Code (Code redefined). Description string Category's Description. LineType string Line Type FiscalType string Fiscal Type FiscalItemClassif string Fiscal Item Classification Item
Property Name Type Description OriginalCode string Original Code (for redefined codes). Description string Item Description Abbreviation string Item Description Abbreviation Obs string Item Observations SubstituteItem string Substitute Item Discount double Commercial Discount of the Item BarCode string Principal BarCode of the Item Inactive bool Define if the Item is inactive or not. StandardCostPrice double Standard cost price of the Item. VatIncidencePerc double VAT Incidence Percentage DeductVatPerc double Deductible VAT Percentage DeductVAT bool Define if the Item Deducts VAT or not. NetWeight double Net Weight of the Item. Weight double Weight of the Item. UnitBase string Item Base Unit UnitBuy string Item Buy Unit UnitSell string Item Sell Unit UnitIn string Item In Unit UnitOut string Item Out Unit StockMove bool Defines if the item is moves Stock or not. SingularManagement bool Defines if the item has Singular Management or not. SubjectToReturn bool Defines if the item possible to Return (Refund) or not. VatTaxCode string Item VAT Tax Code. HasRetention bool Defines where Item has retention of IRS or not. MinimumStock double Minimum Stock MaximumStock double Maximum Stock SafetyStock double Safety Stock DimensionsType byte Dimension Type of the Item (0-No Dimensions / 1-FatherItem / 2-SunItem) TopItem string Top Item Code, for dimensions purposes Dimension1Type string Dimension #1 Type Dimension1Code string Dimension #1 Code Dimension1LineCode string Dimension #1 Rubric Dimension2Type string Dimension #2 Type Dimension2Code string Dimension #2 Code Dimension2LineCode string Dimension #2 Rubric ManageBatches bool Defines where Item Manage Batches or not ManageSerialNumbers bool Defines where Item Manage Serial Numbers or not Family string Family of the Item SubFamily string SubFamily of the Item Brand string Brand of the Item Model string Model of the Item CommercialDescription string Commercial Description Characteristics string Characteristics of the Item StandardCostSuggestion int Standard Cost Suggestion DeliveryTime int Medium Delivery Time Volume double Volume of the Item Class int Item Class (Simple = 0, Set = 1, Composite = 2, Kit = 3) WarrantyMonths int Warranty Months ItemCategory string Item Category FormulaIn string Measure Fórmula for Entries FormulaOut string Measure Fórmula for Exits DefFormulaIn ItemFormula Measure Fórmula for Entries (info to Create) DefFormulaOut ItemFormula Measure Fórmula for Exits (info to Create) Prices List List of Prices Langs List List of Langs (descriptions) StockParams List List of Warehouse Stock Params Components List List of Components UDFs List User defined Fields. Family
Property Name Type Description TargetCode string Target Code (Code redefined), for Codes bigger than 10 chars. Description string Description of the Family. AllowReturns bool Defines if MoneyBack is allowed or not. SubFamilies List List of SubFamilies. ExpeditionMode
Property Name Type Description Description string Zone Description. IntrastatMode string Intrastat Mode. EntityBankAccount
Property Name Type Description Bank string Bank of the Account BankCounter string Bank Counter AccountNumber string Account Number BIN string Bank Identification Number IBAN string IBAN SWIFT string SWIFT Default bool Defines if the Account is the default one. DocumentTypeState
Property Name Type Description State string State. DocumentType
Property Name Type Description Code string Code of the Document Type. Description string Description of the Document Type. FiscalDescription string Description of the Document Type in Fiscal Terms. DocTypeSAFT string Description of the Document Type in SAFT Terms. DocType int Document Type PayableReceivable string Payable/Receivable P/R AvailableForIndifCustomers bool Avaliable for Indiferentiated Customers. AvailableForCustomers bool Payment Condition avaliable for Customers. AvailableForOtherDebtors bool Payment Condition avaliable for Other Debtors. AvailableForIndifSuppliers bool Avaliable for Indiferentiated Suppliers. AvailableForSuppliers bool Payment Condition avaliable for Suppliers. AvailableForOtherCreditors bool Payment Condition avaliable for Other Creditors. StatisticSuggestion bool Statistic Suggestion CanBeConverted bool Can be Converted CirculationGoods bool Document of Circulation of Goods StockConnection bool Connection to Stocks CalculateCommissions bool Calculate Commissions or not AllowNegativeTotal bool Allow Negative Total AllowNegativeLines bool Allow Negative Lines MoveStockType string Movement Stock Type NMoveStockType string N Movement Stock Type RecapitulativeReport bool Recapitulative Report Nature string Nature D/C TreasuryConnection bool Has or not Treasury Connection CreditLimit bool Credit Limit? DeductSettleVAT bool Deducts or Settles VAT WithholdingSubject bool Subject to Withholding States List List of Account/States DimensionType
Property Name Type Description Description string Dimension Type Description. DimensionLine
Property Name Type Description TargetCode string Target Code (Code redefined). Description string Item Description. Order int Order of Item in lines DigitalAttachment
Property Name Type Description AttachKey string Attach Key. Type string Type of the Attachment (IPR / IMG). FileName string File Name of the Attachment FileInfo byte[] File Info of the Attachment Currency
Property Name Type Description TargetCode string Target Code (Code redefined). BuyExchangeRate double Last Buy Exchange Rate. SellExchangeRate double Last Sell Exchange Rate. ExchangeDate DateTime Last ExchangeRate Date. Description string Currency's Description. Rounding int Normal Rounding (precision). UnitPriceRounding int Unit Price Rounding (precision). VATRounding int VAT Rounding (precision). Symbol string Currency' Symbol. ISO4217 string ISO4217 Code. Country
Property Name Type Description TargetCode string Target Code (Code redefined). Description string Country's Description. ISOA2 string ISOA2 Code. ISON string ISON Code. ISOA3 string ISOA3 Code CostGroup
Property Name Type Description Description string Description of the Cost Group. ByBatch bool Define if the Cost Group has a Batch Valorization or not. ContactType
Property Name Type Description Description string Contact Type Description. Contact
Property Name Type Description Name string Contact Name Email string Contact Email Position string Position / Role Phone string Phone of the Contact. HomePhone string Home Phone of the Contact. CellPhone string CellPhone of the Contact. Fax string Phone 2 of the Contact. Obs string Observations. ZoneCode string Zone Code of the Contact. Webpage string Webpage of the Contact. DistrictCode string Contact District Code (just one between DistrictCode and DistrictDescription). DistrictDescription string Contact District Description (for Check purposes). Address1 string Address line 1. Address2 string Address line 2. Location string Location of the Contact. PostalCode string Postal Code of the Contact. PostalCodeLocation string Postal Code Location of the Contact. CountryCode string Country Code of the Contact. TaxPayerNumber string Tax Payer Number of the Contact. ContactType string Contact Type UDFs List User defined Fields. CompanyData
Property Name Type Description TaxPayerNumber string Tax Payer Number of the company. Name string Name of the company. Address string Main Address of the company. PostalCode string Postal Code of the company. PostalCodeLocation string Postal Code Location. Phone string Main Phone of the of the company. Fax string Main Fax of the company. Webpage string Webpage of the company. Location string Location of the company. Municipality string Municipalityu of the company. District string District of the company. VatType string VAT Type of the company.
M - For Monthy VAT report.
T - For Quarterly VAT report.InitMonth int Init Month of the FiscalYear (1 for mostly cases). EndMonth int End Month of the FiscalYear (12 for mostly cases).
economic activity codeDecimalPlacesQuantity int Number of decimal places for the company (quantities). DecimalPlacesTotals int Number of decimal places for the company (Totals). DecimalPlacesUnitPrices int Number of decimal places for the company (Unit Prices). DecimalPlacesUnitCosts int Number of decimal places for the company (Unit Costs). SIIInitialYear int Initial year for SII communications (Spain only). YearsCashAccountingVAT List Years for Cash Accounting VAT protocol. EAC string Economic activity code MainActivity string Main/principal activity Email string Main email of the company CharteredAccountantTIN string Tax Identification Number (TIN) of the Chartered Accountant LegalRepresentativeTIN string Tax Identification Number(TIN) of the Legal Representative TaxOfficeCode string Tax Office Code SocialCapital double Social Capital of the company. SocialCapitalCurrency string Currency of Social Capital of the company. SocialCapitalPercNational double National percentage of Social Capital. SocialCapitalPercForeigner double Foreigner Percentage of Social Capital. SocialCapitalPercPublic double Public Percentage of Social Capital. ActivityBeginYear int Year of commencement of activity NumberEmployees int Actual Number of employees SalesVolume double Sales volume CommercialRegistryOffice string Commercial Registry Office SocialSecurityNumber string Social Security Number RegistrationNumber string Company registration number LegalNature string Legal nature EmployerAssociation string Employer association VatIncludedPrice1 bool VAT Included in the price #1. VatIncludedPrice2 bool VAT Included in the price #2. VatIncludedPrice3 bool VAT Included in the price #3. VatIncludedPrice4 bool VAT Included in the price #4. VatIncludedPrice5 bool VAT Included in the price #5. VatIncludedPrice6 bool VAT Included in the price #6. UDFDefinition List User Defined Fields Definition. Brand
Property Name Type Description TargetCode string Target Code (Code redefined), for Codes bigger than 10 chars. Description string Description of the Brand. Models List List of Models. Batch
Property Name Type Description Code string Account Code TargetCode string Target Code (Code redefined), for Codes bigger than 5 chars. Description string Account Description AccountType int Account Type Currency string Currency BIN string Bank Identification Number Bank string Bank Code BankCounter string Bank Counter BankCounterName string Bank Counter AccountHolderName string Account Holder Name AccountHolderAddress string Account Holder Address AccountHolderLocation string Account Holder Location AccountHolderPostalCode string Account Holder Postal Code AccountManagerName string Account Manager Name AccountManagerPhone string Account Manager Phone AccountManagerFax string Account Manager Fax SWIFT string SWIFT IBAN string IBAN CountryCode string Country Code of the Customer. ShipmentsSuffix string Shipments Suffix ShipmentsPlafond double Shipments Plafond Bank
Property Name Type Description TargetCode string Target Code (Code redefined), for Codes bigger than 3 chars. Description string Banks's Description. OfficialCode string Banks's Official Code. Contacts List List of Contacts.