SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
ORDER_GRPEFFDTDefault Value: %date
LANGUAGE_CDORD_GROUP_LNG(SQL Table) |
Index Back |
|---|---|
Order Group Table Related Lng.This table holds information which may categorize the contents of a sales order or quotation. It also holds information that could be used as defaults on orders when the information is absent from the customer record or not entered by the user. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ORDER_GRP |
Character(6) | VARCHAR2(6) NOT NULL | Order Group |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |