BI_LINE_AUX_VW

(SQL View)
 Index Back

Bill Lines Adjust Auxiliary Vw


select business_unit, invoice, adj_aux_line_seq, bi_currency_cd, base_currency, invoice_line, original_invoice, original_line_seq, next_adj_invoice, next_adj_line_seq, prior_adj_invoice, prior_adj_line_seq, latest_invoice, latest_line_seq, line_type, identifier, descr, unit_of_measure, qty, charge_from_dt, charge_to_dt, unit_amt, tax_cd, tax_exempt_cert, tax_exempt_flg, net_extended_amt, gross_extended_amt, net_extended_bse, gross_extended_bse, tot_discount_amt, tot_surcharge_amt, tot_discount_bse, tot_surcharge_bse, po_ref, contract_num, add_dttm, last_update_dttm, last_maint_oprid from PS_BI_LINE_ADJ_AUX

# 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 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
5 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. "
6 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
7 ORIGINAL_INVOICE Character(22) VARCHAR2(22) NOT NULL Original Invoice
8 ORIGINAL_LINE_SEQ Number(5,0) INTEGER NOT NULL Original Line Sequence 5
9 NEXT_ADJ_INVOICE Character(22) VARCHAR2(22) NOT NULL Adjusting Invoice
10 NEXT_ADJ_LINE_SEQ Number(5,0) INTEGER NOT NULL Next Adjustment Line Sequence
11 PRIOR_ADJ_INVOICE Character(22) VARCHAR2(22) NOT NULL Adjusted Invoice
12 PRIOR_ADJ_LINE_SEQ Number(5,0) INTEGER NOT NULL Prior Adjustment Line Seq
13 LATEST_INVOICE Character(22) VARCHAR2(22) NOT NULL Latest Invoice
14 LATEST_LINE_SEQ Number(5,0) INTEGER NOT NULL Latest Line Sequence
15 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
16 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier

Prompt Table: %EDITTABLE4

17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

19 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
20 CHARGE_FROM_DT Date(10) DATE From Date for line charges
21 CHARGE_TO_DT Date(10) DATE Through date for charges
22 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
23 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: TAX_HEADER_TBL

24 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate

Prompt Table: CUST_EXEMPT

25 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

26 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
27 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
28 NET_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount
29 GROSS_EXTENDED_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
30 TOT_DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amt
31 TOT_SURCHARGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amt
32 TOT_DISCOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Discount Amount
33 TOT_SURCHARGE_BSE 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 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
37 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.
38 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID