|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Asset Attributes - Rows
Table Name: FAA1
Table Description: Asset Attributes - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | Int | 11 | OFAA | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| AttrID | Attribute ID | Int | 11 | - | Â | Â | Â |
| AttrName | Attribute Name | nVarChar | 100 | - | Â | Â | Â |
| FieldType | Field Type | VarChar | 1 | - | Â | A | Text |
| Â | Â | Â | Â | Â | Â | N | Numeric |
| Â | Â | Â | Â | Â | Â | D | Date |
| Â | Â | Â | Â | Â | Â | S | Amount |
| Â | Â | Â | Â | Â | Â | P | Price |
| Â | Â | Â | Â | Â | Â | Q | Quantity |
| DefaultVal | Default Value | nVarChar | 100 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| SnapshotId | Snapshot ID | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |
| Â | Â | LineNum |
| UNIQUE | Yes | Code |
| Â | Â | AttrID |