Customer data mapping

A common XML is used to communicate with external systems.

The following shows the common XML:


<Customer OrganizationCode="" Operation="" CustomerType="">
   <CustomerContactList >
      <CustomerContact DayFaxNo="" DayPhone="" EmailID="" 
EveningFaxNo=""
EveningPhone="" FirstName="" LastName="" MobilePhone="" 
Title="" UserID="">
         <CustomerAdditionalAddressList Reset="y" >
            <CustomerAdditionalAddress 
CustomerAdditionalAddressID="" IsShipTo=""
IsBillTo="" IsSoldTo="" IsDefaultShipTo="" IsDefaultBillTo=""
IsDefaultSoldTo="">
               <PersonInfo AddressLine1="" AddressLine2="" 
AddressLine3="" City="" Country=""
State="" ZipCode="" />
               </CustomerAdditionalAddress>
            </CustomerAdditionalAddressList>
            <CustomerPaymentMethodList Reset="Y">
               <CustomerPaymentMethod CreditCardExpDate="" 
FirstName=""
MiddleName="" LastName="" CreditCardNo="" CreditCardType=""
PaymentType="" IsDefaultMethod="" />
            </CustomerPaymentMethodList>
      </CustomerContact>
   </CustomerContactList>
</Customer>

Database fields for customer data mapping

These are the database fields for Customer Data Mapping:

Sterling™ Order Management System Software Database Fields
YFS_CUSTOMER_CONTACT.USER_ID
YFS_CUSTOMER_CONTACT.LAST_NAME
YFS_CUSTOMER_CONTACT.FIRST_NAME
YFS_CUSTOMER_CONTACT.TITLE
YFS_CUSTOMER_CONTACT.EMAILID
YFS_CUSTOMER_PAYMENT_METHOD.PAYMENT_TYPE
YFS_CUSTOMER_PAYMENT_METHOD.CREDIT_CARD_NO
YFS_CUSTOMER_PAYMENT_METHOD.CREDIT_CARD_EXP_DATE
YFS_CUSTOMER_PAYMENT_METHOD.CREDIT_CARD_TYPE
YFS_CUSTOMER_PAYMENT_METHOD.FIRST_NAME
YFS_CUSTOMER_PAYMENT_METHOD.MIDDLE_NAME
YFS_CUSTOMER_PAYMENT_METHOD.LAST_NAME
YFS_CUSTOMER.ORGANIZATION_CODE
YFS_PERSON_INFO.ADDRESS_LINE1
YFS_PERSON_INFO.ADDRESS_LINE2
YFS_PERSON_INFO.ADDRESS_LINE3
YFS_PERSON_INFO.CITY
YFS_PERSON_INFO.ZIP_CODE
YFS_PERSON_INFO.STATE
YFS_PERSON_INFO.COUNTRY
YFS_CUSTOMER_ADDNL_ADDRESS.IS_SOLD_TO
YFS_CUSTOMER_ADDNL_ADDRESS.IS_SHIP_TO
YFS_CUSTOMER_ADDNL_ADDRESS.IS_BILL_TO
YFS_CUSTOMER_ADDNL_ADDRESS.IS_DEFAULT_SOLD_TO
YFS_CUSTOMER_ADDNL_ADDRESS.IS_DEFAULT_SHIP_TO
YFS_CUSTOMER_ADDNL_ADDRESS.IS_DEFAULT_BILL_TO
YFS_CUSTOMER_CONTACT.<tablename> Note: The <table_name> column is determined by the value of the CMGT_PHONES.PHONE_TYPE_CODE column. The customer phone number is then stored in this column.

Note: Extended attributes can be provided under the /Item/@Extn element.