CUSTAGR_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for CUST_AGREEMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 REIMB_AGREEMENT Character(25) VARCHAR2(25) NOT NULL Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records
5 DOCUMENT_REQUESTS Number(7,0) INTEGER NOT NULL Number of Requests
6 DOCUMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
123=Lotus 1-2-3
AVI=Video for Windows
CAD=AutoCad Document
DOC=Microsoft Winword
MPP=MicroSoft Project
NON=No Document Type
PST=PeopleSoft PeopleTools
SCR=Lotus ScreenCam
TLP=TimeLine for Windows
TXT=Notepad for ASCII Text
XLS=Microsoft Excel

Default Value: TXT

7 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
8 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
9 DOCUMENT_PATH Character(80) VARCHAR2(80) NOT NULL Application Path
10 DESCRLONG Long Character CLOB Long Description
11 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code