BI_IM_LINES_VW

(SQL View)
 Index Back

Billing Line View

View of regular and rebill bill lines used in Invoice Maintenance.

SELECT A.BUSINESS_UNIT , A.INVOICE , A.LINE_SEQ_NUM , A.LINE_TYPE , A.IDENTIFIER , A.NET_EXTENDED_AMT , A.BI_CURRENCY_CD , A.DESCR , %subrec(PC_CF1_N_SBR, A) , ' ' , ' ' , ' ' FROM PS_BI_LINE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
5 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
6 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
7 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

10 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

11 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

12 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

13 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

14 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

15 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

16 RES_TYPE_NEW Character(5) VARCHAR2(5) NOT NULL RESOURCE_TYPE new (changed to) value.

Prompt Table: PROJ_RES_TYPE

17 RES_CATEGORY_NEW Character(5) VARCHAR2(5) NOT NULL RESOURCE_CATEGORY new (changed to) value.

Prompt Table: PROJ_CATG_VW

18 RES_SUB_CAT_NEW Character(5) VARCHAR2(5) NOT NULL RESOURCE_SUB_CAT new (changed to) value.

Prompt Table: PROJ_SUBCAT_VW