AccountOutstandingValue__c |
Account Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
0 |
AccountValue__c |
Account Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
0 |
Account__c |
Account |
Pre-Spring 2018 |
A cash matching history record will refer to the account
Looks up to: Account
|
Lookup |
|
Action__c |
Action |
Pre-Spring 2018 |
The reason for the creation of the record.
|
Picklist: Currency Write-off Discount Match Undo Match Write-off |
|
ArchiveSet__c |
Archive Set |
Spring 2018 |
Looks up to: ArchiveSet__c
|
Lookup |
|
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) |
|
DiscountDate__c |
Discount Date |
Pre-Spring 2018 |
|
Date |
|
DocumentOutstandingValue__c |
Document Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
0 |
DocumentValue__c |
Document Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
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) |
0 |
DualValue__c |
Dual Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
0 |
ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
|
HomeOutstandingValue__c |
Home Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
0 |
HomeValue__c |
Home Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
0 |
LineNumber__c |
Line Number |
Pre-Spring 2018 |
Sequential number – the order of creation
|
Number(18,0) |
0 |
MatchedType__c |
Match Type |
Pre-Spring 2018 |
|
Text(255) |
|
MatchingCurrency__c |
Matching Currency |
Pre-Spring 2018 |
Looks up to: codaAccountingCurrency__c
|
Lookup |
|
MatchingDate__c |
Matching Date |
Pre-Spring 2018 |
The date when the line was matched in allocation
|
Date |
Today() |
MatchingReference__c |
Matching Reference |
Pre-Spring 2018 |
A reference linking matched lines
Looks up to: codaMatchingReference__c
|
Lookup |
|
OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: codaCompany__c
|
Lookup |
|
Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: codaPeriod__c
|
Lookup |
|
ReportingOutstandingValue__c |
Reporting Outstanding Value |
Fall 2021 |
The outstanding value used to report to the parent company.
|
Number(18,2) |
|
ReportingValue__c |
Reporting Value |
Fall 2021 |
The value used to report to the parent company.
|
Number(18,2) |
|
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 |
|
UndoMatchingReference__c |
Undo Matching Reference |
Pre-Spring 2018 |
A reference linking un-matched lines
Looks up to: codaMatchingReference__c
|
Lookup |
|
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) |
|
Year__c |
Year |
Pre-Spring 2018 |
Formula: Period__r.YearName__r.Name
|
Text |
|