Data Fields from Avanti Slingshot

These data fields are available:

Avanti Slingshot - Activities Fields Name
Activity Contact Name
Activity Due Date
Activity Employee Code
Activity Employee Name
Activity End Date
Activity Note Text
Activity Objective
Activity Priority
Activity Regarding
Activity Regarding Reference
Activity Status
Activity Subject
Activity Type
Created Date
Cust_id
Last Modified Date

Avanti Slingshot - Customer Address Fields Name
Created Date
Customer Address Address1
Customer Address Address2
Customer Address Address3
Customer Address City
Customer Address Code
Customer Address Contact Address City
Customer Address Contact Address Country Code
Customer Address Contact Business Email
Customer Address Contact Business Ext
Customer Address Contact Business Fax
Customer Address Contact Business Phone
Customer Address Contact File As
Customer Address Contact First and Last
Customer Address Contact First Name
Customer Address Contact Full Name
Customer Address Contact Middle Name
Customer Address Contact Mobile Phone
Customer Address Contact Home Email
Customer Address Contact Home Fax
Customer Address Contact Home Phone
Customer Address Contact Other Email
Customer Address Contact Job Description
Customer Address Contact Job Description Type
Customer Address Contact Last Name
Customer Address Contact Address Name
Customer Address Contact Address Country Name
Customer Address Contact Address Postal Zip
Customer Address Contact Address Stateprov Code
Customer Address Contact Address Stateprov Name
Customer Address Contact Address1
Customer Address Contact Address2
Customer Address Contact Address3
Customer Address Contact Other Phone
Customer Address Contact Suffix
Customer Address Contact Title
Customer Address Country Code
Customer Address Country Name
Customer Address Email Address
Customer Address Fax
Customer Address Fax Ext
Customer Address Is Onetime
Customer Address Name
Customer Address Phone1
Customer Address Phone1 Ext
Customer Address Phone2
Customer Address Phone2 Ext
Customer Address Phone3
Customer Address Phone3 Ext
Customer Address Postal Zip
Customer Address Stateprov Code
Customer Address Stateprov Name

Avanti Slingshot - Customer Contacts Fields Name
Contact Address City
Contact Address Country Code
Contact Address Country Name
Contact Address Name
Contact Address Postal Zip
Contact Address Stateprov Code
Contact Address Stateprov Name
Contact Address1
Contact Address2
Contact Address3
Contact Business Email
Contact Business Ext
Contact Business Fax
Contact Business Phone
Contact File As
Contact First and Last
Contact First Name
Contact Full Name
Contact Home Email
Contact Home Fax
Contact Home Phone
Contact Job Description
Contact Job Description Type
Contact Last Name
Contact Middle Name
Contact Mobile Phone
Contact Other Email
Contact Suffix
Contact Title
Created Date
Custcontact One Time

Avanti Slingshot - Customer Costs Fields Name
Fiscal Year
Fiscal Period
Cost Amount
Created Date

Avanti Slingshot - Customer Sales Fields Name
Customer Cost Amount
Customer Profit Amount
Customer Sales Amount
Customer Sales Period
Customer Sales Year
Fiscal Period End Date
Is MTD
Is YTD

Avanti Slingshot - Fiscal Periods Fields Name
Created Date
Fiscal Period Year
Fiscal Period Start
Fiscal Period End
IsYTD

Avanti Slingshot - Fiscal Periods Detail Name
Created Date
Fiscal Period Number
Fiscal Period Start Date
Fiscal Period End Date
Fiscal Period Year
IsMTD

Avanti Slingshot - Customers Fields Name
Created Date
Customer Accepts Backorders
Customer Category Code
Customer Category Description
Customer Class Code
Customer Class Description
Customer Code
Customer Credit Limit
Customer Csr Code
Customer Csr Name
Customer Currency Code
Customer Currency Name
Customer Industry Code
Customer Industry Description
Customer is Fob
Customer Minimum Order Amount
Customer Name
Customer Parent Customer Code
Customer Parent Customer Name
Customer Payment Code
Customer Payment Description
Customer Payment Terms Code
Customer Payment Terms Description
Customer Po Required
Customer Primary Address Address1
Customer Primary Address Address2
Customer Primary Address Address3
Customer Primary Address City
Customer Primary Address Code
Customer Primary Address Contact Business Email
Customer Primary Address Contact Business Ext
Customer Primary Address Contact Business Phone
Customer Primary Address Contact Full Name
Customer Primary Address Contact Job Description
Customer Primary Address Contact Job Description Type
Customer Primary Address Contact Mobile Phone
Customer Primary Address Country Code
Customer Primary Address Country Name
Customer Primary Address Email Address
Customer Primary Address Fax
Customer Primary Address Fax Ext
Customer Primary Address Name
Customer Primary Address Phone1
Customer Primary Address Phone1 Ext
Customer Primary Address Postal Zip
Customer Primary Address Stateprov Code
Customer Primary Address Stateprov Name
Customer Primary Bill Address Address1
Customer Primary Bill Address Address2
Customer Primary Bill Address Address3
Customer Primary Bill Address City
Customer Primary Bill Address Code
Customer Primary Bill Address Contact Business Email
Customer Primary Bill Address Contact Business Ext
Customer Primary Bill Address Contact Business Phone
Customer Primary Bill Address Contact Full Name
Customer Primary Bill Address Contact Job Description
Customer Primary Bill Address Contact Job Description Type
Customer Primary Bill Address Contact Mobile Phone
Customer Primary Bill Address Country Code
Customer Primary Bill Address Country Name
Customer Primary Bill Address Email Address
Customer Primary Bill Address Fax
Customer Primary Bill Address Fax Ext
Customer Primary Bill Address Name
Customer Primary Bill Address Phone1
Customer Primary Bill Address Phone1 Ext
Customer Primary Bill Address Postal Zip
Customer Primary Bill Address Stateprov Code
Customer Primary Bill Address Stateprov Name
Customer Primary Shipto Address Address1
Customer Primary Shipto Address Address2
Customer Primary Shipto Address Address3
Customer Primary Shipto Address City
Customer Primary Shipto Address Code
Customer Primary Shipto Address Contact Business Email
Customer Primary Shipto Address Contact Business Ext
Customer Primary Shipto Address Contact Business Phone
Customer Primary Shipto Address Contact Full Name
Customer Primary Shipto Address Contact Job Description
Customer Primary Shipto Address Contact Job Description Type
Customer Primary Shipto Address Contact Mobile Phone
Customer Primary Shipto Address Country Code
Customer Primary Shipto Address Country Name
Customer Primary Shipto Address Email Address
Customer Primary Shipto Address Fax
Customer Primary Shipto Address Fax Ext
Customer Primary Shipto Address Name
Customer Primary Shipto Address Phone1
Customer Primary Shipto Address Phone1 Ext
Customer Primary Shipto Address Postal Zip
Customer Primary Shipto Address Stateprov Code
Customer Primary Shipto Address Stateprov Name
Customer Priority
Customer Sales Group Code
Customer Sales Group Description
Customer Sales Person Code
Customer Sales Person Name
Customer Ship Complete
Customer Ship Method Code
Customer Ship Method Name
Customer Sic Code
Customer Sic Name
Customer Status
Customer Tax Group Code
Customer Tax Group Description
Customer Tax Registration Number
Customer Territory Code
Customer Territory Description
Customer Type
Customer Website

Date Fields Name
Date

Avanti Slingshot - Estimates Fields Name
Created Date
Estimate Csr Code
Estimate Csr Name
Estimate Customer Po
Estimate Date
Estimate Description
Estimate Estimator Code
Estimate Estimator Name
Estimate Fiscal Period
Estimate Fiscal Year
Estimate Good Until Date
Estimate Number
Estimate Opportunity 30 Days
Estimate Opportunity 60 Days
Estimate Opportunity 90 Days
Estimate Opportunity Chance To Close Percentage
Estimate Opportunity Closed Date
Estimate Opportunity Committed Close
Estimate Opportunity Expected Close Date
Estimate Opportunity Lost Amount
Estimate Opportunity Over 90 Days
Estimate Opportunity Stage
Estimate Opportunity Won Amount
Estimate Sales Person Code
Estimate Sales Person Name
Estimate Status
Estimate Subtotal Amount
Estimate Total Amount

Avanti Slingshot - Estimate Detail Fields Name
Accounter
Created Date
Estimate Detail Code
Estimate Detail Description
Estimate Detail Discount Amt
Estimate Detail Extended Price
Estimate Detail Line Num
Estimate Detail Rd Diff
Estimate Detail Qty Backorder
Estimate Detail Qty Ordered
Estimate Detail Qty Received
Estimate Detail Qty Reserved
Estimate Detail Qty Shipped
Estimate Detail Reference Num 1
Estimate Detail Reference Num 2
Estimate Detail Type
Estimate Detail Unit Price
Estimate Detail Unit Price Uom
Estimate Detail Uom
Estimate Detail Warehouse
Hoodie Commit SeqNo
Hoodie Commit Time
Hoodie File Name
Hoodie Partition Path
Hoodie Record Key
Last Modified Date
Ordh_id
Ordrevd_id
Org_id
Source File
Tenant

Avanti Slingshot - Estimate Detail Section Fields Name
Accounter
Created Date
Estimate Detail Section Bleed L
Estimate Detail Section Bleed W
Estimate Detail Section CBar
Estimate Detail Section Color
Estimate Detail Section Description
Estimate Detail Section Diff
Estimate Detail Section Finish
Estimate Detail Section Finish L
Estimate Detail Section Finish W
Estimate Detail Section Form No
Estimate Detail Section Grain Direction
Estimate Detail Section Gripper
Estimate Detail Section Last Completed
Estimate Detail Section Next Milestone
Estimate Detail Section Num
Estimate Detail Section Pages
Estimate Detail Section Press
Estimate Detail Section Press Time
Estimate Detail Section Qty
Estimate Detail Section Substrate
Estimate Detail Section Substrate Weight
Estimate Detail Section Type
Estimate Detail Section Weight Uom
Estimate Detail Section Work Weight Uom
Hoodie Commit Seq No
Hoodie Commit Time
Hoodie File Name
Hoodie Partition Path
Hoodie Record Key
Last Modified Date
Ordrevd_id
Ordrevds_id
Org_id
Source File
Tenant

Location Fields Name
Location Name

Operator Fields Name
Operator Name

Operator Activity - Continuous Form Fields Name
Logged Activity Type

Operator Session - Continuous Form Fields Name
Operator Login Duration (Ms)

Avanti Slingshot - Orders Fields Name
Days Left in Shipment
Div Code
Div Name
Order Csr Code
Order Csr Name
Order Customer Po
Order Date
Order Description
Order Expected Ship Date
Order External Order Id
Order Fiscal Period
Order Fiscal Year
Order Not Fully Invoiced
Order Number
Order Project
Order Promise Date
Order Proof Date
Order Release Date
Order Sales Order Ref 1
Order Sales Order Ref 2
Order Sales Person Code
Order Sales Person Name
Order Sales Territory Code
Order Sales Territory Name
Order Ship Method Code
Order Ship Method Description
Order Shipping Amount
Order Status
Order Subtotal Amount
Order Total Actual Cost
Order Total Amount
Order Total Tax Amount
Order Total Commission Amount
Order Total Postage Amount
Order Total Contract Charge Amount
Order Type
Plant Code
Plant Name

Avanti Slingshot - Orders Detail Fields Name
Accounter
Created Date
Hoodie Commit Seq No
Hoodie Commit Time
Hoodie File Name
Hoodie Partition Path
Hoodie Record Key
Job Id
Last Modified Date
Order Detail Code
Order Detail Description
Order Detail Discount Amt
Order Detail Extended Price
Order Detail Line Num
Order Detail Ord Diff
Order Detail Qty Back Order
Order Detail Qty Ordered
Order Detail Qty Received
Order Detail Qty Reserved
Order Detail Qty Shipped
Order Detail Reference Num 1
Order Detail Reference Num 2
Order Detail Type
Order Detail Unit Price
Order Detail Unit Price Uom
Order Detail Uom
Order Detail Warehouse
Ordh_id
Ordrevd_id
Org_id
Source File
Tenant

Avanti Slingshot - Orders Detail Section Fields Name
Accounter
Created Date
Hoodie Commit Seq No
Hoodie Commit Time
Hoodie File Name
Hoodie Partition Path
Hoodie Record Key
Last Modified Date
Order Detail Section Bleed L
Order Detail Section Bleed W
Order Detail Section CBar
Order Detail Section Color
Order Detail Section Description
Order Detail Section Diff
Order Detail Section Finish
Order Detail Section Finish L
Order Detail Section Finish W
Order Detail Section Form No
Order Detail Section Grain Direction
Order Detail Section Gripper
Order Detail Section Last Completed Milestone
Order Detail Section Next Milestone Uncompleted
Order Detail Section Num
Order Detail Section Pages
Order Detail Section Press
Order Detail Section Press Time
Order Detail Section Qty
Order Detail Section Substrate
Order Detail Section Substrate Weight
Order Detail Section Type
Ordrevd_id
Ordrevds_id
Org_id
Source File
Tenant
Weight Uom
Worktype Uom

Avanti Slingshot - Invoices Fields Name
Created Date
Invoice Record Type
Invoice Customer Code
Invoice Customer Name
Invoice Number
Invoice Date
Invoice Subtotal Amount
Invoice Postage Amount
Invoice Freight Amount
Invoice Salestax Amount
Invoice Total Amount
Fiscal Year
Fiscal Period

Avanti Slingshot - Invoices Cost Centre Fields Name
Accounter
Created Date
Hoodie Commit Seq No
Hoodie Commit Time
Hoodie File Name
Hoodie Partition Path
Hoodie Record Key
Inv_id
Invccs_id
Invoice Cost Centre Cost of Sales
Invoice Cost Centre Department
Invoice Cost Centre Discount
Invoice Cost Centre Gross Sales
Invoice Cost Centre Net Sales
Invoice Cost Centre Operation
Invoice Cost Centre Operation Category
Last Modified Date
Org_id
Source File
Tenant

Avanti Slingshot - Invoices Billing Code Fields Name
Accounter
Created Date
Hoodie Commit Seq No
Hoodie Commit Time
Hoodie File Name
Hoodie Partition Path
Hoodie Record Key
Inv_id
Invd_id
Invoice Billing Code
Invoice Billing Code Address Code
Invoice Billing Code Description
Invoice Billing Code Ext Price
Invoice Billing Code Level
Invoice Billing Code Qty
Invoice Billing Code Rounding Indicator
Invoice Billing Code Sequence Nr
Invoice Billing Code Ship Address Name
Invoice Billing Code Tax Amt
Invoice Billing Code Unit Price
Last Modified Date
Org_id
Source File
Tenant

Avanti Slingshot - Jobs Fields Name
Created Date
Fiscal Period
Fiscal Year
Job Actual Labour Cost
Job Actual Material Cost
Job Actual Other Cost
Job Actual Purchase Cost
Job Actual Total Cost
Job Budget Labour
Job Budget Material
Job Budget Purchase
Job Budget Status
Job Budget Total
Job Completed Date
Job Date
Job Date 2
Job Description
Job Expected Ship Date
Job Has Milestones
Job Invoice Status
Job Max Milestone Date Completed
Job Max Milestone Date Due
Job Max Milestone Date Scheduled
Job Number
Job Paper Actual Cost
Job Paper Budget Cost
Job Press
Job Price
Job Priority
Job Schedule Status
Job Ship Method
Job Shipping Status
Job Status
Job Total Press Time
Milestone Last Modified Date
Variance