BI_LINE_CTAX_VW

(SQL View)
 Index Back

Bill Line Tax Fields View


SELECT business_unit ,invoice ,line_seq_num ,prior_adj_invoice ,tax_cd ,identifier ,qty ,unit_amt ,UNIT_OF_MEASURE ,net_extended_amt ,net_extended_bse ,gross_extended_amt ,gross_extended_bse ,tot_line_dst_amt ,tot_line_dst_bse ,tot_line_dfr_amt ,tot_line_dfr_bse ,tot_discount_amt ,tot_discount_bse ,tot_surcharge_amt ,tot_surcharge_bse ,bi_currency_cd ,base_currency ,system_source ,business_unit_om ,ship_to_cust_id ,ship_to_addr_num ,ship_from_bu ,SHIP_DATE ,tax_exempt_flg ,tax_exempt_cert ,tax_amt ,tax_amt_bse ,tax_pct ,adj_line_type ,vat_amt ,vat_basis_amt ,vat_trans_amt ,tax_cd_vat ,tax_cd_vat_pct ,tax_vat_flg , VAT_RVRSE_CHG_GDS , TAX_CD_VAT_RVC , TAX_CD_VAT_RVC_PCT , VAT_AMT_RVC ,exd_invoice_no ,exd_appl_flg ,stx_appl_flg ,inv_item_id ,qty_base ,exd_assess_value ,exd_uom ,exd_conversion_rt ,exd_use_av_flg ,exd_tax_rate_cd ,stx_tax_rate_cd ,exs_currency_rptg ,exd_tax_amt ,exd_tax_amt_bse ,exd_tax_amt_rpt ,stx_tax_amt ,stx_tax_amt_bse ,stx_tax_amt_rpt ,error_status_bi ,last_update_dttm ,last_maint_oprid ,original_invoice ,max_tax_flg ,start_dt ,end_dt ,freight_terms , line_type ,bi_tax_timing ,final_tax_flg ,vat_advpay_flg 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
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 PRIOR_ADJ_INVOICE Character(22) VARCHAR2(22) NOT NULL Adjusted Invoice
5 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
6 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
7 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
8 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
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 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
11 NET_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount
12 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
13 GROSS_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
14 TOT_LINE_DST_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Dist Amount
15 TOT_LINE_DST_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Dist Amount
16 TOT_LINE_DFR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Deferred Amount
17 TOT_LINE_DFR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Contract Liability Amt
18 TOT_DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amt
19 TOT_DISCOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Discount Amount
20 TOT_SURCHARGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amt
21 TOT_SURCHARGE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amount
22 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
23 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. "
24 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
25 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
26 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
27 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num
28 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
29 SHIP_DATE Date(10) DATE Item Shipping Date
30 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
31 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
32 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
33 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)
34 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent
35 ADJ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Line Type
ACR=Adjustment Credit Line
ADJ=Adjustment
ARB=Adjustment Rebill Line
REG=Regular bill line (not adjust)
36 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.
37 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.
38 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
39 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.
40 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.
41 TAX_VAT_FLG Character(1) VARCHAR2(1) NOT NULL Include VAT
N=No
Y=Yes
42 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag

Y/N Table Edit

43 TAX_CD_VAT_RVC Character(8) VARCHAR2(8) NOT NULL Reverse Charge VAT Code
44 TAX_CD_VAT_RVC_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Customer VAT Rate
45 VAT_AMT_RVC Signed Number(28,3) DECIMAL(26,3) NOT NULL Reverse Charge VAT Amount
46 EXD_INVOICE_NO Character(10) VARCHAR2(10) NOT NULL Excise Invoice Number
47 EXD_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
48 STX_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Sales Tax Applicability.
49 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
50 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
51 EXD_ASSESS_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Assessable Value
52 EXD_UOM Character(3) VARCHAR2(3) NOT NULL Excise Unit Of Measure
53 EXD_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
54 EXD_USE_AV_FLG Character(1) VARCHAR2(1) NOT NULL Excise Use Av Flag
55 EXD_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Excise Tax Calculation Code
56 STX_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Sales Tax Calculation Code
57 EXS_CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Excise Currency Reporting
58 EXD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Tax Amount
59 EXD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty in Base Currency
60 EXD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty Amt In Rpt Curr
61 STX_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
62 STX_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN BASE CURR
63 STX_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN REPORT CURR
64 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status
65 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.
66 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
67 ORIGINAL_INVOICE Character(22) VARCHAR2(22) NOT NULL Original Invoice
68 MAX_TAX_FLG Character(1) VARCHAR2(1) NOT NULL max_tax_flg = 'Y' implies that max taxes were applied
69 START_DT Date(10) DATE Start Date
70 END_DT Date(10) DATE End Date
71 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
72 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
73 BI_TAX_TIMING Character(1) VARCHAR2(1) NOT NULL BI Tax Timing
S=Tax on Services Rendered
74 FINAL_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Final Tax Flag
75 VAT_ADVPAY_FLG Character(1) VARCHAR2(1) NOT NULL VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments