ORD_HEADER_SHIP

(SQL Table)
Index Back

Sales Order Mass Update

Used for sales order Mass Update Date Initials Issue Description 091801 dms F-CJORGENS-11 Add REASON_CD

# 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
3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

Prompt Table: SP_BUIN_NONVW

4 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm
5 SEL_AERP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

6 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
7 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: %EDITTABLE8

8 SEL_CARRIER_ID Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

9 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

Prompt Table: %EDITTABLE8

10 SEL_CARRIER_ID_EXP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

11 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
12 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
13 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes
14 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

15 SELECT_DISTR_TYPE Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

16 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
17 EXPORT_APPL_DT Date(10) DATE Application Date
18 SELECT_EXP_APPL_DT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

19 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
20 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
21 SELECT_EXP_LIC_EXP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

22 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
23 SELECT_EXP_LIC_NBR Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

24 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
25 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
26 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific
27 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value
28 SELECT_EXP_LIC_VAL Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

29 EXPORT_REC_DT Date(10) DATE Date Received
30 SELECT_EXP_REC_DT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

31 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: %EDITTABLE7

32 SEL_FRT_TERMS Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

33 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

Prompt Table: %EDITTABLE7

34 SEL_FRT_TERMS_EXP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

35 IMPORT_APPL_DT Date(10) DATE Application Date
36 SELECT_IMP_APPL_DT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

37 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
38 SELECT_IMP_CERTNBR Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

39 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes
40 IMPORT_LIC_EXP Date(10) DATE Expiration Date
41 SELECT_IMP_LIC_EXP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

42 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes
43 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
44 IMPORT_REC_DT Date(10) DATE Date Received
45 SELECT_IMP_REC_DT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

46 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule

Prompt Table: IN_RULE_B_VW

47 SEL_IN_LN_BO_RULE Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

48 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule

Prompt Table: IN_RULE_R_VW

49 SEL_IN_LN_RESV_RUL Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

50 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder

Prompt Table: IN_RULE_R_VW

51 SEL_IN_LN_RESV_BO Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

52 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule

Prompt Table: IN_RULE_O_VW

53 SEL_IN_ORD_RES_RUL Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

54 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
55 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: %EDITTABLE12

56 SELECT_LOAD_ID Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

57 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
58 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: REASON_SHIP_VW

59 SELECT_REASON_CD Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

60 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

Prompt Table: %EDITTABLE13

61 SELECT_ROUTE_CD Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

62 SCHED_ARRV_DATE Date(10) DATE Scheduled Arrival Date
63 SCHED_ARRV_TIME Time(15) TIMESTAMP Scheduled Arrival Time
64 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
65 SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
66 SELECT_SCH_ARRV_DT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

67 SELECT_SCH_SHIP_DT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

68 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
69 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
70 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes
71 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

Prompt Table: %EDITTABLE6

72 SEL_SHIP_PRI_EXP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

73 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

Prompt Table: %EDITTABLE6

74 SEL_SHIP_PRIORITY Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

75 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes
76 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: %EDITTABLE4

77 SEL_SHIP_TYPE_ID Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

78 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

Prompt Table: %EDITTABLE4

79 SEL_SHIP_TYPE_EXP Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

80 SELECT_CUST_PO Character(1) VARCHAR2(1) NOT NULL Date Initials Issuse Description 032307 LPL F-CJORG-A5ZU6 New field

Y/N Table Edit

Default Value: N

81 CUSTOMER_PO_UPD Character(25) VARCHAR2(25) NOT NULL Date Initials Issuse Description 032307 LPL F-CJORG-A5ZU6 New field
82 SEL_PROJECT Character(1) VARCHAR2(1) NOT NULL Select Project

Y/N Table Edit

Default Value: N

83 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
84 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
85 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
86 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
87 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
88 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
89 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
90 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
91 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
92 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.