# Custom Records

## Record Types

### FQ APM Async Execution Request

<table data-header-hidden data-full-width="false"><thead><tr><th width="380"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_async_exec_request</td><td>This is a Custom Record used to store instruction for Asynchronous Processing.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th width="139">Field Name</th><th width="169">Field ID</th><th width="318">Field Help</th><th width="143">Field Type</th></tr></thead><tbody><tr><td>Callback Parts</td><td>custrecord_fq_apm_aer_callback_txt</td><td>This stores the Callback Parts for the function that needs to be executed.</td><td>Text</td></tr><tr><td>Error</td><td>custrecord_fq_apm_aer_error_txt</td><td>In case of Error during the Async Execution Request, the message is stored here.</td><td>Text</td></tr><tr><td>Module Path</td><td>custrecord_fq_apm_aer_modulepath_txt</td><td>This stores the Module Path for the File that contains the function that needs to be processed.</td><td>Text</td></tr><tr><td>Parameters</td><td>custrecord_fq_apm_aer_params_ltxt</td><td>This stores the Parameters for the function that needs to be executed.</td><td>Clobtext</td></tr><tr><td>Processed</td><td>custrecord_fq_apm_aer_processed_cb</td><td>This indicates if the Async Execution Request has been processed.</td><td>Check Box</td></tr><tr><td>Record ID</td><td>custrecord_fq_apm_aer_recordid_int</td><td>This stores the Record ID for which this AER executes.</td><td>Integer</td></tr><tr><td>Record Type</td><td>custrecord_fq_apm_aer_recordtype_txt</td><td>This stores the Record Type for which this AER executes.</td><td>Text</td></tr><tr><td>Task ID</td><td>custrecord_fq_apm_aer_taskid_txt</td><td>This stores the Task ID that executes for this AER.</td><td>Text</td></tr></tbody></table>

### FQ FoodQloud Cost Calculation Method

<table data-header-hidden data-full-width="false"><thead><tr><th width="364"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_cost_calc_method</td><td>The Cost Calculation Method records defines the algorithms or formulas used to compute costs for items in transactions. It specifies how costs like freight, duties, and taxes are allocated ensuring accurate and consistent cost distribution.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th>Field ID</th><th width="338">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Available for Landed Costs?</td><td>custrecord_fq_apm_ccm_lc_available_cb</td><td>If checked, the cost calculation method is available to be selected during landed cost processing.</td><td>Check Box</td></tr><tr><td>Available for Sales Costs?</td><td>custrecord_fq_apm_ccm_sc_available_cb</td><td>If checked, the cost calculation method is available to be selected during sales cost processing.</td><td>Check Box</td></tr><tr><td>Description</td><td>custrecord_fq_apm_ccm_description_txt</td><td>The ';Description' field provides a detailed explanation of the selected cost calculation method, illustrating how costs are allocated within a transaction.</td><td>Textarea</td></tr><tr><td>Requires Sustainable Packaging?</td><td>custrecord_fq_apm_ccm_requires_sp_cb</td><td>If checked, the cost calculation method is available only if the sustainable Packaging App is installed</td><td>Check Box</td></tr></tbody></table>

### FQ Landed Cost Budget

<table data-header-hidden data-full-width="false"><thead><tr><th width="297"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_lc_budget</td><td>The 'Landed Cost Budget' record is designed for planning and managing anticipated additional costs on purchases, including duties, freight, and taxes. It aligns projected expenses with actuals, incorporating details like source transactions, budgeted amounts in local and source currencies, and exchange rates, ensuring effective cost control and financial oversight.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="176">Field ID</th><th width="326">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Auto-Apply Transactions</td><td>custrecord_fq_apm_lcb_autoappltrans_mlst</td><td>Specify transactions to which the budget record should be automatically applied to.</td><td>Multiselect</td></tr><tr><td>Calculation Method</td><td>custrecord_fq_apm_lcb_calc_method_lst</td><td>Describes the formula or method used to allocate landed costs to items/transactions.</td><td>Select</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_lcb_currency_lst</td><td>Specifies the currency in which the landed costs are calculated and applied.</td><td>Select</td></tr><tr><td>Description</td><td>custrecord_fq_apm_lcb_description_txt</td><td>Provide an overview or details about the budget record. This is shown on the Landed Cost Purchase Order.</td><td>Textarea</td></tr><tr><td>Item</td><td>custrecord_fq_apm_lcb_item_lst</td><td>Identifies the specific item within transactions that the landed cost is associated with.</td><td>Select</td></tr><tr><td>Landed Cost Category</td><td>custrecord_fq_apm_lcb_lc_category_lst</td><td>This is the landed cost item category. This is sourced from the landed cost item.</td><td>Select</td></tr><tr><td>Landed Cost Filters</td><td>custrecord_fq_apm_lcb_lcbfilters_ltxt</td><td>Aggregates the LCB Filters that should apply during the Landed Cost Process.<br><br>Filled in by script.</td><td>Clobtext</td></tr><tr><td>Landed Cost Item</td><td>custrecord_fq_apm_lcb_lc_item_lst</td><td>Specifies the item which is used on the landed Cost Purchase Order.</td><td>Select</td></tr><tr><td>Landed Cost Vendor</td><td>custrecord_fq_apm_lcb_lc_vendor_lst</td><td>Designates the vendor responsible for additional landed costs. This can be the same as the Vendor.</td><td>Select</td></tr><tr><td>Percent</td><td>custrecord_fq_apm_lcb_percent_per</td><td>Denotes the percentage used in the calculation of landed costs, relevant for certain calculation methods.</td><td>Percent</td></tr><tr><td>PO Creation Method</td><td>custrecord_fq_apm_lcb_po_createmeth_lst</td><td>Defines the approach for generating Purchase Orders for landed costs.</td><td>Select</td></tr><tr><td>Primary Landed Cost Variance Method</td><td>custrecord_fq_apm_lcb_privarmeth_lst</td><td>Select a Primary method for handling discrepancies between estimated and actual landed costs.</td><td>Select</td></tr><tr><td>Rate</td><td>custrecord_fq_apm_lcb_rate_flt</td><td>Indicates the rate to use in the cost calculation.</td><td>Float</td></tr><tr><td>Secondary Landed Cost Variance Method</td><td>custrecord_fq_apm_lcb_secvarmeth_lst</td><td>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).</td><td>Select</td></tr><tr><td>Vendor</td><td>custrecord_fq_apm_lcb_vendor_lst</td><td>Identifies the primary vendor associated with the goods or services being procured.</td><td>Select</td></tr></tbody></table>

### FQ Landed Cost Filter

<table data-header-hidden data-full-width="false"><thead><tr><th width="294"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_lcb_filter</td><td>The Landed Cost Filter record is designed to enhance the filtering capability of Landed Cost Budget records that are applied from Entity / Item to the Transaction during the Landed Cost process.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="198">Field ID</th><th width="299">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Applied Items</td><td>custrecord_fq_apm_lcfltr_applyitems_ltxt</td><td>This field displays the Applied Items for this Filter.</td><td>Clobtext</td></tr><tr><td>Auto-Apply Transactions</td><td>custrecord_fq_apm_lcfltr_appltrans_mlst</td><td>This field displays the Autoapply Transactions from Landed Cost Budget Record.</td><td>Multiselect</td></tr><tr><td>Calculation Method</td><td>custrecord_fq_apm_lcfltr_calc_method_lst</td><td>This field displays the Calculation Method from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_lcfltr_currency_lst</td><td>This field displays the Currency from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Description</td><td>custrecord_fq_apm_lcfltr_description_txt</td><td>This field displays the Description from Landed Cost Budget Record.</td><td>Textarea</td></tr><tr><td>Field Data Type</td><td>custrecord_fq_apm_lcfltr_flddatatype_lst</td><td>This field displays the Filter Field Data Type.</td><td>Select</td></tr><tr><td>Field Data Type ID</td><td>custrecord_fq_apm_lcfltr_flddatatype_int</td><td>This field displays the Filter Field Data Type ID.</td><td>Integer</td></tr><tr><td>Field Script ID</td><td>custrecord_fq_apm_lcfltr_fldscriptid_txt</td><td>This field displays the Filter Field Script ID.</td><td>Text</td></tr><tr><td>Filter Type</td><td>custrecord_fq_apm_lcfltr_filtertype_lst</td><td>This field displays the Filter APM Field Type.</td><td>Select</td></tr><tr><td>Item Saved Search</td><td>custrecord_fq_apm_lcfltr_itemss_lst</td><td>This field displays the Item Saved Search.</td><td>Select</td></tr><tr><td>Item Table Data HTML</td><td>custrecord_fq_apm_lcfltr_itemdata_ltxt</td><td>This field displays the Item Data Table HTML Definition.</td><td>Clobtext</td></tr><tr><td>Landed Cost Budget</td><td>custrecord_fq_apm_lcfltr_lcb_lst</td><td>This field displays the parent Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Landed Cost Category</td><td>custrecord_fq_apm_lcfltr_lc_category_lst</td><td>This field displays the Landed Cost Category from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Landed Cost Item</td><td>custrecord_fq_apm_lcfltr_lc_item_lst</td><td>This field displays the Landed Cost Item from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Landed Cost Vendor</td><td>custrecord_fq_apm_lcfltr_lcvendor_lst</td><td>This field displays the Landed Cost Vendor from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Operator</td><td>custrecord_fq_apm_lcfltr_operator_txt</td><td>This field displays the Filter Operator.</td><td>Text</td></tr><tr><td>Percent</td><td>custrecord_fq_apm_lcfltr_percent_per</td><td>This field displays the Percent from Landed Cost Budget Record.</td><td>Percent</td></tr><tr><td>PO Creation Method</td><td>custrecord_fq_apm_lcfltr_pocrtmeth_lst</td><td>This field displays the PO Creation Method from Parent Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Primary Landed Cost Variance Method</td><td>custrecord_fq_apm_lcfltr_privarmeth_lst</td><td>This field displays the Primary Landed Cost Variance Method from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Rate</td><td>custrecord_fq_apm_lcfltr_rate_flt</td><td>This field displays the Rate from Landed Cost Budget Record.</td><td>Float</td></tr><tr><td>Record Type ID</td><td>custrecord_fq_apm_lcfltr_rectype_txt</td><td>This field displays the Filter Record Type ID.</td><td>Clobtext</td></tr><tr><td>Secondary Landed Cost Variance Method</td><td>custrecord_fq_apm_lcfltr_secvarmeth_lst</td><td>This field displays the Secondary Landed Cost Variance Method from Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Value</td><td>custrecord_fq_apm_lcfltr_value_txt</td><td>This field displays the Filter Value.</td><td>Text</td></tr><tr><td>Value List ID</td><td>custrecord_fq_apm_lcfltr_valuelist_txt</td><td>This field displays the Filter Value Field List ID.</td><td>Text</td></tr><tr><td>Value To</td><td>custrecord_fq_apm_lcfltr_valueto_txt</td><td>This field displays the Filter Value To.</td><td>Text</td></tr><tr><td>Vendor</td><td>custrecord_fq_apm_lcfltr_vendor_lst</td><td>This field displays the Vendor from Landed Cost Budget Record.</td><td>Select</td></tr></tbody></table>

### FQ Landed Cost Filter Item Application

<table data-header-hidden data-full-width="false"><thead><tr><th width="393"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_lcb_lcfltr_itemapply</td><td>The Landed Cost Filter Item Application record is designed to enhance the Item filtering capability on the Landed Cost Filter.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="179">Field ID</th><th width="309">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Apply</td><td>custrecord_fq_apm_lcfltria_apply_cb</td><td>This field displays whether the Item is applied to the Landed Cost Filter.</td><td>Check Box</td></tr><tr><td>Item</td><td>custrecord_fq_apm_lcfltria_item_lst</td><td>This field displays the Item.</td><td>Select</td></tr><tr><td>Landed Cost Budget</td><td>custrecord_fq_apm_lcfltria_lcbudget_lst</td><td>This field displays the parent Landed Cost Budget Record.</td><td>Select</td></tr><tr><td>Landed Cost Filter</td><td>custrecord_fq_apm_lcfltria_lcfilter_lst</td><td>This field displays the parent Landed Cost Filter Record.</td><td>Select</td></tr></tbody></table>

### FQ Transaction Landed Cost

<table data-header-hidden data-full-width="false"><thead><tr><th width="417"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_lc_trans_rec</td><td>This custom record is used to store transaction landed costs records.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="191">Field ID</th><th width="345">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Applied To Items</td><td>custrecord_fq_apm_tlc_appltoitems_mlst</td><td>This Field displays the Items to which this Transaction Landed Cost is exclusively applied.<br><br>If this Field is empty, the Transaction Landed Cost Budget is not filtered based on Items.</td><td>Multiselect</td></tr><tr><td>Automatically Created</td><td>custrecord_fq_apm_tlc_autocreated_cb</td><td>If this is checked, when the Landed Cost Vendor Bill was processed, the variance has been automatically processed.</td><td>Check Box</td></tr><tr><td>Base Currency</td><td>custrecord_fq_apm_tlc_currency_bsc_lst</td><td>Specifies the base currency in the NetSuite account (sourced from Company Information).</td><td>Select</td></tr><tr><td>Base Exchange Rate</td><td>custrecord_fq_apm_tlc_exchrate_bsc_flt</td><td>Indicates the exchange rate between the Base Currency and the Landed Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Billed Amount</td><td>custrecord_fq_apm_tlc_amt_billed_flt</td><td>Represents the total billed amount for landed costs in the landed cost currency.</td><td>Float</td></tr><tr><td>Billed Amount (Base Currency)</td><td>custrecord_fq_apm_tlc_amt_billed_bsc_flt</td><td>Represents the total billed amount for landed costs in the base currency.</td><td>Float</td></tr><tr><td>Billed Amount (Source Currency)</td><td>custrecord_fq_apm_tlc_amt_billed_sc_flt</td><td>Represents the total billed amount for landed costs in the source transaction currency.</td><td>Float</td></tr><tr><td>Budgeted Amount</td><td>custrecord_fq_apm_tlc_amt_budget_flt</td><td>Represents the budgeted / total amount for landed costs in the landed cost currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Source Currency)</td><td>custrecord_fq_apm_tlc_amt_budget_sc_flt</td><td>Represents the budgeted / total amount for landed costs in the source transaction currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Base Currency)</td><td>custrecord_fq_apm_tlc_amt_budget_bsc_flt</td><td>Represents the budgeted / total amount for landed costs in the base currency.</td><td>Float</td></tr><tr><td>Calculation Data</td><td>custrecord_fq_apm_tlc_calcdata_ltxt</td><td>Shows the Calculation Data as an outcome of the Landed Cost Process.</td><td>Clobtext</td></tr><tr><td>Calculation Method</td><td>custrecord_fq_apm_tlc_calc_method_lst</td><td>Describes the method used to allocate landed costs to items/transactions.</td><td>Select</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_tlc_currency_lst</td><td>Specifies the currency in which the landed costs are calculated and applied.</td><td>Select</td></tr><tr><td>Date/Time Posted</td><td>custrecord_fq_apm_tlc_posted_dt</td><td>This field stores the date and time when the landed cost reconciliation record was created.</td><td>Date/Time</td></tr><tr><td>Description</td><td>custrecord_fq_apm_tlc_description_txt</td><td>Provide an overview or details about the landed cost record. This is shown on the Landed Cost Purchase Order.</td><td>Textarea</td></tr><tr><td>Filter Data</td><td>custrecord_fq_apm_tlc_filterdata_ltxt</td><td>Aggregates the LCB Filters that should apply during the Landed Cost Process.<br><br>Filled in by script.</td><td>Clobtext</td></tr><tr><td>Item Table Data HTML</td><td>custrecord_fq_apm_tlc_itemdata_ltxt</td><td>This field displays the Item Data Table HTML Definition.</td><td>Clobtext</td></tr><tr><td>Landed Cost Budget</td><td>custrecord_fq_apm_tlc_lcb_lst</td><td>Identifies the original landed cost budget record from which the transaction landed cost was created.</td><td>Select</td></tr><tr><td>Landed Cost Category</td><td>custrecord_fq_apm_tlc_lc_category_lst</td><td>This is the landed cost item category. This is sourced from the landed cost item</td><td>Select</td></tr><tr><td>Landed Cost Item</td><td>custrecord_fq_apm_tlc_lc_item_lst</td><td>Specifies the item which is used on the landed Cost Purchase Order. The item must be Other Charge for Purchase and cannot be fulfilled / received.</td><td>Select</td></tr><tr><td>Landed Cost PO</td><td>custrecord_fq_apm_tlc_lcpo_lst</td><td>This links the Transaction Landed Cost to the Landed Coost Purchase Order.</td><td>Select</td></tr><tr><td>Landed Cost Source</td><td>custrecord_fq_apm_tlc_lc_source_lst</td><td>This field displays the landed cost source</td><td>Select</td></tr><tr><td>Landed Cost Status</td><td>custrecord_fq_apm_tlc_lcstatus_lst</td><td>The status field indicates the current stage of the Transaction Landed Cost record in its lifecycle, from creation to resolution. It helps manage and track the progress of landed cost applications, variance handling, and billing.</td><td>Select</td></tr><tr><td>Landed Cost Vendor</td><td>custrecord_fq_apm_tlc_lc_vendor_lst</td><td>Designates the vendor responsible for additional expenses such as freight, duties, or taxes that comprise the landed costs.</td><td>Select</td></tr><tr><td>Landed Cost Vendor Bills</td><td>custrecord_fq_apm_tlc_vbills_mlst</td><td>This links the Transaction Landed Cost record to the Vendor Bills</td><td>Multiselect</td></tr><tr><td>Line Unique Key</td><td>custrecord_fq_apm_tlc_lineuniquekey_int</td><td>Line Unique Key from the Transaction Line.</td><td>Integer</td></tr><tr><td>Percent</td><td>custrecord_fq_apm_tlc_percent_per</td><td>Denotes the percentage used in the calculation of landed costs, relevant for certain calculation methods.</td><td>Percent</td></tr><tr><td>PO Creation Method</td><td>custrecord_fq_apm_tlc_po_createmeth_lst</td><td>PO Creation Method Defines the approach for generating Purchase Orders for landed costs.</td><td>Select</td></tr><tr><td>Primary Landed Cost Variance Method</td><td>custrecord_fq_apm_tlc_privarmeth_lst</td><td>Select a Primary method for handling discrepancies between estimated and actual landed costs.</td><td>Select</td></tr><tr><td>Quantity</td><td>custrecord_fq_apm_tlc_quantity_flt</td><td>Specifies the quantity for the landed cost. This is the quantity on the landed cost purchase order and is always calculated by the script.</td><td>Float</td></tr><tr><td>Rate</td><td>custrecord_fq_apm_tlc_rate_flt</td><td>Indicates the rate to use in the cost calculation.</td><td>Float</td></tr><tr><td>Secondary Landed Cost Variance Method</td><td>custrecord_fq_apm_tlc_secvarmeth_lst</td><td>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)</td><td>Select</td></tr><tr><td>Source Exchange Rate</td><td>custrecord_fq_apm_tlc_exchrate_sc_flt</td><td>Indicates the exchange rate between the Source Currency and the Landed Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Source Transaction</td><td>custrecord_fq_apm_tlc_sourc_trans_lst</td><td>Identifies the original transaction to which the landed costs are being applied.</td><td>Select</td></tr><tr><td>Source Transaction Currency</td><td>custrecord_fq_apm_tlc_currency_sc_lst</td><td>Specifies the currency used in the Source Transaction.</td><td>Select</td></tr><tr><td>Supply Order</td><td>custrecord_fq_apm_tlc_inorder_lst</td><td>Refers to the specific supply order linked to the landed costs.</td><td>Select</td></tr><tr><td>Updated Manually</td><td>custrecord_fq_apm_tlc_updated_man_cb</td><td>This field indicates if the landed cost has been updated manually by a user</td><td>Check Box</td></tr><tr><td>Variance Amount</td><td>custrecord_fq_apm_tlc_amt_var_flt</td><td>Represents the variance in the landed cost currency.</td><td>Float</td></tr><tr><td>Variance Amount (Base Currency)</td><td>custrecord_fq_apm_tlc_amt_var_bsc_flt</td><td>Represents the variance in the base currency.</td><td>Float</td></tr><tr><td>Variance Amount (Source Currency)</td><td>custrecord_fq_apm_tlc_amt_var_sc_flt</td><td>Represents the variance in the source transaction cost currency.</td><td>Float</td></tr><tr><td>Variance Transaction</td><td>custrecord_fq_apm_tlc_vartrans_mlst</td><td>This provides a link to the variance transaction(s).</td><td>Multiselect</td></tr><tr><td>Vendor</td><td>custrecord_fq_apm_tlc_vendor_lst</td><td>Specifies the primary vendor from whom the goods are purchased, related to the source transaction.</td><td>Select</td></tr></tbody></table>

### FQ Transaction Landed Cost Allocation

<table data-header-hidden data-full-width="false"><thead><tr><th width="331"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_lc_trans_alloc</td><td>The Transaction Landed Cost Allocation record documents the distribution/allocation of each Transaction Landed Cost to individual line items within a transaction. It provides granular details on how landed are apportioned across items, ensuring precise cost tracking and financial accuracy in inventory valuation.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="166">Field ID</th><th width="348">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Applied Item Receipt</td><td>custrecord_fq_apm_tlca_ir_mlst</td><td>Indicates the Item Receipt that the landed cost allocation has been applied to, confirming the receipt of goods and the associated costs.</td><td>Multiselect</td></tr><tr><td>Automatically Created</td><td>custrecord_fq_apm_tlca_autocreated_cb</td><td>If this is checked, when the Landed Cost Vendor Bill was processed, the variance has been automatically processed.</td><td>Check Box</td></tr><tr><td>Base Currency</td><td>custrecord_fq_apm_tlca_currency_bc_lst</td><td>Specifies the base currency.</td><td>Select</td></tr><tr><td>Base Exchange Rate</td><td>custrecord_fq_apm_tlca_exchrate_bc_flt</td><td>Indicates the exchange rate between the Base Currency and the Landed Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Billed Amount</td><td>custrecord_fq_apm_tlca_amt_billed_flt</td><td>Shows the amount billed for the landed costs in transaction landed cost currency.</td><td>Float</td></tr><tr><td>Billed Amount (Base Currency)</td><td>custrecord_fq_apm_tlca_amt_billed_bc_flt</td><td>Shows the amount billed for the landed costs in base currency.</td><td>Float</td></tr><tr><td>Billed Amount (Source Currency)</td><td>custrecord_fq_apm_tlca_amt_billed_sc_flt</td><td>Shows the amount billed for the landed costs in transaction source currency.</td><td>Float</td></tr><tr><td>Billed Rate</td><td>custrecord_fq_apm_tlca_rat_billed_flt</td><td>Shows the rate billed for the landed costs in transaction landed cost currency.</td><td>Float</td></tr><tr><td>Billed Rate (Source Currency)</td><td>custrecord_fq_apm_tlca_rat_billed_sc_flt</td><td>Shows the rate billed for the landed costs in transaction source currency.</td><td>Float</td></tr><tr><td>Billed Rate (Base Currency)</td><td>custrecord_fq_apm_tlca_rat_billed_bc_flt</td><td>Shows the rate billed for the landed costs in base currency.</td><td>Float</td></tr><tr><td>Budgeted Amount</td><td>custrecord_fq_apm_tlca_amt_budget_flt</td><td>Shows the amount initially budgeted for the landed costs in transaction landed cost currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Base Currency)</td><td>custrecord_fq_apm_tlca_amt_budget_bc_flt</td><td>Shows the amount initially budgeted for the landed costs in the base currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Source Currency)</td><td>custrecord_fq_apm_tlca_amt_budget_sc_flt</td><td>Shows the amount initially budgeted for the landed costs in transaction source currency.</td><td>Float</td></tr><tr><td>Budgeted Rate</td><td>custrecord_fq_apm_tlca_rat_budget_flt</td><td>Shows the rate initially budgeted for the landed costs in transaction landed cost currency.</td><td>Float</td></tr><tr><td>Budgeted Rate (Base Currency)</td><td>custrecord_fq_apm_tlca_rat_budget_bc_flt</td><td>Shows the rate initially budgeted for the landed costs in the base currency.</td><td>Float</td></tr><tr><td>Budgeted Rate (Source Currency)</td><td>custrecord_fq_apm_tlca_rat_budget_sc_flt</td><td>Shows the rate initially budgeted for the landed costs in transaction source currency.</td><td>Float</td></tr><tr><td>Calculation Data</td><td>custrecord_fq_apm_tlca_calcdata_ltxt</td><td>Shows the Calculation Data as an outcome of the Landed Cost Process.</td><td>Clobtext</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_tlca_currency_lst</td><td>Specifies the currency in which the landed costs are calculated and applied.</td><td>Select</td></tr><tr><td>Date/Time Posted</td><td>custrecord_fq_apm_tlca_posted_dt</td><td>This field stores the date and time when the landed cost reconciliation record was created.</td><td>Date/Time</td></tr><tr><td>Item</td><td>custrecord_fq_apm_tlca_item_lst</td><td>Identifies the specific item to which the landed cost is allocated, linking the cost directly to the affected inventory</td><td>Select</td></tr><tr><td>Landed Cost Budget</td><td>custrecord_fq_apm_tlca_lcb_lst</td><td>Identifies the original landed cost budget record from which the transaction landed cost distribution was created.</td><td>Select</td></tr><tr><td>Landed Cost PO</td><td>custrecord_fq_apm_tlca_lcpo_lst</td><td>References the Purchase Order created specifically for the landed costs being allocated, ensuring traceability of the expenses.</td><td>Select</td></tr><tr><td>Landed Cost Vendor Bills</td><td>custrecord_fq_apm_tlca_vbills_mlst</td><td>Indicates the Vendor Bill that the landed cost allocation has been billed on.</td><td>Multiselect</td></tr><tr><td>Line Unique Key</td><td>custrecord_fq_apm_tlca_lineuniquekey_int</td><td>A unique identifier for the transaction line within the allocation record, ensuring precise tracking and differentiation of cost allocation</td><td>Integer</td></tr><tr><td>Quantity</td><td>custrecord_fq_apm_tlca_quantity_int</td><td>Displays the quantity for the landed cost allocation.</td><td>Integer</td></tr><tr><td>Source Exchange Rate</td><td>custrecord_fq_apm_tlca_exchrate_sc_flt</td><td>Indicates the exchange rate between the Source Currency and the Landed Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Source Transaction</td><td>custrecord_fq_apm_tlca_sourc_trans_lst</td><td>Identifies the original transaction to which the landed costs are being applied.</td><td>Select</td></tr><tr><td>Source Transcation Currency</td><td>custrecord_fq_apm_tlca_currency_sc_lst</td><td>Specifies the currency used in the Source Transaction.</td><td>Select</td></tr><tr><td>Supply Order</td><td>custrecord_fq_apm_tlca_inorder_lst</td><td>Denotes the incoming order or shipment to which the landed costs apply.</td><td>Select</td></tr><tr><td>Supply Order Line</td><td>custrecord_fq_apm_tlca_inorderln_lst</td><td>Specifies the particular line within the Incoming Order that is associated with the allocated cost.</td><td>Select</td></tr><tr><td>Transaction Landed Cost</td><td>custrecord_fq_apm_tlca_tlc_lst</td><td>Associates this allocation with a specific Transaction Landed Cost record, detailing the landed costs incurred</td><td>Select</td></tr><tr><td>Variance Amount</td><td>custrecord_fq_apm_tlca_amt_var_flt</td><td>Represents the variance in the landed cost currency.</td><td>Float</td></tr><tr><td>Variance Amount (Base Currency)</td><td>custrecord_fq_apm_tlca_amt_var_bc_flt</td><td>Represents the variance in the base currency.</td><td>Float</td></tr><tr><td>Variance Amount (Source Currency)</td><td>custrecord_fq_apm_tlca_amt_var_sc_flt</td><td>Represents the variance in the source transaction cost currency.</td><td>Float</td></tr><tr><td>Variance Transaction</td><td>custrecord_fq_apm_tlca_vartrans_mlst</td><td>This provides a link to the variance transaction(s).</td><td>Multiselect</td></tr></tbody></table>

### FQ Cost Record Status

<table data-header-hidden data-full-width="false"><thead><tr><th width="333"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_costrec_status</td><td>The status record indicates the current stage of the Transaction Landed / Sales Cost record in its lifecycle, from creation to resolution. It helps manage and track the progress of landed cost applications, variance handling, and billing.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="185">Field ID</th><th width="305">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Description</td><td>custrecord_fq_apm_costrec_stat_desc_txt</td><td>The 'Description' field provides a detailed explanation of the Landed / Sales Cost Status.</td><td>Textarea</td></tr></tbody></table>

### TQ Sales Cost Budget

