SHIP_CNTR_VW8(SQL View) |
Index Back |
|---|---|
Ship Cntr View No PCodeShip Container Header view that has no peoplecode attached to it. It also does not have the Business Unit default and Ship Container default, so it can be used in scrolls and the user doesn't see NEXT as the ship container id if nothing is selected into the scroll. |
| SELECT BUSINESS_UNIT , SHIP_CNTR_ID , CONTAINER_TYPE , UCC_EAN_CD , DESCR , DESCRLONG , STOCK_TYPE , SHIP_HEIGHT , SHIP_LENGTH , SHIP_WIDTH , MAX_WEIGHT , EMPTY_WEIGHT , UNIT_MEASURE_DIM , UNIT_MEASURE_WT , UNIT_MEASURE_VOL , OWNER , SHIP_ID , PRO_NUMBER , FREIGHT_AMT , FREIGHT_CURRNCY_CD , FRT_CHRG_AUDIT , FRT_CHRG_OVERRIDE , NET_WEIGHT , GROSS_WEIGHT , CARRIER_ID , SHIP_TYPE_ID , LOCATION , SHIP_TO_CUST_ID , ADDRESS_SEQ_NUM , PARENT_SHIP_CNTR , OVERRIDE , GROSS_WEIGHT_USER , UNIT_MEASR_WT_USER , ARRIVAL_DATE , FRT_REF_NO , EXT_PKG_ID , OVERSIZED , ADD_HANDLING , OUTER_MOST_CNTR_ID FROM PS_SHIP_CNTR_HDR |
| # | 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 | SHIP_CNTR_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Shipping Container ID
Prompt Table: SHIP_CNTR_VW2 |
| 3 | CONTAINER_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Container Type
Prompt Table: CNTR_TYPE_INV |
| 4 | UCC_EAN_CD | Character(1) | VARCHAR2(1) NOT NULL |
UCC/EAN Packaging Type
0=Case/Carton 1=Pallet 2=Truckload 3=Undefined 4=Intra-Company |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |
| 7 | STOCK_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Stock Type
F=Finished R=Raw Mtrl W=WIP |
| 8 | SHIP_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Height |
| 9 | SHIP_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Length |
| 10 | SHIP_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Width |
| 11 | MAX_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Weight Capacity |
| 12 | EMPTY_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Empty Weight |
| 13 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL | Dimension UOM |
| 14 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 15 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |
| 16 | OWNER | Character(20) | VARCHAR2(20) NOT NULL | Asset Owner |
| 17 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 18 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 19 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 20 | FREIGHT_CURRNCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | FRT_CHRG_AUDIT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Freight Charge |
| 22 | FRT_CHRG_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Freight Charge Override |
| 23 | NET_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Net Weight |
| 24 | GROSS_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 25 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 26 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 27 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 28 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 29 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 30 | PARENT_SHIP_CNTR | Character(20) | VARCHAR2(20) NOT NULL | Parent Shipping Container ID |
| 31 | OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Copy Method
A=Append O=Override Y/N Table Edit Default Value: N |
| 32 | GROSS_WEIGHT_USER | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Weight |
| 33 | UNIT_MEASR_WT_USER | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: INV_SHIP_UOM_VW |
| 34 | ARRIVAL_DATE | Date(10) | DATE | Arrival Date |
| 35 | FRT_REF_NO | Character(30) | VARCHAR2(30) NOT NULL | Freight Reference Number |
| 36 | EXT_PKG_ID | Character(30) | VARCHAR2(30) NOT NULL | External Packaging ID |
| 37 | OVERSIZED | Character(1) | VARCHAR2(1) NOT NULL |
Oversized Item
Y/N Table Edit Default Value: N |
| 38 | ADD_HANDLING | Character(1) | VARCHAR2(1) NOT NULL |
Additional Handling
Y/N Table Edit Default Value: N |
| 39 | OUTER_MOST_CNTR_ID | Character(20) | VARCHAR2(20) NOT NULL | Shipping Container ID |