FDMSLevel2 Control

Properties   Methods   Events   Config Settings   Errors  

The FDMSLevel2 control is a tool used to create Level2 Corporate Purchasing Card addendum aggregates, which can then be passed to the FDMSSETTLE control and settled.

Syntax

FDMSLevel2

Remarks

The properties required to build a Level 2 addendum depends upon the value of the CardType property. The following tables indicate which properties are valid for what card type:

American Express

• DestinationZip (required)
• PurchaseIdentifier (required)
• TaxAmount (required)

Visa

• PurchaseIdentifier (required)
• CommercialCardType (optional)
• InvoiceNumber (optional)
• DestinationCountry (optional)
• DestinationZip (optional)
• DiscountAmount (optional)
• DutyAmount (optional)
• FreightAmount (optional)
• FreightTaxAmount (optional)
• FreightTaxRate (optional)
• MerchantReference (optional)
• OrderDate (optional)
• ShippedFromZip (optional)
• TaxAmount (optional)

MasterCard

• MerchantTaxId (required)
• MerchantType (required)
• PurchaseIdentifier (required)
• TaxAmount (required)
• CommercialCardType (optional)
• DestinationCountry (optional)
• DestinationState (optional)
• DestinationZip (optional)
• DutyAmount (optional)
• FreightAmount (optional)
• MerchantReference (optional)
• ShippedFromZip (optional)

The following example illustrates how to add Level 2 data to a transaction to be settled:

FDMSECommerce.Authorize() FDMSLevel2.CardType = fctVisa FDMSLevel2.CommercialCardType = FDMSECommerce.ResponseCommercialCard FDMSLevel2.OrderDate = "060828" 'September 28th, 2006 FDMSLevel2.FreightTaxAmount = "0" FDMSLevel2.FreightAmount = "600" FDMSLevel2.PurchaseIdentifier = "123456PURCHID" FDMSLevel2.InvoiceNumber = "CUSTCODE" FDMSLevel2.ShippedToZip = "90210" FDMSLevel2.ShippedFromZip = "90210" FDMSLevel2.TaxAmount = "120" FDMSSettle.DetailRecordCount = 1 FDMSSettle.DetailRecordAggregate(0) = FDMSECommerce.GetDetailAggregate() FDMSSettle.DetailRecordAddendum(0) = FDMSLevel2.GetAddendum()

Note that while Level 2 addendum data is only applicable to corporate purchasing cards, you may send Level 2 data for all Visa, Master Card, and American Express cards if you wish.

Property List

---

The following is the full list of the properties of the control with short descriptions. Click on the links for further details.

Method List

---

The following is the full list of the methods of the control with short descriptions. Click on the links for further details.

Event List

---

The following is the full list of the events fired by the control with short descriptions. Click on the links for further details.

Config Settings

---

The following is a list of config settings for the control with short descriptions. Click on the links for further details.

CardType Property (FDMSLevel2 Control)

The card type for which a Level 2 or Level 3 addendum will be created.

Syntax

fdmslevel2control.CardType[=integer]

Possible Values

fctUnknown(0), 
fctVisa(1), 
fctMasterCard(2), 
fctAmericanExpress(3)

Default Value

0

Remarks

The value of this property MUST correspond to the card number that is to be settled in the detail record (to which this addendum is associated). Valid values for this property include:

Data Type

Integer

CommercialCardType Property (FDMSLevel2 Control)

Indicates the type of commercial card being settled.

Syntax

fdmslevel2control.CommercialCardType[=integer]

Possible Values

fccNotCommercial(0), 
fccPurchaseCard(1), 
fccCorporateCard(2), 
fccBusinessCard(3), 
fccUnknown(4)

Default Value

0

Remarks

Business, corporate, and purchasing cards are subsets of commercial cards. Therefore, the user should send Level 2 (and possibly Level 3) data in the settlement when this property indicates a commercial card was used. The following table indicates the type of commercial card:

Note: Commercial card transactions settled with Level 2 or Level 3 data must include tax amounts to receive the best interchange rate.

This property is used for both Visa and MasterCard Corporate Purchasing Cards.

Data Type

Integer

DestinationCountry Property (FDMSLevel2 Control)

Country the goods are to be shipped to.

Syntax

fdmslevel2control.DestinationCountry[=string]

Default Value

""

Remarks

For Visa and MasterCard transactions, this property contains the three-digit numeric code of the country where the goods are being shipped. These codes are specified by ISO-3166. For the United States, use "840".

The maximum length of this property is 3 characters.

This property is used for both Visa and MasterCard Corporate Purchasing Cards.

Data Type

String

DestinationState Property (FDMSLevel2 Control)

State or province to which the goods are to be shipped.

Syntax

fdmslevel2control.DestinationState[=string]

Default Value

""

Remarks

This property contains the State or Province where purchased goods will be delivered. The maximum length of this property is 3 characters. This property is only used for MasterCard Corporate Purchasing Cards.

Data Type

String

DestinationZip Property (FDMSLevel2 Control)

The zip code to which the commodity was shipped.

Syntax

fdmslevel2control.DestinationZip[=string]

Default Value

""

Remarks

If the ship-to zip code is not available, or the customer purchased the item in person (Card-present transaction), this property should be defaulted to the zip code of the merchant where the purchase took place. In this case, both DestinationZip and ShippedFromZip should be identical.

The maximum length for this property is 10 characters.

This property is used for Visa, MasterCard, and American Express Corporate Purchasing Cards.

Data Type

String

DiscountAmount Property (FDMSLevel2 Control)

Amount of any discount subtracted from the line item totals.

Syntax

fdmslevel2control.DiscountAmount[=string]

Default Value

""

Remarks

This property contains the amount of any discount applied to the transaction by the merchant. This field should be empty if no line item discount applies, or if Level 3 data is attached to the transaction, and contains discount amounts for individual items on an item-by-item basis.

This amount is to be presented with an implied decimal point. For example, US $10.00 must be represented as 1000, and $0.10 is likewise simply 10. The allowable number of significant digits as well as the positioning of any implied decimal point is dictated by the designated CurrencyCode configuration setting. In the United States (default), the number of allowable significant digits is seven. Thus the maximum TransactionAmount is "9999999", yielding a US dollar amount of $99,999.99. This field may not contain a negative number.

This property is only used for Visa Corporate Purchasing Cards.

Data Type

String

DutyAmount Property (FDMSLevel2 Control)

Duty fees (if any) for imported goods.

Syntax

fdmslevel2control.DutyAmount[=string]

Default Value

""

Remarks

This property contains the fee amount associated with the import of the purchased goods.

This amount is to be presented with an implied decimal point. For example, US $10.00 must be represented as 1000, and $0.10 is likewise simply 10. The allowable number of significant digits as well as the positioning of any implied decimal point is dictated by the designated CurrencyCode configuration setting. In the United States (default), the number of allowable significant digits is seven. Thus the maximum TransactionAmount is "9999999", yielding a US dollar amount of $99,999.99. This field may not contain a negative number.

This property is used for both Visa and MasterCard Corporate Purchasing Cards.

Data Type

String

FreightAmount Property (FDMSLevel2 Control)

Shipping charges associated with this transaction.

Syntax

fdmslevel2control.FreightAmount[=string]

Default Value

""

Remarks

This property contains the freight or shipping portion of the total transaction amount.

This amount is to be presented with an implied decimal point. For example, US $10.00 must be represented as 1000, and $0.10 is likewise simply 10. The allowable number of significant digits as well as the positioning of any implied decimal point is dictated by the designated CurrencyCode configuration setting. In the United States (default), the number of allowable significant digits is seven. Thus the maximum TransactionAmount is "9999999", yielding a US dollar amount of $99,999.99. This field may not contain a negative number.

This property is used for both Visa and MasterCard Corporate Purchasing Cards.

Data Type

String

FreightTaxAmount Property (FDMSLevel2 Control)

Portion of the FreightAmount that is tax.

Syntax

fdmslevel2control.FreightTaxAmount[=string]

Default Value

""

Remarks

This property contains the amount of any Value Added Taxes (VAT) which can be associated with the freight or shipping charges of the overall purchase.

This amount is to be presented with an implied decimal point. For example, US $10.00 must be represented as 1000, and $0.10 is likewise simply 10. The allowable number of significant digits as well as the positioning of any implied decimal point is dictated by the designated CurrencyCode configuration setting. In the United States (default), the number of allowable significant digits is seven. Thus the maximum TransactionAmount is "9999999", yielding a US dollar amount of $99,999.99. This field may not contain a negative number.

This property is only used for Visa Corporate Purchasing Cards.

