ORD_COPY_HDR_VW (SQL View)	Index Back
Order Header - OM This record is created when a Sales Order or Quotation is entered. The order header stores information about the order or quote. Much of this information is defaulted from the customer records and order group table. This record is the parent to ORD_LINE. Date Initials Issue # Description 113000 dms R-ED.WON-3S567 Add CNTCT_SEQ_BILL 082301 dms 8.4 Remove unused fields 091301 dms F-CJORGENS-11 Add REASON_Code 112601 yb R-FTOURN-PU9JS Prompt Tables for sold to, ship to and bill to customer are replaced for detail search. 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

ORD_COPY_HDR_VW

(SQL View)

Order Header - OM

This record is created when a Sales Order or Quotation is entered. The order header stores information about the order or quote. Much of this information is defaulted from the customer records and order group table. This record is the parent to ORD_LINE. Date Initials Issue # Description 113000 dms R-ED.WON-3S567 Add CNTCT_SEQ_BILL 082301 dms 8.4 Remove unused fields 091301 dms F-CJORGENS-11 Add REASON_Code 112601 yb R-FTOURN-PU9JS Prompt Tables for sold to, ship to and bill to customer are replaced for detail search. 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT H.BUSINESS_UNIT , H.ORDER_NO , H.SOLD_TO_CUST_ID , H.BILL_TO_CUST_ID , H.ACTIVITY_ID , H.ADDRESS_SEQ_NUM , H.ADDRESS_SEQ_SHIP , H.ADDRESS_SEQ_SOLD , H.ADDR_OVRD_LEVEL , H.ADDR_OVRDSD_FLAG , H.ADDTL_ADJUST_PCT , H.ADDTL_ADJUST_AMT , H.ADDTL_ADJUST_BASE , H.ADDTL_ADJ_BILLED , H.AERP , H.ANALYSIS_TYPE , L.BACKGROUND_REQD , H.BCKORDR_CNCL_FLAG , H.BILL_TYPE_ID , H.BROKER_ID , H.BUSINESS_UNIT_PC , H.PRICE_PROGRAM , H.CANCEL_DATE , H.CARRIER_ID , H.CARRIER_ID_EXP , H.CC_AMOUNT , H.CCARD_APPROVAL_CD , H.CCI_REQ_EXP , H.CNTCT_SEQ_BILL , H.CNTCT_SEQ_NUM , H.COMMSN_LEVEL , H.COMMSN_METHOD , H.CONFIRM_PO_RECVD , H.COO_REQ_EXP , H.COUNTRY_LOC_BUYER , H.COUNTRY_LOC_SELLER , H.COUNTRY_SHIP_FROM , H.COUNTRY_SHIP_TO , H.COUNTRY_VAT_BILLFR , H.COUNTRY_VAT_BILLTO , H.COUNTRY_VAT_PERFRM , H.COUNTRY_VAT_SUPPLY , H.CNTRCT_ID , H.CNTRCT_PROTECTED , H.CR_CARD_NBR , H.CR_CARD_TYPE , H.cr_card_amt_base , H.cr_card_auth_dt , H.cr_card_auth_stat , H.cr_card_fname , H.cr_card_lname , H.cr_card_expmo , H.cr_card_expyr , H.cr_card_digits , L.CREDIT_REQD , H.CURRENCY_CD , H.CURRENCY_CD_BASE , H.CUST_CHANNEL , %subrec(ORD_CUSTOM_SBR, H) , H.CUSTOMER_COMPANY , H.CUSTOMER_PO , H.DIRECT_INVOICING , H.DS_NETWORK_CODE , H.emailid , H.EOEP_ARB_ID , H.EXPORT , H.EXPORT_LIC_REQ , H.EXPORT_LIC_TYPE , H.EXPORT_LIC_APPL , H.EXPORT_APPL_DT , H.EXPORT_LIC_REC , H.EXPORT_REC_DT , H.EXPORT_LIC_NBR , H.EXPORT_LIC_EXPIRE , H.EXPORT_LIC_VALUE , H.EXPORT_LIC_QTY , H.FREIGHT_BILL_TYPE , H.FREIGHT_CHARGE , H.FREIGHT_CHARGE_BSE , H.FREIGHT_TAX_AMT , H.FREIGHT_TAX_BASE , H.FREIGHT_TAX_PCT , H.EXS_TAX_TXN_TYPE , H.FREIGHT_TERMS , H.FREIGHT_TERMS_EXP , H.FRT_CHRG_METHOD , L.HOLD_REQD , H.IMPORT_LIC_REQ , H.IMPORT_LIC_APPL , H.IMPORT_APPL_DT , H.IMPORT_LIC_REC , H.IMPORT_REC_DT , H.IMPORT_CERT_NBR , H.IMPORT_LIC_EXP , H.INITIATED_BY , L.IN_PROCESS_FLG , H.LC_ID , H.LOAD_PRICE_RULE , H.NAFTA_REQ_EXP , H.ORDER_DATE , H.ORDER_GRP , H.ORDER_STATUS , H.ORDER_TYPE_CD , H.PAYMENT_METHOD , H.phone , H.PHYSICAL_NATURE , H.PROD_ID_SRC , H.PROD_SUBSTITUTE , H.PROJECT_ID , H.PYMNT_TERMS_CD , H.QUOTE_DUE_DATE , H.QUOTE_EXPIRE_DT , H.QUOTE_NBR , H.QUOTE_REQUESTOR , H.RATE_DATE , H.RATE_DIV , H.RATE_MULT , H.REASON_CD , H.REF_ORDER_NBR , H.REQ_ARRIVAL_DTTM , H.RESOURCE_CATEGORY , H.RESOURCE_SUB_CAT , H.RESOURCE_TYPE , H.REVISION_NUMBER , H.RT_TYPE , H.SED_REQ_EXP , H.SHIP_PARTIAL_FLAG , H.SHIP_PARTIAL_ORD , H.SHIP_PRIOR_FLAG , H.SHIP_PRIORITY_ID , H.SHIP_PRIORITY_EXP , H.SHIP_TO_CUST_ID , H.SHIP_TYPE_ID , H.SHIP_TYPE_ID_EXP , H.SINGLE_SHIP_FLAG , H.SOURCE_CD , H.STATE_LOC_BUYER , H.STATE_LOC_SELLER , H.STATE_SHIP_FROM , H.STATE_SHIP_TO , H.STATE_VAT_DEFAULT , H.STATE_VAT_PERFRM , H.STD_DISCOUNT , H.STORE_NUMBER , H.SUBCUST_QUAL1 , H.SUBCUST_QUAL2 , H.SUCCESS_PCT , H.SUPPORT_TEAM_CD , H.TAX_CD , H.TAX_EXEMPT_CERT , H.TAX_EXEMPT_FLG , H.VAT_CALC_GROSS_NET , H.VAT_DCLRTN_POINT , H.VAT_ENTITY , H.VAT_EXCPTN_CERTIF , H.VAT_EXCPTN_TYPE , H.VAT_RECALC_FLG , H.VAT_RGSTRN_BUYER , H.VAT_ROUND_RULE , H.VAT_TREATMENT , H.VAT_TREATMENT_GRP , H.VAT_SERVICE_TYPE , H.VAT_SVC_SUPPLY_FLG , L.PROCESS_INSTANCE , L.DATETIME_ADDED , H.LAST_EXP_CHK_DTTM , L.LAST_DTTM_ORD_UPD , L.LASTUPDDTTM , L.LAST_MAINT_OPRID FROM PS_ORD_HEADER H , PS_ORD_HEADER_LOCK L WHERE %Join(COMMON_KEYS, ORD_HEADER H, ORD_HEADER_LOCK L)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_OM_NONVW

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
Prompt Table: ORD_AN_VW

