BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
FIELDNAMEPrompt Table: INV_SHPKEY_VW
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
INV_SHPFLD_DTL(SQL Table) |
Index Back |
|---|---|
Estimated Shipment Field Defin |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: INV_SHPKEY_VW |
| 3 | DEL_ORD_RESTRICTED | Character(1) | VARCHAR2(1) NOT NULL |
Deliveries restricted to order
N=Deliveries Not Restricted Y=Deliveries Restricted to Order Y/N Table Edit Default Value: N |
| 4 | UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Update Prior Operations
Y/N Table Edit Default Value: N |
| 5 | ADD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Add flag
Y/N Table Edit Default Value: N |