CUST_AGR_FUND (SQL Table)	Index Back
Cust Agreement Table Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created record from PS7.52 and replaced CONTRACT_NUM with REIMB_AGREEMENT 03/21/03 JJM 8.9 SqlVal Change length of FUND_ATTRIB_VALUE field

CUST_AGR_FUND

(SQL Table)

Cust Agreement Table

Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created record from PS7.52 and replaced CONTRACT_NUM with REIMB_AGREEMENT 03/21/03 JJM 8.9 SqlVal Change length of FUND_ATTRIB_VALUE field

Parent record: CUST_AGREEMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 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.
Prompt Table: CUSTOMER

3 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

4 FUND_ATTRIB_VALUE Character(20) VARCHAR2(20) NOT NULL Fund Attribute Value
Prompt Table: CUST_FU_A_VL_VW
Set Control Field: SETID_WRK

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

7 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

8 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
Prompt Table: SP_SI_FUA_NONVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	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. Prompt Table: CUSTOMER
3	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
4	FUND_ATTRIB_VALUE	Character(20)	VARCHAR2(20) NOT NULL	Fund Attribute Value Prompt Table: CUST_FU_A_VL_VW Set Control Field: SETID_WRK
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
7	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
8	SETID1	Character(5)	VARCHAR2(5) NOT NULL	SetID Value Prompt Table: SP_SI_FUA_NONVW