SpecialAccount Table
| Column | Data type | Data type name | Length | Can be queried? | Can be updated? | Can be inserted? | Mandatory when inserting? | Format | Refers To | Version introduced in | Edition available in |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SpecialAccountType | 12 | VARCHAR | 30 | True | False | True | False | AccountsPayable AccountsReceivable CondenseItemAdjustmentExpenses CostOfGoodsSold DirectDepositLiabilities Estimates InventoryAssets OpeningBalanceEquity PayrollExpenses PayrollLiabilities PurchaseOrders RetainedEarnings SalesOrders SalesTaxPayable UncategorizedExpenses UncategorizedIncome UndepositedFunds |
2.1 | US, CA, UK | |
| CurrencyRef_ListID | 12 | VARCHAR | 36 | True | False | True | False | %s | ListID | 1.0 | US, CA, UK |
| CurrencyRef_FullName | 12 | VARCHAR | 64 | True | False | True | False | %s | Name | 1.0 | US, CA, UK |