<table data-header-hidden data-full-width="false"><thead><tr><th width="301"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_sc_budget</td><td><p>The Sales Cost Budget record is designed for planning and managing anticipated additional costs on sales, including duties, freight, and taxes. It aligns projected expenses with actuals ensuring effective cost control and financial oversight.</p><p><br>Budgets can be loaded against customers, items or a combination of both to automate the processing of sales costs.</p></td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="210">Field ID</th><th width="296">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Auto-Apply Transactions</td><td>custrecord_fq_apm_scb_autoappltrans_mlst</td><td>Specify transactions to which the budget record should be automatically applied to.</td><td>Multiselect</td></tr><tr><td>Calculation Method</td><td>custrecord_fq_apm_scb_calc_method_lst</td><td>Describes the calculation method used to allocate sales costs to items/transactions.</td><td>Select</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_scb_currency_lst</td><td>Defines the currency to use on the generated Purchase Order.</td><td>Select</td></tr><tr><td>Custom Price Calculation Method</td><td>custrecord_fq_apm_scb_cpm_lst</td><td>This setting allows for the differentiation between custom pricing derived from customer master data and custom pricing set on a transaction by a user.</td><td>Select</td></tr><tr><td>Customer</td><td>custrecord_fq_apm_scb_customer_lst</td><td>Identifies the customer associated with the goods or services being sold.</td><td>Select</td></tr><tr><td>Description</td><td>custrecord_fq_apm_scb_description_txt</td><td>Provide an overview or details about the budget record. This is shown on the Sales Cost Purchase Order.</td><td>Textarea</td></tr><tr><td>Item</td><td>custrecord_fq_apm_scb_item_lst</td><td>Identifies the specific item within transactions that the sales cost is associated with.</td><td>Select</td></tr><tr><td>Percent</td><td>custrecord_fq_apm_scb_percent_per</td><td>Denotes the percentage used in the calculation of sales costs, relevant for certain calculation methods.</td><td>Float</td></tr><tr><td>Percentage Increase Rate Calculation Method</td><td>custrecord_fq_apm_scb_perinccm_lst</td><td>Select the default value to use as the starting value when a Sales Cost is used to increase the rate.</td><td>Select</td></tr><tr><td>Percentage Decrease Rate Calculation Method</td><td>custrecord_fq_apm_scb_perdeccm_lst</td><td>Select the default value to use as the starting value when a Sales Cost is used to decrease the rate.</td><td>Select</td></tr><tr><td>PO Creation Method</td><td>custrecord_fq_apm_scb_po_createmeth_lst</td><td>Defines the approach for generating Purchase Orders for sales costs.</td><td>Select</td></tr><tr><td>Rate</td><td>custrecord_fq_apm_scb_rate_flt</td><td>Indicates the rate to use in the cost calculation.</td><td>Float</td></tr><tr><td>Sales Cost Item</td><td>custrecord_fq_apm_scb_sc_item_lst</td><td>Specifies the item to be used for costing.<br><br>This item will appear on transactions and impacts the general ledger.<br><br>The item must be Other Charge for Resale OR  Service for Resale and the native field ‘Can Be Fulfilled / Received’ should be set to FALSE.</td><td>Select</td></tr><tr><td>Sales Cost Filters</td><td>custrecord_fq_apm_scb_scbfilters_ltxt</td><td>Aggregates the SCB Filters that should apply during the Sales Cost Process.<br><br>Filled in by script.</td><td>Clobtext</td></tr><tr><td>Sales Cost Processing Method</td><td>custrecord_fq_apm_scb_processmeth_lst</td><td>The Sales Cost Processing defines the method for processing the Transaction Sales Cost record.</td><td>Select</td></tr><tr><td>Sales Cost Vendor</td><td>custrecord_fq_apm_scb_sc_vendor_lst</td><td>Designates the vendor responsible for additional sales costs. This can be the same as the Vendor.</td><td>Select</td></tr></tbody></table>

### TQ Sales Cost Filter

<table data-header-hidden data-full-width="false"><thead><tr><th width="297"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_scb_filter</td><td>The Sales Cost Filter record is designed to enhance the filtering capability of Sales Cost Budget records that are applied from Entity / Item to the Transaction during the Sales Cost process.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="193">Field ID</th><th width="326">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Applied Items</td><td>custrecord_fq_apm_scfltr_applyitems_ltxt</td><td>This field displays the Applied Items for this Filter.</td><td>Clobtext</td></tr><tr><td>Auto-Apply Transactions</td><td>custrecord_fq_apm_scfltr_appltrans_mlst</td><td>This field displays the Autoapply Transactions from Sales Cost Budget Record.</td><td>Multiselect</td></tr><tr><td>Calculation Method</td><td>custrecord_fq_apm_scfltr_calc_method_lst</td><td>This field displays the Calculation Method from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_scfltr_currency_lst</td><td>This field displays the Currency from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Custom Price Handling</td><td>custrecord_fq_apm_scfltr_cpm_lst</td><td>This field displays the Custom Price Handling from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Customer</td><td>custrecord_fq_apm_scfltr_customer_lst</td><td>This field displays the Customer from Sales Cost Budget Record.</td><td>Text</td></tr><tr><td>Description</td><td>custrecord_fq_apm_scfltr_description_txt</td><td>This field displays the Description from Sales Cost Budget Record.</td><td>Textarea</td></tr><tr><td>Field Data Type</td><td>custrecord_fq_apm_scfltr_flddatatype_lst</td><td>This field displays the Filter Field Data Type.</td><td>Select</td></tr><tr><td>Field Data Type ID</td><td>custrecord_fq_apm_scfltr_flddatatype_int</td><td>This field displays the Filter Field Data Type ID.</td><td>Integer</td></tr><tr><td>Field Script ID</td><td>custrecord_fq_apm_scfltr_fldscriptid_txt</td><td>This field displays the Filter Field Script ID.</td><td>Text</td></tr><tr><td>Filter Type</td><td>custrecord_fq_apm_scfltr_filtertype_lst</td><td>This field displays the Filter APM Field Type.</td><td>Select</td></tr><tr><td>Item Saved Search</td><td>custrecord_fq_apm_scfltr_itemss_lst</td><td>This field displays the Item Saved Search.</td><td>Select</td></tr><tr><td>Item Table Data HTML</td><td>custrecord_fq_apm_scfltr_itemdata_ltxt</td><td>This field displays the Item Data Table HTML Definition.</td><td>Clobtext</td></tr><tr><td>Operator</td><td>custrecord_fq_apm_scfltr_operator_txt</td><td>This field displays the Filter Value Field List ID.</td><td>Text</td></tr><tr><td>Percent</td><td>custrecord_fq_apm_scfltr_percent_per</td><td>This field displays the Percent from Landed Cost Budget Record.</td><td>Float</td></tr><tr><td>Percentage Decrease Rate Calculation Method</td><td>custrecord_fq_apm_scfltr_perdeccm_lst</td><td>This field displays the Percentage Decrease Rate Calculation Method from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Percentage Increase Rate Calculation Method</td><td>custrecord_fq_apm_scfltr_perinccm_lst</td><td>This field displays the Percentage Increase Rate Calculation Method from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>PO Creation Method</td><td>custrecord_fq_apm_scfltr_pocrtmeth_lst</td><td>This field displays the PO Creation Method from Parent Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Rate</td><td>custrecord_fq_apm_scfltr_rate_flt</td><td>This field displays the Rate from Sales Cost Budget Record.</td><td>Float</td></tr><tr><td>Record Type ID</td><td>custrecord_fq_apm_scfltr_rectype_txt</td><td>This field displays the Filter Record Type ID.</td><td>Clobtext</td></tr><tr><td>Sales Cost Budget</td><td>custrecord_fq_apm_scfltr_scb_lst</td><td>This field displays the parent Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Sales Cost Item</td><td>custrecord_fq_apm_scfltr_sc_item_lst</td><td>This field displays the Sales Cost Item from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Sales Cost Processing Method</td><td>custrecord_fq_apm_scfltr_processmeth_lst</td><td>This field displays the Sales Cost Processing Method from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Sales Cost Vendor</td><td>custrecord_fq_apm_scfltr_scvendor_lst</td><td>This field displays the Sales Cost Vendor from Sales Cost Budget Record.</td><td>Select</td></tr><tr><td>Value</td><td>custrecord_fq_apm_scfltr_value_txt</td><td>This field displays the Filter Value.</td><td>Text</td></tr><tr><td>Value List ID</td><td>custrecord_fq_apm_scfltr_valuelist_txt</td><td>This field displays the Filter Field Data Type ID.</td><td>Text</td></tr><tr><td>Value To</td><td>custrecord_fq_apm_scfltr_valueto_txt</td><td>This field displays the Filter Value To.</td><td>Text</td></tr></tbody></table>

