SpecialItem 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SpecialItemType | 12 | VARCHAR | 27 | True | False | True | False | FinanceCharge ReimbursableExpenseGroup ReimbursableExpenseSubtotal |
1.0 | US, CA, UK | |
| BarCode_Value | 12 | VARCHAR | 50 | True | False | True | False | 12.0 | US, CA, UK | ||
| BarCode_AssignEvenIfUsed | -7 | BIT | 2 | True | False | True | False | 1.0 | US, CA, UK | ||
| BarCode_AllowOverride | -7 | BIT | 2 | True | False | True | False | 1.0 | US, CA, UK | ||
| ExternalGUID | 12 | VARCHAR | 40 | True | False | True | False | {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} | 8.0 | US, CA, UK |