Connectors
Sage 300
Connectors
Sage 300
Connector Details
| Name | Value |
|---|---|
| Platform | Sage 300 |
| Auth Type | API Keys |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the Sage 300 connector.
| Table Name | Fields |
|---|---|
| batch_invoices | VendorNumber, DocumentNumber, RemitToLocation, DocumentType, TransactionType, OrderNumber, PONumber, InvoiceDescription, ApplytoDocument, AccountSet, DocumentDate, AsOfDate, FiscalYear, FiscalPeriod, CurrencyCode, RateType, RateOverridden, ExchangeRate, ApplytoExchangeRate, Terms, TermsOverridden, DueDate, DiscountPercentage, DiscountAmountAvailable, NumberOfDetailsDecimal, Taxable, TaxAmountControl, TaxGroup, TaxAuthority1, TaxAuthority2, TaxAuthority3, TaxAuthority4, TaxAuthority5, TaxClass1, TaxClass2, TaxClass3, TaxClass4, TaxClass5, TaxBase1, TaxBase2, TaxBase3, TaxBase4, TaxBase5, TaxAmount1, TaxAmount2, TaxAmount3, TaxAmount4, TaxAmount5, Num1099CPRSAmount, DistributionSetAmount, TotalDistributedTax, DocumentTotalBeforeTaxes, DistributedAllocatedTaxes, NumberOfScheduledPayments, DistributedTotalBeforeTaxes, DistributedTotalIncludingTax, PrepaymentNumber, LocationName, AddressLine1, AddressLine2, AddressLine3, AddressLine4, City, StateProvince, ZipPostalCode, Country, ContactName, PhoneNumber, FaxNumber, RateDate, RecoverableTaxes, VendorGroupCode, TermsDescription, DistributionSet, Num1099CPRSCode, AmountDue, GeneratePaymentSchedule, TaxTotal, DocumentTotalIncludingTax, UndistributedAmount, TaxInclusive1, TaxInclusive2, TaxInclusive3, TaxInclusive4, TaxInclusith.Property(ve5, ExpensedSeparatelyTaxes, TaxAmountTobeAllocated, CurrencyCodeOperator, RecoverableAccount1, RecoverableAccount2, RecoverableAccount3, RecoverableAccount4, RecoverableAccount5, ExpenseSeparatelyAccount1, ExpenseSeparatelyAccount2, ExpenseSeparatelyAccount3, ExpenseSeparatelyAccount4, ExpenseSeparatelyAccount5, DrillDownApplicationSource, DrillDownType, DrillDownLinkNumber, PropertyCode, PropertyValue, ProcessCommandCode, JobRelated, DistributionRecoverableTaxes, DistributionExpenseSeparatelyTaxes, ErrorBatch, ErrorEntry, Email, ContactsPhone, ContactsFax, ContactsEmail, PrepaymentAmount, RecurringPayableCode, DiscountBaseWithTax, DiscountBaseWithoutTax, DiscountBase, RetainageInvoice, HasRetainage, OriginalDocumentNumber, RetainageAmount, PercentRetained, DaysRetained, RetainageTermsCode, RetainageDueDateOverride, RetainageAmountOverride, RetainageExchangeRate, TaxBaseControl, NumberOfOptionalFields, NumberOfDetails, SourceApplication, OnHold, OrigExists, OrigName, OrigStatus, VendorExists, VendorName, VendorDistType, VendorDistCode, VendorAccount, VendorTaxReportType, RemitExists, RemitName, Num1099CPRSExists, Num1099CPRSDescription, DistSetExists, DistSetDescription, DistSetMethod, TermExists, TermUsePaymentSchedule, RTGTermExists, RTGTermDescription, PMLevel1Name, PMLevel2Name, PMLevel3Name, TaxGroupDescription, TaxAuth1Description, TaxAuth2Description, TaxAuth3Description, TaxAuth4Description, TaxAuth5Description, APVersionCreatedIn, TaxStateVersion, ReportRetainageTax, TaxReportingCurrencyCode, TaxReportingCalculateMethod, TaxReportingExchangeRate, TaxReportingRateType, TaxReportingRateOperator, TaxReportingRateOverride, TaxReportingAmount1, TaxReportingAmount2, TaxReportingAmount3, TaxReportingAmount4, TaxReportingAmount5, TaxReportingTotal, TaxReportingAllocatedTax, TaxReportingExpensedTax, TaxReportingRecoverableTax, RetainageTaxBase1, RetainageTaxBase2, RetainageTaxBase3, RetainageTaxBase4, RetainageTaxBase5, RetainageTaxAmount1, RetainageTaxAmount2, RetainageTaxAmount3, RetainageTaxAmount4, RetainageTaxAmount5, FunctionalTaxBase1, FunctionalTaxBase2, FunctionalTaxBase3, FunctionalTaxBase4, FunctionalTaxBase5, FunctionalTaxAmount1, FunctionalTaxAmount2, FunctionalTaxAmount3, FunctionalTaxAmount4, FunctionalTaxAmount5, FunctionalDistributionWithTaxTotal, FunctionalRetainageAmount, FunctionalDiscountAmount, Functional1099CPRSAmount, FunctionalPrepaymentAmount, SourceAmountDue, FunctionalAmountDue, VendorName2, RetainageTaxTotal, TaxAmount1Total, TaxAmount2Total, TaxAmount3Total, TaxAmount4Total, TaxAmount5Total, RetainageAmountFromDetails, EnteredBy, PostingDate, AcctSetDescription, ImportDeclarationNumber, EstimatedTaxWithheldAmount1, EstimatedTaxWithheldAmount2, EstimatedTaxWithheldAmount3, EstimatedTaxWithheldAmount4, EstimatedTaxWithheldAmount5, ReverseChargesBase1, ReverseChargesBase2, ReverseChargesBase3, ReverseChargesBase4, ReverseChargesBase5, ReverseChargesAmount1, ReverseChargesAmount2, ReverseChargesAmount3, ReverseChargesAmount4, ReverseChargesAmount5, NegativeReverseChargesAmount, NetVendorTaxAmount, ReverseChargesAmount, TotalTaxWithholding, AmountDuewithTaxWithholding, AmtDueDiscWithholdAdjusted, InvoiceDetails, InvoicePaymentSchedules, InvoiceOptionalFields |