ANET_DOCKEY_REG(SQL Table) |
Index Back |
---|---|
Document Types ReferenceA table holding the information about the Touch Point Document Types of OAG Standards used by PIP SAP. This table is populated with seed data. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ANET_DOCTYP_KEY_ID | Character(15) | VARCHAR2(15) NOT NULL | Document Type Key ID for Document Keys |
2 | ANET_DOC_KEY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Document key Name |
3 | ANET_DOC_KEY_DESC | Character(250) | VARCHAR2(250) NOT NULL | Document key Description |
4 | ANET_KEYORGRF_PATH | Character(250) | VARCHAR2(250) NOT NULL | Document Key Original Reference Path |
5 | ANET_KEYEXTRF_PATH | Character(250) | VARCHAR2(250) NOT NULL | Document Key External Reference Path |
6 | ANET_SUB_KEY | Character(1) | VARCHAR2(1) NOT NULL | Sub Object Key |
7 | ANET_MASTER_KEY | Character(50) | VARCHAR2(50) NOT NULL | Primary Key |
8 | ANET_PARENT | Character(50) | VARCHAR2(50) NOT NULL | Parent |
9 | ANET_LOOKUP | Character(50) | VARCHAR2(50) NOT NULL | Lookup |
10 | ANET_MASTER | Character(1) | VARCHAR2(1) NOT NULL | Primary Data Value |
11 | ANET_TOPT_ID | Character(15) | VARCHAR2(15) NOT NULL | Touch point id |
12 | ANET_DOCTYPE_ID | Character(15) | VARCHAR2(15) NOT NULL | Document type ID |