This data object is used to display all deal packet summary information. There is exactly one record returned for every deal packet in Fusion, open or invoiced. To see detail information line by line, join to Sales Deal Detail.

This information can be found in the Deal Packet program within the Fusion business system.

URL

/frw/SalesDealPacket

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the given deal packet was added to the system (for invoiced deal packets, displays the date on which the original open deal packet was added to the system).
AddUser This field displays the username of the user who added the given deal packet to the system (for invoiced deal packets, displays the username of the user who added the original open deal packet).
BillToAddress1 This field displays the first line of the bill to address for the given deal packet.
BillToAddress2 This field displays the second line of the bill to address for the given deal packet.
BillToCity This field displays the city of the bill to address for the given deal packet.
BillToCountry This field displays the country of the bill to address for the given deal packet.
BillToCounty This field displays the county of the bill to address for the given deal packet.
BillToPostalCode This field displays the postal code of the bill to address for the given deal packet.
BillToRegion This field displays the region of the bill to address for the given deal packet.
BillToTaxBody This field displays the tax body that the bill to address for the given deal packet is located within.
Branch This field displays the branch associated with the given deal packet.
Commission This field displays the total commission amount that the salesperson associated with the sale earned from the given deal packet.
CommissionPostDate This field displays the date on which the commission for the given deal packet was posted to accounting.
CommissionPostJournal This field displays the journal which the commission for the given deal packet is posted against.
CommissionPostMonth This field displays the month and year in which the commission for the given deal packet was posted to accounting.
CompanyName This field displays the company name of the customer associated with the given deal packet.
ContactAddress1 This field displays the first line of the address for the contact associated with the given deal packet.
ContactAddress2 This field displays the second line of the address for the contact associated with the given deal packet.
ContactCity This field displays the city of the address for the contact associated with the given deal packet.
ContactCountry This field displays the country of the address for the contact associated with the given deal packet.
ContactCounty This field displays the county of the address for the contact associated with the given deal packet.
ContactPostalCode This field displays the postal code of the address for the contact associated with the given deal packet.
ContactRegion This field displays the region of the address for the contact associated with the given deal packet.
ContactTaxBody This field displays the tax body that the address for the contact associated with the given deal packet is located within.
CurrencyCode This field displays the currency code associated with the GL transaction for the given invoiced deal packet.
CustomerNumber This field displays the customer number of the customer associated with the given deal packet.
CustomerPO This field displays the purchase order number associated with the customer on the given deal packet.
DealContractDate This field displays the contract date of the deal that the given deal packet is associated with.
DealNumber This field displays the deal number of the deal that the given deal packet is associated with.
DealPacketStatus This field displays the status of the given deal packet.
DeliveryDate This field displays the date on which the unit(s) associated with the given deal packet came into the possession of the customer.
Department This field displays the department associated with the given deal packet.
FinanceAmount This field displays the total amount of financing applied to particular units on the given deal packet.
FinanceCommission This field displays the total amount of finance commission on the given deal packet.
FinanceReserve This field displays the total finance reserve amount associated with particular units on the given deal packet.
InsuranceCommission This field displays the total amount of insurance commission on the given deal packet.
InsuranceIncome This field displays the total amount of insurance income on the given deal packet.
InvoiceDate This field displays the date on which the given deal packet was invoiced.
InvoiceName1 This field displays the first name entered on the deal packet which should be printed on the invoice for the given deal packet.
InvoiceName2 This field displays the second name entered on the deal packet which should be printed on the invoice for the given deal packet.
InvoiceNumber This field displays the invoice number of the given invoiced deal packet.
InvoiceUser This field displays the username of the user who invoiced the given invoiced deal packet.
Journal This field displays the journal which the GL transaction for the given deal packet is posted against.
JournalBranch This field displays the branch in which the journal entry for the GL transaction for the given deal packet was posted.
JournalReference This field displays the reference number associated with the journal entry for the GL transaction for the given deal packet.
LastUpdate This field displays the date on which the given deal packet was last updated in the system.
LastUpdateUser This field displays the username of the user who last updated the given deal packet in the system.
OverrideExchangeRate This field displays the override exchange rate entered at the time of the GL transaction for the given deal packet.
PacketNumber This field displays the packet number of the given deal packet.
PaymentMethod This field displays the payment method used by the customer on the given deal packet.
PostDate This field displays the date on which the GL transaction for the given deal packet was posted.
PostPeriod This field displays the month and year in which the GL transaction for the given deal packet was posted.
PostedAfterSalesCommission This field displays the total commission amount that was entered after the given deal packet was closed and posted to accounting.
PostedAfterSalesExpense This field displays the total amount of expenses that were entered after the given deal packet was closed and posted to accounting.
SalesType This field displays the sale type of the given deal packet.
Salesperson This field displays the username of the unit salesperson associated with the customer on the given deal packet.
ShipToAddress1 This field displays the first line of the ship to address for the given deal packet.
ShipToAddress2 This field displays the second line of the ship to address for the given deal packet.
ShipToCity This field displays the city of the ship to address for the given deal packet.
ShipToCountry This field displays the country of the ship to address for the given deal packet.
ShipToCounty This field displays the county of the ship to address for the given deal packet.
ShipToPostalCode This field displays the postal code of the ship to address for the given deal packet.
ShipToRegion This field displays the region of the ship to address for the given deal packet.
ShipToTaxBody This field displays the tax body that the ship to address for the given deal packet is located within.
SignDate This field displays the date on which all of the documents for the given deal packet were signed by the customer.
TaxBasis This field displays whether the sales tax on the given deal packet will be charged based on the local tax body or the tax body of the customer.
TaxBody This field displays the overruling tax body of the given deal packet, from the Tax Information tab.
TaxRegion This field displays the region associated with the tax body of the given deal packet.
TaxStatus This field displays the tax status of the given deal packet.
TotalActualCashValue This field displays the total actual cash value of all trade in units on the given deal packet.
TotalDealAddOnCost This field displays the total cost of all deal add ons on the given deal packet.
TotalDealAddOnPrice This field displays the total price of all deal add ons on the given deal packet.
TotalDeposits This field displays the total amount of all deposits on the given deal packet.
TotalDownPayments This field displays the total amount of all down payments on the given deal packet.
TotalFET This field displays the total amount of all FET charges on the given deal packet.
TotalFinanceReserve This field displays the total finance reserve amount on the given deal packet.
TotalFinanced This field displays the total amount of financing on the given deal packet.
TotalNonProfitDealAddOnCost This field displays the total cost of all deal add ons on the given deal packet that are not included in the profit calculation for the deal packet.
TotalNonProfitDealAddOnPrice This field displays the total price of all deal add ons on the given deal packet that are not included in the profit calculation for the deal packet.
TotalNonProfitUnitAddOnCost This field displays the total cost of all unit add ons on the given deal packet that are not included in the profit calculation for the deal packet.
TotalNonProfitUnitAddOnPrice This field displays the total price of all unit add ons on the given deal packet that are not included in the profit calculation for the deal packet.
TotalPayoff This field displays the total amount of all payoffs on the given deal packet.
TotalProfit This field displays the amount of the total price of the deal packet that is profit (price - cost).
TotalProfitDealAddOnCost This field displays the total cost of all deal add ons on the given deal packet that are included in the profit calculation for the deal packet.
TotalProfitDealAddOnPrice This field displays the total price of all deal add ons on the given deal packet that are included in the profit calculation for the deal packet.
TotalProfitPercent This field displays the percentage of the total price of the deal packet that is profit.
TotalProfitUnitAddOnCost This field displays the total cost of all unit add ons on the given deal packet that are included in the profit calculation for the deal packet.
TotalProfitUnitAddOnPrice This field displays the total price of all unit add ons on the given deal packet that are included in the profit calculation for the deal packet.
TotalSalesTax This field displays the total amount of sales tax on the given deal packet.
TotalTradeInAllowance This field displays the total allowance given on all trade in units on the given deal packet.
TotalUnitAddOnCost This field displays the total cost of all unit add ons on the given deal packet.
TotalUnitAddOnPrice This field displays the total price of all unit add ons on the given deal packet.
TotalUnitCost This field displays the total cost of all units on the given deal packet.
TotalUnitPrice This field displays the total price of all units on the given deal packet.