Custom Records

Record Types

Demand Order FQ

cseg_fq_setup_oo	This Segment tracks a Demand Order from estimate through to the final sale for analysis.
customrecord_cseg_fq_setup_oo

Field Name	Field ID	Field Help	Field Type
Amount (Base Currency)	custrecord_fq_setup_oo_amt_basecur_flt	This is the amount from the transaction in base currency.	Float
Amount (Subsidiary Currency)	custrecord_fq_setup_oo_amt_subscur_flt	This is the amount from the transaction in subsidiary currency.	Float
Amount (Transaction Currency)	custrecord_fq_setup_oo_amt_transcur_flt	This is the amount from the transaction.	Float
Base Currency	custrecord_fq_setup_oo_base_curr_lst	This is the base currency of the NetSuite account.	Select
Base Exchange Rate	custrecord_fq_setup_oo_base_exrate_flt	This is the exchange rate between source transaction and base currency.	Float
Class	custrecord_fq_setup_oo_class_lst	This is the class on the source transaction.	Select
Date	custrecord_fq_setup_oo_date_dt	This is the date of the source transaction.	Date
Department	custrecord_fq_setup_oo_department_lst	This is the department on the source transaction.	Select
Entity	custrecord_fq_setup_oo_entity_lst	This is the entity on the source transaction.	Select
Location	custrecord_fq_setup_oo_location_lst	This is the location on the source transaction.	Select
Net Amount	custrecord_fq_apm_oo_scamt_net_flt	This is the Net Amount.	Float
Net Amount (Base Currency)	custrecord_fq_apm_oo_scamt_net_bc_flt	This is the Net Amount in Base Currency.	Float
Net Amount (Subsidiary Currency)	custrecord_fq_apm_oo_scamt_net_sc_flt	This is the Net Amount in Subsidiary Currency.	Float
SC Billed Amount	custrecord_fq_apm_oo_scamt_billed_flt	This is the Sales Cost Billed Amount.	Float
SC Billed Amount (Base Currency)	custrecord_fq_apm_oo_scamt_billed_bc_flt	This is the Sales Cost Billed Amount in Base Currency.	Float
SC Billed Amount (Subsidiary Currency)	custrecord_fq_apm_oo_scamt_billed_sc_flt	This is the Sales Cost Billed Amount in Subsidiary Currency	Float
SC Budgeted Amount	custrecord_fq_apm_oo_scamt_budget_flt	This is the Sales Cost Budgeted Amount.	Float
SC Budgeted Amount (Base Currency)	custrecord_fq_apm_oo_scamt_budget_bc_flt	This is the Sales Cost Budgeted Amount in Base Currency.	Float
SC Budgeted Amount (Subsidiary Currency)	custrecord_fq_apm_oo_scamt_budget_sc_flt	This is the Sales Cost Budgeted Amount in Subsidiary Currency.	Float
SC Variance Amount	custrecord_fq_apm_oo_scamt_var_flt	This is the Sales Cost Variance Amount.	Float
SC Variance Amount (Base Currency)	custrecord_fq_apm_oo_scamt_var_bc_flt	This is the Sales Cost Variance Amount in Base Currency.	Float
SC Variance Amount (Subsidiary Currency)	custrecord_fq_apm_oo_scamt_var_sc_flt	This is the Sales Cost Variance Amount in Subsidiary Currency.	Float
Source Transaction	custrecord_fq_setup_oo_source_lst	This is the source transaction.	Select
Subsidiary	custrecord_fq_setup_oo_subsidiary_lst	This is the source transaction subsidiary.	Select
Subsidiary Currency	custrecord_fq_setup_oo_subs_cur_lst	This is the currency from the subsidiary.	Select
Subsidiary Exchange Rate	custrecord_fq_setup_oo_subs_exrate_flt	This is the exchange rate between source transaction and the subsidiary (1 / exchange rate).	Float
Transaction Currency	custrecord_fq_setup_oo_currency_lst	This is the currency on the source transaction.	Select
Transaction Exchange Rate	custrecord_fq_setup_oo_exchange_rate_flt	This is the exchange rate on the source transaction.	Float

Demand Order Line FQ

cseg_fq_setup_ool	This Segment tracks a Demand Order from estimate through to the final sale for analysis.
customrecord_cseg_fq_setup_ool

Field Name	Field ID	Field Help	Field Type
Amount (Base Currency)	custrecord_fq_setup_ool_amt_basecur_flt	This is the amount from the transaction in base currency.	FLOAT
Amount (Subsidiary Currency)	custrecord_fq_setup_ool_amt_subscur_flt	This is the amount from the transaction in subsidiary currency.	FLOAT
Amount (Transaction Currency)	custrecord_fq_setup_ool_amt_transcur_flt	This is the amount from the transaction.	FLOAT
Base Currency	custrecord_fq_setup_ool_base_curr_lst	This is the base currency of the NetSuite account.	SELECT
Base Exchange Rate	custrecord_fq_setup_ool_base_exrate_flt	This is the exchange rate between source transaction and base currency.	FLOAT
Class	custrecord_fq_setup_ool_class_lst	This is the class on the source transaction.	SELECT
Demand Order	custrecord_fq_setup_ool_oo_lst	This is the Demand Order.	SELECT
Department	custrecord_fq_setup_ool_department_lst	This is the department on the source transaction.	SELECT
Entity	custrecord_fq_setup_ool_entity_lst	This is the entity on the source transaction.	SELECT
Item	custrecord_fq_setup_ool_item_lst	This is the item on the source transaction.	SELECT
Line ID	custrecord_fq_setup_ool_lineid_int	This displays the line ID. This is auto generated by the system.	INTEGER
Line Unique Key	custrecord_fq_setup_ool_lnuniqkey_int	This displays the line unique key. This is auto generated by the system.	INTEGER
Location	custrecord_fq_setup_ool_location_lst	This is the location on the source transaction.	SELECT
Net Amount	custrecord_fq_apm_ool_scamt_net_flt	This is the Net Amount.	FLOAT
Net Amount (Base Currency)	custrecord_fq_apm_ool_scamt_net_bc_flt	This is the Net Amount in Base Currency.	FLOAT
Net Amount (Subsidiary Currency)	custrecord_fq_apm_ool_scamt_net_sc_flt	This is the Net Amount in Subsidiary Currency.	FLOAT
Net Rate	custrecord_fq_apm_ool_scrat_net_flt	This is the Net Rate.	FLOAT
Net Rate (Base Currency)	custrecord_fq_apm_ool_scrat_net_bc_flt	This is the Net Rate in Base Currency.	FLOAT
Net Rate (Subsidiary Currency)	custrecord_fq_apm_ool_scrat_net_sc_flt	This is the Net Rate in Subsidiary Currency.	FLOAT
Quantity	custrecord_fq_setup_ool_qty_flt	This is the quantity on the transaction.	FLOAT
Quantity Fulfilled	custrecord_fq_setup_ool_qty_fulfill_flt	This is the quantity fulfilled on the transaction.	FLOAT
Quantity Invoiced/Credited	custrecord_fq_setup_ool_qty_invcred_flt	This is the quantity invoiced/credited on the transaction.	FLOAT
Rate (Base Currency)	custrecord_fq_setup_ool_rate_basecur_flt	This is the rate from the transaction in base currency.	FLOAT
Rate (Subsidiary Currency)	custrecord_fq_setup_ool_rate_subscur_flt	This is the rate from the transaction in subsidiary currency.	FLOAT
Rate (Transaction Currency)	custrecord_fq_setup_ool_rate_trancur_flt	This is the rate from the transaction currency.	FLOAT
SC Billed Amount	custrecord_fq_apm_ool_scamt_bill_flt	This is the Sales Cost Billed Amount.	FLOAT
SC Billed Amount (Base Currency)	custrecord_fq_apm_ool_scamt_bill_bc_flt	This is the Sales Cost Billed Amount in Base Currency.	FLOAT
SC Billed Amount (Subsidiary Currency)	custrecord_fq_apm_ool_scamt_bill_sc_flt	This is the Sales Cost Billed Amount in Subsidiary Currency.	FLOAT
SC Budgeted Amount	custrecord_fq_apm_ool_scamt_budg_flt	This is the Sales Cost Budgeted Amount.	FLOAT
SC Budgeted Amount (Base Currency)	custrecord_fq_apm_ool_scamt_budg_bc_flt	This is the Sales Cost Budgeted Amount in Base Currency.	FLOAT
SC Budgeted Amount (Subsidiary Currency)	custrecord_fq_apm_ool_scamt_budg_sc_flt	This is the Sales Cost Budgeted Amount in Subsidiary Currency.	FLOAT
SC Variance Amount	custrecord_fq_apm_ool_scamt_var_flt	This is the Sales Cost Variance Amount.	FLOAT
SC Variance Amount (Base Currency)	custrecord_fq_apm_ool_scamt_var_bc_flt	This is the Sales Cost Variance Amount in Base Currency.	FLOAT
SC Variance Amount (Subsidiary Currency)	custrecord_fq_apm_ool_scamt_var_sc_flt	This is the Sales Cost Variance Amount in Subsidiary Currency.	FLOAT
Source Transaction	custrecord_fq_setup_ool_source_tran_lst	This is the source transaction.	SELECT
Starting Rate	custrecord_fq_apm_ool_startrate_flt	The starting price for Sales Cost Calculations.	FLOAT
Starting Rate (Base Currency)	custrecord_fq_apm_ool_scrate_bc_flt	The starting price for Sales Cost Calculations in Base Currency	FLOAT
Starting Rate (Subsidiary Currency)	custrecord_fq_apm_ool_startrate_sc_flt	The starting price for Sales Cost Calculations in Subsidiary Currency.	FLOAT
Subsidiary Currency	custrecord_fq_setup_ool_subs_cur_lst	This is the currency from the subsidiary.	SELECT
Subsidiary Exchange Rate	custrecord_fq_setup_ool_subs_exrate_flt	This is the exchange rate between source transaction and the subsidiary (1 / exchange rate).	FLOAT
Transaction Currency	custrecord_fq_setup_ool_currency_lst	This is the currency on the source transaction.	SELECT
Transaction Exchange Rate	custrecord_fq_setup_ool_exch_rate_flt	This is the exchange rate on the source transaction.	FLOAT
Units	custrecord_fq_setup_ool_units_lst	This is the units on the transaction.	SELECT

FoodQloud Setup

customrecord_fq_setup	This record is used to store setup for all FoodQloud-related modules and functionalities.

Field Name	Field ID	Field Help	Field Type
Advanced Profitability Management End of Support Date	custrecord_fq_setup_apm_eosupport_dt	The date of end of support for the installed Setup App version.	DATE
Automatically Process Landed Cost Variance	custrecord_fq_setup_apm_autovariance_cb	If this is checked, when a Landed Cost Vendor Bill is processed , a script will compare the rates between the Vendor Bill and Item Receipt.
	CHECKBOX
Date of Last License Check	custrecord_fq_setup_date_license_dtt	The last date the license was checked by the system	DATETIMETZ
Default Landed Cost PO Creation Method	custrecord_fq_setup_apm_lccostpometh_lst	The Cost PO Creation Method defines the standard procedure for generating Purchase Orders (POs) for costs.	SELECT
Default Percentage Decrease Rate Calculation Method	custrecord_fq_setup_apm_sc_perdemeth_lst	Select the default value to use as the starting value when a Sales Cost is used to decrease the rate.	SELECT
Default Percentage Increase Rate Calculation Method	custrecord_fq_setup_apm_sc_perinmeth_lst	Select the default value to use as the starting value when a Sales Cost is used to increase the rate.	SELECT
Default Primary Landed Cost Variance Method	custrecord_fq_setup_apm_prilcvarmeth_lst	Select a Primary method for handling discrepancies between estimated and actual landed costs.	SELECT
Default Sales Cost Custom Price Handling Method	custrecord_fq_setup_apm_sc_cstprmeth_lst	This setting allows for the differentiation between custom pricing derived from customer master data and custom pricing set on a transaction by a user. 
	SELECT
