BI_LN_DPV_EC_VW

(SQL View)
 Index Back

BI Line...

BI Line Deposit Applied and Payment with Corp Voucher Data View

SELECT BUSINESS_UNIT , INVOICE , LINE_SEQ_NUM , INVOICE_LINE , CHARGE_FROM_DT , CHARGE_TO_DT , IDENTIFIER , DESCR , UNIT_OF_MEASURE , QTY , UNIT_AMT , GROSS_EXTENDED_AMT , gross_extended_xeu , NET_EXTENDED_AMT , net_extended_xeu , TOT_DISCOUNT_AMT , tot_discount_xeu , TOT_SURCHARGE_AMT , tot_surcharge_xeu , TAX_AMT , tax_amt_xeu , TAX_PCT , TAX_CD , TAX_EXEMPT_CERT , TAX_EXEMPT_FLG , PO_REF , PO_LINE , CONTRACT_NUM , CONTRACT_DT , CONTRACT_TYPE , bi_currency_cd , currency_cd_xeu , vat_amt , vat_amt_xeu , tax_cd_vat , tax_cd_vat_pct , vat_applicability , vat_basis_amt , vat_basis_amt_xeu , line_type , business_unit_om , cust_deposit_id FROM PS_BI_LINE WHERE LINE_TYPE IN ('DAPP','PYCV')

# 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 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
5 CHARGE_FROM_DT Date(10) DATE From Date for line charges
6 CHARGE_TO_DT Date(10) DATE Through date for charges
7 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
11 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
12 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
13 GROSS_EXTENDED_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
14 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
15 NET_EXTENDED_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount
16 TOT_DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amt
17 TOT_DISCOUNT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Discount Amount
18 TOT_SURCHARGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amt
19 TOT_SURCHARGE_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amount
20 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
21 TAX_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount - Euro
22 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent
23 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
24 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
25 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
26 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
27 PO_LINE Number(3,0) SMALLINT NOT NULL Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
28 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
29 CONTRACT_DT Date(10) DATE Contract Date
30 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
31 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
32 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency
33 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.
34 VAT_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amount - Euro Currency
35 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
36 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
37 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
38 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
39 VAT_BASIS_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amount in Euro Curr
40 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
41 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
42 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID