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.AgentWrntyID
|
|
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.