### TQ Sales Cost Filter Item Application

<table data-header-hidden data-full-width="false"><thead><tr><th width="377"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_scb_scfltr_itemapply</td><td>The Sales Cost Filter Item Application record is designed to enhance the Item filtering capability on the Sales Cost Filter.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="187">Field ID</th><th width="303">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Apply</td><td>custrecord_fq_apm_scfltria_apply_cb</td><td>This field displays whether the Item is applied to the Sales Cost Filter.</td><td>Check Box</td></tr><tr><td>Item</td><td>custrecord_fq_apm_scfltria_item_lst</td><td>This field displays the Item.</td><td>Select</td></tr><tr><td>Sales Cost Filter</td><td>custrecord_fq_apm_scfltria_scfilter_lst</td><td>This field displays the parent Sales Cost Filter Record.</td><td>Select</td></tr><tr><td>Sales Cost Budget</td><td>custrecord_fq_apm_scfltria_scbudget_lst</td><td>This field displays the parent Sales Cost Budget Record.</td><td>Select</td></tr></tbody></table>

### TQ Sales Cost Percentage Change Method

<table data-header-hidden data-full-width="false"><thead><tr><th width="442"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_sc_perchangemeth</td><td>This record defines the calculation methods available when using percentage change calculation methods.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="196">Field ID</th><th width="295">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Description</td><td>custrecord_fq_apm_sc_perchm_description</td><td>The Description field provides a detailed explanation of the Sales Cost Percentage Change Method</td><td>Textarea</td></tr><tr><td>Net Rate</td><td>val_fqapm_scpchm_netrate</td><td>This is the rate of selling the item plus/minus all the applicable costs required to deliver it to the customer.<br><br>The Net Rate provides a more accurate reflection of what the company has spent to sell the item.<br><br>It is calculated as the (Gross Amount - Sales Costs) / Quantity.</td><td>Instance</td></tr><tr><td>Rate</td><td>val_fqapm_scpchm_rate</td><td>The price charged to the customer for a single unit of product / service.<br><br>Sales Costs can increase or decrease the rate.</td><td>Instance</td></tr><tr><td>Starting Rate</td><td>val_fqapm_scpchm_startrate</td><td>The starting price for Sales Cost Calculations. This is sourced from the customer or item but could be changed on a transaction.</td><td>Instance</td></tr></tbody></table>

### TQ Sales Cost Processing Method

<table data-header-hidden data-full-width="false"><thead><tr><th width="377"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_sc_processmeth</td><td>The TQ Sales Cost Processing defines strategy for processing the Sales Cost record when transacting.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="177">Field ID</th><th width="328">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Add as Line Item - Individual</td><td>val_fqapm_scpm_addasindividual</td><td>This method adds each sales cost budget as a separate line item on the transaction.</td><td>Instance</td></tr><tr><td>Add as Discount Item</td><td>val_fqapm_scpm_addasdiscount</td><td>This method applies the sales cost as a discount item, inserting a discount line underneath each applicable line item. This can be an increase or decrease.</td><td>Instance</td></tr><tr><td>Add as Line Item - Grouped</td><td>val_fqapm_scpm_addasgrouped</td><td>This method groups each sales cost budget per sales cost and then combines into a transaction line.</td><td>Instance</td></tr><tr><td>Change Rate</td><td>val_fqapm_scpm_changerate</td><td>This method changes the rate on the transaction to include the sales cost, directly altering the transaction amount.</td><td>Instance</td></tr><tr><td>Change Rate and Custom GL Posting</td><td>val_fqapm_scpm_changerategl</td><td>This method adjusts the rate on the transaction and posts the sales cost as a custom GL posting based on the item selected.</td><td>Instance</td></tr><tr><td>Custom GL Posting</td><td>val_fqapm_scpm_changegl</td><td>This method posts the sales cost to the general ledger based on the item selected, without altering the transaction amount or rates.</td><td>Instance</td></tr><tr><td>Description</td><td>custrecord_fq_apm_sc_pm_description</td><td>The 'Description' field provides a detailed explanation of the selected sales cost processing, illustrating how costs are processed within a transaction.</td><td>Textarea</td></tr><tr><td>No GL Posting</td><td>val_fqapm_scpm_nogl</td><td>This method processes the sales cost without posting any entries to the General Ledger, ensuring no financial impact.</td><td>Instance</td></tr></tbody></table>

### TQ Transaction Sales Cost Allocation

<table data-header-hidden data-full-width="false"><thead><tr><th width="328"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_sc_trans_alloc</td><td>The Transaction Sales Cost Allocation record documents the distribution/allocation of each Transaction Sales Cost to individual line items within a transaction. It provides granular details on how landed are apportioned across items, ensuring precise cost tracking and financial accuracy in inventory valuation.</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="194">Field ID</th><th width="301">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Automatically Created</td><td>custrecord_fq_apm_tsca_autocreated_cb</td><td>If this is checked, when the Sales Cost Vendor Bill was processed, the variance has been automatically processed.</td><td>Check Box</td></tr><tr><td>Base Currency</td><td>custrecord_fq_apm_tsca_currency_bc_lst</td><td>Specifies the base currency.</td><td>Select</td></tr><tr><td>Base Exchange Rate</td><td>custrecord_fq_apm_tsca_exchrate_bc_flt</td><td>Indicates the exchange rate between the Base Currency and the Landed Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Billed Amount</td><td>custrecord_fq_apm_tsca_amt_billed_flt</td><td>Shows the amount billed for the sales costs in transaction sales cost currency.</td><td>Float</td></tr><tr><td>Billed Amount (Base Currency)</td><td>custrecord_fq_apm_tsca_amt_billed_bc_flt</td><td>Shows the amount billed for the sales costs in base currency.</td><td>Float</td></tr><tr><td>Billed Amount (Source Currency)</td><td>custrecord_fq_apm_tsca_amt_billed_sc_flt</td><td>Shows the amount billed for the sales costs in transaction source currency.</td><td>Float</td></tr><tr><td>Billed Rate</td><td>custrecord_fq_apm_tsca_rat_billed_flt</td><td>Shows the rate billed for the sales costs in transaction landed cost currency.</td><td>Float</td></tr><tr><td>Billed Rate (Base Currency)</td><td>custrecord_fq_apm_tsca_rat_billed_bc_flt</td><td>Shows the rate billed for the sales costs in base currency.</td><td>Float</td></tr><tr><td>Billed Rate (Source Currency)</td><td>custrecord_fq_apm_tsca_rat_billed_sc_flt</td><td>Shows the rate billed for the sales costs in transaction source currency.</td><td>Float</td></tr><tr><td>Budgeted  Rate</td><td>custrecord_fq_apm_tsca_rat_budget_flt</td><td>Shows the rate initially budgeted for the sales costs in transaction landed cost currency.</td><td>Float</td></tr><tr><td>Budgeted Amount</td><td>custrecord_fq_apm_tsca_amt_budget_flt</td><td>Shows the amount initially budgeted for the sales costs in transaction sales cost currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Base Currency)</td><td>custrecord_fq_apm_tsca_amt_budget_bc_flt</td><td>Shows the amount initially budgeted for the sales costs in the base currency.</td><td>Float</td></tr><tr><td>Budgeted Rate (Base Currency)</td><td>custrecord_fq_apm_tsca_rat_budget_bc_flt</td><td>Shows the rate initially budgeted for the sales costs in the base currency.</td><td>Float</td></tr><tr><td>Budgeted Rate (Source Currency)</td><td>custrecord_fq_apm_tsca_rat_budget_sc_flt</td><td>Shows the rate initially budgeted for the sales costs in transaction source currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Source Currency)</td><td>custrecord_fq_apm_tsca_amt_budget_sc_flt</td><td>Shows the amount initially budgeted for the sales costs in transaction source currency.</td><td>Float</td></tr><tr><td>Calculation Data</td><td>custrecord_fq_apm_tsca_calcdata_ltxt</td><td>Shows the Calculation Data as an outcome of the Sales Cost Process.</td><td>Clobtext</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_tsca_currency_lst</td><td>Specifies the currency in which the sales costs are calculated and applied.</td><td>Select</td></tr><tr><td>Date/Time Posted</td><td>custrecord_fq_apm_tsca_posted_dt</td><td>This field stores the date and time when the sales cost reconciliation record was created.</td><td>Date / Time</td></tr><tr><td>Demand Order Line</td><td>custrecord_fq_apm_tsca_outorderln_lst</td><td>Specifies the particular line within the demand order that is associated with the distributed cost.</td><td>Select</td></tr><tr><td>Demand Order</td><td>custrecord_fq_apm_tsca_outorder_lst</td><td>Denotes the demand order or shipment to which the landed costs apply.</td><td>Select</td></tr><tr><td>Item</td><td>custrecord_fq_apm_tsca_item_lst</td><td>Identifies the specific item to which the sales cost is allocated, linking the cost directly to the affected inventory.</td><td>Select</td></tr><tr><td>Line Unique Key</td><td>custrecord_fq_apm_tsca_lineuniquekey_int</td><td>A unique identifier for the transaction line within the allocation record, ensuring precise tracking and differentiation of cost allocation.</td><td>Integer</td></tr><tr><td>Quantity</td><td>custrecord_fq_apm_tsca_quantity_int</td><td>Displays the quantity for the sales cost allocation.</td><td>Integer</td></tr><tr><td>Sales Cost PO</td><td>custrecord_fq_apm_tsca_scpo_lst</td><td>References the Purchase Order created specifically for the sales costs being distributed, ensuring traceability of the expenses.</td><td>Select</td></tr><tr><td>Sales Cost Vendor Bills</td><td>custrecord_fq_apm_tsca_vbills_mlst</td><td>Indicates the Vendor Bill that the landed cost allocation has been billed on.</td><td>Multiselect</td></tr><tr><td>Sales Cost Budget</td><td>custrecord_fq_apm_tsca_scb_lst</td><td>Identifies the original sales cost budget record from which the transaction sales cost allocation was created.</td><td>Select</td></tr><tr><td>Source Exchange Rate</td><td>custrecord_fq_apm_tsca_exchrate_sc_flt</td><td>Indicates the exchange rate between the Source Currency and the Landed Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Source Transcation Currency</td><td>custrecord_fq_apm_tsca_currency_sc_lst</td><td>Specifies the currency used in the Source Transaction.</td><td>Select</td></tr><tr><td>Source Transaction</td><td>custrecord_fq_apm_tsca_sourc_trans_lst</td><td>Identifies the original transaction to which the sales costs are being applied.</td><td>Select</td></tr><tr><td>Transaction Sales Cost</td><td>custrecord_fq_apm_tsca_tsc_lst</td><td>Associates this allocation with a specific Transaction Sales Cost record, detailing the sales costs incurred</td><td>Select</td></tr><tr><td>Variance Amount</td><td>custrecord_fq_apm_tsca_amt_var_flt</td><td>Represents the variance in the sales cost currency.</td><td>Float</td></tr><tr><td>Variance Amount (Source Currency)</td><td>custrecord_fq_apm_tsca_amt_var_sc_flt</td><td>Represents the variance in the source transaction cost currency.</td><td>Float</td></tr><tr><td>Variance Transaction</td><td>custrecord_fq_apm_tsca_vartrans_mlst</td><td>This provides a link to the variance transaction(s).</td><td>Multiselect</td></tr><tr><td>Variance Amount (Base Currency)</td><td>custrecord_fq_apm_tsca_amt_var_bc_flt</td><td>Represents the variance in the base currency.</td><td>Float</td></tr></tbody></table>

### TQ Transaction Sales Cost

<table data-header-hidden data-full-width="false"><thead><tr><th width="378"></th><th></th></tr></thead><tbody><tr><td>customrecord_fq_apm_sc_trans_rec</td><td>This custom record is used to store transaction sales costs records</td></tr></tbody></table>

<table data-full-width="false"><thead><tr><th>Field Name</th><th width="195">Field ID</th><th width="302">Field Help</th><th>Field Type</th></tr></thead><tbody><tr><td>Applied To Items</td><td>custrecord_fq_apm_tsc_appltoitems_mlst</td><td>This Field displays the Items to which this Transaction Sales Cost is exclusively applied.<br><br>If this Field is empty, the Transaction Sales Cost Budget is not filtered based on Items.</td><td>Multiselect</td></tr><tr><td>Automatically Created</td><td>custrecord_fq_apm_tsc_autocreated_cb</td><td>If this is checked, when the Sales Cost Vendor Bill was processed, the variance has been automatically processed.</td><td>Check Box</td></tr><tr><td>Base Currency</td><td>custrecord_fq_apm_tsc_currency_bsc_lst</td><td>Specifies the base currency in the NetSuite account (sourced from Company Information).</td><td>Select</td></tr><tr><td>Base Exchange Rate</td><td>custrecord_fq_apm_tsc_exchrate_bsc_flt</td><td>Indicates the exchange rate between the Base Currency and the Sales Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Billed Amount</td><td>custrecord_fq_apm_tsc_amt_billed_flt</td><td>Represents the total billed amount for sales costs in the sales cost currency.</td><td>Float</td></tr><tr><td>Billed Amount (Base Currency)</td><td>custrecord_fq_apm_tsc_amt_billed_bsc_flt</td><td>Represents the total billed amount for sales costs in the base currency.</td><td>Float</td></tr><tr><td>Billed Amount (Source Currency)</td><td>custrecord_fq_apm_tsc_amt_billed_sc_flt</td><td>Represents the total billed amount for sales costs in the source transaction currency.</td><td>Float</td></tr><tr><td>Budgeted Amount</td><td>custrecord_fq_apm_tsc_amt_budget_flt</td><td>Represents the budgeted / total amount for sales costs in the sales cost currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Base Currency)</td><td>custrecord_fq_apm_tsc_amt_budget_bsc_flt</td><td>Represents the budgeted / total amount for sales costs in the base currency.</td><td>Float</td></tr><tr><td>Budgeted Amount (Source Currency)</td><td>custrecord_fq_apm_tsc_amt_budget_sc_flt</td><td>Represents the budgeted / total amount for sales costs in the source transaction currency.</td><td>Float</td></tr><tr><td>Calculation Data</td><td>custrecord_fq_apm_tsc_calcdata_ltxt</td><td>Shows the Calculation Data as an outcome of the Sales Cost Process.</td><td>Clobtext</td></tr><tr><td>Calculation Method</td><td>custrecord_fq_apm_tsc_calc_method_lst</td><td>Describes the method used to allocate sales costs to items/transactions.</td><td>Select</td></tr><tr><td>Currency</td><td>custrecord_fq_apm_tsc_currency_lst</td><td>Specifies the currency in which the sales costs are calculated and applied.</td><td>Select</td></tr><tr><td>Custom Price Calculation Method</td><td>custrecord_fq_apm_tsc_cpm_lst</td><td>This fields defines how Sales Cost should handle custom pricing. <br><br>It allows for the differentiation between custom pricing derived from customer master data and custom pricing set on a transaction by a user.  <br> <br>This setting only applies when: <br>- The transaction line has ‘Custom’ set as the price level <br>- A Sales Cost applies that has ‘Change Rate set to TRUE <br> <br>The following options are available: <br>- Always Change Custom Rate - If selected, Sales Cost will modify the rate in all scenarios.  <br>- Change Manually Entered Rates Only - If selected, Sales Cost will modify the rate if a user/script has manually changed the rate on the transaction.<br>- Change Customer/Item Specific Pricing - if selected, Sales Cost will modify the rate if the rate is sourced from the Customer Item Pricing record. <br><br>Never Change Custom Rate - if selected, Sales Cost will never modify the rate.</td><td>Select</td></tr><tr><td>Customer</td><td>custrecord_fq_apm_tsc_customer_lst</td><td>Specifies the customer related to the source transaction</td><td>Select</td></tr><tr><td>Date/Time Posted</td><td>custrecord_fq_apm_tsc_posted_dt</td><td>This field stores the date and time when the sales cost reconciliation record was created.</td><td>Date / Time</td></tr><tr><td>Demand Order</td><td>custrecord_fq_apm_tsc_outorder_lst</td><td>Refers to the specific demand order linked to the sales costs.</td><td>Select</td></tr><tr><td>Description</td><td>custrecord_fq_apm_tsc_description_txt</td><td>Provide an overview or details about the sales cost record. This is shown on the Sales Cost Purchase Order.</td><td>Textarea</td></tr><tr><td>Filter Data</td><td>custrecord_fq_apm_tsc_filterdata_ltxt</td><td>Aggregates the SCB Filters that should apply during the Sales Cost Process.<br><br>Filled in by script.</td><td>Clobtext</td></tr><tr><td>Item Table Data HTML</td><td>custrecord_fq_apm_tsc_itemdata_ltxt</td><td>This field displays the Item Data Table HTML Definition.</td><td>Clobtext</td></tr><tr><td>Line Unique Key</td><td>custrecord_fq_apm_tsc_lineuniquekey_int</td><td>Line Unique Key from the Transaction Line.</td><td>Integer</td></tr><tr><td>Percent</td><td>custrecord_fq_apm_tsc_percent_per</td><td>Denotes the percentage used in the calculation of sales costs, relevant for certain calculation methods.</td><td>Percent</td></tr><tr><td>Percentage Decrease Rate Calculation Method</td><td>custrecord_fq_apm_tsc_perdeccm_lst</td><td>Select the default value to use as the starting value when a Sales Cost is used to decrease the rate.</td><td>Select</td></tr><tr><td>Percentage Increase Rate Calculation Method</td><td>custrecord_fq_apm_tsc_perinccm_lst</td><td>Select the default value to use as the starting value when a Sales Cost is used to increase the rate.</td><td>Select</td></tr><tr><td>PO Creation Method</td><td>custrecord_fq_apm_tsc_po_createmeth_lst</td><td>PO Creation Method. Defines the approach for generating Purchase Orders for sales costs.</td><td>Select</td></tr><tr><td>Quantity</td><td>custrecord_fq_apm_tsc_quantity_flt</td><td>Specifies the quantity for the sales cost. This is the quantity on the sales cost purchase order and is always calculated by the script.</td><td>Float</td></tr><tr><td>Rate</td><td>custrecord_fq_apm_tsc_rate_flt</td><td>Indicates the rate to use in the cost calculation.</td><td>Float</td></tr><tr><td>Sales Cost Budget</td><td>custrecord_fq_apm_tsc_scb_lst</td><td>Identifies the original sales cost budget record from which the transaction sales cost was created</td><td>Select</td></tr><tr><td>Sales Cost Item</td><td>custrecord_fq_apm_tsc_sc_item_lst</td><td>Specifies the item which is used on the Sales Cost Purchase Order. The item must be Other Charge / Service for Purchase and cannot be fulfilled / received.</td><td>Select</td></tr><tr><td>Sales Cost PO</td><td>custrecord_fq_apm_tsc_scpo_lst</td><td>This links the Transaction Sales Cost to the Sales Cost Purchase Order.</td><td>Select</td></tr><tr><td>Sales Cost Processing Method</td><td>custrecord_fq_apm_tsc_processmeth_lst</td><td>The Sales Cost Processing defines the method for processing the Transaction Sales Cost record.</td><td>Select</td></tr><tr><td>Sales Cost Source</td><td>custrecord_fq_apm_tsc_sc_source_lst</td><td>This field displays the sales cost source</td><td>Select</td></tr><tr><td>Sales Cost Status</td><td>custrecord_fq_apm_tsc_scstatus_lst</td><td>The status field indicates the current stage of the Transaction Sales Cost record in its lifecycle, from creation to resolution. It helps manage and track the progress of sales cost applications, variance handling, and billing.</td><td>Select</td></tr><tr><td>Sales Cost Vendor</td><td>custrecord_fq_apm_tsc_sc_vendor_lst</td><td>Designates the vendor responsible for additional expenses such as freight, duties, or taxes that comprise the sales costs.</td><td>Select</td></tr><tr><td>Sales Cost Vendor Bills</td><td>custrecord_fq_apm_tsc_vbills_mlst</td><td>This links the Transaction Sales Cost record to the Vendor Bills.</td><td>Multiselect</td></tr><tr><td>Source Exchange Rate</td><td>custrecord_fq_apm_tsc_exchrate_sc_flt</td><td>Indicates the exchange rate between the Source Currency and the Sales Cost Currency at time of creation.</td><td>Float</td></tr><tr><td>Source Transaction</td><td>custrecord_fq_apm_tsc_sourc_trans_lst</td><td>Identifies the original transaction to which the sales costs are being applied.</td><td>Select</td></tr><tr><td>Source Transaction Currency</td><td>custrecord_fq_apm_tsc_currency_sc_lst</td><td>Specifies the currency used in the Source Transaction.</td><td>Select</td></tr><tr><td>Updated Manually</td><td>custrecord_fq_apm_tsc_updated_man_cb</td><td>This field indicates if the sales cost has been updated manually by a user</td><td>Check Box</td></tr><tr><td>Variance Amount</td><td>custrecord_fq_apm_tsc_amt_var_flt</td><td>Represents the variance in the sales cost currency.</td><td>Float</td></tr><tr><td>Variance Amount (Base Currency)</td><td>custrecord_fq_apm_tsc_amt_var_bsc_flt</td><td>Represents the variance in the base currency.</td><td>Float</td></tr><tr><td>Variance Amount (Source Currency)</td><td>custrecord_fq_apm_tsc_amt_var_sc_flt</td><td>Represents the variance in the source transaction cost currency.</td><td>Float</td></tr><tr><td>Variance Transaction</td><td>custrecord_fq_apm_tsc_vartrans_mlst</td><td>This provides a link to the variance transaction(s).</td><td>Multiselect</td></tr></tbody></table>