3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
Prompt Table: CUST_SLD_VW

4 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
Prompt Table: CUST_SLDBLL_VW

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

6 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Prompt Table: CUST_ADDRBLL_VW

7 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To
Prompt Table: CUST_ADDRSHP_VW

8 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
Prompt Table: CUST_ADDRSLD_VW

9 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule

10 ADDR_OVRDSD_FLAG Character(1) VARCHAR2(1) NOT NULL Sold-to Override Level
Y/N Table Edit
Default Value: N

11 ADDTL_ADJUST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment %

12 ADDTL_ADJUST_AMT Signed Number(29,4) DECIMAL(27,4) NOT NULL Adjustment Amount

13 ADDTL_ADJUST_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Adjustment Amount (base)

14 ADDTL_ADJ_BILLED Character(1) VARCHAR2(1) NOT NULL Adjustment Amount Billed
Y/N Table Edit
Default Value: N

15 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm

16 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: PROJ_ANTYPE_FS

17 BACKGROUND_REQD Character(1) VARCHAR2(1) NOT NULL Background Process Required
E=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes
Default Value: N

18 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

19 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
Prompt Table: BI_TYPE_EF_VW

20 BROKER_ID Character(15) VARCHAR2(15) NOT NULL Broker ID

21 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

22 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
Prompt Table: EOEP_ARB_ID_VW

23 CANCEL_DATE Date(10) DATE Cancel Date

24 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: CARRIER_ID

25 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
Prompt Table: CARRIER_ID

26 CC_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Transaction Amount

27 CCARD_APPROVAL_CD Character(10) VARCHAR2(10) NOT NULL Approval Code

28 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes

29 CNTCT_SEQ_BILL Number(5,0) INTEGER NOT NULL Contact Sequence - Bill To
Prompt Table: CUST_CNCT_BL_VW

30 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
Prompt Table: CUST_CNCT_SL_VW

31 COMMSN_LEVEL Character(1) VARCHAR2(1) NOT NULL Commissions Level
0=No Commissions
1=By Header
2=By Schedule

32 COMMSN_METHOD Character(1) VARCHAR2(1) NOT NULL Commission Method
C=Commission Percent
P=Pro-Rata Percent
Default Value: C

33 CONFIRM_PO_RECVD Character(1) VARCHAR2(1) NOT NULL Confirming PO Received
N=No
Y=Yes
Y/N Table Edit
Default Value: N

34 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes

35 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner

36 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner

37 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

38 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

39 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
Prompt Table: VAT_ENT_REG_VW

40 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
Prompt Table: COUNTRY_VAT_VW

41 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed

42 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country

43 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
Prompt Table: ORD_SCN_HDR1_VW

44 CNTRCT_PROTECTED Character(1) VARCHAR2(1) NOT NULL Contract Protected
Y/N Table Edit
Default Value: N

45 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM

46 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
Prompt Table: ORDENT_CCTYP_VW

47 CR_CARD_AMT_BASE Number(27,3) DECIMAL(26,3) NOT NULL Credit Card Base Amount

48 CR_CARD_AUTH_DT Date(10) DATE Credit Card Authorization Date

49 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
Default Value: U

50 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name

51 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name

52 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

53 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

54 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits

55 CREDIT_REQD Character(1) VARCHAR2(1) NOT NULL Credit Check Required
Y/N Table Edit
Default Value: N

56 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

58 CUST_CHANNEL Character(15) VARCHAR2(15) NOT NULL Customer Channel
Prompt Table: ORDENT_CHAN_VW

59 CUSTOM_C10_A Character(10) VARCHAR2(10) NOT NULL Custom Char 10A

60 CUSTOM_C10_B Character(10) VARCHAR2(10) NOT NULL Custom Char 10B

61 CUSTOM_C20_A Character(20) VARCHAR2(20) NOT NULL Custom Char 20A

62 CUSTOM_C20_B Character(20) VARCHAR2(20) NOT NULL Custom Char 20B

63 CUSTOM_C30_A Character(30) VARCHAR2(30) NOT NULL Custom Char 30A

64 CUSTOM_C30_B Character(30) VARCHAR2(30) NOT NULL Custom Char 30B

65 CUSTOM_C40_A Character(40) VARCHAR2(40) NOT NULL Custom Char 40A

66 CUSTOM_C40_B Character(40) VARCHAR2(40) NOT NULL Custom Char 40B

67 CUSTOM_C80_A Character(80) VARCHAR2(80) NOT NULL Custom Char 80A

68 CUSTOM_C80_B Character(80) VARCHAR2(80) NOT NULL Custom Char 80B

69 CUSTOM_DTTM_A DateTime(26) TIMESTAMP Custom DateTime A

70 CUSTOM_DTTM_B DateTime(26) TIMESTAMP Custom DateTime B

71 CUSTOM_DTTM_C DateTime(26) TIMESTAMP Custom DateTime C

72 CUSTOM_DTTM_D DateTime(26) TIMESTAMP Custom DateTime D

73 CUSTOM_DTTM_E DateTime(26) TIMESTAMP Custom DateTime E

74 CUSTOM_DTTM_F DateTime(26) TIMESTAMP Custom DateTime F

75 CUSTOM_DTTM_G DateTime(26) TIMESTAMP Custom DateTime G

76 CUSTOM_DTTM_H DateTime(26) TIMESTAMP Custom DateTime H

77 CUSTOM_DTTM_I DateTime(26) TIMESTAMP Custom DateTime I

78 CUSTOM_DTTM_J DateTime(26) TIMESTAMP Custom DateTime J

79 CUSTOM_DTTM_K DateTime(26) TIMESTAMP Custom DateTime K

80 CUSTOM_DTTM_L DateTime(26) TIMESTAMP Custom DateTime L

81 CUSTOM_DTTM_M DateTime(26) TIMESTAMP Custom DateTime M

82 CUSTOM_DTTM_N DateTime(26) TIMESTAMP Custom DateTime N

83 CUSTOM_DTTM_O DateTime(26) TIMESTAMP Custom DateTime O

84 CUSTOM_DTTM_P DateTime(26) TIMESTAMP Custom DateTime P

85 CUSTOM_DTTM_Q DateTime(26) TIMESTAMP Custom DateTime Q

86 CUSTOM_DTTM_R DateTime(26) TIMESTAMP Custom DateTime R

87 CUSTOM_DTTM_S DateTime(26) TIMESTAMP Custom DateTime S

88 CUSTOM_DTTM_T DateTime(26) TIMESTAMP Custom DateTime T

89 CUSTOM_N12_A Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 A

90 CUSTOM_N12_B Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 B

91 CUSTOM_N12_C Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 C

92 CUSTOM_N12_D Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 D

93 CUSTOM_N12_E Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 E

94 CUSTOM_N15_A Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 A

95 CUSTOM_N15_B Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 B

96 CUSTOM_N15_C Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 C

97 CUSTOM_N15_D Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 D

98 CUSTOM_N15_E Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 E

99 CUSTOMER_COMPANY Character(10) VARCHAR2(10) NOT NULL Customer Company

100 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

101 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
Y/N Table Edit

102 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

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

104 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan

105 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N

106 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes

107 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific

108 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

109 EXPORT_APPL_DT Date(10) DATE Application Date

110 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

111 EXPORT_REC_DT Date(10) DATE Date Received

112 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr

113 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

114 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value

115 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity

116 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping

117 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge

118 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)

119 FREIGHT_TAX_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount

120 FREIGHT_TAX_BASE Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount Base

121 FREIGHT_TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Freight Tax Percent

122 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
Default Value: DOM

123 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: FREIGHT_TERMS

124 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
Prompt Table: FREIGHT_TERMS

125 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

126 HOLD_REQD Character(1) VARCHAR2(1) NOT NULL Hold Processing Required
Y/N Table Edit
Default Value: N

127 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes

128 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

129 IMPORT_APPL_DT Date(10) DATE Application Date

130 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

131 IMPORT_REC_DT Date(10) DATE Date Received

132 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr

133 IMPORT_LIC_EXP Date(10) DATE Expiration Date

134 INITIATED_BY Character(15) VARCHAR2(15) NOT NULL Ordered by

135 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Y/N Table Edit
Default Value: N

136 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
Prompt Table: OMLC_HDR1_VW

137 LOAD_PRICE_RULE Character(10) VARCHAR2(10) NOT NULL Load Arbitration Plan
Prompt Table: EOEP_ARB_LP_VW

138 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes

139 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Default Value: %date

140 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
Prompt Table: ORD_GROUP

141 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
Default Value: O

142 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order

143 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

144 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
Prompt Table: CNTCT_CRCD_PHVW

145 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

146 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
Default Value: S

147 PROD_SUBSTITUTE Character(1) VARCHAR2(1) NOT NULL Allow Product Substitutions
N=No
Y=Yes
Y/N Table Edit
Default Value: Y

148 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJ_BUGL_FVW

149 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: ORDENT_ARTRM_VW

150 QUOTE_DUE_DATE Date(10) DATE Quote Due Date

151 QUOTE_EXPIRE_DT Date(10) DATE Quote Expiration Date

152 QUOTE_NBR Character(15) VARCHAR2(15) NOT NULL Quotation Number
Prompt Table: QUOTE_HEADER_VW

153 QUOTE_REQUESTOR Character(15) VARCHAR2(15) NOT NULL Quote Requester

154 RATE_DATE Date(10) DATE Exchange Rate Date

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

156 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

157 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: REASON_SHIP_VW

158 REF_ORDER_NBR Character(15) VARCHAR2(15) NOT NULL Reference Order Number

159 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival

160 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT

161 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB

162 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS

163 REVISION_NUMBER Number(3,0) SMALLINT NOT NULL Revision

164 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.
Prompt Table: RT_TYPE_TBL

165 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes

166 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes

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

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

169 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
Prompt Table: SHIP_PRIORITY

170 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
Prompt Table: SHIP_PRIORITY

171 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
Prompt Table: CUST_SLDSHP_VW

172 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

173 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
Prompt Table: SHIP_METHOD

174 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
Default Value: N

175 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
Prompt Table: ORD_SOURCE_CD

176 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner

177 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner

178 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State

179 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State

180 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State

181 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed

182 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount

183 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number

184 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Prompt Table: SUBCUST_Q1_TBL

185 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Prompt Table: SUBCUST_Q2_TBL

186 SUCCESS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Success Percent

187 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code
Prompt Table: TEAM_CODE_TBL

188 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
Prompt Table: TAX_HDR_TBL_VW

189 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
Prompt Table: CUST_SHEXMPT_VW

190 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Y/N Table Edit
Default Value: N

191 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net

192 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time

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

194 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.

195 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated

196 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
Y/N Table Edit

197 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.

198 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up

199 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment

200 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group

201 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication

202 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed

203 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

204 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

205 LAST_EXP_CHK_DTTM DateTime(26) TIMESTAMP Last Date/Time Export Comp Chk

206 LAST_DTTM_ORD_UPD DateTime(26) TIMESTAMP Last Order Change Date

207 LASTUPDDTTM 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.

208 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID