field and not stored in the database.

Toolbar Icons	Description
Column Filter Show/Hide	Insert excerpt Column Filter Show/Hide - Global Column Filter Show/Hide - Global nopanel true
Excel	Insert excerpt Excel - LV 3.0 Excel - LV 3.0 nopanel true
Favorites	Insert excerpt Favorites Add/Remove - Global Favorites Add/Remove - Global nopanel true
Group By Show/Hide	Insert excerpt Group By Show/Hide - Global Group By Show/Hide - Global nopanel true
Help	Insert excerpt Help - Global 3.0 Help - Global 3.0 nopanel true
Print	Insert excerpt Print - LV 3.0 Print - LV 3.0 nopanel true
Quick Filter	Insert excerpt Quick Filter Quick Filter nopanel true
Refresh	Insert excerpt Refresh - Global 3.0 Refresh - Global 3.0 nopanel true
Saved Column Layouts	Insert excerpt Column Layouts for Framework 3.0 - Global Column Layouts for Framework 3.0 - Global nopanel true
View	Image Modified Displays a drop down menu of options. The list of options includes: Transaction: Opens the Sales Transaction Record View for the selected transaction. Journal Details: Opens the Journal Details Record View to view journal entry details for the selected transaction.
Fields	Description
Checkbox	Insert excerpt Checkbox Checkbox nopanel true
Address ID	Insert excerpt Address ID Address ID nopanel true This can be edited from the 'Address ID' field on the 'Properties' tab of the Customer Addresses Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Def - Customer Address ID Def - Customer Address ID nopanel true Database Fields: ERPx_ARCustomerAddress.AddressID, ERPh_SOOrderHeader.AddressSK
Address Name	Insert excerpt Address ID Address ID nopanel true This can be edited from the 'Address Name' field on the 'Properties' tab of the Customer Addresses Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View. Database Fields: ERPx_ARCustomerAddress.AddressName, ERPh_SOOrderHeader.AddressSK
Amount	Identifies the sum of all the Line Items allocated extended amount, formatted to 2 decimal places. This is a calculated field and can only be edited by changing the unit/weight allocations or by updating the 'Price' field of a line item on the Sales Transaction Record View. It is calculated as ([Allocated Quantity] * [Price]), where [Allocated Quantity] is the Allocated 'Units' when the 'Price UOM' is a Unit UOM and it is the Allocated 'Weight' when the 'Price UOM' is a Weight UOM. Database Field: ERPx_SOOrderHeader.AllocatedAmount
Attention To	Insert excerpt Attention To Attention To nopanel true This is not required and can be edited by clicking the 'Ship To' address hyperlink on the 'Home' tab of the Sales Order Record View. Database Fields: ERPx_ARCustomerAddress.AttentionTo, ERPh_SOOrderHeader.ShipAttentionTo
Brokerage Amt.	Insert excerpt Def - Brokerage Amt. Def - Brokerage Amt. nopanel true This field displays the total 'Program Amt.' of all line items on the transaction that qualify for the program. This field is not required. This field is a calculated field and may be edited from the Sales Program Details Record Viewa calculated field and may be edited from the Sales Program Details Record View.  This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater. Database Field: ERPx_SPProgramSettlementItem.ComputedAmount
Currency	Insert excerpt Currency Currency nopanel true This comes from the 'Currency' field in the 'Home' tab of the Sales Order Record View. This field is not editable. Insert excerpt Def - Currency Def - Currency nopanel true Database Fields: ERPx_MFCurrency.CurrencyID, ERPh_SOOrderHeader.CurrencySK
Customer ID	Insert excerpt Customer ID - Transaction Customer ID - Transaction nopanel true This can be edited from the 'Customer ID' field on the 'Properties' tab of the Customer Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Def - Customer ID Def - Customer ID nopanel true Database Fields: ERPx_ARCustomer.CustomerID, ERPh_SOOrderHeader.CustomerSK
Customer Name	Insert excerpt Customer Name - Transaction Customer Name - Transaction nopanel true This can be edited from the 'Customer Name' field on the 'Properties' tab of the Customer Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Def - Customer Name Def - Customer Name nopanel true Database Fields: ERPx_ARCustomer.CustomerName, ERPh_SOOrderHeader.CustomerSK
Freight Amt.	Identifies the total freight amount for all shipments on the transaction. This field is not required. This can be edited by updating the 'Freight Rate', 'Surcharge %' or 'Other Charges' fields on the Shipment Details Record View. This is a calculated field and not stored in the database.
Insert excerpt
Def - Freight Amt.	Def - Freight Amt.
nopanel	true

