BCT_E_MG_MCP_VW(SQL View) |
Index Back |
---|---|
BCTP Detail Mfg CompletionView990105 nas (CN# EN800-6.0) New barcode - Added output fields nas 01-21-99 (cn# EN800-1.0) Added substitute key 990125 nas (CN# SF800-10.0) Added Changed Actual Hours fields 990202 nas (CN# EN800-6.0) Added and moved fields around. 990209 nas (CN#EN800-6.0) Renamed MG_OUTPUT_QTY for MG_NEW_OUTPUT_QTY. 990223 nas (CN# EN800-6.0) Made MG_OUTPUT_COMPL signed and added MG_OUTPUT_SEQ 990316 nas (CN#EN800-1.0) Added SUB_ITM_ID 042299 nas: added Inventory fields (Merge) 061599 nas: Added Purch new fields (Supplier Lot & tag number) 092899 nas: Added MG_ISSUE_COMP_FLG for MES EIP 112299 nas: Added Inv.'s fields per D.P. 000121 nas: Added INV and MFG fields #136 - 144 011703 pwf: Modified sql to ensure the fields and sql are consistent. 062204 PWF Change sched line no to sched line nbr |
SELECT a.BUSINESS_UNIT , a.EIP_CTL_ID , a.MG_OUTPUT_SEQ , a.MG_OUTPUT_ITEM , a.SEQ_NBR , a.TRANSACTION_CODE , a.MG_OUTPUT_TYPE , a.LAST_DTTIME , a.BCT_DET_STATUS , a.STAGED_DATE , a.INV_LOT_ID , a.INV_ITEM_ID , a.SERIAL_ID , a.NEW_SERIAL , a.STORAGE_AREA , a.STOR_LEVEL_1 , a.STOR_LEVEL_2 , a.STOR_LEVEL_3 , a.STOR_LEVEL_4 , a.CONTAINER_ID , a.UNIT_OF_MEASURE , a.RECEIVER_ID , a.RECV_LN_NBR , a.TO_CONTAINER_ID , a.TO_STORAGE_AREA , a.TO_STOR_LEVEL_1 , a.TO_STOR_LEVEL_2 , a.TO_STOR_LEVEL_3 , a.TO_STOR_LEVEL_4 , a.QTY , a.COMPLETE_FLG , a.PRODUCTION_ID , a.PRDN_AREA_CODE , a.COMPL_OP_SEQ , a.UPDATE_OP_SEQ , a.PICK_BATCH_ID , a.PICKLIST_LINE_NO , a.COMPONENT_ID , a.COMPL_QTY , a.SCRAPPED_QTY , a.REASON_CD , a.PERCENT_COMP , a.DISTRIB_TYPE , a.TO_PRODUCTION_ID , a.PTWY_PLAN_ID , a.PTWYPLAN_LN_NBR , a.SHIP_CNTR_ID , a.DEMAND_SOURCE , a.SOURCE_BUS_UNIT , a.ORDER_NO , a.ORDER_INT_LINE_NO , a.SCHED_LINE_NBR , a.DEMAND_LINE_NO , a.QTY_CODE , a.OP_SEQUENCE , a.PEND_CONSUME_QTY , a.PEND_LOSS_QTY , a.REVISION , a.DEVICE_DTTIME , a.UOM_ORIG , a.ORIG_CONSUMED_QTY , a.ORIG_COMP_LOSS_QTY , a.YIELD_QTY , a.SHIPTO_SETID , a.SHIPTO_ID , a.VENDOR_ID , a.SHIPMENT_NO , a.CARRIER_ID , a.BILL_OF_LADING , a.BUSINESS_UNIT_PO , a.PO_ID , a.LINE_NBR , a.END_TRANS_FLG , a.ADJUST_TYPE , a.DOCUMENT_ID , a.EIP_TRANS_SRC_SEQ , a.PACKSLIP_NO , a.BUSINESS_UNIT_IN , a.INTERUNIT_ID , a.INTERUNIT_LINE , a.CONFIG_CODE , a.UNIT_MEASURE_COUNT , a.SHIP_ID , a.SHIP_LINE_NO , a.SHIP_DATE , a.SHIP_TIME , a.SHIP_TYPE_ID , a.FREIGHT_TERMS , a.PRO_NUMBER , a.SHIP_FLAG , a.BOM_CODE , a.RTG_CODE , a.SF_BOM_RTG_EFFDT , a.MG_NEW_OUTPUT_QTY , a.MG_OUTPUT_RES_PCT , a.MG_OUTPUT_COMPL , a.BOM_QTY , a.MG_UNPLAN_OUTPUT , a.MG_TRANS_UOM , a.MG_OUTPUT_QTY_CODE , a.MG_RELATED_TRANS , a.CREW_RPT_FLAG , a.MACH_RPT_FLAG , a.CREWSIZE , a.MACH_RESOURCES , a.LAB_SETUP , a.LAB_RUN , a.LAB_FIXED_RUN , a.LAB_POSTPROD , a.MACH_SETUP , a.MACH_RUN , a.MACH_FIXED_RUN , a.MACH_POSTPROD , a.WORK_CENTER_CODE , a.SF_ENTRY_DATE , a.MG_ORIG_COMP_ID , a.MG_ORIG_QTY_PER , a.PARENT_ITEM_ID , a.SUB_ITM_ID , A.VENDOR_LOT_ID , A.TAG_NUMBER , A.MG_ISSUE_COMP_FLG , A.INV_CART_ID , A.COMPARTMENT , A.COUNT_ORDER , A.CART_COUNT_QTY , A.QTY_OPTION , A.SUFFICIENT_STOCK , A.IU_REC_ID_GRP_FLG , A.IU_REC_SEL_GRP_FLG , A.SPEEDTYPE_KEY , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.SYNCH_FLAG , A.COUNTING_EVENT_ID , A.PORT_OF_UNLOADING , A.IST_RETURN_FLG_IUT , A.REPLACEMENT_FLG , A.PARENT_SHIP_CNTR , A.SF_KANBAN_ID , A.FREIGHT_AMT , A.FREIGHT_CURRNCY_CD , A.GROSS_WEIGHT , A.UNIT_MEASURE_WT , A.VNDR_LOC FROM PS_BCT_DTL A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
3 | MG_OUTPUT_SEQ | Number(4,0) | SMALLINT NOT NULL | NAS 022399 (CN# EN800-6.0) Field required for Message Agent definition of Multiple Outputs Completion. |
4 | MG_OUTPUT_ITEM | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id. |
5 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
6 | TRANSACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
7 | MG_OUTPUT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste |
8 | LAST_DTTIME | DateTime(26) | TIMESTAMP | Last Date Time |
9 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
10 | STAGED_DATE | Date(10) | DATE | Staged Date |
11 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
12 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: SF_OUTPUT_LIST |
13 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
14 | NEW_SERIAL | Character(20) | VARCHAR2(20) NOT NULL | New Serial ID mmt 09/18/03 Adding label for use on mult out compl wedge |
15 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
16 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
17 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
18 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
19 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
20 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
21 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
22 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
23 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
24 | TO_CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
25 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
26 | TO_STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
27 | TO_STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
28 | TO_STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
29 | TO_STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
30 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
31 | COMPLETE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location 1=Pick Line Complete 2=Pick Batch Complete 3=Pick Line as Planned 4=Pick Batch as Planned 5=Process Location - Incomplete 6=Complete Pick - Zero Quantity 7=Complete Pick - Leave Alone 8=Complete Pick - Dft Ship Loc A=Use Defaults B=No Action |
32 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
33 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
34 | COMPL_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Completion Operation Sequence |
35 | UPDATE_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Back Thru Operation |
36 | PICK_BATCH_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pick Batch ID |
37 | PICKLIST_LINE_NO | Number(7,0) | INTEGER NOT NULL | Pick List Sorting Line Number |
38 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
39 | COMPL_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
40 | SCRAPPED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
41 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
42 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
43 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
44 | TO_PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | To Production ID |
45 | PTWY_PLAN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Putaway Plan ID |
46 | PTWYPLAN_LN_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Putaway Line Number |
47 | SHIP_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |
48 | 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 |
49 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
50 | 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 |
51 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
52 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
53 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
54 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
55 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
56 | PEND_CONSUME_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME |
57 | PEND_LOSS_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS |
58 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
59 | DEVICE_DTTIME | DateTime(26) | TIMESTAMP | Device Date Time |
60 | UOM_ORIG | Character(3) | VARCHAR2(3) NOT NULL | Original Unit of Measure |
61 | ORIG_CONSUMED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Original Consumed Quantity |
62 | ORIG_COMP_LOSS_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Original Component Loss Qty |
63 | YIELD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY |
64 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
65 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
66 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
67 | SHIPMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Shipment Number |
68 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
69 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
70 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
71 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
72 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
73 | END_TRANS_FLG | Character(1) | VARCHAR2(1) NOT NULL | End of Transaction Flag |
74 | ADJUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only A=VMI Return D=Decrease I=Increase M=Misc Issue R=Misc Return S=Scrap V=Scrap RTV |
75 | DOCUMENT_ID | Character(12) | VARCHAR2(12) NOT NULL | Document |
76 | EIP_TRANS_SRC_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Source Transaction Sequence |
77 | PACKSLIP_NO | Character(22) | VARCHAR2(22) NOT NULL | Packing Slip Number |
78 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
79 | INTERUNIT_ID | Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
80 | INTERUNIT_LINE | Number(5,0) | INTEGER NOT NULL | InterUnit Order Line |
81 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
82 | UNIT_MEASURE_COUNT | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
83 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
84 | SHIP_LINE_NO | Number(10,2) | DECIMAL(9,2) NOT NULL | Ship Line No |
85 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
86 | SHIP_TIME | Time(15) | TIMESTAMP | Ship Time |
87 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
88 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
89 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
90 | SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Shippable |
91 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
92 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
93 | SF_BOM_RTG_EFFDT | Date(10) | DATE | 12/28/98,eyz, CN#EN800-4.0, new this as a workfield in Completions for the Recipe Management feature. |
94 | MG_NEW_OUTPUT_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item quantity on a Bill of Materials. This value is assumed to be in the UOM of the output item it's associated to. |
95 | MG_OUTPUT_RES_PCT | Number(3,0) | SMALLINT NOT NULL | 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item's resource allocation percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the inputs (components) on the BOM are used to produce the output (co-product). |
96 | MG_OUTPUT_COMPL | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 990105 nas (CN# EN800-6.0) This field will contain the user inputted quantity completed of a specific output within completion process. |
97 | BOM_QTY | Number(7,0) | INTEGER NOT NULL | 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard. |
98 | MG_UNPLAN_OUTPUT | Character(1) | VARCHAR2(1) NOT NULL | 01/19/99 nas (CN#800-6.0) Created new field. |
99 | MG_TRANS_UOM | Character(3) | VARCHAR2(3) NOT NULL | 01/19/99 NAS (CN#800-6.0) Created new field |
100 | MG_OUTPUT_QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
01/28/98 (CN#EN800-6.0) LAJ...Created
Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly ORD=Order |
101 | MG_RELATED_TRANS | Character(25) | VARCHAR2(25) NOT NULL | Related Transaction Control Id |
102 | CREW_RPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Crew Reporting |
103 | MACH_RPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Machine Reporting |
104 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
105 | MACH_RESOURCES | Number(7,2) | DECIMAL(6,2) NOT NULL | Machine Resources |
106 | LAB_SETUP | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Labor Setup |
107 | LAB_RUN | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Labor Run |
108 | LAB_FIXED_RUN | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Labor Fixed Run |
109 | LAB_POSTPROD | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Labor Post Production |
110 | MACH_SETUP | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Machine Setup |
111 | MACH_RUN | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Machine Run |
112 | MACH_FIXED_RUN | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Machine Fixed Run |
113 | MACH_POSTPROD | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Machine Post Production |
114 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
115 | SF_ENTRY_DATE | Date(10) | DATE | Entry Date |
116 | MG_ORIG_COMP_ID | Character(18) | VARCHAR2(18) NOT NULL | original component ID |
117 | MG_ORIG_QTY_PER | Number(16,10) | DECIMAL(15,10) NOT NULL | original qty per |
118 | PARENT_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Item ID |
119 | SUB_ITM_ID | Character(18) | VARCHAR2(18) NOT NULL | 11/30/99 RML Added label "Substitute" |
120 | VENDOR_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Vendor Lot |
121 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
122 | MG_ISSUE_COMP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
NAS - 09-27-99 Created - Will be used to determine if the program must issue components a standard or will we be expecting component consuption transactions from user/external source.
N=Use comp.issue trans. provided Y=Program Generate Issue Trans. |
123 | INV_CART_ID | Character(15) | VARCHAR2(15) NOT NULL | Par Location ID |
124 | COMPARTMENT | Character(10) | VARCHAR2(10) NOT NULL | Compartment |
125 | COUNT_ORDER | Signed Number(5,0) | DECIMAL(4) NOT NULL | Par Location Count Order |
126 | CART_COUNT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Par Location Count Quantity |
127 | QTY_OPTION | Character(2) | VARCHAR2(2) NOT NULL |
Qty Option
01=Count Qty 02=Request Qty |
128 | SUFFICIENT_STOCK | Character(1) | VARCHAR2(1) NOT NULL |
Sufficient Stock
N=NOT SUFFICIENT STOCK Y=SUFFICIENT STOCK |
129 | IU_REC_ID_GRP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Interunit Receipt Identification Group Flag
0 = Group by Receiving Business Unit, Receiver ID. (Default)
1 = Group by Receiving Business Unit, Source Business Unit (origination), Interunit ID, Dest Inventory Business Unit.
2 = Receiving Business Unit, Carrier, Bill of Lading
0=Receiver ID 1=Source BU,InterUnit ID,Dest BU 2=Carrier, Bill of Lading |
130 | IU_REC_SEL_GRP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Interunit Receipt Selection Group Flag
0 = Source Business Unit, Interunit ID, Destination Inventory Business Unit (Default)
1 = Source Business Unit, Shipping Container
0=Source BU, IU ID, Dest BU 1=Source BU, Shipping Container |
131 | SPEEDTYPE_KEY | Character(10) | VARCHAR2(10) NOT NULL | SpeedType Key |
132 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
133 | RTV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
134 | RTV_DISTRIB_NUM | Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
135 | SYNCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required 1=Synchronize a Business Unit 2=Synchronize an Item 3=Synchronize a Storage Location 4=Synchronize a Lot ID 5=Synchronize Item at a Stor Loc |
136 | COUNTING_EVENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Counting Event ID |
137 | PORT_OF_UNLOADING | Character(10) | VARCHAR2(10) NOT NULL | Port Of Unloading |
138 | IST_RETURN_FLG_IUT | Character(1) | VARCHAR2(1) NOT NULL | Intrastat InterUnit Returns |
139 | REPLACEMENT_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods |
140 | PARENT_SHIP_CNTR | Character(20) | VARCHAR2(20) NOT NULL | Parent Shipping Container ID |
141 | SF_KANBAN_ID | Character(15) | VARCHAR2(15) NOT NULL | Kanban ID |
142 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
143 | FREIGHT_CURRNCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
144 | GROSS_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
145 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
146 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |