--- title: "Spring '25 Accounting Seed Data Dictionary" slug: "spring-25-accounting-seed-data-dictionary" tags: ["Accounting Seed", "Admin"] updated: 2025-06-09T17:48:44Z published: 2025-08-08T18:57:50Z canonical: "documents.revenova.com/spring-25-accounting-seed-data-dictionary" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revenova.com/llms.txt > Use this file to discover all available pages before exploring further. # Spring '25 Accounting Seed Data Dictionary ## **Overview** This document defines all Revenova TMS Accounting Seed fields that are added to the base Salesforce platform when installing the Accounting Seed package. Refer to the Salesforce data dictionary for a description of standard [Salesforce objects and fields](https://developer.salesforce.com/docs/atlas.en-us.248.0.object_reference.meta/object_reference/sforce_api_objects_concepts.htm). Standard fields added to all Salesforce objects (such as Created By) are not defined here. By default, Salesforce uses USD as a single default currency. However, multi-currency is also available. Only enable if you require multi-currency as once enable it cannot be disabled! View the TMS Data Dictionary to reference the data model of the main TMS package. ### **Accessorial** The Accessorial object contains pre-populated, read-only reference data that describes “generic” accessorial charges defined in the TMS. Fields may be added to this list, but **do not delete or modify existing records**. | Field Name | Type | Description | | --- | --- | --- | | Accounting Product | Lookup(Product) | A lookup to the Product associated with the Accessorial. | ### **AP Disbursement** The AP Disbursement object defines the relationship a payable has with a cash disbursement. | Field Name | Type | Description | | --- | --- | --- | | Load | Formula (Text) | The Load related to the Payable the disbursement was applied to. | ### **Billing** The Billing object defines the products or services related to sales to a customer. | Field Name | Type | Description | | --- | --- | --- | | Billing Contact Email | Formula (Text) | The customer billing contact email. | | Billing Method | Picklist | The preferred billing method of the customer. Values include: “Email,” “Print,” and “EDI.” “Email” is the default value. | | Customer Quote | Lookup(Customer Quote) | A lookup to the Customer Quote record associated with this billing. | | Customer Quote Total | Formula (Currency) | The customer quote total monetary amount related to this billing. | | Customer Quote Variance | Formula (Currency) | The monetary amount of variance resulting from the Billing Total - Quote Total. | | Date Sent | Date/Time | The date and time the billing was sent to the customer. | | Days Past Due | Formula (Number) | The number of days the billing is past due. | | Dispute Closed Date | Date/Time | The date and time the billing dispute was closed. | | Dispute Contact | Lookup(Contact) | A lookup to the Contact record associated with the billing dispute. | | Dispute Detail | Text Area(255) | A description of the reason for the billing dispute. | | Dispute Opened Date | Date/Time | The date and time the billing dispute was opened. | | Dispute Owner | Lookup(User) | A lookup to the User record associated with resolving the billing dispute. | | Dispute Reason | Picklist (Multi-Select) | The reason for the billing dispute. Values include: “Damages,” “Late Pickup,” “Late Delivery,” and “Pricing Issue.” No default value. | | Dispute Resolution | Text Area(255) | The resolution details for the billing dispute. | | Dispute Status | Picklist | The current state of the billing dispute. Values include: “Open” and “Closed.” No default value. | | Load | Lookup(Load) | A lookup to the Load record associated with the billing. | | POD Received | Formula (Checkbox) | If “Checked,” the POD for the load was received. | ### **Billing Cash Receipt** The Billing Cash Receipt object defines the relationship a Billing record has with a Cash Receipt record. A Billing Cash Receipt record is created during the Cash Application process. | Field Name | Type | Description | | --- | --- | --- | | Load | Formula (Text) | The Load related to the Billing the cash was applied to. | ### **Billing Line** The Billing Line object defines a specific product or service associated with a Billing record. The aggregation of multiple Billing Lines constitute a Billing record. | Field Name | Type | Description | | --- | --- | --- | | Payable | Checkbox | When “Checked,” the accessorial charge is considered for PayIQ. | | Stop | Lookup(Stop) | A lookup to the Stop record for stop-level accessorial charges. | | Unit | Picklist | The costing unit of measure. Some values include: “Fixed Cost,” “Per Pound,” “Per Day,” etc. No default value. | ### **Cash Disbursement** The Cash Disbursement object defines funds paid to a Vendor. | Field Name | Type | Description | | --- | --- | --- | | ACH Payment Info | Text Area(255) | The ACH Payment information for the cash disbursement. | | Alternate Payee | Lookup(Account) | A lookup to the Account record associated with the Alternate Payee of the cash disbursement. | | Included in NACHA File | Checkbox | If “Checked,” the cash disbursement was included in the NACHA file. | ### **Cash Disbursement Batch** The Cash Disbursement Batch object defines aggregate cash disbursements. This includes detail information including the number of cash disbursements and the total payment amount. | Field Name | Type | Description | | --- | --- | --- | | Batch Type | Picklist | The ePayment type when batch cash disbursing. Values include: “Check” and “ACH (NACHA File).” No default value. | | NACHA File Creation Timestamp | Date/Time | The date and time the NACHA file was generated. | | NACHA File Status | Picklist | The status of a NACHA file. Values include: “Uploaded.” No default value. | | NACHA Reference Code | Text(8) | The reference code in the File Header record when generating a NACHA file. | ### **Contact** The Contact object is a standard Salesforce object and defines a person associated with an Account record. | Field Name | Type | Description | | --- | --- | --- | | ACH Email Recipient | Picklist | Email recipient selection when generating a NACHA file. Values include: “To:,” “CC:,” and “BCC:.” No default value. | ### **ePayment** The ePayment object defines Revenova electronic/advance payments, such as Comcheks. | Field Name | Type | Description | | --- | --- | --- | | Amount | Currency(16, 2) | The monetary amount of the ePayment (Comchek). | | Credit Memo Amount | Picklist | The ePayment in relation to a Vendor Credit memo. Values include: “Amount and Payment Fee,” “Amount Only,” “Payment Fee Only,” and “None.” “Amount and Payment Fee” is the default value. | | Description | Text(100) | A description of the purpose of the ePayment. | | ePayment Fee Product | Lookup(Product) | A lookup to the Product record associated with the ePayment fee. | | ePayment Processing Charge Product | Lookup(Product) | A lookup to the Product record associated with the ePayment processing charge amount. | | ePayment Product | Lookup(Product) | A lookup to the Product record associated with the ePayment. | | ePayment Provider Payable | Lookup(Payable) | A lookup to the Payable record associated with the ePayment provider, such as Comdata. | | Load | Lookup(Load) | A lookup to the Load record associated with the ePayment. | | Name | Auto Number | The unique record identifier. Example: ePay-{0}. | | Payment Fee | Currency(16, 2) | The monetary Payment Fee for the ePayment charged to the recipient. | | Payment Status | Picklist | The current state of the ePayment. Values include: “Pending,” “Issued,” “Frozen,” and “Cancelled.” No default value. | | Processing Charge | Currency(16, 2) | The monetary charge paid to the payment processor - Comdata/EFS. | | Recipient | Lookup(Contact) | A lookup to the Contact record associated with receiving the ePayment. | | Reference Number | Text(100) | The ePayment reference number returned from the issuer. | | Transaction Id | Text(50) | The transaction identifier returned from the ePayment issuer. | | Type | Picklist | The ePayment type. Values include: “Comdata Comchek” and “EFS MoneyCode.” “Comchek” is the default value. | | Vendor | Lookup(Account) | A lookup to the Account record associated with the recipient of the ePayment. | | Vendor Credit Memo | Lookup(Payable) | A lookup to the Payable record associated with the Credit Memo created by the ePayment. | ### **Field Export Definition** The Field Definition object defines the fields that constitute part of a .CSV or NACHA file. | Field Name | Type | Description | | --- | --- | --- | | Data Type | Picklist | Selection for the data type when generating a NACHA file. Values include: “Currency,” “Number,” “Alpha,” “Alphanumeric,” “Date,” “Datetime,” and “Time.” No default value. | | Data Type Format | Text(20) | The data format type for generating a NACHA file. | | Default Value | Text(255) | The default value for a field when generating a NACHA file. | | End Position | Number(4, 0) | The ending field number for generating a NACHA file. | | Field Definition Name | Auto Number | The unique record identifier. Example: FDN-{0000}. | | Field Name | Picklist | Selection of the record type when generating a NACHA file. This field is dependent on the File Type field. No default value. | | Field Size | Number(3, 0) | The size of a field when generating a NACHA file. | | Field Value Requirement | Picklist | Setting for fields when generating a NACHA file. Values include: “Optional,” “Mandatory,” and “Required.” This field is dependent on the File Type field. No default value. | | File Type | Picklist | The type of file when generating a NACHA file. Values include: “NACHA,” with no default value. | | Padding Character | Picklist | The padding character selection for NACHA file generation. Values include: “Blank,” “0,” “1,” “2,” “3,” “4,” “5,” “6,” “7,” “8,” and “9.” No default value. | | Padding Justification | Picklist | Alignment selection when generating NACHA files. Values include: “Left” and “Right.” No default value. | | Record Definition | Master-Detail(Record Definition) | The Master-Detail relationship to the parent Record Definition record the Field Definition belongs to for generating NACHA files. | | Reference Field | Text(40) | The reference field for NACHA file generation. | | Sequence Number | Number(4, 0) | The field number sequence for generating a NACHA file. | | Start Position | Number(4, 0) | The beginning field number for generating a NACHA file. | ### **File Definition** The File Definition object defines a NACHA file. | Field Name | Type | Description | | --- | --- | --- | | Create Balancing Transaction | Picklist | Controls whether a balancing Detail record is included in each batch group of the NACHA file. This field is controlled by the File Type field. Values include “Yes” and “No.” No default value. | | Description | Text Area(255) | The description of the file definition. | | File Definition Name | Text(80) | The name of the file definition. | | File Generator Class | Text(40) | A custom class used for file generation. | | File Type | Picklist | The selected file type for NACHA file generation. Values include: “NACHA,” with no default value. This field is dependent on the Create Balancing Transaction field. | | Line Terminator | Picklist | The text file type supported. Values include: “Unix (LF)” and “Windows (CRLF).” “Unix (LF)” is the default value. | ### **File Export Definition** The File Export Definition object defines an export file that is either a .CSV or NACHA file (future use). | Field Name | Type | Description | | --- | --- | --- | | Create Balancing Transaction | Picklist | Selection for the inclusion of a balancing Detail record for NACHA file generation. Values include “Yes” and “No.” This field is dependent on the File Type field. No default value. | | Description | Text Area(255) | The description of a file definition for NACHA file generation. | | File Definition Name | Text(80) | The file definition for NACHA file generation. | | File Generator Class | Text(40) | A custom class used for NACHA file generation. | | File Type | Picklist | The selected file type for NACHA file generation. Values include: “NACHA,” with no default value. | ### **Payable** The Payable object defines liabilities to outside Vendors, Contacts, or Employees. | Field Name | Type | Description | | --- | --- | --- | | Actual Draft Date | Date/Time | The actual date and time the payment processor takes money from payor account. | | Alternate Payee | Lookup(Account) | A lookup to the Account record associated with the Alternate Payee for NACHA file generation. | | Carrier Quote | Lookup(Carrier Quote) | A lookup to the Carrier Quote record associated with the Payable. | | Carrier Quote Total | Formula (Currency) | The monetary Carrier Quote Total amount related to this Payable. | | Carrier Quote Variance | Formula (Currency) | The monetary amount of the Payable Total - Quote Total. | | Days Past Due | Formula (Number) | The number of days the Payable is past due. Negative numbers indicate the days until the due date. | | Dispute Closed Date | Date/Time | The date and time the dispute was closed. | | Dispute Contact | Lookup(Contact) | A lookup to the Contact record associated with the Payable dispute. | | Dispute Detail | Text Area(255) | A description of the Payable dispute. | | Dispute Opened Date | Date/Time | The date and time the Payable dispute was opened. | | Dispute Owner | Lookup(User) | A lookup to the User record associated with resolving the dispute. | | Dispute Reason | Picklist (Multi-Select) | The category of dispute. Values include: “Damages,” “Late Pickup,” “Late Delivery,” and “Pricing Issue.” No default value. | | Dispute Resolution | Text Area(255) | The resolution details of the dispute. | | Dispute Status | Picklist | The current state of the payment dispute. Values include: “Open” and “Closed.” No default value. | | Load | Lookup(Load) | A lookup to the Load record the Payable is related to. | | Locked By | Lookup(User) | A lookup to the User record disbursing the payables when the Post and Pay job is running. | | Payment Method | Picklist | The method of payment. Values include: “Check” and “ACH (NACHA File). No default value. | | Payment Processor | Picklist | Selection of the payment processor. Values include: “Accounting” and “TriumphPay.” “Accounting” is the default value. | | Payment Processor Details | Text Area(255) | Status details related to payment processor activities. | | Payment Processor Fee | Currency(16, 2) | The monetary amount charged to the payor by the payment processor. | | Payment Processor Rebate | Currency(16, 2) | The monetary amount of rebate from the payment processor to the payor. | | Payment Processor Status | Text(250) | The status of the payment from the payment processor. | | Payment Processor Status Date | Date/Time | The date and time of the last update to the payment processor status. | | Payment Processor Submitted Date | Date/Time | The date and time the payable was submitted. | | POD Received | Formula (Checkbox) | If “Checked,” the POD for the load was received. | | Quick Pay Amount | Currency(16, 2) | The monetary amount deducted from the payable total for early payment. | | Remittance Comments | Text Area(255) | Comments regarding payment remittance for NACHA file generation. | | Scheduled Draft Date | Date/Time | The scheduled date and time the payment processor will take money from the payor account. | | Unmatched EDI Transaction | Text(30) | Captures the Unmatched EDI transaction used to create the Payable. | | Vendor Paid Date | Date/Time | The actual date and time the vendor was paid by the payment processor. | ### **Payable Line** The Payable Line object defines the line item expenses associated with a Payable. The aggregation of multiple payable lines constitute a Payable record. | Field Name | Type | Description | | --- | --- | --- | | Unit | Picklist | The costing unit of measure. Some values include: “Fixed Cost,” “Per Mile,” “Per Day,” etc. No default value. | ### **Product** The Product object defines a product the company sells. | Field Name | Type | Description | | --- | --- | --- | | Product Family | Picklist | Selection for Product Family. “Transportation” added. | ### **Record Export Definition** The Record Definition object defines an export record that is part of an export file and contains fields. | Field Name | Type | Description | | --- | --- | --- | | Field Separator | Text(5) | The field separator for NACHA file generation. | | File Export Definition | Master-Detail(File Definition) | The Master-Detail relationship to the parent File Definition record the Record Definition belongs to for generating NACHA files. | | Record Definition Name | Auto Number | The unique record identifier. Example: RDN-{000}. | | Record Format | Picklist | The record format for NACHA file generation. Values include: “Fixed Length” and “Variable Length.” No default value. | | Record Length | Number(5, 0) | The length of the record length for NACHA file generation. | | Record Type | Picklist | The type of record for NACHA file generation. Values include: “File Header,” “Batch Header,” “Detail,” “Batch Control,” and “File Control.” No default value. | | Sequence Number | Number(2, 0) | The sequence number for NACHA file generation. | ### **Sales Tax** The Sales Tax object defines Revenova customer quote/invoice records for Canadian and Mexican sales tax rates. | Field Name | Type | Description | | --- | --- | --- | | Accounting Product | Lookup(Product) | A lookup to the Accounting Product associated with Sales Tax. |