Data entities
Cash and bank management
Finance utilities includes the following data entities in Cash and bank management:
Financial utilities parameters
Cash and bank management > Setup > Advanced bank reconciliation setup > Financial utilities parameters
Data entity: Financial utilities parameters
Financial utilities connection
Cash and bank management > Setup > Advanced bank reconciliation setup > Financial utilities connections
| Order |
Entity |
| 1 |
Financial utilities connections |
| 2 |
Connection - FTP |
| 2 |
Connection - SFTP |
| 2 |
Connection - Azure blob |
| 2 |
Connection - Sharepoint |
Bank accounts
Cash and bank management > Bank accounts > Bank accounts
| Entity |
Additional Finance utilities fields for standard entity |
| Bank accounts |
EFT parameters:
• BPAY batch ID (DFUBPAYBATCHID)
• Extra balance line on EFT (DFUEXTRABALANCELINE)
• Include balance line in record count (DFUBALANCELINECOUNT)
• Total line order (DFUTOTALLINEORDER)
• Use vendor bank name (DFUUSEVENDBANKNAME)
• User identification (DFUEFTUSERID)
Import financial utilities connection:
• Financial utilities connection (DFUCONNECTIONNAME) |
Reconciliation matching rules
Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rules
Note: This standard entity doesn’t support Modern bank reconciliation.
Interim solution to import Modern bank reconciliation matching rules, see ER migration
| Entity |
Additional Finance utilities fields for standard entity |
| Reconciliation matching rules |
Step 2: Do not mark when there are matching bank transactions:
• Group by document number (SYSTEMGENERATEDTYPE = ECL_GroupByDocumentNum)
• Include in (DFUBANKRULEACTIVATEINCLUDEIN)
Step 3: Extended financial details: (pre-Modern bank reconciliation for ‘Mark new transactions’ reconciliation matching rules)
• Company (DFUCOMPANY)
• Offset company (DFUOFFSETCOMPANY)
• Offset account type (DFUOffsetAccountType)
• Offset account (DFUOFFSETLEDGERDIMENSIONDISPLAYVALUE)
• Account’s financial dimension values (DFUDEFAULTDIMENSIONDISPLAYVALUE) **
• Offset account’s financial dimension values (DFUOFFSETDEFAULTDIMENSIONDISPLAYVALUE) **
• Offset account bank statement field (DFUOFFSETACCOUNTFIELDNAME)
• Offset account reference bank statement field (DFUOFFSETACCOUNTREFERENCEFIELDNAME)
• Settle transaction (DFUSETTLETRANS)
• Settle transaction bank statement field (DFUSETTLETRANSFIELDNAME)
• Auto-post customer payment journal (DFUCUSTPAYMAUTOPOST)
• Auto-post and transfer customer payment journal (DFUCUSTPAYMAUTOPOSTTRANSFER)
• GST group (DFUTAXGROUP)
• Item GST group (DFUTAXITEMGROUP)
• Description mask (SAB_DESCRIPTIONMASK) |
** Note: Ensure the Financial dimension configuration for integrating applications dimension format aligns with dimensions on the bank reconciliation matching rule before importing the Reconciliation matching rules entity. General ledger > Chart of accounts > Dimensions > Financial dimension configuration for integrating applications.
Define data entity format for Default dimensions integration and Ledger dimensions integration.
See link for more detail.
Cash and bank management > Setup > Advanced bank reconciliation setup > Bank statement format
Bank statement format entities are a combination of Finance utilities entities and additional fields added to standard entity.
| Order |
Entity |
Standard / Finance
utilities entity |
Additional Finance utilities fields for standard entity |
| 1 |
Bank statement format |
Standard |
• Custom format (SAB_FINCUSTOMFORMAT)
• ABSR file type (SAB_FINFILETYPE)
• Field delimiter (SAB_FINFIELDDELIMITER)
• Record code field position (SAB_FINFIELDPOSITION)
• Record code field length (DFUIMPORTLENGTHRECORDCODE) |
| 2 |
Custom line codes |
Finance utilities |
- |
| 3 |
Bank statement format lines |
Finance utilities |
- |
| 4 |
Line codes format |
Finance utilities |
- |
Note: If comma is used in Field delimiter on the Bank statement format, set SAB_FINFIELDDELIMITER Text qualifier to Yes in Mapping details.
Electronic reporting export
Electronic reporting export connections
Organisation administration > Electronic reporting > Electronic reporting export connections
| Order |
Entity |
| 1 |
Electronic reporting Azure blob connection settings |
| 1 |
Electronic reporting FTP connection settings |
| 1 |
Electronic reporting SFTP connection settings |
Document types
Organisation administration > Document management > Document types
| Order |
Entity |
Standard / Finance
utilities entity |
Additional Finance utilities fields for standard entity |
| 1 |
Document types |
Standard |
• Electronic reporting export connection (DFUGEREXPORTCONNECTION) |
Accounts payable
Finance utilities includes the following data entities in Accounts payable:
Vendor bank accounts
Accounts payable > Vendors > All vendors - Bank accounts on Vendor FastTab
| Entity |
Additional Finance utilities fields for standard entity |
| Vendor bank accounts |
• Biller code (DFUBILLERCODE)
• Lodgement reference (DFULODGEMENTREF)
• Bank code (ECL_BANKCODE)
• Bank particulars (ECL_BANKPARTICULARS)
• Bank reference (ECL_BANKREFERENCE) |
Vendor methods of payment
Accounts payable > Payment setup > Methods of payments
| Entity |
Additional Finance utilities fields for standard entity |
| Vendor payment method |
• Sundry method of payment (DFUSUNDRYPAYM)
• Auto payment reference number (DFUAUTOPAYMENTREFNUMBER)
• BPAY method of payment (DFUBPAYPAYM)
• Generate file per payment line (DFUFILEPERPAYMLINE)
• Payment control > Lodgement reference is mandatory (DFUVALIDATELODGEMENTREFISMANDATORY)
• Payment attributes > Lodgement reference (DFUATTRIBUTELODGEMENTREFENABLED)
• File name mask (DFUFILENAMEMASK) |
Self billing invoicing / RCTI
Finance utilities includes the following data entities for Self billing invoicing / Recipient-Created Tax Invoice (RCTI)
Accounts payable parameters
Accounts payable > Setup > Accounts payable parameters
| Entity |
Additional Finance utilities fields for standard entity |
| Vendor parameters |
• Enable self billing invoicing (DFUSELFBILLINGINVOICING)
• Invoice date (DFUSELFBILLINGINVOICEDATE)
• Posting date (DFUSELFBILLINGPOSTINGDATE) |
Self billing invoice groups
Accounts payable > Setup > Self billing invoice groups
Data entity: Self billing invoice groups
Vendors
Accounts payable > Vendors > All vendors
| Entity |
Additional Finance utilities fields for standard entity |
| Vendors V2 |
• Self billing invoicing (DFUSELFBILLINGINVOICEGROUP) |
Accounts receivable
Finance utilities includes the following data entities in Accounts receivable:
Reference number type
Accounts receivable > Setup > Reference number type
Data entity: Reference number type
Customer references
Accounts receivable > Customers > All customers: Customer references
Data entity: Customer references
ABN and IRD number validation
Validation providers
Organisation administration > Setup > Validation providers
| Order |
Entity |
| 1 |
Validation providers |
| 2 |
Validation provider - ABN |
Legal entities
Organisation administration > Organisations > Legal entities
| Entity |
Additional Finance utilities fields for standard entity |
| Legal entities |
For ABN validation:
• DXCABNValidationEnabled
• DXCABNValidationProviderTypeTable_Name
For IRD number validation:
• DXCCountryRegionId |
Budgeting
Finance utilities includes the following data entities in Budgeting:
Budget utilities parameters
Budgeting > Setup > Basic budgeting > Budget utilities parameters
Data entity: Budget utilities parameters
Accounts receivable - AR utilities
Finance utilities - AR utilities includes the following data entities in Cash and bank management:
Note: The forms and additional fields are only available where additional licensed feature Finance utilities - AR utilities is enabled
Accounts receivable > Payments setup > Remittance format
| Order |
Entity |
| 1 |
Finance utilities template file |
| 2 |
Remittance format |
| 3 |
Finance utilities template file section |
| 4 |
Finance utilities template file line section |
Financial utilities connections
Accounts receivable > Payments setup > Financial utilties connection
| Order |
Entity |
| 1 |
Financial utilities connections |
| 2 |
Connection - FTP |
| 2 |
Connection - SFTP |
| 2 |
Connection - Azure blob |
| 2 |
Connection - Sharepoint |
Accounts receivable parameters
Accounts receivable > Setup > Accounts receivable parameters
| Entity |
Additional Finance utilities fields for standard entity |
| Customer parameters |
• Create prepayment (DXCARCREATEPREPAYMENT)
• Auto post customer payment journal (DXCARAUTOPOSTCUSTPAYMJOUR)
• File attachment document type (DXCARDOCUTYPEID) |
Methods of payment
Accounts receivable > Payment setup > Methods of payment
| Entity |
Additional Finance utilities fields for standard entity |
| Customer payment method |
• Error account customer (DXCARCUSTACCOUNTERROR)
• Settle transactions (DXCARSETTLETRANSACTIONS)
• Posting date (DXCARPOSTINGDATETYPE)
• Reference number type (DXCARREFERENCENUMBERTYPE)
• Remittance format |
