OM_RCPT_FRT_VW

(SQL View)
Index Back

Receipt Freight Detail

Receipt Freight Detail

SELECT DISTINCT E.SOURCE_BUS_UNIT , E.ORDER_NO , E.DELIVERY_ID , E.CURRENCY_CD_DEF , E.CURRENCY_CD_BASE , P.DESCR , D.DOC_REFNUM , E.INVOICE , 1 , E.FREIGHT_CHARGE_CNV , E.FREIGHT_CHARGE_BSE , 0 , 0 , 0 , 0 , 0 , ' ' , E.IDENTIFIER , E.IDENTIFIER , 1 , E.FREIGHT_TAX_AMT , E.FREIGHT_TAX_BASE , E.TAX_CD_VAT , E.TAX_CD_VAT_PCT , E.TAX_CD_VAT_RVC , E.TAX_CD_VAT_RVC_PCT , E.UNIT_OF_MEASURE , E.VAT_AMT , E.VAT_AMT_BSE , E.VAT_AMT_RVC , E.VAT_AMT_RVC_BSE , E.VAT_RVRSE_CHG_GDS , E.VAT_APPLICABILITY , ' ' , E.VAT_BASIS_AMT , E.VAT_BASIS_AMT_BSE , E.VAT_ENTITY , E.VAT_EXCPTN_CERTIF , ' ' , E.VAT_EXCPTN_TYPE , E.VAT_TRANS_AMT , E.VAT_TRANS_AMT_BSE , E.VAT_TREATMENT FROM %Table(IN_DELIVERY_ORD) E , %Table(PROD_ITEM) P , %Table(SET_CNTRL_REC) SC , PS_IN_DELIVERY D WHERE E.SOURCE_BUS_UNIT = SC.SETCNTRLVALUE AND SC.REC_GROUP_ID = 'FS_18' AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = P.SETID AND P.PRODUCT_ID = E.IDENTIFIER AND E.FREIGHT_CHARGE_CNV <> 0 AND E.FREIGHT_APP = 'OM' AND E.SHIP_ID = ' ' AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.DELIVERY_ID = E.DELIVERY_ID

  • Related Language Record: OM_RCPT_FR_LANG
  • # 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 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    5 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number
    8 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    9 INVOICED_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Note: OM_BILL populates this field with the quantity invoiced in PRICING UOM.
    10 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    11 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
    12 ORD_ADJST_SCH_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount
    13 ORD_ADJST_SCH_BASE Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount
    14 PRC_NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    15 PRC_NET_UNIT_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
    16 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.
    17 PRICING_UOM Character(3) VARCHAR2(3) NOT NULL Pricing UOM

    Prompt Table: PROD_UOMPRC_VW

    18 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: %EDITTABLE

    19 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered

    Prompt Table: %EDITTABLE5

    20 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
    21 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
    22 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)
    23 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

    24 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.
    25 TAX_CD_VAT_RVC Character(8) VARCHAR2(8) NOT NULL Reverse Charge VAT Code
    26 TAX_CD_VAT_RVC_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Customer VAT Rate
    27 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

    28 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.
    29 VAT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Amount in Base Curr
    30 VAT_AMT_RVC Signed Number(28,3) DECIMAL(26,3) NOT NULL Reverse Charge VAT Amount
    31 VAT_AMT_RVC_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Reverse Charge Amount in Base Currency
    32 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag
    33 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
    34 VAT_APPLIC_DESCR Character(30) VARCHAR2(30) NOT NULL VAT Applicability Description
    35 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.
    36 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
    37 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.
    38 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.
    39 VAT_EXCPTN_DESCR Character(30) VARCHAR2(30) NOT NULL VAT Exception Description
    40 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
    41 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.
    42 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
    43 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment