IN_FL_DM4_TAO(SQL Table) |
Index Back |
---|---|
Demand tempDedicated temp table containing demand inf_inv, demand inv, ship inf_inv data. Used to hold demand lines for the current processing group. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
3 | 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 |
4 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table: SP_BU_FS_NONVW |
5 | 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 |
6 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
7 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW2 |
9 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
10 | IN_FULFILL_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Inventory Fulfillment State
10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled |
11 | IN_PRIOR_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Inventory Fulfillment State at the time the demand line was cancelled
10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Picking Confirmed 60=Shipped 70=Depleted 90=Canceled |
12 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
13 | GRP_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Group stage table. |
14 | DTL_SEQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Details stage table. |
15 | 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 |
16 | PROCESSING_GROUP | Number(10,0) | DECIMAL(10) NOT NULL | A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level. |
17 | COMMIT_GROUP | Number(10,0) | DECIMAL(10) NOT NULL | A group of data to be committed to the database as one unit of work that may be smaller than the processing group. Commit Group will always be contained within a Processing Group. When processing, if Pass-through Level is greater than the specified Commit Level, the Commit Group will be expanded to include all data at the Pass-through Level. |
18 | DEMAND_DATE | Date(10) | DATE | Demand Date |
19 | REQUEST_DATE | Date(10) | DATE | Requested |
20 | CANCEL_DATE | Date(10) | DATE | Cancel Date |
21 | SCHED_DTTM | DateTime(26) | TIMESTAMP | 08/16/01 JNW (CN#PL900-1.0): Added |
22 | ORIG_SCHED_DTTM | DateTime(26) | TIMESTAMP | Original Schedule Date/Time |
23 | SHIP_DTTM | DateTime(26) | TIMESTAMP | Ship Date/Time |
24 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
25 | PICK_DATE | Date(10) | DATE | Picked Date |
26 | PICK_CONFIRM_DTTM | DateTime(26) | TIMESTAMP | Pick Confirm Date/Time |
27 | ORIG_BU | Character(5) | VARCHAR2(5) NOT NULL | Original Business Unit |
28 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
29 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |
30 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
31 | LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Load ID
Prompt Table: LOAD_INV |
32 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID |
33 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
34 | SHIP_EARLY_DTTM | DateTime(26) | TIMESTAMP | Earliest Ship Date/Time |
35 | SHIP_LATE_DTTM | DateTime(26) | TIMESTAMP | Latest Ship Date/Time |
36 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: FREIGHT_TERMS |
37 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
38 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Distrib. Type
Prompt Table: CM_DISTR_TYPE |
39 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
40 | PICKLIST_LINE_NO | Number(7,0) | INTEGER NOT NULL | Pick List Sorting Line Number |
41 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
42 | PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
43 | KIT_LINE_NBR | Number(3,0) | SMALLINT NOT NULL | Kit Line Number |
44 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
45 | FERC_CD | Character(10) | VARCHAR2(10) NOT NULL |
FERC Code
Prompt Table: FERC_CD_TBL |
46 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
47 | INTERUNIT_LINE | Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
48 | INTERUNIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit
N=No Y=Yes Y/N Table Edit Default Value: N |
49 | INTERUNIT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Status
C=Cancelled I=In-Transit O=Open P=Picked R=Received Default Value: O |
50 | PRICE_MARKUP_PCT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Price Markup % |
51 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_SBU_VW |
52 | 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. |
53 | CUST_NAME | Character(40) | VARCHAR2(40) NOT NULL | Name |
54 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
55 | SHIP_CUST_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Ship To Name |
56 | SHIP_CUST_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Ship To Name 2 |
57 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
58 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
59 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
60 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
61 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
62 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
63 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
64 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
65 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
66 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
67 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
68 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
69 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
70 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
71 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
72 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
73 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
74 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
75 | TAX_EXEMPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit |
76 | TRANSFER_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price |
77 | PACKAGING_CD | Character(4) | VARCHAR2(4) NOT NULL |
Packaging Code
Prompt Table: PACKAGNG_CD_INV |
78 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
79 | QTY_REQUESTED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested |
80 | QTY_REQUESTED_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested Base |
81 | QTY_ALLOCATED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Allocated quantity |
82 | QTY_ALLOC_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity allocation |
83 | QTY_PICKED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Picked |
84 | QTY_SHIPPED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
85 | QTY_SHIPPED_CONV | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
86 | QTY_PICK_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Pick Base |
87 | QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Ship Base |
88 | LAST_QTY_SHIP | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Last Shipped |
89 | LAST_QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'. |
90 | QTY_BACKORDER | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Backorder Qty |
91 | QTY_BACKORDER_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Backorder Base Qty |
92 | QTY_PICK_OVRIDE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Field used to override the net requested quantity when printing the pick play for non-soft reservation items. |
93 | FULFILL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
OK to Pick
Y/N Table Edit Default Value: N |
94 | RESERVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both N=No Y=Yes Y/N Table Edit Default Value: N |
95 | PICKLIST_PRINTED | Character(1) | VARCHAR2(1) NOT NULL |
Picklist Printed
Y/N Table Edit Default Value: N |
96 | CONFIRMED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Confirm
Y/N Table Edit Default Value: N |
97 | HARD_ALLOC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hard Allocate
Y/N Table Edit Default Value: N |
98 | LOT_ALLOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Lot Allocation
Y/N Table Edit Default Value: N |
99 | SHIPPED_MESSAGE | Character(1) | VARCHAR2(1) NOT NULL |
Shipped Message
Y/N Table Edit Default Value: N |
100 | QTY_VERIFY_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Verify Qty
Y/N Table Edit Default Value: N |
101 | APPROVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Approved
B=Both N=No Y=Yes Y/N Table Edit Default Value: N |
102 | SHIP_PRIOR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship Prior to Sched Date
Y/N Table Edit Default Value: N |
103 | 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 |
104 | BCKORDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Backorder Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
105 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Custodian |
106 | CHARGE_CODE | Character(20) | VARCHAR2(20) NOT NULL | Charge Code |
107 | DISTRIB_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
GL Distribution
Y/N Table Edit Default Value: N |
108 | COSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process N=Transaction is Not Costed P=Qualified for Purging X=Transaction Won't be Costed Y=Transaction is Costed Default Value: N |
109 | PARTIAL_QTY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit Default Value: N |
110 | PARTIAL_ORDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No Y=Yes Y/N Table Edit Default Value: N |
111 | AUTO_PICK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag Items for Auto-Pick
Y/N Table Edit |
112 | AUTO_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag Items for Auto-Ship
Y/N Table Edit |
113 | FROZEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Frozen Flag
B=Both N=No Y=Yes Y/N Table Edit Default Value: N |
114 | OM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Order Management Extract Flag
Y/N Table Edit Default Value: N |
115 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table: SHIP_HDR_INV |
116 | SHIP_LINE_NO | Number(10,2) | DECIMAL(9,2) NOT NULL | Ship Line No |
117 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
118 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
119 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL |
Shipment Unit of Measure
Prompt Table: INV_SHIP_UOM_VW |
120 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_ORDR_UOM_VW |
121 | SHIP_UOM_CONV_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
UOM Conversion Flag-Ship Panel
1=Enter Qty in Ordering UOM 2=Enter Qty in Shipping UOM Default Value: 1 |
122 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
123 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
124 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
125 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
126 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
127 | TRANSFER_YIELD | Number(5,1) | DECIMAL(4,1) NOT NULL | Transfer Yield |
128 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
129 | PSSH_NONOWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Non Own Flag
Y/N Table Edit Default Value: N |
130 | INTERUNIT_INSERT | Character(1) | VARCHAR2(1) NOT NULL |
Interunit Insert
Y/N Table Edit Default Value: N |
131 | DEPLETE_INV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Deplete Inventory Flag
Default Value: Y |
132 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
133 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
134 | BILLING_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Status
A=Available B=In Billing C=Contract I=Invoiced N=Not Avail P=In Process S=Staged Default Value: N |
135 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
136 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
137 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
138 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
139 | DIRECT_INVOICING | Character(1) | VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit Default Value: N |
140 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
141 | EDI_DT_TIME | DateTime(26) | TIMESTAMP | EDI DATE TIME STAMP |
142 | BACKORDER_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
Backorder Created Flag
Y/N Table Edit Default Value: N |
143 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
144 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
145 | HOLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hold
N=Hold Y=Hold |
146 | NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Field to specify the notification method - WorkList only, Email only or Worklist and Email
B=Email and Worklist N=None W=WorkList Only |
147 | BACKORDER_ACTION | Character(2) | VARCHAR2(2) NOT NULL |
Backorder Action
01=Cancel Backorder 02=Create Backorder 03=Hold and Notify 04=Release as Shortage 05=Reserve Substitute |
148 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table: HOLD_CD |
149 | CARTON_PRINTED | Character(1) | VARCHAR2(1) NOT NULL |
Carton Print Flag
Y/N Table Edit Default Value: N |
150 | SHIPPING_PRINTED | Character(1) | VARCHAR2(1) NOT NULL |
Shipping Container Print Flag
Y/N Table Edit Default Value: N |
151 | IST_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Distribution Status
A=Awaiting Arrival Processing D=Distributed I=Ignored M=Archival Entry N=Not Distributed R=Reversal Entry S=Awaiting Dispatch Processing U=Undefined Default Value: I |
152 | SHIP_SHORT_WF_DONE | Character(1) | VARCHAR2(1) NOT NULL |
Ship Short WF Notification
Y/N Table Edit Default Value: N |
153 | CURRENCY_CD_DEST | Character(3) | VARCHAR2(3) NOT NULL | Currency Code Dest |
154 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL | Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. |
155 | TRANSFER_COST_DEST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Transfer Price Dest |
156 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
157 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
158 | 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: ROUTE_INV_VW |
159 | ROUTE_STOP_NBR | Number(5,0) | INTEGER NOT NULL | An identifier used to sequence customer addresses/location for a given route. |
160 | PICK_RELEASE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Release ID |
161 | RESERVED_DATE | Date(10) | DATE | Date on which a demand line was soft reserved. |
162 | DEPLETED_DATE | Date(10) | DATE | Date on which a shipped demand line was depleted from on-hand inventory quantity balances. |
163 | BUDGET_DT | Date(10) | DATE | Budget Date |
164 | EXPORT | Character(1) | VARCHAR2(1) NOT NULL |
Export Analytic Instance
N=No Y=Yes Y/N Table Edit Default Value: N |
165 | REPLACEMENT_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods Default Value: NA |
166 | IST_RETURN_FLG_IUT | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat InterUnit Returns
Y/N Table Edit Default Value: N |
167 | IST_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No Y=Yes Default Value: N |
168 | ORIG_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Used to identify the original item ordered, in case an item substitution has taken place. |
169 | ORIG_UOM | Character(3) | VARCHAR2(3) NOT NULL | Original Unit of Measure |
170 | 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 |
171 | FRT_CHRG_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Freight Charge Override
Y/N Table Edit Default Value: N |
172 | FRT_CHRG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value 02=Weight 03=Volume 04=Order Quantity |
173 | FRT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Freight Rule Code |
174 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer PO |
175 | SHIP_ID_EST | Character(10) | VARCHAR2(10) NOT NULL | Estimated Ship ID |
176 | NET_UNIT_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price |
177 | CUST_CONTACT | Character(40) | VARCHAR2(40) NOT NULL | Customer Contact |
178 | ALLOW_OVERPICK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit Default Value: N |
179 | MAX_PICK_TOLERANCE | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the allowable percentage of overshipment for a customer or business unit. |
180 | QTY_PACK_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity Packed |
181 | SINGLE_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
182 | EXT_REF_NBR | Number(10,0) | DECIMAL(10) NOT NULL | External Reference Number |
183 | EXT_REF_LN_NBR | Number(5,0) | INTEGER NOT NULL | External Reference Line Number |
184 | PUB_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
185 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
186 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
187 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
188 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: REASON_SHIP_VW |
189 | 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 Default Value: 0 |
190 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
191 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
192 | TMS_EXT_REF_ID | Character(10) | VARCHAR2(10) NOT NULL | TMS Reference ID |
193 | TMS_EXT_REF_LN_NBR | Number(7,0) | INTEGER NOT NULL | TMS Line Number |
194 | UPDATE_RESTRCT_LVL | Character(1) | VARCHAR2(1) NOT NULL | This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process. |
195 | QTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Bid factor Flag
Y/N Table Edit Default Value: N |
196 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
197 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
198 | UNIT_MEASURE_TXN | Character(3) | VARCHAR2(3) NOT NULL | Transaction Unit of Measure |
199 | FROM_STOR_AREA | Character(5) | VARCHAR2(5) NOT NULL | From storage area |
200 | FROM_STOR_LEV1 | Character(4) | VARCHAR2(4) NOT NULL | From Storage Level 1 |
201 | FROM_STOR_LEV2 | Character(4) | VARCHAR2(4) NOT NULL | From Storage Level 2 |
202 | FROM_STOR_LEV3 | Character(4) | VARCHAR2(4) NOT NULL | From Storage Level 3 |
203 | FROM_STOR_LEV4 | Character(4) | VARCHAR2(4) NOT NULL | From Storage Level 4 |
204 | NEW_ROW | Character(1) | VARCHAR2(1) NOT NULL |
New Row of Information
N=DONOT ALLOW Y=ALLOW |
205 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Hold From Further Processing
Default Value: Y |
206 | IN_LINE_BO_RULE | Character(10) | VARCHAR2(10) NOT NULL | Line Backorder Rule |
207 | IN_LINE_RESV_RULE | Character(10) | VARCHAR2(10) NOT NULL | Line Reservation Rule |
208 | IN_LN_RESV_BO_RULE | Character(10) | VARCHAR2(10) NOT NULL | Line Reservation - Backorder |
209 | IN_ORDER_RESV_RULE | Character(10) | VARCHAR2(10) NOT NULL | Order Reservation Rule |
210 | RESERVED_CRIT_MET | Character(1) | VARCHAR2(1) NOT NULL |
Reserved Flag
Default Value: N |
211 | HOLD_RESERVE_QTY | Character(1) | VARCHAR2(1) NOT NULL | Hold Reservation Quantity |
212 | DESTIN_GL_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination GL Business Unit |
213 | ADDR_OVRD_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Address Override Level
D=Demand Line H=Header L=Line S=Schedule |
214 | VMI_DESTIN_SHIPTO | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
215 | OUTER_MOST_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
216 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
217 | LAST_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
218 | DELIVERY_ID | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
219 | NEW_LINE | Character(1) | VARCHAR2(1) NOT NULL | New Line |
220 | RTV_VERIFIED | Character(1) | VARCHAR2(1) NOT NULL |
RTV Verified
Y/N Table Edit |