Transaction Fields
|
Transaction.WrntyID
|
Transaction.ExternalID
|
Transaction.Type
|
Transaction.Status
|
Transaction.CreationDate
|
Transaction.CreationDateTime
|
Transaction.ModificationDateTime
|
Transaction.Date
|
Transaction.ActionDateTime
|
Transaction.DeliveryDate
|
Transaction.Remark
|
Transaction.Deleted
|
Transaction.Signature
|
Transaction.Currency
|
Transaction.TotalItemsCount
|
Transaction.SubTotal
|
Transaction.SubTotalAfterItemsDiscount
|
Transaction.GrandTotal
|
Transaction.TotalsBox
|
Transaction.DiscountPercentage
|
Transaction.TaxPercentage
|
Transaction.BillToName
|
Transaction.BillToStreet
|
Transaction.BillToCity
|
Transaction.BillToState
|
Transaction.BillToCountry
|
Transaction.BillToZipCode
|
Transaction.BillToFax
|
Transaction.BillToPhone
|
Transaction.BillToAddress
|
Transaction.ShipToExternalID
|
Transaction.ShipToName
|
Transaction.ShipToStreet
|
Transaction.ShipToCity
|
Transaction.ShipToState
|
Transaction.ShipToCountry
|
Transaction.ShipToZipCode
|
Transaction.ShipToFax
|
Transaction.ShipToPhone
|
Transaction.ShipToAddress
|
Transaction.Branch
|
Transaction.ContactPersonList
|
Transaction.SubmissionGeoCodeLAT
|
Transaction.SubmissionGeoCodeLNG
|
Transaction.CreationGeoCodeLAT
|
Transaction.CreationGeoCodeLNG
|
Transaction.AccountWrntyID
|
Transaction.ContactPersonWrntyID
|
Transaction.Agent.WrntyID
|
Transaction.CatalogWrntyID
|
Transaction.ActivityTypeID
|
Transaction.CurrencyID
|
Transaction.CurrencySymbol
|
Transaction.AccountExternalID
|
Transaction.OriginAccountWrntyID
|
Item Fields
|
Item.WrntyID
|
Item.ExternalID
|
Item.MainCategory
|
Item.MainCategoryCode
|
Item.Code
|
Item.UPC
|
Item.Name
|
Item.LongDescription
|
Item.Inactive
|
Item.Image
|
Item.ParentImage
|
Item.ColorImage
|
Item.Price
|
Item.PriceListWholeSalePrice
|
Item.SecondaryPrice
|
Item.CostPrice
|
Item.Discount
|
Item.CampaignName
|
Item.CampaignDescription
|
Item.FixedPrice
|
Item.IgnoreDiscount
|
Item.QuantitySelector
|
Item.AllowDecimal
|
Item.CaseQuantity
|
Item.MinimumQuantity
|
Item.InStockQuantity
|
Item.AccountInStockQuantity
|
Item.FutureAvailabilityQuantity
|
Item.FutureAvailabilityDate
|
Item.ParentCode
|
Item.ParentExternalID
|
Item.Dimension1Code (Color code)
|
Item.Dimension1Name (Color name)
|
Item.Dimension2Code (Size code)
|
Item.Dimension2Name (Size name)
|
Item.Dimension2Group (Size group)
|
Item.Prop5
|
Item.Prop8
|
Item.Prop4
|
Item.Prop1
|
Item.Prop9
|
Item.Prop7
|
Item.Prop6
|
Item.Prop3
|
Item.Prop2
|
Item.Hidden
|
Item.ColorWrntyID
|
Item.SizeWrntyID
|
Item.Boolean[0-64]
|
Item.BoolFieldsBitMask
|
Item.ParentWrntyID
|
Item.ParentExID
|
Item.PortfolioWrntyID
|
Item.BrandWrntyID
|
Transaction Line Item Fields
|
TransactionLine.WrntyID
|
TransactionLine.Hidden
|
TransactionLine.UnitDiscountPercentage
|
TransactionLine.UnitPriceAfterDiscount
|
TransactionLine.TotalUnitsPriceBeforeDiscount
|
TransactionLine.TotalUnitsPriceAfterDiscount
|
TransactionLine.DeliveryDate
|
TransactionLine.UOMQuantity
|
TransactionLine.UOM
|
TransactionLine.TransactionWrntyID
|
TransactionLine.LineNumber
|
TransactionLine.SetName
|
TransactionLine.ItemWrntyID
|
TransactionLine.Image
|
TransactionLine.ParentImage
|
TransactionLine.ColorImage
|
TransactionLine.UnitsQuantity
|
TransactionLine.UnitPrice
|
TransactionLine.ItemExternalID
|
TransactionLine.IsFixedDiscount
|
TransactionLine.IsFixedUnitPriceAfterDiscount
|
TransactionLine.CreationDateTime
|
TransactionLine.UnitFinalPrice
|
Account Fields
|
Transaction.Account.WrntyID
|
Transaction.Account.ExternalID
|
Transaction.Account.CreationDate
|
Transaction.Account.Name
|
Transaction.Account.Phone
|
Transaction.Account.Mobile
|
Transaction.Account.Fax
|
Transaction.Account.Email
|
Transaction.Account.GovID
|
Transaction.Account.Note
|
Transaction.Account.IsActive
|
Transaction.Account.HasVos
|
Transaction.Account.Deleted
|
Transaction.Account.ParentExternalID
|
Transaction.Account.ParentName
|
Transaction.Account.LastActivity
|
Transaction.Account.NextPlannedActivity
|
Transaction.Account.Address
|
Transaction.Account.Street
|
Transaction.Account.City
|
Transaction.Account.State
|
Transaction.Account.Country
|
Transaction.Account.ZipCode
|
Transaction.Account.Discount
|
Transaction.Account.PriceLevelName
|
Transaction.Account.SpecialPriceListName
|
Transaction.Account.Debts30
|
Transaction.Account.Debts60
|
Transaction.Account.Debts90
|
Transaction.Account.DebtsAbove90
|
Transaction.Account.Prop1
|
Transaction.Account.Prop2
|
Transaction.Account.Prop3
|
Transaction.Account.Prop4
|
Transaction.Account.Prop5
|
Transaction.Account.Locations
|
Transaction.Account.ContactPersons
|
Transaction.Account.Agents
|
Transaction.Account.Buyers
|
Transaction.Account.PriceListWrntyID
|
Transaction.Account.SpecialPriceListWrntyID
|
Transaction.Account.StateISOAlpha2Code
|
Transaction.Account.StateID
|
Transaction.Account.CountryISOAlpha2Code
|
Transaction.Account.CountryID
|
Transaction.Account.ParentWrntyID
|
Transaction.Account.TypeDefinitionID
|
Transaction.Account.Type
|
Transaction.Account.ParentExID
|
PriceLevel.WrntyID
|
PriceLevel.ExternalID
|
PriceLevel.Hidden
|
PriceLevel.Description
|
PriceLevel.SubType
|
PriceLevel.CurrencyID
|
PriceLevel.CurrencySymbol
|
PriceLevelItem.WrntyID
|
PriceLevelItem.PriceListWrntyID
|
PriceLevelItem.ItemWrntyID
|
PriceLevelItem.Hidden
|
PriceLevelItem.Price
|
Transaction.Catalog.WrntyID
|
Transaction.Catalog.ID
|
Transaction.Catalog.Description
|
Transaction.Catalog.CreationDate
|
Transaction.Catalog.IsActive
|
Transaction.Catalog.ExpirationDate
|
Transaction.Catalog.PriceFactor
|
Transaction.Catalog.ExternalID
|
Transaction.Catalog.Hidden
|
0 comments
Please sign in to leave a comment.