CA_NLNK_DTL_VW

(SQL View)
 Index Back

SELECT CONTRACT_NUM ,CONTRACT_LINE_NUM ,DESCR ,SHIP_TO_CUST_ID ,ADDR_SEQ_NUM_SHIP ,SHIP_FROM_LOC ,TAX_EXEMPT_FLG ,TAX_EXEMPT_CERT ,TAX_GROUP ,TAX_CD ,TAX_TRANS_TYPE ,TAX_TRANS_SUB_TYPE ,PHYSICAL_NATURE ,BILL_PLAN_ID ,'N' ,PRODUCT_ID FROM PS_CA_DETAIL WHERE BPLAN_LN_NBR = 0

  • Related Language Record: CA_NLKDTL_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_CONTR_HDR

    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

    Prompt Table: BI_SHIP_TO_VW
    Set Control Field: BUSINESS_UNIT_BI

    5 ADDR_SEQ_NUM_SHIP Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: CA_CUST_SHIP_VW

    6 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

    Prompt Table: LOCATION_TBL
    Set Control Field: BUSINESS_UNIT_BI

    7 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

    Y/N Table Edit

    8 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
    9 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

    Prompt Table: PRODGP_NGTAX_VW
    Set Control Field: BUSINESS_UNIT

    10 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: CA_TAX_CD_VW
    Set Control Field: BUSINESS_UNIT_BI

    11 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    12 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
    1=Property
    2=Freight
    3=Service
    4=Rental or Lease
    5=Expense
    6=Misc
    N=None
    13 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    14 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
    15 LINKS Character(1) VARCHAR2(1) NOT NULL Links

    Y/N Table Edit

    16 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID