SAP Business One SDK 10.0 - Database Tables Reference
-
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 |