IN_FL_SHIP_AET

(SQL Table)
Index Back

Shipping State Record

Used in the fulfillment shipping AE as the default state record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SHIP_LINE_CNT_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Line Count Error Flag
3 ADDRESS_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Used to denote that the address override is not valid.
4 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
5 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
6 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
7 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
10 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
11 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
12 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
13 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
16 DEMAND_LINE_NEW Number(4,0) SMALLINT NOT NULL Demand Line No
17 ADHOC_REQ_FLG Character(1) VARCHAR2(1) NOT NULL Create Adhoc Requisitions
18 REPLENISH_ID Number(10,0) DECIMAL(10) NOT NULL Replenish ID
19 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
20 REPLENISH_LEAD Signed Number(16,2) DECIMAL(14,2) NOT NULL Replenish Lead (Days)
21 EXPECTED_DATE Date(10) DATE Expected By
22 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
23 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes
24 DPI_ROW_COUNT Number(15,0) DECIMAL(15) NOT NULL Demand Phys Row Count
25 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
26 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
27 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
28 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
29 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
30 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
31 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
32 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
33 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
34 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
35 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
36 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
37 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
38 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
39 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
40 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
41 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
42 STAGED_DATE Date(10) DATE Staged Date
43 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure
44 CFG_COST_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Costing
45 CM_METHOD Character(2) VARCHAR2(2) NOT NULL 8/20/02 lee: added xlate 9 for retroactive perp average 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average
46 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
47 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
48 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
49 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
50 DFLT_ACTUAL_COST Number(15,4) DECIMAL(14,4) NOT NULL Default Actual Cost
51 AVERAGE_COST Number(15,4) DECIMAL(14,4) NOT NULL Average Purchase Price
52 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
53 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest
54 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
55 DFLT_IUNIT_PREFIX Character(1) VARCHAR2(1) NOT NULL Default InterUnit ID Prefix
56 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
57 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
58 IUNIT_ID_COUNTER Number(9,0) DECIMAL(9) NOT NULL InterUnit ID Counter
59 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
60 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID
61 KIT_QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Kit Quantity Shipped
62 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
63 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
64 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
65 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
66 SHIP_SERIAL_ERROR Character(1) VARCHAR2(1) NOT NULL Ship Serial Error Flag
67 EST_SHIP_ID_ERR Character(1) VARCHAR2(1) NOT NULL Estimated Ship ID Error
68 DEALLOCATE_ERROR Character(1) VARCHAR2(1) NOT NULL Deallocation Error
69 SHIP_CNTR_UOM_ERR Character(1) VARCHAR2(1) NOT NULL
70 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
71 SHIPPING_ID Number(10,0) DECIMAL(10) NOT NULL Shipping ID
72 COUNTER9 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
73 SETID Character(5) VARCHAR2(5) NOT NULL SetID
74 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit
75 PASS_THROUGH_LEVEL Character(2) VARCHAR2(2) NOT NULL Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line
76 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
77 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
78 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
79 LLS_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Location / :pt / Serial stage table.
80 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
81 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
82 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
83 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
84 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
85 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
86 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.
87 PICK_BATCH_FROM Number(10,0) DECIMAL(10) NOT NULL From Pick Batch ID
88 PICK_BATCH_TO Number(10,0) DECIMAL(10) NOT NULL To Pick Batch ID
89 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
90 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
91 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
92 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
93 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance
94 AE_LONG_CHUNK1 Character(254) VARCHAR2(254) NOT NULL An internal work field required in order to process character string data within the Cash Position Wor
95 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
96 DTTM_STAMP_SEC 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.
97 CANCEL_INDICATOR Number(1,0) SMALLINT NOT NULL Cancel Indicator for PO Lookup
98 TEMPORARY_FLG Character(1) VARCHAR2(1) NOT NULL Temporary
99 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
100 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
101 TRANS_DTL_ERR_FLAG Character(1) VARCHAR2(1) NOT NULL Transaction Dtl Errors
102 CTNR_AE_COUNTER Number(10,0) DECIMAL(10) NOT NULL Auto Container AE Counter
103 PROCESS_MODE Character(2) VARCHAR2(2) NOT NULL Run Mode
JB=Job Mode
ON=Online Mode
PR=Process Mode
TR=Transaction Mode
104 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.
105 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
106 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
107 PACK_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Pack Qty Error Flag

Y/N Table Edit

Default Value: N

108 CONVERT_UOM_FLG Character(1) VARCHAR2(1) NOT NULL Convert Unit of Measure
109 KIT_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Kit Processing Enables
110 KIT_CMPS_SPLIT_FLG Character(1) VARCHAR2(1) NOT NULL Kit Comps Split across Demand
111 KIT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Kit Processing Error Flag
112 ADHOC_PRESENT_FLAG Character(1) VARCHAR2(1) NOT NULL Adhocs Present
113 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
114 MULT_CLAUSES_FLAG Character(1) VARCHAR2(1) NOT NULL Multiple Select Clauses Flag

Default Value: N

115 GROUP_SCNT_FLAG Character(1) VARCHAR2(1) NOT NULL Group Ship Cntr Flag
116 DFLT_INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Default Lot ID
117 DFLT_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Default Serial ID
118 DFLT_STAGED_DATE Date(10) DATE Default Staged Date
119 ADD_DTL_TRANS_FLAG Character(1) VARCHAR2(1) NOT NULL Add Detail Transaction Flag
120 GROUP_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Group Processing Flag
121 ADDRESS_USE Character(1) VARCHAR2(1) NOT NULL Address Usage
B=Bill To
S=Ship To
122 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

123 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
124 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
125 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
126 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
127 CITY Character(30) VARCHAR2(30) NOT NULL City
128 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
129 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
130 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
131 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
132 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
133 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
134 COUNTY Character(30) VARCHAR2(30) NOT NULL County
135 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

136 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
137 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
138 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

139 SHIP_ID_EXIST_FLAG Character(1) VARCHAR2(1) NOT NULL Ship ID Exists
140 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
141 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
142 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
143 DTL_BUTTON Character(1) VARCHAR2(1) NOT NULL Detail Button
144 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
145 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
146 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
147 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
148 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
149 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
150 GROUP_COUNT Number(10,0) DECIMAL(10) NOT NULL Selected Count
151 RUNDATE Date(10) DATE Process Scheduler Run Date
152 STAGING_ID Number(15,0) DECIMAL(15) NOT NULL Putaway Staging ID
153 IN_FL_TEMP_TBL_IND Character(1) VARCHAR2(1) NOT NULL Temp Table Indicator
154 SHIP_VALIDATE_WARN Character(1) VARCHAR2(1) NOT NULL Ship Valdt Warning Already giv

Default Value: N

155 WORK_CNT1 Number(10,0) DECIMAL(10) NOT NULL Work Count 1
156 WORK_CNT1B Number(10,0) DECIMAL(10) NOT NULL Working Count 1B
157 WORK_CNT2 Number(10,0) DECIMAL(10) NOT NULL Work Count 2
158 WORK_CNT2C Number(10,0) DECIMAL(10) NOT NULL Count the Releasable Rows Not shipped
159 WORK_CNT2B Number(10,0) DECIMAL(10) NOT NULL Work Count 2b
160 WORK_CNT3 Number(10,0) DECIMAL(10) NOT NULL Work Count 3
161 WORK_CNT4 Number(10,0) DECIMAL(10) NOT NULL Work Count 4
162 WORK_CNT5 Number(10,0) DECIMAL(10) NOT NULL Work Count 5
163 WORK_CNT6 Number(10,0) DECIMAL(10) NOT NULL Work Count 6
164 WORK_CNT7 Number(10,0) DECIMAL(10) NOT NULL Work Count 7
165 WORK_CNT8 Number(8,0) INTEGER NOT NULL Count of Anything
166 WORK_CNT9 Number(8,0) INTEGER NOT NULL Count of Anything
167 WORK_CNT10 Number(8,0) INTEGER NOT NULL Count of Anything
168 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
169 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
170 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
171 SHP_DTTM_ERR_FLG Character(1) VARCHAR2(1) NOT NULL Scheduled Ship Date Error