| AccountCurrency__c |
Account Currency |
Pre-Spring 2018 |
Formula:
Account__r.CODAAccountTradingCurrency__c
|
Text |
|
| AccountName__c |
Account Name |
Spring 2018 |
Formula:
Account__r.Name
|
Text |
|
| AccountOutstanding__c |
Account Outstanding |
Pre-Spring 2018 |
Formula:
Transaction__r.AccountOutstandingTotal__c
|
Number(18,2) |
|
| AccountTotal__c |
Account Total |
Pre-Spring 2018 |
Formula:
Transaction__r.AccountTotal__c
|
Number(18,2) |
|
| Account__c |
Account |
Pre-Spring 2018 |
The customer account.
Looks up to: Account
|
Lookup |
|
| ArchiveSet__c |
Archive Set |
Spring 2018 |
Looks up to: ArchiveSet__c
|
Lookup |
|
| AvalaraVATReportingDocumentIndicator__c |
Avalara VAT Reporting Document Indicator |
Spring 2020 |
Document indicator required for the Avalara VAT Reporting integration. If blank, "1 - Invoice" is used.
|
Picklist:
1 - Invoice
10 - Customs - Customs additional Assessment - Spain
2 - Simplified Invoice
3 - Ticket
4 - Advance Payment
5 - Canceled Invoice
6 - Receipts - Italy
7 - Summary Invoice
8 - Simplified Invoice with Partner Details - Spain
9 - Regular Invoice without Partner Information - Spain |
|
| BillingAddress__c |
Billing Address |
Pre-Spring 2018 |
Formula:
Account__r.BillingStreet + ' ' + Account__r.BillingCity + ' ' + Account__r.BillingState + ' ' + Account__r.BillingPostalCode + ' ' + Account__r.BillingCountry
|
Text |
|
| BillingDocument__c |
Billing Document |
Spring 2022 |
Billing document the sales invoice relates to.
Looks up to: fferpcore__BillingDocument__c
|
Lookup |
|
| CompanyReference__c |
Company Name |
Pre-Spring 2018 |
Company Reference
Formula:
OwnerCompany__r.Name
|
Text |
|
| CompositeGroupKey__c |
Consolidation Composite Group Key |
Spring 2022 |
Combination of field values used to group the invoices for consolidation. Internal use only.
|
Text(255) |
|
| ConsolidatedInvoice__c |
Consolidated Invoice |
Spring 2022 |
Looks up to: codaInvoice__C
|
Lookup |
|
| CopyAccountValues__c |
Copy Account Values |
Pre-Spring 2018 |
|
Checkbox |
true |
| CopyDefaultPrintedTextDefinitions__c |
Copy Default Printed Text Definitions |
Pre-Spring 2018 |
|
Checkbox |
true |
| CreatingRecurringInvoice__c |
Creating Recurring Invoice |
Pre-Spring 2018 |
|
Checkbox |
false |
| Currency__c |
Currency |
Pre-Spring 2018 |
Invoice currency.
Formula:
InvoiceCurrency__r.Name
|
Text |
|
| CustomerReference__c |
Customer Reference |
Pre-Spring 2018 |
The customer reference.
|
Text(24) |
|
| DeriveCurrency__c |
Derive Currency |
Pre-Spring 2018 |
|
Checkbox |
true |
| DeriveDueDate__c |
Derive Due Date |
Pre-Spring 2018 |
|
Checkbox |
true |
| DerivePeriod__c |
Derive Period |
Pre-Spring 2018 |
|
Checkbox |
true |
| Dimension1__c |
Dimension 1 |
Pre-Spring 2018 |
Looks up to: codaDimension1__c
|
Lookup |
|
| Dimension2__c |
Dimension 2 |
Pre-Spring 2018 |
Looks up to: codaDimension2__c
|
Lookup |
|
| Dimension3__c |
Dimension 3 |
Pre-Spring 2018 |
Looks up to: codaDimension3__c
|
Lookup |
|
| Dimension4__c |
Dimension 4 |
Pre-Spring 2018 |
Looks up to: codaDimension4__c
|
Lookup |
|
| DiscardReason__c |
Discard Reason |
Pre-Spring 2018 |
The reason this Invoice was discarded.
|
TextArea |
|
| DocumentOutstandingTotal__c |
Outstanding |
Pre-Spring 2018 |
Invoice Outstanding.
Formula:
Transaction__r.DocumentOutstandingTotal__c
|
Number(18,2) |
|
| DocumentTotal__c |
Total |
Pre-Spring 2018 |
Invoice Total.
Formula:
Transaction__r.DocumentTotal__c
|
Number(18,2) |
|
| DualRate__c |
Dual Rate |
Pre-Spring 2018 |
The dual to home exchange rate.
|
Number(18,9) |
|
| DueDate__c |
Due Date |
Pre-Spring 2018 |
The date the invoice is due for payment.
|
Date |
|
| EInvoiceDeliveryError__c |
E-Invoice Delivery Error |
Fall 2021 |
Used to convey the reasons for a delivery failure. Will remain blank unless the status is Failed. Not used for business responses such as accepted or rejected.
|
LongTextArea(131072) |
|
| EInvoiceDeliveryStatus__c |
E-Invoice Delivery Status |
Fall 2021 |
Indicates the lifecycle of the sending journey of the e-invoice, from being queued to send, to being updated by the integration connector as it is delivered and subsequently processed by the recipient.
|
Picklist:
Delivered
Failed
Queued
Sending |
|
| EInvoiceExternalIdentifier__c |
E-Invoice External Unique Identifier |
Fall 2021 |
Used to uniquely identify the e-invoice in the Storecove system.
|
Text(36) |
|
| EInvoiceIdentifier__c |
E-Invoice Unique Identifier |
Fall 2021 |
Used to uniquely identify the e-invoice to the integration, as a reliable means of distinguishing between retries and duplicated invoices.
|
Text(36) |
|
| Engagement__c |
Engagement |
Spring 2022 |
Lookup to the Engagement that this sales invoice relates to.
Looks up to: fferpcore__ff_Engagement__c
|
Lookup |
|
| ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
|
| FirstDueDate__c |
First Due Date |
Pre-Spring 2018 |
The date the invoice is due for the first payment.
|
Date |
TODAY() |
| GeneralLedgerAccount__c |
General Ledger Account |
Pre-Spring 2018 |
GLA used for Income Schedule
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
|
| GenerateAdjustmentJournal__c |
Generate Adjustment Journal |
Pre-Spring 2018 |
If checked a currency adjustment journal will be automatically generated when you post this invoice in a multi-currency environment.
|
Checkbox |
true |
| HoldStatus__c |
Hold Status |
Fall 2018 |
|
Text(15) |
|
| IncomeScheduleGroup__c |
Group |
Pre-Spring 2018 |
Looks up to: codaGroupingReference__c
|
Lookup |
|
| IncomeSchedule__c |
Income Schedule |
Pre-Spring 2018 |
Looks up to: codaIncomeScheduleDefinition__c
|
Lookup |
|
| IntercompanyTransfer__c |
Intercompany Transfer |
Pre-Spring 2018 |
Looks up to: codaIntercompanyTransfer__c
|
Lookup |
|
| Interval__c |
Interval |
Pre-Spring 2018 |
Payment schedule interval
|
Picklist:
Daily
Monthly
Quarterly
Weekly
Yearly |
|
| InvoiceCurrencyDecimalPlaces__c |
Currency Decimal Places |
Spring 2022 |
The number of decimal places used by the invoice currency. Permitted values are 0 and 2. The default is 2.
|
Number(1,0) |
2 |
| InvoiceCurrency__c |
Invoice Currency |
Pre-Spring 2018 |
Looks up to: codaAccountingCurrency__c
|
Lookup |
|
| InvoiceDate__c |
Invoice Date |
Pre-Spring 2018 |
The date the sales invoice was created.
|
Date |
Today() |
| InvoiceDescription__c |
Invoice Description |
Pre-Spring 2018 |
A description of the invoice.
|
TextArea |
|
| InvoiceGroup__c |
Invoice Group |
Pre-Spring 2018 |
Looks up to: codaGroupingReference__c
|
Lookup |
|
| InvoiceRate__c |
Invoice Rate |
Pre-Spring 2018 |
The document to home exchange rate.
|
Number(18,9) |
|
| InvoiceStatus__c |
Invoice Status |
Pre-Spring 2018 |
The current status of the invoice.
|
Picklist:
Complete
Discarded
In Progress
Ready to Post
Superseded |
|
| InvoiceTotal__c |
Invoice Total |
Pre-Spring 2018 |
The total value of all the items on the invoice, including the tax.
Formula:
NetTotal__c + TaxTotal__c + WithholdingTotal__c
|
Number(18,2) |
|
| InvoiceType__c |
Invoice Type |
Spring 2022 |
Stores the current invoice type.
|
Picklist:
Consolidated
Standard |
|
| LineCount__c |
Line Count |
Spring 2022 |
|
Summary |
|
| MatchType__c |
Match Type |
Pre-Spring 2018 |
Formula:
TEXT(Transaction__r.MatchType__c)
|
Text |
|
| NetTotal__c |
Net Total |
Pre-Spring 2018 |
The total value of items on the invoice, before tax.
|
Summary |
|
| NumberOfPayments__c |
Number of Payments |
Pre-Spring 2018 |
Payment schedule number of payments
|
Number(2,0) |
|
| NumberofJournals__c |
Number of Journals |
Pre-Spring 2018 |
|
Number(12,0) |
|
| Opportunity__c |
Opportunity |
Pre-Spring 2018 |
The opportunity to which this invoice is related.
Looks up to: Opportunity
|
Lookup |
|
| OutstandingValue__c |
Outstanding Value |
Pre-Spring 2018 |
Formula:
Transaction__r.DocumentOutstandingTotal__c
|
Number(18,2) |
|
| OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: codaCompany__c
|
Lookup |
|
| PaymentScheduleTotal__c |
PaymentScheduleTotal |
Pre-Spring 2018 |
|
Summary |
|
| PaymentSchedule__c |
Payment Schedule |
Pre-Spring 2018 |
|
Picklist:
Payment Schedule |
|
| PaymentStatus__c |
Payment Status |
Pre-Spring 2018 |
Formula:
if( NOT( ISPICKVAL( InvoiceStatus__c, 'Complete' ) ), $Label.NotApplicable, if( Transaction__r.DocumentOutstandingTotal__c == 0, $Label.Paid, if( Transaction__r.DocumentTotal__c == Transaction__r.DocumentOutstandingTotal__c, $Label.codaPurchaseInvoiceFieldStatusUnpaid, $Label.codaPurchaseInvoiceFieldStatusPartPaid ) ) )
|
Text |
|
| PeriodInterval__c |
Period Interval |
Pre-Spring 2018 |
|
Number(12,0) |
|
| Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: codaPeriod__c
|
Lookup |
|
| PrintStatus__c |
Print Status |
Pre-Spring 2018 |
|
Picklist:
Not Printed
Printed |
|
| PrintedText1AllowEdit__c |
Printed Text 1 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
false |
| PrintedText1Heading__c |
Printed Text 1 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText1TextDefinitionName__c |
Printed Text 1 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText1Text__c |
Printed Text 1 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
| PrintedText2AllowEdit__c |
Printed Text 2 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
false |
| PrintedText2Heading__c |
Printed Text 2 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText2TextDefinitionName__c |
Printed Text 2 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText2Text__c |
Printed Text 2 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
| PrintedText3AllowEdit__c |
Printed Text 3 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
false |
| PrintedText3Heading__c |
Printed Text 3 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText3TextDefinitionName__c |
Printed Text 3 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText3Text__c |
Printed Text 3 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
| PrintedText4AllowEdit__c |
Printed Text 4 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
false |
| PrintedText4Heading__c |
Printed Text 4 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText4TextDefinitionName__c |
Printed Text 4 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText4Text__c |
Printed Text 4 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
| PrintedText5AllowEdit__c |
Printed Text 5 Allow Edit |
Pre-Spring 2018 |
|
Checkbox |
false |
| PrintedText5Heading__c |
Printed Text 5 Heading |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText5TextDefinitionName__c |
Printed Text 5 Text Definition Name |
Pre-Spring 2018 |
|
Text(80) |
|
| PrintedText5Text__c |
Printed Text 5 Text |
Pre-Spring 2018 |
|
LongTextArea(32000) |
|
| RoundedInvoiceTotal__c |
Rounded Invoice Total |
Spring 2022 |
If invoice currency is CHF, displays the invoice total rounded to 0.05.
Formula:
IF ( InvoiceCurrency__r.Name = 'CHF', ( ROUND(InvoiceTotal__c * 20,0) )/20, InvoiceTotal__c )
|
Number(18,2) |
|
| SalesTaxDocumentCode__c |
External tax document code |
Pre-Spring 2018 |
|
Text(80) |
|
| SalesTaxStatus__c |
External Tax Status |
Pre-Spring 2018 |
The current tax status of the invoice.
|
Picklist:
Calculated
Finalized
Not Calculated |
|
| ShippingAddress__c |
Shipping Address |
Pre-Spring 2018 |
Formula:
Account__r.ShippingStreet + ' ' + Account__r.ShippingCity + ' ' + Account__r.ShippingState + ' ' + Account__r.ShippingPostalCode + ' ' + Account__r.ShippingCountry
|
Text |
|
| ShippingMethod__c |
Shipping Method |
Pre-Spring 2018 |
The method of delivery.
|
Picklist:
FedEx
Mail
Van |
|
| StartDate__c |
Start Date |
Pre-Spring 2018 |
|
Date |
|
| Tax1Total__c |
Tax 1 Total |
Pre-Spring 2018 |
|
Summary |
|
| Tax2Total__c |
Tax 2 Total |
Pre-Spring 2018 |
|
Summary |
|
| Tax3Total__c |
Tax 3 Total |
Pre-Spring 2018 |
|
Summary |
|
| TaxCode1__c |
Tax Code |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
|
| TaxCode2__c |
Tax Code 2 |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
|
| TaxCode3__c |
Tax Code 3 |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
|
| TaxTotal__c |
Tax Total |
Pre-Spring 2018 |
Formula:
Tax1Total__c + Tax2Total__c + Tax3Total__c
|
Number(18,2) |
|
| Transaction__c |
Transaction |
Pre-Spring 2018 |
Looks up to: codaTransaction__c
|
Lookup |
|
| UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
|
| Usepartperiods__c |
Use Part Periods |
Pre-Spring 2018 |
|
Checkbox |
true |
| WithholdingNetTotal__c |
Withholding Net Total |
Fall 2021 |
|
Summary |
|
| WithholdingRate__c |
Withholding Rate |
Fall 2021 |
The amount of Withholding Tax as a percentage.
|
Number(7,3) |
|
| WithholdingTax__c |
Withholding Tax |
Fall 2021 |
Lookup to the tax code used to withhold tax.
Looks up to: codaTaxCode__c
|
Lookup |
|
| WithholdingTotal__c |
Withholding Total |
Fall 2021 |
Total gross value of product lines on the sales invoice, used to withhold tax.
Formula:
ROUND(((WithholdingNetTotal__c * BLANKVALUE(WithholdingRate__c, 0)) / 100) * -1, BLANKVALUE(InvoiceCurrencyDecimalPlaces__c, 2))
|
Number(18,2) |
|
| Year__c |
Year |
Pre-Spring 2018 |
Formula:
Period__r.YearName__r.Name
|
Text |
|
