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 |