AR_BI_LINE2_VW

(SQL View)
 Index Back

Bill Line Search VW


SELECT business_unit , invoice , line_seq_num , invoice_line , bi_currency_cd , base_currency , currency_cd_xeu , charge_from_dt , charge_to_dt , identifier , descr , unit_of_measure , qty , unit_amt , tax_cd , gross_extended_amt , net_extended_amt , gross_extended_bse , net_extended_bse , gross_extended_xeu , net_extended_xeu , tax_amt , tax_amt_bse , tax_amt_xeu , vat_amt , vat_amt_bse , vat_amt_xeu , tot_discount_amt , tot_surcharge_amt , tot_discount_bse , tot_surcharge_bse , tot_discount_xeu , tot_surcharge_xeu , po_ref , contract_num , contract_dt , order_no , order_date , bill_of_lading , business_unit_ca , contract_line_num FROM PS_BI_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
5 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
6 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
7 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency
8 CHARGE_FROM_DT Date(10) DATE From Date for line charges
9 CHARGE_TO_DT Date(10) DATE Through date for charges

Default Value: BI_LINE.CHARGE_FROM_DT

10 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
13 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
14 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
15 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: TAX_HEADER_TBL

16 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
17 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
18 GROSS_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
19 NET_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount
20 GROSS_EXTENDED_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
21 NET_EXTENDED_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount
22 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
23 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)
24 TAX_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount - Euro
25 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
26 VAT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amount in Base Curr
27 VAT_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amount - Euro Currency
28 TOT_DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amt
29 TOT_SURCHARGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amt
30 TOT_DISCOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Discount Amount
31 TOT_SURCHARGE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amount
32 TOT_DISCOUNT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Discount Amount
33 TOT_SURCHARGE_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amount
34 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
35 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
36 CONTRACT_DT Date(10) DATE Contract Date
37 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
38 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
39 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
40 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
41 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num