SalesPad Support Hours

8am-5pm EST Monday-Thursday

8am-4pm EST Friday

Start a conversation

SDK

Important Notice

After October 29, 2019, SalesPad will no longer be supporting CardControl. Additionally, the application will cease to be a PA-DSS validated solution as of this date, and therefore CardControl customers would no longer be PCI compliant. 

Instead, SalesPad Desktop now offers built-in credit card processing via Nodus PayFabric. If you have questions or want more information on our credit card processing services, please contact your sales rep.


Overview

This document gives an overview of how to use both SOAP and REST services of the web API of CardControl. The document begins with an overview of the objects involved, progresses to the functions that operate on those objects, and then gives detailed examples of common usage.

Directory

Objects and their members CustomerCreditCard Customer

InOutDocument CreditCardTransaction SalesDocument SalesLineItem

Functions

Credit Card Functions Customer Functions Transaction Functions

C# SOAP Examples

Initial Server Configuration Example Create Customer Example

Read Customer Example Update Customer Example Delete Customer Example Creating a Customer Credit Card

Getting a Customer’s Credit Card List

Getting the Transactions Made by a Customer

Getting the Transactions Made Between Any Two Dates Processing an Authorization-Only Request

Processing a Capture Request on a Previous Authorization-Only Processing a Void Request on a Previous Transaction Processing a Credit Request

Specific Use Case Examples

XML Serialized Object Examples for the REST API Http Verbs

Valid Rowstate Values for Externally Serialized Objects HTTP Headers

Customer Object Credit Card Object

Authorization-only Request

The Response from the above Authorization-Only Request A Charge Request

The Response from the above Charge Request Charge Request with Sales Document

Objects
CustomerCreditCard

Element

Type

Description

CC_ID

Int32

Unique ID automatically generated when a card is saved.

Customer_Num

String

Unique customer ID.

CC_Number_Masked

String

Masked credit card number (XXXX- XXXX-XXXX-0000).

CC_Type

String

Full name of the credit card type (Mastercard, Visa).

CC_Number_Secure

String

Encrypted Credit Card Number or Token ID.

CC_Expiration_Date

DateTime

Expiration date of the credit card (MM/YY).

Cardholder_Name

String

Name of the card holder.

Cardholder_Street_Address

String

Street address specified in the card billing address.

Cardholder_City

String

City specified in the card billing address.

Cardholder_State

String

State specified in the card billing address.

Cardholder_Zip

String

Zip code specified in the card billing address.

Cardholder_Country

String

Country specified in the card billing address.

Cardholder_Country_Code

String

Country code specified in the card billing address.

Cardholder_Phones

String

Whitespace delimited list of card holder phone numbers, maximum amount three.

CC_Description

String

Description of the credit card.

IsDefault

Boolean

Designates whether or not this is the default card for the associated customer.

Type

Int (Enum)

Designates whether or not this is a credit card or a token.

-Possible values:

  • 0 : CreditCard
  • 1 : Token

TokenStorage

Int32

ID of the processor associated with this token.

Card_Type: Enum

Int

Two character abbreviation of the CC_Type (MC, VI).

-Possible values:

  • 0 : Unknown
  • 1 : NotSet
  • 2 : AM
  • 3 : DI
  • 4 : MC
  • 5 : VI

Example CustomerCreditCard XML

<CustomerCreditCard RowState="Unchanged">

<Columns>

<CC_ID>9074</CC_ID>

<Customer_Num>Test1234533</Customer_Num>

<CC_Number_Masked></CC_Number_Masked>

<CC_Type>MASTERCARD</CC_Type>

<CC_Number_Secure></CC_Number_Secure>

<CC_Expiration_Date>2017-01-01 00:00:00</CC_Expiration_Date>

<Cardholder_Name>AARON FITZ</Cardholder_Name>

<Cardholder_Street_Address>42 Wallaby Way</Cardholder_Street_Address>

<Cardholder_City></Cardholder_City>

<Cardholder_State></Cardholder_State>

<Cardholder_Zip></Cardholder_Zip>

<Cardholder_Country></Cardholder_Country>

<Cardholder_Country_Code></Cardholder_Country_Code>

<Cardholder_Phones></Cardholder_Phones>

<CC_Description>This is a new credit card.</CC_Description>

<Created_On>2014-12-19 09:13:45</Created_On>

<Created_By>salespad</Created_By>

<Changed_On>2014-12-19 09:13:45</Changed_On>

<Changed_By>salespad</Changed_By>

<IsDefault>True</IsDefault>

<Type>1</Type>

<TokenStorage>1</TokenStorage>

<Card_Type>4</Card_Type>

</Columns>

</CustomerCreditCard>

Customer

Element

Type

Description

Customer_Num

String

Unique customer ID.

Customer_Name

String

Customer name.

Don’t_Store_CC

Boolean

Designates whether or not credit cards for this customer will be saved.

Example Customer XML

<Customer RowState="Unchanged">

<Columns>

<Customer_Num>TEST1234533</Customer_Num>

<Customer_Name>Test User</Customer_Name>

<Dont_Store_CC>False</Dont_Store_CC>

</Columns>

</Customer>

InOutDocument

Element

Type

Description

Prev_Transaction_ID

Int32

Unique identifier of the previous transaction associated with the current transaction (Authorization

   

being captured, transaction being voided, etc).

Document_Source

Int (Enum)

Designates the source of this request. Possible values:

  • 0 : Unknown
  • 1 : SOPEntry
  • 2 : CashReceipt
  • 3 : WebApi

Document_Number

String

Document ID.

Document_Type

Int (Enum)

Designates the type of document. Possible values:

  • 0 : Unknown
  • 1 : Quote
  • 2 : Order
  • 3 : Invoice
  • 4 : Return
  • 5 : Backorder
  • 6 : Fulfillment
     

Document_Date

DateTime

Designates the creation date of the document.

Document_Group

String

Unique ID that multiple related documents can belong to. Also known as a Master Number in Microsoft Dynamics GP.

Document_Total

Decimal

The total amount associated with this document.

Customer_Num

String

Unique customer ID associated with this document.

Customer_Name

String

Name of the customer associated with this document.

Currency_ID

String

ID of the currency in use for this document.

Amount

Decimal

Total amount of the transaction for this document.

Upcharge_Percent

Decimal

The percentage to multiply by the amount as an extra charge for this transaction.

Transaction_Type

Int(Enum)

Designates the type of the current transaction.

Possible values: 0 : None

  1. : Authorization
  2. : Charge
  3. : Capture
  4. : Void
  5. : Credit

Processor_ID

Int32

Unique identifier for the target processor that will handle this transaction.

CreditCard_ID

Int32

Unique identifier for a saved credit card. This value should be -1 if the card is new.

CreditCard_Number

String

Credit card number.

CreditCard_Expiration_Date

DateTime

Expiration date of the credit card.

CVV2

String

CVV2 code of the credit card.

Swipe

String

The swipe data generated by using a credit card swiper.

Save_Credit_Card

Boolean

Designates whether or not this credit card should be saved.

Sales_Document

SalesDocument

A sales document containing order information as well as any sales line items.

Example InOutDocument XML

<InOutDocument RowState="Added">

<Columns>

<Prev_Transaction_ID>0</Prev_Transaction_ID>

<Document_Source>3</Document_Source>

<Document_Number>ORDST2320</Document_Number>

<Document_Type>2</Document_Type>

<Document_Date>2018-11-30 00:00:00</Document_Date>

<Document_Group />

<Document_Total>64.15000</Document_Total>

<Customer_Num>DONOVAN1</Customer_Num>

<Customer_Name>DONOVAN</Customer_Name>

<Currency_ID>Z-US$</Currency_ID>

<Amount>64.15000</Amount>

<Upcharge_Percent>0</Upcharge_Percent>

<Transaction_Type>2</Transaction_Type>

<Processor_ID>15</Processor_ID>

<CreditCard_ID>26</CreditCard_ID>

<CreditCard_Number>1234567890123456</CreditCard_Number>

<CreditCard_Expiration_Date>2017-01-01 00:00:00.000</CreditCard_Expiration_Date>

<CVV2 />

<Swipe />

<Save_Credit_Card>False</Save_Credit_Card>

</Columns>

<Properties>

<SalesDocument>

<SalesDocument RowState="Modified">

<Columns>

<Sales_Doc_Type>2</Sales_Doc_Type>

<Sales_Doc_Num>ORDST2320</Sales_Doc_Num>

<Sales_Doc_ID>STDORD</Sales_Doc_ID>

<Master_Num />

<Doc_Date>2015-2-12 00:00:00</Doc_Date>

