BUSINESS_UNITASSET_IDAUC_ASSETDTL_VW(SQL View) |
Index Back |
|---|---|
Auctions Asset Attribute View |
| SELECT A.BUSINESS_UNIT ,A.ASSET_ID ,A.ASSET_HEIGHT ,A.ASSET_LENGTH ,A.ASSET_WIDTH ,A.ASSET_WEIGHT ,A.ASSET_CAPACITY ,A.ASSET_COLOR ,A.LENGTH_UM ,A.WEIGHT_UM ,A.CAPACITY_UM FROM PS_ASSET_ATTRIBUTE A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ASSET_ATTRIBUTE B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.ASSET_ID = A.ASSET_ID AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | AUC_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 4 | AUC_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 5 | AUC_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 6 | AUC_ITEM_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Weight |
| 7 | AUC_ITEM_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Volume |
| 8 | AUC_ITEM_COLOR | Character(15) | VARCHAR2(15) NOT NULL | Sourcing Item Color |
| 9 | AUC_DIMENSION_UOM | Character(3) | VARCHAR2(3) NOT NULL | Dimension UOM |
| 10 | AUC_WEIGHT_UOM | Character(3) | VARCHAR2(3) NOT NULL | Weight UOM |
| 11 | AUC_VOLUME_UOM | Character(3) | VARCHAR2(3) NOT NULL | Volume UOM |