SDK_BUS_EXP_DTL

index back

SDK Business Expense Details

SDK Business Expense Details

  • Parent record: SDK_BUS_EXP_PER
  • PeopleSoft Field NameField TypeColumn TypeDescription
    SDK_EMPLIDCharacter(11)VARCHAR2(11) NOT NULLSDK Employee ID

    Prompt Table: SDK_PERS_DATA

    SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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_SYNCTIMESTAMPDateTime(26)TIMESTAMPSDK Synchronization Timestamp
    SDK_EXP_PER_DTDate(10)DATE NOT NULLSDK Expense Period Date

    Default: %date

    SDK_CHARGE_DTDate(10)DATE NOT NULLSDK Charge Date
    SDK_EXPENSE_CDCharacter(2)VARCHAR2(2) NOT NULLSDK 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_AMTSigned Number(20,3)DECIMAL(18,3) NOT NULLSDK Expense Amount
    SDK_CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLSDK Currency Code

    Default: USD

    Prompt Table: SDK_CURR_CD_TBL

    SDK_BUS_PURPOSECharacter(20)VARCHAR2(20) NOT NULLSDK Business Purpose
    SDK_DEPTIDCharacter(10)VARCHAR2(10) NOT NULLSDK Department ID

    Prompt Table: SDK_DEPT_TBL_VW

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