This appendix covers the following topics:
The seeded data in Oracle Proposals allows users to leverage default attributes and predefined parameters. Oracle Proposals can accommodate additional attributes to fit your business processes through user defined tokens. The following is a comprehensive list of the seeded data currently included in the application.
Dynamic fields that get their value from a database object are pre-seeded into the application. Sales administrators can use these dynamic fields in their component content, but are not allowed to change them.
This table lists the Proposal - General seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Proposal Name | PRP_PROPOSALS | PROPOSAL_NAME | Field Code: PRP001 RTF Display: <@PRP001:Proposal Name@> |
| Due Date | PRP_PROPOSALS | DUE_DATE | Field Code: PRP003 RTF Display: <@PRP003:Proposal Due Date@> |
| Proposal Version | PRP_PROPOSALS | Version of the proposal being generated (Latest version plus one) | Field Code: PRP011 RTF Display: <@PRP011:Proposal Version@> |
The following table lists all the Proposal - Sales Representative seeded dynamic fields.
| Dynamic field Name | Table | Comment |
|---|---|---|
| Sales Rep Name | JTF_RS_RESOURCE_EXTNS | Based on whether the user is an employee or resource, name should come from the appropriate table. Field Code: PRP012 RTF Display:<@PRP012:Sales Rep Name@> |
| Sales Rep Phone Number | JTF_RS_RESOURCE_EXTNS | Based on whether the user is an employee or resource, name should came from the appropriate table. Field Code: PRP013 RTF Display:<@PRP013:Sales Rep Phone Number@> |
| Sales Rep Fax Number | JTF_RS_RESOURCE_EXTNS | Based on whether the user is an employee or resource, name should came from the appropriate table. Field Code: PRP014 RTF Display:<@PRP014:Sales Rep Fax Number@> |
| Sales Rep Email | JTF_RS_RESOURCE_EXTNS | Based on whether the user is an employee or resource, name should came from the appropriate table. Field Code: PRP015 RTF Display:<@PRP015:Sales Rep Email@> |
| Sales Rep Address Line 1 | JTF_RS_RESOURCE_EXTNS | Field Code: PRP016 RTF Display:<@PRP016:Sales Rep Address Line 1@> |
| Sales Rep Address Line 2 | JTF_RS_RESOURCE_EXTNS | Field Code: PRP017 RTF Display:<@PRP017:Sales Rep Address Line 2@> |
| Sales Rep City | JTF_RS_RESOURCE_EXTNS | Field Code: PRP018 RTF Display:<@PRP018:Sales Rep City@> |
| Sales Rep State | JTF_RS_RESOURCE_EXTNS | Field Code: PRP019 RTF Display:<@PRP019:Sales Rep State@> |
| Sales Rep ZIP | JTF_RS_RESOURCE_EXTNS | Field Code: PRP020 RTF Display:<@PRP020:Sales Rep ZIP@> |
| Sales Rep County | JTF_RS_RESOURCE_EXTNS | Field Code: PRP021 RTF Display:<@PRP021:Sales Rep County@> |
| Sales Rep Province | JTF_RS_RESOURCE_EXTNS | Field Code: PRP022 RTF Display:<@PRP022:Sales Rep Province@> |
| Sales Rep Country | JTF_RS_RESOURCE_EXTNS | Field Code: PRP023 RTF Display:<@PRP023:Sales Rep Country@> |
| Sales Rep Job Title | JTF_RS_RESOURCE_EXTNS | Based on whether the user is an employee or resource, name should came from the appropriate table. Field Code: PRP024 RTF Display:<@PRP024:Sales Rep Job Title@> |
The following table lists the Proposal - Customer seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Customer Name | HZ_PARTIES | PARTY_NAME (for organization) PERSON_FIRST_NAME PERSON_MIDDLE_NAME PERSON_LAST_NAME (for people) |
Field Code: PRP006 RTF Display: <@PRP006:Customer Name@> |
| Contact Name | HZ_PARTIES | PERSON_FIRST_NAME PERSON_MIDDLE_NAME PERSON_LAST_NAME |
Field Code: PRP007 RTF Display: <@PRP007:Contact Name@> |
| Contact Title | HZ_PARTIES | PERSON_TITLE | Field Code: PRP008 RTF Display: <@PRP008:Contact Title@> |
| Contact Phone Number | HZ_CONTACT_POINTS | PHONE_COUNTRY_CODE, PHONE_AREA_CODE, PHONE_NUMBER, PHONE_EXTENSION | Field Code: PRP009 RTF Display: <@PRP009: Contact Phone Number@> |
| Customer Email Address | HZ_PARTIES | EMAIL_ADDRESS | Field Code: PRP010 RTF Display: <@PRP010:Customer Email@> |
This table lists the Quote Dynamic Fields - Header: General seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Quote Name | ASO_QUOTE_HEADERS_ALL | QUOTE_NAME | Field Code: PRPQOT001 RTF Display:<@PRPQOT001:Quote Name Code@> |
| Quote Number | ASO_QUOTE_HEADERS_ALL | QUOTE_NUMBER | Field Code: PRPQOT002 RTF Display:<@PRPQOT002:Quote Number@> |
| Quote Version | ASO_QUOTE_HEADERS_ALL | QUOTE_VERSION | Field Code:PRPQOT003 RTF Display:<@PRPQOT003:Quote Version@> |
| Expiration Date | ASO_QUOTE_HEADERS_ALL | QUOTE_EXPIRATION_DATE | Field Code:PRPQOT004 RTF Display: <@PRPQOT004:Expiration Date@> |
| Campaign Name | AMS_CAMPAIGNS_ALL_TL | CAMPAIGN_NAME | Field Code:PRPQOT005 RTF Display: <@PRPQOT005:Campaign Name @> |
| Quote Promotion Code | ASO_PRICE_ATTRIBUTES | PRICING_ATTRIBUTE1 | There can be multiple codes applied to a quote. Requires a repeater block. Field Code: PRPQOT006 RTF Display:<@PRPQOT006:Quote Promotion Code@> |
| Quote Promotion Name | ASO_PRICE_ATTRIBUTES | PRICING_ATTRIBUTE1 | There can be multiple codes applied to a quote. Requires a repeater block. Field Code: PRPQOT007 RTF Display:<@PRPQOT007:Quote Promotion Name@> |
| Status | ASO_QUOTE_STATUSES_TL | MEANING | Field Code: PRPQOT054 RTF Display: <@PRPQOT054:Status@> |
| Category Description | MTL_CATEGORIES_TL | DESCRIPTION | Field Code: PRPQOT150 RTF Display: <@PRPQOT150:Category Description@> |
| Category Subtotal | ASO_QUOTE_LINES_ALL | Sum of [QUANTITY ( LINE_LIST_PRICE + LINE_ADJUSTED_AMOUNT)] - Returns for each category. |
Field Code: PRPQOT151 RTF Display: <@PRPQOT151:Category Subtotal@> |
| Category Adjustment Amount | ASO_QUOTE_LINES_ALL | Sum of LINE_ADJUSTED_AMOUNT- RETURNS for each category | Field Code: PRPQOT152 RTF Display: <@PRPQOT152:Category Adjustment Amount@> |
| Category Subtotal List Price | ASO_QUOTE_LINES_ALL | Sum of LINE_LIST_PRICE for each category. | Field Code: PRPQOT153 RTF Display: <@PRPQOT153:Category Subtotal List Price@> |
This table lists the seeded Quote Header: Customer dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Sold to Cust Name | HZ_PARTIES | PARTY_NAME (for organization) or PERSON_FIRST_NAME PERSON_MIDDLE_NAME PERSON_LAST_NAME (for people) |
Field Code:PRPQOT008 RTF Display: <@PRPQOT008:Sold to Cust Name@> |
| Sold to Cust Acct Number | HZ_CUST_ACCOUNTS | ACCOUNT_NUMBER | Field Code: PRPQOT009 RTF Display: <@PRPQOT009:Sold to Cust Acct Number@> |
| Sold to Contact Name | HZ_PARTIES | PERSON_FIRST_NAME PERSON_MIDDLE_NAME PERSON_LAST_NAME PERSON_NAME_SUFFIX |
Does not exist if the customer is a party of type person. Field Code:PRPQOT010 RTF Display: <@PRPQOT010:Sold to Contact Name@> |
| Sold to Contact Title | HZ_PARTIES | PERSON_TITLE | Field Code:PRPQ0T011 RTF Display: <@PRPQOT011:Sold to Contact Title@> |
| Sold to Cust Addressee | HZ_PARTY_SITES | ADDRESSEE | Field Code:PRPQOT012 RTF Display: <@PRPQOT012:Sold to Cust Addressee@> |
| Sold to Cust Address Line 1 | HZ_LOCATIONS | ADDRESS 1 | Field Code:PRPQOT013 RTF Display: <@PRPQOT013:Sold to Cust Address Line 1@> |
| Sold to Cust Address Line 2 | HZ_LOCATIONS | ADDRESS 2 | Field Code:PRPQOT014 RTF Display: <@PRPQOT014:Sold to Cust Address Line 2@> |
| Sold to Cust City | HZ_LOCATIONS | CITY | Field Code:PRPQOT015 RTF Display: <@PRPQOT015:Sold to Cust City@> |
| Sold to Cust State | HZ_LOCATIONS | STATE | Field Code:PRPQOT016 RTF Display: <@PRPQOT016:Sold to Cust State@> |
| Sold to Cust ZIP | HZ_LOCATIONS | POSTAL_CODE | Field Code:PRPQOT017 RTF Display: <@PRPQOT017:Sold to Cust ZIP@> |
| Sold to Cust County | HZ_LOCATIONS | COUNTY | Field Code:PRPQOT018 RTF Display: <@PRPQOT018:Sold to Cust County@> |
| Sold to Cust Province | HZ_LOCATIONS | PROVINCE | Field Code:PRPQOT019 RTF Display: <@PRPQOT019:Sold to Cust Province@> |
| Sold to Cust Country | HZ_LOCATIONS | COUNTRY | Field Code:PRPQOT020 RTF Display: <@PRPQOT020:Sold to Cust Country@> |
| Sold to Contact Phone | HZ_CONTACT_POINTS | PHONE_COUNTRY_CODE PHONE_AREA_CODE PHONE_NUMBER PHONE_EXTENSION |
Field Code:PRPQOT021 RTF Display: <@PRPQOT021:Sold to Contact Phone@> |
| Sold to Cust Email | HZ_PARTIES | EMAIL_ADDRESS | Field Code:PRPQOT022 RTF Display: <@PRPQOT022:Sold to Cust Email@> |
| Bill to Customer Name | HZ_PARTIES | PARTY_NAME (for organization) PERSON_FIRST_NAME PERSON_MIDDLE_NAME | PERSON_LAST_NAME (for people) |
Field Code:PRPQOT093 RTF Display: <@PRPQOT093:Bill To Customer Name@> |
| Bill to Customer Account Number | HZ_CUST_ACCOUNTS | ACCOUNT_NUMBER | Field Code:PRPQOT094 RTF Display: <@PRPQOT094:Bill To Customer Account@> |
| Bill to Customer Addressee | HZ_PARTY_SITES | ADDRESSEE | Field Code:PRPQOT095 RTF Display: <@PRPQOT095:Bill To Customer Addressee@> |
| Bill to Customer Address Line 1 | HZ_LOCATIONS | ADDRESS 1 | Field Code:PRPQOT096 RTF Display: <@PRPQOT096:Bill To Customer Address Line 1@> |
| Bill to Customer Address Line 2 | HZ_LOCATIONS | ADDRESS 2 | Field Code:PRPQOT097 RTF Display: <@PRPQOT097:Bill To Customer Address Line 2@> |
| Bill to Customer City | HZ_LOCATIONS | CITY | Field Code:PRPQOT098 RTF Display: <@PRPQOT098:Bill To Customer City@> |
| Bill to Customer State | HZ_LOCATIONS | STATE | Field Code:PRPQOT099 RTF Display: <@PRPQOT099:Bill To Customer State@> |
| Bill to Customer ZIP | HZ_LOCATIONS | POSTAL_CODE | Field Code:PRPQOT100 RTF Display: <@PRPQOT100:Bill To Customer ZIP@> |
| Bill to Customer County | HZ_LOCATIONS | COUNTY | Field Code:PRPQOT101 RTF Display: <@PRPQOT101:Bill To Customer County@> |
| Bill to Customer Province | HZ_LOCATIONS | PROVINCE | Field Code:PRPQOT102 RTF Display: <@PRPQOT102:Bill To Customer Province@> |
| Bill to Customer Country | HZ_LOCATIONS | COUNTRY | Field Code:PRPQOT103 RTF Display: <@PRPQOT103:Bill To Customer County@> |
| Ship to Customer Name | HZ_PARTIES | PARTY_NAME (for organization) PERSON_FIRST_NAME | PERSON_MIDDLE_NAME PERSON_LAST_NAME (for people) |
Field Code:PRPQOT104 RTF Display: <@PRPQOT104:Ship To Customer Name@> |
| Ship to Customer Account Number | HZ_CUST_ACCOUNTS | ACCOUNT_NUMBER | Field Code:PRPQOT105 RTF Display: <@PRPQOT105:Ship To Customer Account Number@> |
| Ship to Customer Addressee | HZ_PARTY_SITES | ADDRESSEE | Field Code:PRPQOT106 RTF Display: <@PRPQOT106:Ship To Customer Addressee@> |
| Ship to Customer Address Line 1 | HZ_LOCATIONS | ADDRESS 1 | Field Code:PRPQOT107 RTF Display: <@PRPQOT107:Ship To Customer Address Line 1@> |
| Ship to Customer Address Line 2 | HZ_LOCATIONS | ADDRESS 2 | Field Code:PRPQOT108 RTF Display: <@PRPQOT108:Ship To Customer Address Line 2@> |
| Ship to Customer City | HZ_LOCATIONS | CITY | Field Code:PRPQOT109 RTF Display: <@PRPQOT109:Ship To Customer City@> |
| Ship to Customer State | HZ_LOCATIONS | STATE | Field Code:PRPQOT110 RTF Display: <@PRPQOT110:Ship To Customer State@> |
| Ship to Customer ZIP | HZ_LOCATIONS | POSTAL_CODE | Field Code:PRPQOT111 RTF Display: <@PRPQOT111:Ship To Customer ZIP@> |
| Ship to Customer County | HZ_LOCATIONS | COUNTY | Field Code:PRPQOT112 RTF Display: <@PRPQOT112:Ship To Customer County@> |
| Ship to Customer Province | HZ_LOCATIONS | PROVINCE | Field Code:PRPQOT113 RTF Display: <@PRPQOT113:Ship To Customer Province@> |
| Ship to Customer Country | HZ_LOCATIONS | COUNTRY | Field Code:PRPQOT114 RTF Display: <@PRPQOT114:Ship To Customer Country@> |
This table lists the Quote Header: Pricing seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Price List Name | QP_LIST_HEADERS_TL | NAME | Field Code: PRPQOT056 RTF Display: <@PRPQOT056:Price List Name@> Priority 2 |
| Currency Code | ASO_QUOTE_HEADERS | CURRENCY_CODE | Field Code: PRPQOT023 RTF Display: <@PRPQOT023:Currency Code@> |
| Total List Price | ASO_QUOTE_HEADERS | TOTAL_LIST_PRICE | Field Code:PRPQOT024 RTF Display: <@PRPQOT024:Total List Price@> |
| Total Adjustment Amount | ASO_QUOTE_HEADERS | TOTAL_ADJUSTED_AMOUNT | Can be either positive or negative amount. All adjustment types except FREIGHTS AND CHARGES. Field Code:PRPQOT025 RTF Display: <@PRPQOT025:Total Adjustment Amount@> |
| Total Adjustment Percent | ASO_QUOTE_HEADERS | TOTAL_ADJUSTMENT_PERCENT | All adjustment types except FREIGHTS AND CHARGES. Field Code:PRPQOT026 RTF Display: <@PRPQOT026:Total Adjustment Percent@> |
| Total Selling Price | Calculated | TOTAL_LIST_PRICE – TOTAL_ADJUSTED_ADMOUNT | Reflects a total of list price – adjustments Field Code:PRPQOT027 RTF Display: <@PRPQOT027:Total Selling Price@> |
| Total Tax Amount | ASO_QUOTE_HEADERS | TOTAL_TAX | Field Code:PRPQOT028 RTF Display: <@PRPQOT028:Total Tax Amount@> |
| Total Charges | ASO_QUOTE_HEADERS | TOTAL_SHIPPING_CHARGE | Field Code:PRPQOT029 RTF Display: <@PRPQOT029:Total Charges@> |
| Total Quote Price | ASO_QUOTE_HEADERS | TOTAL_QUOTE_PRICE | Total adjusted amount plus total tax and total shipping charge. Field Code:PRPQOT030 RTF Display: <@PRPQOT030:Total Quote Price@> |
| Price List Name | QP_LIST_HEADERS_TL | NAME | Field Code:PRPQOT056 RTF Display: <@PRPQOT056:Price List Name@> |
| Agreement Name | OE_AGREEMENTS_TL | NAME | Field Code:PRPQOT057 RTF Display: <@PRPQOT057:Agreement Name@> |
| Header Charge Information | ASO_PRICE_ADJUSTMENTS_V | MODIFIER_DESCRIPTION CHARGE_TYPE_CODE | CHARGE_SUBTYPE_CODE |
Field Code:PRPQOT170 RTF Display: <@PRPQOT170:Header Charge Information@> |
| Header Charge Amount | ASO_PRICE_ADJUSTMENTS_V | ADUSTED_AMOUNT | Field Code:PRPQOT171 RTF Display: <@PRPQOT171:Header Charge Amount@> |
This table lists the Quote Header - Contract seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Contract Number | OKC_K_HEADERS_B | CONTRACT_NUMBER OBJECT_VERSION_NUMBER |
Field Code:PRPQOT059 RTF Display: <@PRPQOT059:Contract Number@> |
| Contract Section | OKC_K_HEADERS_B | CONTRACT_SECTION | Field Code:PRPQOT031 RTF Display: <@PRPQOT031:Contract Section@> |
| Contract Article | OKC_K_HEADERS_B | CONTRACT_ARTICLE | Field Code:PRPQOT032 RTF Display: <@PRPQOT032:Contract Article@> |
| Contract Standard Text | OKC_K_HEADERS_B | CONTRACT_STANDARD_TEXT | Field Code: PRPQOT033 RTF Display: <@PRPQOT033:Contract Standard Text@> |
| Contract Non Standard Text | OKC_K_HEADERS_B | CONTRACT_NON_STANDARD_TEXT | Field Code: PRPQOT034 RTF Display: <@PRPQOT034:Contract Non Standard Text@> |
This table lists the Quote Header: Payment seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Payment Terms | ASO_PAYMENTS | PAYMENT_TERM_ID | Field Code:PRPQOT035 RTF Display: <@PRPQOT035:Payment Terms@> |
| Payment Type | ASO_PAYMENTS | PAYMENT_TYPE_CODE | Field Code:PRPQOT036 RTF Display: <@PRPQOT036:Payment Type@> |
| PO Number | ASO_PAYMENTS | CUST_PO_NUMBER | Field Code:PRPQOT037 RTF Display: <@PRPQOT037:PO Number@> |
| Check Number | ASO_PAYMENTS | PAYMENT_REF_NUMBER | Field Code:PRPQOT038 RTF Display: <@PRPQOT038:Check Number@> |
| Credit Card Type | ASO_PAYMENTS | CREDIT_CARD_CODE | Field Code:PRPQOT039 RTF Display: <@PRPQOT039:Credit Card Type@> |
| Credit Card Number | ASO_PAYMENTS | CREDIT_CARD_NUMBER | Field Code:PRPQOT040 RTF Display: <@PRPQOT040:Credit Card Number@> |
| Credit Card Holder Name | ASO_PAYMENTS | CREDIT_CARD_HOLDER_NAME | Field Code:PRPQOT041 RTF Display: <@PRPQOT041:Credit Card Holder Name@> |
| Credit Card Expiration | ASO_PAYMENTS | CREDIT_CARD_EXPIRATION_DATE | Field Code:PRPQOT042 RTF Display: <@PRPQOT042:Credit Card Expiration@> |
This table lists the Quote Header: Attachment seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Header Attachment Description | FND_DOCUMENTS_VL | DESCRIPTION | Field Code:PRPQOT160 RTF Display: <@PRPQOT160:Header Attachment Description@> |
| Header Attachment Text | FND_LOBS | FILE_DATA | Field Code:PRPQOT161 RTF Display: <@PRPQOT161:Header Attachment Text@> |
This tables lists the Quote Dynamic Fields - Header: Shipment seeded dynamic fields.
| Dynamic Field Name | Table | Table Column | Comment |
|---|---|---|---|
| Freight Terms | ASO_PVT_SHIPMENTS_V | FREIGHT_TERMS_CODE | Field Code: PRPQOT115 RTFDisplay: <@PRPQOT115:Freight Terms@> |
This table lists the Quote Dynamic Fields - Lines: General seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Item Number | MTL_SYSTEM_ITEMS | ITEM_NUMBER | Field Code: PRPQOT043 RTF Display: <@PRPQOT043:Item Number@> |
| Product Description | MTL_SYSTEM_ITEMS | PRODUCT_DESC | Field Code: PRPQOT044 RTF Display: <@PRPQOT044: Product Description@> |
| Unit of Measure | ASO_QUOTE_LINES_ALL | UOM_CODE | Field Code: PRPQOT045 RTF Display: <@PRPQOT045:Unit of Measure@> |
| Line Quantity | ASO_QUOTE_LINES_ALL | QUANTITY | Field Code: PRPQOT046 RTF Display: <@PRPQOT046:Line Quantity@> |
| Line Type | ASO_QUOTE_LINES_ALL | ORDER_LINE_TYPE_ID | Field Code: PRPQOT047 RTF Display: <@PRPQOT047:Line Type@> |
| Line Number | ASO_PVT_QUOTE_LINES_BALI_V | UI_LINE_NUMBER | Field Code: PRPQOT330 RTF Display: <@PRPQOT330:Line Number@> |
| Line Service Start Date | ASO_QUOTE_LINES_ALL | START_DATE_ACTIVE | Field Code: PRPQOT331 RTF Display: <@PRPQOT331:Line Service Start Date@> |
| Line Service End Date | ASO_QUOTE_LINES_ALL | END_DATE_ACTIVE | Field Code: PRPQOT332 RTF Display: <@PRPQOT332:Line Service End Date@> |
| Line Service Number | ASO_QUOTE_LINE_DETAILS | SERVICE_NUMBER | Field Code: PRPQOT333 RTF Display: <@PRPQOT333:Line Service Number@> |
| Line Service Period | ASO_QUOTE_LINE_DETAILS | SERVICE_PERIOD | Field Code: PRPQOT334 RTF Display: <@PRPQOT334:Line Service Period@> |
| Line Service Duration | ASO_QUOTE_LINE_DETAILS | SERVICE_DURATION | Field Code: PRPQOT335 RTF Display: <@PRPQOT335:Line Service Duration@> |
| Item Long Description | MTL_SYSTEM_ITEMS | LONG_DESCRIPTION | Field Code: PRPQOT336 RTF Display: <@PRPQOT336:Item Long Description@> |
This table lists the Quote Dynamic Fields - Lines: Pricing seeded dynamic fields.
| Dynamic field Name | Table | Table Column | Comment |
|---|---|---|---|
| Line Unit List Price | ASO_QUOTE_LINES_ALL | LINE_LIST_PRICE | Field Code: PRPQOT048 RTF Display: <@PRPQOT048:Line Unit List Price@> |
| Line Unit Adjustment Amount | ASO_QUOTE_LINES_ALL | LINE_ADJUSTMENT_AMOUNT | Field Code: PRPQOT049 RTF Display: <@PRPQOT049:Line Unit Adjustment Amount@> |
| Line Unit Adjustment Percent | ASO_QUOTE_LINES_ALL | LINE_ADJUSTMENT_PERCENT | Field Code: PRPQOT050 RTF Display: <@PRPQOT050:Line Unit Adjustment Percent@> |
| Line Total Selling Price | Calculated | LINE_QUOTE_PRICE*QTY | Field Code: PRPQOT052 RTF Display: <@PRPQOT052:Line Total Selling Price@> |
| Line Unit Selling Price | ASO_QUOTE_LINES_ALL | LINE_QUOTE_PRICE | Field Code: PRPQOT051 RTF Display: <@PRPQOT051:Line Unit Selling Price@> |
| Line Charge Information | ASO_PRICE_ADJUSTMENTS_V | MODIFIER_DESCRIPTION | CHARGE_TYPE_CODE | CHARGE_SUBTYPE_CODE |
Field Code: PRPQOT310 RTF Display: <@PRPQOT310:Line Charge Information@> |
| Line Charge Amount | ASO_PRICE_ADJUSTMENTS_V | ADJUSTED_AMOUNT | Field Code: PRPQOT311 RTF Display: <@PRPQOT311:Line Charge Amount@> |
| Line Tax Code | ASO_TAX_DETAILS | TAX_CODE | Field Code: PRPQOT320 RTF Display: <@PRPQOT320:Line Tax Code@> |
| Line Tax Rate | ASO_TAX_DETAILS | TAX_CODE | Field Code: PRPQOT321 RTF Display: <@PRPQOT321:Line Tax Rate@> |
| Line Tax Amount | ASO_TAX_DETAILS | TAX_AMOUNT | Field Code: PRPQOT322 RTF Display: <@PRPQOT322:Line Tax Amount@> |
These structure tokens enable users to designate the structure where multiple quotes, lines or any other data must be inserted into the document. These are only used for organizing quote-related information in RTF files.
This table lists the Structure dynamic fields:
| Group | Entry Values | Field Name | Description |
|---|---|---|---|
| Quote Structure - Header | Field Code:PRPSTR001 RTF Display: <@PRPSTR001:Begin Quote@> |
Begin Quote | Control structure to indicate quote beginning |
| Quote Structure - Header | Field Code:PRPSTR002 RTF Display: <@PRPSTR002:End Quote@> |
End Quote | Control structure to indicate quote end |
| Quote Structure - Header | Field Code:PRPSTR015 RTF Display: <@PRPSTR015:Begin Quote Category Sub Total@> |
Begin Quote Category Sub Total | Control structure to indicate quote category subtotal beginning. |
| Quote Structure - Header | Field Code:PRPSTR016 RTF Display: <@PRPSTR016:End Quote Category Sub Total@> |
End Quote Category Sub Total | Control structure to indicate quote category subtotal ending. |
| Quote Structure - Header | Field Code:PRPSTR017 RTF Display: <@PRPSTR017:Begin Quote Header Attachment Text@> |
Begin Quote Header Attachment Text | Control structure to indicate quote header attachment text beginning. |
| Quote Structure - Header | Field Code:PRPSTR018 RTF Display: <@PRPSTR018:End Quote Header Attachment Text@> |
End Quote Header Attachment Text | Control structure to indicate quote header attachment text end. |
| Quote Structure - Header | Field Code:PRPSTR019 RTF Display: <@PRPSTR019:Begin Quote Header Charges@> |
Begin Quote Header Charges | Control structure to indicate quote header charges beginning. |
| Quote Structure - Header | Field Code:PRPSTR020 RTF Display: <@PRPSTR020:End Quote Header Charges@> |
End Quote Header Charges | Control structure to indicate quote header charges end. |
| Quote Structure - Header | Field Code:PRPSTR021 RTF Display: <@PRPSTR021:Begin Quote Header Tax@>. |
Begin Quote Header Tax | Control structure to indicate quote header tax beginning. |
| Quote Structure - Header | Field Code:PRPSTR022 RTF Display: <@PRPSTR022:End Quote Header Tax@> |
End Quote Header Tax | Control structure to indicate quote header tax end. |
| Quote Structure – Line | Field Code:PRPSTR003 RTF Display: <@PRPSTR001:Begin Quote Line@> |
Begin Quote Line | Control structure to indicate quote line beginning. |
| Quote Structure – Line | Field Code:PRPSTR004 RTF Display: <@PRPSTR004:End Quote Line@> |
End Quote Line | Control structure to indicate quote line end. |
| Quote Structure – Line | Field Code:PRPSTR031 RTF Display: <@PRPSTR031:Begin Quote Line Attachment Text@> |
Begin Quote Line Attachment Text | Control structure to indicate quote line attachment text beginning. |
| Quote Structure – Line | Field Code:PRPSTR032 RTF Display: <@PRPSTR032:End Quote Line Attachment Text@> |
End Quote Line Attachment Text | Control structure to indicate quote line attachment text end. |
| Quote Structure – Line | Field Code:PRPSTR033 RTF Display: <@PRPSTR033:Begin Quote Line Charges@> |
Begin Quote Line Charges | Control structure to indicate quote line charges beginning. |
| Quote Structure – Line | Field Code:PRPSTR034 RTF Display: <@PRPSTR034:End Quote Line Charges@> |
End Quote Line Charges | Control structure to indicate quote line charges end. |
| Quote Structure – Line | Field Code:PRPSTR035 RTF Display: <@PRPSTR035:Begin Quote Line Tax@> |
Begin Quote Line Tax | Control structure to indicate quote line tax beginning. |
| Quote Structure – Line | Field Code:PRPSTR036 RTF Display: <@PRPSTR036:End Quote Line Tax@> |
End Quote Line Tax | Control structure to indicate quote line tax end. |
| Quote Structure – Contract | Field Code:PRPSTR005 RTF Display: <@PRPSTR005:Begin Contract@> |
Begin Contract | Control structure to indicate contract beginning. |
| Quote Structure – Contract | Field Code:PRPSTR006 RTF Display: <@PRPSTR006:End Contract@> |
End Contract | Control structure to indicate contract end. |
| Quote Structure – Contract | Field Code:PRPSTR007 RTF Display: <@PRPSTR007:Begin Contract Article@> |
Begin Contract Article | Control structure to indicate contract article beginning. |
| Quote Structure – Contract | Field Code:PRPSTR008 RTF Display: <@PRPSTR008:End Contract Article@> |
End Contract Article | Control structure to indicate contract article end. |
| Quote Structure – Pricing | Field Code:PRPSTR009 RTF Display: <@PRPSTR009:Begin Quote Header Promo Code@> |
Begin Quote Header Promo Code | Control structure to indicate quote header promo code beginning. |
| Quote Structure – Pricing | Field Code:PRPSTR010 RTF Display: <@PRPSTR010:End Quote Header Promo Code@> |
End Quote Header Promo Code | Control structure to indicate quote header promo code end. |