| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
DEBUG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to enable debug messages when executing the position monitor calculation process.
A=All Debug Messages
F=Flow Debug Messages
N=No Debug Messages
|
| 3 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 4 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 5 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
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
|
| 8 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 9 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 10 |
PRC_SCHED_NBR |
Number(6,0) |
INTEGER NOT NULL |
Pricing Schedule Number
|
| 11 |
LINE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
|
| 12 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 13 |
DST_PCT_REV |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Revenue Dist Percentage
|
| 14 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 15 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 16 |
DST_ID_DIS |
Character(10) |
VARCHAR2(10) NOT NULL |
Discount Distribution Code
|
| 17 |
DST_ID_SUR |
Character(10) |
VARCHAR2(10) NOT NULL |
Surcharge Distribution Code
|
| 18 |
DST_PCT_SUR |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Surcharge Dist Percentage
|
| 19 |
DST_PCT_DIS |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Discount Dist Percentage
|
| 20 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 21 |
SEQ_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Expense Sequence Number
|
| 22 |
LIST_PRICE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
List Price
|
| 23 |
DST_ID_REV |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Dist Code
|
| 24 |
OMBI_EXCISE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OM_BILL Excise Flag
|
| 25 |
OMBI_PRC_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Adjustment Detail Option
1=Netted with Revenue
2=As Account Distribution
3=As Disc/Surch Detail
|
| 26 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 27 |
DS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 28 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 29 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 30 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 31 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 32 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 33 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 34 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 35 |
PRICE_ORIG |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Original Price
|
| 36 |
GROSS_CHANGE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Negotiated Amount
|
| 37 |
INTFC_ID_ADJ |
Number(8,0) |
INTEGER NOT NULL |
Interface ID of Adj Trans
|
| 38 |
INTFC_LINE_NUM_ADJ |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number - Adj
|
| 39 |
AMT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount1
|
| 40 |
AMT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount2
|
| 41 |
AMT_3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount3
|
| 42 |
AMT_4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount4
|
| 43 |
WRKAMT_1 |
Signed Number(31,6) |
DECIMAL(29,6) NOT NULL |
Amount1
|
| 44 |
WRKAMT_2 |
Signed Number(31,6) |
DECIMAL(29,6) NOT NULL |
Amount2
|
| 45 |
WRKAMT_3 |
Signed Number(31,6) |
DECIMAL(29,6) NOT NULL |
Amount3
|
| 46 |
WRKAMT_4 |
Signed Number(31,6) |
DECIMAL(29,6) NOT NULL |
Amount4
|
| 47 |
WRKPRICE_1 |
Signed Number(18,6) |
DECIMAL(16,6) NOT NULL |
Adjusted Price
|
| 48 |
WRKPCT_1 |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Adjust Percentage
|
| 49 |
WRKPCT_2 |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Adjust Percentage
|
| 50 |
WRKPCT_3 |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Adjust Percentage
|
| 51 |
WRKPCT_4 |
Signed Number(12,4) |
DECIMAL(10,4) NOT NULL |
Adjust Percentage
|
| 52 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 53 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 54 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 55 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 56 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 57 |
FIELDNUM |
Number(4,0) |
SMALLINT NOT NULL |
Field Number
|
| 58 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 59 |
PRODUCT_KIT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Kit Number
|
| 60 |
VAT_KIT_PCT |
Number(3,0) |
SMALLINT NOT NULL |
% of Kit Value for VAT
|
| 61 |
UNIT_AMOUNT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 62 |
AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 63 |
AMOUNT_UNIT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 64 |
BUSINESS_UNIT_LAST |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business_Unit
|
| 65 |
TRANS_TYPE_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
|
| 66 |
TRANS_TYPE_BI_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
|
| 67 |
MAX_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Maximum Sequence Number
|
| 68 |
PREV_PRICE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Price Set Type
99=Standard Discount
A=Replacement Price
F=Cascading
S=Summed Adjustments
Z=Product Giveaway
|
| 69 |
PREV_PRICE_SET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price Set ID
|
| 70 |
EOEP_ADJUST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back
AMT=Amount
OI=Off-Invoice
OVR=Price Override
PCT=Percent
|
| 71 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 72 |
DISC_SUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
|
| 73 |
TOTAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply to Total
|
| 74 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 75 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 76 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 77 |
OM_AMOUNT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Amount
|
| 78 |
FINAL_AMOUNT_ROUND |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Amount Rounded
|
| 79 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 80 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 81 |
SUM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Summary amount used in reconciliation
|
| 82 |
PRICE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Flag
|
| 83 |
TOT_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 84 |
MAX_LVL_NUM_DS |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 85 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=CRM Free Period Promotion
11=CRM Product Add
12=Pricing Base
13=Rollup Only Rule
14=Min/Max Margin
2=Price Override
3=Product Add
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Related Busines Objects
9=Price List Only Condition
99=Standard Discount
|
| 86 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
|
| 87 |
EOEP_PRCBASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pricing Base Flag
1=List Price
2=Cost
3=Buying Agreement
4=Alternate Cost
|
| 88 |
PREV_EOEP_ACT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
2=Price Override
3=Giveaway
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Price List Only Condition
|
| 89 |
PREV_EOEP_ADJ_METD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
|
| 90 |
DECIMALPOS1 |
Number(4,0) |
SMALLINT NOT NULL |
Decimal Positions1
|
| 91 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 92 |
FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag1
|
| 93 |
FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag2
|
| 94 |
FLAG3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag3
|
| 95 |
FLAG4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag4
|
| 96 |
FLAG5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag5
|
| 97 |
UPS_FLAG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 98 |
UPS_FLAG2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 99 |
AMOUNT_OUT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 100 |
AMOUNT_OUT2 |
Signed Number(31,5) |
DECIMAL(29,5) NOT NULL |
Output Amount 2
|
| 101 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 102 |
PCT_DIFF |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 103 |
PERCENTAGE1 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 104 |
PERCENTAGE2 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 105 |
PERCENTAGE3 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 106 |
PERCENTAGE4 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 107 |
SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 108 |
AMT_DIFF |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount1
|
| 109 |
MAX_AMOUNT |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Maximum Amount
|
| 110 |
LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost Retired at Chart
|
| 111 |
OM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
OM Work Flag
|
| 112 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
|
| 113 |
SQL_TABLES |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Tables
|
| 114 |
STD_DISCOUNT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Standard Discount
|