Message Specifications for Sales Order Line | Sonic Alert B31540-02

STANDARD_TERMS	CREDIT_CLASSIFIC	HZ_CUSTOMER_PR	Standard terms
	ATION_INFO	OFILES.
		STANDARD_TERMS
OVERRIDE_TERMS	CREDIT_CLASSIFIC	HZ_CUSTOMER_PR	Override terms
	ATION_INFO	OFILES.
		OVERRIDE_TERMS
DATETIME	CREDIT_CLASSIFIC	HZ_CUSTOMER_PR	Last credit review
	ATION_INFO	OFILES.	date
		LAST_CREDIT_REVI
		EW_DATE
CREDIT_CLASSIFIC	CREDIT_CLASSIFIC	HZ_CUSTOMER_PR	Credit classification
ATION	ATION_INFO	OFILES.
		CREDIT_CLASSIFIC
		ATION
CREDIT_EXTENDED	CREDIT_CLASSIFIC	Credit classification	-
_ATTRIBUTES	ATION_INFO	extended attributes
ATTRIBUTE1 to	CREDIT_EXTENDED	HZ_CUSTOMER_PR	Extended attributes
ATTRIBUTE15	_ATTRIBUTES	OFILES.
		ATTRIBUTE1 to
		ATTRIBUTE15

Message Specifications for Sales Order Line

The following table lists the specifications for sales order line information.

Message Specifications for Sales Order Line

XML TagT	XML Parent Tag	Field in E-Business	Description
		Suite
ORDER_LINE_INFO	DATAAREA	Sales order line	-
		information
ORDER_LINE_ID	ORDER_LINE_INFO	OE_ORDER_LINES_	Primary Key to
		ALL.	identify the Order
		LINE_ID	Line
		LINE_ID

D-20Oracle Telecommunications Billing Integrator Implementation Guide

Image 84

Sonic Alert B31540-02 manual Message Specifications for Sales Order Line

Contents

