| 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) |
false |
|
| 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 |
false |
|
| CODAAccountsReceivableControl__c |
Accounts Receivable Control |
Pre-Spring 2018 |
An appropriate accounts receivable (or trade debtors) general ledger account.
Looks up to: codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| 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 |
false |
|
| 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:
(MISC) 1 - Rents
(MISC) 10 - Gross proceeds paid to an attorney
(MISC) 11 - Fish purchased for resale
(MISC) 12 - Section 409A deferrals
(MISC) 13 - FATCA filing requirement (Checkbox)
(MISC) 14 - Excess golden parachute payments
(MISC) 15 - Nonqualified deferred compensation
(MISC) 16 - State tax withheld
(MISC) 17 - State/Payer's state no.
(MISC) 18 - State income
(MISC) 2 - Royalties
(MISC) 3 - Other income
(MISC) 4 - Federal income tax withheld
(MISC) 5 - Fishing boat proceeds
(MISC) 6 - Medical and health care payments
(MISC) 7 - Payer made direct sales of 5000 or more (Checkbox)
(MISC) 8 - Substitute payments in lieu of dividends or interest
(MISC) 9 - Crop insurance proceeds
(NEC) 1 - Nonemployee compensation
(NEC) 2 - Payer made direct sales of 5000 or more (Checkbox)
(NEC) 4 - Federal income tax withheld
(NEC) 5 - State tax withheld
(NEC) 6 - State/Payer's state no.
(NEC) 7 - State income
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) |
false |
|
| 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) |
false |
|
| CODAValidatedBillingCountry__c |
ValidatedBillingCountry |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| CODAValidatedBillingPostCode__c |
ValidatedBillingPostCode |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| CODAValidatedBillingState__c |
ValidatedBillingState |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| CODAValidatedBillingStreet__c |
ValidatedBillingStreet |
Pre-Spring 2018 |
|
TextArea |
false |
|
| CODAValidatedShippingCity__c |
ValidatedShippingCity |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| CODAValidatedShippingCountry__c |
ValidatedShippingCountry |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| CODAValidatedShippingPostCode__c |
ValidatedShippingPostCode |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| CODAValidatedShippingState__c |
ValidatedShippingState |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| CODAValidatedShippingStreet__c |
ValidatedShippingStreet |
Pre-Spring 2018 |
|
TextArea |
false |
|
| CollectionsOnHoldReason__c |
Collections On Hold Reason |
Fall 2018 |
|
Picklist:
Account in dispute
Invoice in dispute
Other |
false |
|
| 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) |
false |
|
