WM_SHOP_LASTNBR(SQL Table) |
Index Back |
---|---|
Shop Definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
2 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
3 | BEG_SEQ | Character(3) | VARCHAR2(3) NOT NULL | Beginning Sequence |
4 | WM_TIME_SHEET_ID | Number(7,0) | INTEGER NOT NULL | Time Sheet Unique Identifier (System Generated) - for 7 character timesheet ids |