| AccountAddress__c |
Account Address |
Pre-Spring 2018 |
Formula:
Account__r.BillingStreet + ' ' + Account__r.BillingCity + ' ' + Account__r.BillingState + ' ' + Account__r.BillingPostalCode + ' ' + Account__r.BillingCountry
|
Text |
|
| AccountECCountryCode__c |
Tax Country Code |
Pre-Spring 2018 |
Formula:
TEXT(Account__r.CODAECCountryCode__c)
|
Text |
|
| AccountInvoiceNumber__c |
Vendor Invoice Number |
Pre-Spring 2018 |
The vendor reference.
|
Text(25) |
|
| Account__c |
Account |
Pre-Spring 2018 |
Looks up to: Account
|
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 |
|
| CopyAccountValues__c |
Copy Account Values |
Pre-Spring 2018 |
|
Checkbox |
true |
| 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 Payable Invoice was discarded.
|
TextArea |
|
| 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 payable invoice is due for payment.
|
Date |
|
| EInvoiceExternalIdentifier__c |
E-Invoice External Unique Identifier |
Spring 2022 |
Used to uniquely identify the e-invoice in the Storecove system.
|
Text(36) |
|
| EInvoiceProcessingStatus__c |
E-Invoice Processing Status |
Spring 2022 |
Picklist to specify the received e-invoice stages from acknowledged to accepted.
|
Picklist:
Accepted
Acknowledged
Rejected |
|
| EnableReverseCharge__c |
Enable Reverse Charge |
Pre-Spring 2018 |
|
Checkbox |
false |
| ExpensesNetTotal__c |
Expenses Net Total |
Pre-Spring 2018 |
Total value of expense items on the invoice, before tax. SUM: Payable Invoice Expense Line Item: NetValue
|
Summary |
|
| ExpensesOutputTaxTotal__c |
Expenses Output Tax Total |
Pre-Spring 2018 |
|
Summary |
|
| ExpensesTax1Total__c |
Expenses Tax 1 Total |
Pre-Spring 2018 |
Sum of tax 1 posted to Expense Line Items.
|
Summary |
|
| ExpensesTax2Total__c |
Expenses Tax 2 Total |
Pre-Spring 2018 |
Sum of tax 2 posted to Expense Line Items.
|
Summary |
|
| ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
|
| HoldStatus__c |
Hold Status |
Pre-Spring 2018 |
|
Text(15) |
|
| IncomeTaxType__c |
Income Tax Type |
Pre-Spring 2018 |
Income Tax Type
|
Picklist:
1 - Rents
10 - Crop Insurance Proceeds
11 - Unused 11
12 - Unused 12
13 - Excess Golden Parachute Payments
14 - Gross Proceeds Paid to an Attorney
2 - Royalties
3 - Other Income
4 - Federal Income Tax Withheld
5 - Fishing Boat Proceeds
6 - Medical and Healthcare Payments
7 - Nonemployee Compensation
8 - Substitute Payments in Lieu of Dividends or Interest
9 - Payer Made Direct Sales of 5000 or More
Not Reportable |
|
| IntercompanyTransfer__c |
Intercompany Transfer |
Pre-Spring 2018 |
Looks up to: codaIntercompanyTransfer__c
|
Lookup |
|
| 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 payable invoice was created.
|
Date |
Today() |
| InvoiceDescription__c |
Invoice Description |
Pre-Spring 2018 |
A description of the payable invoice.
|
TextArea |
|
| 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 payable invoice.
|
Picklist:
Complete
Discarded
In Progress
Ready to Post |
|
| InvoiceTotal__c |
Invoice Total |
Pre-Spring 2018 |
The total value of all items and expenses on the payable invoice, including the tax.
Formula:
NetTotal__c + TaxTotal__c + WithholdingTotal__c
|
Number(18,2) |
|
| ItemsNetTotal__c |
Items Net Total |
Pre-Spring 2018 |
Total value of product items on the invoice, before tax. SUM: Payable Invoice Line Item: NetValue
|
Summary |
|
| ItemsOutputTaxTotal__c |
Items Output Tax Total |
Pre-Spring 2018 |
|
Summary |
|
| ItemsTax1Total__c |
Items Tax 1 Total |
Pre-Spring 2018 |
Sum of tax 1 posted to Product Line Items.
|
Summary |
|
| ItemsTax2Total__c |
Items Tax 2 Total |
Pre-Spring 2018 |
Sum of tax 2 posted to Product Line Items.
|
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 and expenses on the puchase invoice, before tax.
Formula:
ItemsNetTotal__c + ExpensesNetTotal__c
|
Number(18,2) |
|
| 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 |
|
| 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 |
|
| Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: codaPeriod__c
|
Lookup |
|
| Reference1__c |
Reference 1 |
Pre-Spring 2018 |
|
Text(80) |
|
| Reference2__c |
Reference 2 |
Pre-Spring 2018 |
|
Text(80) |
|
| RegisteredDate__c |
Registered Date |
Pre-Spring 2018 |
|
Date |
TODAY() |
| TaxCode1__c |
Tax Code 1 |
Pre-Spring 2018 |
Looks up to: codaTaxCode__c
|
Lookup |
|
| TaxDocumentCode__c |
External Tax Document Code |
Pre-Spring 2018 |
|
Text(80) |
|
| TaxStatus__c |
External Tax Status |
Pre-Spring 2018 |
Tax status of the invoice.
|
Picklist:
Calculated
Finalized
Not Calculated |
|
| TaxTotal__c |
Tax Total |
Pre-Spring 2018 |
Formula:
ItemsTax1Total__c + ExpensesTax1Total__c + ItemsTax2Total__c + ExpensesTax2Total__c - ItemsOutputTaxTotal__c - ExpensesOutputTaxTotal__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) |
|
| VATRegistrationNumber__c |
Tax Registration Number |
Pre-Spring 2018 |
Formula:
Account__r.CODAVATRegistrationNumber__c
|
Text |
|
| WithholdingExpenseNetTotal__c |
Withholding Expense Net Total |
Spring 2021 |
|
Summary |
|
| WithholdingProductNetTotal__c |
Withholding Product Net Total |
Spring 2021 |
|
Summary |
|
| WithholdingRate__c |
Withholding Rate |
Spring 2021 |
The Withholding tax rate.
|
Number(7,3) |
|
| WithholdingTax__c |
Withholding Tax |
Spring 2021 |
Lookup in the tax codes from purchase invoice for withholding tax details.
Looks up to: codaTaxCode__c
|
Lookup |
|
| WithholdingTotal__c |
Withholding Total |
Spring 2021 |
The total value of items and expenses on the puchase invoice, applicable for withholding tax.
Formula:
ROUND((((WithholdingExpenseNetTotal__c + WithholdingProductNetTotal__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 |
|
