GP_PINMAP_EFFDT(SQL Table) |
Index Back |
|---|---|
Pin Map For PackagingPin Map Used by Packaging Utility |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT | Date(10) | DATE | Effective Date |
| 2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | PIN_MBR_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 4 | FLDMAP_RECNUM_KEY | Number(9,0) | DECIMAL(9) NOT NULL | Record # identifier Key |
| 5 | FLDMAP_FLDNUM_KEY1 | Number(9,0) | DECIMAL(9) NOT NULL | Field Number Key Identifier 1 |
| 6 | FLDMAP_FLDNUM_KEY2 | Number(9,0) | DECIMAL(9) NOT NULL | Field Number Key Identifier 2 |