| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
TRFT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Arbitration Rule Code.
Default Value: NEXT
Prompt Table:
TRFT_RULE
|
| 3 |
TRFT_FEATURE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead
2=Backorder Rule Defaulting
3=Supply Sources
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
TRFT_SRC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Source/Transportation Sort Order
1=Arbitration Plan Sequence
2=Quantity Available Descending
3=Quantity Available Ascending
4=Shortest Lead Time, Plan Seq
5=Longest Lead Time, Plan Seq
Default Value: 1
|
| 6 |
DEFAULT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default
Y/N Table Edit
Default Value: N
|
| 7 |
FRT_BY_QTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight by Order Quantity
Y/N Table Edit
Default Value: N
|
| 8 |
FRT_BY_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight by Order Value
Y/N Table Edit
Default Value: Y
|
| 9 |
FRT_BY_VOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight by Shipping Volume
Y/N Table Edit
Default Value: Y
|
| 10 |
FRT_BY_WT |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight by Shipping Weight
Y/N Table Edit
Default Value: Y
|
| 11 |
CUST_GROUP_FLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Customer Group
Y/N Table Edit
Default Value: N
|
| 12 |
PRODUCT_GROUP_FLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Product Group
Y/N Table Edit
Default Value: N
|
| 13 |
REGION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Region Flag
Y/N Table Edit
Default Value: N
|
| 14 |
VNDR_FRT_GRP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supp Frt Group Flag
Default Value: N
|
| 15 |
WHERE_LONG |
Long Character |
CLOB |
Where Clause
|
| 16 |
DTTIME_ADDED |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 17 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 18 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|