TRFT_SRC_BREAK(SQL Table) |
Index Back |
|---|---|
Alternate Sourcing BreakAlternate sources of supply break table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL | Priority |
| 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 | TRFT_SRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Alternate Source Type
0=All Sources 1=Inventory Business Unit 2=Distribution Network 3=New Requisition 4=New Purchase Order 5=Existing Requisition 6=Existing Purchase Order 7=Existing Interunit Transfer 8=Existing Production Order 9=New Production Order |
| 9 | TRFT_DISPOSITION | Character(1) | VARCHAR2(1) NOT NULL |
Supply Source disposition
1=Direct Ship 2=Direct Receipt |
| 10 | TRFT_SRC_VALUE | Character(10) | VARCHAR2(10) NOT NULL |
Source Value
Prompt Table: %EDITTABLE |