<Source>Open</Source>

<Sales_Batch>CONTRACTS</Sales_Batch>

<Customer_Num>DONOVAN1</Customer_Num>

<Customer_PO_Num>NEED PO</Customer_PO_Num>

<Total>64.15000</Total>

<Req_Ship_Date>2018-11-30 00:00:00</Req_Ship_Date>

<Sales_Person_ID>SALESPERSON</Sales_Person_ID>

<Payment_Terms>NET 30</Payment_Terms>

<Notes />

<Created_By>salespad</Created_By>

<Customer_Name>DONOVAN</Customer_Name>

<Shipping_Method>GROUND</Shipping_Method>

<Workflow_Name />

<SalesDocument_Save_Action>0</SalesDocument_Save_Action>

<Holds />

<GM_Amt>64.15000</GM_Amt>

<GM_Pct>100</GM_Pct>

<Ship_To_Contact>SHIPTO CONTACT</Ship_To_Contact>

<Ship_To_Address_1>SHIPTOADDRESS ONE</Ship_To_Address_1>

<Ship_To_Address_2 />

<Ship_To_Address_3 />

<Ship_To_City>SHIPTO CITY</Ship_To_City>

<Ship_To_State>WI</Ship_To_State>

<Ship_To_Zip>53701-6652</Ship_To_Zip>

<Ship_To_Country>USA</Ship_To_Country>

<Ship_To_Country_Code />

<Ship_To_Phone>5555555555</Ship_To_Phone>

<Ship_To_Fax />

<Ship_To_Email />

<Bill_To_Contact>BILLTO CONTACT</Bill_To_Contact>

<Bill_To_Address_1>BILLTO ADDRESS</Bill_To_Address_1>

<Bill_To_Address_2 />

<Bill_To_Address_3 />

<Bill_To_City>BILLTO CITY</Bill_To_City>

<Bill_To_State>WI</Bill_To_State>

<Bill_To_Zip>53701-6652</Bill_To_Zip>

<Bill_To_Country>USA</Bill_To_Country>

<Bill_To_Country_Code />

<Bill_To_Phone>5555555555</Bill_To_Phone>

<Bill_To_Fax>5555555555</Bill_To_Fax>

<Bill_To_Email />

<Ship_To_Addr_Code>PRIMARY</Ship_To_Addr_Code>

<Bill_To_Addr_Code>PRIMARY</Bill_To_Addr_Code>

<Misc_Amt>0</Misc_Amt>

<Freight>0</Freight>

<Subtotal>0</Subtotal>

<Location_Code>WAREHOUSE</Location_Code>

<Price_Level>RETAIL</Price_Level>

<Tax_Schedule>USASTCITY-6*</Tax_Schedule>

<Currency>Z-US$</Currency>

<Tax>0.00</Tax>

<Tax_Exempt_1 />

<Tax_Exempt_2 />

<Discount>0</Discount>

<On_Account>64.15000</On_Account>

<ISOCurrencyID />

<Duty>0</Duty>

</Columns>

</SalesDocument>

</SalesDocument>

</Properties>

</InOutDocument>

CreditCardTransaction

Element

Type

Description

CC_Transaction_ID

Int32

Unique transaction ID automatically generated when a new transaction is created.

CC_Processor_ID

Int32

Unique identifier for the target processor that will handle this transaction.

CC_Transaction_Type

Int (Enum)

Designates the type of the current transaction.

Possible values:

  • 0 : None
  • 1 : Authorization
  • 2 : Charge
  • 3 : Capture
  • 4 : Void
  • 5 : Credit

CC_Transaction_Time

DateTime

Date that the transaction was processed.

CC_Cardholder_Name

String

Name of the card holder.

CC_Type

String

Full name of the credit card type (Mastercard, Visa).

CC_Number_Masked

String

Masked credit card number (XXXX- XXXX-XXXX-0000).

CC_Expiration_Date

DateTime

Expiration date of the credit card (MM/YY).

CC_Bank_Phone

String

Bank phone number.

CC_ID

Int32

Unique ID automatically generated when a card is saved.

Card_Type

Int (Enum)

Two character abbreviation of the CC_Type (MC, VI).

Possible values:

  • 0 : Unknown
  • 1 : NotSet
  • 2 : AM
  • 3 : DI
  • 4 : MC
  • 5 : VI

