ORG_LOCATION_TS(SQL Table) |
Index Back |
---|---|
Organization TS130 Setup |
# | 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
Prompt Table: ORG_LOC_ADDR_VW |
3 | EDI_SEND_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Sending Options for EDI Transcripts.
D=Place File in Directory E=Email |
4 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
5 | TS130_EMAIL_ADDR | Character(254) | VARCHAR2(254) NOT NULL | TS130 E-Mail address. |