Custom Transaction Body and Sublist Fields
When you work with custom transactions, the available fields vary depending on the transaction type, the features enabled in your account, and other factors. As a best practice, view the entry form for the transaction instance in the UI to see which fields are available. Alternatively, you can look at the Import Assistant’s mapping screen, or open the transaction type for editing.
The following factors affect field availability:
-
Depending on the custom transaction type’s configuration, the class, department, and location fields may or may not be available. Similarly, these fields can be configured to appear on either the transaction body or Lines sublist. For details on these configuration choices, see Custom Transaction Type Classification Fields.
-
The transaction type may or may not be configured to use the Status field. You can import a value for Status only if statuses exist, and only if the Show Status Field option has been selected for the custom transaction type. When the field is available, you can set a value for status by referencing the status’s text label.
-
Different custom transaction types can be configured to use different custom fields. You can view the fields available to a custom transaction type by viewing the Custom Fields subtab. For more details, see Custom Fields in Custom Transaction Types.
-
A custom transaction type can have any of three list styles. The list style has an impact on whether the Lines sublist is available and how you use the sublist. For more details, see How List Styles Affect Your Import.
-
The Lines sublist is keyed. When updating the sublist, you can use the Line field as a key. Alternatively, if every line has a unique value in the Account field, you can use Account as the key. (Note that this behavior differs from SOAP web services, where you can use only Line as a key, even when every line has a unique Account value.)
-
The Accounting Books sublist is available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. This sublist is selectively updatable based on the Secondary Book key field.
-
The Accounting Book Detail sublist is available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. This sublist is selectively updateable based on the Accounting Book key field.
-
The subsidiary field is available only for OneWorld accounts.
For details on opening a custom transaction type for editing, see Editing a Custom Transaction Type.
For full details about fields that can be mapped in the customer payment record, see the SOAP Schema Browser’s custom transaction reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with this tool, see SOAP Schema Browser.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.