SCM Data Dictionary

Invoicing__c

Label: Invoicing

This Object describes an Invoice which is a request for payment between a company and their Customer for delivery of goods (e.g., parts) or services and is subject to a formal process of control. This object supports business processes such as Inventory consumption business processes such as fulfilling a customer sales order. In addition there are workflows and business intelligences dependent on this object. This information is used in Sales, Inventory Management, Quality, and Finance processes.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Applied_Discount__c Applied Discount Pre-Spring 2018 The amount of discount applied to this invoice.

Currency(18,2) 0
Applied_Rebate_Amount__c Applied Rebate Amount Pre-Spring 2018 Total amount of rebate rolled-up from the invoice lines

Currency(18,2) 0
Avalara_Location_Code__c Avalara Location Code Winter 2023 Code of the location in AvaTax that represents the physical location where the invoice is sold from. This is used for location-based filing in Avalara.

Text(25)
Bill_to_City__c Bill-to City Pre-Spring 2018 Text(100)
Bill_to_Country__c Bill-to Country Pre-Spring 2018 Text(100)
Bill_to_Name__c Bill-to Name Pre-Spring 2018 Text(150)
Bill_to_State_Province__c Bill-to State / Province Pre-Spring 2018 Text(100)
Bill_to_Street_2__c Bill-to Street 2 Pre-Spring 2018 Text(100)
Bill_to_Street__c Bill-to Street Pre-Spring 2018 Text(100)
Bill_to_Zip_Postal_Code__c Bill-to Zip / Postal Code Pre-Spring 2018 Text(15)
Billing_Account__c Billing Account Pre-Spring 2018 Looks up to: Account

Lookup
Change_Request__c Change Request Pre-Spring 2018 Looks up to: Change_Request__c
Lookup
Credit_Status__c Credit Status Pre-Spring 2018 This is set by code.

Picklist:
Fully Credited
Not Credited
Partially Credited
Customer_Account__c Customer Site Sold To Pre-Spring 2018 Formula:
Customer_Name__c
Text
Customer_Name__c Customer Name Pre-Spring 2018 Text(128)
Customer_Purchase_Order_Number__c Customer Purchase Order Number Pre-Spring 2018 Formula:
PO_Number__c
Text
Customer__c Customer Pre-Spring 2018 Looks up to: Account

Lookup
Delivery_Options__c Delivery Options Pre-Spring 2018 Picklist:
E-Mail
Fax
Print
Delivery_Status__c Delivery Status Pre-Spring 2018 Picklist:
Delivered
Not Delivered
Not Delivered - Error
Not Delivered - Processing
Discount__c Total Order Discount Pre-Spring 2018 Total discount on entire order. See 'Applied Discount' field for the discount applied to this invoice.

Formula:
Sales_Order__r.Discount__c
Currency(18,2)
Export_Error__c Export Error Pre-Spring 2018 Text(255)
Export_Status__c Export Status Pre-Spring 2018 The status of the export of this invoice.

Picklist:
Export Error
Export in Process
Exported
Exported as Billing Document
New
External_Tax_Status_Last_Updated__c External Tax Status Last Updated Winter 2023 Date and time when the External Tax Status field was last updated.

DateTime
External_Tax_Status__c External Tax Status Winter 2023 Status of the external tax calculation if using an external system to calculate tax for the invoice.

Picklist:
Calculated
Committed
Not Calculated
Posted
Voided
External_Tax_Transaction_ID__c External Tax Transaction ID Winter 2023 Unique identifier of the transaction that represents the invoice in the external tax calculation system.

Text(50)
FOB__c FOB Pre-Spring 2018 Formula:
Sales_Order__r.FOB__c
Text
Foreign_Invoice_Number__c Foreign Invoice Number Pre-Spring 2018 Text(100)
Invoice_Date__c Invoice Date Pre-Spring 2018 Date Today() + 0
Invoice_Due_Date__c Invoice Due Date Pre-Spring 2018 Date
Memo_Long__c Memo Pre-Spring 2018 Html(32768)
PO_Number__c PO Number Pre-Spring 2018 Text(80)
Payment_Terms_Name__c Payment Terms Name Pre-Spring 2018 Formula:
Payment_Terms__r.Terms_Name__c
Text
Payment_Terms__c Payment Terms Pre-Spring 2018 The terms are initially set from the sales order.

Looks up to: PO_Payment_Terms__c
Lookup
Remaining_Discount__c Remaining Discount Pre-Spring 2018 The remaining discount that has not yet been applied to the invoice.

Formula:
if(!ISBLANK(Sales_Order__c), Sales_Order__r.Discount__c - Sales_Order__r.Applied_Discount__c, 0)
Currency(18,2)
Sales_Order__c Sales Order Pre-Spring 2018 Looks up to: Sales_Order__c
Lookup
Sales_Representative__c Sales Representative Pre-Spring 2018 Formula:
Sales_Order__r.Primary_Sales_Rep__r.FirstName + ' ' + Sales_Order__r.Primary_Sales_Rep__r.LastName
Text
Service_Contract__c Service Contract Pre-Spring 2018 Looks up to: Service_Order__c
Lookup
Ship_to_City__c Ship-to City Pre-Spring 2018 Text(100)
Ship_to_Country__c Ship-to Country Pre-Spring 2018 Text(100)
Ship_to_State_Province__c Ship-to State / Province Pre-Spring 2018 Text(100)
Ship_to_Street_2__c Ship-to Street 2 Pre-Spring 2018 Text(100)
Ship_to_Street__c Ship-to Street Pre-Spring 2018 Text(100)
Ship_to_Zip_Postal_Code__c Ship-to Zip / Postal Code Pre-Spring 2018 Text(15)
Shipping__c Shipping Pre-Spring 2018 Reference to the shipping object that shipped the parts to the customer.

Looks up to: Shipping__c
Lookup
Status__c Status Pre-Spring 2018 Picklist:
Closed
Open
Voided
Tax_Code__c Tax Code Pre-Spring 2018 Formula:
Sales_Order__r.Tax_Code__r.Description__c
Text
Total_Amount_Credited__c Total Amount Credited Pre-Spring 2018 Currency(18,2) 0
Total_Customer_Rebate_Discount__c Total Customer Rebate Discount Pre-Spring 2018 Total amount of rebate rolled-up from the invoice lines

Currency(18,2) 0
Total_Invoice_After_Rebate_Discount__c Total Invoice After Rebate Discount Pre-Spring 2018 Total invoice with discounts minus total customer rebate discount.

Formula:
Total_Invoice_with_Discount__c - Total_Customer_Rebate_Discount__c
Currency(18,2)
Total_Invoice__c Total Invoice Pre-Spring 2018 The total value of the invoice including tax, freight, miscellaneous charges, and shipped parts. This is a summary of the Amount attribute.

Summary
Total_Invoice_with_Discount__c Total Invoice with Discount Pre-Spring 2018 Formula:
Total_Invoice__c - Applied_Discount__c
Currency(18,2)
Total_Tax__c Total Tax Winter 2023 Total amount of tax on the invoice.

Currency(9,2)


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