SDK_BUS_EXP_DTL

(SQL Table)
 Index Back

SDK Business Expense Details

SDK Business Expense Details

  • Parent record: SDK_BUS_EXP_PER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SDK_EMPLID Character(11) VARCHAR2(11) NOT NULL SDK Employee ID

    Prompt Table: SDK_PERS_DATA

    2 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    3 SDK_SYNCTIMESTAMP DateTime(26) TIMESTAMP SDK Synchronization Timestamp
    4 SDK_EXP_PER_DT Date(10) DATE NOT NULL SDK Expense Period Date

    Default Value: %date

    5 SDK_CHARGE_DT Date(10) DATE NOT NULL SDK Charge Date
    6 SDK_EXPENSE_CD Character(2) VARCHAR2(2) NOT NULL SDK Expense Code
    01=Airfare
    02=Lodging
    03=Car Rental
    04=Meals
    05=Telephone
    06=Travel
    07=Relocation
    08=Entertainment
    09=Parking
    10=Mileage
    11=Advertising
    12=Referral Fee
    13=Postage
    14=Publication
    15=Membership
    16=Miscellaneous
    17=Staff Time
    7 SDK_EXPENSE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL SDK Expense Amount
    8 SDK_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL SDK Currency Code

    Default Value: USD

    Prompt Table: SDK_CURR_CD_TBL

    9 SDK_BUS_PURPOSE Character(20) VARCHAR2(20) NOT NULL SDK Business Purpose
    10 SDK_DEPTID Character(10) VARCHAR2(10) NOT NULL SDK Department ID

    Prompt Table: SDK_DEPT_TBL_VW