Oracle Telecommunications Billing Integrator Part No. B31540-02 Government Rights Contents Configuring Oracle Applications InterConnect Message Maps and DTDs for XML Gateway Page Send Us Your Comments Part No. B31540-02Vii Page TTY Access to Oracle Support Services PrefaceIntended Audience Documentation Accessibility Accessibility of Code Examples in DocumentationStructure Related Information Sources Integration RepositoryGuides Related to All Products Guides Related to This Product Installation and System Administration Xii Other Implementation Documentation Xiii Xiv Introduction to Telecommunications Billing Integrator Telecommunications Billing Integrator Overview Telecommunications Billing Integrator Features Publishing Account Update Details Publishing Information to the Billing ApplicationsPublishing New Account Details Publishing Item/Product Details Publishing Sales Order Details Products Used in TBI EnhancementsPublishing Group Sales Order Message Details Additional TCA Events for Account Update Message Grouped Sales Order MessagePublish Bill To Accounts for a Sales Order Enhancements to Account Message Enhancements to Sales Order MessageObsoleted Billing Preference Events Obsoleted Billing Preference Information Uptake of JMS Compliant Queues in XML Gateway Implementing Telecommunications Billing Integrator Implementation ConsiderationsTBI with TSO Middleware in TBI External Billing ApplicationsPage Setting up Profile Values Implementation Tasks Setting Up XML Gateway Defining XML Gateway Profile ValuesDefining Utlfiledir Parameters Defining XML Standards Defining a HubDefining Hub Users Standard Type Enter XML Defining Transactions Internal and External Transactions in XML GatewayStandard Code Select OAG Account Outbound Internal Transaction External Transactions for Account OutboundInternal Transaction for Sales Order Outbound External Transactions for Sales Order Outbound Internal Transactions for Group Sales Order OutboundExternal Transactions for Group Sales Order Outbound Internal Transacations for Inventory Item Outbound External Transactions for Inventory Item Outbound Internal Transaction for Confirm BOD InboundExternal Transactions for Confirm BOD Inbound Transactions Enabled for TBI Transactions Enabled for TBIExternal Transactions for Confirm BOD Inbound Setting Up Oracle Collaboration History Defining Trading Partners Lookup Type Lookup Code Description Enable Defining Collaboration History Profile ValuesDefining Lookup Values for Collaboration Lookup Types Setting Up Collaboration Events Setting up the Final Collaboration Event Setting Up Bill Summary UI Checking Status of Agent ListenersDefining Bill Summary UI Profile Options Providing Access and Enabling the Bill Summary UI Bill Summary UI Profiles ValuesProfile Option Value Personalizing Oracle Contact Center for TBI Accessing the Bill Summary UI from Oracle Contact Center Loading Bill Summary DataIntegration with Order Management Workflow Processes Workflow Process for Publishing Account Information Defining Sales Order Line Profile Option Workflow Process for Publishing Sales Order Information Setting Up and Running the Item Publish Concurrent Program Creating the Workflow Function Item Batch Export Profile Values Item Batch Export Profile ValuesSeeded Values for Item Batch Export Concurrent Program Name Value Subscribing to Account Update Events Submitting the Item Publish Request Supported Events Event Name Event Display Name Description Configuring the Middleware Page Configuring Oracle Applications InterConnect Oracle Applications InterConnect Overview Setting Up OAI Hub To stop the repository service, use the following command Setting up OAI Adapter for Advanced Queues Dropping the Hub Schema Importing OAI Maps to the Repository Page Procedure Insertrowbatch APIs in Telecommunications Billing IntegratorBill Summary Bulk Insert APIs Procedure Updaterowbatch Procedure InsertrowbatchParameter Name /Out Data Type Description Procedure Updaterowbatch Specifications for BillsummariestableBill Summary Public Table Type Billsummariestable Bill Summary Public Record Type Billsummariesrec Specifications for Billsummariesrec Attribute Name Data Type Description Mandatory attributesOptional Attributes Attribute Name Data Type Description Page Message Maps and DTDs for XML Gateway Maps and DTDs OverviewMaps in XML Gateway Maps in XML Gateway DTDs in XML Gateway Open Applications Group OAG Conforming DTDsDTDs in XML Gateway Root Element Loading and Deleting Maps Loading and Deleting DTDsPage XML Messages in TBI XML Message Overview Outbound and Inbound BOD XML Message FormatOutbound Messages JMS Message Structure JMS Message Header Properties for Cbod JMS Message Structure Inbound Messages Fields in the Advanced Queue MessageField Value XML Messages in TBI D-5 Structure of the Cbod XML Message Cntrolarea BSR Message Specifications for Account Information Message Specifications for AccountSeeded XML Messages Accountname Accountinfo Hzcustaccoun Relationshipty Relatedaccoun Hzcustacctre Datetime Taxexemptions Rataxexemptio Receiptmethod Receiptmethods Arreceiptmeth Emailaddress Customerinfo HZPARTIES.EMAIL Addrline Address Contact Parentrelatio Relationshipinf Hzrelationship Edipaymentfor Customercont MAT ACT Partygroup Customercont HZLOCATIONS.AD Amount Custprofileam Hzcustprofile Datetime Custprofileam Hzcustprofile Message Specifications for Sales Order Line Message Specifications for Sales Order Line Topmodelline Orderlineinfo Oeorderlines Inventoryitem Orderlineinfo Mtlsystemitem Shiptoorgid Orderlineinfo Oeorderlines Stateprovn Address HZLOCATIONS.ST Extattributes Oeorderlines Lastoeorderl Installbaseinf Csiiteminstanc Attributename Attributeinfo Csiiextendeda Billtoownerf Billtopartyin HZPARTIES.BILLT Postalcode Partyextattri Billtopartyin Message Specifications for Product/Item Following table lists the specifications for product Message Specifications for Product Message Specifications For Group Sales Order Line Message Specifications for Group Sales Order Line Soldtoaccoun Orderheaderi Hzcustaccoun ALL Inventoryitem Inventoryitem Orderlineinfo Mtlsystemitem Invoicetoorgi Shiptoorgid Orderlineinfo Oeorderlines County Address HZLOCATIONS.CO ATTRIBUTE1 Lastoeorderl Installbaseinf Csiiteminstanc XML Messages in TBI D-39 Billtoownerf Billtopartyin HZPARTIES.BILLT ATTRIBUTE15 Shiptocontact Orderline Personnamesu Contactname HZPARTIES.PERSO Glossary Transaction Workflow FunctionXML Gateway XML Payload Index Index-1