Advanced Installation TopicsMS Dynamics AX 2009 Changes

MS Dynamics AX 2009 Changes

Sana Commerce 8.3
Your provider

Back Next

Modified Tables

The table below provides the description of the modified tables in Microsoft Dynamics AX, including the fields:

Table Name	Field ID	Field Name	Type	Description
EmplTable	50001	SC_LastModified	Real	Last date/time modified
ContactPerson	50001	SC_LastModified	Real	Last date/time modified
InventTxt	50001	SC_Name	String	Item name
InventDimCombination	50001	SC_VisibleInWebShop	Enum	Item visibility in the webshop
CustPackingSlipJour	50001	SC_BillToName	String	Bill to name
CustPackingSlipJour	50002	SC_PaymentMethod	String	Payment method name
CustPackingSlipJour	50003	SC_Comments	String	Comments
CustInvoiceJour	50001	SC_BillToName	String	Bill to name
CustInvoiceJour	50002	SC_PaymentMethod	String	Payment method name
CustInvoiceJour	50003	SC_Comments	String	Comments
SalesQuotationTable	50001	SC_OrderId	String	Sana order number
SalesQuotationTable	50002	SC_FieldsDictionary	String	Raw XML data
SalesQuotationTable	50003	SC_Comments	String	Comments
SalesQuotationTable	50004	SC_BillToName	String	Bill to name
SalesQuotationTable	50005	SC_PaymentMethod	String	Payment method name
SalesQuotationTable	50006	SC_PaymentStatus	String	Payment method status
SalesQuotationTable	50007	SC_PromotionCode	String	Promotion code
SalesQuotationTable	50008	SC_PromotionTitle	String	Promotion title
SalesQuotationTable	50009	SC_PromotionType	Enum	Promotion type
SalesQuotationTable	50010	SC_PromotionAmount	Real	Promotion discount amount
SalesQuotationTable	50011	SC_PromotionValue	Real	Promotion discount value
SalesQuotationTable	50012	SC_PromotionDiscPercent	Real	For internal use
SalesQuotationTable	50013	SC_SanaOrder	Enum	Order is made using E-Commerce system.
SalesQuotationTable	50014	SC_ShipmentMethodName	String	Shipment method name imported from SQL provider
SalesQuotationTable	50015	SC_ShopAccountCode	String	Sell-to shop account e-mail
SalesQuotationTable	50016	SC_TimeReceived	Time	Sana order time received
SalesQuotationTable	50017	SC_DateReceived	Date	Sana order date received
SalesQuotationTable	50018	SC_PaymentTransactionId	String	Payment transaction ID
SalesQuotationTable	50019	SC_WebshopId	String	Webshop ID
SalesQuotationLine	50001	SC_SuppItem	Enum	Supplementary item
MarkupTable	50001	SC_MarkupCode	String	For internal use
SalesTable	50001	SC_OrderId	String	Sana order number
SalesTable	50002	SC_FieldsDictionary	String	Raw XML data
SalesTable	50003	SC_Comments	String	Comments
SalesTable	50004	SC_BillToName	String	Bill to name
SalesTable	50005	SC_PaymentMethod	String	Payment method name
SalesTable	50006	SC_PaymentStatus	String	Payment method status
SalesTable	50007	SC_PromotionValue	Real	Promotion discount value
SalesTable	50008	SC_PromotionAmount	Real	Promotion discount amount
SalesTable	50009	SC_PromotionType	Enum	Promotion type
SalesTable	50010	SC_PromotionTitle	String	Promotion title
SalesTable	50011	SC_PromotionCode	String	Promotion code
SalesTable	50012	SC_PromotionDiscPercent	Real	For internal use
SalesTable	50013	SC_ShipmentMethodName	String	Shipment method name imported from SQL provider
SalesTable	50014	SC_SanaOrder	Enum	Order is made using E-Commerce system
SalesTable	50015	SC_DateReceived	Date	Sana order date received
SalesTable	50016	SC_TimeReceived	Time	Sana order time received
SalesTable	50017	SC_ShopAccountCode	String	Sell-to shop account e-mail
SalesTable	50018	SC_PaymentTransactionId	String	Payment transaction ID
SalesTable	50019	SC_WebshopId	String	Webshop ID
SalesLine	50001	SC_SuppItem	Enum	Supplementary item
AddressCountryRegion	50001	SC_VisibleInWebshop	Enum	Item visibility in the webshop
AddressCountryRegion	50002	SC_TemplateAccount	String	Customer template
InventItemGroup	50001	SC_VisibleInWebshop	Enum	Item group visibility in the webshop
InventItemGroup	50002	SC_SortNum	Integer	Order number in the webshop left menu
CustTable	50001	SC_B2cCustomer	Enum	Defines whether a customer is B2C
CustTable	50002	SC_ImportCustNum	String	Sana customer number
CustTable	50003	SC_lastModified	Real	Last date/time modified
InventTable	50001	SC_VisibleInWebShop	Enum	Item visibility in the webshop
InventTable	50002	SC_LastModified	Real	Last date/time modified

Back Next

Advanced Installation TopicsMS Dynamics AX 2009 Changes

Sitemap

Installation

Product Versions

Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.

Sana Commerce – the integrated e-Commerce solution for Microsoft Dynamics NAV & AX

Updated: January 2014