Default Sales Cost PO Creation Method	custrecord_fq_setup_apm_sccostpometh_lst	The Cost PO Creation Method defines the standard procedure for generating Purchase Orders (POs) for costs.	SELECT
Default Sales Cost Processing Method	custrecord_fq_setup_apm_processmeth_lst	The FQ Sales Cost Processing defines strategy for processing the Sales Cost record when transacting.	SELECT
Default Secondary Landed Cost Variance Method	custrecord_fq_setup_apm_seclcvarmeth_lst	Select a Secondary method for handling discrepancies between estimated and actual landed costs. This is mandatory if the primary method is Update Inventory Cost (Open Period Only)	SELECT
Demand Order Transactions	custrecord_fq_setup_ooc_tran_mlst	Select the transactions to which Demand Orders will be generated.	MULTISELECT
Enable Demand Order Creation	custrecord_fq_setup_ooc_cb	Enable this feature to track inventory from estimate to invoicing using Demand Orders (a custom record/segment)	CHECKBOX
Enable Demand Order Line Creation	custrecord_fq_setup_oolc_cb	Enable this feature to track inventory from estimate to invoicing using Demand Order lines (a custom record/segment).	CHECKBOX
Enable Inventory Number Allocation	custrecord_fq_setup_eim_ina_cb	Enable this feature to allow inventory number allocation to transaction lines.	CHECKBOX
Enable Landed Costs	custrecord_fq_setup_apm_lc_cb	Enable this feature to enhance the standard NetSuite landed cost functionality.	CHECKBOX
Enable Sales Costs	custrecord_fq_setup_apm_sc_cb	Enable this feature to track sales costs in addition to the cost of goods sold.	CHECKBOX
Enable Supply Order Creation	custrecord_fq_setup_ioc_cb	Enable this feature to track inventory from procurement (via purchase order or work order) to final sale using Supply Orders (a custom record/segment)	CHECKBOX
Enable Supply Order Line Creation	custrecord_fq_setup_iolc_cb	Enable this feature to track inventory from procurement (via purchase order or work order) to final sale using Supply Order lines (a custom record/segment).	CHECKBOX
Enhanced Inventory Management End of Support Date	custrecord_fq_setup_eim_eosupport_dt	The date of end of support for the installed Setup App version.	DATE
Enhanced Inventory Management Expiration	custrecord_fq_setup_eim_expiry_dt	The date of expiration for the Enhanced Inventory Management App	DATE
Enhanced Inventory Management Installed Version	custrecord_setup_vercur_eim	The current version installed for the Enhanced Inventory Management App.	TEXT
Enhanced Inventory Management Leading Version	custrecord_setup_verlead_eim	The current released version containing the latest features and updates for the Enhanced Inventory Management App.	TEXT
Enhanced Inventory Management Licensed?	custrecord_fq_setup_eim_cb		CHECKBOX
Excise Duty Management End of Support Date	custrecord_fq_setup_edm_eosupport_dt	The date of end of support for the installed Setup App version.	DATE
Excise Duty Management Expiration	custrecord_fq_setup_edm_expiry_dt	The date of expiration for Excise Duty Management App	DATE
Excise Duty Management Installed Version	custrecord_fq_setup_vercur_edm	The current version installed for the Excise Duty Management App.	TEXT
Excise Duty Management Leading Version	custrecord_fq_setup_verlead_edm	The current released version containing the latest features and updates for the Excise Duty Management App.	TEXT
Excise Duty Management Licensed?	custrecord_fq_setup_edm_cb	Is the Excise Duty Management App Licensed?	CHECKBOX
External ID	custrecord_fq_setup_externalid_str	This displays the external ID. The external ID is set by a script.	TEXT
Inventory Number Allocation Page Size	custrecord_fq_setup_eim_ina_pg_size_int	Enter the number of results to be returned when the inventory number allocation window page is loaded.	INTEGER
Landed Cost Rounding	custrecord_fq_setup_apm_lc_rounding_int	Landed Cost Rounding allows you to specify the rounding precision for calculated landed cost values. 
	INTEGER
Landed Cost Transactions	custrecord_fq_setup_apm_lc_tran_mlst	Select the procurement transactions to which landed costs will be applied.	MULTISELECT
Product Specifications End of Support Date	custrecord_fq_setup_ps_eosupport_dt	The date of end of support for the installed Setup App version.	DATE
Product Specifications Expiration	custrecord_fq_setup_ps_expiry_dt	The date of expiration for Product Specifications App	DATE
Product Specifications Installed Version	custrecord_fq_setup_vercur_ps	The current version installed for the Product Specifications App.	TEXT
Product Specifications Leading Version	custrecord_fq_setup_verlead_ps	The current released version containing the latest features and updates for the Product Specifications App.	TEXT
Product Specifications Licensed?	custrecord_fq_setup_ps_cb	Is the Product Specifications App Licensed?	CHECKBOX
Qloud Margin Control Expiration	custrecord_fq_setup_apm_expiry_dt	The date of expiration for the Qloud Margin Control App	DATE
Qloud Margin Control Installed Version	custrecord_fq_setup_vercur_apmtrack	The current version installed for the Qloud Margin Control App.	TEXT
Qloud Margin Control Leading Version	custrecord_fq_setup_verlead_apmtrack	The current released version containing the latest features and updates for the Qloud Margin Control App.	TEXT
Qloud Margin Control Licensed?	custrecord_fq_setup_apm_cb	Is the Qloud Margin Control App Licensed?	CHECKBOX
REST Feedback	custrecord_fq_setup_rest_feedback	This field contains any rest response that would contain an atypical response.	CLOBTEXT
Sales Cost Rounding	custrecord_fq_setup_apm_sc_rounding_int	Sales Cost Rounding allows specifying the rounding precision for calculated sales cost values. 
	INTEGER
