Import Specification:  Virtual Account

Table Name: UtilitiesVirtualAccounts 

Table Type:  Utility Tables

Current Import Version: 1.0


Data Specification

Field Name

Data Type

Requires Value?

Max Length

Related Table

Precision

VirtualAccountCode

CleanString

Yes

50



VirtualAccountName

String

Yes

150



AccountType

Available Values+

Yes

50

Accounts


UsageComments

String

No

300




Available Import Header Commands

* This is the default behavior for file import processing of this table.

+ Acceptable Account Types of: Aggregate, Burden, Fee, Labor, ODC, Other.  (only 1 can be used per virtual account, no spaces, and are case sensitive.)


Page ID:1836-2491-5746