Data Type

String

FreightTaxRate Property (FDMSLevel2 Control)

Rate used to calculate the FreightTaxAmount .

Syntax

fdmslevel2control.FreightTaxRate[=string]

Default Value

""

Remarks

This property contains the tax rate used to calculate the FreightTaxAmount. This field has a two-digit implied decimal position, and the maximum length is 4 digits.

This property is only used for Visa Corporate Purchasing Cards.

Data Type

String

InvoiceNumber Property (FDMSLevel2 Control)

Customer Reference Identifier.

Syntax

fdmslevel2control.InvoiceNumber[=string]

Default Value

""

Remarks

This property contains the Customer Reference Indicator, used by the customer to identify the purchase (e.g., the invoice number). The maximum length of this property is 17 characters.

This property is only used for Visa Corporate Purchasing Cards.

Data Type

String

MerchantReference Property (FDMSLevel2 Control)

Merchant Reference Number.

Syntax

fdmslevel2control.MerchantReference[=string]

Default Value

""

Remarks

For Master Card, this property contains the code that facilitates merchant/corporation communication and record keeping. For Visa, this property contains the invoice number associated with the VAT invoice (not applicable in the US).

The maximum length of this property is 15 characters for Visa and 17 characters for MasterCard.

This property is used for both Visa and MasterCard Corporate Purchasing Cards.

Data Type

String

MerchantTaxId Property (FDMSLevel2 Control)

Merchant's government tax Id number.

Syntax

fdmslevel2control.MerchantTaxId[=string]

Default Value

""

Remarks

This property contains the government-assigned tax identification number of the merchant from whom the goods or services were purchased.

The maximum length of this property is 15 characters. This property is only used for MasterCard Corporate Purchasing Cards.

Data Type

String

MerchantType Property (FDMSLevel2 Control)

MasterCard merchant classification code.

Syntax

fdmslevel2control.MerchantType[=string]

Default Value

"0000"

Remarks

Merchant Type is a four-position field defined by MasterCard that describes various merchant classifications. Each position in the field has a separate, special meaning for categorizing the merchant. If the data for a particular position is not available, that position must contain a blank. If it is available, it must contain one of the following business codes:

Position 1 - Business Classification

Position 2 - Type of Business Owner Classification

Position 3 - Minority, Small Business, Disadvantaged Certification

Position 4 - Racial or Ethnic Type (Unconditional Majority Owner)

The maximum length of this property is 4 characters. This property is only used for MasterCard Corporate Purchasing Cards.

Data Type

String

OrderDate Property (FDMSLevel2 Control)

Date of the order in YYMMDD format.

Syntax

fdmslevel2control.OrderDate[=string]

Default Value

""

Remarks

This property contains the purchase order date, and must be supplied in the YYMMDD format.

The maximum length of this field is 6 digits.

This property is only used for Visa Corporate Purchasing Cards.

Data Type

String

PurchaseIdentifier Property (FDMSLevel2 Control)

Used to identify the purchase.

Syntax

fdmslevel2control.PurchaseIdentifier[=string]

Default Value

""

Remarks

This field is required for Visa, MasterCard and Amex Level2 transactions.For Visa this field should contain a merchant assigned value to identify the purchase such as the SKU number. For MasterCard this field should contain the code that was supplied to the merchant by the cardholder. For Amex this field should contain the customer reference number. The maximum length of this property is 25 characters.

Data Type

String

ShippedFromZip Property (FDMSLevel2 Control)

Zip code the goods are being shipped from.

Syntax

fdmslevel2control.ShippedFromZip[=string]

Default Value

""

Remarks

This property contains the Postal/Zip code of the address from where the purchased goods are being shipped.

The maximum length of this property is 10 characters.

This property is used for both Visa and MasterCard Corporate Purchasing Cards.

Data Type

String

TaxAmount Property (FDMSLevel2 Control)

Sales tax charged in addition to the original TransactionAmount .

Syntax

fdmslevel2control.TaxAmount[=string]

Default Value

""

Remarks

This property contains the amount of state or provincial (or VAT) tax included in the transaction amount. Any non-zero sales tax must have a minimum value of 0.1% and a maximum value of 22% of the sale amount.