CC_Transaction_Status

Int (Enum)

Designates the current status of the transaction.

Possible values:

  • 0 : New
  • 1 : Pending
  • 2 : Success
  • 3 : Fail

Document_XML

String

XML serialized SalesDocument object.

Document_Number

String

Document ID.

Document_Type

Int (Enum)

Designates the type of document. Possible values:

  • 0 : Unknown
  • 1 : Quote
  • 2 : Order
  • 3 : Invoice
   
  • 4 : Return
  • 5 : Backorder
  • 6 : Fulfillment

Document_Date

DateTime

Designates the creation date of the document.

Document_Group

String

Unique ID that multiple related documents can belong to. Also known as a Master Number in Microsoft Dynamics GP and Master_Num for the SalesDocument object.

Customer_Num

String

Unique customer ID associated with this document.

Customer_Name

String

Name of the customer associated with this document.

PO_Num

String

Designates the purchase order number associated with this document.

Comments

String

Miscellaneous comments for this document.

Document_Total

Decimal

The total amount associated with this document.

Currency_ID

String

ID of the currency in use for this document.

Freight

Decimal

This document’s freight amount.

Tax

Decimal

This document’s tax amount.

Discount

Decimal

This document’s discount amount.

Amount

Decimal

The total amount for the current transaction.

Auth_Code

String

Unique identifier for the current transaction. If this transaction is new, this field is automatically generated by the processor when the transaction is completed.

Auth_Code2

String

Secondary identifier for the current transaction set by the payment processor.

Processor_Results

String

Processor response details.

Original_Transaction_Info

String

XML serialized CreditCardTransaction for the previous associated transaction.

Document_Source

Int (Enum)

Designates the source of this request. Possible values:

  • 0 : Unknown
  • 1 : SOPEntry
  • 2 : CashReceipt
  • 3 : WebApi

Tax_Exempt_1

String

Determines whether or not tax is included with the transaction amount.

Tax_Exempt_2

String

Determines whether or not tax is included with the transaction amount.

Shipping_Method

String

The shipping method the associated products.

ISOCurrencyID

String

The ISO standardized currency ID for the current transaction amounts.

Ship_To_Contact

String

The name of the customer associated with the shipping address.

Ship_To_Address_1

String

The first line of the shipping address.

Ship_To_Address_2

String

The second line of the shipping address.

Ship_To_Address_3

String

The third line of the shipping address.

Ship_To_City

String

The city specified in the shipping address.

Ship_To_State

String

The state specified in the shipping address.

Ship_To_Zip

String

The zip code specified in the shipping address.

Ship_To_Country

String

The country specified in the shipping address.

Ship_To_Country_Code

String

The country code specified in the shipping address.

Ship_To_Phone

String

The phone number specified in the shipping address.

Ship_To_Fax

String

The fax number specified in the shipping address.

Ship_To_Email

String

The email address specified in the shipping address.

Ship_To_Addr_Code

String

The address code specified in the shipping address.

Bill_To_Contact

String

The name of the customer associated with the billing address.

Bill_To_Address_1

String

The first line of the billing address.

BillTo_Address_2

String

The second line of the billing address.

Bill_To_Address_3

String

The third line of the billing address.

Bill_To_City

String

The city specified in the billing address.

Bill_To_State

String

The state specified in the billing address.

Bill_To_Zip

String

The zip code specified in the billing address.

Bill_To_Country

String

The country specified in the billing address.

Bill_To_Country_Code

String

The country code specified in the billing address.

Bill_To_Phone

String

The phone number specified in the billing address.

Bill_To_Fax

String

The fax number specified in the billing address.

Bill_To_Email

String

The email address specified in the billing address.

Bill_To_Addr_Code

String

The address code specified in the billing address.

Example CreditCardTransaction XML

<CreditCardTransaction RowState="Unchanged">

<Columns>

<CC_Transaction_ID>13628</CC_Transaction_ID>

<CC_Processor_ID>1</CC_Processor_ID>

<CC_Processor_Name>TestProcessor</CC_Processor_Name>

<CC_Transaction_Type>1</CC_Transaction_Type>

<CC_Transaction_Time>2014-12-19 12:41:10</CC_Transaction_Time>

<CC_Cardholder_Name></CC_Cardholder_Name>

<CC_Type>MASTERCARD</CC_Type>

