BI_CHARGE

(SQL Table)
 Index Back

Billing Charge Id Table

Billing Charge Id Table

  • 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

    Default Value: G

    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
    17 VAT_GROUP Character(10) VARCHAR2(10) NOT NULL VAT Group

    Prompt Table: BI_VAT_GROUP

    18 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    19 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    20 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID