POS_FIELD_TYPE

(SQL Table)
 Index Back

Position Field Type Table

Define aliases for fieldnames

  • Related Language Record: POS_FIELD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym

    Prompt Table: POS_FIELD_VW

    2 POS_FIELD_TYPE Character(2) VARCHAR2(2) NOT NULL "The type of data field (character
    01=Business Date
    02=Business Unit
    03=Amount
    04=Bank SetID
    05=Currency Code
    06=Bank Code
    07=Source Business Unit
    08=Bank Account
    09=Reference ID
    10=Other
    11=Facility ID
    12=Bank Account Key
    13=Payment Method
    14=WorkSheetID

    Default Value: 10

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROMPT_METHOD Character(2) VARCHAR2(2) NOT NULL Represents the data source for purposes of on-line F4 prompting when constructing position data sources.
    01=Record
    02=Translate
    03=None

    Default Value: 01

    5 FIELD_PROMPT Character(15) VARCHAR2(15) NOT NULL Record Prompt

    Prompt Table: RECDEFN_VW

    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: FIELD_W_XLAT_VW

    7 META_FIELD Character(2) VARCHAR2(2) NOT NULL Allows the user to create a specialized data variable that can be utilized in building a position data source.

    Y/N Table Edit

    Default Value: N

    8 META_TEXT Character(250) VARCHAR2(250) NOT NULL The specific SQL text utilized in order to create a specialized data variable that can be utilized in building a