INSTALLATION_IN(SQL Table) |
Index Back |
|---|---|
PS Inventory Installation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DFLT_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Default Serial ID |
| 2 | DFLT_STAGED_DATE | Date(10) | DATE | Default Staged Date |
| 3 | DFLT_INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Default Lot ID |
| 4 | DFLT_RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Default Receiver ID |
| 5 | DFLT_RECEIVER_LINE | Number(5,0) | INTEGER NOT NULL | Default Receiver Line No |
| 6 | DFLT_IUNIT_PREFIX | Character(1) | VARCHAR2(1) NOT NULL | Default InterUnit ID Prefix |
| 7 | IUNIT_ID_COUNTER | Number(9,0) | DECIMAL(9) NOT NULL | InterUnit ID Counter |
| 8 | STAGED_DATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF Y=Staged Date Tracking ON Y/N Table Edit Default Value: N |
| 9 | UOM_CONV_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
UOM Conversion Flag
0=Use Entered UOM 1=Convert to Standard UOM 2=Convert to Default Stock UOM Default Value: 0 |
| 10 | RESERVE_ID_COUNTER | Number(27,0) | DECIMAL(27) NOT NULL | Auto Reserve Counter |
| 11 | CONFIRM_ID_COUNTER | Number(27,0) | DECIMAL(27) NOT NULL | Auto Confirm Counter |
| 12 | DEPLETE_ID_COUNTER | Number(27,0) | DECIMAL(27) NOT NULL | Auto Deplete Counter |
| 13 | IUNIT_VALUES | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit Transaction Options
1=Use GL BU Settings Only 2=Use IN BU Settings Only 3=Use Both Default Value: 3 |
| 14 | CTNR_AE_COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Auto Container AE Counter |
| 15 | PEG_KEY_SEPARATOR | Character(1) | VARCHAR2(1) NOT NULL |
Pegging Key Separator
Default Value: / |
| 16 | CM_DMS_RUN_INST | Character(1) | VARCHAR2(1) NOT NULL |
CM_DMS_RUN_STATUS
Y/N Table Edit Default Value: N |
| 17 | CM_SEQ_PLATFORM_SP | Character(1) | VARCHAR2(1) NOT NULL |
Set based Sequencing
Y/N Table Edit Default Value: N |
| 18 | IN_SEQ_PLATFORM_SP | Character(1) | VARCHAR2(1) NOT NULL |
Set based Sequencing
Y/N Table Edit Default Value: N |
| 19 | IN_DMS_RUN_INST | Character(1) | VARCHAR2(1) NOT NULL |
IN_DMS_RUN_STATUS
Y/N Table Edit Default Value: N |
| 20 | STOR_LOC_SRCH_LIM | Number(5,0) | INTEGER NOT NULL | Initial Search Row Limit |
| 21 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL |
Hold Code
Prompt Table: HOLD_CD |
| 22 | DFLT_RTV_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Default RTV Customer ID |
| 23 | MAX_LINES_SCROLL | Number(5,0) | INTEGER NOT NULL |
Maximum Lines Displayed
Default Value: 100 |
| 24 | PAR_REPLN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Installation option for par replenishment
Y/N Table Edit Default Value: N |
| 25 | NUMBER_OF_DAYS | Number(2,0) | SMALLINT NOT NULL | This field will hold the value for number of days for retianing data in put away staging record |
| 26 | CURR_CD_KIBANA | Character(3) | VARCHAR2(3) NOT NULL |
Reporting Currency
Prompt Table: CURRENCY_CD_TBL |
| 27 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |