Advanced Installation TopicsMS Dynamics AX 2012 Changes

MS Dynamics AX 2012 Changes

Sana Commerce 8.2
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
HcmWorker	60001	SC_LastModified	Real	Last date/time modified
ContactPerson	60001	SC_LastModified	Real	Last date/time modified
InventDimCombination	60001	SC_VisibleInWebShop	Enum	Item visibility in the webshop
EcoResProductRelationTable	60001	SC_SortNum	String	Sorting number
LogisticsAddressCountryRegion	60001	SC_TemplateAccount	String	Customer template
LogisticsAddressCountryRegion	60002	SC_VisibleInWebshop	Enum	Item visibility in webshop
CustInvoiceJour	60007	SC_BillToName	String	Bill to name
CustInvoiceJour	60008	SC_Comments	String	Comments
CustInvoiceJour	60009	SC_PaymentMethod	String	Payment method name
CustPackingSlipJour	60005	SC_BillToName	String	Bill to name
CustPackingSlipJour	60006	SC_Comments	String	Comments
CustPackingSlipJour	60007	SC_PaymentMethod	String	Payment method name
CustTable	60017	SC_B2cCustomer	Enum	Determines whether a customer is B2C
CustTable	60018	SC_ImportCustNum	String	Sana customer number
CustTable	60019	SC_LastModofied	Real	Last date/time modified
InventItemGroup	60001	SC_SortNum	Integer	Sorting number
InventItemGroup	60002	SC_VisibleInWebshop	Enum	Item group visibility in the webshop
MarkupTable	60002	SC_MarkupCode	String	For internal use
SalesQuotationTable	60009	SC_BillToName	String	Bill to name
SalesQuotationTable	60010	SC_Comments	String	Comments
SalesQuotationTable	60011	SC_DateReceived	Date	Sana order date received
SalesQuotationTable	60012	SC_FieldsDictionary	String	Raw XML data
SalesQuotationTable	60013	SC_OrderId	String	Sana order number
SalesQuotationTable	60014	SC_PaymentMethod	String	Payment method name
SalesQuotationTable	60015	SC_PaymentStatus	String	Payment method status
SalesQuotationTable	60016	SC_PaymentTransactionId	String	Payment transaction ID
SalesQuotationTable	60017	SC_PromotionAmount	Real	Promotion discount amount
SalesQuotationTable	60018	SC_PromotionCode	String	Promotion code
SalesQuotationTable	60019	SC_PromotionDiscPercent	Real	For internal use
SalesQuotationTable	60020	SC_PromotionTitle	String	Promotion title
SalesQuotationTable	60021	SC_PromotionType	Enum	Promotion type
SalesQuotationTable	60022	SC_PromotionValue	Real	Promotion discount value
SalesQuotationTable	60023	SC_SanaOrder	Enum	Sana quotation
SalesQuotationTable	60024	SC_ShipmentMethodName	String	Sana shipment method name
SalesQuotationTable	60025	SC_ShopAccountCode	String	Sell-to shop account e-mail
SalesQuotationTable	60026	SC_TimeReceived	Time	Sana order time received
SalesQuotationTable	60027	SC_WebShopId	String	Webshop ID
SalesTable	60015	SC_BillToName	String	Bill to name
SalesTable	60016	SC_Comments	String	Comments
SalesTable	60017	SC_DateReceived	Date	Sana order date received
SalesTable	60018	SC_FieldsDictionary	String	Raw XML data
SalesTable	60019	SC_OrderId	String	Sana order number
SalesTable	60020	SC_PaymentMethod	String	Payment method name
SalesTable	60021	SC_PaymentStatus	String	Payment method status
SalesTable	60022	SC_PaymentTransactionId	String	Payment transaction ID
SalesTable	60023	SC_PromotionAmount	Real	Promotion discount amount
SalesTable	60024	SC_PromotionCode	String	Promotion code
SalesTable	60025	SC_PromotionDiscPercent	Real	For internal use
SalesTable	60026	SC_PromotionTitle	String	Promotion title
SalesTable	60027	SC_PromotionType	Enum	Promotion type
SalesTable	60028	SC_PromotionValue	Real	Promotion discount value
SalesTable	60029	SC_SanaOrder	Enum	Sana order
SalesTable	60030	SC_ShipmentMethodName	String	Sana shipment method name
SalesTable	60031	SC_ShopAccountCode	String	Sell-to shop account e-mail
SalesTable	60032	SC_TimeReceived	Time	Sana order time received
SalesTable	60033	SC_WebShopId	String	Webshop ID
SalesLine	60018	SC_SuppItem	Enum	Supplementary item
SalesQuotationLine	60011	SC_SuppItem	Enum	Supplementary item
InventTable	60019	SC_LastModified	Real	Last date/time modified
InventTable	60020	SC_VisibleInWebShop	Enum	Item visibility in the webshop

Back Next

Advanced Installation TopicsMS Dynamics AX 2012 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 2013