Accounting Data Dictionary

codaIntercompanyTransfer__c

Label: Intercompany Transfer

An intermediate staging object used during the intercompany journal process.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
CanceledIntercompanyTransfer__c Canceled Intercompany Transfer Pre-Spring 2018 Looks up to: codaIntercompanyTransfer__c
Lookup
DestinationCashEntry__c Destination Cash Entry Number Pre-Spring 2018 Looks up to: codaCashEntry__c
Lookup
DestinationCompany__c Destination Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
DestinationDocumentBankAccount__c Destination Document Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup
DestinationDocumentCurrency__c Destination Document Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
DestinationDocumentPeriod__c Destination Document Period Pre-Spring 2018 Formula:
IF( ISBLANK( DestinationCashEntry__c ), '', DestinationCashEntry__r.Period__r.Name)
Text
DestinationDocumentReference__c Destination Document Reference Pre-Spring 2018 TextArea
DestinationDocumentTotal__c Destination Document Total Pre-Spring 2018 Formula:
IF( ISBLANK( DestinationPayableInvoice__c ), DestinationPayableCreditNote__r.CreditNoteTotal__c, DestinationPayableInvoice__r.InvoiceTotal__c )
Number(18,2)
DestinationDocumentType__c Destination Document Type Pre-Spring 2018 Picklist:
Payment
Payment Refund
Receipt
Refund
DestinationJournalDate__c Destination Document Date Pre-Spring 2018 Formula:
IF( ISBLANK( DestinationPayableInvoice__c ), IF( ISBLANK( DestinationPayableCreditNote__c ), IF( ISBLANK(DestinationCashEntry__c), DestinationJournal__r.JournalDate__c, DestinationCashEntry__r.Date__c ), DestinationPayableCreditNote__r.CreditNoteDate__c ), DestinationPayableInvoice__r.InvoiceDate__c)
Date
DestinationJournalDescription__c Destination Document Description Pre-Spring 2018 TextArea
DestinationJournalReference__c Destination Document Reference Pre-Spring 2018 Formula:
IF(ISBLANK( DestinationCashEntry__c ), IF( ISBLANK( DestinationPayableInvoice__c ), IF( ISBLANK( DestinationPayableCreditNote__c ), DestinationJournal__r.Reference__c, DestinationPayableCreditNote__r.Reference1__c & IF(ISBLANK(DestinationPayableCreditNote__r.Reference1__c) || ISBLANK(DestinationPayableCreditNote__r.Reference2__c), '', ', ') & DestinationPayableCreditNote__r.Reference2__c ), DestinationPayableInvoice__r.Reference1__c & IF(ISBLANK(DestinationPayableInvoice__r.Reference1__c) || ISBLANK(DestinationPayableInvoice__r.Reference2__c), '', ', ') & DestinationPayableInvoice__r.Reference2__c ), SourceCashEntry__r.Name )
Text
DestinationJournal__c Destination Journal Number Pre-Spring 2018 Looks up to: codaJournal__c
Lookup
DestinationPayableCreditNote__c Destination Payable Credit Note Number Pre-Spring 2018 Looks up to: codaPurchaseCreditNote__c
Lookup
DestinationPayableInvoice__c Destination Payable Invoice Number Pre-Spring 2018 Looks up to: codaPurchaseInvoice__c
Lookup
DocumentRate__c Document Rate Pre-Spring 2018 The document to home exchange rate.

Number(18,9)
DualRate__c Dual Rate Pre-Spring 2018 The dual to home exchange rate.

Number(18,9)
ExternalId__c External Id Pre-Spring 2018 Text(32)
ProcessingMessages__c Processing Messages Pre-Spring 2018 LongTextArea(32000)
ProcessingStatus__c Processing Status Pre-Spring 2018 Picklist:
Available
Complete
Error
Rejected
RejectReason__c Reason for Rejection Pre-Spring 2018 TextArea
SourceCashEntry__c Source Cash Entry Number Pre-Spring 2018 Looks up to: codaCashEntry__c
Lookup
SourceCompany__c Source Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
SourceDocumentBankAccount__c Source Document Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup
SourceDocumentCurrency__c Source Document Currency Pre-Spring 2018 Looks up to: codaAccountingCurrency__c
Lookup
SourceDocumentDate__c Source Document Date Pre-Spring 2018 Date
SourceDocumentName__c Source Document Name Pre-Spring 2018 Formula:
IF( ISBLANK( SourcePayableInvoice__c ), IF( ISBLANK( SourcePayableCreditNote__c ), IF( ISBLANK( SourceSalesInvoice__c ), IF( ISBLANK( SourceSalesCreditNote__c ), IF( ISBLANK( SourceCashEntry__c ), SourceJournal__r.Name, SourceCashEntry__r.Name), SourceSalesCreditNote__r.Name ), SourceSalesInvoice__r.Name ), SourcePayableCreditNote__r.Name ), SourcePayableInvoice__r.Name )
Text
SourceDocumentPeriod__c Source Document Period Pre-Spring 2018 Formula:
IF( ISBLANK( SourceCashEntry__c ), '', SourceCashEntry__r.Period__r.Name)
Text
SourceDocumentReference__c Source Document Reference Pre-Spring 2018 TextArea
SourceDocumentTotal1__c Source Document Total Pre-Spring 2018 Number(18,2)
SourceDocumentTotal__c Source Document Total Pre-Spring 2018 Formula:
IF( ISBLANK( SourceSalesInvoice__c ), SourceSalesCreditNote__r.CreditNoteTotal__c, SourceSalesInvoice__r.InvoiceTotal__c )
Number(18,2)
SourceDocumentType__c Source Document Type Pre-Spring 2018 Picklist:
Payment
Payment Refund
Receipt
Refund
SourceDocumentVendorAccount__c Source Document Account Pre-Spring 2018 Looks up to: Account

Lookup
SourceJournalDate__c Source Document Date Pre-Spring 2018 Formula:
IF( ISBLANK( SourceSalesInvoice__c ), IF( ISBLANK( SourceSalesCreditNote__c ), IF( ISBLANK( SourceJournal__c ), SourceCashEntry__r.Date__c, SourceJournal__r.JournalDate__c ), SourceSalesCreditNote__r.CreditNoteDate__c ), SourceSalesInvoice__r.InvoiceDate__c )
Date
SourceJournalDescription__c Source Document Description Pre-Spring 2018 TextArea
SourceJournalReference__c DEPRECATED: Source Document Reference Pre-Spring 2018 Formula:
IF( ISBLANK( SourceSalesInvoice__c ), IF( ISBLANK( SourceSalesCreditNote__c ), SourceJournal__r.Reference__c, SourceSalesCreditNote__r.CustomerReference__c ), SourceSalesInvoice__r.CustomerReference__c )
Text
SourceJournal__c Source Journal Number Pre-Spring 2018 Looks up to: codaJournal__c
Lookup
SourcePayableCreditNote__c Source Payable Credit Note Number Pre-Spring 2018 Looks up to: codaPurchaseCreditNote__c
Lookup
SourcePayableInvoice__c Source Payable Invoice Number Pre-Spring 2018 Looks up to: codaPurchaseInvoice__c
Lookup
SourceSalesCreditNote__c Source Sales Credit Note Number Pre-Spring 2018 Looks up to: codaCreditNote__c
Lookup
SourceSalesInvoice__c Source Sales Invoice Number Pre-Spring 2018 Looks up to: codaInvoice__c
Lookup
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
Version__c Check optimistic locks Pre-Spring 2018 Number(18,0)


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.