| AccountOutstandingValue__c |
Account Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| AccountValue__c |
Account Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| Account__c |
Account |
Pre-Spring 2018 |
A cash matching history record will refer to the account
Looks up to: Account
|
Lookup |
false |
|
| Action__c |
Action |
Pre-Spring 2018 |
The reason for the creation of the record.
|
Picklist:
Auxiliary GLA
Currency Write-off
Discount
GLA Balancing
Match
Undo Match
Write-off |
|
|
| ArchiveSet__c |
Archive Set |
Spring 2018 |
Looks up to: ArchiveSet__c
|
Lookup |
false |
|
| DaysToPay__c |
Days to Pay |
Spring 2019 |
Number of days the customer took to pay. This value is used to calculate the Average Days to Pay on the Account object.
Formula:
IF(AND(ISPICKVAL(TransactionLineItem__r.Transaction__r.TransactionType__c, 'Invoice'), AccountOutstandingValue__c == 0), MatchingDate__c - TransactionLineItem__r.Transaction__r.TransactionDate__c, 0)
|
Number(18,0) |
false |
|
| DiscountDate__c |
Discount Date |
Pre-Spring 2018 |
|
Date |
false |
|
| DocumentOutstandingValue__c |
Document Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| DocumentValue__c |
Document Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| Document__c |
Document |
Spring 2021 |
This field contain the links for the respective matching document number.
Formula:
HYPERLINK("/" & IF(TransactionLineItem__r.Transaction__r.SalesInvoice__c != null, TransactionLineItem__r.Transaction__r.SalesInvoice__c, IF(TransactionLineItem__r.Transaction__r.CashEntry__c != null, TransactionLineItem__r.Transaction__r.CashEntry__c, IF(TransactionLineItem__r.Transaction__r.SalesCreditNote__c != null, TransactionLineItem__r.Transaction__r.SalesCreditNote__c, IF(TransactionLineItem__r.Transaction__r.Journal__c != null, TransactionLineItem__r.Transaction__r.Journal__c, IF(TransactionLineItem__r.Transaction__r.PayableCreditNote__c != null, TransactionLineItem__r.Transaction__r.PayableCreditNote__c, IF(TransactionLineItem__r.Transaction__r.PayableInvoice__c != null, TransactionLineItem__r.Transaction__r.PayableInvoice__c, "")))))) , TransactionLineItem__r.Transaction__r.DocumentNumber__c )
|
Text |
|
|
| DualOutstandingValue__c |
Dual Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| DualValue__c |
Dual Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
false |
|
| HomeOutstandingValue__c |
Home Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| HomeValue__c |
Home Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| LineNumber__c |
Line Number |
Pre-Spring 2018 |
Sequential number – the order of creation
|
Number(18,0) |
false |
0 |
| MatchedType__c |
Match Type |
Pre-Spring 2018 |
|
Text(255) |
false |
|
| MatchingCurrency__c |
Matching Currency |
Pre-Spring 2018 |
Looks up to: codaAccountingCurrency__c
|
Lookup |
false |
|
| MatchingDate__c |
Matching Date |
Pre-Spring 2018 |
The date when the line was matched in allocation
|
Date |
false |
Today() |
| MatchingReference__c |
Matching Reference |
Pre-Spring 2018 |
A reference linking matched lines
Looks up to: codaMatchingReference__c
|
Lookup |
false |
|
| OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: codaCompany__c
|
Lookup |
false |
|
| Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: codaPeriod__c
|
Lookup |
false |
|
| ReportingOutstandingValue__c |
Reporting Outstanding Value |
Fall 2021 |
The outstanding value used to report to the parent company.
|
Number(18,2) |
false |
|
| ReportingValue__c |
Reporting Value |
Fall 2021 |
The value used to report to the parent company.
|
Number(18,2) |
false |
|
| TransactionLineItem__c |
Transaction Line Item |
Pre-Spring 2018 |
A transaction line may have many cash matching history records if its type is account; analysis and tax lines do not have a history
Looks up to: codaTransactionLineItem__c
|
Lookup |
false |
|
| UndoMatchingReference__c |
Undo Matching Reference |
Pre-Spring 2018 |
A reference linking un-matched lines
Looks up to: codaMatchingReference__c
|
Lookup |
false |
|
| UndoReason__c |
Undo Reason |
Pre-Spring 2018 |
The reason for matching being undone
|
Picklist:
Matching Error
Remittance Advice Incorrect |
|
|
| UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
false |
|
| Year__c |
Year |
Pre-Spring 2018 |
Formula:
Period__r.YearName__r.Name
|
Text |
false |
|