This amount is to be presented with an implied decimal point. For example, US $10.00 must be represented as 1000, and $0.10 is likewise simply 10. The allowable number of significant digits as well as the positioning of any implied decimal point is dictated by the designated CurrencyCode configuration setting. In the United States (default), the number of allowable significant digits is seven. Thus the maximum TransactionAmount is "9999999", yielding a US dollar amount of $99,999.99. This field may not contain a negative number.

This property is used for Visa, MasterCard, and American Express Corporate Purchasing Cards.

Data Type

String

Config Method (FDMSLevel2 Control)

Sets or retrieves a configuration setting.

Syntax

fdmslevel2control.Config ConfigurationString

Remarks

Config is a generic method available in every control. It is used to set and retrieve configuration settings for the control.

These settings are similar in functionality to properties, but they are rarely used. In order to avoid "polluting" the property namespace of the control, access to these internal properties is provided through the Config method.

To set a configuration setting named PROPERTY, you must call Config("PROPERTY=VALUE"), where VALUE is the value of the setting expressed as a string. For boolean values, use the strings "True", "False", "0", "1", "Yes", or "No" (case does not matter).

To read (query) the value of a configuration setting, you must call Config("PROPERTY"). The value will be returned as a string.

GetAddendum Method (FDMSLevel2 Control)

Returns a Level 2 Purchasing card addendum based on the specified CardType .

Syntax

fdmslevel2control.GetAddendum 

Remarks

The properties required to build a Level 2 addendum depends upon the value of the CardType property. The following tables indicate which properties are valid for what card type:

American Express

• DestinationZip (required)
• PurchaseIdentifier (required)
• TaxAmount (required)

Visa

• PurchaseIdentifier (required)
• CommercialCardType (optional)
• InvoiceNumber (optional)
• DestinationCountry (optional)
• DestinationZip (optional)
• DiscountAmount (optional)
• DutyAmount (optional)
• FreightAmount (optional)
• FreightTaxAmount (optional)
• FreightTaxRate (optional)
• MerchantReference (optional)
• OrderDate (optional)
• ShippedFromZip (optional)
• TaxAmount (optional)

MasterCard

• MerchantTaxId (required)
• MerchantType (required)
• PurchaseIdentifier (required)
• TaxAmount (required)
• CommercialCardType (optional)
• DestinationCountry (optional)
• DestinationState (optional)
• DestinationZip (optional)
• DutyAmount (optional)
• FreightAmount (optional)
• MerchantReference (optional)
• ShippedFromZip (optional)

The following example illustrates how to add Level 2 data to a transaction to be settled:

FDMSECommerce.Authorize() FDMSLevel2.CardType = fctVisa FDMSLevel2.CommercialCardType = FDMSECommerce.ResponseCommercialCard FDMSLevel2.OrderDate = "060828" 'September 28th, 2006 FDMSLevel2.FreightTaxAmount = "0" FDMSLevel2.FreightAmount = "600" FDMSLevel2.PurchaseIdentifier = "123456PURCHID" FDMSLevel2.InvoiceNumber = "CUSTCODE" FDMSLevel2.ShippedToZip = "90210" FDMSLevel2.ShippedFromZip = "90210" FDMSLevel2.TaxAmount = "120" FDMSSettle.DetailRecordCount = 1 FDMSSettle.DetailRecordAggregate(0) = FDMSECommerce.GetDetailAggregate() FDMSSettle.DetailRecordAddendum(0) = FDMSLevel2.GetAddendum()

Reset Method (FDMSLevel2 Control)

Clears all properties to their default values.

Syntax

fdmslevel2control.Reset 

Remarks

This method clears all properties to their default values.

Error Event (FDMSLevel2 Control)

Information about errors during data delivery.

Syntax

Sub fdmslevel2control_Error(ErrorCode As Integer, Description As String)

Remarks

The Error event is fired in case of exceptional conditions during message processing. Normally the control fails with an error.

ErrorCode contains an error code and Description contains a textual description of the error. For a list of valid error codes and their descriptions, please refer to the Error Codes section.

Config Settings (FDMSLevel2 Control)

The control accepts one or more of the following configuration settings. Configuration settings are similar in functionality to properties, but they are rarely used. In order to avoid "polluting" the property namespace of the control, access to these internal properties is provided through the Config method.

Base Config Settings

Trappable Errors (FDMSLevel2 Control)

FDMSLevel2 Errors

	20502    Data field invalid length.
	20503    Data field invalid format.
	20504    Data field out of range.
	20606    Invalid CardType.