BI_ADJ_HIST_VW (SQL View)	Index Back
Billing Adjustment History Vw

BI_ADJ_HIST_VW

(SQL View)

Billing Adjustment History Vw

select a.business_unit, a.invoice, a.bi_currency_cd, a.base_currency, a.bill_status, a.invoice_type, a.original_invoice, a.invoice_dt, a.invoice_amount, a.invoice_amt_bse, a.entry_type, a.entry_reason, A.ADD_DTTM from PS_BI_HDR a

# 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

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

4 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. "

5 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill

6 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill

7 ORIGINAL_INVOICE Character(22) VARCHAR2(22) NOT NULL Original Invoice

8 INVOICE_DT Date(10) DATE Invoice Date

9 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

10 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

11 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table: %EDITTABLE

12 ENTRY_REASON Character(5) VARCHAR2(5) NOT NULL "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table: %EDITTABLE2

13 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

#	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
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
4	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. "
5	BILL_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Bill Status CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill
6	INVOICE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Invoice Type ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill
7	ORIGINAL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Original Invoice
8	INVOICE_DT	Date(10)	DATE	Invoice Date
9	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
10	INVOICE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
11	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. Prompt Table: %EDITTABLE
12	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""." Prompt Table: %EDITTABLE2
13	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added