PL_BOM_HEADER(SQL Table) |
Index Back |
---|---|
Planning BOM Header Sub-recordRAG CN#SF800-12.0 Added record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUIN_NONVW |
|
2 | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITEMS_INV |
|
3 | BOM_QTY | Number(7,0) | INTEGER NOT NULL |
06/02/00 LAJ (8.0)
Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard.
Default Value: 1 |