CS_DOC_PURH_SVW

(SQL View)
 Index Back

Purchase Order Header VW

New PO record for PTSF 11/2015 - add CNTRCT_STYLE for master/group/special contracts

SELECT DISTINCT '0008' ,PO.CS_DOC_ID ,PO.BUSINESS_UNIT ,PO.PO_ID ,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.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 ,POHDR.VENDOR_SETID , POHDR.VENDOR_ID , V.NAME1 ,V.VENDOR_NAME_SHORT ,V.SES_VN_ATTR_L_DTTM , POHDR.PO_TYPE , POHDR.PO_STATUS , POHDR.OPRID_APPROVED_BY , POHDR.APPROVAL_DT , POHDR.PO_REF , POHDR.PO_DT , POHDR.CURRENCY_CD , POHDR.BUYER_ID , POHDR.HOLD_STATUS , POHDR.BUDGET_CHECK , POHDR.ACTIVITY_DATE , TMP.AMT_OPEN , CASE WHEN %Coalesce(TMPDTE.DTTM_MODIFIED, %datetimein('1900-01-01-00.00.00.000000')) > %Coalesce(TMPDTE.DTTM_MODIFIED_SES, %datetimein('1900-01-01-00.00.00.000000')) 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 ,%subrec(PUR_USR_HDR_SBR, POHDR) FROM PS_CS_DOC_PUR_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_PO_HDR POHDR ,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.BUSINESS_UNIT = POHDR.BUSINESS_UNIT AND PO.PO_ID = POHDR.PO_ID AND POHDR.VENDOR_SETID = V.SETID AND POHDR.VENDOR_ID = V.VENDOR_ID

  • Related Language Record: CS_DOC_PURH_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_BU_PM_OPRVW

    4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    6 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
    7 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

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

    Prompt Table: PSOPRDEFN_VW

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

    Prompt Table: PSOPRDEFN_VW

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

    Prompt Table: CS_DEPTID_VW

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

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: CS_TEMPLATE_DVW

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

    Prompt Table: CS_TEMPLATE_DVW

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

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

    Default Value: 0:0

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

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

    Default Value: 1/1/1900 0:0

    37 EXECUTED_DTTM DateTime(26) TIMESTAMP Executed On
    38 CS_COMPLETED_DTTM DateTime(26) TIMESTAMP Completed Datetime
    39 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    45 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: %EDITTABLE18

    46 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    47 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    48 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

    49 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
    GEN=General
    KAN=Kanban

    Default Value: GEN

    Prompt Table: %EDITTABLE30

    50 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
    A=Approved
    C=Complete
    D=Dispatched
    DA=Denied
    I=Initial
    LD=Line Denied
    O=Open
    PA=Pending Approval/Approved
    PX=Pending Cancel
    X=Canceled

    Default Value: I

    51 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
    52 APPROVAL_DT Date(10) DATE Date of Approval
    53 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    54 PO_DT Date(10) DATE NOT NULL Date

    Default Value: %date

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

    Default Value: CNTRCT_CONTROL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: BUYER_ACTIVE_VW

    57 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
    58 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
    N=No
    Y=Yes
    59 ACTIVITY_DATE Date(10) DATE Last Activity
    60 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
    61 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    62 CS_INT_SIGN_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Signature Status
    NR=Not Required
    PS=Pending Signatures
    SS=Signed

    Default Value: NR

    63 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

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

    Y/N Table Edit

    Default Value: N

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