ORD_HDR_MSG_IN

(SQL View)
 Index Back

Order Header

ORD_HEADER view for sales order/quote messages

SELECT BUSINESS_UNIT , ORDER_NO , SOLD_TO_CUST_ID , ADDRESS_SEQ_NUM , ADDRESS_SEQ_SHIP , ADDRESS_SEQ_SOLD , ADDTL_ADJUST_AMT , ADDTL_ADJUST_BASE , ADDTL_ADJUST_PCT , BILL_TO_CUST_ID , CARRIER_ID , CCARD_APPROVAL_CD , CC_AMOUNT , CNTCT_SEQ_BILL , CNTCT_SEQ_NUM , CNTCT_SEQ_SHIP , CR_CARD_AMT_BASE , CR_CARD_AUTH_DT , CR_CARD_AUTH_STAT , CR_CARD_DIGITS , CR_CARD_EXPMO , CR_CARD_EXPYR , CR_CARD_FNAME , CR_CARD_LNAME , CR_CARD_NBR , CR_CARD_TYPE , CR_CARD_VENDOR , CC_PROF_TOKEN , CURRENCY_CD , CURRENCY_CD_BASE , CUSTOMER_PO , FREIGHT_BILL_TYPE , FREIGHT_CHARGE , FREIGHT_CHARGE_BSE , FREIGHT_TAX_AMT , FREIGHT_TAX_BASE , FREIGHT_TAX_PCT , FREIGHT_TERMS , ORDER_DATE , ORDER_GRP , ORDER_STATUS , PAYMENT_METHOD , PHONE , PYMNT_TERMS_CD , QUOTE_DUE_DATE , QUOTE_EXPIRE_DT , QUOTE_NBR , QUOTE_REQUESTOR , RATE_DATE , RATE_DIV , RATE_MULT , REQ_ARRIVAL_DTTM , RT_TYPE , SHIP_PARTIAL_FLAG , SHIP_PARTIAL_ORD , SHIP_PRIOR_FLAG , SHIP_TO_CUST_ID , SHIP_TYPE_ID , SOURCE_CD , STD_DISCOUNT , SUCCESS_PCT , TAX_EXEMPT_CERT , TAX_EXEMPT_FLG , EMAILID FROM PS_ORD_HEADER

# 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

Default Value: NEXT

3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
4 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
5 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To
6 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
7 ADDTL_ADJUST_AMT Signed Number(29,4) DECIMAL(27,4) NOT NULL Adjustment Amount
8 ADDTL_ADJUST_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Adjustment Amount (base)
9 ADDTL_ADJUST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment %
10 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
11 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
12 CCARD_APPROVAL_CD Character(10) VARCHAR2(10) NOT NULL Approval Code
13 CC_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Transaction Amount
14 CNTCT_SEQ_BILL Number(5,0) INTEGER NOT NULL Contact Sequence - Bill To
15 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
16 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To
17 CR_CARD_AMT_BASE Number(27,3) DECIMAL(26,3) NOT NULL Credit Card Base Amount
18 CR_CARD_AUTH_DT Date(10) DATE Credit Card Authorization Date
19 CR_CARD_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Credit Card Auth Status
A=Authorized
B=Billed
C=Credited
D=Denied
E=Validation Errors
F=Auth Reversal
G=Validated
H=Auth Reversal Denied
J=Reauthorize
K=No Action
L=Credit Card Not In Group
M=Manually Approved/Settled
N=Change to Terms
P=Authorized and Billed
R=Processing
T=Cancel Order
U=Unprocessed/Retry
V=Pending Approval
W=Deleted after Settlement
X=Deleted
Y=Cancelled
Z=Zero Payment for Maintenance
20 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
21 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
22 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
23 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
24 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
25 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
26 CR_CARD_TYPE Character(3) VARCHAR2(3) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute
27 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name
28 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
30 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
31 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
32 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping
33 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
34 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)
35 FREIGHT_TAX_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount
36 FREIGHT_TAX_BASE Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount Base
37 FREIGHT_TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Freight Tax Percent
38 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
39 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

Default Value: %date

40 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
41 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
42 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
43 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
44 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.
45 QUOTE_DUE_DATE Date(10) DATE Quote Due Date
46 QUOTE_EXPIRE_DT Date(10) DATE Quote Expiration Date
47 QUOTE_NBR Character(15) VARCHAR2(15) NOT NULL Quotation Number
48 QUOTE_REQUESTOR Character(15) VARCHAR2(15) NOT NULL Quote Requester
49 RATE_DATE Date(10) DATE Exchange Rate Date
50 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
51 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
52 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
53 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.
54 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes

Y/N Table Edit

Default Value: N

55 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes

Y/N Table Edit

Default Value: N

56 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes

Y/N Table Edit

Default Value: N

57 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
58 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
59 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
60 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount
61 SUCCESS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Success Percent
62 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
63 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: N

64 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address