| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | RELID | Region in IMPORT/EXPORT Data Table | nvarchar | 2 | 0 | CHAR | (N' ') | No | | INDX_RELID | Allow NULL? |
| 2 | RVARID | PFDB: GUID for report variants | nvarchar | 32 | 0 | CHAR | (N' ') | No | | ALPFDBRVAR | Allow NULL? |
| 3 | SRTF2 | Next record counter in EXPORT/IMPORT data tables | int | 10 | 0 | INT4 | ((0)) | No | | INDX_SRTF2 | Allow NULL? |
| 4 | CREAUSER | PFDB: Changed by user name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ALPFDBUSER | Allow NULL? |
| 5 | CREADATE | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 6 | UPDTUSER | PFDB: Changed by user name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ALPFDBUSER | Allow NULL? |
| 7 | UPDTDATE | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 8 | UPDTTIME | Alert: Time value in timeformat | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALTIME | Allow NULL? |
| 9 | VERSION | Version of the dictionary objects defined for the perf. DB | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ALPFDBVERS | Allow NULL? |
| 10 | WITH_EST | PFDB: Status flag | char | 1 | 0 | CHAR | (N' ') | Yes | | ALPFDBVSTA | Allow NULL? |
| 11 | AGG_GRAN | Aggregation and Resolution of a CPH Data Record | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ALPDBRTYP | Allow NULL? |
| 12 | FIRSTDAY | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 13 | LASTDAY | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 14 | RANGEUNIT | PFDB: Status flag | char | 1 | 0 | CHAR | (N' ') | Yes | | ALPFDBVSTA | Allow NULL? |
| 15 | PASTINT | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 16 | FUTUREINT | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 17 | CLUSTR | Length field for user data in EXPORT/IMPORT tables | smallint | 5 | 0 | INT2 | ((0)) | Yes | | INDX_CLSTR | |
| 18 | CLUSTD | Data field for IMPORT/EXPORT database tables | varbinary | 2886 | 0 | LRAW | | Yes | | INDX_CLUST | |