CUST_AGREEMENT

(SQL Table)
 Index Back

Cust Agreement Table

Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Replaced CONTRACT_NUM with REIMB_AGREEMENT

  • Related Language Record: CUST_AGRMNT_LNG

  • Parent record: CUSTOMER

    • # 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 DOCUMENT_REQUESTS Number(7,0) INTEGER NOT NULL Number of Requests
    5 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
    6 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    7 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
    8 DOCUMENT_PATH Character(80) VARCHAR2(80) NOT NULL Application Path
    9 DESCRLONG Long Character CLOB Long Description