SAC_SS_HDR_VW

(SQL View)
 Index Back

Purchase Order Header

Purchase Order Header

SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , 0 , A.PO_TYPE , 'A' , 'N' , 'N' , 'Y' , A.DISP_METHOD , 'U' , %CurrentDateIn , %Substring(B.AUC_NAME, 1, 30) , A.BIDNUM , A.BIDDER_TYPE , A.AUC_AWARD_NBR , A.BIDDER_SETID , %Substring(A.BIDDER_ID , 1, 10) , A.BIDDER_LOC , A.BIDDER_SETID , %Substring(A.BIDDER_ID , 1, 10) , A.BIDDER_LOC , A.PYMNT_TERMS_CD , A.BUYER_ID , A.ORIGIN , 0 , C.ADDRESS_SEQ_NUM , C.CNTCT_SEQ_NUM , 0 , A.LOCATION , A.TAX_EXEMPT , A.TAX_EXEMPT_ID ,(DECODE(A.AUC_AWARD_CURR , 'R' , A.RESP_CURRENCY_CD , A.CURRENCY_CD)) , B.RT_TYPE , A.MATCH_ACTION , A.MATCH_CNTRL_ID , 'T' , 'N' , 0 , ' ' , 'N' , 'STANDARD' , B.OPRID_ENTERED_BY , %CurrentDateIn , ' ' , %DateNull , B.OPRID_MODIFIED_BY , B.LAST_UPDATE_DTTM , %CurrentDateIn , ' ' , 'N' , %CurrentDateIn , 'N' , 0 , 'N' , 'N' ,(DECODE(A.AUC_AWARD_CURR , 'R' , A.RESP_CURRENCY_CD , A.CURRENCY_CD)) , B.RATE_DATE , 1 , 1 , ' ' , ' ' , 'V' , 'N' , 0 , 'N' , 'N' , 'I' , %DateNull , '1' , 'V' , 'N' , %Sql(POPURUSRINIT1) , 'N' , E.PHONE , E.FAX , G.NAME1 , F.ADDRESS1 , F.ADDRESS2 , F.CITY , F.STATE , F.POSTAL , F.COUNTRY , F.EMAILID FROM PS_AUC_AWARD_HDR A , PS_AUC_HDR B , PS_AUC_AWARD_ADDR C , PS_BUYER_TBL E , PS_VENDOR_ADDR F , PS_VENDOR G WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION AND A.BIDNUM = C.BIDNUM AND A.BIDDER_SETID = C.BIDDER_SETID AND A.BIDDER_ID = C.BIDDER_ID AND A.BIDDER_TYPE = C.BIDDER_TYPE AND A.BIDDER_LOC = C.BIDDER_LOC AND A.AUC_AWARD_NBR = C.AUC_AWARD_NBR AND A.BIDDER_SETID = G.SETID AND A.BIDDER_ID = G.VENDOR_ID AND A.BIDDER_SETID = F.SETID AND A.BIDDER_ID = F.VENDOR_ID AND C.ADDRESS_SEQ_NUM = F.ADDRESS_SEQ_NUM AND A.BUYER_ID = E.BUYER_ID AND F.EFFDT = ( SELECT MAX(EFFDT) FROM PS_VENDOR_ADDR WHERE F.SETID = SETID AND F.VENDOR_ID = VENDOR_ID AND EFFDT <= %CurrentDateIn)

# 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

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
6 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
7 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
8 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
9 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
10 DISP_ACTION Character(1) VARCHAR2(1) NOT NULL Allow Dispatch When Appr
11 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
12 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
13 PO_DT Date(10) DATE NOT NULL Date
14 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
15 BIDNUM Signed Number(6,0) DECIMAL(5) NOT NULL Bid ID
16 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
17 AUC_AWARD_NBR Number(3,0) SMALLINT NOT NULL Award Number
18 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
19 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
20 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
21 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
22 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
23 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
24 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.
25 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
26 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
27 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
28 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
29 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
30 SALES_CNTCT_SEQ_N Number(3,0) SMALLINT NOT NULL Salesperson
31 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

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

Default Value: BUS_UNIT_TBL_PM.TAX_EXEMPT

33 TAX_EXEMPT_ID Character(30) VARCHAR2(30) NOT NULL Tax Exempt ID
34 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

35 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

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

Default Value: N

37 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
38 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

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

Default Value: N

40 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
41 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance
42 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document

Default Value: Y

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

Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID

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

Default Value: BUS_UNIT_TBL_PM.BUSINESS_UNIT_GL

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

Default Value: N

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

Default Value: N

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

Default Value: N

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

Default Value: BUS_UNIT_TBL_PM.ACCRUE_USE_TAX

58 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
59 RATE_DATE Date(10) DATE Exchange Rate Date
60 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: 1

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

Default Value: 1

62 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.
63 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
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

Default Value: V

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

Default Value: N

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

Default Value: N

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

Default Value: N

69 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
70 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
71 BACKORDER_STATUS Character(1) VARCHAR2(1) NOT NULL Back Order Status
1=Not Backordered
2=Backordered
3=Backordered Received

Default Value: 1

72 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

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

Default Value: N

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

Default Value: N

82 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
83 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
84 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
85 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
86 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
87 CITY Character(30) VARCHAR2(30) NOT NULL City
88 STATE Character(6) VARCHAR2(6) NOT NULL State
89 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
90 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
91 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address