Accounting Data Dictionary

Account
Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AverageDaysToPay__c Average Days to Pay Spring 2019 Number of days the customer takes to pay on average, based on their payments in the last 365 days. The value in this field is automatically calculated.

 Number(5,2)
CODAAccountTradingCurrency__c Account Trading Currency Pre-Spring 2018 Text(3)
CODAAccountsPayableControl__c Accounts Payable Control Pre-Spring 2018 A vendor must refer to a GLA for it to be used in making a posting. This association is inherited from the Accounting Dimension.

Looks up to: codaGeneralLedgerAccount__c
 Lookup
CODAAccountsReceivableControl__c Accounts Receivable Control Pre-Spring 2018 An appropriate accounts receivable (or trade debtors) general ledger account.

Looks up to: codaGeneralLedgerAccount__c
 Lookup
CODAAllowDeleteInUse__c Allow Deletion of Account in Use Pre-Spring 2018 Checkbox false
CODABankAccountName__c Bank Account Name Pre-Spring 2018 The name of the bank account

 Text(255)
CODABankAccountNumber__c Bank Account Number Pre-Spring 2018 The account number

 Text(40)
CODABankAccountReference__c Bank Account Reference Pre-Spring 2018 The account reference, sometimes required for electronic transfers

 Text(20)
CODABankCity__c Bank City Pre-Spring 2018 The city

 Text(40)
CODABankCountry__c Bank Country Pre-Spring 2018 The country

 Text(40)
CODABankFax__c Bank Fax Pre-Spring 2018 The fax number

 Phone
CODABankIBANNumber__c Bank IBAN Number Pre-Spring 2018 The IBAN number

 Text(40)
CODABankName__c Bank Name Pre-Spring 2018 The name of the bank

 Text(255)
CODABankPhone__c Bank Phone Pre-Spring 2018 The bank phone number

 Phone
CODABankSWIFTNumber__c Bank SWIFT Number Pre-Spring 2018 The SWIFT or similar number

 Text(40)
CODABankSortCode__c Bank Sort Code Pre-Spring 2018 The sort code / bank identifier

 Text(20)
CODABankStateProvince__c Bank State/Province Pre-Spring 2018 The state / county / province

 Text(20)
CODABankStreet__c Bank Street Pre-Spring 2018 TextArea
CODABankZipPostalCode__c Bank Zip/Postal Code Pre-Spring 2018 The postal code

 Text(20)
CODABaseDate1__c Base Date 1 Pre-Spring 2018 The date on which terms will be calculated.

 Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABaseDate2__c Base Date 2 Pre-Spring 2018 The date on which terms will be calculated

 Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABaseDate3__c Base Date 3 Pre-Spring 2018 The date on which terms will be calculated

 Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABaseDate4__c Base Date 4 Pre-Spring 2018 The date on which terms will be calculated

 Picklist:
End of Next Month
Invoice Date
Start of Next Month
CODABillingAddressIsValid__c Billing Address Validated Pre-Spring 2018 Formula:
NOT(ISBLANK(BillingStreet) && ISBLANK(BillingCity) && ISBLANK(BillingState) && ISBLANK(BillingPostalCode) && ISBLANK(BillingCountry)) && CODAValidatedBillingStreet__c == BillingStreet && CODAValidatedBillingCity__c == BillingCity && CODAValidatedBillingState__c == BillingState && CODAValidatedBillingPostCode__c == BillingPostalCode && CODAValidatedBillingCountry__c == BillingCountry
 Checkbox
CODABillingMethod__c Billing Method Pre-Spring 2018 The billing method

 Picklist:
Electronic
Paper
Self-billing
CODACreditAgency__c Credit Agency Pre-Spring 2018 The name of the credit agency

 Text(255)
CODACreditLimitEnabled__c Credit Limit Enabled Pre-Spring 2018 Set to enable the credit limit

 Checkbox false
CODACreditLimitReviewed__c Credit Limit Reviewed Pre-Spring 2018 The date when the limit was last reviewed

 Date
CODACreditLimit__c Credit Limit Pre-Spring 2018 The credit limit in org currency

 Number(18,2)
CODACreditManager__c Credit Manager Pre-Spring 2018 The manager responsible for the credit details

Looks up to: User

 Lookup
CODACreditRatingReviewed__c Credit Rating Reviewed Pre-Spring 2018 The date the rating was last reviewed

 Date
CODACreditRating__c Credit Rating Pre-Spring 2018 The rating given by the credit agency

 Text(40)
CODACreditReference__c Credit Reference Pre-Spring 2018 The reference at the credit agency

 Text(40)
CODACreditStatus__c Credit Status Pre-Spring 2018 The current credit status. The picklist is user-definable

 Picklist:
Cash with Order
Credit Allowed
On Hold
CODADaysOffset1__c Days Offset 1 Pre-Spring 2018 The number of days to add to the base date

 Number(18,0) 0
CODADaysOffset2__c Days Offset 2 Pre-Spring 2018 The number of days to add to the base date

 Number(18,0)
CODADaysOffset3__c Days Offset 3 Pre-Spring 2018 The number of days to add to the base date

 Number(18,0)
CODADaysOffset4__c Days Offset 4 Pre-Spring 2018 The number of days to add to the base date

 Number(18,0)
CODADefaultExpenseAccount__c Default Expense Account Pre-Spring 2018 The default GLA on expense lines.

Looks up to: codaGeneralLedgerAccount__c
 Lookup
CODADescription1__c Description 1 Pre-Spring 2018 The description of the settlement terms

 Text(24)
CODADescription2__c Description 2 Pre-Spring 2018 The description of the settlement terms

 Text(24)
CODADescription3__c Description 3 Pre-Spring 2018 The description of the settlement terms

 Text(24)
CODADescription4__c Description 4 Pre-Spring 2018 The description of the settlement terms

 Text(24)
CODADimension1__c Dimension 1 Pre-Spring 2018 Looks up to: codaDimension1__c
 Lookup
CODADimension2__c Dimension 2 Pre-Spring 2018 Looks up to: codaDimension2__c
 Lookup
CODADimension3__c Dimension 3 Pre-Spring 2018 Looks up to: codaDimension3__c
 Lookup
CODADimension4__c Dimension 4 Pre-Spring 2018 Looks up to: codaDimension4__c
 Lookup
CODADiscount1__c Discount 1 Pre-Spring 2018 The amount of discount to be applied

 Number(5,2) 0.00
CODADiscount2__c Discount 2 Pre-Spring 2018 The amount of discount to be applied

 Number(5,2)
CODADiscount3__c Discount 3 Pre-Spring 2018 The amount of discount to be applied

 Number(5,2)
CODADiscount4__c Discount 4 Pre-Spring 2018 The amount of discount to be applied

 Number(5,2)
CODAECCountryCode__c Tax Country Code Pre-Spring 2018 Picklist:
AE
AT
AU
BE
BG
CA
CH
CY
CZ
DE
DK
EE
EL
ES
FI
FR
GB
GR
HK
HU
IE
IT
LT
LU
LV
MT
MY
NL
NO
NZ
PL
PT
RO
SE
SG
SI
SK
US
ZA
CODAEntityUseCode__c Entity / Use Code Pre-Spring 2018 Picklist:
A - Federal government - United States
B - State government - United States
C - Tribe / Status Indian / Indian Band - both
D - Foreign diplomat - both
E - Charitable or benevolent org - both
F - Religious or educational org - both
G - Resale - both
H - Commercial agricultural production - both
I - Industrial production / manufacturer - both
J - Direct pay permit - United States
K - Direct mail - United States
L - Other - both
N - Local government - United States
P - Commercial aquaculture - Canada
Q - Commercial Fishery - Canada
R - Non-resident - Canada
CODAExemptionCertificate__c Exemption Certificate Pre-Spring 2018 Text(20)
CODAExternalId__c External Id Pre-Spring 2018 Text(32)
CODAFederallyReportable1099__c Federally Reportable 1099 Pre-Spring 2018 Federally Reportable 1099

 Checkbox false
CODAFinanceContact__c Finance Contact Pre-Spring 2018 Looks up to: Contact

 Lookup
CODAIncomeTaxType__c Income Tax Type Pre-Spring 2018 Income Tax Type

 Picklist:
1 - Rents
10 - Gross Proceeds Paid to an Attorney
11 - Fish Purchased for Resale
12 - Section 409A Deferrals
13 - FATCA Filing Requirement (Checkbox)
14 - Excess Golden Parachute Payments
15 - Nonqualified Deferred Compensation
16 - State Tax Withheld
17 - State/Payer's State No.
18 - State Income
2 - Royalties
3 - Other Income
4 - Federal Income Tax Withheld
5 - Fishing Boat Proceeds
6 - Medical and Healthcare Payments
7 - Payer Made Direct Sales of 5000 or More (Checkbox)
8 - Substitute Payments in Lieu of Dividends or Interest
9 - Crop Insurance Proceeds
Not Reportable
CODAInputVATCode__c Input VAT/GST Code Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
CODAIntercompanyAccount__c Intercompany Account Pre-Spring 2018 Checkbox false
CODAInvoiceEmail__c Invoice Email Pre-Spring 2018 Email
CODAMergeId__c Merge Id Pre-Spring 2018 Text(80)
CODAOutputVATCode__c Output VAT/GST Code Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
CODAPaymentMethod__c Payment Method Pre-Spring 2018 The payment method

 Picklist:
Asperato - Domestic
Asperato - Domestic - ACH
Asperato - Domestic - BANK_TRANSFER
Asperato - Domestic - BPAY
Asperato - Domestic - FAST
Asperato - Domestic - FASTER_PAYMENTS
Asperato - Domestic - FEDWIRE
Asperato - Domestic - FPS
Asperato - Domestic - GIRO
Asperato - Domestic - RTGS
Asperato - International
Cash
Check
Electronic
CODAReportingCode__c Reporting Code Pre-Spring 2018 A unique code used for reporting

 Text(24)
CODASalesTaxStatus__c Sales Tax Status Pre-Spring 2018 Picklist:
Exempt
Exempt for Qualifying Products
Taxable
CODAShippingAddressIsValid__c Shipping Address Validated Pre-Spring 2018 Formula:
NOT(ISBLANK(ShippingStreet) && ISBLANK(ShippingCity) && ISBLANK(ShippingState) && ISBLANK(ShippingPostalCode) && ISBLANK(ShippingCountry)) && CODAValidatedShippingStreet__c == ShippingStreet && CODAValidatedShippingCity__c == ShippingCity && CODAValidatedShippingState__c == ShippingState && CODAValidatedShippingPostCode__c == ShippingPostalCode && CODAValidatedShippingCountry__c == ShippingCountry
 Checkbox
CODATaxCalculationMethod__c Tax Calculation Method Pre-Spring 2018 The method of calculating tax in the UK.

 Picklist:
Gross
Net of Discount
CODATaxCode1__c Tax Code 1 Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
CODATaxCode2__c Tax Code 2 Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
CODATaxCode3__c Tax Code 3 Pre-Spring 2018 Looks up to: codaTaxCode__c
 Lookup
CODATaxpayerIdentificationNumber__c Taxpayer Identification Number Pre-Spring 2018 Taxpayer Identification Number

 Text(15)
CODAUnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)
CODAVATRegistrationNumber__c Tax Registration Number Pre-Spring 2018 Identifying number used for tax purposes.

 Text(255)
CODAVATStatus__c Tax Status Pre-Spring 2018 Picklist:
EC Non-registered
EC Registered
Export
Home
CODAValidatedBillingCity__c ValidatedBillingCity Pre-Spring 2018 Text(40)
CODAValidatedBillingCountry__c ValidatedBillingCountry Pre-Spring 2018 Text(40)
CODAValidatedBillingPostCode__c ValidatedBillingPostCode Pre-Spring 2018 Text(20)
CODAValidatedBillingState__c ValidatedBillingState Pre-Spring 2018 Text(20)
CODAValidatedBillingStreet__c ValidatedBillingStreet Pre-Spring 2018 TextArea
CODAValidatedShippingCity__c ValidatedShippingCity Pre-Spring 2018 Text(40)
CODAValidatedShippingCountry__c ValidatedShippingCountry Pre-Spring 2018 Text(40)
CODAValidatedShippingPostCode__c ValidatedShippingPostCode Pre-Spring 2018 Text(20)
CODAValidatedShippingState__c ValidatedShippingState Pre-Spring 2018 Text(20)
CODAValidatedShippingStreet__c ValidatedShippingStreet Pre-Spring 2018 TextArea
CollectionsOnHoldReason__c Collections On Hold Reason Fall 2018 Picklist:
Account in dispute
Invoice in dispute
Other
CollectionsOnHold__c Collections On Hold Fall 2018 Checkbox false
DaysSalesOutstanding__c Days Sales Outstanding (Annual) Spring 2019 Average number of days it takes to collect payment after a sale has been made, based on the sales and payments made in the last 365 days. The value in this field is automatically calculated.

 Number(16,2)


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