Overview
Configuration is provided for establishing connections with Sage 300 ERP service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this task, we will show you step-by-step how to create a connection to Sage 300 REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Sage 300.
Step 3. Set [host] to the desired host in the Server host parameter and [company] to the desired company in the server company parameter. Then provide Username and Password for username and password parameter in the grid below.
Step 4. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Sage 300 instance.
In this guide, we will show how to read data from the Sage 300 service resource using the COZYROC REST Source component.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.
Step 3. Double click on the "REST Source" component and select Sage 300 connection from the combo. Select from available Sage 300 resources listed in the second combo below.
Optionally you can include extra parameters in the grid below like if needed.
Step 4. Click on the "Columns tab" and select Sage 300 resource columns you want to read.
Step 5. Click Preview to make sure all necessary resource columns are included.
Bravo! You have now learned how to read data from Sage 300 service.
In this guide, we will show how to write data to the Sage 300 service resource using the COZYROC REST Destination component.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3. Double click on the "REST Destination" component and select Sage 300 connection from the combo. Also, select resource action and Sage 300 resource you want to work on.
Step 4. Click on the "Mapping" tab and map the input columns for the process you are configuring.
If you want to provide input for other resource composite objects, change the input above and map the columns.
Done. You have now learned how to write data into the Sage 300 resource.
Configuration
Base URL address: https://[host]/Sage300WebApi/v1.0/-/GLDINC.
- Basic
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- Username: Required. Specify user name.
- Password: Required. Specify password.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Basic {{=Base64.encode(connection.user.Username + ':' + connection.user.Password)}}
Documentation: https://en.wikipedia.org/wiki/Basic_access_authentication.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AP/APCreateGLBatch({{=sq(item.keyField)}}).
- @odata.context
Template: ShortText.
- keyField
Template: ShortText.
- ProcessPaymentBatch
Template: ShortText.
- ThruPaymentPostingSequenceNumber
Data type: DT_I4
- ProcessInvoiceBatch
Template: ShortText.
- ThruInvoicePostingSequenceNumber
Data type: DT_I4
- ProcessAdjustmentBatch
Template: ShortText.
- ThruAdjustmentPostingSequenceNumber
Data type: DT_I4
- ProcessRevalueBatch
Template: ShortText.
- ThruRevaluePostingSequenceNumber
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AP/APCreateRecurringPayableBatch({{=sq(item.keyField)}}).
- RunDate
Data type: DT_DBTIMESTAMP
- keyField
Template: ShortText.
- Mode
Data type: DT_I4
- SelectRecordsBy
Template: ShortText.
- StartingRecurringPayableCode
Template: ShortText.
- EndingRecurringPayableCode
Template: ShortText.
- StartingVendorNumber
Template: ShortText.
- EndingVendorNumber
Template: ShortText.
- StartingVendorGroupCode
Template: ShortText.
- EndingVendorGroupCode
Template: ShortText.
- ScheduleKey
Template: ShortText.
- ScheduleLink
Data type: DT_I4
- Status
Data type: DT_I4
- DateGenerationMethod
Template: ShortText.
- BatchGenerationMethod
Template: ShortText.
- ForcedInvoiceDate
Template: ShortText.
- AppendToBatchNumber
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AP/APCreateRetainageDocumentBatch({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- RunDate
Data type: DT_DBTIMESTAMP
- Mode
Data type: DT_I4
- SelectRecordsBy
Template: ShortText.
- StartingDocumentNumber
Template: ShortText.
- EndingDocumentNumber
Template: ShortText.
- StartingVendorNumber
Template: ShortText.
- EndingVendorNumber
Template: ShortText.
- StartingVendorGroupCode
Template: ShortText.
- EndingVendorGroupCode
Template: ShortText.
- IncludeInvoice
Template: ShortText.
- IncludeDebitNote
Template: ShortText.
- IncludeCreditNote
Template: ShortText.
- DaysBeforeRetainageDue
Data type: DT_I4
- CommandCode
Template: ShortText.
- Status
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AP/APDeleteInactiveRecords({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- ClearFromVendorNumber
Template: ShortText.
- ClearThruVendorNumber
Template: ShortText.
- ClearFromGroupCode
Template: ShortText.
- ClearThruGroupCode
Template: ShortText.
- ClearRemitToFromVendorNumber
Template: ShortText.
- ClearRemitToThruVendorNumber
Template: ShortText.
- ClearFromDate
Data type: DT_DBTIMESTAMP
- ClearThruDate
Data type: DT_DBTIMESTAMP
- ClearInactiveVendors
Template: ShortText.
- ClearInactiveGroups
Template: ShortText.
- ClearInactiveRemitToLocation
Template: ShortText.
- ClearInactiveRecurringPayable
Template: ShortText.
- ClearFromRecurringPayable
Template: ShortText.
- ClearThruRecurringPayable
Template: ShortText.
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AP/APPostInvoices({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- ProcessAllBatches
Template: ShortText.
- FromBatch
Data type: DT_I4
- ToBatch
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AP/APPostPaymentsAndAdjustments({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- BatchType
Template: ShortText.
- PostAllBatches
Template: ShortText.
- PostBatchFrom
Data type: DT_I4
- PostBatchTo
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/AP/APRecurringPayables.
The result is extracted from:{{=response.value}}.
- [Create] action
-
Endpoint URL address:
/AP/APRecurringPayables.
- [Update] action
-
Endpoint URL address:
/AP/APRecurringPayables{{='(VendorNumber=' + sq(item.VendorNumber) + ',RecurringPayableCode=' + sq(item.RecurringPayableCode) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/AP/APRecurringPayables{{='(VendorNumber=' + sq(item.VendorNumber) + ',RecurringPayableCode=' + sq(item.RecurringPayableCode) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/AP/APRecurringPayables{{='(VendorNumber=' + sq(item.VendorNumber) + ',RecurringPayableCode=' + sq(item.RecurringPayableCode) + ')'}}.
- VendorNumber
A key field. Template: ShortText.
- RecurringPayableCode
A key field. Template: ShortText.
- Description
Template: ShortText.
- Status
Template: ShortText.
- InactiveDate
Data type: DT_DBTIMESTAMP
- DateLastMaintained
Data type: DT_DBTIMESTAMP
- EffectiveDate
Data type: DT_DBTIMESTAMP
- ExpirationType
Template: ShortText.
- ExpirationDate
Data type: DT_DBTIMESTAMP
- MaximumNumberOfInvoices
Data type: DT_I4
- MaximumTotalInvoiceAmount
Data type: DT_R8
- LastInvoiceDatePosted
Data type: DT_DBTIMESTAMP
- LastInvoiceAmountPosted
Data type: DT_R8
- YTDNumberOfInvoices
Data type: DT_I4
- YTDTotalInvoiceAmount
Data type: DT_R8
- OrderNumber
Template: ShortText.
- PONumber
Template: ShortText.
- InvoiceDescription
Template: ShortText.
- RemitToLocation
Template: ShortText.
- CurrencyCode
Template: ShortText.
- RateType
Template: ShortText.
- Terms
Template: ShortText.
- DistributionSet
Template: ShortText.
- DistributionAmount
Data type: DT_R8
- TaxGroup
Template: ShortText.
- TaxAmountControl
Template: ShortText.
- TaxAuthority1
Template: ShortText.
- TaxAuthority2
Template: ShortText.
- TaxAuthority3
Template: ShortText.
- TaxAuthority4
Template: ShortText.
- TaxAuthority5
Template: ShortText.
- TaxClass1
Data type: DT_I4
- TaxClass2
Data type: DT_I4
- TaxClass3
Data type: DT_I4
- TaxClass4
Data type: DT_I4
- TaxClass5
Data type: DT_I4
- TaxInclusive1
Template: ShortText.
- TaxInclusive2
Template: ShortText.
- TaxInclusive3
Template: ShortText.
- TaxInclusive4
Template: ShortText.
- TaxInclusive5
Template: ShortText.
- TaxAmount1
Data type: DT_I4
- TaxAmount2
Data type: DT_I4
- TaxAmount3
Data type: DT_I4
- TaxAmount4
Data type: DT_I4
- TaxAmount5
Data type: DT_I4
- DistributedTotalBeforeTaxes
Data type: DT_I4
- InvoiceSubtotal
Data type: DT_R8
- Num1099CPRSCode
Template: ShortText.
- Num1099CPRSAmount
Data type: DT_R8
- LastDetailSequenceNumber
Data type: DT_I4
- Schedule
Template: ShortText.
- ScheduleLink
Data type: DT_I4
- DocumentTotal
Data type: DT_R8
- TaxBase1
Data type: DT_I4
- TaxBase2
Data type: DT_I4
- TaxBase3
Data type: DT_I4
- TaxBase4
Data type: DT_I4
- TaxBase5
Data type: DT_I4
- InvoiceTaxable
Template: ShortText.
- TaxBaseControl
Template: ShortText.
- TotalDistributionTaxIncludedInPrice
Data type: DT_I4
- TotalDistributionTaxExcludedFromPrice
Data type: DT_I4
- TotalTaxAmount
Data type: DT_R8
- NumberOfOptionalFields
Data type: DT_I4
- ProcessCommand
Template: ShortText.
- JobRelated
Template: ShortText.
- NextScheduledDate
Data type: DT_DBTIMESTAMP
- LastInvoiceDateGenerated
Template: ShortText.
- UnpostedNumberOfInvoices
Data type: DT_I4
- UnpostedTotalInvoiceAmount
Data type: DT_I4
- PostedNumberOfInvoices
Data type: DT_I4
- PostedTotalInvoiceAmount
Data type: DT_I4
- LastInvoiceNumberPosted
Template: ShortText.
- LastBatchNumberPosted
Data type: DT_I4
- LastEntryNumberPosted
Data type: DT_I4
- LastPostingSequenceNumber
Data type: DT_I4
- AccountSet
Template: ShortText.
- RecurringPayableDetails
Field components:
- An array.
- Contains the following components: VendorNumber, RecurringPayableCode, LineNumber, DistributionCode, DistributionDescription, GLAccount, TaxClass1, TaxClass2, TaxClass3, TaxClass4, TaxClass5, TaxInclusive1, TaxInclusive2, TaxInclusive3, TaxInclusive4, TaxInclusive5, TaxAmount1, TaxAmount2, TaxAmount3, TaxAmount4, TaxAmount5, DistributedAmount, DistributedAmountBeforeTaxes, DistributionTaxincludedInPrice, DistributionTaxexcludedFromPrice, TaxAmountTotal, TaxBase1, TaxBase2, TaxBase3, TaxBase4, TaxBase5, Discountable, NumberOfOptionalFields, ProcessCommandCode, Comment, Contract, Project, Category, ProjectCategoryResource, CostClass, BillingType, ItemNumber, UnitOfMeasure, Quantity, Cost, BillingRate, BillingCurrency, RecurringPayableDetailFields, UpdateOperation.
- RecurringPayableOptionalField
Template: APTemplate.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/AP/APRemitToLocations.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/AP/APRemitToLocations.
- [Update] action
-
Endpoint URL address:
/AP/APRemitToLocations{{='(VendorNumber=' + sq(item.VendorNumber) + ',RemitToLocationKey=' + sq(item.RemitToLocationKey) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/AP/APRemitToLocations{{='(VendorNumber=' + sq(item.VendorNumber) + ',RemitToLocationKey=' + sq(item.RemitToLocationKey) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/AP/APRemitToLocations{{='(VendorNumber=' + sq(item.VendorNumber) + ',RemitToLocationKey=' + sq(item.RemitToLocationKey) + ')'}}.
- VendorNumber
A key field. Template: ShortText.
- RemitToLocationKey
A key field. Template: ShortText.
- Status
Template: ShortText.
- InactiveDate
Data type: DT_DBTIMESTAMP
- DateLastMaintained
Data type: DT_DBTIMESTAMP
- DateOfLastActivity
Data type: DT_DBTIMESTAMP
- Description
Template: ShortText.
- AddressLine1
Template: ShortText.
- AddressLine2
Template: ShortText.
- AddressLine3
Template: ShortText.
- AddressLine4
Template: ShortText.
- City
Template: ShortText.
- StateProvince
Template: ShortText.
- ZipPostalCode
Template: ShortText.
- Country
Template: ShortText.
- ContactName
Template: ShortText.
- PhoneNumber
Template: ShortText.
- FaxNumber
Template: ShortText.
- CheckLanguage
Template: ShortText.
- PrimaryRemittoIndicator
Template: ShortText.
Template: ShortText.
- ContactsPhone
Template: ShortText.
- ContactsFax
Template: ShortText.
- ContactsEmail
Template: ShortText.
- NumberOfOptionalFields
Data type: DT_I4
- ProcessCommandCode
Template: ShortText.
- SuppressIntegration
Data type: DT_BOOL
- APVersion
Template: ShortText.
- Database
Template: ShortText.
- Mode
Template: ShortText.
- RemitToLocationOptionalField
Template: APTemplate.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/AR/ARRecurringCharges.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/AR/ARRecurringCharges.
- [Update] action
-
Endpoint URL address:
/AR/ARRecurringCharges{{='(RecurringChargeCode=' + sq(item.RecurringChargeCode) + ',CustomerNumber=' + sq(item.CustomerNumber) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/AR/ARRecurringCharges{{='(RecurringChargeCode=' + sq(item.RecurringChargeCode) + ',CustomerNumber=' + sq(item.CustomerNumber) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/AR/ARRecurringCharges{{='(RecurringChargeCode=' + sq(item.RecurringChargeCode) + ',CustomerNumber=' + sq(item.CustomerNumber) + ')'}}.
- RecurringChargeCode
A key field. Template: ShortText.
- CustomerNumber
A key field. Template: ShortText.
- Description
Template: ShortText.
- Status
Template: ShortText.
- InactiveDate
Data type: DT_DBTIMESTAMP
- DateLastMaintained
Data type: DT_DBTIMESTAMP
- LastInvoiceDateGenerated
Data type: DT_DBTIMESTAMP
- EffectiveDate
Data type: DT_DBTIMESTAMP
- ExpirationDate
Data type: DT_DBTIMESTAMP
- MaximumTotalInvoiceAmount
Data type: DT_R8
- YTDTotalInvoiceAmount
Data type: DT_R8
- ShipToLocation
Template: ShortText.
- SpecialInstructions
Template: ShortText.
- OrderNumber
Template: ShortText.
- PONumber
Template: ShortText.
- InvoiceDescription
Template: ShortText.
- CurrencyCode
Template: ShortText.
- RateType
Template: ShortText.
- Terms
Template: ShortText.
- LastLineNumber
Data type: DT_I4
- Salesperson1
Template: ShortText.
- Salesperson2
Template: ShortText.
- Salesperson3
Template: ShortText.
- Salesperson4
Template: ShortText.
- Salesperson5
Template: ShortText.
- SalesSplitPercentage1
Data type: DT_I4
- SalesSplitPercentage2
Data type: DT_I4
- SalesSplitPercentage3
Data type: DT_I4
- SalesSplitPercentage4
Data type: DT_I4
- SalesSplitPercentage5
Data type: DT_I4
- Taxable
Template: ShortText.
- TaxOverride
Template: ShortText.
- TaxGroup
Template: ShortText.
- TaxAuthority1
Template: ShortText.
- TaxAuthority2
Template: ShortText.
- TaxAuthority3
Template: ShortText.
- TaxAuthority4
Template: ShortText.
- TaxAuthority5
Template: ShortText.
- TaxClass1
Data type: DT_I4
- TaxClass2
Data type: DT_I4
- TaxClass3
Data type: DT_I4
- TaxClass4
Data type: DT_I4
- TaxClass5
Data type: DT_I4
- TaxBase1
Data type: DT_I4
- TaxBase2
Data type: DT_I4
- TaxBase3
Data type: DT_I4
- TaxBase4
Data type: DT_I4
- TaxBase5
Data type: DT_I4
- TaxAmount1
Data type: DT_R8
- TaxAmount2
Data type: DT_R8
- TaxAmount3
Data type: DT_R8
- TaxAmount4
Data type: DT_R8
- TaxAmount5
Data type: DT_R8
- LastInvoiceAmountPosted
Data type: DT_R8
- InvoiceSubtotal
Data type: DT_R8
- MaximumNumberOfInvoices
Data type: DT_I4
- YTDNumberOfInvoices
Data type: DT_I4
- Schedule
Template: ShortText.
- ScheduleLink
Data type: DT_I4
- ExpirationType
Template: ShortText.
- ShipViaCode
Template: ShortText.
- ShipViaDescription
Template: ShortText.
- InvoiceTotalBeforeTax
Data type: DT_R8
- InvoiceTotalIncludingTax
Data type: DT_R8
- TotalTaxAmount
Data type: DT_R8
- InvoiceType
Template: ShortText.
- NumberOfOptionalFields
Data type: DT_I4
- ProcessCommandCode
Template: ShortText.
- JobRelated
Template: ShortText.
- NextScheduledDate
Data type: DT_DBTIMESTAMP
- UnpostedNumberOfInvoices
Data type: DT_I4
- UnpostedTotalInvoiceAmount
Data type: DT_R8
- PostedNumberOfInvoices
Data type: DT_I4
- PostedTotalInvoiceAmount
Data type: DT_R8
- LastInvoiceDatePosted
Data type: DT_DBTIMESTAMP
- LastInvoiceNumberPosted
Template: ShortText.
- LastBatchNumberPosted
Data type: DT_I4
- LastEntryNumberPosted
Data type: DT_I4
- LastPostingSequenceNumber
Data type: DT_I4
- AccountSet
Template: ShortText.
- RecurringChargeDetails
Field components:
- An array.
- Contains the following components: RecurringChargeCode, CustomerNumber, LineNumber, ItemNumber, DistributionCode, Description, UnitOfMeasure, Quantity, Cost, Price, ExtendedAmountWithTIP, COGSAmount, ExtendedAmountWithoutTIP, TotalTaxAmount, TaxBase1, TaxBase2, TaxBase3, TaxBase4, TaxBase5, TaxClass1, TaxClass2, TaxClass3, TaxClass4, TaxClass5, TaxIncluded1, TaxIncluded2, TaxIncluded3, TaxIncluded4, TaxIncluded5, TaxRate1, TaxRate2, TaxRate3, TaxRate4, TaxRate5, TaxAmount1, TaxAmount2, TaxAmount3, TaxAmount4, TaxAmount5, RevenueAccount, DistributedAmountBeforeTax, Discountable, InventoryAccount, COGSAccount, Comments, PrintComment, ItemCost, NumberOfOptionalFields, ProcessCommandCode, Contract, Project, Category, ProjectCategoryResource, CostClass, RecChargeDetailOptionalFields.
- RecurringChargeOptionalFields
Template: APTemplate.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/AR/ARShipToLocations.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/AR/ARShipToLocations.
- [Update] action
-
Endpoint URL address:
/AR/ARShipToLocations{{='(CustomerNumber=' + sq(item.CustomerNumber) + ',ShipToLocationKey=' + sq(item.ShipToLocationKey) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/AR/ARShipToLocations{{='(CustomerNumber=' + sq(item.CustomerNumber) + ',ShipToLocationKey=' + sq(item.ShipToLocationKey) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/AR/ARShipToLocations{{='(CustomerNumber=' + sq(item.CustomerNumber) + ',ShipToLocationKey=' + sq(item.ShipToLocationKey) + ')'}}.
- CustomerNumber
A key field. Template: ShortText.
- ShipToLocationKey
A key field. Template: ShortText.
- Status
Template: ShortText.
- InactiveDate
Data type: DT_DBTIMESTAMP
- DateLastMaintained
Data type: DT_DBTIMESTAMP
- Description
Template: ShortText.
- AddressLine1
Template: ShortText.
- AddressLine2
Template: ShortText.
- AddressLine3
Template: ShortText.
- AddressLine4
Template: ShortText.
- City
Template: ShortText.
- StateProvince
Template: ShortText.
- ZipPostalCode
Template: ShortText.
- Country
Template: ShortText.
- ContactName
Template: ShortText.
- PhoneNumber
Template: ShortText.
- FaxNumber
Template: ShortText.
- TerritoryCode
Template: ShortText.
- TaxGroup
Template: ShortText.
- TaxRegistrationNumber1
Template: ShortText.
- TaxRegistrationNumber2
Template: ShortText.
- TaxRegistrationNumber3
Template: ShortText.
- TaxRegistrationNumber4
Template: ShortText.
- TaxRegistrationNumber5
Template: ShortText.
- TaxClassCode1
Data type: DT_I4
- TaxClassCode2
Data type: DT_I4
- TaxClassCode3
Data type: DT_I4
- TaxClassCode4
Data type: DT_I4
- TaxClassCode5
Data type: DT_I4
- SpecialInstructions
Template: ShortText.
- Salesperson1
Template: ShortText.
- Salesperson2
Template: ShortText.
- Salesperson3
Template: ShortText.
- Salesperson4
Template: ShortText.
- Salesperson5
Template: ShortText.
- SalesSplitPercentage1
Data type: DT_R8
- SalesSplitPercentage2
Data type: DT_R8
- SalesSplitPercentage3
Data type: DT_R8
- SalesSplitPercentage4
Data type: DT_R8
- SalesSplitPercentage5
Data type: DT_R8
- CustomerPriceList
Template: ShortText.
- FreeOnBoard
Template: ShortText.
- ShipViaCode
Template: ShortText.
- ShipViaDescription
Template: ShortText.
- PrimaryShipToIndicator
Template: ShortText.
Template: ShortText.
- ContactsPhone
Template: ShortText.
- ContactsFax
Template: ShortText.
- ContactsEmail
Template: ShortText.
- NumberOfOptionalFields
Data type: DT_I4
- ProcessCommandCode
Template: ShortText.
- InventoryLocation
Template: ShortText.
- SuppressIntegration
Data type: DT_BOOL
- ARVersion
Template: ShortText.
- Database
Template: ShortText.
- Mode
Template: ShortText.
- ShipToLocationsOptionalField
Template: APTemplate.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/CS/CSCurrencyRates.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/CS/CSCurrencyRates.
- [Update] action
-
Endpoint URL address:
/CS/CSCurrencyRates{{='(ToCurrency=' + sq(item.ToCurrency) + ',RateType=' + sq(item.RateType) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/CS/CSCurrencyRates{{='(ToCurrency=' + sq(item.ToCurrency) + ',RateType=' + sq(item.RateType) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/CS/CSCurrencyRates{{='(ToCurrency=' + sq(item.ToCurrency) + ',RateType=' + sq(item.RateType) + ')'}}.
- ToCurrency
A key field. Template: ShortText.
- RateType
A key field. Template: ShortText.
- TableDescription
Template: ShortText.
- DateMatching
Template: ShortText.
- RateOperation
Template: ShortText.
- SourceOfRates
Template: ShortText.
- PropagateChangesImmediately
Data type: DT_BOOL
- Command
Template: ShortText.
- FromDate
Data type: DT_DBTIMESTAMP
- ToDate
Data type: DT_DBTIMESTAMP
- CurrencyRateDetail
Field components:
- An array.
- Contains the following components: ToCurrency, RateType, FromCurrency, RateDate, Rate, Spread, DateMatching, RateOperation, PropagateChangesImmediately, UpdateOperation, Warnings, ETag, IsDeleted, IsNewLine, HasChanged, DisplayIndex, ChangeSequence, PreviousKey.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/GL/GLSegmentCodes.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/GL/GLSegmentCodes.
- [Update] action
-
Endpoint URL address:
/GL/GLSegmentCodes{{='(SegmentNumber=' + sq(item.SegmentNumber) + ',SegmentCodeKey=' + sq(item.SegmentCodeKey) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/GL/GLSegmentCodes{{='(SegmentNumber=' + sq(item.SegmentNumber) + ',SegmentCodeKey=' + sq(item.SegmentCodeKey) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/GL/GLSegmentCodes{{='(SegmentNumber=' + sq(item.SegmentNumber) + ',SegmentCodeKey=' + sq(item.SegmentCodeKey) + ')'}}.
- SegmentNumber
A key field. Template: ShortText.
- SegmentCodeKey
A key field. Template: ShortText.
- SegmentCodeDescription
Template: ShortText.
- ClosingAccount
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/GL/GLSourceCodes.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/GL/GLSourceCodes.
- [Update] action
-
Endpoint URL address:
/GL/GLSourceCodes{{='(SourceLedger=' + sq(item.SourceLedger) + ',SourceType=' + sq(item.SourceType) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/GL/GLSourceCodes{{='(SourceLedger=' + sq(item.SourceLedger) + ',SourceType=' + sq(item.SourceType) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/GL/GLSourceCodes{{='(SourceLedger=' + sq(item.SourceLedger) + ',SourceType=' + sq(item.SourceType) + ')'}}.
- SourceLedger
A key field. Template: ShortText.
- SourceType
A key field. Template: ShortText.
- Description
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/OE/OEMiscellaneousCharges.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/OE/OEMiscellaneousCharges.
- [Update] action
-
Endpoint URL address:
/OE/OEMiscellaneousCharges{{='(Currency=' + sq(item.Currency) + ',MiscellaneousChargeCode=' + sq(item.MiscellaneousChargeCode) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/OE/OEMiscellaneousCharges{{='(Currency=' + sq(item.Currency) + ',MiscellaneousChargeCode=' + sq(item.MiscellaneousChargeCode) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/OE/OEMiscellaneousCharges{{='(Currency=' + sq(item.Currency) + ',MiscellaneousChargeCode=' + sq(item.MiscellaneousChargeCode) + ')'}}.
- Currency
A key field. Template: ShortText.
- MiscellaneousChargeCode
A key field. Template: ShortText.
- Description
Template: ShortText.
- MiscellaneousChargeRevenueAccount
Template: ShortText.
- Amount
Data type: DT_R8
- NumberOfOptionalFields
Data type: DT_I4
- AccountDescription
Template: ShortText.
- ProcessCommand
Template: ShortText.
- JobRelated
Data type: DT_BOOL
- ExtendedCost
Data type: DT_R8
- MiscellaneousChargeExpenseAccount
Template: ShortText.
- MiscellaneousChargeClearingAccount
Template: ShortText.
- MiscellaneousChargeCostExpenseAccoun
Template: ShortText.
- MiscellaneousChargeClearingAccountDe
Template: ShortText.
- FunctionalCurrency
Template: ShortText.
- MiscellaneousChargeTaxes
Field components:
- An array.
- Contains the following components: Currency, MiscellaneousChargeCode, Authority, SalesTaxClass, AuthorityDescription, ClassDescription, UpdateOperation, Warnings, ETag, IsDeleted, IsNewLine, HasChanged, DisplayIndex, ChangeSequence, PreviousKey.
- MiscellaneousChargeOptionalFields
Template: APTemplate.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/PO/POVendorContractCosts.
The result is extracted from:{{= response.value }}.
- [Create] action
-
Endpoint URL address:
/PO/POVendorContractCosts.
- [Update] action
-
Endpoint URL address:
/PO/POVendorContractCosts{{='(ItemNumber=' + sq(item.ItemNumber) + ',VendorNumber=' + sq(item.VendorNumber) + ')'}}.
- [Upsert] action
-
Endpoint URL address:
/PO/POVendorContractCosts{{='(ItemNumber=' + sq(item.ItemNumber) + ',VendorNumber=' + sq(item.VendorNumber) + ')'}}.
- [Delete] action
-
Endpoint URL address:
/PO/POVendorContractCosts{{='(ItemNumber=' + sq(item.ItemNumber) + ',VendorNumber=' + sq(item.VendorNumber) + ')'}}.
- ItemNumber
A key field. Template: ShortText.
- VendorNumber
A key field. Template: ShortText.
- ContractCostDescription
Template: ShortText.
- BaseCostType
Template: ShortText.
- BaseCostAmount
Data type: DT_R8
- BaseUnit
Template: ShortText.
- BaseUnitConversion
Data type: DT_R8
- SaleCostType
Template: ShortText.
- SaleCostBasedOn
Template: ShortText.
- PercentageOfBase
Data type: DT_R8
- DiscountAmount
Data type: DT_R8
- FixedAmount
Data type: DT_R8
- SaleUnit
Template: ShortText.
- SaleUnitConversion
Data type: DT_R8
- SaleStarts
Data type: DT_DBTIMESTAMP
- SaleEnds
Data type: DT_R8
- DiscountBasedOn
Template: ShortText.
- QuantityLevel0
Data type: DT_I4
- QuantityLevel1
Data type: DT_I4
- QuantityLevel2
Data type: DT_I4
- QuantityLevel3
Data type: DT_I4
- QuantityLevel4
Data type: DT_I4
- QuantityLevel5
Data type: DT_I4
- QuantityLevel6
Data type: DT_I4
- QuantityLevel7
Data type: DT_I4
- QuantityLevel8
Data type: DT_I4
- QuantityLevel9
Data type: DT_I4
- PercentageLevel0
Data type: DT_R8
- PercentageLevel1
Data type: DT_R8
- PercentageLevel2
Data type: DT_R8
- PercentageLevel3
Data type: DT_R8
- PercentageLevel4
Data type: DT_R8
- PercentageLevel5
Data type: DT_R8
- PercentageLevel6
Data type: DT_R8
- PercentageLevel7
Data type: DT_R8
- PercentageLevel8
Data type: DT_R8
- PercentageLevel9
Data type: DT_R8
- AmountLevel0
Data type: DT_R8
- AmountLevel1
Data type: DT_R8
- AmountLevel2
Data type: DT_R8
- AmountLevel3
Data type: DT_R8
- AmountLevel4
Data type: DT_R8
- AmountLevel5
Data type: DT_R8
- AmountLevel6
Data type: DT_R8
- AmountLevel7
Data type: DT_R8
- AmountLevel8
Data type: DT_R8
- AmountLevel9
Data type: DT_R8
- RoundingMethod
Template: ShortText.
- RoundToaMultipleOf
Data type: DT_I4
- ItemDescription
Template: ShortText.
- FormattedItemNumber
Template: ShortText.
- UnitOfMeasure
Template: ShortText.
- CalculatedSaleCost
Data type: DT_R8
- UIHelper
Data type: DT_I4
- QuantityTo0
Data type: DT_I4
- QuantityTo1
Data type: DT_I4
- QuantityTo2
Data type: DT_I4
- QuantityTo3
Data type: DT_I4
- QuantityTo4
Data type: DT_I4
- QuantityTo5
Data type: DT_I4
- QuantityTo6
Data type: DT_I4
- QuantityTo7
Data type: DT_I4
- QuantityTo8
Data type: DT_I4
- QuantityTo9
Data type: DT_I4
- QuantityNext0
Data type: DT_I4
- QuantityNext1
Data type: DT_I4
- QuantityNext2
Data type: DT_I4
- QuantityNext3
Data type: DT_I4
- QuantityNext4
Data type: DT_I4
- QuantityNext5
Data type: DT_I4
- QuantityNext6
Data type: DT_I4
- QuantityNext7
Data type: DT_I4
- QuantityNext8
Data type: DT_I4
- QuantityNext9
Data type: DT_I4
- DiscountedAmount0
Data type: DT_R8
- DiscountedAmount1
Data type: DT_R8
- DiscountedAmount2
Data type: DT_R8
- DiscountedAmount3
Data type: DT_R8
- DiscountedAmount4
Data type: DT_R8
- DiscountedAmount5
Data type: DT_R8
- DiscountedAmount6
Data type: DT_R8
- DiscountedAmount7
Data type: DT_R8
- DiscountedAmount8
Data type: DT_R8
- DiscountedAmount9
Data type: DT_R8
- LEVELUSEDX
Data type: DT_BOOL
- LevelUsed0
Data type: DT_BOOL
- LevelUsed1
Data type: DT_BOOL
- LevelUsed2
Data type: DT_BOOL
- LevelUsed3
Data type: DT_BOOL
- LevelUsed4
Data type: DT_BOOL
- LevelUsed5
Data type: DT_BOOL
- LevelUsed6
Data type: DT_BOOL
- LevelUsed7
Data type: DT_BOOL
- LevelUsed8
Data type: DT_BOOL
- LevelUsed9
Data type: DT_BOOL
- LEVELUSEDZ
Data type: DT_BOOL
- QuantityMaximum
Data type: DT_I4
- QuantityIncrement
Data type: DT_I4
- VendorCurrency
Template: ShortText.
- Name
Template: ShortText.
- VendorContractCostBaseUnits
Field components:
- An array.
- Contains the following components: ItemNumber, Vendor, UnitOfMeasure, ConversionFactorToStocking, BaseAmount, DefaultUnitOfMeasure, UpdateOperation, Warnings, ETag, IsDeleted, IsNewLine, HasChanged, DisplayIndex, ChangeSequence, PreviousKey.
- VendorContractCostSaleUnits
Field components:
- An array.
- Contains the following components: ItemNumber, Vendor, UnitOfMeasure, ConversionFactorToStocking, SaleCostCalculatedUsing, DiscountPercent, DiscountAmount, FixedAmount, SaleStartDate, SaleEndDate, SaleCost, DefaultUnitOfMeasure, UpdateOperation, Warnings, ETag, IsDeleted, IsNewLine, HasChanged, DisplayIndex, ChangeSequence, PreviousKey.
- VendorContractIncludedTaxes
Field components:
- An array.
- Contains the following components: ItemNumber, Vendor, TaxAuthority, TaxClass, TaxAuthorityDescription, TaxClassDescription, UpdateOperation, Warnings, ETag, IsDeleted, IsNewLine, HasChanged, DisplayIndex, ChangeSequence, PreviousKey.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AR/ARCreateGLBatch({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- ProcessReceiptBatch
Template: ShortText.
- ReceiptThroughPostingSequenceNumber
Data type: DT_I4
- ProcessInvoiceBatch
Template: ShortText.
- InvoiceThroughPostingSequenceNumber
Data type: DT_I4
- ProcessAdjustmentBatch
Template: ShortText.
- AdjustmentThroughPostingSequenceNumber
Data type: DT_I4
- ProcessRevaluationBatch
Template: ShortText.
- RevaluationThroughPostingSequenceNumber
Data type: DT_I4
- ProcessRefundBatch
Template: ShortText.
- RefundThroughPostingSequenceNumber
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AR/ARCreateRecurringCharge({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- RangeType
Template: ShortText.
- RangeFrom
Template: ShortText.
- RangeThrough
Template: ShortText.
- RunDate
Data type: DT_DBTIMESTAMP
- Mode
Data type: DT_I4
- FiscalYear
Template: ShortText.
- FiscalPeriod
Template: ShortText.
- ScheduleKey
Template: ShortText.
- ScheduleLink
Data type: DT_I4
- Status
Data type: DT_I4
- DateGenerationMethod
Template: ShortText.
- BatchGenerationMethod
Template: ShortText.
- ForcedInvoiceDate
Data type: DT_DBTIMESTAMP
- AppendToBatchNumber
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AR/ARCreateRetainageDocumentBatch({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- RunDate
Data type: DT_DBTIMESTAMP
- Mode
Data type: DT_I4
- SelectRecordsBy
Template: ShortText.
- StartingDocumentNumber
Template: ShortText.
- EndingDocumentNumber
Template: ShortText.
- StartingCustomerNumber
Template: ShortText.
- EndingCustomerNumber
Template: ShortText.
- StartingCustomerGroupCode
Template: ShortText.
- EndingCustomerGroupCode
Template: ShortText.
- StartingNationalAccount
Template: ShortText.
- EndingNationalAccount
Template: ShortText.
- IncludeInvoice
Template: ShortText.
- IncludeDebitNote
Template: ShortText.
- IncludeCreditNote
Template: ShortText.
- DaysBeforeRetainageDue
Data type: DT_I4
- CommandCode
Template: ShortText.
- Status
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AR/ARPostInvoices({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- PostAllBatches
Template: ShortText.
- PostBatchFrom
Data type: DT_I4
- PostBatchTo
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AR/ARPostReceiptsAndAdjustments({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- BatchType
Template: ShortText.
- PostAllBatches
Template: ShortText.
- PostBatchFrom
Data type: DT_I4
- PostBatchTo
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/AR/ARPostRefunds({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- PostAllBatches
Template: ShortText.
- PostBatchFrom
Data type: DT_I4
- PostBatchTo
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/GL/GLPostJournal({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- PostAllBatchesSwitch
Template: ShortText.
- ProvisionalPostSwitch
Template: ShortText.
- FromBatchNumber
Template: ShortText.
- ToBatchNumber
Template: ShortText.
- ErrorBatchCreatedSwitch
Template: ShortText.
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/IC/ICCreateGLBatch({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- DayEndNumber
Data type: DT_I4
- TransactionsCreated
Data type: DT_BOOL
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/IC/ICDayEndProcessing({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- ClearHistory
Data type: DT_BOOL
- Application
Template: ShortText.
- ProcessingType
Data type: DT_I4
- TransactionNumber
Data type: DT_I4
- PostSequenceNumber
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/PO/POCreateBatch({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- DayEndNumber
Data type: DT_I4
- TransactionsCreated
Data type: DT_BOOL
- PostGLBatch
Data type: DT_BOOL
- PostAPBatch
Data type: DT_BOOL
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/PO/PODayEndProcessing({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- ClearHistory
Data type: DT_BOOL
- Application
Template: ShortText.
- ProcessingType
Data type: DT_I4
- TransactionNumber
Data type: DT_I4
- PostSequenceNumber
Data type: DT_I4
- ActionSelector
Template: ShortText.
- UpdateOperation
Template: ShortText.
- [Read] action
-
- [Read] action
-
- [Read] action
-
- [Read] action
-
- [Read] action
-
- [Read] action
-
- [Read] action
-
- [Read] action
-
- [Read] action
-
The external resource list is extracted from: {{=Sage300.getEntityList('GL')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('AP')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('AR')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('BK')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('IC')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('OE')}}.
Based on resource template Entity.
The external resource list URL address: /PO.
The external resource list is extracted from: {{=Sage300.getEntityList('PO')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('TX')}}.
Based on resource template Entity.
The external resource list is extracted from: {{=Sage300.getEntityList('CS')}}.
Based on resource template Entity.
- [Read] action
-
The result is paginated.The following request parameters will be automatically processed:
-
$skip:
{{=parameters.iterator}} -
$top:
{{=parameters.batchSize}} -
_includeUserParameters:
{{=parameters}}
-
$skip:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PATCH method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Upsert] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/{{=resource.external.type}}/{{=resource.external.name}}.
The result is extracted from:{{=response.value}}.
- [Create] action
-
Endpoint URL address:
/{{=resource.external.type}}/{{=resource.external.name}}.
- [Update] action
-
Endpoint URL address:
/{{=resource.external.type}}/{{=resource.external.name}}({{=sq(item.keyField)}}).
- [Upsert] action
-
Endpoint URL address:
/{{=resource.external.type}}/{{=resource.external.name}}({{=sq(item.keyField)}}).
- [Delete] action
-
Endpoint URL address:
/{{=resource.external.type}}/{{=resource.external.name}}({{=sq(item.keyField)}}).
- keyField
Template: ShortText.
- [External]
-
The external fields list is extracted from:
{{=Sage300.getEntityFields(resource)}}.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Date
Data type: DT_DBDATE
- APTemplate
Field components:
- An array.
- Contains the following components: VendorNumber, RecurringPayableCode, RecurringChargeCode, CustomerNumber, ShipToLocationCode, OptionalField, Value, Currency, MiscellaneousChargeCode, MiscellaneousChargeOptionalFieldType, ShipToLocationsOptionalFieldType, LineNumber, OptionalField, OptionalFieldValue, RecChargeDetailOptionalFieldType, RemitToLocationOptionalFieldType, RemitToLocation, RecurringPayableOptionalFieldType, Length, Decimals, AllowBlank, Validate, ValueSet, TypedValueFieldIndex, TextValue, AmountValue, NumberValue, IntegerValue, YesNoValue, DateValue, TimeValue, OptionalFieldDescription, ValueDescription, UpdateOperation, Warnings, ETag, IsDeleted, IsNewLine, HasChanged, DisplayIndex, ChangeSequence, PreviousKey.
- warningEtagT
Field components:
- Contains the following components: Warnings.
What's New
- New: Introduced connection.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.