Below is a list of all of the fields that are supported by the ConnectIt-Sage200 Document Item field &QWDI_ macros. In order to use these macros within the ConnectIt Configuration, the macro should be entered with the &QWDI_ prefix followed by the database field name. For example, to use the value from the CustomText01 field, then the macro should be entered as &QWDI_CustomText01.
The full list of field names available is as follows:
AlternateExtendedCost, AlternateExtendedList, AlternateExtendedPrice, AlternateSalesTax, AlternateShippingAmount, AlternateUnitCost, AlternateUnitList, AlternateUnitPrice, AttributesCustom, BackOrderedDate, BackOrderedQty, BackOrderExpectedDate, CloseProbability, CMOppRecID, Comment, CostModifier, CustomDate01, CustomDate02, CustomDate03, CustomDate04, CustomDate05, CustomMemo01, CustomMemo02, CustomMemo03, CustomMemo04, CustomMemo05, CustomNumber01, CustomNumber02, CustomNumber03, CustomNumber04, CustomNumber05, CustomText01, CustomText02, CustomText03, CustomText04, CustomText05, CustomText06, CustomText07, CustomText08, CustomText09, CustomText10, CustomText11, CustomText12, CustomText13, CustomText14, CustomText15, CustomText16, CustomText17, CustomText18, CustomText19, CustomText20, Description, DocID, DUI, ExtendedCost, ExtendedDescription, ExtendedList, ExtendedPrice, ExtendedWeight, ExtraDate01, ExtraDbl01, ExtraLng01, ExtraLogic01, ExtraMemo01, ExtraText01, ExtraText02, FontAttributes, Formula, GroupTag, ID, InternalPartNumber, ItemType, LineAttributes, LineNumber, LineType, ManufacturerPartNumber, Manufacturer, Notes, OrderDate, PONumber, PriceModifier, PriceProfile, QtyBase, QtyGroupMultiplier, QtyMultiplier1, QtyMultiplier2, QtyMultiplier3, QtyMultiplier4, QtyTotal, ReceivedDate, RecLastModified, ReplicationID, Result, SalesTax, SerialNumber, ShippingAmount, Style, Tag, TaxCode, TaxRate, UnitCost, UnitList, UnitOfMeasureFactor, UnitOfMeasure, UnitOfPricingFactor, UnitOfPricing, UnitPrice, UnitWeight, VendorPartNumber, Vendor
|
