PO_HDR_FS2_VW

(SQL View)
 Index Back

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.PROCESS_INSTANCE ,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 , %subrec(LAST_UPDATE_SBR,A) ,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 ,%subrec(KK_TRAN_SBR,A) ,A.LC_ID ,A.BUDGET_HDR_STS_NP , A.BACKORDER_STATUS , A.DOC_TOL_HDR_STATUS , A.MID_ROLL_STATUS ,%subrec(PUR_USR_HDR_SBR,A) FROM PS_PO_HDR A WHERE HOLD_STATUS = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO 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

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_ORD_VW

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_ADDR_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

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.
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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
36 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
37 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document

Y/N Table Edit

Default Value: N

38 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

39 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
40 ENTERED_DT Date(10) DATE Entered on
41 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
42 APPROVAL_DT Date(10) DATE Date of Approval
43 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.
44 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.
45 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
46 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

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

Y/N Table Edit

Default Value: N

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

Default Value: N

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

Default Value: N

52 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

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

Prompt Table: CURRENCY_CD_TBL

54 RATE_DATE Date(10) DATE Exchange Rate Date
55 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
56 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
57 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.
58 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

59 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
60 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
61 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
62 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
63 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

64 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
65 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received
66 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
67 MID_ROLL_STATUS Character(1) VARCHAR2(1) NOT NULL Mid Roll Status
68 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
69 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
70 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
71 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
72 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
73 CUSTOM_DATE_A Date(10) DATE Custom Date
74 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2