SCM Data Dictionary

Changes to the Schema in Winter 2023

The following changes have been introduced in the Winter 2023 release.

New Objects Added

TaxCalculationSettings__c

Deprecated Objects

No changes have been made in this release.

Updates to Objects

New Fields Added

Object NameField NameType
AP_Voucher_Credit__c External_Tax_Status_Last_Updated__c DateTime
External_Tax_Status__c Picklist:
Calculated
Committed
Not Calculated
Posted
Voided
External_Tax_Transaction_ID__c Text(50)
AP_Voucher_Line_Credit__c Tax_Name_1__c Text(100)
Tax_Name_2__c Text(100)
Tax_Name_3__c Text(100)
Tax_Rate_1__c Percent(7,4)
Tax_Rate_2__c Percent(7,4)
Tax_Rate_3__c Percent(7,4)
Tax_Value_1__c Currency(9,2)
Tax_Value_2__c Currency(9,2)
Tax_Value_3__c Currency(9,2)
AP_Voucher_Line__c Override_Avalara_Tax_Code__c Text(20)
Tax_Name_1__c Text(100)
Tax_Name_2__c Text(100)
Tax_Name_3__c Text(100)
Tax_Rate_1__c Percent(7,4)
Tax_Rate_2__c Percent(7,4)
Tax_Rate_3__c Percent(7,4)
Tax_Value_1__c Currency(9,2)
Tax_Value_2__c Currency(9,2)
Tax_Value_3__c Currency(9,2)
AP_Voucher__c External_Tax_Status_Last_Updated__c DateTime
External_Tax_Status__c Picklist:
Calculated
Committed
Not Calculated
Posted
Voided
External_Tax_Transaction_ID__c Text(50)
Credit_Invoice_Line__c Tax_Name_1__c Text(100)
Tax_Name_2__c Text(100)
Tax_Name_3__c Text(100)
Tax_Rate_1__c Percent(7,4)
Tax_Rate_2__c Percent(7,4)
Tax_Rate_3__c Percent(7,4)
Tax_Rate__c Percent(7,4)
Tax_Value_1__c Currency(9,2)
Tax_Value_2__c Currency(9,2)
Tax_Value_3__c Currency(9,2)
Tax__c Currency(9,2)
Credit_Invoice__c External_Tax_Status_Last_Updated__c DateTime
External_Tax_Status__c Picklist:
Calculated
Committed
Not Calculated
Posted
Voided
External_Tax_Transaction_ID__c Text(50)
Total_Tax__c Currency(9,2)
Customer_Quotation_Line__c Avalara_Tax_Code__c Text(20)
Override_Avalara_Tax_Code__c Text(20)
Shipping_Address_Validated__c Checkbox
Tax_Name_1__c Text(100)
Tax_Name_2__c Text(100)
Tax_Name_3__c Text(100)
Tax_Rate_1__c Percent(7,4)
Tax_Rate_2__c Percent(7,4)
Tax_Rate_3__c Percent(7,4)
Tax_Rate__c Percent(7,4)
Tax_Value_1__c Currency(9,2)
Tax_Value_2__c Currency(9,2)
Tax_Value_3__c Currency(9,2)
Tax__c Currency(9,2)
Customer_Quotation__c External_Tax_Status__c Picklist:
Calculated
Not Calculated
Prospect_Tax_Registration_Number__c Text(255)
Total_Tax__c Currency(9,2)
Invoice_Line_Item__c Avalara_Tax_Code__c Text(20)
Discount__c Currency(18,2)
Override_Avalara_Tax_Code__c Text(20)
Tax_Name_1__c Text(100)
Tax_Name_2__c Text(100)
Tax_Name_3__c Text(100)
Tax_Rate_1__c Percent(7,4)
Tax_Rate_2__c Percent(7,4)
Tax_Rate_3__c Percent(7,4)
Tax_Rate__c Percent(7,4)
Tax_Value_1__c Currency(9,2)
Tax_Value_2__c Currency(9,2)
Tax_Value_3__c Currency(9,2)
Tax__c Currency(9,2)
Invoicing__c Avalara_Location_Code__c Text(25)
External_Tax_Status_Last_Updated__c DateTime
External_Tax_Status__c Picklist:
Calculated
Committed
Not Calculated
Posted
Voided
External_Tax_Transaction_ID__c Text(50)
Total_Tax__c Currency(9,2)
Purchase_Contract_Line__c Quantity__c Number(18,4)
Purchase_Contract__c Renewal_Reminder__c Date
Purchase_Order_Line_Item__c End_Date__c Date
Purchase_Order__c External_Tax_Status__c Picklist:
Calculated
Not Calculated
Requisition_Line_Item__c Purchase_Contract_Line_Award__c Lookup
Sales_Order_Line_Item__c Avalara_Tax_Code__c Text(20)
Override_Avalara_Tax_Code__c Text(20)
Tax_Name_1__c Text(100)
Tax_Name_2__c Text(100)
Tax_Name_3__c Text(100)
Tax_Rate_1__c Percent(7,4)
Tax_Rate_2__c Percent(7,4)
Tax_Rate_3__c Percent(7,4)
Tax_Rate__c Percent(7,4)
Tax_Value_1__c Currency(9,2)
Tax_Value_2__c Currency(9,2)
Tax_Value_3__c Currency(9,2)
Tax__c Currency(9,2)
Sales_Order__c Avalara_Location_Code__c Text(25)
Drop_Ship_Address_Validated__c Checkbox
External_Tax_Status__c Picklist:
Calculated
Not Calculated
Total_Tax__c Currency(9,2)
Supplier_Site__c Mailing_Address_Validated__c Checkbox

Deprecated Fields

No changes have been made in this release.


© Copyright 2009–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.