<CC_Number_Masked>XXXX-XXXX-XXXX-5100</CC_Number_Masked>

<CC_Expiration_Date>2019-01-01 00:00:00</CC_Expiration_Date>

<CC_Bank_Phone></CC_Bank_Phone>

<CC_Transaction_Status>2</CC_Transaction_Status>

<Document_XML></Document_XML>

<Document_Number>ORD012020</Document_Number>

<Document_Type>2</Document_Type>

<Document_Group></Document_Group>

<Document_Date>1900-01-01 00:00:00</Document_Date>

<Customer_Num>AA10202</Customer_Num>

<Customer_Name>John Smith</Customer_Name>

<PO_Num></PO_Num>

<Comments></Comments>

<Document_Total>0</Document_Total>

<Currency_ID></Currency_ID>

<Freight>0</Freight>

<Tax>0</Tax>

<Discount>0</Discount>

<Amount>20.00</Amount>

<Auth_Code>2225851807</Auth_Code>

<Processor_Results>Authorization transaction successful: This transaction has been approved. | AVS Response: Address (Street) and five digit ZIP match | Security Code Response: | Cardholder Authentication Verification Response: CAVV passed validation</Processor_Results>

<Created_On>2014-12-19 12:41:10</Created_On>

<Created_By>salespad</Created_By>

<Changed_On>2014-12-19 12:41:10</Changed_On>

<Changed_By>salespad</Changed_By>

<Original_Transaction_Info></Original_Transaction_Info>

<Document_Source>3</Document_Source>

<Tax_Exempt_1></Tax_Exempt_1>

<Tax_Exempt_2></Tax_Exempt_2>

<Shipping_Method></Shipping_Method>

<ISOCurrencyID></ISOCurrencyID>

<Ship_To_Contact></Ship_To_Contact>

<Ship_To_Address_1></Ship_To_Address_1>

<Ship_To_Address_2></Ship_To_Address_2>

<Ship_To_Address_3></Ship_To_Address_3>

<Ship_To_City></Ship_To_City>

<Ship_To_State></Ship_To_State>

<Ship_To_Zip></Ship_To_Zip>

<Ship_To_Country></Ship_To_Country>

<Ship_To_Country_Code></Ship_To_Country_Code>

<Ship_To_Phone></Ship_To_Phone>

<Ship_To_Fax></Ship_To_Fax>

<Ship_To_Email></Ship_To_Email>

<Bill_To_Contact></Bill_To_Contact>

<Bill_To_Address_1></Bill_To_Address_1>

<Bill_To_Address_2></Bill_To_Address_2>

<Bill_To_Address_3></Bill_To_Address_3>

<Bill_To_City></Bill_To_City>

<Bill_To_State></Bill_To_State>

<Bill_To_Zip></Bill_To_Zip>

<Bill_To_Country></Bill_To_Country>

<Bill_To_Country_Code></Bill_To_Country_Code>

<Bill_To_Phone></Bill_To_Phone>

<Bill_To_Fax></Bill_To_Fax>

<Bill_To_Email></Bill_To_Email>

<Ship_To_Addr_Code></Ship_To_Addr_Code>

<Bill_To_Addr_Code></Bill_To_Addr_Code>

<Auth_Code2>IP6DO5</Auth_Code2>

<CC_ID>9088</CC_ID>

<Card_Type>4</Card_Type>

</Columns>

</CreditCardTransaction>

SalesDocument

Element

Type

Description

Sales_Doc_Type

Int (Enum)

Designates the type of document. Possible Values:

  • 0 : Unknown
  • 1 : Quote
  • 2 : Order
  • 3 : Invoice
  • 4 : Return
  • 5 : Backorder
  • 6 : Fulfillment

Sales_Doc_Number

String

Document ID.

Sales_Doc_ID

String

Document ID.

Master_Num

String

Unique ID that multiple related documents can belong to. Also known as Document_Group for InOutDocument object.

Doc_Date

DateTime

Designates the creation date of the document.

Source

String (Enum)

Designates the source of the document.

Sales_Batch

String

Designates the batch that this document currently belongs to.

Customer_Num

String

Designates the customer ID associated with this document.

Customer_PO_Num

String

Designates the customer ID associated with this purchase order.

Total

Decimal

The total amount for this document.

Req_Ship_Date

DateTime

The required ship date for this document.

Sales_Person_ID

String

The salesperson associated with this document.

