BI_ACCUM_BAL_VW(SQL View) |
Index Back |
|---|---|
Hdr/Line View for Cum Billing |
| SELECT A.BUSINESS_UNIT , A.INVOICE , A.INVOICE_DT , A.BILL_TYPE_ID , A.BILL_SOURCE_ID , A.BILL_STATUS , A.BILL_TO_CUST_ID , B.IDENTIFIER , B.DESCR , B.TAX_CD , B.PO_REF , B.CONTRACT_NUM , B.ORDER_NO , B.BILL_OF_LADING , B.SHIP_TO_CUST_ID , B.SHIP_ID , B.SOLD_TO_CUST_ID , B.PROJECT_ID , B.ANALYSIS_TYPE , B.RESOURCE_TYPE , B.RESOURCE_CATEGORY , B.RESOURCE_SUB_CAT , B.ACTIVITY_ID , B.ACTIVITY_TYPE , B.SYSTEM_SOURCE , B.SERVICE_CUST_ID , B.ACCUMULATE , B.USER1 , B.USER2 , B.USER3 , B.USER4 , B.USER5 , B.USER6 , B.USER7 , B.USER8 , B.USER9 , B.QTY , B.UNIT_AMT , B.TAX_AMT , B.VAT_BASIS_AMT , B.VAT_AMT , B.GROSS_EXTENDED_AMT , B.NET_EXTENDED_AMT , B.TOT_DISCOUNT_AMT , B.TOT_SURCHARGE_AMT , B.USER_AMT1 , B.USER_AMT2 , B.TAX_AMT_BSE , B.VAT_BASIS_AMT_BSE , B.VAT_AMT_BSE , B.GROSS_EXTENDED_BSE , B.NET_EXTENDED_BSE , B.TOT_DISCOUNT_BSE , B.TOT_SURCHARGE_BSE , B.USER_AMT1_BSE , B.USER_AMT2_BSE , B.TAX_AMT_XEU , B.VAT_BASIS_AMT_XEU , B.VAT_AMT_XEU , B.GROSS_EXTENDED_XEU , B.NET_EXTENDED_XEU , B.TOT_DISCOUNT_XEU , B.TOT_SURCHARGE_XEU , B.USER_AMT1_XEU , B.USER_AMT2_XEU , B.BI_CURRENCY_CD , B.BASE_CURRENCY , B.CURRENCY_CD_XEU , B.EXD_INVOICE_NO , B.EXD_ASSESS_VALUE , B.EXD_UOM , B.EXD_TAX_AMT , B.EXD_TAX_AMT_BSE , B.EXD_TAX_AMT_RPT , B.STX_TAX_AMT , B.STX_TAX_AMT_BSE , B.STX_TAX_AMT_RPT , B.EXS_CURRENCY_RPTG , B.PHYSICAL_NATURE FROM PS_BI_HDR A ,PS_BI_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND B.ACCUMULATE = 'Y' AND A.TEMPLATE_IVC_FLG = 'N' |
| # | 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 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 5 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
| 6 | 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 |
| 7 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 8 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: TAX_HEADER_TBL |
| 11 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 12 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 13 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 14 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 15 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: CUSTOMER |
| 16 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 17 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: CUSTOMER |
| 18 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 19 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 20 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 21 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 22 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 23 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 24 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason |
| 25 | 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. |
| 26 | SERVICE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Service Customer ID
Prompt Table: CUSTOMER |
| 27 | ACCUMULATE | Character(1) | VARCHAR2(1) NOT NULL | Include in Cumulative Balance |
| 28 | USER1 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 29 | USER2 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 30 | USER3 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 31 | USER4 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 32 | USER5 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 33 | USER6 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 34 | USER7 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 35 | USER8 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 36 | USER9 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
| 37 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 38 | UNIT_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Unit Price |
| 39 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 40 | 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. |
| 41 | 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. |
| 42 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 43 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 44 | TOT_DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amt |
| 45 | TOT_SURCHARGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amt |
| 46 | USER_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 47 | USER_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 48 | TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount (base) |
| 49 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 50 | VAT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount in Base Curr |
| 51 | GROSS_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 52 | NET_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 53 | TOT_DISCOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Discount Amount |
| 54 | TOT_SURCHARGE_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amount |
| 55 | USER_AMT1_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 1 |
| 56 | USER_AMT2_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 2 |
| 57 | TAX_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount - Euro |
| 58 | VAT_BASIS_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amount in Euro Curr |
| 59 | VAT_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount - Euro Currency |
| 60 | GROSS_EXTENDED_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 61 | NET_EXTENDED_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 62 | TOT_DISCOUNT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Discount Amount |
| 63 | TOT_SURCHARGE_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amount |
| 64 | USER_AMT1_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 1 |
| 65 | USER_AMT2_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 2 |
| 66 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 67 | 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. " |
| 68 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL | Euro Currency |
| 69 | EXD_INVOICE_NO | Character(10) | VARCHAR2(10) NOT NULL | Excise Invoice Number |
| 70 | EXD_ASSESS_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Assessable Value |
| 71 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 72 | EXD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Tax Amount |
| 73 | EXD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty in Base Currency |
| 74 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 75 | STX_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 76 | STX_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN BASE CURR |
| 77 | STX_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN REPORT CURR |
| 78 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 79 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |