BUSINESS_UNIT_IN1=No Warning
2=Warning
3=Error
ORDENT_BUIN_VW(SQL View) |
Index Back |
|---|---|
View on BUS_UNIT_TBL_INUsed by order entry to select exception dates. Date Initials Issue Description 081601 dms DI-MVANWINK-3 Add cal_lookup_done 082602 dms DI-DSCANTLA-2 Add check_bushp |
| SELECT business_unit , auto_round_opt , frt_rule_cd , location , business_unit_bi , use_route_flag , 'N' , 0 , 0 , 'N' FROM PS_BUS_UNIT_TBL_IN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 2 | AUTO_ROUND_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Automatic UOM Round Option
1=No Warning 2=Warning 3=Error |
| 3 | FRT_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Freight Rule Code |
| 4 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 5 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 6 | USE_ROUTE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Determines whether route functionality will be used for a business unit. |
| 7 | CAL_LOOKUP_DONE | Character(1) | VARCHAR2(1) NOT NULL | Calendar Lookup Done |
| 8 | DAY_ROW | Number(5,0) | INTEGER NOT NULL | Day Row |
| 9 | BLOCK_ROW | Number(5,0) | INTEGER NOT NULL | Block Row |
| 10 | CHECK_BUSHP | Character(1) | VARCHAR2(1) NOT NULL | Check BUSHP for fields |