TD_LOADPRC_AET

(SQL Table)
Index Back

Main State Rec for TD_LOADPRC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
N=No
Y=Yes
3 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
4 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
N=No
Y=Yes
5 EOEP_NUM_VALUE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
6 EOEP_TEXT_VALUE Character(254) VARCHAR2(254) NOT NULL Text Value
7 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
11 TD_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL RnCntrl Select for TD_LOADPRC
A=All Promotions and Allowances
L=All National Allowances
N=Single National Allowance
P=All Customer Promotions
S=Single Customer Promotion
12 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
13 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
14 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
1=No
2=Per Customer
3=Per Rule
15 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Price Type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
16 PROMO_TYPE Character(1) VARCHAR2(1) NOT NULL Promotion Type
A=National Allowance
P=Promotion Event
17 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
N=No
Y=Yes
18 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
19 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
20 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2
21 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
22 CHAR_VALUE Character(30) VARCHAR2(30) NOT NULL Old Edit Value
23 BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Price Break ID
24 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
26 DATE_BEGIN Date(10) DATE Start Date
27 DATE_END Date(10) DATE End Date
28 BREAK_QTY_HIGH Number(15,4) DECIMAL(14,4) NOT NULL Upper Quantity/Amount
29 BREAK_QTY_LOW Number(15,4) DECIMAL(14,4) NOT NULL Low Quantity/Amount
30 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
31 ADJUSTMENT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Percent
32 OM_ADJST_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Order Adjustment Amount
33 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
34 FIRST_ORDER_DATE Date(10) DATE First Order Date
35 LAST_ORDER_DATE Date(10) DATE Last Order Date
36 FIRST_DELIVERY_DT Date(10) DATE Physical date of position.
37 LAST_DELIVERY_DT Date(10) DATE Last delivery date for a contract .
38 FIRST_SHIP_DATE Date(10) DATE First Scheduled Ship Date
39 LAST_SHIP_DATE Date(10) DATE Last Scheduled Ship Date
40 FIRST_PERFORM_DT Date(10) DATE First Peformance Date
41 LAST_PERFORM_DT Date(10) DATE Last Performance Date
42 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
43 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
44 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
45 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
46 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
47 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
48 DESCR Character(30) VARCHAR2(30) NOT NULL Description
49 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
50 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
51 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
52 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
53 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
54 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.
55 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
56 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
57 COUNTER2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Counter 2
58 PPRC_LOAD_ONLY Character(1) VARCHAR2(1) NOT NULL Weight/Volume Only Pricing
59 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
60 FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag2
61 FLAG3 Character(1) VARCHAR2(1) NOT NULL Flag3
62 FLAG4 Character(1) VARCHAR2(1) NOT NULL Flag4
63 STATUS_TD Character(2) VARCHAR2(2) NOT NULL Promotion Status
CA=Customer Approved
CE=Customer Cancelled
CL=Closed
CR=Customer Rejected
MA=Management Approved
MR=Management Rejected
PA=Pending Approval
PL=Planned
RE=Recalled
RL=Released
64 TD_INT_STATUS Character(1) VARCHAR2(1) NOT NULL Interface Status
A=Not Applicable
C=Changed
D=Deleted
M=Complete
N=New
65 TD_INT_STATUS2 Character(1) VARCHAR2(1) NOT NULL Temporary Int Status
C=Changed
M=Complete
N=New
66 TD_CUST_TYPE Character(6) VARCHAR2(6) NOT NULL Customer Class
67 DISCOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
68 DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
69 DISCOUNT_PERCENT Signed Number(13,8) DECIMAL(11,8) NOT NULL 9/19/00: Discount Percent is used in the proration of AP discounts in projects.
70 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
71 BEG_ORDER_DT Date(10) DATE Beginning Order Date
72 END_ORDER_DT Date(10) DATE Ending Order Date
73 BEG_SCH_SHP_DT Date(10) DATE Beginning Schedule Ship Date
74 END_SCH_SHP_DT Date(10) DATE Ending Schedule Ship Date
75 BEG_REQ_ARR_DT Date(10) DATE Beginning Req. Arrival Date
76 END_REQ_ARR_DT Date(10) DATE Ending Req. Arrival Date
77 PPRC_KEY_VALUE1 Character(60) VARCHAR2(60) NOT NULL Price Key value 1
78 PCT_AMT_TYPE Character(1) VARCHAR2(1) NOT NULL Percent/Amount Type
A=Amount
C=New Price
P=Percent
79 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
80 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
N=No
R=By Rule
Y=By Customer
81 EOEP_RANGE_ID Number(10,0) DECIMAL(10) NOT NULL Range ID
82 TD_STOP_SEARCH Character(1) VARCHAR2(1) NOT NULL Stop Applying Discounts
83 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
84 CAP_UNITS Number(11,0) DECIMAL(11) NOT NULL Capped Units
85 TD_SEND_PRICE Character(1) VARCHAR2(1) NOT NULL Send To Pricing
86 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
87 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID
88 EFFDT Date(10) DATE Effective Date

Default Value: %date

89 TD_PCT_AMT_TYPE Character(1) VARCHAR2(1) NOT NULL Percent/Amount Type
A=Amount
P=Percent
90 TD_FG_PCT_AMT_TYPE Character(1) VARCHAR2(1) NOT NULL Product Add Percent/Amount
A=Amount
P=Percent
91 FG_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product Add
92 FG_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity/BOGO Factor
93 FG_DISCOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
94 FG_UOM Character(3) VARCHAR2(3) NOT NULL Product Add Unit Of Measure
95 EOEP_TD_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Period to date pricing
96 TD_PRICE_KEY Character(4) VARCHAR2(4) NOT NULL TD Price Key
97 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
98 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
1=Cascading
2=Summed
99 EOEP_ORD_DT_PROC Character(1) VARCHAR2(1) NOT NULL Arbitration Date
1=Defined on Arbitration Plan
2=All Order Dates
100 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field
101 EOEP_FORMULA_ID Number(10,0) DECIMAL(10) NOT NULL Pricing Formula ID
102 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
103 EOEP_LONG Long Character CLOB Price Rule Definition
104 PROMO_GROUP Character(10) VARCHAR2(10) NOT NULL Promotional Group
105 EOEP_ADJST_FLG Character(2) VARCHAR2(2) NOT NULL Adjustment Flag
01=Amount
02=Percentage
03=Price
04=External Class
05=Math Expression
06=Quantity
07=BOGO Factor
08=Quantity with Price
09=BOGO with Price
10=Quantity Expression
11=Amount And Math Expression
12=Percentage And Math Expression
13=Price And Math Expression
106 EOEP_VAR_TYPE Character(2) VARCHAR2(2) NOT NULL Pricing Variable Type
01=Base Price
02=Rollup Quantity
03=Rollup Amount
04=Rollup Weight
05=Rollup Volume
06=Net Price
07=List Price
08=Product Cost
09=Index Start Amount
10=Index Start Value
11=Index End Value
12=Trans Extended Base Price
13=Trans Extended List Price
14=Trans Extended Net Price
15=Trans Extended Product Cost
16=Alternate Product Cost
99=User Variable
107 EOEP_DATE_NAME Character(15) VARCHAR2(15) NOT NULL Date Name
108 EOEP_DATE_BREAK Character(30) VARCHAR2(30) NOT NULL Date Break
109 EOEP_FORM_BREAK Character(30) VARCHAR2(30) NOT NULL Formula Break
110 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
N=No
Y=Yes
111 EOEP_ALTCSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply to alternate cost base.
N=No
Y=Yes
112 EOEP_LISTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use list price.
N=No
Y=Yes
113 EOEP_PRC_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Indicate what to use to match price break
B=Base Price
N=Net Price
114 TD_RMA_FLG Character(1) VARCHAR2(1) NOT NULL Applicable to RMA
N=No
Y=Yes
115 EOEP_CHILD_CDS Character(64) VARCHAR2(64) NOT NULL Child Applications