FFA 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 - Crop Insurance Proceeds
11 - Unused 11
12 - Unused 12
13 - Excess Golden Parachute Payments
14 - Gross Proceeds Paid to an Attorney
2 - Royalties
3 - Other Income
4 - Federal Income Tax Withheld
5 - Fishing Boat Proceeds
6 - Medical and Healthcare Payments
7 - Nonemployee Compensation
8 - Substitute Payments in Lieu of Dividends or Interest
9 - Payer Made Direct Sales of 5000 or More
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 - Bank transfer
Asperato - Domestic - FAST
Asperato - Domestic - FASTER_PAYMENTS
Asperato - Domestic - FPS
Asperato - Domestic - Fedwire
Asperato - Domestic - GIRO
Asperato - Domestic - RTGS
Asperato - Domestic - SEPA
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–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.