| Both sides previous revision
Previous revision
|
|
cc:cc_web_import [2023/03/03 12:42]
dtucker |
cc:cc_web_import [2023/10/23 15:58] (current)
dtucker |
| |
| <WRAP center round info> | <WRAP center round info> |
| The Web Order Import data integration for TWBS Credit Card version 1.5 **does not** require that any information be encrypted for import. | The Web Order Import data integration for TWBS Credit Card version 1.5 is only designed for the importing of authorization transactions that **have not** been settled at the gateway. This process will **not** work if the authorization has already been settled by an outside method. |
| </WRAP> | </WRAP> |
| |
| <WRAP center round info> | <WRAP center round info> |
| The Web Order Import data integration for TWBS Credit Card version 1.5 is only designed for the importing of authorization transactions that **have not** been settled at the gateway. This process will **not** work if the authorization has already been settled by an outside method. | The fields that are required for settling an imported authorization and successfully creating an Incoming Payment in SAP for the transaction are highlighted in <color #ed1c24>Red Highlighted Text</color>. |
| </WRAP> | </WRAP> |
| |
| ^**User Defined Field Name**^**Data Type**^**Max. Length**^**Description**^^ | ^**User Defined Field Name**^**Data Type**^**Max. Length**^**Description**^^ |
| |TWBS_CC_TrxType |AlphaNumeric |10 |Payment type for credit card orders. This field should be populated with the value "CCWeb" to identify that this order and authorization came from an external source.|| | |<color #ed1c24>TWBS_CC_TrxType</color> |AlphaNumeric |10 |Payment type for credit card orders. This field should be populated with the value "CCWeb" to identify that this order and authorization came from an external source.|| |
| |TWBS_CC_CustProfileID |AlphaNumeric |20 |The Customer Profile ID value from the gateway of the business partner associated with the card used for the authorization transaction.|| | |TWBS_CC_CustProfileID |AlphaNumeric |20 |The Customer Profile ID value from the gateway of the business partner associated with the card used for the authorization transaction.|| |
| |TWBS_CC_PayProfileID |AlphaNumeric |20 |The Payment Profile ID value from the gateway of the card used for the authorization transaction.|| | |TWBS_CC_PayProfileID |AlphaNumeric |20 |The Payment Profile ID value from the gateway of the card used for the authorization transaction.|| |
| |TWBS_CC_CardLast4 |AlphaNumeric |4 |The last 4 digits of the number of the card used for the authorization transaction.|| | |<color #ed1c24>TWBS_CC_CardLast4</color> |AlphaNumeric |4 |The last 4 digits of the number of the card used for the authorization transaction.|| |
| |TWBS_CC_CardType |AlphaNumeric |30 |Type of the card used for the authorization transaction (i.e. Visa, MC, etc.) The value filled in this field should match a valid value in the Credit Card Setup screen in SAP® Business One. Note - The value imported to this field must be the Name value, not the Code value. This screen is located under the Administration Setup Banking Credit Card menu option.|| | |<color #ed1c24>TWBS_CC_CardType</color> |AlphaNumeric |30 |Type of the card used for the authorization transaction (i.e. Visa, MC, etc.) The value filled in this field should match a valid value in the Credit Card Setup screen in SAP® Business One. Note - The value imported to this field must be the Name value, not the Code value. This screen is located under the Administration Setup Banking Credit Card menu option.|| |
| |TWBS_CC_AuthTotal |AlphaNumeric |15 |Total amount of the authorization transaction. This amount should be rounded to 2 decimal places. Note - The value for the authorization total does not need to match the document total. However, if the authorization amount is less than the document total, the remaining balance will need to be paid though another transaction in SAP® Business One.|| | |<color #ed1c24>TWBS_CC_AuthTotal</color> |AlphaNumeric |15 |Total amount of the authorization transaction. This amount should be rounded to 2 decimal places. Note - The value for the authorization total does not need to match the document total. However, if the authorization amount is less than the document total, the remaining balance will need to be paid though another transaction in SAP® Business One.|| |
| |TWBS_CC_AuthExpDate |AlphaNumeric |10 |Expiration Date of the card used for the transaction. The formatting of the data in this field must use "MM/YY".|| | |<color #ed1c24>TWBS_CC_AuthExpDate</color> |AlphaNumeric |10 |Expiration Date of the card used for the transaction. The formatting of the data in this field must use "MM/YY".|| |
| |TWBS_CC_TrxID |AlphaNumeric |15 |Transaction ID Reference Number. This is the transaction id # returned by the payment gateway. Usually an 8-10 digit numeric value.|| | |<color #ed1c24>TWBS_CC_TrxID</color> |AlphaNumeric |15 |Transaction ID Reference Number. This is the transaction id # returned by the payment gateway. Usually an 8-10 digit numeric value.|| |
| |TWBS_CC_AuthCode |AlphaNumeric |15 |Authorization Reference Code. This is the authorization code returned by the payment provider. Usually a 6-8 character alphanumeric value.|| | |<color #ed1c24>TWBS_CC_AuthCode</color> |AlphaNumeric |15 |Authorization Reference Code. This is the authorization code returned by the payment provider. Usually a 6-8 character alphanumeric value.|| |
| |TWBS_CC_AuthDate |AlphaNumeric |10 |The date of the authorization transaction. The formatting of the data in this field must use "MM/DD/YY".|| | |<color #ed1c24>TWBS_CC_AuthDate</color> |AlphaNumeric |10 |The date of the authorization transaction. The formatting of the data in this field must use "MM/DD/YY".|| |
| |TWBS_CC_CardAddr1 |AlphaNumeric |30 |Address 1 information of the card holder of the card used for the transaction.|| | |TWBS_CC_CardAddr1 |AlphaNumeric |30 |Address 1 information of the card holder of the card used for the transaction.|| |
| |TWBS_CC_CardAddr2 |AlphaNumeric |30 |Address 2 information of the card holder of the card used for the transaction.|| | |TWBS_CC_CardAddr2 |AlphaNumeric |30 |Address 2 information of the card holder of the card used for the transaction.|| |
| |TWBS_CC_CardZip |AlphaNumeric |10 |Address postal code information of the card holder of the card used for the transaction.|| | |TWBS_CC_CardZip |AlphaNumeric |10 |Address postal code information of the card holder of the card used for the transaction.|| |
| |TWBS_CC_CardUID |AlphaNumeric |50 |A unique name for a payment profile stored on the gateway associated with the business partner. An example of this could be the card type and the last 4 digits of the card number ("Visa 1234").|| | |TWBS_CC_CardUID |AlphaNumeric |50 |A unique name for a payment profile stored on the gateway associated with the business partner. An example of this could be the card type and the last 4 digits of the card number ("Visa 1234").|| |
| |TWBS_CC_GWProfile |AlphaNumeric |200 |The gateway profile account unique name that the authorization was performed on by the outside software or website.|| | |<color #ed1c24>TWBS_CC_GWProfile</color> |AlphaNumeric |200 |The gateway profile account unique name that the authorization was performed on by the outside software or website.|| |
| |
| |
| | |
