CUST_BLL_OPT_VW

(SQL View)
 Index Back

Bill-to Cust Options View - OM

Bill-to Cust Options View - OM

SELECT A.SETID ,A.CUST_ID ,A.EFFDT ,A.EFF_STATUS ,A.BILL_TYPE_ID ,A.PAYMENT_METHOD ,A.PYMNT_TERMS_CD ,A.FREIGHT_BILL_TYPE ,A.GRACE_DUE_DAYS ,A.GRACE_DISC_DAYS ,A.RETENTION_DAYS ,A.PP_HOLD ,A.PP_METHOD ,A.REF_QUALIFIER_CODE ,A.PO_REQUIRED ,A.CUSTOMER_PO ,A.START_DATE ,A.END_DATE ,A.DIRECT_INVOICING ,A.LAST_MAINT_OPRID ,A.DATE_LAST_MAINT FROM PS_CUST_OPTION A

  • Parent record: CUSTOMER

    • # 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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Prompt Table: CUSTOMER

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
    6 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report
    7 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: AR_TRMS_VW

    8 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
    OE=Order Entry
    SH=Shipping
    9 GRACE_DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Grace Days
    10 GRACE_DISC_DAYS Number(3,0) SMALLINT NOT NULL Discount Grace Days
    11 RETENTION_DAYS Number(3,0) SMALLINT NOT NULL Closed Item Retention Days
    12 PP_HOLD Character(1) VARCHAR2(1) NOT NULL Payment Predictor Hold

    Y/N Table Edit

    Default Value: N

    13 PP_METHOD Character(15) VARCHAR2(15) NOT NULL Payment Predictor Method

    Prompt Table: PP_MET_TBL

    14 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code

    Prompt Table: AR_FLD_REF_VW

    15 PO_REQUIRED Character(1) VARCHAR2(1) NOT NULL Purchase Order Required

    Y/N Table Edit

    Default Value: N

    16 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
    17 START_DATE Date(10) DATE Start Date for Gen Standing PO
    18 END_DATE Date(10) DATE End Date
    19 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

    Y/N Table Edit

    20 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    21 DATE_LAST_MAINT Date(10) DATE Date Last Maintained