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
Credit Card Functions Customer Functions Transaction Functions
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
XML Serialized Object Examples for the REST API Http Verbs
Valid Rowstate Values for Externally Serialized Objects HTTP Headers
Customer Object Credit Card Object
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:
|
|
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:
|
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:
|
|
Document_Number |
String |
Document ID. |
|
Document_Type |
Int (Enum) |
Designates the type of document. Possible values:
|
|
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
|
|
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:
|
|
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:
|
|
CC_Transaction_Status |
Int (Enum) |
Designates the current status of the transaction. Possible values:
|
|
Document_XML |
String |
XML serialized SalesDocument object. |
|
Document_Number |
String |
Document ID. |
|
Document_Type |
Int (Enum) |
Designates the type of document. Possible values:
|
|
||
|
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:
|
|
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:
|
|
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:
|
|
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 |
SalesPad Support
Comments