AO Scheduler - Orders

The orders data polling moves the data from Accredo to the website. As new orders are made they get polled automatically.

Recommended Schedule: Every 2 Hours

MetaData
TableName String
NoMarkedRecords Int
TotalNoRecords String
SalesHeaders
DocumentType String
ERPDocumentClass String
ERPDocumentType String
DocumentNo String
SelltoCustomerNo String
BilltoCustomerNo String
ShiptoCode String
JenkinsEnabled Boolean
JenkinsRecord Boolean
JenkinsOrderEntryId Int
ERPOrderEntryId Int
OrderEntryId Int
JenkinsStatus String
JenkinsDeliveryDate String
JenkinsDeliveryDateTime String
OrderDate String
PostingDate String
HeaderShipmentDate String
STName String
STName2 String
STAddress String
STAddress2 String
STCity String
STCounty String
STPostCode String
STContact String
SellToCustomerName String
SellToAddress String
SellToAddress2 String
SellToCity String
SellToCounty String
SellToPostCode String
ExternalDocumentNo String
YourReference String
ShiptoInstructionsLine1 String
ShiptoInstructionsLine2 String
LocationCode String
CurrencyCode String
ShippingNo String
DeliveryRequired Boolean
PayMethod String
PayDetails String
CustomertoCollect Boolean
DatetoCollect String
RequestedDate String
RequestedTime String
LoadedDate String
LoadedTime String
LoyalityCard String
ReferralCard String
STSuburb String
CustomerCode String
DocumentID Int
DocumentClass String
PostStatus String
PrintStatus String
PriceCode String
OrderNo String
PackingSlipNo String
InternalReference String
QuotationReference String
SalesAreaCode String
SalesPersonCode String
BranchCode String
DepartmentCode String
DefaultLocationCode String
DeliveryCountryCode String
Charge1Amount Decimal
Charge2Amount Decimal
Charge3Amount Decimal
Charge1GstAmount Decimal
Charge2GstAmount Decimal
Charge3GstAmount Decimal
Category1 String
Category2 String
Custom1 String
Custom2 String
DeliveryAddressCode String
InvoiceID Int
ExclusiveCostBs Decimal
ExclusiveAmountBs Decimal
CustReqDespatchDate String
TotalNoofTiles Decimal
TotalNoofCartons Decimal
FreightCalledDate String
FreightCalledTime String
ShippingAgentCode String
PackageTrackingNo String
WebTrackingUrl String
SourceID Int
SourceOrderID int
SourceModule String
Active Boolean
JOCartLoginEntryId Int
JOWebPortalID Int
JOOrderStatus Int
JONAVOrderNo String
JONAVPostedOrderNo String
JOERPDocumentStatus String
JOERPLoginEntryId Int
JOLoginEmail String
JOLoginNameFirstLast String
JONavCustomerNoFromLoginTable String
JOCustomerName String
DiscountScheduleCode String
JONavOrderEntryId Int
JOOrderEntryId int
SalesLines
SLDocumentType String
SLDocumentNo String
OrderNo String
SLNavEntryId Int
SLLineNo Int
SalesLineType String
ItemNo String
SalesLineLocationCode String
ShipmentDate String
Description String
UnitofMeasure String
Quantity Decimal
OutstandingQuantity Decimal
QtytoInvoice Decimal
QtytoShip Decimal
UnitPrice Decimal
VAT Decimal
LineDiscount Decimal
LineDiscountAmount Decimal
Amount Decimal
AmountIncludingVAT Decimal
GrossWeight Decimal
NetWeight Decimal
ItemCategoryCode String
ERPQuantityBackOrdered Decimal
DocumentID Int
LocationCode String
BranchCode String
DepartmentCode String
QuantityOrdered Decimal
QuantitySupplied Decimal
QuantityBackOrdered Decimal
QuantityInvoiced Decimal
Unit String
SerialNo String
DiscountPercentage Decimal
SalesGroupCode String
Custom1 String
Custom2 String
Narration String
Comment String
LineBreak Boolean
Active Boolean
JenkinsRecordSL Boolean
JenkinsIsGift Boolean
UOMCode String
UOMMultiplier Decimal
UOMQuantityOrdered Decimal
UOMQuantitySupplied Decimal
UOMQuantityBackordered Decimal
UOMSellingPrice Decimal
UOMSellingPriceBs Decimal
UOMCostPrice Decimal
UOMCostPriceBs Decimal
AOOrderLineEntryId Int
JenkinsOrderHeaders
NavOrderEntryIdJOH Int
OrderEntryIdJOH Int
CartLoginEntryId Int
JOHActive Boolean
WebPortalID Int
LoginEmail String
NavCustomerNoFromLoginTable String
HasBeenPolled Boolean
ModifiedSinceLastPolled Boolean
OrderStatus String
Active Boolean
NAVOrderNo String
NAVOrderPostedNo String
NAVDocumentStatus String
Copyright 2025 by Acumen Consulting : Terms Of Use : Privacy Statement