| c2g__AccountOutstandingValue__c |
Account Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| c2g__AccountValue__c |
Account Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| c2g__Account__c |
Account |
Pre-Spring 2018 |
A cash matching history record will refer to the account
Looks up to: Account
|
Lookup |
false |
|
| c2g__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 |
|
|
| c2g__ArchiveSet__c |
Archive Set |
Spring 2018 |
Looks up to: c2g__ArchiveSet__c
|
Lookup |
false |
|
| c2g__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(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__TransactionType__c, 'Invoice'), c2g__AccountOutstandingValue__c == 0), c2g__MatchingDate__c - c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__TransactionDate__c, 0)
|
Number(18,0) |
false |
|
| c2g__DiscountDate__c |
Discount Date |
Pre-Spring 2018 |
|
Date |
false |
|
| c2g__DocumentOutstandingValue__c |
Document Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| c2g__DocumentValue__c |
Document Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| c2g__Document__c |
Document |
Spring 2021 |
This field contain the links for the respective matching document number.
Formula:
HYPERLINK("/" & IF(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__SalesInvoice__c != null, c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__SalesInvoice__c, IF(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__CashEntry__c != null, c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__CashEntry__c, IF(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__SalesCreditNote__c != null, c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__SalesCreditNote__c, IF(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__Journal__c != null, c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__Journal__c, IF(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__PayableCreditNote__c != null, c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__PayableCreditNote__c, IF(c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__PayableInvoice__c != null, c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__PayableInvoice__c, "")))))) , c2g__TransactionLineItem__r.c2g__Transaction__r.c2g__DocumentNumber__c )
|
Text |
|
|
| c2g__DualOutstandingValue__c |
Dual Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| c2g__DualValue__c |
Dual Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| c2g__ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
false |
|
| c2g__HomeOutstandingValue__c |
Home Outstanding Value |
Pre-Spring 2018 |
See note 2
|
Number(18,2) |
false |
0 |
| c2g__HomeValue__c |
Home Value |
Pre-Spring 2018 |
See note 1
|
Number(18,2) |
false |
0 |
| c2g__LineNumber__c |
Line Number |
Pre-Spring 2018 |
Sequential number – the order of creation
|
Number(18,0) |
false |
0 |
| c2g__MatchedType__c |
Match Type |
Pre-Spring 2018 |
|
Text(255) |
false |
|
| c2g__MatchingCurrency__c |
Matching Currency |
Pre-Spring 2018 |
Looks up to: c2g__codaAccountingCurrency__c
|
Lookup |
false |
|
| c2g__MatchingDate__c |
Matching Date |
Pre-Spring 2018 |
The date when the line was matched in allocation
|
Date |
false |
Today() |
| c2g__MatchingReference__c |
Matching Reference |
Pre-Spring 2018 |
A reference linking matched lines
Looks up to: c2g__codaMatchingReference__c
|
Lookup |
false |
|
| c2g__OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: c2g__codaCompany__c
|
Lookup |
false |
|
| c2g__Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: c2g__codaPeriod__c
|
Lookup |
false |
|
| c2g__ReportingOutstandingValue__c |
Reporting Outstanding Value |
Fall 2021 |
The outstanding value used to report to the parent company.
|
Number(18,2) |
false |
|
| c2g__ReportingValue__c |
Reporting Value |
Fall 2021 |
The value used to report to the parent company.
|
Number(18,2) |
false |
|
| c2g__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: c2g__codaTransactionLineItem__c
|
Lookup |
false |
|
| c2g__UndoMatchingReference__c |
Undo Matching Reference |
Pre-Spring 2018 |
A reference linking un-matched lines
Looks up to: c2g__codaMatchingReference__c
|
Lookup |
false |
|
| c2g__UndoReason__c |
Undo Reason |
Pre-Spring 2018 |
The reason for matching being undone
|
Picklist:
Matching Error
Remittance Advice Incorrect |
|
|
| c2g__UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
false |
|
| c2g__Year__c |
Year |
Pre-Spring 2018 |
Formula:
c2g__Period__r.c2g__YearName__r.Name
|
Text |
false |
|
