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.