ORD_HEADER_SHIP(SQL Table) |
Index Back |
---|---|
Sales Order Mass UpdateUsed 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. |