Data Fields from Avanti Slingshot
Data fields from Avanti Slingshot include data provided by 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 |