IN_SD_FUNC_AREAIN=Inventory
Default Value: IN
FIELDNAMEPrompt Table: IN_SDMC_FLD_VW
Y/N Table Edit
Default Value: N
IN_SDMC_SETUP(SQL Table) |
Index Back |
|---|---|
Mass Change field setupLists the fields available for mass change by functional area %InsertSelect(DISTINCT, IN_SDMC_SETUP, IN_DMD_CHG_CFG, IN_SD_FUNC_AREA = 'IN', FIELDNAME = IN_FIELDNAME, RECNAME = 'IN_DEMAND') FROM PS_IN_DMD_CHG_CFG WHERE IN_FIELDNAME <> ' ' AND SYSTEM_DATA_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IN_SD_FUNC_AREA |
Character(2) | VARCHAR2(2) NOT NULL |
Functional Application Area
IN=Inventory Default Value: IN |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: IN_SDMC_FLD_VW |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Data
Y/N Table Edit Default Value: N |