BI_CHARGE_EF_VW

(SQL View)
 Index Back

Billing Charge Id Eff. View

Billing Charge Id Effective View

SELECT A.SETID , A.BI_CURRENCY_CD , A.CHARGE_ID , A.EFFDT , A.EFF_STATUS , A.DESCR , A.UNIT_OF_MEASURE , A.LIST_PRICE , A.DESCR254 , A.DST_ID , A.REV_RECOG_BASIS , A.TAX_GROUP , A.TAX_TRANS_TYPE , A.TAX_TRANS_SUB_TYPE , A.PHYSICAL_NATURE , A.VAT_SVC_PERFRM_FLG FROM PS_BI_CHARGE A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BI_CHARGE WHERE SETID=A.SETID AND CHARGE_ID=A.CHARGE_ID AND BI_CURRENCY_CD = A.BI_CURRENCY_CD AND EFFDT <= %CurrentDateIn) AND A.EFF_STATUS='A'

  • Related Language Record: BI_CHARGE_LANG

    • # 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 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

    Default Value: OPR_DEF_TBL_BI.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    3 CHARGE_ID Character(18) VARCHAR2(18) NOT NULL Billing Charge ID
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    8 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    10 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

    Prompt Table: DST_CODE_REV_VW

    11 REV_RECOG_BASIS Character(3) VARCHAR2(3) NOT NULL Revenue Recognition Basis
    CHG=From/To Date Range
    CON=Contract Date
    INV=Invoice Date
    ORD=Order Date
    SHP=Ship Date
    STE=Start/End Date Range
    UD1=User Date 1
    UD2=User Date 2

    Default Value: INV

    12 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

    Prompt Table: BI_TAX_GROUP

    13 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return

    Default Value: 1

    14 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

    Default Value: N

    15 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    16 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
    1=Ship To Location
    2=Ship From Location
    3=Buyer's Location
    4=Supplier's Location