| c2g__AccountAllocated__c |
Account Allocated |
Pre-Spring 2018 |
Formula:
c2g__AccountTotal__c - c2g__AccountUnallocated__c
|
Number(18,2) |
|
|
| c2g__AccountCurrency__c |
Account Currency |
Pre-Spring 2018 |
Formula:
c2g__Account__r.c2g__CODAAccountTradingCurrency__c
|
Text |
|
|
| c2g__AccountDimension1__c |
Account Dimension 1 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension1__c
|
Lookup |
|
|
| c2g__AccountDimension2__c |
Account Dimension 2 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension2__c
|
Lookup |
|
|
| c2g__AccountDimension3__c |
Account Dimension 3 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension3__c
|
Lookup |
|
|
| c2g__AccountDimension4__c |
Account Dimension 4 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension4__c
|
Lookup |
|
|
| c2g__AccountTotal__c |
Account Total |
Pre-Spring 2018 |
Formula:
IF(ISPICKVAL(c2g__Type__c,'Payment') || ISPICKVAL(c2g__Type__c,'Payment Refund'),-1 * c2g__Transaction__r.c2g__AccountTotal__c, c2g__Transaction__r.c2g__AccountTotal__c)
|
Number(18,2) |
|
|
| c2g__AccountUnallocated__c |
Account Unallocated |
Pre-Spring 2018 |
Formula:
IF(ISPICKVAL(c2g__Type__c,'Payment') || ISPICKVAL(c2g__Type__c,'Payment Refund'),-1 * c2g__Transaction__r.c2g__AccountOutstandingTotal__c, c2g__Transaction__r.c2g__AccountOutstandingTotal__c)
|
Number(18,2) |
|
|
| c2g__Account__c |
Account |
Pre-Spring 2018 |
Looks up to: Account
|
Lookup |
|
|
| c2g__BankAccountCurrency__c |
Bank Account Currency |
Pre-Spring 2018 |
Formula:
c2g__BankAccount__r.c2g__BankAccountCurrency__r.Name
|
Text |
|
|
| c2g__BankAccountDimension1__c |
Bank Account Dimension 1 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension1__c
|
Lookup |
|
|
| c2g__BankAccountDimension2__c |
Bank Account Dimension 2 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension2__c
|
Lookup |
|
|
| c2g__BankAccountDimension3__c |
Bank Account Dimension 3 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension3__c
|
Lookup |
|
|
| c2g__BankAccountDimension4__c |
Bank Account Dimension 4 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension4__c
|
Lookup |
|
|
| c2g__BankAccountValue__c |
Bank Account Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
0 |
| c2g__BankAccount__c |
Bank Account |
Pre-Spring 2018 |
Looks up to: c2g__codaBankAccount__c
|
Lookup |
|
|
| c2g__CancelingCashEntry__c |
Canceling Cash Entry Number |
Pre-Spring 2018 |
Looks up to: c2g__codaCashEntry__c
|
Lookup |
false |
|
| c2g__CashEntryCurrency__c |
Cash Entry Currency |
Pre-Spring 2018 |
Looks up to: c2g__codaAccountingCurrency__c
|
Lookup |
|
|
| c2g__CashEntryRate__c |
Cash Entry Rate |
Pre-Spring 2018 |
|
Number(18,9) |
|
|
| c2g__ChargesAmount__c |
Bank Charge |
Pre-Spring 2018 |
|
Number(18,2) |
|
0 |
| c2g__ChargesGLADimension1__c |
Dimension 1 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension1__c
|
Lookup |
|
|
| c2g__ChargesGLADimension2__c |
Dimension 2 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension2__c
|
Lookup |
|
|
| c2g__ChargesGLADimension3__c |
Dimension 3 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension3__c
|
Lookup |
|
|
| c2g__ChargesGLADimension4__c |
Dimension 4 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension4__c
|
Lookup |
|
|
| c2g__ChargesGLA__c |
Bank Charges GLA |
Pre-Spring 2018 |
Looks up to: c2g__codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| c2g__ChargesLocalGLA__c |
Bank Charges Local GLA |
Pre-Spring 2018 |
Lookup to GLA
Looks up to: c2g__codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| c2g__CompanyReference__c |
Company Name |
Pre-Spring 2018 |
Company Reference
Formula:
c2g__OwnerCompany__r.Name
|
Text |
|
|
| c2g__Currency__c |
Payment Currency |
Pre-Spring 2018 |
Cash entry currency.
Formula:
c2g__CashEntryCurrency__r.Name
|
Text |
|
|
| c2g__Date__c |
Date |
Pre-Spring 2018 |
The date on the cheque, etc.
|
Date |
true |
TODAY() |
| c2g__DeriveBankAccountDimensions__c |
Derive Bank Account Dimensions |
Winter 2023 |
|
Checkbox |
|
true |
| c2g__DeriveBankAccount__c |
Derive Company Bank Account |
Winter 2023 |
|
Checkbox |
|
true |
| c2g__DeriveBankChargesAnalysis__c |
Derive Bank Charges Analysis |
Winter 2023 |
|
Checkbox |
|
true |
| c2g__DeriveCurrency__c |
Derive Bank Account Currency |
Winter 2023 |
|
Checkbox |
|
true |
| c2g__DerivePeriod__c |
Derive Period |
Winter 2023 |
|
Checkbox |
|
true |
| c2g__Description__c |
Description |
Pre-Spring 2018 |
An optional description of the item
|
TextArea |
|
|
| c2g__DiscardReason__c |
Discard Reason |
Pre-Spring 2018 |
The reason the item was discarded (canceled)
|
TextArea |
|
|
| c2g__DualRate__c |
Dual Rate |
Pre-Spring 2018 |
|
Number(18,9) |
|
|
| c2g__ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
|
|
| c2g__FromIntercompanyTransfer__c |
From Intercompany Transfer |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__IntercompanyTransfer__c |
Intercompany Transfer |
Pre-Spring 2018 |
Looks up to: c2g__codaIntercompanyTransfer__c
|
Lookup |
|
|
| c2g__LineCharges__c |
Line Charges |
Pre-Spring 2018 |
|
Number(18,2) |
|
|
| c2g__LineCount__c |
Line Count |
Winter 2024 |
The number of lines on the cash entry.
|
Summary |
|
|
| c2g__NetBanked__c |
Net Banked |
Pre-Spring 2018 |
Formula:
c2g__BankAccountValue__c - c2g__TotalCharges__c
|
Number(18,2) |
|
|
| c2g__NetTotal__c |
Net Total |
Winter 2024 |
Sum of the net values on the cash entry line items.
|
Summary |
|
|
| c2g__NetValue__c |
Net Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
0 |
| c2g__OriginalCashEntry__c |
Original Cash Entry Number |
Pre-Spring 2018 |
Looks up to: c2g__codaCashEntry__c
|
Lookup |
false |
|
| c2g__OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: c2g__codaCompany__c
|
Lookup |
|
|
| c2g__PaymentMediaSummary__c |
Payment Media Summary |
Winter 2024 |
Lookup to the payment media summary record associated with the cash entry.
Looks up to: c2g__codaPaymentMediaSummary__c
|
Lookup |
|
|
| c2g__PaymentMethod__c |
Payment Method |
Pre-Spring 2018 |
The type of payment
|
Picklist:
Cash
Check
Electronic
Mixed |
|
|
| c2g__PaymentNumber__c |
Payment Number |
Pre-Spring 2018 |
Looks up to: c2g__codaPayment__c
|
Lookup |
|
|
| c2g__PaymentStatus__c |
Payment Status |
Pre-Spring 2018 |
Formula:
if( NOT( ISPICKVAL( c2g__Status__c, 'Complete' ) ), $Label.NotApplicable, if( c2g__Transaction__r.c2g__DocumentOutstandingTotal__c == 0, $Label.Paid, if( c2g__Transaction__r.c2g__DocumentTotal__c == c2g__Transaction__r.c2g__DocumentOutstandingTotal__c, $Label.codaPurchaseInvoiceFieldStatusUnpaid, $Label.codaPurchaseInvoiceFieldStatusPartPaid ) ) )
|
Text |
false |
|
| c2g__PaymentTotal__c |
Payment Total |
Pre-Spring 2018 |
Document total generated in the transaction.
Formula:
IF(ISPICKVAL(c2g__Type__c,'Payment') || ISPICKVAL(c2g__Type__c,'Payment Refund'),-1 * c2g__Transaction__r.c2g__DocumentTotal__c, c2g__Transaction__r.c2g__DocumentTotal__c)
|
Number(18,2) |
|
|
| c2g__PaymentType__c |
Payment Type |
Pre-Spring 2018 |
Convert type for final community users.
Formula:
IF( ISPICKVAL(c2g__Type__c, 'Receipt'), $Label.CommunitiesCashEntryTypePayment, IF( ISPICKVAL(c2g__Type__c, 'Payment'), $Label.Paid, IF( ISPICKVAL(c2g__Type__c, 'Payment Refund'), $Label.CommunitiesCashEntryTypeRefunded, $Label.CommunitiesCashEntryTypeRefund)))
|
Text |
|
|
| c2g__Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: c2g__codaPeriod__c
|
Lookup |
|
|
| c2g__Reference__c |
Reference |
Pre-Spring 2018 |
Any reference number from the registered item, such as giro #
|
Text(80) |
|
|
| c2g__ReportingRate__c |
Reporting Rate |
Spring 2022 |
|
Number(18,9) |
|
|
| c2g__SignedBankCharge__c |
Signed Bank Charge |
Pre-Spring 2018 |
Formula:
IF( text(c2g__Type__c) = "Refund", c2g__ChargesAmount__c *-1, c2g__ChargesAmount__c )
|
Number(18,2) |
|
|
| c2g__SignedNetBanked__c |
Signed Net Banked |
Pre-Spring 2018 |
Formula:
IF( text(c2g__Type__c) = "Refund", c2g__NetBanked__c *-1, c2g__NetBanked__c )
|
Number(18,2) |
|
|
| c2g__Status__c |
Status |
Pre-Spring 2018 |
The status of the item
|
Picklist:
Complete
Discarded
In Progress
Ready to Post |
|
|
| c2g__TotalAllocated__c |
Payment Allocated |
Pre-Spring 2018 |
The total value minus the outstanding value generated in the transaction.
Formula:
c2g__PaymentTotal__c - c2g__TotalUnallocated__c
|
Number(18,2) |
|
|
| c2g__TotalBankAccountValue__c |
Total Bank Account Value |
Winter 2024 |
Sum of the bank account values on the cash entry line items.
|
Summary |
|
|
| c2g__TotalCashEntryValue__c |
Total Cash Entry Value |
Winter 2024 |
Sum of the cash entry values on the cash entry line items.
|
Summary |
|
|
| c2g__TotalCharges__c |
Total Charges |
Pre-Spring 2018 |
|
Number(18,2) |
|
0 |
| c2g__TotalLineCharges__c |
Total Line Charges |
Winter 2024 |
Sum of the charges on the cash entry line items.
|
Summary |
|
|
| c2g__TotalUnallocated__c |
Payment Unallocated |
Pre-Spring 2018 |
The outstanding value generated in the transaction.
Formula:
IF(ISPICKVAL(c2g__Type__c,'Payment') || ISPICKVAL(c2g__Type__c,'Payment Refund'),-1 * c2g__Transaction__r.c2g__DocumentOutstandingTotal__c, c2g__Transaction__r.c2g__DocumentOutstandingTotal__c)
|
Number(18,2) |
|
|
| c2g__Transaction__c |
Transaction |
Pre-Spring 2018 |
Looks up to: c2g__codaTransaction__c
|
Lookup |
|
|
| c2g__TriggerPostingError__c |
Trigger Posting Error |
Winter 2023 |
|
TextArea |
false |
|
| c2g__TriggerPosting__c |
Trigger Posting |
Winter 2023 |
The method of trigger-posting a document after its header has been updated.
|
Picklist:
Asynchronous
Synchronous |
|
|
| c2g__Type__c |
Type |
Pre-Spring 2018 |
The direction of payment
|
Picklist:
Payment
Payment Refund
Receipt
Refund |
|
|
| c2g__UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
|
|
| c2g__Value__c |
Cash Entry Value |
Pre-Spring 2018 |
The amount in home currency
|
Number(18,2) |
|
0 |
| c2g__Year__c |
Year |
Pre-Spring 2018 |
Formula:
c2g__Period__r.c2g__YearName__r.Name
|
Text |
|
|
