IN_RUN_INTUNIT(SQL Table) |
Index Back |
|---|---|
Interunit Exp Rec Run Request12/99 Created for outbound shipping notice message selection. |
| # | 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 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUINVN_NONVW |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | INV_EDI_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Inventory ASN EDI Option
A=All Shipments D=Sold To Customer H=Ship To Customer I=Shipping ID V=Delivery ID Default Value: A |
| 7 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shipping ID
Prompt Table: IN_SHIPID_IU_VW |
| 8 | SEL_DESTBU_OPT | Character(1) | VARCHAR2(1) NOT NULL |
12/99:Created
A=All S=Specific Default Value: A |
| 9 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table: SP_BUINVN_NONVW |
| 10 | SEL_TRAN_OPT | Character(1) | VARCHAR2(1) NOT NULL |
12/99 Created
C=Closed/Cancelled N=New Default Value: N |
| 11 | POST_SHIP_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Cancel Instance |
| 12 | REGEN_MSG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
12/99 Created
Y/N Table Edit Default Value: N |