DR_EFT_TYPE_VW

(SQL View)
Index Back

Draft Type


SELECT %subrec(DR_EFT_TYPE_VW, A) FROM PS_DRAFT_TYPE_TBL A WHERE A.DRAFT_EFT_FLG = 'Y'

  • Related Language Record: DR_EFT_TYPE_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 DRAFT_TYPE Character(10) VARCHAR2(10) NOT NULL A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).

    Prompt Table: DRAFT_TYPE_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DRAFT_INITIATOR Character(1) VARCHAR2(1) NOT NULL Draft Initiator
    C=Customer
    V=Supplier
    5 DRAFT_TXN_TYPE Character(10) VARCHAR2(10) NOT NULL Draft Transaction Type

    Prompt Table: DR_TXN_TYPE_TBL

    6 DISCOUNT_DRAFT Character(1) VARCHAR2(1) NOT NULL Discount Draft

    Y/N Table Edit

    Default Value: N

    7 DRAFT_APPROVAL Character(1) VARCHAR2(1) NOT NULL "Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
    P=Preapproved
    R=Approval Required
    8 DRAFT_DOC Character(1) VARCHAR2(1) NOT NULL "A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
    C=Create Document
    N=Do Not Create Document
    9 DRAFT_NUM_OPTION Character(1) VARCHAR2(1) NOT NULL Auto-number Draft Ref

    Y/N Table Edit

    Default Value: N

    10 DRAFT_FORMAT Character(1) VARCHAR2(1) NOT NULL "A flag that indicates whether a draft will be associated with a single item or with multiple items. This field is used only when the payment method is ""draft""."
    M=Multiple Items Per Draft
    S=Single Item Per Draft

    Default Value: M

    11 REJECT_REASON_REQD Character(1) VARCHAR2(1) NOT NULL Reject Reason Required

    Y/N Table Edit

    Default Value: Y

    12 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    13 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    14 DRAFT_EFT_FLG Character(1) VARCHAR2(1) NOT NULL EFT Draft Flag

    Y/N Table Edit

    Default Value: N

    15 DRAFT_CANCEL_FLG Character(1) VARCHAR2(1) NOT NULL Permit Remittance Cancellation

    Y/N Table Edit

    Default Value: Y

    16 DRAFT_UNPOST_FLG Character(1) VARCHAR2(1) NOT NULL Permit Unpost Draft

    Y/N Table Edit

    Default Value: Y

    17 DRAFT_VOID_FLG Character(1) VARCHAR2(1) NOT NULL Permit Void Draft

    Y/N Table Edit

    Default Value: Y