| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /XFT/EPA_APL_001 | Header table applicant file | 5 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
2 | /XFT/EPA_APL_002 | Header table application file | 7 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
3 | /XFT/EPA_RECBOHD | Header table BOR file | 6 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
4 | /XFT/EPA_RECHEAD | Property extension: File header | 5 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
5 | /XFT/EPA_RECPOS | Property extension: File nodes ArchiveLink documents | 11 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
6 | /XFT/SRMNOTE01 | Continuous Note | 2 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
7 | /XFT/SRMNOTE01T | Continuous Note | 3 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
8 | /XFT/SRM_REC02 | Record: Header | 7 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
9 | /XFT/SRM_REC05 | Record Node: Header | 23 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
10 | /XFT/SRM_RECT02 | Template: Header | 7 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
11 | /XFT/SRM_RECT05 | Template Node: Header | 23 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
12 | HRMSS_D_NOTES | Notes in ESS/MSS | 2 | NOTE_ID | | nvarchar | 30 | 0 | | |
13 | LWM_RS_NOTE_ACTN | Actions on notes | 2 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
14 | SRA012_NOTE_ACTN | Actions on notes | 2 | NOTE_ID | Note ID | nvarchar | 34 | 0 | | |
15 | TOBJ_CHK_CTRL_DH | Scenario for Switchable Authorization Check (Design Phase) | 3 | NOTE_ID | SAP Note Number | nvarchar | 10 | 0 | | |
16 | PIQDBAUDF_ATTR1 | Requirement Profile Attributes: Note | 4 | NOTE_ID | GUID - Unique Note Identifier | nvarchar | 32 | 0 | | |
TOPBack Office |
17 | TRST_RECON_POS | Reconciliation Positions | 15 | NOTE_ID | Note Id | varbinary | 16 | 0 | | |
18 | TRST_RECON_RCE | Treasury: External Securities Account Statement | 25 | NOTE_ID | Note Id | varbinary | 16 | 0 | | |
TOPClinical System |
19 | N2GL_ACT_NOTE | Pathways: Comment on Activity | 3 | NOTE_ID | pathways Key of Note | nvarchar | 32 | 0 | | |
TOPGeneral |
20 | LWMHR_D_MYM_NOTE | Notes of HR Business Partner | 3 | NOTE_ID | Meet My Manager: Identifier for a Note | nvarchar | 40 | 0 | | |
TOPImplementation Guide |
21 | TNOTATW | Note: Attribute table | 1 | NOTE_ID | Unique ID for notes | nvarchar | 32 | 0 | | |
22 | TNOTESAV | Note document temporary save | 9 | NOTE_ID | Unique ID for notes | nvarchar | 32 | 0 | | |
23 | TNOTFTW | Test Workbench status: Connection to test package | 3 | NOTE_ID | Unique ID for notes | nvarchar | 32 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
24 | DFMCA_NOTE_ATT | Note Attributes for Process Objects | 2 | NOTE_ID | Name | nvarchar | 70 | 0 | | |