OM_BU_HOLD_FLDS(SQL Table) |
Index Back |
|---|---|
OMBU Hold field definitionsMetadata record that defines the OMBU holds. Date Init. Issue # Description 051304 dms F-KNANN-V59N4 Replace old pass thru fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HOLD_FIELD |
Character(18) | VARCHAR2(18) NOT NULL | Hold Field |
| 2 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | DISPLAY_FIELDS | Character(1) | VARCHAR2(1) NOT NULL |
Display Catalog Search Fields
Y/N Table Edit Default Value: Y |
| 4 | DISPLAY_CHECKBOX | Character(1) | VARCHAR2(1) NOT NULL |
Display Checkbox
Y/N Table Edit Default Value: Y |
| 5 | PASS_HOLD_LEVEL | Character(4) | VARCHAR2(4) NOT NULL |
Hold Code Level
CUST=Customer Hold HDR=Header Hold LINE=Line Hold PROD=Product Hold SCH=Schedule Hold SYS=System Holds |
| 6 | HOLD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Hold Type
A=Automatic Holds C=Credit Holds D=Credit Card Holds F=Configurator Holds O=Other Holds |
| 7 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL | System Data |