BUSINESS_UNITORDER_IDORDER_TYPEC=Career Order
T=Temporary Order
Default Value: FOORDER_UPG.ORDER_TYPE
FO_CSF_IDPrompt Table: CUST_CSF
FO_CSF_DESCRPrompt Table: FO_CSF_DTL_VW
FOORDRCSFFL_UPG(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_ID |
Character(25) | VARCHAR2(25) NOT NULL | Order ID |
| 3 | ORDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Type of Order
C=Career Order T=Temporary Order Default Value: FOORDER_UPG.ORDER_TYPE |
| 4 | FO_CSF_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Definition ID
Prompt Table: CUST_CSF |
| 5 | FO_CSF_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Customer Field Name |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Prompt Table: FO_CSF_DTL_VW |
| 7 | VALIDATE_DATA_TBL | Character(1) | VARCHAR2(1) NOT NULL | Validate Data Table |
| 8 | LENGTH_MAX | Number(5,0) | INTEGER NOT NULL | Maximum Length |
| 9 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |