| AccountAllocated__c |
Account Allocated |
Pre-Spring 2018 |
Formula:
AccountTotal__c - AccountUnallocated__c
|
Number(18,2) |
|
| AccountCurrency__c |
Account Currency |
Pre-Spring 2018 |
Formula:
Account__r.CODAAccountTradingCurrency__c
|
Text |
|
| AccountDimension1__c |
Account Dimension 1 |
Pre-Spring 2018 |
Looks up to: codaDimension1__c
|
Lookup |
|
| AccountDimension2__c |
Account Dimension 2 |
Pre-Spring 2018 |
Looks up to: codaDimension2__c
|
Lookup |
|
| AccountDimension3__c |
Account Dimension 3 |
Pre-Spring 2018 |
Looks up to: codaDimension3__c
|
Lookup |
|
| AccountDimension4__c |
Account Dimension 4 |
Pre-Spring 2018 |
Looks up to: codaDimension4__c
|
Lookup |
|
| AccountTotal__c |
Account Total |
Pre-Spring 2018 |
Formula:
IF(ISPICKVAL(Type__c,'Payment') || ISPICKVAL(Type__c,'Payment Refund'),-1 * Transaction__r.AccountTotal__c, Transaction__r.AccountTotal__c)
|
Number(18,2) |
|
| AccountUnallocated__c |
Account Unallocated |
Pre-Spring 2018 |
Formula:
IF(ISPICKVAL(Type__c,'Payment') || ISPICKVAL(Type__c,'Payment Refund'),-1 * Transaction__r.AccountOutstandingTotal__c, Transaction__r.AccountOutstandingTotal__c)
|
Number(18,2) |
|
| Account__c |
Account |
Pre-Spring 2018 |
Looks up to: Account
|
Lookup |
|
| BankAccountCurrency__c |
Bank Account Currency |
Pre-Spring 2018 |
Formula:
BankAccount__r.BankAccountCurrency__r.Name
|
Text |
|
| BankAccountDimension1__c |
Bank Account Dimension 1 |
Pre-Spring 2018 |
Looks up to: codaDimension1__c
|
Lookup |
|
| BankAccountDimension2__c |
Bank Account Dimension 2 |
Pre-Spring 2018 |
Looks up to: codaDimension2__c
|
Lookup |
|
| BankAccountDimension3__c |
Bank Account Dimension 3 |
Pre-Spring 2018 |
Looks up to: codaDimension3__c
|
Lookup |
|
| BankAccountDimension4__c |
Bank Account Dimension 4 |
Pre-Spring 2018 |
Looks up to: codaDimension4__c
|
Lookup |
|
| BankAccountValue__c |
Bank Account Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
| BankAccount__c |
Bank Account |
Pre-Spring 2018 |
Looks up to: codaBankAccount__c
|
Lookup |
|
| CancelingCashEntry__c |
Canceling Cash Entry Number |
Pre-Spring 2018 |
Looks up to: codaCashEntry__c
|
Lookup |
|
| CashEntryCurrency__c |
Cash Entry Currency |
Pre-Spring 2018 |
Looks up to: codaAccountingCurrency__c
|
Lookup |
|
| CashEntryRate__c |
Cash Entry Rate |
Pre-Spring 2018 |
|
Number(18,9) |
|
| ChargesAmount__c |
Bank Charge |
Pre-Spring 2018 |
|
Number(18,2) |
0 |
| ChargesGLADimension1__c |
Dimension 1 |
Pre-Spring 2018 |
Looks up to: codaDimension1__c
|
Lookup |
|
| ChargesGLADimension2__c |
Dimension 2 |
Pre-Spring 2018 |
Looks up to: codaDimension2__c
|
Lookup |
|
| ChargesGLADimension3__c |
Dimension 3 |
Pre-Spring 2018 |
Looks up to: codaDimension3__c
|
Lookup |
|
| ChargesGLADimension4__c |
Dimension 4 |
Pre-Spring 2018 |
Looks up to: codaDimension4__c
|
Lookup |
|
| ChargesGLA__c |
Bank Charges GLA |
Pre-Spring 2018 |
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
|
| ChargesLocalGLA__c |
Bank Charges Local GLA |
Pre-Spring 2018 |
Lookup to GLA
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
|
| CompanyReference__c |
Company Name |
Pre-Spring 2018 |
Company Reference
Formula:
OwnerCompany__r.Name
|
Text |
|
| Currency__c |
Payment Currency |
Pre-Spring 2018 |
Cash entry currency.
Formula:
CashEntryCurrency__r.Name
|
Text |
|
| Date__c |
Date |
Pre-Spring 2018 |
The date on the cheque, etc.
|
Date |
TODAY() |
| Description__c |
Description |
Pre-Spring 2018 |
An optional description of the item
|
TextArea |
|
| DiscardReason__c |
Discard Reason |
Pre-Spring 2018 |
The reason the item was discarded (canceled)
|
TextArea |
|
| DualRate__c |
Dual Rate |
Pre-Spring 2018 |
|
Number(18,9) |
|
| ExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
|
| FromIntercompanyTransfer__c |
From Intercompany Transfer |
Pre-Spring 2018 |
|
Checkbox |
false |
| IntercompanyTransfer__c |
Intercompany Transfer |
Pre-Spring 2018 |
Looks up to: codaIntercompanyTransfer__c
|
Lookup |
|
| LineCharges__c |
Line Charges |
Pre-Spring 2018 |
|
Number(18,2) |
|
| NetBanked__c |
Net Banked |
Pre-Spring 2018 |
Formula:
BankAccountValue__c - TotalCharges__c
|
Number(18,2) |
|
| NetValue__c |
Net Value |
Pre-Spring 2018 |
|
Number(18,2) |
|
| OriginalCashEntry__c |
Original Cash Entry Number |
Pre-Spring 2018 |
Looks up to: codaCashEntry__c
|
Lookup |
|
| OwnerCompany__c |
Company |
Pre-Spring 2018 |
Looks up to: codaCompany__c
|
Lookup |
|
| PaymentMethod__c |
Payment Method |
Pre-Spring 2018 |
The type of payment
|
Picklist:
Cash
Check
Electronic
Mixed |
|
| PaymentNumber__c |
Payment Number |
Pre-Spring 2018 |
Looks up to: codaPayment__c
|
Lookup |
|
| PaymentStatus__c |
Payment Status |
Pre-Spring 2018 |
Formula:
if( NOT( ISPICKVAL( Status__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 |
|
| PaymentTotal__c |
Payment Total |
Pre-Spring 2018 |
Document total generated in the transaction.
Formula:
IF(ISPICKVAL(Type__c,'Payment') || ISPICKVAL(Type__c,'Payment Refund'),-1 * Transaction__r.DocumentTotal__c, Transaction__r.DocumentTotal__c)
|
Number(18,2) |
|
| PaymentType__c |
Payment Type |
Pre-Spring 2018 |
Convert type for final community users.
Formula:
IF( ISPICKVAL(Type__c, 'Receipt'), $Label.CommunitiesCashEntryTypePayment, IF( ISPICKVAL(Type__c, 'Payment'), $Label.CommunitiesCashEntryTypePaid, IF( ISPICKVAL(Type__c, 'Payment Refund'), $Label.CommunitiesCashEntryTypeRefunded, $Label.CommunitiesCashEntryTypeRefund)))
|
Text |
|
| Period__c |
Period |
Pre-Spring 2018 |
Financial period
Looks up to: codaPeriod__c
|
Lookup |
|
| Reference__c |
Reference |
Pre-Spring 2018 |
Any reference number from the registered item, such as giro #
|
Text(80) |
|
| ReportingRate__c |
Reporting Rate |
Spring 2022 |
|
Number(18,9) |
|
| SignedBankCharge__c |
Signed Bank Charge |
Pre-Spring 2018 |
Formula:
IF( text(Type__c) = "Refund", ChargesAmount__c *-1, ChargesAmount__c )
|
Number(18,2) |
|
| SignedNetBanked__c |
Signed Net Banked |
Pre-Spring 2018 |
Formula:
IF( text(Type__c) = "Refund", NetBanked__c *-1, NetBanked__c )
|
Number(18,2) |
|
| Status__c |
Status |
Pre-Spring 2018 |
The status of the item
|
Picklist:
Complete
Discarded
In Progress |
|
| TotalAllocated__c |
Payment Allocated |
Pre-Spring 2018 |
The total value minus the outstanding value generated in the transaction.
Formula:
PaymentTotal__c - TotalUnallocated__c
|
Number(18,2) |
|
| TotalCharges__c |
Total Charges |
Pre-Spring 2018 |
|
Number(18,2) |
0 |
| TotalUnallocated__c |
Payment Unallocated |
Pre-Spring 2018 |
The outstanding value generated in the transaction.
Formula:
IF(ISPICKVAL(Type__c,'Payment') || ISPICKVAL(Type__c,'Payment Refund'),-1 * Transaction__r.DocumentOutstandingTotal__c, Transaction__r.DocumentOutstandingTotal__c)
|
Number(18,2) |
|
| Transaction__c |
Transaction |
Pre-Spring 2018 |
Looks up to: codaTransaction__c
|
Lookup |
|
| Type__c |
Type |
Pre-Spring 2018 |
The direction of payment
|
Picklist:
Payment
Payment Refund
Receipt
Refund |
|
| UnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
|
| Value__c |
Cash Entry Value |
Pre-Spring 2018 |
The amount in home currency
|
Number(18,2) |
0 |
| Year__c |
Year |
Pre-Spring 2018 |
Formula:
Period__r.YearName__r.Name
|
Text |
|
