EXT_ORG_IDPrompt Table: EXT_ORG_TBL
ORG_LOCATIONY/N Table Edit
Prompt Table: SAD_BPV_OTYP_VW
SAD_BPV_LOC_NLD(SQL Table) |
Index Back |
|---|---|
BPV Organisatie LocatiesFS 03052004 |
| # | 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 | SAD_ADDR_PRI_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Main address
Y/N Table Edit |
| 4 | SAD_BPV_OTYPE_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Organization type
Prompt Table: SAD_BPV_OTYP_VW |
| 5 | SAD_DEBNR_FZ_NLD | Character(20) | VARCHAR2(20) NOT NULL | Customer nbr FZ |
| 6 | SAD_KC_RELNR_NLD | Character(20) | VARCHAR2(20) NOT NULL | Relation nbr knowledge centre |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |