|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Personal Fields Setup - History
Table Name: APFS
Table Description: Personal Fields Setup - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| TableName | Data Subtype | nVarChar | 21 | - | Â | Â | Â |
| FieldName | Field Name | nVarChar | 50 | - | Â | Â | Â |
| RefObjType | Data Type | nVarChar | 20 | - | Â | Â | Â |
| Category | Category | VarChar | 1 | - | N | N | Â |
| Â | Â | Â | Â | Â | Â | R | Sales A/R |
| Â | Â | Â | Â | Â | Â | P | Purchase A/P |
| Â | Â | Â | Â | Â | Â | Q | Purchase Request |
| Â | Â | Â | Â | Â | Â | A | Inventory Transfers and Requests Sales A/R |
| Â | Â | Â | Â | Â | Â | B | Inventory Transfers and Requests Purchase A/P |
| Â | Â | Â | Â | Â | Â | C | Opportunity - Business Partner |
| Â | Â | Â | Â | Â | Â | D | Opportunity - Business Partner Channel |
| Â | Â | Â | Â | Â | Â | E | Customer Equipment Card - Business Partner |
| Â | Â | Â | Â | Â | Â | F | Customer Equipment Card - Direct Partner |
| Â | Â | Â | Â | Â | Â | L | Landed Cost - Vendor |
| Â | Â | Â | Â | Â | Â | G | Landed Cost - Broker |
| Â | Â | Â | Â | Â | Â | X | Payment Results - Business Partner |
| Â | Â | Â | Â | Â | Â | U | Payment Results - User |
| Â | Â | Â | Â | Â | Â | H | Incoming Payments |
| Â | Â | Â | Â | Â | Â | I | Outgoing Payments |
| Â | Â | Â | Â | Â | Â | J | Sales A/R |
| Â | Â | Â | Â | Â | Â | K | Purchase A/P |
| Â | Â | Â | Â | Â | Â | M | Bill of Exchange for Incoming Payments |
| Â | Â | Â | Â | Â | Â | S | Business Partner - Contact Person |
| Â | Â | Â | Â | Â | Â | O | Company |
| Â | Â | Â | Â | Â | Â | Y | Service Call - Employee |
| OrigType | Default Data Classification | VarChar | 1 | - | U | U | User Defined |
| Â | Â | Â | Â | Â | Â | S | Sensitive Personal |
| Â | Â | Â | Â | Â | Â | P | Personal |
| Â | Â | Â | Â | Â | Â | N | Not Personal |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTS | Create Time - Incl. Secs | Int | 11 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Type | Data Classification | VarChar | 1 | - | N | N | Not Personal |
| Â | Â | Â | Â | Â | Â | S | Sensitive Personal |
| Â | Â | Â | Â | Â | Â | P | Personal |
| Descr | Description | nVarChar | 254 | - | Â | Â | Â |
| MaxType | Max. Data Classification | VarChar | 1 | - | U | U | User Defined |
| Â | Â | Â | Â | Â | Â | S | Sensitive Personal |
| Â | Â | Â | Â | Â | Â | P | Personal |
| SysDefined | Is System Defined | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |
| SECONDARY | Yes | TableName |
| Â | Â | FieldName |
| Â | Â | Category |
| Â | Â | LogInstanc |