RE_LEVEL1_TMP(SQL Table) |
Index Back |
|---|---|
Temporary table for level 1Temporary table for level 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 2 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
C=C N=N Y=Y |
| 3 | UID20 | Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 4 | UID20F_SHIP | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 5 | UID20F_SHIPC | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 6 | UID20F_SITE | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 7 | UID20F_SITEC | Character(20) | VARCHAR2(20) NOT NULL | Foreign UID................................................................... |
| 8 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address type field to store address type information.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home LEGL=Legal MAIL=Mailing OTHR=Other |