Sales Cost Transactions	custrecord_fq_setup_apm_sc_tran_mlst	Select the demand transactions to which sales costs can be applied.	MULTISELECT
Setup End of Support Date	custrecord_fq_setup_eosupport_dt	The date of end of support for the installed App version.	DATE
Setup Expiration	custrecord_fq_setup_expiry_dt	The date of expiration for the Setup App	DATE
Setup Installed Version	custrecord_fq_setup_vercur_setup	The current version installed for the Setup App.	TEXT
Setup Leading Version	custrecord_fq_setup_verlead_setup	Setup Leading Version.	TEXT
Setup Licensed?	custrecord_fq_setup_cb	Is the Setup App Licensed?	CHECKBOX
Supply Order Transactions	custrecord_fq_setup_ioc_tran_mlst	Select the transactions to which Supply orders will be generated.	MULTISELECT
Sustainable Packaging End of Support Date	custrecord_fq_setup_sp_eosupport_dt	The date of end of support for the installed Setup App version.	DATE
Sustainable Packaging Expiration	custrecord_fq_setup_sp_expiry_dt	The date of expiration for the Sustainable Packaging App	DATE
Sustainable Packaging Installed Version	custrecord_fq_setup_vercur_sp	The current version installed for the Sustainable Packaging App.	TEXT
Sustainable Packaging Leading Version	custrecord_fq_setup_verlead_sp	The current released version containing the latest features and updates for the Sustainable Packaging App.	TEXT
Sustainable Packaging Licensed?	custrecord_fq_setup_sp_cb	Is the Sustainable Packaging App Licensed?	CHECKBOX
Unique ID	custrecord_fq_setup_uniqueid_str	The unique ID for the account / App. This is generated by a script.	TEXT
Update IR Rate based on Vendor Bill Rate	custrecord_fq_setup_apm_updt_ir_rate_cb	If this is checked, when a Vendor Bill is saved , a script will compare the rates between the Vendor Bill and Item Receipt. If there is a variance, the rate will be updated on the Item Receipt .	CHECKBOX
Update IR Rate Saved Search	custrecord_fq_setup_apm_updt_ir_srch_lst	If this is checked, when a Vendor Bill is saved , a script will compare the rates between the Vendor Bill and Item Receipt. If there is a variance, the rate will be updated on the Item Receipt.	SELECT

FoodQloud Transaction Configuration

customrecord_fq_setup_tran_module_config	This record is used to define which transactions are available for FoodQloud Modules. All standard records have been pre-configured however new records will be required for any custom transactions.

Field Name	Field ID	Field Help	Field Type
Create Outgoing Request	custrecord_fq_setup_tmc_ooc_cb	Enable this transaction to have it available for Outgoing Request selection. Once enabled, and the transaction is selected on FoodQloud Setup, Demand Orders will be created on the transaction.	CHECKBOX
Create Supply Order	custrecord_fq_setup_tmc_ioc_cb	Enable this transaction to have it available for Supply Order selection. Once enabled, and the transaction is selected on FoodQloud Setup, Supply Order will be created on the transaction.	CHECKBOX
Landed Cost Transactions	custrecord_fq_setup_tmc_lc_cb	Enable this transaction to have it available for Landed Cost selection. Once enabled, and the transaction is selected on FoodQloud Setup, Landed Costs will be enabled on the transaction.	CHECKBOX
Sales Cost Transcation	custrecord_fq_setup_tmc_sc_cb	Enable this transaction to have it available for Sales Cost selection. Once enabled, and the transaction is selected on FoodQloud Setup, Sales Cost will be enabled on the transaction.	CHECKBOX
Transaction Type	custrecord_fq_setup_tmc_transaction_lst	Select the transactions to specify which modules are available. After selection, a script will ensure the transaction has only been selected once.	SELECT

FQ Cost PO Creation Method

customrecord_fq_setup_cost_po_createmeth	This record defines the strategies for generating Purchase Orders (POs) related to costs.

Field Name	Field ID	Field Help	Field Type
Available for Landed Costs?	custrecord_fq_apm_cpocm_lc_available_cb	If checked, the Cost PO Creation method is available to be selected during landed cost processing.	CHECKBOX
Available for Sales Costs?	custrecord_fq_apm_cpocm_sc_available_cb	If checked, the Cost PO Creation method is available to be selected during sales cost processing.	CHECKBOX
Description	custrecord_fq_apm_cpocm_description_txt	The 'Description' field provides a detailed explanation of the selected Cost PO Creation Method, illustrating how purchase orders will be generated.	TEXTAREA

