ASSET_CHECKOUT(SQL Table) |
Index Back |
|---|---|
Asset Checkout |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: ASSET_SCHDLB_VW |
| 3 | CHECKOUT_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Checkout ID
Default Value: NEXT |
| 4 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW |
| 5 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table: WM_WO_TSK_VW3 |
| 6 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL |
Task Number
Prompt Table: WM_WO_TSK_VW4 |
| 7 | START_DT | Date(10) | DATE NOT NULL | Start Date |
| 8 | START_TM | Time(15) | TIMESTAMP | Represents the process starting time associated with position calculation. |
| 9 | END_DT | Date(10) | DATE | End Date |
| 10 | END_TM | Time(15) | TIMESTAMP | End Time |
| 11 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL |
Custodian
Prompt Table: AM_CSTDN_NAME |
| 12 | CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Provider Contact |
| 13 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: AM_WM_SHOP |
| 14 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: AM_WM_LOC |
| 15 | DEPLOYED_BU | Character(5) | VARCHAR2(5) NOT NULL |
Deployed Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 16 | DEPLOYED_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Deployed Asset ID
Prompt Table: AM_DEPLOY_ASSET |
| 17 | USAGE_AMOUNT | Number(13,4) | DECIMAL(12,4) NOT NULL | Usage Amount |
| 18 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 19 | CHECKED_IN | Character(1) | VARCHAR2(1) NOT NULL |
Checked In
Y/N Table Edit Default Value: N |