| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 3 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 4 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 5 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 6 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 7 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 8 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 9 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 10 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 11 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 12 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 13 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 14 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 15 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 16 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 17 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 18 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 19 |
APPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Application ID
|
| 20 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 21 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 22 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 23 |
SCHED_DTTM |
DateTime(26) |
TIMESTAMP |
08/16/01 JNW (CN#PL900-1.0): Added
|
| 24 |
SCHED_SHIP_DATE |
Date(10) |
DATE |
Scheduled Ship Date
|
| 25 |
SCHED_SHIP_TIME |
Time(15) |
TIMESTAMP |
Scheduled Ship Time
|
| 26 |
SCHED_ARRV_DTTM |
DateTime(26) |
TIMESTAMP |
Schedule Arrival Dt/Tm
|
| 27 |
SCHED_ARRV_DATE |
Date(10) |
DATE |
Scheduled Arrival Date
|
| 28 |
SCHED_ARRV_TIME |
Time(15) |
TIMESTAMP |
Scheduled Arrival Time
|
| 29 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 30 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 31 |
DISTRIB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Distrib. Type
|
| 32 |
CNTCT_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Contact Name1
|
| 33 |
CNTCT_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Ship To
|
| 34 |
CUST_PICKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No
Y=Yes
Y/N Table Edit
|
| 35 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 36 |
CUSTOMER_PO_UPD |
Character(25) |
VARCHAR2(25) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
|
| 37 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 38 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 39 |
SHIP_PRIORITY_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Shipping Priority Code
|
| 40 |
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.
|
| 41 |
ROUTE_STOP_NBR |
Number(5,0) |
INTEGER NOT NULL |
An identifier used to sequence customer addresses/location for a given route.
|
| 42 |
LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Load ID
|
| 43 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 44 |
PARTIAL_ORDER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No
Y=Yes
|
| 45 |
SINGLE_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No
Y=Yes
|
| 46 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
|
| 47 |
EXPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No
Y=Yes
|
| 48 |
SHIP_PRIOR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
|
| 49 |
BCKORDR_CNCL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit
Default Value: N
|
| 50 |
ALLOW_SUB_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate whether item substitutions are allowed on the order schedule.
Y/N Table Edit
Default Value: N
|
| 51 |
INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
|
| 52 |
ORD_SCH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
|
| 53 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 54 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 55 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 56 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax Number
|
| 57 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 58 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
|
| 59 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
|
| 60 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
|
| 61 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
|
| 62 |
CLR_AERP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Automated Exporter Rptg
Y/N Table Edit
Default Value: N
|
| 63 |
CLR_CARRIER_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Carrier ID
Y/N Table Edit
Default Value: N
|
| 64 |
CLR_DISTRIB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Distribution Type
Y/N Table Edit
Default Value: N
|
| 65 |
CLR_FREIGHT_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Freight Amount
Y/N Table Edit
Default Value: N
|
| 66 |
CLR_FREIGHT_TERMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Freight Terms
Y/N Table Edit
Default Value: N
|
| 67 |
CLR_IN_LN_BO_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Automated Exporter Rptg
Y/N Table Edit
Default Value: N
|
| 68 |
CLR_IN_LN_RESV_BO |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Line Resv - Backorder
Y/N Table Edit
Default Value: N
|
| 69 |
CLR_IN_LN_RESV_RUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Line Reservation Rule
Y/N Table Edit
Default Value: N
|
| 70 |
CLR_IN_ORD_RES_RUL |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Order Reservation Rule
Y/N Table Edit
Default Value: N
|
| 71 |
CLR_INTERUNIT_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Interunit Status
Y/N Table Edit
Default Value: N
|
| 72 |
CLR_LOAD_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Load ID
Y/N Table Edit
Default Value: N
|
| 73 |
CLR_NAFTA |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear North American Free Trade Agmt
Y/N Table Edit
Default Value: N
|
| 74 |
CLR_REASON_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Reason CD
Y/N Table Edit
Default Value: N
|
| 75 |
CLR_ROUTE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Route Code
Y/N Table Edit
Default Value: N
|
| 76 |
CLR_ROUTE_STOP_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Route Stop Number
Y/N Table Edit
Default Value: N
|
| 77 |
CLR_SED_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear North American Free Trade Agmt
Y/N Table Edit
Default Value: N
|
| 78 |
CLR_SHIP_TYPE_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if user wants blank value to be used for update of ship type id
Y/N Table Edit
Default Value: N
|
| 79 |
CLR_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Priority Number
Y/N Table Edit
Default Value: N
|
| 80 |
CLR_PROJECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Project
|
| 81 |
CLR_CARRIER_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Carrier ID
Y/N Table Edit
Default Value: N
|
| 82 |
CLR_FRT_TRM_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Freight Terms
Y/N Table Edit
Default Value: N
|
| 83 |
CLR_PRIORITY_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Priority Number
Y/N Table Edit
Default Value: N
|
| 84 |
CLR_SHIP_TYPE_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if user wants blank value to be used for update of ship type id
Y/N Table Edit
Default Value: N
|
| 85 |
CLR_ADDRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to denote that the address should be cleared on the demand lines.
Y/N Table Edit
Default Value: N
|
| 86 |
CLR_CCI_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Canadian Customs Invoice
Y/N Table Edit
Default Value: N
|
| 87 |
CLR_CNTCT_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Ship Contact
Default Value: N
|
| 88 |
CLR_CUST_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Customer PO
|
| 89 |
CLR_COO_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Certificate of Origin
Y/N Table Edit
Default Value: N
|
| 90 |
CLR_EXPORT_APPL_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export Applied Date
Y/N Table Edit
Default Value: N
|
| 91 |
CLR_EXPORT_LIC_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export License Applied
Y/N Table Edit
Default Value: N
|
| 92 |
CLR_EXPORT_LIC_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export License Expired
Y/N Table Edit
Default Value: N
|
| 93 |
CLR_EXPORT_LIC_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export License Number
Y/N Table Edit
Default Value: N
|
| 94 |
CLR_EXPORT_LIC_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export License Received
Y/N Table Edit
Default Value: N
|
| 95 |
CLR_EXPORT_LIC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export Licence Required
Y/N Table Edit
Default Value: N
|
| 96 |
CLR_EXPORT_LIC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export License Type
Y/N Table Edit
Default Value: N
|
| 97 |
CLR_EXPORT_LIC_VAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export License Value
Y/N Table Edit
Default Value: N
|
| 98 |
CLR_EXPORT_REC_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Export Received Date
Y/N Table Edit
Default Value: N
|
| 99 |
CLR_IMPORT_APPL_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import Application Date
Y/N Table Edit
Default Value: N
|
| 100 |
CLR_IMPORT_CERT_NB |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import License Number
Y/N Table Edit
Default Value: N
|
| 101 |
CLR_IMPORT_LIC_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import License Applied
Y/N Table Edit
Default Value: N
|
| 102 |
CLR_IMPORT_LIC_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import Expiration Date
Y/N Table Edit
Default Value: N
|
| 103 |
CLR_IMPORT_LIC_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import License Received
Y/N Table Edit
Default Value: N
|
| 104 |
CLR_IMPORT_LIC_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import License Required
Y/N Table Edit
Default Value: N
|
| 105 |
CLR_IMPORT_REC_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Import Date Received
Y/N Table Edit
Default Value: N
|
| 106 |
CAR_LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier
|
| 107 |
CAR_ROUTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier
|
| 108 |
SHIP_TYPE_LOAD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 109 |
SHIP_TYPE_ROUTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 110 |
ADDRESS_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to mark that an address update is pending.
Y/N Table Edit
Default Value: N
|
| 111 |
AERP |
Character(50) |
VARCHAR2(50) NOT NULL |
Automated Exporter Rptg Prgm
|
| 112 |
CARRIER_ID_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Carrier ID
|
| 113 |
SHIP_TYPE_ID_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Shipping Method
|
| 114 |
FREIGHT_TERMS_EXP |
Character(10) |
VARCHAR2(10) NOT NULL |
Export Freight Terms Code
|
| 115 |
SHIP_PRIORITY_EXP |
Character(6) |
VARCHAR2(6) NOT NULL |
Export Shipping Priority
|
| 116 |
CCI_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Canadian Customs Invoice
N=No
Y=Yes
|
| 117 |
COO_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Certificate of Origin
N=No
Y=Yes
|
| 118 |
EXPORT_LIC_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Export License Required
NO=No
YES=Yes
|
| 119 |
EXPORT_LIC_APPL |
Character(3) |
VARCHAR2(3) NOT NULL |
Applied For
NO=No
YES=Yes
|
| 120 |
EXPORT_LIC_REC |
Character(3) |
VARCHAR2(3) NOT NULL |
License Received
NO=No
YES=Yes
|
| 121 |
EXPORT_LIC_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Export License Nbr
|
| 122 |
EXPORT_LIC_VALUE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
License Value
|
| 123 |
EXPORT_LIC_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
License Type
GDST=General
SPEC=Specific
|
| 124 |
EXPORT_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 125 |
EXPORT_REC_DT |
Date(10) |
DATE |
Date Received
|
| 126 |
EXPORT_LIC_EXPIRE |
Date(10) |
DATE |
Expiration Date
|
| 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_LIC_REC |
Character(3) |
VARCHAR2(3) NOT NULL |
License Received
NO=No
YES=Yes
|
| 130 |
IMPORT_CERT_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Import License Nbr
|
| 131 |
IMPORT_APPL_DT |
Date(10) |
DATE |
Application Date
|
| 132 |
IMPORT_REC_DT |
Date(10) |
DATE |
Date Received
|
| 133 |
IMPORT_LIC_EXP |
Date(10) |
DATE |
Expiration Date
|
| 134 |
NAFTA_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
North American Free Trade Agmt
N=No
Y=Yes
|
| 135 |
SED_REQ_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Shippers Export Declaration
N=No
Y=Yes
|
| 136 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 137 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 138 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 139 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 140 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 141 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 142 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 143 |
ERROR_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 144 |
SUCCESS_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 145 |
HEADER_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
|
| 146 |
LINE_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Initials Issuse Description
032307 LPL F-CJORG-A5ZU6 New field
|
| 147 |
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.
Default Value: %datetime
|
| 148 |
AE_LONG_CHUNK6 |
Long Character(1024) |
VARCHAR2(1024) |
Used in AE processes to store dynamically built sql
|