CS_DOC_AUCH_SVW

(SQL View)
 Index Back

PTSF Contract Document Header

Contract Document Header view for PTSF 11/17/2015 TBG Added CNTRCT_STYLE field for Master Contracts

SELECT DISTINCT '0008' ,AUC.CS_DOC_ID ,AUC.BUSINESS_UNIT ,AUC.AUC_ID ,AUC.AUC_ROUND ,AUC.AUC_VERSION ,H.DESCR60 ,H.CS_DOC_STATUS ,H.CS_DOCUMENT_TYPE ,H.CNTRCT_STYLE ,T.CS_TMPL_TYPE ,H.CS_DOC_OWNER ,H.CS_SPONSOR ,H.DEPTID ,H.CS_SETID ,H.CS_TEMPLATE_ID ,H.CS_TEMPLATE_AMEND ,H.CS_EX_SUMM_TMPL_ID ,H.CS_VERSION ,H.CS_AMENDMENT ,H.CS_TWOFILE_AMEND ,H.CS_SOURCE_TRANS ,H.CS_TRANKEY_REC ,H.CLOSE_FLAG ,H.CNTRCT_BEGIN_DT ,H.CNTRCT_EXPIRE_DT ,H.EXECUTED_DTTM , H.CREATED_DTTM , H.CREATED_DTTM , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 1, 4) , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 9, 2) , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 6, 2) , %Substring(%Cast(H.CREATED_DTTM, DateTime, Character), 6, 2) ,H.CREATED_BY_USER ,H.DATETIME_CHECKOUT ,H.CHECKED_OUT_BY ,H.COMMENT1 ,H.APPROVAL_DTTM ,H.LAST_MODIFIED_DATE ,H.LASTUPDOPRID ,H.BUSINESS_UNIT_REQ ,H.REQ_ID ,H.CS_REQ_LOCATION ,AH.AUC_STATUS ,AH.AUC_FORMAT ,AH.AUC_TYPE ,AH.AUC_NAME ,AH.TIMEZONE ,AH.AUC_DTTM_PREVIEW ,AH.AUC_DTTM_START ,AH.AUC_DTTM_FINISH ,AH.PYMNT_TERMS_CD ,AH.CURRENCY_CD ,AH.ORIGIN ,AH.PAYMENT_METHOD ,AH.REQUESTOR_ID ,AH.BUYER_ID ,AH.NAME1 ,AH.PHONE ,AH.EMAILID ,AH.CATEGORY_ID , CASE WHEN %Coalesce(TMPDTE.DTTM_MODIFIED, %datetimein('1900-01-01-00.00.00.000000')) > TMPDTE.DTTM_MODIFIED_SES THEN TMPDTE.DTTM_MODIFIED ELSE TMPDTE.DTTM_MODIFIED_SES END ,H.CS_INT_SIGN_STATUS ,H.CS_EXT_SIGN_STATUS ,H.CS_ROUTE_SIGN_FLG ,H.CS_CHAR_USER1 ,H.CS_CHAR_USER2 ,H.CS_CHAR_USER3 ,H.CS_CHAR_USER4 ,H.CS_CHAR_USER5 ,H.CS_CHAR_USER6 ,H.CS_CHAR_USER7 ,H.CS_CHAR_USER8 ,H.CS_CHAR_USER9 ,H.CS_CHAR_USER10 ,H.CS_CHAR_USER11 ,H.CS_CHAR_USER12 ,H.CS_CHAR_USER13 ,H.CS_CHAR_USER14 ,H.CS_CHAR_USER15 ,H.CS_CHAR_USER16 ,H.CS_CHAR_USER17 ,H.CS_CHAR_USER18 ,H.CS_CHAR_USER19 ,H.CS_CHAR_USER20 ,H.CS_CHAR_USER21 ,H.CS_CHAR_USER22 ,H.CS_CHAR_USER23 ,H.CS_CHAR_USER24 ,H.CS_CHAR_USER25 ,H.CS_CHAR_USER26 ,H.CS_CHAR_USER27 ,H.CS_CHAR_USER28 ,H.CS_CHAR_USER29 ,H.CS_CHAR_USER30 ,H.CS_CHAR_USER31 ,H.CS_CHAR_USER32 ,H.CS_CHAR_USER33 ,H.CS_CHAR_USER34 ,H.CS_CHAR_USER35 ,H.CS_CHAR_USER36 ,H.CS_CHAR_USER37 ,H.CS_CHAR_USER38 ,H.CS_DATE_USER1 ,H.CS_DATE_USER2 ,H.CS_DATE_USER3 ,H.CS_DATE_USER4 ,H.CS_DATE_USER5 ,H.CS_DATE_USER6 ,H.CS_DATE_USER7 ,H.CS_DATE_USER8 ,H.CS_DATE_USER9 ,H.CS_DATE_USER10 ,H.CS_DATE_USER11 ,H.CS_DATE_USER12 ,H.CS_DATE_USER13 ,H.CS_DATE_USER14 ,H.CS_DATE_USER15 ,H.CS_DEC_USER1 ,H.CS_DEC_USER2 ,H.CS_DEC_USER3 ,H.CS_DEC_USER4 ,H.CS_DEC_USER5 ,H.CS_DEC_USER6 ,H.CS_DEC_USER7 ,H.CS_DEC_USER8 ,H.CS_DEC_USER9 ,H.CS_DEC_USER10 ,H.CS_DEC_USER11 ,H.CS_DEC_USER12 ,H.CS_DEC_USER13 ,H.CS_DEC_USER14 ,H.CS_DEC_USER15 ,H.CS_INT_USER1 ,H.CS_INT_USER2 ,H.CS_INT_USER3 ,H.CS_INT_USER4 ,H.CS_INT_USER5 ,H.CS_INT_USER6 ,H.CS_INT_USER7 ,H.CS_INT_USER8 ,H.CS_INT_USER9 ,H.CS_INT_USER10 ,H.CS_INT_USER11 ,H.CS_INT_USER12 ,H.CS_INT_USER13 ,H.CS_INT_USER14 ,H.CS_INT_USER15 ,H.CS_INT_USER16 ,H.CS_INT_USER17 ,H.CS_INT_USER18 ,H.CS_INT_USER19 ,H.CS_INT_USER20 ,H.CS_INT_USER21 ,H.CS_INT_USER22 ,H.CS_INT_USER23 ,H.CS_INT_USER24 FROM PS_CS_DOC_AUC_KEYS AUC ,(PS_CS_DOC_HDR H LEFT OUTER JOIN PS_CS_TMPL_TBL T ON H.CS_TEMPLATE_ID = T.CS_TEMPLATE_ID AND H.CS_SETID = T.SETID) ,PS_CS_DOC_DATE_SES TMPDTE ,PS_AUC_HDR AH WHERE AUC.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = TMPDTE.CS_DOC_ID AND AUC.BUSINESS_UNIT = AH.BUSINESS_UNIT AND AUC.AUC_ID = AH.AUC_ID AND AUC.AUC_ROUND = AH.AUC_ROUND AND AUC.AUC_VERSION = AH.AUC_VERSION

  • Related Language Record: CS_DOC_AUCH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
    0001=Clause
    0002=Section
    0003=Ad Hoc Clause
    0004=Rule
    0005=Bind Variables
    0006=Wizard Definition
    0007=Document Configurator
    0008=Document
    0009=Contract Agreement
    0010=Bid Factor
    0011=Contract
    0012=Sourcing Event
    0013=Question Group
    0014=Document Type
    0015=Word Template
    0016=Document Format and Options
    2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_AUC_BU_OPRVW

    4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    5 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

    Default Value: 1

    6 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

    Default Value: 1

    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    8 CS_DOC_STATUS Character(2) VARCHAR2(2) NOT NULL Document Status
    AA=Approved
    AD=Denied
    AP=Pending Approval
    CC=Collaborated
    CP=Pending Collaboration
    CR=Collaborated, Pending Review
    DC=Complete
    DR=Draft
    DS=Dispatched
    EC=Pending External Collaboration
    EX=Executed
    PI=Pending Internal Review
    9 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File

    Prompt Table: CS_DOCT_ALL_VW

    10 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    11 CS_TMPL_TYPE Character(4) VARCHAR2(4) NOT NULL SCC 09/01/04
    12 CS_DOC_OWNER Character(30) VARCHAR2(30) NOT NULL Document Administrator

    Prompt Table: PSOPRDEFN_VW

    13 CS_SPONSOR Character(30) VARCHAR2(30) NOT NULL Sponsor

    Prompt Table: PSOPRDEFN_VW

    14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: CS_DEPTID_VW

    15 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects

    Prompt Table: SP_SETID_NONVW

    16 CS_TEMPLATE_ID Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04

    Prompt Table: CS_TEMPLATE_DVW

    17 CS_TEMPLATE_AMEND Character(20) VARCHAR2(20) NOT NULL SCC 09/01/04
    18 CS_EX_SUMM_TMPL_ID Character(20) VARCHAR2(20) NOT NULL Executive Summary Configurator

    Prompt Table: CS_TEMPLATE_DVW

    19 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
    20 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
    21 CS_TWOFILE_AMEND Character(1) VARCHAR2(1) NOT NULL Amendment Option
    1=Amend Contract Only
    2=Amend Contract with Amendments
    3=Amendment Files Only

    Default Value: 1

    22 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
    01=Ad Hoc
    02=Purchasing Contracts
    03=Purchase Orders
    04=Sourcing Events
    97=All Sources
    98=Multiple Sources
    99=Not Transactional
    23 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
    24 CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Close Contract Flag
    25 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    26 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    27 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
    28 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

    Default Value: 0:0

    29 SES_DOCUMENT_DATE Date(10) DATE Document Date
    30 SES_YEAR Character(4) VARCHAR2(4) NOT NULL Document Date Hierarchy
    31 SES_DAY Character(2) VARCHAR2(2) NOT NULL Day
    32 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    33 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    34 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    35 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
    36 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
    37 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
    38 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper

    Default Value: 1/1/1900 0:0

    39 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date

    Default Value: 1/1/1900 0:0

    40 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    41 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

    Prompt Table: SP_BU_PM_OPRVW

    42 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

    Prompt Table: CS_REQ_ID_VW

    43 CS_REQ_LOCATION Character(1) VARCHAR2(1) NOT NULL Requisition Transaction
    C=Core
    E=ePro
    44 AUC_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
    A=Awarded
    C=Collaborating Event
    D=Collaborating Bid Analysis
    E=Evaluating
    F=RFI Reviewed
    I=Pending RFI Review
    N=Not Awarded
    O=Open
    P=Posted
    Q=Paused
    R=Pending Scheduled Review
    S=Pending Post Approval
    T=Pending Award
    U=Pending Award Approval
    W=Post to Third Party Failed
    X=Cancelled
    Z=Inactive Version

    Default Value: O

    45 AUC_FORMAT Character(1) VARCHAR2(1) NOT NULL Event Format
    F=Sell
    I=RFI
    R=Buy
    S=Service
    46 AUC_TYPE Character(1) VARCHAR2(1) NOT NULL Event Type
    E=Auction
    S=RFx
    47 AUC_NAME Character(50) VARCHAR2(50) NOT NULL Event Name
    48 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    49 AUC_DTTM_PREVIEW DateTime(26) TIMESTAMP Date Time Preview
    50 AUC_DTTM_START DateTime(26) TIMESTAMP NOT NULL Date Time Start
    51 AUC_DTTM_FINISH DateTime(26) TIMESTAMP NOT NULL Date Time Finish
    52 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: PYMT_TR_EFF_VW

    53 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CNTRCT_CONTROL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    54 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    55 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report
    56 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Prompt Table: RQSTR_ACTIVE_VW

    57 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: BUYER_ACTIVE_VW

    58 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    59 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    60 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    61 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    62 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    63 CS_INT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Signature Status
    NR=Not Required
    PS=Pending Signatures
    SS=Signed

    Default Value: NR

    64 CS_EXT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL External Signature Status
    NR=Not Initiated
    PS=Pending Signatures
    RJ=Declined
    SS=Signed

    Default Value: NR

    65 CS_ROUTE_SIGN_FLG Character(1) VARCHAR2(1) NOT NULL Document in Signature Loop

    Y/N Table Edit

    Default Value: N

    66 CS_CHAR_USER1 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 1
    67 CS_CHAR_USER2 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 2
    68 CS_CHAR_USER3 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 3
    69 CS_CHAR_USER4 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 4
    70 CS_CHAR_USER5 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 5
    71 CS_CHAR_USER6 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 6
    72 CS_CHAR_USER7 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 7
    73 CS_CHAR_USER8 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 8
    74 CS_CHAR_USER9 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 9
    75 CS_CHAR_USER10 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 10
    76 CS_CHAR_USER11 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 11
    77 CS_CHAR_USER12 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 12
    78 CS_CHAR_USER13 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 13
    79 CS_CHAR_USER14 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 14
    80 CS_CHAR_USER15 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 15
    81 CS_CHAR_USER16 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 16
    82 CS_CHAR_USER17 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 17
    83 CS_CHAR_USER18 Character(10) VARCHAR2(10) NOT NULL Character 10 User Field 18
    84 CS_CHAR_USER19 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 19
    85 CS_CHAR_USER20 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 20
    86 CS_CHAR_USER21 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 21
    87 CS_CHAR_USER22 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 22
    88 CS_CHAR_USER23 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 23
    89 CS_CHAR_USER24 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 24
    90 CS_CHAR_USER25 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 25
    91 CS_CHAR_USER26 Character(30) VARCHAR2(30) NOT NULL Character 30 User Field 26
    92 CS_CHAR_USER27 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 27
    93 CS_CHAR_USER28 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 28
    94 CS_CHAR_USER29 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 29
    95 CS_CHAR_USER30 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 30
    96 CS_CHAR_USER31 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 31
    97 CS_CHAR_USER32 Character(60) VARCHAR2(60) NOT NULL Character 60 User Field 32
    98 CS_CHAR_USER33 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 33
    99 CS_CHAR_USER34 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 34
    100 CS_CHAR_USER35 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 35
    101 CS_CHAR_USER36 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 36
    102 CS_CHAR_USER37 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 37
    103 CS_CHAR_USER38 Character(120) VARCHAR2(120) NOT NULL Character 120 User Field 38
    104 CS_DATE_USER1 Date(10) DATE Date User Field 1
    105 CS_DATE_USER2 Date(10) DATE Date User Field 2
    106 CS_DATE_USER3 Date(10) DATE Date User Field 3
    107 CS_DATE_USER4 Date(10) DATE Date User Field 4
    108 CS_DATE_USER5 Date(10) DATE Date User Field 5
    109 CS_DATE_USER6 Date(10) DATE Date User Field 6
    110 CS_DATE_USER7 Date(10) DATE Date User Field 7
    111 CS_DATE_USER8 Date(10) DATE Date User Field 8
    112 CS_DATE_USER9 Date(10) DATE Date User Field 9
    113 CS_DATE_USER10 Date(10) DATE Date User Field 10
    114 CS_DATE_USER11 Date(10) DATE Date User Field 11
    115 CS_DATE_USER12 Date(10) DATE Date User Field 12
    116 CS_DATE_USER13 Date(10) DATE Date User Field 13
    117 CS_DATE_USER14 Date(10) DATE Date User Field 14
    118 CS_DATE_USER15 Date(10) DATE Date User Field 15
    119 CS_DEC_USER1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 1 (23.3)
    120 CS_DEC_USER2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 2 (23.3)
    121 CS_DEC_USER3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 3 (23.3)
    122 CS_DEC_USER4 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 4 (11.4)
    123 CS_DEC_USER5 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field5 (11.4)
    124 CS_DEC_USER6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 6 (23.3)
    125 CS_DEC_USER7 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 7 (23.3)
    126 CS_DEC_USER8 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 8 (23.3)
    127 CS_DEC_USER9 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 9 (23.3)
    128 CS_DEC_USER10 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 10 (23.3)
    129 CS_DEC_USER11 Signed Number(28,3) DECIMAL(26,3) NOT NULL Decimal User Field 11 (23.3)
    130 CS_DEC_USER12 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 12 (11.4)
    131 CS_DEC_USER13 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 13 (11.4)
    132 CS_DEC_USER14 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 14 (11.4)
    133 CS_DEC_USER15 Signed Number(17,4) DECIMAL(15,4) NOT NULL Decimal User Field 15 (11.4)
    134 CS_INT_USER1 Number(8,0) INTEGER NOT NULL Integer User Field 1
    135 CS_INT_USER2 Number(8,0) INTEGER NOT NULL Integer User Field 2
    136 CS_INT_USER3 Number(8,0) INTEGER NOT NULL Integer User Field 3
    137 CS_INT_USER4 Number(8,0) INTEGER NOT NULL Integer User Field 4
    138 CS_INT_USER5 Number(8,0) INTEGER NOT NULL Integer User Field 5
    139 CS_INT_USER6 Number(8,0) INTEGER NOT NULL Integer User Field 6
    140 CS_INT_USER7 Number(8,0) INTEGER NOT NULL Integer User Field 7
    141 CS_INT_USER8 Number(8,0) INTEGER NOT NULL Integer User Field 8
    142 CS_INT_USER9 Number(8,0) INTEGER NOT NULL Integer User Field 9
    143 CS_INT_USER10 Number(8,0) INTEGER NOT NULL Integer User Field 10
    144 CS_INT_USER11 Number(8,0) INTEGER NOT NULL Integer User Field 11
    145 CS_INT_USER12 Number(8,0) INTEGER NOT NULL Integer User Field 12
    146 CS_INT_USER13 Number(8,0) INTEGER NOT NULL Integer User Field 13
    147 CS_INT_USER14 Number(8,0) INTEGER NOT NULL Integer User Field 14
    148 CS_INT_USER15 Number(8,0) INTEGER NOT NULL Integer User Field 15
    149 CS_INT_USER16 Number(8,0) INTEGER NOT NULL Integer User Field 16
    150 CS_INT_USER17 Number(8,0) INTEGER NOT NULL Integer User Field 17
    151 CS_INT_USER18 Number(8,0) INTEGER NOT NULL Integer User Field 18
    152 CS_INT_USER19 Number(8,0) INTEGER NOT NULL Integer User Field 19
    153 CS_INT_USER20 Number(8,0) INTEGER NOT NULL Integer User Field 20
    154 CS_INT_USER21 Number(8,0) INTEGER NOT NULL Integer User Field 21
    155 CS_INT_USER22 Number(8,0) INTEGER NOT NULL Integer User Field 22
    156 CS_INT_USER23 Number(8,0) INTEGER NOT NULL Integer User Field 23
    157 CS_INT_USER24 Number(8,0) INTEGER NOT NULL Integer User Field 24