EXT_ORG_IDPrompt Table: EXT_ORG_TBL
ORG_LOCATIONADDRESS_TYPEPrompt Table: SAD_ADDR_TP_NLD
Y/N Table Edit
SAD_BPV_OLT_NLD(SQL Table) |
Index Back |
|---|---|
Main Address TypeMain Address Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | ORG_LOCATION |
Number(3,0) | SMALLINT NOT NULL | Location Nbr |
| 3 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: SAD_ADDR_TP_NLD |
| 4 | SAD_ADDR_PRI_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Main address
Y/N Table Edit |