| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | TableName | Data Subtype | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | FieldName | Field Name | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | RefObjType | Data Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | Category | Category | char | 1 | 0 | | N | 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, G=Landed Cost - Broker, H=Incoming Payments, I=Outgoing Payments, J=Sales A/R, K | Allow NULL? |
| 6 | OrigType | Default Data Classification | char | 1 | 0 | | U | P=Personal, S=Sensitive Personal, U=User Defined | Allow NULL? |
| 7 | UserSign | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 8 | UserSign2 | Updating User | int | 6 | 0 | | | | Allow NULL? |
| 9 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 10 | CreateTS | Create Time - Incl. Secs | int | 11 | 0 | | | | Allow NULL? |
| 11 | UpdateDate | Date of Update | date | 8 | 0 | | | | |
| 12 | UpdateTS | Update Full Time | int | 11 | 0 | | | | Allow NULL? |
| 13 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 14 | Type | Data Classification | char | 1 | 0 | | N | N=Not Personal, P=Personal, S=Sensitive Personal | Allow NULL? |
| 15 | Descr | Description | nvarchar | 254 | 0 | | | | Allow NULL? |