IN_DELIVERY_PKG

(SQL Table)
Index Back

Delivery Packages

Delivery Packages

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
3 IN_PACKAGE_ID Character(20) VARCHAR2(20) NOT NULL Package ID
4 AUTO_ASSIGN Character(1) VARCHAR2(1) NOT NULL Automatic Assigned

Default Value: N

5 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type

Prompt Table: CNTR_TYPE_INV

6 FRT_RATE_STATUS Character(2) VARCHAR2(2) NOT NULL Rate Status
00=None
10=Requested
20=Received

Default Value: 00

7 FREIGHT_ERROR Character(1) VARCHAR2(1) NOT NULL Freight Error
8 MANIFEST_STATUS Character(2) VARCHAR2(2) NOT NULL Manifest Status
00=None
10=Requested
20=Received

Default Value: 00

9 PACKING_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Height
10 PACKING_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Length
11 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
12 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
13 PACKING_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Width
14 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

Prompt Table: UNITS_TBL

15 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

Prompt Table: UNITS_TBL

16 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

Prompt Table: UNITS_TBL

17 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID