|
B Spreadsheet Column Header
|
Location of data within TransActPOS
|
Edit Option
|
|
BM Outlet #
|
Entered during the Data View process
|
Edit BM Outlet # number during Data View process
|
|
Account Number
|
Customer File - Customer ID
|
Edit within customer file
|
|
Account Name
|
Customer File - Company Name
|
Edit within customer file
|
|
Account Address
|
Customer File - Customer Address
|
Edit within customer file
|
|
Account City
|
Customer File - Customer City
|
Edit within customer file
|
|
Account State
|
Customer File - Customer State
|
Edit within customer file
|
|
Account Zip
|
Customer File - Customer Zip
|
Edit within customer file
|
|
Phone Number
|
Customer File - Customer Phone
|
Edit within customer file
|
|
E-Mail Address
|
Customer File - Customer Email
|
Edit within customer file
|
|
Transaction Date
|
Invoice - Invoice Date
|
Non-editable field - void invoice or return product
|
|
Invoice Number
|
Invoice - Invoice Number
|
Non-editable field - void invoice or return products
|
|
Transaction Line Number
|
Invoice - Invoice Detail Record
|
Non-editable field
|
|
UPC Code
|
Inventory File - Lookup Screen - Primary UPC
|
Edit within Inventory File - Lookup field
|
|
BM SKU
|
Inventory File - General Tab - Manufacturer Number
|
Edit within Inventory File - General tab
|
|
Product Description
|
Inventory File - General Tab - Description
|
Edit within Inventory File - General tab
|
|
Quantity
|
Invoice - Invoice Detail Record
|
Non-editable field - void invoice or return products
|
|
Unit of Measure
|
Invoice - Invoice Detail Record
|
Non-editable field - void invoice or return products
|
|
Unit Price
|
Invoice - Invoice Detail Record
|
Non-editable field - void invoice or return products
|
|
Ext Price
|
Invoice - Invoice Detail Record
|
Non-editable field - void invoice or return products
|
|
Job
|
Invoice - Invoice Header
|
Edit within POS - Manager Screen - Edit Header - Job Name
|
|
Job Name
|
Invoice - Invoice Header
|
Edit within Customer File - General Tab - Jobs - Properties
|
|
Job Address
|
Customer File - General Tab - Jobs - Properties
|
Edit within Customer File - General Tab - Jobs - Properties
|
|
Job City
|
Customer File - General Tab - Jobs - Properties
|
Edit within Customer File - General Tab - Jobs - Properties
|
|
Job State
|
Customer File - General Tab - Jobs - Properties
|
Edit within Customer File - General Tab - Jobs - Properties
|
|
Job Zip
|
Customer File - General Tab - Jobs - Properties
|
Edit within Customer File - General Tab - Jobs - Properties
|
|
Sales Rep Terr #
|
Customer File - General Tab - Jobs - Properties
|
Edit within Customer File - General Tab - Jobs - Properties
|
|
Sales Rep Terr Name
|
Customer File - General Tab - Jobs - Properties
|
Edit within Customer File - General Tab - Jobs - Properties
|