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 | 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 | Master 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 | Master 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 |