Payment_Terms

String

The payment terms for this document.

Notes

String

Miscellaneous notes for this document.

Custome_Name

String

The name for the customer associated with this document.

Shipping_Method

String

The shipping method for the products associated with this document.

Workflow_Name

String

The name of the workflow that triggered the processing of this document.

SalesDocument_Save_Action

Int32

Determines how the document is saved.

Holds

String

Semicolon delimited list of holds currently applied to the document.

GM_Amt

Decimal

Gross margin amount.

GM_Pct

Decimal

Gross margin percent.

Ship_To_Contact

String

The name of the customer associated with the shipping address.

Ship_To_Address_1

String

The first line of the shipping address.

Ship_To_Address_2

String

The second line of the shipping address.

Ship_To_Address_3

String

The third line of the shipping address.

Ship_To_City

String

The city specified in the shipping address.

Ship_To_State

String

The state specified in the shipping address.

Ship_To_Zip

String

The zip code specified in the shipping address.

Ship_To_Country

String

The country specified in the shipping address.

Ship_To_Country_Code

String

The country code specified in the shipping address.

Ship_To_Phone

String

The phone number specified in the shipping address.

Ship_To_Fax

String

The fax number specified in the shipping address.

Ship_To_Email

String

The email address specified in the shipping address.

Ship_To_Addr_Code

String

The address code specified in the shipping address.

Bill_To_Contact

String

The name of the customer associated with the billing address.

Bill_To_Address_1

String

The first line of the billing address.

Bill_To_Address_2

String

The second line of the billing address.

Bill_To_Address_3

String

The third line of the billing address.

Bill_To_City

String

The city specified in the billing address.

Bill_To_State

String

The state specified in the billing address.

Bill_To_Zip

String

The zip code specified in the billing address.

Bill_To_Country

String

The country specified in the billing address.

Bill_To_Country_Code

String

The country code specified in the billing address.

Bill_To_Phone

String

The phone number specified in the billing address.

Bill_To_Fax

String

The fax number specified in the billing address.

Bill_To_Email

String

The email address specified in the billing address.

Bill_To_Addr_Code

String

The address code specified in the billing address.

Misc_Amt

Decimal

The miscellaneous extra charges for this document.

Freight

Decimal

This document’s freight amount.

Tax

Decimal

This document’s tax amount.

Discount

Decimal

This document’s discount amount.

Subtotal

Decimal

The subtotal for this document.

Tax_Exempt_1

String

Reason one for tax exemption.

Tax_Exempt_2

String

Reason two for tax exemption.

Tax_Schedule

String

Desired tax schedule.

Currency

String

ID of the currency in use for this document.

Location_Code

String

Customer location code.

On_Account

Decimal

The amount remaining to be paid on the document.

ISOCurrencyID

String

The ISO standardized currency ID for the current transaction amounts.

Duty

Decimal

Amount to pay when the product crosses a country border.

<SalesDocument>

<SalesDocument RowState="Modified">

<Columns>

<Sales_Doc_Type>2</Sales_Doc_Type>

<Sales_Doc_Num>ORDST2320</Sales_Doc_Num>

<Sales_Doc_ID>STDORD</Sales_Doc_ID>

<Master_Num />

<Doc_Date>2015-2-12 00:00:00</Doc_Date>

<Source>Open</Source>

<Sales_Batch>CONTRACTS</Sales_Batch>

<Customer_Num>DONOVAN1</Customer_Num>

<Customer_PO_Num>NEED PO</Customer_PO_Num>

<Total>64.15000</Total>

<Req_Ship_Date>2018-11-30 00:00:00</Req_Ship_Date>

<Sales_Person_ID>SALESPERSON</Sales_Person_ID>

<Payment_Terms>NET 30</Payment_Terms>

<Notes />

<Created_By>salespad</Created_By>

<Customer_Name>DONOVAN</Customer_Name>

<Shipping_Method>GROUND</Shipping_Method>

<Workflow_Name />

<SalesDocument_Save_Action>0</SalesDocument_Save_Action>

<Holds />

<GM_Amt>64.15000</GM_Amt>

<GM_Pct>100</GM_Pct>

<Ship_To_Contact>SHIPTO CONTACT</Ship_To_Contact>

<Ship_To_Address_1>SHIPTOADDRESS ONE</Ship_To_Address_1>

<Ship_To_Address_2 />

