PO_HDR_FS

(SQL View)
 Index Back

Purchase Order Header

Purchase Order Header

SELECT A.BUSINESS_UNIT , A.PO_ID , A.CHNG_ORD_BATCH , A.PO_TYPE , A.PO_STATUS , A.HOLD_STATUS , A.RECV_STATUS , A.DISP_ACTION , A.DISP_METHOD , A.CHANGE_STATUS , A.PO_DT , A.PO_REF , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.PRICE_SETID , A.PRICE_VENDOR , A.PRICE_LOC , A.PYMNT_TERMS_CD , A.BUYER_ID , A.ORIGIN , A.CHNG_ORD_SEQ , A.ADDRESS_SEQ_NUM , A.CNTCT_SEQ_NUM , A.SALES_CNTCT_SEQ_N , A.BILL_LOCATION , A.TAX_EXEMPT , A.TAX_EXEMPT_ID , A.CURRENCY_CD , A.RT_TYPE , A.MATCH_ACTION , A.MATCH_CNTRL_ID , A.MATCH_STATUS_PO , A.MATCH_PROCESS_FLG , A.APPL_JRNL_ID_ENC , A.POST_DOC , A.DST_CNTRL_ID , A.OPRID_ENTERED_BY , A.ENTERED_DT , A.OPRID_APPROVED_BY , A.APPROVAL_DT , A.OPRID_MODIFIED_BY , A.LAST_DTTM_UPDATE , A.ACCOUNTING_DT , A.BUSINESS_UNIT_GL , A.IN_PROCESS_FLG , A.ACTIVITY_DATE , A.PO_POST_STATUS , A.NEXT_MOD_SEQ_NBR , A.ERS_ACTION , A.ACCRUE_USE_TAX , A.CURRENCY_CD_BASE , A.RATE_DATE , A.RATE_MULT , A.RATE_DIV , A.VAT_ENTITY , A.BUDGET_HDR_STATUS , A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.LC_ID , A.BUDGET_HDR_STS_NP , A.PREPAID_PO_FLG , A.PREPAID_AMT , A.PREPAID_AUTH_STAT , A.PREPAID_STATUS_PO , A.PAY_TRM_BSE_DT_OPT , A.TERMS_BASIS_DT , A.BACKORDER_STATUS , A.DOC_TOL_HDR_STATUS , A.MID_ROLL_STATUS , A.USER_HDR_CHAR1 , A.CUSTOM_C100_A1 , A.CUSTOM_C100_A2 , A.CUSTOM_C100_A3 , A.CUSTOM_C100_A4 , A.CUSTOM_DATE_A , A.CUSTOM_C1_A , A.BUDGET_CHECK , A.POA_STATUS , A.POA_REQS , A.CC_SECURITY_ID , A.CC_USE_FLAG , A.CC_DISP_OPTION , A.CONTACT_NAME , A.CONTACT_PHONE , A.TEXT254_CC2 , A.TMPLDEFN_ID , A.SPLIT_PO_BY_SHIPTO , A.EE_SEQ_NUM , A.PROCURE_INSTRUM_ID , A.PI_ID_PARENT , A.UNIVERSAL_REC_ID , A.FEDERAL_AWARD_ID , A.EXCLUDE_REPORTING , A.PROCESS_INSTANCE , A.PRIORITY_FLG FROM PS_PO_HDR A

  • Parent Record Of CS_POLNANDSHPVW CS_PO_CHRGES_VW CS_PO_LINE_VW CS_PO_LINE_VW2 PO_COMMENTS_FS PO_COMMENTS_FS1 PO_HDR_COMM_VW PO_LINE_AW_VW PO_LINE_FS PO_LN_ORDER_VW PO_LN_ORDER_VW2 PO_LN_ORDER_VW3 PO_LN_ORDER_VW4 PO_LN_ORD_VW4A PO_SSPOA_HC_VW PO_SSPOA_LC_VW RECV_COMMENT_FS VCHRPO_COMMENTS VCHRPO_HDR_CMNT VCHRRCV_CMNTS VCHRRCV_HDR_CMT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_PM_NONVW

    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Default Value: NEXT

    3 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
    4 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
    GEN=General
    KAN=Kanban

    Default Value: GEN

    Prompt Table: %EDITTABLE30

    5 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
    A=Approved
    C=Complete
    D=Dispatched
    DA=Denied
    I=Initial
    LD=Line Denied
    O=Open
    PA=Pending Approval/Approved
    PX=Pending Cancel
    X=Canceled

    Default Value: I

    6 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

    Y/N Table Edit

    Default Value: N

    7 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
    C=Closed Receipt
    H=Hold Receipt
    M=Moved to Destination
    N=PO Not Received
    O=Open
    P=PO Partially Received
    R=Fully Received
    X=Canceled

    Default Value: N

    8 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr

    Y/N Table Edit

    Default Value: Y

    9 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
    EDX=Electronic Document Exchange
    EML=Email Dispatch
    FAX=Fax Transmission
    PHN=Phone Dispatch
    PRN=Print
    10 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
    C=Changed
    U=Unchanged

    Default Value: U

    11 PO_DT Date(10) DATE NOT NULL Date

    Default Value: %date

    12 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
    13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_PO_VW

    15 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_LOC_VW1

    16 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
    17 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
    18 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
    19 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: PYMT_TR_EFF_VW

    20 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: %EDIT_BUYER

    21 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

    22 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
    23 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Default Value: VENDOR.ADDR_SEQ_NUM_ORDR

    Prompt Table: VENDOR_ADDR1_VW

    24 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: VENDOR_CNTCT_VW

    25 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson

    Prompt Table: VENDOR_CNTCT_VW

    26 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

    Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

    Prompt Table: LOCATION_TBL

    27 TAX_EXEMPT Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

    Y/N Table Edit

    Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

    28 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
    29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    30 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.

    Default Value: BUS_UNIT_TBL_PM.RT_TYPE

    Prompt Table: RT_TYPE_TBL

    31 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
    N=No Match
    Y=Standard

    Default Value: N

    32 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

    Prompt Table: %EDITTABLE2

    33 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
    M=Matched
    N=Not Required
    P=Partially Matched
    T=To Match

    Default Value: N

    34 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
    I=In Process
    N=No

    Default Value: N

    35 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
    36 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document

    Y/N Table Edit

    Default Value: Y

    37 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

    Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID

    Prompt Table: DST_CNTRL_VW

    38 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
    39 ENTERED_DT Date(10) DATE Entered on
    40 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
    41 APPROVAL_DT Date(10) DATE Date of Approval
    42 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
    43 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    44 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    45 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

    46 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Y/N Table Edit

    Default Value: N

    47 ACTIVITY_DATE Date(10) DATE Last Activity
    48 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
    D=Distributed
    N=None

    Default Value: N

    49 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number
    50 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
    N=No
    Y=Yes

    Default Value: N

    51 ACCRUE_USE_TAX Character(1) VARCHAR2(1) NOT NULL Accrue Use Tax

    Y/N Table Edit

    Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX

    52 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

    Prompt Table: CURRENCY_CD_TBL

    53 RATE_DATE Date(10) DATE Exchange Rate Date
    54 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

    Default Value: 1

    55 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

    Default Value: 1

    56 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.

    Prompt Table: VAT_ENTITY

    57 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid

    Default Value: V

    58 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
    0=Budget
    1=Actuals and Recognized
    2=Encumbrance
    3=Pre-Encumbrance
    4=Collected Revenue
    5=Planned
    7=Actuals, Recognize and Collect
    9=Dynamic
    59 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
    N=No
    Y=Yes
    60 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
    61 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
    62 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System

    Prompt Table: LC_HDR_PO_VW
    Set Control Field: BUSINESS_UNIT_GL

    63 BUDGET_HDR_STS_NP Character(1) VARCHAR2(1) NOT NULL Budget Ch'k Hdr Sts NonProrate
    E=Error in Budget Check
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid Budget Check

    Default Value: V

    64 PREPAID_PO_FLG Character(1) VARCHAR2(1) NOT NULL Prepaid PO Flag

    Y/N Table Edit

    Default Value: N

    65 PREPAID_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepaid Amount
    66 PREPAID_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Prepaid Authorization Status
    A=Authorized
    N=Not Approved
    P=Pending Authorization

    Default Value: N

    67 PREPAID_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Prepaid PO Status
    N=Not Processed
    P=Processing
    V=Vouchered

    Default Value: N

    68 PAY_TRM_BSE_DT_OPT Character(1) VARCHAR2(1) NOT NULL Payment Terms Basis Date Type
    A=Acct Date
    C=Doc Date
    I=Inv Date
    R=Recpt Date
    S=Ship Date
    U=User Date
    69 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
    70 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
    1=Not Backordered
    2=Backordered
    3=Backordered Received

    Default Value: 1

    71 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
    E=Error
    N=Not Checked
    R=Reset
    V=Valid

    Default Value: V

    72 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status

    Default Value: N

    73 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    74 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    75 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    76 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    77 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    78 CUSTOM_DATE_A Date(10) DATE Custom Date
    79 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    80 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    81 POA_STATUS Character(2) VARCHAR2(2) NOT NULL po ack status field that will be on po_hdr.
    AC=Acknowledged with changes
    AK=Acknowledged
    BA=Approved, Changes Pending
    IN=Initial Dispatch Acknowledged
    NR=Not Required
    SR=Responded, Awaits Review
    WD=Awaiting PO Dispatch
    WR=Awaiting Acknowledgement

    Default Value: NR

    82 POA_REQS Character(1) VARCHAR2(1) NOT NULL CEL. New field to store POA requirements on the PO Hdr
    A=All dispatches
    I=Initial dispatch only
    N=Not required

    Default Value: N

    83 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
    84 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

    Y/N Table Edit

    Default Value: N

    85 CC_DISP_OPTION Character(1) VARCHAR2(1) NOT NULL ProCard Dispatch Option
    A=Default
    B=Include Masked Card Info
    C=Contact Buyer
    D=Contact Cardholder
    E=Charge to Card on File
    F=No Reference
    86 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
    87 CONTACT_PHONE Character(24) VARCHAR2(24) NOT NULL Recepient Phone
    88 TEXT254_CC2 Character(254) VARCHAR2(254) NOT NULL Payment Instructions
    89 TMPLDEFN_ID Character(30) VARCHAR2(30) NOT NULL Template ID (see PSXPTMPLDEFN).

    Prompt Table: PO_XMLP_TMPL_VW

    90 SPLIT_PO_BY_SHIPTO Character(1) VARCHAR2(1) NOT NULL Split PO by Ship To
    B=Default from Higher Level
    N=Do Not Split PO by Ship To
    Y=Split PO by Ship To
    91 EE_SEQ_NUM Number(8,0) INTEGER NOT NULL Entry Event Sequence Number
    92 PROCURE_INSTRUM_ID Character(50) VARCHAR2(50) NOT NULL Procurement Instrument ID
    93 PI_ID_PARENT Character(50) VARCHAR2(50) NOT NULL Parent PIID
    94 UNIVERSAL_REC_ID Character(70) VARCHAR2(70) NOT NULL Universal Record Identifier
    95 FEDERAL_AWARD_ID Character(30) VARCHAR2(30) NOT NULL Federal Award IdentificationNo
    96 EXCLUDE_REPORTING Character(1) VARCHAR2(1) NOT NULL Exclude from DATA Act

    Y/N Table Edit

    Default Value: N

    97 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    98 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
    1=High
    2=Medium
    3=Low