| 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(50) |
|
| 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 |
|
| Swiss_QRReference__c |
Swiss QR Reference |
Winter 2024 |
The Swiss QR reference code.
|
Text(255) |
|
| Swiss_StructuredReferenceType__c |
Swiss Structured Reference Type |
Winter 2024 |
The reference type for QR code. This field displays the picklist with values NON, QRR, and SCOR. NON is the default value. If QRR is selected, the Swiss QR Reference field is mandatory.
|
Picklist:
NON
QRR
SCOR |
|
| 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 |
|
| TriggerPostingError__c |
Trigger Posting Error |
Winter 2023 |
|
TextArea |
|
| TriggerPosting__c |
Trigger Posting |
Winter 2023 |
The method of trigger-posting a document after its header has been updated.
|
Picklist:
Asynchronous
Synchronous |
|
| 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 |
|
