SAC_RCV_LNDS_V

(SQL View)
 Index Back

Receipt Accounting Entries EIP

Receipt Accounting Entries EIP Msg View

SELECT A.BUSINESS_UNIT ,A.RECEIVER_ID ,A.RECV_LN_NBR ,A.RECV_SHIP_SEQ_NBR ,A.DISTRIB_LINE_NUM ,A.ACCOUNT ,A.ALTACCT ,A.DEPTID ,A.ACTIVITY_ID ,A.ANALYSIS_TYPE ,A.BUSINESS_UNIT_AM ,A.BUSINESS_UNIT_GL ,A.BUSINESS_UNIT_IN ,A.BUSINESS_UNIT_PC ,A.BUSINESS_UNIT_PO ,A.CAP_NUM ,A.CAP_SEQUENCE ,A.CHARTFIELD_STATUS ,A.CONSIGNED_FLAG ,A.COST_TYPE ,A.COSTED_FLAG ,A.CURRENCY_CD ,A.CURRENCY_CD_BASE ,A.DELIVERED_DT ,A.DELIVERED_FLG ,A.DELIVERED_TO ,A.DISTRIB_TYPE ,A.DST_ACCT_TYPE ,A.EMPLID ,A.FINANCIAL_ASSET_SW ,A.FREIGHT_PERCENT ,A.LINE_NBR ,A.LOCATION ,A.LOC_RECV_LBL_FLG ,A.MERCH_AMT_BSE ,A.MERCH_AMT_PO_BSE ,A.MERCHANDISE_AMT ,A.MERCHANDISE_AMT_PO ,A.MOV_DS_ACCPT_SUOM ,A.PO_DIST_LINE_NUM ,A.PO_ID ,A.PROCESS_INSTANCE ,A.PROFILE_ID ,A.QTY_DS_ACCPT_SUOM ,A.QTY_DS_ACCPT_VUOM ,A.QTY_PO ,A.RATE_DIV ,A.RATE_MULT ,A.RECV_DS_STATUS ,A.REQ_ID ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.RESOURCE_TYPE ,A.RT_TYPE ,A.SCHED_NBR ,A.STATISTICS_CODE ,A.STATISTIC_AMOUNT ,A.TAX_CD_SUT_PCT ,A.TAX_CD_VAT_PCT ,%subrec(CF15_AN_SBR ,A) ,A.PROJECT_ID ,%subrec(PUR_USR_DST_SBR, A) FROM PS_RECV_LN_DISTRIB A

  • Parent record: RECV_LN_SHIP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: %EDIT_ACCOUNT
    Set Control Field: BUSINESS_UNIT_GL

    7 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: %EDIT_ALTACCT
    Set Control Field: BUSINESS_UNIT_GL

    8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW
    Set Control Field: BUSINESS_UNIT_GL

    9 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    10 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    11 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: %EDIT_BU_AM

    12 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BUPRCR_NONVW

    13 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: %EDIT_BU_IN

    14 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    15 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    16 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

    Prompt Table: CAP_DET_VW

    17 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

    Prompt Table: CAP_DET_VW

    18 CHARTFIELD_STATUS Character(1) VARCHAR2(1) NOT NULL Chartfield Status
    R=Recycled
    V=Valid

    Default Value: V

    19 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag

    Y/N Table Edit

    Default Value: N

    20 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

    Prompt Table: COST_TYPE_TBL

    21 COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
    E=Error; Cannot process
    N=Transaction is Not Costed
    P=Qualified for Purging
    X=Transaction Won't be Costed
    Y=Transaction is Costed

    Y/N Table Edit

    Default Value: N

    22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    23 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    24 DELIVERED_DT Date(10) DATE Delivered Date
    25 DELIVERED_FLG Character(1) VARCHAR2(1) NOT NULL Delivered Flag

    Y/N Table Edit

    Default Value: N

    26 DELIVERED_TO Character(30) VARCHAR2(30) NOT NULL Delivered To
    27 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
    28 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
    29 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    30 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
    N=Non Cap
    Y=Capitalize
    31 FREIGHT_PERCENT Signed Number(9,3) DECIMAL(7,3) NOT NULL Freight Percent
    32 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    33 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_VW

    34 LOC_RECV_LBL_FLG Character(1) VARCHAR2(1) NOT NULL Location Labels Processed

    Y/N Table Edit

    Default Value: N

    35 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
    36 MERCH_AMT_PO_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt PO Base
    37 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    38 MERCHANDISE_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Merchandise Amount
    39 MOV_DS_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Interfaced Qty
    40 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
    41 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    42 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    43 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: %EDIT_PROFILE

    44 QTY_DS_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Quantity
    45 QTY_DS_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Qty in Supp UOM
    46 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    47 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    48 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    49 RECV_DS_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
    C=Closed
    H=Hold
    M=Moved
    O=Open
    R=Received
    X=Cancelled
    50 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    51 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
    52 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
    53 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
    54 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    55 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    56 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_BUGL_VW

    57 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
    58 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
    59 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.
    60 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_BUGL_VW

    61 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_BUGL_VW

    62 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL_VW

    63 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASSCF_BUGL_VW

    64 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_BUGL_VW

    65 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_BUGL_VW

    66 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    67 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    68 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    69 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL_VW

    70 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL_VW

    71 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL_VW

    72 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    73 USER_DIST_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    74 CUSTOM_C100_D1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    75 CUSTOM_C100_D2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    76 CUSTOM_C100_D3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    77 CUSTOM_C100_D4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    78 CUSTOM_DATE_D Date(10) DATE Custom Date
    79 CUSTOM_C1_D Character(1) VARCHAR2(1) NOT NULL Custom Character 2