IN_SDA_MULT_TMP(SQL Table) |
Index Back |
|---|---|
Sup/Dmd Multi-Template Tmp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SEARCH_TEMPLATE | Character(30) | VARCHAR2(30) NOT NULL | Search Template |
| 3 | CHART_NBR | Number(3,0) | SMALLINT NOT NULL | Chart Number |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | SAVE_TEMPLATE | Character(1) | VARCHAR2(1) NOT NULL |
Save Template
Y/N Table Edit Default Value: Y |
| 6 | DELETE_TEMPLATE | Character(1) | VARCHAR2(1) NOT NULL |
Delete Template
Y/N Table Edit Default Value: N |
| 7 | IN_SDA_MISC_LABELS | Character(1) | VARCHAR2(1) NOT NULL | Analytic Data |
| 8 | IN_SDA_GROUPBOX_1 | Character(1) | VARCHAR2(1) NOT NULL | Demand Search Criteria |
| 9 | IN_SDA_GROUPBOX_2 | Character(1) | VARCHAR2(1) NOT NULL | Demand Search Criteria |
| 10 | IN_SDA_GROUPBOX_3 | Character(1) | VARCHAR2(1) NOT NULL | Demand Search Criteria |
| 11 | IN_SDA_GROUPBOX_4 | Character(1) | VARCHAR2(1) NOT NULL | Demand Search Criteria |
| 12 | CHART1 | Character(1) | VARCHAR2(1) NOT NULL | Chart 1 |
| 13 | CHART2 | Character(1) | VARCHAR2(1) NOT NULL | Chart 2 |
| 14 | CHART3 | Character(1) | VARCHAR2(1) NOT NULL | Chart 3 |
| 15 | CHART4 | Character(1) | VARCHAR2(1) NOT NULL | Chart 4 |
| 16 | SCM_ANALYTICS | Character(3) | VARCHAR2(3) NOT NULL |
Analytic
D01=INV - Inventory Demand D02=INV - Par Location MSRs M01=MFG - Production Supply M02=MFG - Component Demand P01=PO - Expected Receipts P02=PO - Par Location Orders |
| 17 | SCM_ANALYTIC_CRRNT | Character(3) | VARCHAR2(3) NOT NULL |
Analytic
D01=INV - Inventory Demand D02=INV - Par Location MSRs M01=MFG - Production Supply M02=MFG - Component Demand P01=PO - Incoming Receipts P02=PO - Par Location Orders |
| 18 | SCM_ANALYTICS1 | Character(3) | VARCHAR2(3) NOT NULL |
Analytic
D01=INV - Inventory Demand D02=INV - Par Location MSRs M01=MFG - Production Supply M02=MFG - Component Demand P01=PO - Expected Receipts P02=PO - Par Location Orders |
| 19 | CHART_TITLE1 | Character(60) | VARCHAR2(60) NOT NULL | Chart Title |
| 20 | CHARTTYPE1 | Character(2) | VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart EP=Exploding Pie Chart HB=Horizontal Bar Chart P=Pie Chart Default Value: IN_SDA_OPR_CFG.CHARTTYPE1 |
| 21 | X_AXIS_DATA_OPT1 | Character(2) | VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status 20=Scheduled Date Default Value: IN_SDA_OPR_CFG.X_AXIS_DATA_OPT1 |
| 22 | Y_AXIS_DATA_OPT1 | Character(2) | VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price 20=Quantity 30=Number of Orders Default Value: IN_SDA_OPR_CFG.Y_AXIS_DATA_OPT1 |
| 23 | IN_LEGEND_POS1 | Character(1) | VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom L=Left N=None R=Right T=Top Default Value: IN_SDA_OPR_CFG.IN_LEGEND_POS1 |
| 24 | NBR_INTERVALS1 | Number(2,0) | SMALLINT NOT NULL |
Number of Intervals
Default Value: IN_SDA_OPR_CFG.NBR_INTERVALS |
| 25 | DAYS_INTERVAL1 | Number(3,0) | SMALLINT NOT NULL |
Days Interval
Default Value: IN_SDA_OPR_CFG.DAYS_INTERVAL |
| 26 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: IN_SDA_OPR_CFG.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 27 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Source Bus Unit
Prompt Table: SP_BU_FS_NONVW |
| 28 | SEL_DMD_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request NO=All Non-OM OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return WM=Work Order Default Value: OM |
| 29 | 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 Default Value: OM |
| 30 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW2 |
| 31 | 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 |
| 32 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_VW_BU |
| 33 | PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
| 34 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 35 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: CUST_SHP_INV_VW |
| 36 | SHIP_CUST_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Ship To Name |
| 37 | 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. |
| 38 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: %EDITTABLE |
| 39 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Carrier ID
Prompt Table: CARRIER_ID |
| 40 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: SHIP_METHOD |
| 41 | LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Load ID
Prompt Table: LOAD_INV |
| 42 | 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 |
| 43 | ROUTE_STOP_NBR | Number(5,0) | INTEGER NOT NULL | An identifier used to sequence customer addresses/location for a given route. |
| 44 | INTERUNIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit
N=No Y=Yes |
| 45 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 46 | SINGLE_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Single Ship Flag
N=No Y=Yes |
| 47 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 48 | SUP_PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Unpegged |
| 49 | DATE_RANGE_OPT1 | Character(2) | VARCHAR2(2) NOT NULL |
Date Option
10=As of Date 20=Date Range 30=Number of Days Default Value: IN_SDA_OPR_CFG.DATE_RANGE_OPT1 |
| 50 | ASOFDATE | Date(10) | DATE |
As of Date
Default Value: %Date |
| 51 | DATE_FROM | Date(10) | DATE | Date From |
| 52 | DATE_TO | Date(10) | DATE | Date To |
| 53 | NUM_DAYS_BEFORE1 | Number(4,0) | SMALLINT NOT NULL |
Before Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_BEFORE1 |
| 54 | NUM_DAYS_AFTER1 | Number(4,0) | SMALLINT NOT NULL |
After Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_AFTER1 |
| 55 | INV_ITEM_GROUP1 | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 56 | INV_PROD_FAM_CD1 | Character(10) | VARCHAR2(10) NOT NULL |
Item Family
Prompt Table: INV_ITEM_FAM |
| 57 | CART_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Par Location Group
Prompt Table: IN_PARGROUP_VW |
| 58 | TO_PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 59 | IN_PLACEHLDR_DM | Character(10) | VARCHAR2(10) NOT NULL | Placeholder |
| 60 | SELECT_PENDING | Character(1) | VARCHAR2(1) NOT NULL |
Select Pending
Y/N Table Edit Default Value: N |
| 61 | SELECT_UNFULFILLED | Character(1) | VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit Default Value: Y |
| 62 | SELECT_RELEASABLE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit Default Value: Y |
| 63 | SELECT_RELEASED | Character(1) | VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit Default Value: Y |
| 64 | SELECT_CONFIRMED | Character(1) | VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit Default Value: Y |
| 65 | SELECT_SHIPPED | Character(1) | VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Picked state.
Y/N Table Edit Default Value: N |
| 66 | SELECT_DEPLETED | Character(1) | VARCHAR2(1) NOT NULL |
Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
Y/N Table Edit Default Value: N |
| 67 | SCM_ANALYTICS2 | Character(3) | VARCHAR2(3) NOT NULL |
Analytic
D01=INV - Inventory Demand D02=INV - Par Location MSRs M01=MFG - Production Supply M02=MFG - Component Demand P01=PO - Expected Receipts P02=PO - Par Location Orders |
| 68 | CHART_TITLE2 | Character(60) | VARCHAR2(60) NOT NULL | Chart Title |
| 69 | CHARTTYPE2 | Character(2) | VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart EP=Exploding Pie Chart HB=Horizontal Bar Chart P=Pie Chart Default Value: IN_SDA_OPR_CFG.CHARTTYPE2 |
| 70 | X_AXIS_DATA_OPT2 | Character(2) | VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status 20=Scheduled Date Default Value: IN_SDA_OPR_CFG.X_AXIS_DATA_OPT2 |
| 71 | Y_AXIS_DATA_OPT2 | Character(2) | VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price 20=Quantity 30=Number of Orders Default Value: IN_SDA_OPR_CFG.Y_AXIS_DATA_OPT2 |
| 72 | IN_LEGEND_POS2 | Character(1) | VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom L=Left N=None R=Right T=Top Default Value: IN_SDA_OPR_CFG.IN_LEGEND_POS2 |
| 73 | NBR_INTERVALS2 | Number(2,0) | SMALLINT NOT NULL |
Number of Intervals
Default Value: IN_SDA_OPR_CFG.NBR_INTERVALS |
| 74 | DAYS_INTERVAL2 | Number(3,0) | SMALLINT NOT NULL |
Days Interval
Default Value: IN_SDA_OPR_CFG.DAYS_INTERVAL |
| 75 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 76 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL |
Inventory Unit
Default Value: IN_SDA_OPR_CFG.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 77 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 78 | DATE_RANGE_OPT2 | Character(2) | VARCHAR2(2) NOT NULL |
Date Option
10=As of Date 20=Date Range 30=Number of Days Default Value: IN_SDA_OPR_CFG.DATE_RANGE_OPT1 |
| 79 | ASOFDATE2 | Date(10) | DATE |
As of Date
Default Value: %Date |
| 80 | NUM_DAYS_BEFORE2 | Number(4,0) | SMALLINT NOT NULL |
Before Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_BEFORE1 |
| 81 | NUM_DAYS_AFTER2 | Number(4,0) | SMALLINT NOT NULL |
After Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_AFTER1 |
| 82 | FROM_DATE_PO | Date(10) | DATE | 04/02/02 PCL (CN#PL900-1): Added. |
| 83 | TO_DATE_PO | Date(10) | DATE | 04/02/02 EGS (CN#PL900-1): Added. |
| 84 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 85 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_PO_VW
|
| 86 | INV_ITEM_ID_PO | Character(18) | VARCHAR2(18) NOT NULL |
Item Number PO
Prompt Table: BU_ITM_INV_VW2 |
| 87 | INV_ITEM_GROUP2 | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 88 | INV_PROD_FAM_CD2 | Character(10) | VARCHAR2(10) NOT NULL |
Item Family
Prompt Table: INV_ITEM_FAM |
| 89 | INCL_PO | Character(1) | VARCHAR2(1) NOT NULL |
Include Purchase Orders
Y/N Table Edit Default Value: Y |
| 90 | INCL_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Include Requisitions
Y/N Table Edit Default Value: Y |
| 91 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |
| 92 | LOCATION2 | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: IN_PARLOC_VW2 |
| 93 | CART_GROUP2 | Character(5) | VARCHAR2(5) NOT NULL |
Par Location Group
Prompt Table: IN_PARGROUP_VW2 |
| 94 | IN_PLACEHLDR_PO | Character(10) | VARCHAR2(10) NOT NULL | Placeholder |
| 95 | PEND_APPR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
PENDING APPROVAL FLAG
Y/N Table Edit Default Value: Y |
| 96 | APPROVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Approved
B=Both N=No Y=Yes Y/N Table Edit Default Value: Y |
| 97 | OPEN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
OPEN FLAG
Y/N Table Edit Default Value: Y |
| 98 | DISPATCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Dispatched
D=Dispatched N=No Y/N Table Edit Default Value: Y |
| 99 | COMPLETED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Completed
N=Not Completed Y=Complete Y/N Table Edit Default Value: N |
| 100 | DENY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
DENY FLAG
Y/N Table Edit Default Value: N |
| 101 | PEND_CAN_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Pending Cancel
N=No PX=Pending Cancel Y/N Table Edit Default Value: N |
| 102 | CANCEL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Cancel PO
B=Both N=No Y=Yes Y/N Table Edit Default Value: N |
| 103 | LINE_APPROVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Lines Approved
Y/N Table Edit Default Value: Y |
| 104 | LINE_DENIED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Line Denied
Y/N Table Edit Default Value: N |
| 105 | PREVIEW_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Preview
Y/N Table Edit Default Value: N |
| 106 | INIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Initial Flag
I=Initial N=No Y/N Table Edit Default Value: N |
| 107 | INCL_RCPT_NOTPTWY | Character(1) | VARCHAR2(1) NOT NULL |
Received but Not Putaway
Y/N Table Edit Default Value: Y |
| 108 | SCM_ANALYTICS3 | Character(3) | VARCHAR2(3) NOT NULL |
Analytic
D01=INV - Inventory Demand D02=INV - Par Location MSRs M01=MFG - Production Supply M02=MFG - Component Demand P01=PO - Expected Receipts P02=PO - Par Location Orders |
| 109 | CHART_TITLE3 | Character(60) | VARCHAR2(60) NOT NULL | Chart Title |
| 110 | CHARTTYPE3 | Character(2) | VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart EP=Exploding Pie Chart HB=Horizontal Bar Chart P=Pie Chart Default Value: IN_SDA_OPR_CFG.CHARTTYPE3 |
| 111 | X_AXIS_DATA_OPT3 | Character(2) | VARCHAR2(2) NOT NULL |
X-Axis Data
10=Status 20=Scheduled Date Default Value: IN_SDA_OPR_CFG.X_AXIS_DATA_OPT3 |
| 112 | Y_AXIS_DATA_OPT3 | Character(2) | VARCHAR2(2) NOT NULL |
Y-Axis Data
10=Value/Price 20=Quantity 30=Number of Orders Default Value: IN_SDA_OPR_CFG.Y_AXIS_DATA_OPT3 |
| 113 | IN_LEGEND_POS3 | Character(1) | VARCHAR2(1) NOT NULL |
Legend Position
B=Bottom L=Left N=None R=Right T=Top Default Value: IN_SDA_OPR_CFG.IN_LEGEND_POS3 |
| 114 | NBR_INTERVALS3 | Number(2,0) | SMALLINT NOT NULL |
Number of Intervals
Default Value: IN_SDA_OPR_CFG.NBR_INTERVALS |
| 115 | DAYS_INTERVAL3 | Number(3,0) | SMALLINT NOT NULL |
Days Interval
Default Value: IN_SDA_OPR_CFG.DAYS_INTERVAL |
| 116 | BUSINESS_UNIT_MG | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Manufacturing
Default Value: IN_SDA_OPR_CFG.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
| 117 | DATE_RANGE_OPT3 | Character(2) | VARCHAR2(2) NOT NULL |
Date Option
10=As of Date 20=Date Range 30=Number of Days Default Value: IN_SDA_OPR_CFG.DATE_RANGE_OPT1 |
| 118 | ASOFDATE3 | Date(10) | DATE |
As of Date
Default Value: %Date |
| 119 | NUM_DAYS_BEFORE3 | Number(4,0) | SMALLINT NOT NULL |
Before Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_BEFORE1 |
| 120 | NUM_DAYS_AFTER3 | Number(4,0) | SMALLINT NOT NULL |
After Today
Default Value: IN_SDA_OPR_CFG.NUM_DAYS_AFTER1 |
| 121 | PA_DATE_FROM | Date(10) | DATE | 3/23/98 rlk - Changed rftshort to work with sf_prdn_plan_load panel |
| 122 | PA_DATE_TO | Date(10) | DATE | Production Due Date To |
| 123 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Production Area
Prompt Table: MG_PRDN_AREA_VW |
| 124 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 125 | PROD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Production Status
10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled |
| 126 | SEL_PID | Character(1) | VARCHAR2(1) NOT NULL |
Select Production IDs
Y/N Table Edit Default Value: IN_SDA_OPR_CFG.SEL_PID |
| 127 | SEL_PA | Character(1) | VARCHAR2(1) NOT NULL |
Select Prdn Area Schedules
Y/N Table Edit Default Value: IN_SDA_OPR_CFG.SEL_PA |
| 128 | INV_ITEM_ID3 | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_BUITM_INV_VW |
| 129 | INV_ITEM_GROUP3 | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 130 | INV_PROD_FAM_CD3 | Character(10) | VARCHAR2(10) NOT NULL |
Item Family
Prompt Table:
INV_ITEM_FAM
|
| 131 | IN_PLACEHLDR_MG | Character(10) | VARCHAR2(10) NOT NULL | Placeholder |
| 132 | SEL_ENT | Character(1) | VARCHAR2(1) NOT NULL |
Entered
Y/N Table Edit Default Value: N |
| 133 | SEL_FIRM | Character(1) | VARCHAR2(1) NOT NULL |
Firmed
Y/N Table Edit Default Value: Y |
| 134 | SEL_RELEASED | Character(1) | VARCHAR2(1) NOT NULL |
Released
Y/N Table Edit Default Value: Y |
| 135 | SEL_IN_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Close In-Process Productions
Y/N Table Edit Default Value: Y |
| 136 | SEL_PEND | Character(1) | VARCHAR2(1) NOT NULL |
Close Pending-Cmpl Productions
Y/N Table Edit Default Value: Y |
| 137 | SEL_CMPL | Character(1) | VARCHAR2(1) NOT NULL |
Close Completed Productions
Y/N Table Edit Default Value: Y |
| 138 | SEL_LAB | Character(1) | VARCHAR2(1) NOT NULL |
Close Labor-Closed Productions
Y/N Table Edit Default Value: Y |