OM_RCPT_LINE_VW(SQL View) |
Index Back |
|---|---|
Receipt Line DetailReceipt Line Detail |
| SELECT L.BUSINESS_UNIT , L.ORDER_NO , L.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , PS.PRC_SCHED_NBR , S.COUNTRY_VAT_BILLFR , PS.CURRENCY_CD , PS.CURRENCY_CD_BASE , P.DESCR , %Truncate(%DecMult(PS.QTY_ORDERED,PS.NET_UNIT_PRICE),4) , %Truncate(%DecMult(PS.QTY_ORDERED,PS.NET_UNIT_PRICE_BSE),4) , S.DOC_REFNUM , S.INVOICE , PS.INVOICED_QTY , PS.NET_UNIT_PRICE , PS.NET_UNIT_PRICE_BSE , 0 , 0 , PS.ORD_ADJST_SCH_AMT , PS.ORD_ADJST_SCH_BASE , PS.PRC_NET_UNIT_BSE , PS.PRC_NET_UNIT_PRICE , PS.PRICING_QTY , L.PRICING_UOM , L.PRODUCT_ID , L.PROD_ID_ENTERED , PS.QTY_ORDERED , PS.TAX_AMT , PS.TAX_AMT_BSE , S.TAX_CD_VAT , PS.TAX_CD_VAT_PCT , S.TAX_CD_VAT_RVC , PS.TAX_CD_VAT_RVC_PCT , L.UNIT_OF_MEASURE , PS.VAT_AMT , PS.VAT_AMT_BSE , PS.VAT_AMT_RVC , PS.VAT_AMT_RVC_BSE , S.VAT_RVRSE_CHG_GDS , S.VAT_APPLICABILITY , ' ' , PS.VAT_BASIS_AMT , PS.VAT_BASIS_AMT_BSE , S.VAT_ENTITY , S.VAT_EXCPTN_CERTIF , ' ' , S.VAT_EXCPTN_TYPE , PS.VAT_TRANS_AMT , PS.VAT_TRANS_AMT_BSE , S.VAT_TREATMENT FROM %Table(ORD_LINE) L , %Table(ORD_SCHEDULE) S , %Table(ORD_PRICE_SCHED) PS , %Table(PROD_ITEM) P , %Table(SET_CNTRL_REC) SC WHERE %Join(COMMON_KEYS, ORD_LINE L, ORD_SCHEDULE S) AND %Join(COMMON_KEYS, ORD_SCHEDULE S, ORD_PRICE_SCHED PS) AND L.BUSINESS_UNIT = SC.SETCNTRLVALUE AND SC.REC_GROUP_ID = 'FS_18' AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = P.SETID AND P.PRODUCT_ID = L.PRODUCT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | 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 |
| 3 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | PRC_SCHED_NBR |
Number(6,0) | INTEGER NOT NULL | Pricing Schedule Number |
| 6 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | EXTENDED_NET_PRICE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Ext Net Amount |
| 11 | EXT_NET_PRC_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Extended Net Price (base) |
| 12 | DOC_REFNUM | Character(20) | VARCHAR2(20) NOT NULL | Counter sale document reference number |
| 13 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 14 | INVOICED_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Note: OM_BILL populates this field with the quantity invoiced in PRICING UOM. |
| 15 | NET_UNIT_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price |
| 16 | NET_UNIT_PRICE_BSE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
| 17 | ORD_ADJ_BASIS | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 18 | ORD_ADJ_BASIS_BASE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 19 | ORD_ADJST_SCH_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 20 | ORD_ADJST_SCH_BASE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 21 | PRC_NET_UNIT_BSE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
| 22 | PRC_NET_UNIT_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price |
| 23 | PRICING_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Pricing quantity. |
| 24 | PRICING_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Pricing UOM
Prompt Table: PROD_UOMPRC_VW |
| 25 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: %EDITTABLE |
| 26 | PROD_ID_ENTERED | Character(20) | VARCHAR2(20) NOT NULL |
Product ID Entered
Prompt Table: %EDITTABLE5 |
| 27 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 28 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 29 | TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount (base) |
| 30 | 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.
Prompt Table: VAT_HEADER_VW |
| 31 | 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. |
| 32 | TAX_CD_VAT_RVC | Character(8) | VARCHAR2(8) NOT NULL | Reverse Charge VAT Code |
| 33 | TAX_CD_VAT_RVC_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Customer VAT Rate |
| 34 | 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: PROD_UOM_VW |
| 35 | 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. |
| 36 | VAT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount in Base Curr |
| 37 | VAT_AMT_RVC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Reverse Charge VAT Amount |
| 38 | VAT_AMT_RVC_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Reverse Charge Amount in Base Currency |
| 39 | VAT_RVRSE_CHG_GDS | Character(1) | VARCHAR2(1) NOT NULL | VAT Reverse Charge goods flag |
| 40 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 41 | VAT_APPLIC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Applicability Description |
| 42 | 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. |
| 43 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 44 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 45 | VAT_EXCPTN_CERTIF | Character(20) | VARCHAR2(20) NOT NULL | Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT. |
| 46 | VAT_EXCPTN_DESCR | Character(30) | VARCHAR2(30) NOT NULL | VAT Exception Description |
| 47 | VAT_EXCPTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None S=Suspended X=Exonerated |
| 48 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 49 | VAT_TRANS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount in base currency against which the VAT is applicable |
| 50 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |