| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
CHAR_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Old Edit Value
|
| 4 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 5 |
CUST_GROUP_FLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Customer Group
Y/N Table Edit
Default Value: N
|
| 6 |
CUST_GRP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation
|
| 7 |
IN_LN_RESV_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation - Backorder
|
| 8 |
IN_ORDER_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Reservation Rule
|
| 9 |
IN_LINE_BO_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Backorder Rule
|
| 10 |
IN_LINE_RESV_RULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Line Reservation Rule
|
| 11 |
LAST_ORDER |
Character(10) |
VARCHAR2(10) NOT NULL |
Last Order
|
| 12 |
LINE_NBR_LAST |
Number(5,0) |
INTEGER NOT NULL |
Last Line Number
|
| 13 |
OM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OM Work Flag
|
| 14 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 15 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 16 |
PROD_GRP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Product Group Type
ACCT=Accounting
BO=Backorder/Reservations
CA=Contract
CLMB=Claimback Contract
CTLG=Product Catalogs
FCST=Forecast
FRT=Freight
PRC=Pricing
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources of Supply
TAX=Tax
TRPT=Transportations
VAT=VAT
WEB=WEB Order Entry
|
| 17 |
OM_HDR_TAO_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Header TAO Recname
|
| 18 |
OM_LINE_TAO_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Line TAO Recname
|
| 19 |
OM_SCH_TAO_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Schedule TAO Recname
|
| 20 |
OM_PRD_TAO_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Product TAO Record
|
| 21 |
PRODUCT_GROUP_FLAG |
Character(2) |
VARCHAR2(2) NOT NULL |
Product Group
Y/N Table Edit
Default Value: N
|
| 22 |
RECNAME_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 1 Name
|
| 23 |
RECNAME_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Record 2 Name
|
| 24 |
REGION_CD_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Region Code Type
ACCT=Accounting
BO=Backorder/Reservation
CDOM=Contract Domain
CNTR=Contracts
FRT=Freight
MBR=Team Member
PRC=Pricing
RPT=Reporting
RS=Resource Management
SPRS=Procurement
SSRC=Alternate Sources Of Supply
TRPT=Transportation
|
| 25 |
REGION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Region Flag
Y/N Table Edit
Default Value: N
|
| 26 |
RULE_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Rule Code
Prompt Table:
%EDITTABLE
|
| 27 |
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
|
| 28 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 29 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 30 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 31 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 32 |
SCHED_NBR_LAST |
Number(5,0) |
INTEGER NOT NULL |
Scheduled last number
|
| 33 |
TRFT_FEATURE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead
2=Backorder Rule Defaulting
3=Supply Sources
|
| 34 |
TRFT_KEY_CD |
Character(50) |
VARCHAR2(50) NOT NULL |
Select Key Fields
|
| 35 |
TRFT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Arbitration Rule Code.
|
| 36 |
TRFT_SET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Rule Cd
|
| 37 |
UPDATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Prior Operations
|
| 38 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 39 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 40 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 41 |
WHERE_LONG |
Long Character |
CLOB |
Where Clause
|