TRFT_BO_BREAK(SQL Table) |
Index Back |
|---|---|
BackOrder Reservation RuleBackOrder Reservation Rule Breaks. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | TRFT_SET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
| 3 | TRFT_FEATURE_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead 2=Backorder Rule Defaulting 3=Supply Sources |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
| 5 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 6 | DATE_END | Date(10) | DATE | End Date |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 8 | RULE_CD | Character(5) | VARCHAR2(5) NOT NULL |
Rule Code
Prompt Table: %EDITTABLE |
| 9 | RULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rule Type
B=Line Backorder Rule L=Line Reservation - Backorder O=Order Reservation Rule R=Line Reservation Rule |