BI_EXT_INST_SUM

(SQL Table)
Index Back

Extract - Print Installmnt Sum

Bill Extract for Printing Installmnet Sum

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 INSTALL_NBR Number(3,0) SMALLINT NOT NULL Installment Number
6 PRINT_SEQ_NBR Number(5,0) INTEGER NOT NULL Print Sequence
7 GENERATED_INVOICE Character(22) VARCHAR2(22) NOT NULL Generated Invoice
8 INVOICE_DT Date(10) DATE Invoice Date
9 TEMPLATE_INVOICE Character(22) VARCHAR2(22) NOT NULL Template Invoice ID
10 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
11 INSTALLMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Installment Amount
12 SERVICE_CHRG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Service Charge Amount
13 TOT_SU_TAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Sales/Use Tax
14 TOT_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
15 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
16 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
17 ADD_DT Date(10) DATE Customer Added On
18 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
19 TOT_VAT_RVC Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount