BI_ADJ_LHIST_VW(SQL View) |
Index Back |
|---|---|
Billing Adjust Line Hist Work |
| select A.business_unit, b.invoice, b.line_seq_num, A.invoice, A.line_seq_num, a.bi_currency_cd, a.base_currency, c.invoice_type, C.bill_status, C.invoice_dt, A.original_invoice, A.original_line_seq, A.next_adj_invoice, A.next_adj_line_seq, c.dt_invoiced, A.invoice_line, A.identifier, A.descr, A.qty, A.net_extended_amt, a.net_extended_bse, a.entry_type, a.entry_reason, A.ADD_DTTM from ps_bi_line a, ps_bi_line b,PS_BI_HDR C where A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INVOICE = C.INVOICE and b.business_unit = a.business_unit and b.original_invoice = a.original_invoice and b.original_line_seq = a.original_line_seq |
| # | 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 | LINE_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Sequence |
| 4 | SCROLL_INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 5 | SCROLL_LINE_SEQ |
Number(5,0) | INTEGER NOT NULL | Scroll Line Seq |
| 6 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 7 | 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. " |
| 8 | 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 |
| 9 | 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 |
| 10 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 11 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 12 | ORIGINAL_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Original Line Sequence 5 |
| 13 | NEXT_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusting Invoice |
| 14 | NEXT_ADJ_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Next Adjustment Line Sequence |
| 15 | DT_INVOICED | Date(10) | DATE | Date Invoiced |
| 16 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 17 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 19 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 20 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 21 | NET_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 22 | 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 |
| 23 | 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 |
| 24 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |