BI_LINE_SS1_VW(SQL View) |
Index Back |
|---|---|
Bill Line Self-Service View |
| SELECT BUSINESS_UNIT , INVOICE , INVOICE_LINE , LINE_SEQ_NUM , BI_CURRENCY_CD , IDENTIFIER , DESCR , %Round(QTY, 2) , UNIT_OF_MEASURE , UNIT_AMT , GROSS_EXTENDED_AMT , NET_EXTENDED_AMT , TOT_DISCOUNT_AMT , TOT_SURCHARGE_AMT , TAX_AMT , TAX_PCT , VAT_AMT , TAX_CD_VAT_PCT , TAX_CD_VAT , VAT_RVRSE_CHG_GDS , TAX_CD_VAT_RVC , TAX_CD_VAT_RVC_PCT , VAT_AMT_RVC , BUSINESS_UNIT_OM , ORDER_NO , ORDER_INT_LINE_NO , ORDER_DATE , PRODUCT_ID , PRODUCT_KIT_ID , SHIP_TO_CUST_ID , SHIP_FROM_BU , SHIP_ID , SHIP_DATE , SHIP_TO_ADDR_NUM , RMA_ID , RMA_LINE_NBR , BUSINESS_UNIT_CA , CONTRACT_NUM , CONTRACT_LINE_NUM , CONTRACT_DT , PROJECT_ID , CHARGE_FROM_DT , CHARGE_TO_DT , PO_REF , PO_LINE , SOLD_TO_CUST_ID , EMPLID , IDENTIFIER_TBL , LANG_DESCR_OVR 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 | INVOICE_LINE |
Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 4 | LINE_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Sequence |
| 5 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 6 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | LINE_QTY | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Quantity |
| 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 | UNIT_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Unit Price |
| 11 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 12 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 13 | TOT_DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amt |
| 14 | TOT_SURCHARGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amt |
| 15 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 16 | TAX_PCT | Number(7,4) | DECIMAL(6,4) NOT NULL | Tax Percent |
| 17 | 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. |
| 18 | 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. |
| 19 | 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. |
| 20 | VAT_RVRSE_CHG_GDS | Character(1) | VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
Y/N Table Edit |
| 21 | TAX_CD_VAT_RVC | Character(8) | VARCHAR2(8) NOT NULL | Reverse Charge VAT Code |
| 22 | TAX_CD_VAT_RVC_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Customer VAT Rate |
| 23 | VAT_AMT_RVC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Reverse Charge VAT Amount |
| 24 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 25 | 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 |
| 26 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 27 | ORDER_DATE | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 28 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 29 | PRODUCT_KIT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product Kit Number |
| 30 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 31 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 32 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 33 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 34 | SHIP_TO_ADDR_NUM | Number(5,0) | INTEGER NOT NULL | Ship To Address Sequence Num |
| 35 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
| 36 | RMA_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 37 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 38 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 39 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 40 | CONTRACT_DT | Date(10) | DATE | Contract Date |
| 41 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 42 | CHARGE_FROM_DT | Date(10) | DATE | From Date for line charges |
| 43 | CHARGE_TO_DT | Date(10) | DATE | Through date for charges |
| 44 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 45 | PO_LINE | Number(3,0) | SMALLINT NOT NULL | Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF. |
| 46 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 47 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 48 | IDENTIFIER_TBL | Character(3) | VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID CON=Contracts D=Discount Table G=Generic Identifier ID=PS/Billing Charge Id ITM=PS/Inventory Item ID LAB=Labor type PDA=Product Alias PRD=PS/Product Id PRM=PS/Promotion Code S=Surcharge Table SVC=Service UPC=UPC UPN=Universal Item ID |
| 49 | LANG_DESCR_OVR | Character(3) | VARCHAR2(3) NOT NULL | Language of Descr Override |