FQ Custom Price Handling

customrecord_fq_setup_custpricehandling	This list defines the custom price handling for Sales Costs.

Field Name	Field ID	Field Help	Field Type
Description	custrecord_fq_setup_cph_description	The Description field provides a detailed explanation of the Custom Price Handling Method	TEXTAREA

FQ Landed Cost Variance Method

customrecord_fq_setup_lc_var_meth

The 'Landed Cost Variance Management' record is designed to streamline the process of managing landed cost variances within NetSuite. This record enables users to select a preferred method for handling discrepancies between estimated and actual landed costs. By providing multiple options for variance handling, the record ensures that users can align the variance management process with their specific accounting practices and business needs.

Field Name	Field ID	Field Help	Field Type
Description	custrecord_fq_apm_lcvar_desc_txt	The 'Description' field provides a detailed explanation of the Landed Cost Variance Method.	TEXTAREA
Primary Landed Cost Variance Method	custrecord_fq_apm_lcvar_isprim_cb		CHECKBOX
Secondary Landed Cost Variance Method	custrecord_fq_apm_lcvar_issec_cb		CHECKBOX

FQ Setup Async Execution Request

customrecord_fq_setup_async_exec_request	This is a Custom Record used to store instruction for Asynchronous Processing.

Field Name	Field ID	Field Help	Field Type
Callback Parts	custrecord_fq_setup_aer_callback_txt	This stores the Callback Parts for the function that needs to be executed.	TEXT
Error	custrecord_fq_setup_aer_error_txt	In case of Error during the Async Execution Request, the message is stored here.	TEXT
Module Path	custrecord_fq_setup_aer_modulepath_txt	This stores the Module Path for the File that contains the function that needs to be processed.	TEXT
Parameters	custrecord_fq_setup_aer_params_ltxt	This stores the Parameters for the function that needs to be executed.	CLOBTEXT
Processed	custrecord_fq_setup_aer_processed_cb	This indicates if the Async Execution Request has been processed.	CHECKBOX

FQ Transaction Type

customrecord_fq_tran_type	This record is used to define which attributes the transaction has in relation to the FoodQloud functionality.

Field Name	Field ID	Field Help	Field Type
Description	custrecord_fq_tran_type_description	This field acts as a description to the transaction type.	TEXTAREA

Supply Order FQ

cseg_fq_setup_io	This Segment tracks a Supply Order from procurement through to the final sale for analysis.
customrecord_cseg_fq_setup_io

Field Name	Field ID	Field Help	Field Type
Amount (Base Currency)	custrecord_fq_setup_io_amt_basecur_flt	This is the amount from the transaction in base currency.	FLOAT
Amount (Subsidiary Currency)	custrecord_fq_setup_io_amt_subscur_flt	This is the amount from the transaction in subsidiary currency.	FLOAT
Amount (Transaction Currency)	custrecord_fq_setup_io_amt_transcur_flt	This is the amount from the transaction.	FLOAT
Base Currency	custrecord_fq_setup_io_base_curr_lst	This is the base currency of the NetSuite account.	SELECT
Base Exchange Rate	custrecord_fq_setup_io_base_exrate_flt	This is the exchange rate between source transaction and base currency.	FLOAT
Class	custrecord_fq_setup_io_class_lst	This is the class on the source transaction	SELECT
Date	custrecord_fq_setup_io_date_dt	This is the date of the source transaction.	DATE
Department	custrecord_fq_setup_io_department_lst	This is the department on the source transaction	SELECT
Entity	custrecord_fq_setup_io_entity_lst	This is the entity on the source transaction	SELECT
LC Billed Amount	custrecord_fq_apm_io_lcamt_billed_flt	This is the Landed Cost Billed Amount.	FLOAT
LC Billed Amount (Base Currency)	custrecord_fq_apm_io_lcamt_billed_bc_flt	This is the Landed Cost Billed Amount in Base Currency.	FLOAT
LC Billed Amount (Subsidiary Currency)	custrecord_fq_apm_io_lcamt_billed_sc_flt	This is the Landed Cost Billed Amount in Subsidiary Currency.	FLOAT
LC Budgeted Amount	custrecord_fq_apm_io_lcamt_budget_flt	This is the Landed Cost Budgeted Amount.	FLOAT
LC Budgeted Amount (Base Currency)	custrecord_fq_apm_io_lcamt_budget_bc_flt	This is the Landed Cost Budgeted Amount in Base Currency.	FLOAT
LC Budgeted Amount (Subsidiary Currency)	custrecord_fq_apm_io_lcamt_budget_sc_flt	This is the Landed Cost Budgeted Amount in Subsidiary Currency.	FLOAT
LC Variance Amount	custrecord_fq_apm_io_lcamt_var_flt	This is the Landed Cost Variance Amount.	FLOAT
LC Variance Amount (Base Currency)	custrecord_fq_apm_io_lcamt_var_bc_flt	This is the Landed Cost Variance Amount in Base Currency.	FLOAT
LC Variance Amount (Subsidiary Currency)	custrecord_fq_apm_io_lcamt_var_sc_flt	This is the Landed Cost Variance Amount in Subsidiary Currency.	FLOAT
Location	custrecord_fq_setup_io_location_lst	This is the location on the source transaction	SELECT
Source Transaction	custrecord_fq_setup_io_source_lst	This is the source transaction.	SELECT
Subsidiary	custrecord_fq_setup_io_subsidiary_lst	This is the source transaction subsidiary.	SELECT
Subsidiary Currency	custrecord_fq_setup_io_subs_cur_lst	This is the currency from the subsidiary.	SELECT
Subsidiary Exchange Rate	custrecord_fq_setup_io_subs_exrate_flt	This is the exchange rate between source transaction and the subsidiary (1 / exchange rate).	FLOAT
Total Cost	custrecord_fq_apm_io_totalcost_flt	This is the Total Cost (Amount + Landed Costs). If the Landed Costs are billed, the billed amount is used in the calculation. If the Landed Costs are pending billing, the budgeted amount is used.	FLOAT
Total Cost (Base Currency)	custrecord_fq_apm_io_totalcost_bc_flt	This is the Total Cost (Amount + Landed Costs) in Base Currency. If the Landed Costs are billed, the billed amount is used in the calculation. If the Landed Costs are pending billing, the budgeted amount is used.	FLOAT
Total Cost (Subsidiary Currency)	custrecord_fq_apm_io_totalcost_sc_flt	This is the Total Cost (Amount + Landed Costs) in Subsidiary Currency.If the Landed Costs are billed, the billed amount is used in the calculation. If the Landed Costs are pending billing, the budgeted amount is used.	FLOAT
Transaction Currency	custrecord_fq_setup_io_currency_lst	This is the currency on the source transaction.	SELECT
Transaction Exchange Rate	custrecord_fq_setup_io_exchange_rate_flt	This is the exchange rate on the source transaction.	FLOAT

Supply Order Line FQ

cseg_fq_setup_iol	This Segment tracks a Supply Order from procurement through to the final sale for analysis.
customrecord_cseg_fq_setup_iol

Field Name	Field ID	Field Help	Field Type
Amount (Base Currency)	custrecord_fq_setup_iol_amt_basecur_flt	This is the amount from the transaction in base currency.	FLOAT
Amount (Subsidiary Currency)	custrecord_fq_setup_iol_amt_subscur_flt	This is the amount from the transaction in subsidiary currency.	FLOAT
Amount (Transaction Currency)	custrecord_fq_setup_iol_amt_transcur_flt	This is the amount from the transaction.	FLOAT
Base Currency	custrecord_fq_setup_iol_base_curr_lst	This is the base currency of the NetSuite account.	SELECT
Base Exchange Rate	custrecord_fq_setup_iol_base_exrate_flt	This is the exchange rate between source transaction and base currency.	FLOAT
Class	custrecord_fq_setup_iol_class_lst	This is the class on the source transaction.	SELECT
Department	custrecord_fq_setup_iol_department_lst	This is the department on the source transaction.	SELECT
Entity	custrecord_fq_setup_iol_entity_lst	This is the entity on the source transaction.	SELECT
Item	custrecord_fq_setup_iol_item_lst	This is the item on the source transaction.	SELECT
LC Billed Amount	custrecord_fq_apm_iol_lcamt_bill_flt	This is the Landed Cost Billed Amount.	FLOAT
LC Billed Amount (Base Currency)	custrecord_fq_apm_iol_lcamt_bill_bc_flt	This is the Landed Cost Billed Amount in Base Currency.	FLOAT
LC Billed Amount (Subsidiary Currency)	custrecord_fq_apm_iol_lcamt_bill_sc_flt	This is the Landed Cost Billed Amount in Subsidiary Currency.	FLOAT
LC Budgeted Amount	custrecord_fq_apm_iol_lcamt_budg_flt	This is the Landed Cost Budgeted Amount.	FLOAT
LC Budgeted Amount (Base Currency)	custrecord_fq_apm_iol_lcamt_budg_bc_flt	This is the Landed Cost Budgeted Amount in Base Currency.	FLOAT
LC Budgeted Amount (Subsidiary Currency)	custrecord_fq_apm_iol_lcamt_budg_sc_fl	This is the Landed Cost Budgeted Amount in Subsidiary Currency.	FLOAT
LC Rate	custrecord_fq_apm_iol_lcrate_flt	This is the Landed Cost Rate.	FLOAT
LC Rate (Base Currency)	custrecord_fq_apm_iol_lcrate_bc_flt	This is the Landed Cost Rate in Base Currency.	FLOAT
LC Rate (Subsidiary Currency)	custrecord_fq_apm_iol_lcrate_sc_flt	This is the Landed Cost Rate in Subsidiary Currency.	FLOAT
LC Variance Amount	custrecord_fq_apm_iol_lcamt_var_flt	This is the Landed Cost Variance Amount.	FLOAT
LC Variance Amount (Base Currency)	custrecord_fq_apm_iol_lcamt_var_bc_flt	This is the Landed Cost Variance Amount in Base Currency.	FLOAT
LC Variance Amount (Subsidiary Currency)	custrecord_fq_apm_iol_lcamt_var_sc_flt	This is the Landed Cost Variance Amount in Subsidiary Currency.	FLOAT
Line ID	custrecord_fq_setup_iol_lineid_int	This displays the line ID. This is auto generated by the system.	INTEGER
Line Unique Key	custrecord_fq_setup_iol_lnuniqkey_int	This displays the line unique key. This is auto generated by the system.	INTEGER
Location	custrecord_fq_setup_iol_location_lst	This is the location on the source transaction.	SELECT
Quantity	custrecord_fq_setup_iol_qty_flt	This is the quantity on the transaction.	FLOAT
Quantity Billed / Completed	custrecord_fq_setup_iol_qty_billcomp_flt	This is the quantity billed/closed on the transaction.	FLOAT
Quantity Received / Built	custrecord_fq_setup_iol_qty_recbuilt_flt	This is the quantity received/built on the transaction.	FLOAT
Rate (Base Currency)	custrecord_fq_setup_iol_rate_basecur_flt	This is the rate from the transaction in base currency.	FLOAT
Rate (Subsidiary Currency)	custrecord_fq_setup_iol_rate_subscur_flt	This is the rate from the transaction in subsidiary currency.	FLOAT
Rate (Transaction Currency)	custrecord_fq_setup_iol_rate_trancur_flt	This is the rate from the transaction currency.	FLOAT
Source Transaction	custrecord_fq_setup_iol_source_tran_lst	This is the source transaction.	SELECT
Subsidiary Currency	custrecord_fq_setup_iol_subs_cur_lst	This is the currency from the subsidiary.	SELECT
Subsidiary Exchange Rate	custrecord_fq_setup_iol_subs_exrate_flt	This is the exchange rate between source transaction and the subsidiary (1 / exchange rate).	FLOAT
Supply Order	custrecord_fq_setup_iol_io_lst	This is the Supply Order.	SELECT
Total Cost	custrecord_fq_apm_iol_totalcost_flt	This is the Total Cost (Amount + Landed Costs).	FLOAT
Total Cost (Base Currency)	custrecord_fq_apm_iol_totalcost_bc_flt	This is the Total Cost (Amount + Landed Costs) in Base Currency. If the Landed Costs are billed, the billed amount is used in the calculation. If the Landed Costs are pending billing, the budgeted amount is used.	FLOAT
Total Cost (Subsidiary Currency)	custrecord_fq_apm_iol_totalcost_sc_flt	This is the Total Cost (Amount + Landed Costs) in Subsidiary Currency. If the Landed Costs are billed, the billed amount is used in the calculation. If the Landed Costs are pending billing, the budgeted amount is used.	FLOAT
Transaction Currency	custrecord_fq_setup_iol_currency_lst	This is the currency on the source transaction.	SELECT
Transaction Exchange Rate	custrecord_fq_setup_iol_exch_rate_flt	This is the exchange rate on the source transaction.	FLOAT
Units	custrecord_fq_setup_iol_units_lst	This is the units on the transaction	SELECT