SDK_BUS_EXP_DTL

index back

SDK Business Expense Details

SDK Business Expense Details

  • Parent record: SDK_BUS_EXP_PER
  • PeopleSoft Field Name Field Type Column Type Description
    SDK_EMPLID Character(11) VARCHAR2(11) NOT NULL SDK Employee ID

    Prompt Table: SDK_PERS_DATA

    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.
    SDK_SYNCTIMESTAMP DateTime(26) TIMESTAMP SDK Synchronization Timestamp
    SDK_EXP_PER_DT Date(10) DATE NOT NULL SDK Expense Period Date

    Default: %date

    SDK_CHARGE_DT Date(10) DATE NOT NULL SDK Charge Date
    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
    SDK_EXPENSE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL SDK Expense Amount
    SDK_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL SDK Currency Code

    Default: USD

    Prompt Table: SDK_CURR_CD_TBL

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

    Prompt Table: SDK_DEPT_TBL_VW

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19