CS_DOC_CNTH_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 PO002 Manufacturer Contract.

SELECT DISTINCT '0008' ,PO.CS_DOC_ID ,PO.SETID ,PO.CNTRCT_ID , PO.VERSION_NBR ,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 ,CNT.CNTRCT_BEGIN_DT ,CNT.CNTRCT_EXPIRE_DT , 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.DATETIME_DISPATCH , H.EXECUTED_DTTM , H.CS_COMPLETED_DTTM ,H.LAST_MODIFIED_DATE ,H.LASTUPDOPRID ,H.BUSINESS_UNIT_REQ ,H.REQ_ID ,H.CS_REQ_LOCATION ,CNT.VENDOR_SETID ,CNT.VENDOR_ID ,V.NAME1 ,V.VENDOR_NAME_SHORT ,V.SES_VN_ATTR_L_DTTM ,CNT.CNTRCT_STATUS ,CNT.OPRID_APPROVED_BY , CNT.APPROVAL_DT ,R.AMT_RELSD_OPEN_ITM ,CNT.AMT_RELSD_OITM_CUM ,CNT.CNTRCT_TYPE ,CNT.DESCR ,CNT.CURRENCY_CD ,CNT.BUYER_ID ,CNT.CNTRCT_PROC_OPT ,CNT.MSTR_CNTRCT_ID ,CNT.ALLOW_OPEN_ITEM ,TMP.AMT_REMAINING ,TMP.AMT_CNTRCT_MAX ,%Coalesce(TMPDTE.DTTM_MODIFIED, %datetimein('1900-01-01-00.00.00.000000')) ,H.CS_INT_SIGN_STATUS ,H.CS_EXT_SIGN_STATUS ,H.CS_ROUTE_SIGN_FLG ,CNT.CONTROL_TYPE ,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 ,%subrec(PUR_USR_HDR_SBR, CNT) FROM PS_CS_DOC_PO_KEYS PO ,(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_HDR_SES TMP ,PS_CS_DOC_DATE_SES TMPDTE ,PS_CNTRCT_HDR CNT ,PS_CNTRCT_HDR_RLS R ,PS_VENDOR V WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND H.CS_DOC_ID = TMP.CS_DOC_ID AND H.CS_DOC_ID = TMPDTE.CS_DOC_ID AND PO.SETID = CNT.SETID AND PO.CNTRCT_ID = CNT.CNTRCT_ID AND PO.VERSION_NBR = CNT.VERSION_NBR AND R.SETID = CNT.SETID AND R.CNTRCT_ID = CNT.CNTRCT_ID AND CNT.VENDOR_SETID = V.SETID AND CNT.VENDOR_ID = V.VENDOR_ID

  • Related Language Record: CS_DOC_CNTH_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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    5 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    7 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
    8 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

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

    Prompt Table: PSOPRDEFN_VW

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

    Prompt Table: PSOPRDEFN_VW

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

    Prompt Table: CS_DEPTID_VW

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

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: CS_TEMPLATE_DVW

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

    Prompt Table: CS_TEMPLATE_DVW

    18 CS_VERSION Number(6,2) DECIMAL(5,2) NOT NULL Version
    19 CS_AMENDMENT Number(3,0) SMALLINT NOT NULL Amendment
    20 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

    21 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
    22 CS_TRANKEY_REC Character(15) VARCHAR2(15) NOT NULL Source Key Record
    23 CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Close Contract Flag
    24 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    25 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    26 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

    Default Value: 0:0

    27 SES_DOCUMENT_DATE Date(10) DATE Document Date
    28 SES_YEAR Character(4) VARCHAR2(4) NOT NULL Document Date Hierarchy
    29 SES_DAY Character(2) VARCHAR2(2) NOT NULL Day
    30 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
    31 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
    32 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    33 DATETIME_CHECKOUT DateTime(26) TIMESTAMP Checked Out On
    34 CHECKED_OUT_BY Character(30) VARCHAR2(30) NOT NULL Checked Out By
    35 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
    36 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

    37 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0

    Default Value: 1/1/1900 0:0

    38 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
    39 CS_COMPLETED_DTTM DateTime(26) TIMESTAMP Completed Datetime
    40 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date

    Default Value: 1/1/1900 0:0

    41 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.
    42 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit

    Prompt Table: SP_BU_PM_OPRVW

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

    Prompt Table: CS_REQ_ID_VW

    44 CS_REQ_LOCATION Character(1) VARCHAR2(1) NOT NULL Requisition Transaction
    C=Core
    E=ePro
    45 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    46 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: %EDITTABLE18

    47 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    48 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    49 SES_VN_ATTR_L_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTime specific for vendor attributes such as vendor name, vendor location, vendor phone and vendor contact.

    Default Value: %DATETIME

    50 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
    A=Approved
    C=Closed
    H=On-Hold
    O=Open
    P=Pre-Approved
    X=Canceled

    Default Value: O

    51 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
    52 APPROVAL_DT Date(10) DATE Date of Approval
    53 AMT_RELSD_OPEN_ITM Signed Number(28,3) DECIMAL(26,3) NOT NULL Amt relsd for Open Item
    54 AMT_RELSD_OITM_CUM Number(27,3) DECIMAL(26,3) NOT NULL Cumulative Relsd for Open Item
    55 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
    AP=Recurring Voucher
    GN=General Contract
    MS=Master Contract
    PO=Purchase Order

    Default Value: GN

    56 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    57 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CNTRCT_CONTROL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: BUYER_ACTIVE_VW

    59 CNTRCT_PROC_OPT Character(4) VARCHAR2(4) NOT NULL Contract Process Option
    AP=Recurring Voucher
    BPO=Release to Single PO Only
    DST=Distributor
    GN=General Contract
    GRPM=Group Multi Supplier
    GRPS=Group Single Supplier
    MFG=Manufacturer
    PADV=Prepaid Voucher w/ Advance PO
    PO=Purchase Order
    PPAY=Prepaid Voucher
    RPOV=Recurring PO Voucher
    SPP=Special Purpose

    Default Value: GN

    60 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID

    Prompt Table: CNTRCT_MSTR_VW

    61 ALLOW_OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Allow Open Item Reference
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    62 AMT_REMAINING Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount
    63 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.
    64 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    65 CS_INT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Signature Status
    NR=Not Required
    PS=Pending Signatures
    SS=Signed

    Default Value: NR

    66 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

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

    Y/N Table Edit

    Default Value: N

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