IN_FL_SHIP_AET(SQL Table) |
Index Back |
---|---|
Shipping State RecordUsed 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 |