OCH_NDUPD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ADDR_SEQ_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Address Seq Error Flag Default Value: N
3	ADDR_SEQ_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Address Sequence Number update is pending. Y/N Table Edit Default Value: N
4	ADDR_SEQ_VALID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Address Seq Valid Flag Default Value: Y
5	ADDRESS_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used to denote that the address override is not valid. Default Value: N
6	ADDRESS_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that an address update is pending. Y/N Table Edit Default Value: N
7	AERP_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Automated Exporter Rptg Error Default Value: N
8	AERP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Automated Exporter Rptg Prgm Update
9	AERP_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Automated Exporter Rptg Valid Default Value: Y
10	ALLOW_ITEM_SUB_ERR	Character(1)	VARCHAR2(1) NOT NULL	Allow Item Sub Error Default Value: N
11	ALLOW_ITEM_SUB_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Allow Item Substitution Flag update is pending. Y/N Table Edit Default Value: N
12	ARVL_DTTM_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Scheduled Arrival Date/Time update is pending. Y/N Table Edit Default Value: N
13	CANCEL_BO_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cancel BO Error Flag Default Value: N
14	CANCEL_BO_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Cancel Backorder Flag update is pending. Y/N Table Edit Default Value: N
15	CNCL_BO_SS_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cancel BO Error Flag Default Value: N
16	CARRIER_EXP_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
17	CARRIER_EXP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Carrier ID update is pending. Y/N Table Edit Default Value: N
18	CAR_EXP_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Carrier ID Valid Default Value: Y
19	CARRIER_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
20	CARRIER_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Carrier ID update is pending. Y/N Table Edit Default Value: N
21	CARRIER_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Carrier ID Valid Default Value: Y
22	CCI_REQ_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
23	CCI_REQ_UPD	Character(1)	VARCHAR2(1) NOT NULL	CCI Req Update
24	CCI_REQ_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	CCI Req Exp Valid Flag Default Value: Y
25	CNTCT_SHP_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Contact Ship Error Default Value: N
26	CNTCT_SHP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Contact Ship Seq Update
27	CNTCT_SHP_VAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Contact Ship Seq Valid Default Value: Y
28	COO_REQ_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
29	COO_REQ_UPD	Character(1)	VARCHAR2(1) NOT NULL	COO Req Update
30	COO_REQ_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	COO Req Exp Valid Flag Default Value: Y
31	CUST_PICKUP_ERR	Character(1)	VARCHAR2(1) NOT NULL	Customer Pick-Up Error Default Value: N
32	CUST_PICKUP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Customer Pick-Up Update Default Value: N
33	CUST_PICKUP_VALID	Character(1)	VARCHAR2(1) NOT NULL	Customer Pickup Valid Flag Default Value: Y
34	CUST_PO_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Customer PO Error Flag Default Value: N
35	CUST_PO_UPD	Character(1)	VARCHAR2(1) NOT NULL	Customer PO Update
36	CUST_PO_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Customer PO Valid Flag Default Value: Y
37	DISTRIB_TYPE_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
38	DISTRIB_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Distribution Type update is pending. Y/N Table Edit Default Value: N
39	DIS_TYP_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Distribution Type Valid Default Value: Y
40	EXPORT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
41	EXPORT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Update Flag Y/N Table Edit Default Value: N
42	EXP_LIC_APP_DT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
43	EXP_LIC_APPL_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
44	EXP_LIC_EXP_DT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
45	EXP_LIC_NBR_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
46	EXP_LIC_REC_DT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
47	EXP_LIC_REC_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
48	EXP_LIC_REQ_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
49	EXP_LIC_TYPE_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
50	EXP_LIC_VAL_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
51	EXP_APP_DT_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Appl Dt Valid Flag Default Value: Y
52	EXP_LIC_APP_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Appl Valid Flag Default Value: Y
53	EXP_LIC_EXP_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Expire Valid Flag Default Value: Y
54	EXP_LIC_NBR_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Nbr Valid Flag Default Value: Y
55	EXP_LIC_REC_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Rec Valid Flag Default Value: Y
56	EXP_LIC_REQ_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Req Valid Flag Default Value: Y
57	EXP_LIC_TYP_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Type Valid Flag Default Value: Y
58	EXP_LIC_VAL_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Value Valid Flag Default Value: Y
59	EXP_REC_DT_VALID	Character(1)	VARCHAR2(1) NOT NULL	Export Rec Dt Valid Flag Default Value: Y
60	EXPORT_APPL_DT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Appl Date Upd
61	EXPORT_APPL_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Appl Upd
62	EXPORT_EXPIRE_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Expire Update
63	EXPORT_LIC_REQ_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Update
64	EXPORT_NBR_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Nbr Upd
65	EXPORT_REC_DT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Rec Dt Upd
66	EXPORT_REC_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Rec Update
67	EXPORT_TYPE_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Type Upd
68	EXPORT_VALUE_UPD	Character(1)	VARCHAR2(1) NOT NULL	Export Lic Value Upd
69	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes Default Value: N
70	FRT_TRM_EXP_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
71	FRT_TRM_EXP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Freight Terms update is pending. Y/N Table Edit Default Value: N
72	FRT_EXP_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Freight Terms Valid Default Value: Y
73	FRT_TRM_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
74	FRT_TRM_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Freight Terms update is pending. Y/N Table Edit Default Value: N
75	FRT_TRM_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Freight Terms Valid Default Value: Y
76	ILBR_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Line Backorder Rule Error Default Value: N
77	ILRBR_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Line Resv - Backorder Error Default Value: N
78	ILRR_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Line Reservation Rule Error Default Value: N
79	IMP_LIC_APP_DT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
80	IMP_LIC_APPL_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
81	IMP_LIC_EXP_DT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
82	IMP_LIC_NBR_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
83	IMP_LIC_REC_DT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
84	IMP_LIC_REC_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
85	IMP_LIC_REQ_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
86	IMP_APP_DT_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Appl Dt Valid Flag Default Value: Y
87	IMP_CER_NBR_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Cert Nbr Valid Flag Default Value: Y
88	IMP_LIC_APP_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Appl Valid Flag Default Value: Y
89	IMP_LIC_EXP_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Exp Valid Flag Default Value: Y
90	IMP_LIC_REC_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Rec Valid Flag Default Value: Y
91	IMP_LIC_REQ_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Req Valid Flag Default Value: Y
92	IMP_REC_DT_VALID	Character(1)	VARCHAR2(1) NOT NULL	Import Rec Dt Valid Flag Default Value: Y
93	IMPORT_APPL_DT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Appl Dt Update
94	IMPORT_APPL_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Appl Update
95	IMPORT_CERT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Cert Nbr Update
96	IMPORT_EXP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Exp Update
97	IMPORT_REC_DT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Rec Dt Update
98	IMPORT_REC_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Rec Update
99	IMPORT_REQ_UPD	Character(1)	VARCHAR2(1) NOT NULL	Import Lic Req Update
100	IN_LN_BO_RULE_UPD	Character(1)	VARCHAR2(1) NOT NULL	Line Backorder Rule Update Default Value: N
101	IN_LN_RESV_BO_UPD	Character(1)	VARCHAR2(1) NOT NULL	Line Reservation - Backorder Update Default Value: N
102	IN_LN_RESV_RUL_UPD	Character(1)	VARCHAR2(1) NOT NULL	Line Reservation Rule Update Default Value: N
103	IN_ORD_RES_RUL_UPD	Character(1)	VARCHAR2(1) NOT NULL	Order Reservation Rule Update Default Value: N
104	INTRASTAT_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
105	INTRASTAT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Intrastat Flag update is pending. Y/N Table Edit Default Value: N
106	IORR_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Order Reservation Rule Error Default Value: N
107	KIT_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Kit Valid Flag Default Value: Y
108	LOAD_ID_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
109	LOAD_RESET_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark a Load ID update is pending. Default Value: N
110	LOAD_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark a Load ID update is pending. Y/N Table Edit Default Value: N
111	LOAD_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Load ID Valid Default Value: Y
112	NAFTA_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	N American Free Trade Agmt Err Default Value: N
113	NAFTA_UPD	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt Update
114	NAFTA_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt Valid Default Value: Y
115	OCH_LOAD_CAR_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
116	OCH_LOAD_EXP_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
117	OCH_LOAD_SDT_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
118	OCH_LOAD_STY_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
119	OCH_RT_ASQ_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
120	OCH_RT_CAR_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
121	OCH_RT_EXP_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
122	OCH_RT_SDT_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
123	OCH_RT_STY_VALID	Character(1)	VARCHAR2(1) NOT NULL	OCH Flag Default Value: Y
124	ORDER_STAT_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Order Status Error Default Value: N
125	ORDER_STATUS_UPD	Character(1)	VARCHAR2(1) NOT NULL	Order Status Update Default Value: N
126	PART_ORD_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Partial Order Flag Error Default Value: N
127	PART_ORD_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Partial Order Flag update is pending. Y/N Table Edit Default Value: N
128	PART_QTY_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Parital Quantity Flag Error Default Value: N
129	PART_QTY_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Partial Quantity Flag update is pending. Y/N Table Edit Default Value: N
130	PART_QTY_ORD_ERR	Character(1)	VARCHAR2(1) NOT NULL	Parital Qty/Ord Flag Error Default Value: N
131	PROJECT_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Projects Error Flag Default Value: N
132	PROJECT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Projects Update Flag Default Value: N
133	PROJECT_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Projects Valid Flag Default Value: Y
134	PRIORITY_EXP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Priority update is pending. Y/N Table Edit Default Value: N
135	SHIP_PRI_EXP_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
136	PRIOR_EXP_VAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used to denote that the priority code is valid Default Value: Y
137	SHIP_PRIORITY_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
138	PRIORITY_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Priority update is pending. Y/N Table Edit Default Value: N
139	PRIOR_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used to denote that the priority code is valid Default Value: Y
140	QTY_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Carrier ID update is pending. Default Value: N
141	REASON_CD_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
142	REASON_CD_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark a Reason Code update is pending. Y/N Table Edit Default Value: N
143	RSN_CD_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reason Code Valid Default Value: Y
144	ROUTE_STOP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Route Stop update is pending. Y/N Table Edit Default Value: N
145	STOP_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Route Stop Error Flag Default Value: N
146	ROUTE_DT_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used to set record in error if the carrier/ship via don't match the Route CD entered by the user. Default Value: N
147	ROUTE_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used to set record in error if the carrier/ship via don't match the Route CD entered by the user. Default Value: N
148	ROUTE_SEARCH	Character(1)	VARCHAR2(1) NOT NULL	Route Search Default Value: N
149	ROUTE_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Route CD Valid Default Value: Y
150	ROUTE_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Route Code update is pending. Y/N Table Edit Default Value: N
151	SCHED_ARRV_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
152	SED_REQ_ERR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Shipper Export Declaration Err Default Value: N
153	SED_REQ_UPD	Character(1)	VARCHAR2(1) NOT NULL	Shippers Export Declaration Update
154	SED_REQ_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt Valid Default Value: Y
155	SHIP_EARLY_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
156	SHIP_EARLY_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Ship Early Flag update is pending. Y/N Table Edit Default Value: N
157	SHIP_PRIOR_ERR	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior Error Default Value: N
158	SHIP_PRIOR_UPD	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior Flag Update Y/N Table Edit Default Value: N
159	SHP_DTTM_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Scheduled Ship Date Error Default Value: N
160	SHP_DTTM_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Scheduled Shipping Date/Time update is pending. Y/N Table Edit Default Value: N
161	SHP_TYP_EXP_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
162	SHP_TYP_EXP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Ship Type ID update is pending. Y/N Table Edit Default Value: N
163	SHP_EXP_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Ship Method Valid Default Value: Y
164	SHP_TYPE_ERR	Character(1)	VARCHAR2(1) NOT NULL	Error Flag Default Value: N
165	SHP_TYP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Ship Type ID update is pending. Y/N Table Edit Default Value: N
166	SHP_MTH_VALID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Ship Method Valid Default Value: Y
167	SING_SHIP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Single Shipment Flag update is pending. Y/N Table Edit Default Value: N
168	SING_SHP_ERR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Single Shipment Flag Error Default Value: N
169	SING_SHP_VALID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Carrier ID Valid Default Value: Y