| c2g__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 |
|
| c2g__CODAAccountTradingCurrency__c |
Account Trading Currency |
Pre-Spring 2018 |
|
Text(3) |
|
|
| c2g__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: c2g__codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| c2g__CODAAccountsReceivableControl__c |
Accounts Receivable Control |
Pre-Spring 2018 |
An appropriate accounts receivable (or trade debtors) general ledger account.
Looks up to: c2g__codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| c2g__CODAAllowDeleteInUse__c |
Allow Deletion of Account in Use |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__CODABankAccountName__c |
Bank Account Name |
Pre-Spring 2018 |
The name of the bank account
|
Text(255) |
|
|
| c2g__CODABankAccountNumber__c |
Bank Account Number |
Pre-Spring 2018 |
The account number
|
Text(40) |
|
|
| c2g__CODABankAccountReference__c |
Bank Account Reference |
Pre-Spring 2018 |
The account reference, sometimes required for electronic transfers
|
Text(20) |
|
|
| c2g__CODABankCity__c |
Bank City |
Pre-Spring 2018 |
The city
|
Text(40) |
|
|
| c2g__CODABankCountry__c |
Bank Country |
Pre-Spring 2018 |
The country
|
Text(40) |
|
|
| c2g__CODABankFax__c |
Bank Fax |
Pre-Spring 2018 |
The fax number
|
Phone |
|
|
| c2g__CODABankIBANNumber__c |
Bank IBAN Number |
Pre-Spring 2018 |
The IBAN number
|
Text(40) |
|
|
| c2g__CODABankName__c |
Bank Name |
Pre-Spring 2018 |
The name of the bank
|
Text(255) |
|
|
| c2g__CODABankPhone__c |
Bank Phone |
Pre-Spring 2018 |
The bank phone number
|
Phone |
|
|
| c2g__CODABankSWIFTNumber__c |
Bank SWIFT Number |
Pre-Spring 2018 |
The SWIFT or similar number
|
Text(40) |
|
|
| c2g__CODABankSortCode__c |
Bank Sort Code |
Pre-Spring 2018 |
The sort code / bank identifier
|
Text(20) |
|
|
| c2g__CODABankStateProvince__c |
Bank State/Province |
Pre-Spring 2018 |
The state / county / province
|
Text(20) |
|
|
| c2g__CODABankStreet__c |
Bank Street |
Pre-Spring 2018 |
|
TextArea |
|
|
| c2g__CODABankZipPostalCode__c |
Bank Zip/Postal Code |
Pre-Spring 2018 |
The postal code
|
Text(20) |
|
|
| c2g__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 |
|
|
| c2g__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 |
|
|
| c2g__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 |
|
|
| c2g__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 |
|
|
| c2g__CODABillingAddressIsValid__c |
Billing Address Validated |
Pre-Spring 2018 |
Formula:
NOT(ISBLANK(BillingStreet) && ISBLANK(BillingCity) && ISBLANK(BillingState) && ISBLANK(BillingPostalCode) && ISBLANK(BillingCountry)) && c2g__CODAValidatedBillingStreet__c == BillingStreet && c2g__CODAValidatedBillingCity__c == BillingCity && c2g__CODAValidatedBillingState__c == BillingState && c2g__CODAValidatedBillingPostCode__c == BillingPostalCode && c2g__CODAValidatedBillingCountry__c == BillingCountry
|
Checkbox |
|
|
| c2g__CODABillingMethod__c |
Billing Method |
Pre-Spring 2018 |
The billing method
|
Picklist:
Electronic
Paper
Self-billing |
|
|
| c2g__CODACreditAgency__c |
Credit Agency |
Pre-Spring 2018 |
The name of the credit agency
|
Text(255) |
|
|
| c2g__CODACreditLimitEnabled__c |
Credit Limit Enabled |
Pre-Spring 2018 |
Set to enable the credit limit
|
Checkbox |
|
false |
| c2g__CODACreditLimitReviewed__c |
Credit Limit Reviewed |
Pre-Spring 2018 |
The date when the limit was last reviewed
|
Date |
|
|
| c2g__CODACreditLimit__c |
Credit Limit |
Pre-Spring 2018 |
The credit limit in org currency
|
Number(18,2) |
|
|
| c2g__CODACreditManager__c |
Credit Manager |
Pre-Spring 2018 |
The manager responsible for the credit details
Looks up to: User
|
Lookup |
|
|
| c2g__CODACreditRatingReviewed__c |
Credit Rating Reviewed |
Pre-Spring 2018 |
The date the rating was last reviewed
|
Date |
|
|
| c2g__CODACreditRating__c |
Credit Rating |
Pre-Spring 2018 |
The rating given by the credit agency
|
Text(40) |
|
|
| c2g__CODACreditReference__c |
Credit Reference |
Pre-Spring 2018 |
The reference at the credit agency
|
Text(40) |
|
|
| c2g__CODACreditStatus__c |
Credit Status |
Pre-Spring 2018 |
The current credit status. The picklist is user-definable
|
Picklist:
Cash with Order
Credit Allowed
On Hold |
|
|
| c2g__CODADaysOffset1__c |
Days Offset 1 |
Pre-Spring 2018 |
The number of days to add to the base date
|
Number(18,0) |
|
0 |
| c2g__CODADaysOffset2__c |
Days Offset 2 |
Pre-Spring 2018 |
The number of days to add to the base date
|
Number(18,0) |
|
|
| c2g__CODADaysOffset3__c |
Days Offset 3 |
Pre-Spring 2018 |
The number of days to add to the base date
|
Number(18,0) |
|
|
| c2g__CODADaysOffset4__c |
Days Offset 4 |
Pre-Spring 2018 |
The number of days to add to the base date
|
Number(18,0) |
|
|
| c2g__CODADefaultExpenseAccount__c |
Default Expense Account |
Pre-Spring 2018 |
The default GLA on expense lines.
Looks up to: c2g__codaGeneralLedgerAccount__c
|
Lookup |
false |
|
| c2g__CODADescription1__c |
Description 1 |
Pre-Spring 2018 |
The description of the settlement terms
|
Text(24) |
|
|
| c2g__CODADescription2__c |
Description 2 |
Pre-Spring 2018 |
The description of the settlement terms
|
Text(24) |
|
|
| c2g__CODADescription3__c |
Description 3 |
Pre-Spring 2018 |
The description of the settlement terms
|
Text(24) |
|
|
| c2g__CODADescription4__c |
Description 4 |
Pre-Spring 2018 |
The description of the settlement terms
|
Text(24) |
|
|
| c2g__CODADimension1__c |
Dimension 1 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension1__c
|
Lookup |
|
|
| c2g__CODADimension2__c |
Dimension 2 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension2__c
|
Lookup |
|
|
| c2g__CODADimension3__c |
Dimension 3 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension3__c
|
Lookup |
|
|
| c2g__CODADimension4__c |
Dimension 4 |
Pre-Spring 2018 |
Looks up to: c2g__codaDimension4__c
|
Lookup |
|
|
| c2g__CODADiscount1__c |
Discount 1 |
Pre-Spring 2018 |
The amount of discount to be applied
|
Number(5,2) |
|
0.00 |
| c2g__CODADiscount2__c |
Discount 2 |
Pre-Spring 2018 |
The amount of discount to be applied
|
Number(5,2) |
|
|
| c2g__CODADiscount3__c |
Discount 3 |
Pre-Spring 2018 |
The amount of discount to be applied
|
Number(5,2) |
|
|
| c2g__CODADiscount4__c |
Discount 4 |
Pre-Spring 2018 |
The amount of discount to be applied
|
Number(5,2) |
|
|
| c2g__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 |
|
|
| c2g__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 |
|
|
| c2g__CODAExemptionCertificate__c |
Exemption Certificate |
Pre-Spring 2018 |
|
Text(20) |
|
|
| c2g__CODAExternalId__c |
External Id |
Pre-Spring 2018 |
|
Text(32) |
|
|
| c2g__CODAFederallyReportable1099__c |
Federally Reportable 1099 |
Pre-Spring 2018 |
Federally Reportable 1099
|
Checkbox |
|
false |
| c2g__CODAFinanceContact__c |
Finance Contact |
Pre-Spring 2018 |
Looks up to: Contact
|
Lookup |
|
|
| c2g__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 |
|
|
| c2g__CODAInputVATCode__c |
Input VAT/GST Code |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__CODAIntercompanyAccount__c |
Intercompany Account |
Pre-Spring 2018 |
|
Checkbox |
|
false |
| c2g__CODAInvoiceEmail__c |
Invoice Email |
Pre-Spring 2018 |
|
Email |
|
|
| c2g__CODAMergeId__c |
Merge Id |
Pre-Spring 2018 |
|
Text(80) |
false |
|
| c2g__CODAOutputVATCode__c |
Output VAT/GST Code |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__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 |
|
|
| c2g__CODAReportingCode__c |
Reporting Code |
Pre-Spring 2018 |
A unique code used for reporting
|
Text(24) |
|
|
| c2g__CODASalesTaxStatus__c |
Sales Tax Status |
Pre-Spring 2018 |
|
Picklist:
Exempt
Exempt for Qualifying Products
Taxable |
|
|
| c2g__CODAShippingAddressIsValid__c |
Shipping Address Validated |
Pre-Spring 2018 |
Formula:
NOT(ISBLANK(ShippingStreet) && ISBLANK(ShippingCity) && ISBLANK(ShippingState) && ISBLANK(ShippingPostalCode) && ISBLANK(ShippingCountry)) && c2g__CODAValidatedShippingStreet__c == ShippingStreet && c2g__CODAValidatedShippingCity__c == ShippingCity && c2g__CODAValidatedShippingState__c == ShippingState && c2g__CODAValidatedShippingPostCode__c == ShippingPostalCode && c2g__CODAValidatedShippingCountry__c == ShippingCountry
|
Checkbox |
|
|
| c2g__CODATaxCalculationMethod__c |
Tax Calculation Method |
Pre-Spring 2018 |
The method of calculating tax in the UK.
|
Picklist:
Gross
Net of Discount |
|
|
| c2g__CODATaxCode1__c |
Tax Code 1 |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__CODATaxCode2__c |
Tax Code 2 |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__CODATaxCode3__c |
Tax Code 3 |
Pre-Spring 2018 |
Looks up to: c2g__codaTaxCode__c
|
Lookup |
|
|
| c2g__CODATaxpayerIdentificationNumber__c |
Taxpayer Identification Number |
Pre-Spring 2018 |
Taxpayer Identification Number
|
Text(15) |
|
|
| c2g__CODAUnitOfWork__c |
Unit of Work |
Pre-Spring 2018 |
|
Number(18,0) |
|
|
| c2g__CODAVATRegistrationNumber__c |
Tax Registration Number |
Pre-Spring 2018 |
Identifying number used for tax purposes.
|
Text(255) |
|
|
| c2g__CODAVATStatus__c |
Tax Status |
Pre-Spring 2018 |
|
Picklist:
EC Non-registered
EC Registered
Export
Home |
|
|
| c2g__CODAValidatedBillingCity__c |
ValidatedBillingCity |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| c2g__CODAValidatedBillingCountry__c |
ValidatedBillingCountry |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| c2g__CODAValidatedBillingPostCode__c |
ValidatedBillingPostCode |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| c2g__CODAValidatedBillingState__c |
ValidatedBillingState |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| c2g__CODAValidatedBillingStreet__c |
ValidatedBillingStreet |
Pre-Spring 2018 |
|
TextArea |
false |
|
| c2g__CODAValidatedShippingCity__c |
ValidatedShippingCity |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| c2g__CODAValidatedShippingCountry__c |
ValidatedShippingCountry |
Pre-Spring 2018 |
|
Text(40) |
false |
|
| c2g__CODAValidatedShippingPostCode__c |
ValidatedShippingPostCode |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| c2g__CODAValidatedShippingState__c |
ValidatedShippingState |
Pre-Spring 2018 |
|
Text(20) |
false |
|
| c2g__CODAValidatedShippingStreet__c |
ValidatedShippingStreet |
Pre-Spring 2018 |
|
TextArea |
false |
|
| c2g__CollectionsOnHoldReason__c |
Collections On Hold Reason |
Fall 2018 |
|
Picklist:
Account in dispute
Invoice in dispute
Other |
false |
|
| c2g__CollectionsOnHold__c |
Collections On Hold |
Fall 2018 |
|
Checkbox |
|
false |
| c2g__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 |
|