<Ship_To_Address_3 />

<Ship_To_City>SHIPTO CITY</Ship_To_City>

<Ship_To_State>WI</Ship_To_State>

<Ship_To_Zip>53701-6652</Ship_To_Zip>

<Ship_To_Country>USA</Ship_To_Country>

<Ship_To_Country_Code />

<Ship_To_Phone>5555555555</Ship_To_Phone>

<Ship_To_Fax />

<Ship_To_Email />

<Bill_To_Contact>BILLTO CONTACT</Bill_To_Contact>

<Bill_To_Address_1>BILLTO ADDRESS</Bill_To_Address_1>

<Bill_To_Address_2 />

<Bill_To_Address_3 />

<Bill_To_City>BILLTO CITY</Bill_To_City>

<Bill_To_State>WI</Bill_To_State>

<Bill_To_Zip>53701-6652</Bill_To_Zip>

<Bill_To_Country>USA</Bill_To_Country>

<Bill_To_Country_Code />

<Bill_To_Phone>5555555555</Bill_To_Phone>

<Bill_To_Fax>5555555555</Bill_To_Fax>

<Bill_To_Email />

<Ship_To_Addr_Code>PRIMARY</Ship_To_Addr_Code>

<Bill_To_Addr_Code>PRIMARY</Bill_To_Addr_Code>

<Misc_Amt>0</Misc_Amt>

<Freight>0</Freight>

<Subtotal>0</Subtotal>

<Location_Code>WAREHOUSE</Location_Code>

<Price_Level>RETAIL</Price_Level>

<Tax_Schedule>USASTCITY-6*</Tax_Schedule>

<Currency>Z-US$</Currency>

<Tax>0.00</Tax>

<Tax_Exempt_1 />

<Tax_Exempt_2 />

<Discount>0</Discount>

<On_Account>64.15000</On_Account>

<ISOCurrencyID />

<Duty>0</Duty>

</Columns>

</SalesDocument>

</SalesDocument>

SalesLineItem

Element

Type

Description

Sales_Doc_Type

Int (Enum)

Designates the type of document. Possible values:

  • 0 : Unknown
  • 1 : Quote
  • 2 : Order
  • 3 : Invoice
  • 4 : Return
  • 5 : Backorder
  • 6 : Fulfillment

Sales_Doc_Number

String

Document ID.

Line_Num

Int

The unique identifier for this line item.

Component_Seq_Num

Int

The unique identifier for a component item.

Source

String

The source of this line item.

Item_Number

String

The unique identifier for the item associated with this line.

Item_Description

String

The description for this item.

Is_Non_Inventory

Bool

Specifies whether or not this item is non-inventory.

Is_Dropship

Bool

Specifies whether or not this item is being drop-shipped.

UOfM_Schedule

String

The name of the unit of measure schedule.

Unit_Of_Measure

String

The name of the chosen unit of measure.

Base_UOfM

String

The first unit of measure in the UOfM_Schedule.

Warehouse_Code

String

Unique identifier for the warehouse associated with this item.

Unit_Cost

Decimal

The cost per unit of this item.

Expected_Unit_Cost

Decimal

The expected cost per unit of this item.

Unit_Price

Decimal

The price per unit of this item.

Extended_Price

Decimal

The Unit_Price * Quantity of the unit.

Currency_Dec

Int

Number of decimal places for the currency.

Markdown_Amount

Decimal

The price markdown for this item.

Markdown_Pct

Decimal

The percentage markdown for this item.

Item_Tax_Schedule

String

The tax schedule for this item.

Quantity

Decimal

The number of units for this item.

Qty_Allocated

Decimal

The number of units allocated to the associated order.

Qty_Remaining

Decimal

The number of units remaining to be allocated for the associated order.

Qty_Canceled

Decimal

The number of units that have been canceled for the associated order.

Qty_Backordered

Decimal

The number of units for this item that are on backorder.

Qty_SentTo_Backordered

Decimal

The number of units that were previously backordered.

Qty_ToPick

Decimal

Qty_Remaining - Qty_Backordered – Qty_Fulfilled or if item type is in range (4, 5, 6) then zero. See Dynamics GP documentation for a description of item type.

Qty_Fulfilled

Decimal

The number of units fulfilled.

Qty_Selected

Decimal

The numbe

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. SalesPad Support

  2. Posted
  3. Updated

Comments