Insert excerpt
Def - Freight Amt. Def - Freight Amt. nopanel true

 This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater.

GL Date
GL Period
GL Year
Gross Margin Amt.

Identifies the profit amount, using only product costs, on the transaction. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount.

Insert excerpt
Def - Gross Margin Amt. Def - Gross Margin Amt. nopanel true

Gross Margin Pct.

Identifies the percentage of profit, using only product costs, on the transaction. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount.

Insert excerpt
Def - Gross Margin Pct. Def - Gross Margin Pct. nopanel true

Invoice
Invoiced
Net Margin Amt.

Identifies the final profit amount on the transaction. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount.

Insert excerpt
Def - Net Margin Amt. Def - Net Margin Amt. nopanel true

Net Margin Pct.

Identifies the percentage of final profit on the transaction. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount.

Insert excerpt
Def - Net Margin Pct. Def - Net Margin Pct. nopanel true

Order #
Order Trans Class
Ordered

Insert excerpt
Doc Date Doc Date nopanel true

It is formatted from the users 'Date Format' preference. This can be edited from the 'Order Date' field on the 'Home' tab of the Sales Order Record View.

Database Field: ERPh_SOOrderHeader.OrderDate

Other Accrual Amt.

Insert excerpt
Def - Other Accrual Amt. Def - Other Accrual Amt. nopanel true

 This field displays the total 'Program Amt.' of all line items on the transaction that qualify for the program. This field is not required. This field is a calculated field and may be edited from the Sales Program Details Record View.

 This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater.

Database Field: ERPx_SPProgramSettlementItem.ComputedAmount

Payment Terms
Product Cost Amt.

Identifies the actual cost of all items on the transaction. This field is not required. If the item is ordered, but not allocated, this field may be edited from the 'Actual Cost' field for the Item in the Item Master File. It the item is allocated, this field may be edited from the 'Actual Cost' assigned on the Inventory Lot.

Insert excerpt
Def - Product Cost Amt. Def - Product Cost Amt. nopanel true

Database Fields: ERPx_SOOrderItem.ItemActualCost, ERPx_IMLotCostHistory.Cost, ERPx_IMLotBalance.LotSK

Purchase OrderSalesperson - Inside

Insert excerpt
Salesperson - Inside Salesperson - Inside nopanel true

This can be edited from the 'Salesperson - Inside Sales' field on the 'Properties' tab of the Sales Order Record View.

Insert excerpt
Def - Salesperson Def - Salesperson nopanel true

Insert excerpt
Def - Salesperson - Inside Def - Salesperson - Inside nopanel true

Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 2, ERPh_SOOrderHeader.InsideSalespersonSK

Salesperson - Outside

Insert excerpt
Salesperson - Outside Salesperson - Outside nopanel true

This can be edited from the 'Salesperson - Outside Sales' field on the 'Properties' tab of the Sales Order Record View.

Insert excerpt
Def - Salesperson Def - Salesperson nopanel true

Insert excerpt
Def - Salesperson - Outside Def - Salesperson - Outside nopanel true

Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 1, ERPh_SOOrderHeader.SalesPersonSK

Ship City/StateShip Country Ship PhoneStatusTrans Class

Insert excerpt
Def - Transaction Class - General Def - Transaction Class - General nopanel true

Database Field: ERPx_SOOrderType.DocumentID

Trans Type

Insert excerpt
Transaction Type Transaction Type nopanel true

It is a system assigned value and is not editable. The transaction types are: Quote, Order, Return and Price Adjustment.

Insert excerpt
Def - Transaction Types Def - Transaction Types nopanel true

Database Field: ERPx_ARTransactionType.TransactionName

Transaction 

Units

Identifies the sum of all the Line Items allocated 'Units', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of allocated 'Units' on one or more line items on the Sales Transaction Record View.

Database Field: ERPx_SOOrderHeader.AllocatedUnits

Weight

Identifies the sum of all the Line Items allocated 'Weight', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of allocated 'Weight' on one or more line items on the Sales Transaction Record View.

Database Field: ERPx_SOOrderHeader.AllocatedWeight