Sonic Alert B31540-02 manual Soldtoaccoun Orderheaderi Hzcustaccoun

Page 97

SOLD_TO_ACCOUN	ORDER_HEADER_I	HZ_CUST_ACCOUN	Unique Identifier for
T_	NFO	TS.	Account
NUMBER		ACCOUNT_NUMBE
		R
SOLD_TO_ACCOUN	ORDER_HEADER_I	HZ_CUST_ACCOUN	Account Name
T_	NFO	TS.
NAME		ACCOUNT_NAME
SOLD_TO_PARTY_	ORDER_HEADER_I	HZ_PARTIES.	Unique Identifier for
NUMBER	NFO	PARTY_NUMBER	Customer
NUMBER		PARTY_NUMBER
SOLD_TO_	ORDER_HEADER_I	HZ_PARTIES.PARTY	Customer Name
PARTY_NAME	NFO	_NAME
ORDER_LINE	ORDER_HEADER_I	Salesorder Line	-
	NFO	Informations
ORDER_LINE_INFO	ORDER_LINE	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
TOP_MODEL_LINE_	ORDER_LINE_INFO	OE_ORDER_LINES_	Identifier of
ID		ALL.	configuration top
		TOP_MODEL_LINE_	parent line
		TOP_MODEL_LINE_
		ID
LINK_TO_LINE_ID	ORDER_LINE_INFO	OE_ORDER_LINES_	Identifier of
		ALL.	immediate parent
		LINK_TO_LINE_ID	component line
		LINK_TO_LINE_ID
PRICE_LIST_ID	ORDER_LINE_INFO	OE_ORDER_LINES_	Price List
		ALL.
		PRICE_LIST_ID
PRICE_LIST_NAME	ORDER_LINE_INFO	QP_LIST_HEADERS_	Price List Name used
		VL.DESCRIPTION	to identify the Price
			List Name

XML Messages in TBI D-33

Image 97

Contents Part No. B31540-02 Oracle Telecommunications Billing IntegratorGovernment Rights Contents Configuring Oracle Applications InterConnect Message Maps and DTDs for XML Gateway Page Part No. B31540-02 Send Us Your CommentsVii Page Preface TTY Access to Oracle Support ServicesIntended Audience Accessibility of Code Examples in Documentation Documentation AccessibilityStructure Integration Repository Related Information SourcesGuides Related to All Products Guides Related to This ProductXii Installation and System AdministrationXiii Other Implementation DocumentationXiv Telecommunications Billing Integrator Overview Introduction to Telecommunications Billing IntegratorTelecommunications Billing Integrator Features Publishing Information to the Billing Applications Publishing Account Update DetailsPublishing New Account Details Publishing Sales Order Details Publishing Item/Product DetailsEnhancements Products Used in TBIPublishing Group Sales Order Message Details Grouped Sales Order Message Additional TCA Events for Account Update MessagePublish Bill To Accounts for a Sales Order Enhancements to Sales Order Message Enhancements to Account MessageObsoleted Billing Preference Events Obsoleted Billing Preference InformationUptake of JMS Compliant Queues in XML Gateway Implementation Considerations Implementing Telecommunications Billing IntegratorTBI with TSO External Billing Applications Middleware in TBIPage Implementation Tasks Setting up Profile ValuesDefining XML Gateway Profile Values Setting Up XML GatewayDefining Utlfiledir Parameters Defining a Hub Defining XML StandardsDefining Hub Users Standard Type Enter XMLInternal and External Transactions in XML Gateway Defining TransactionsStandard Code Select OAG External Transactions for Account Outbound Account Outbound Internal TransactionInternal Transaction for Sales Order Outbound Internal Transactions for Group Sales Order Outbound External Transactions for Sales Order OutboundExternal Transactions for Group Sales Order Outbound Internal Transacations for Inventory Item OutboundInternal Transaction for Confirm BOD Inbound External Transactions for Inventory Item OutboundExternal Transactions for Confirm BOD Inbound Transactions Enabled for TBI Transactions Enabled for TBIExternal Transactions for Confirm BOD Inbound Defining Trading Partners Setting Up Oracle Collaboration HistoryDefining Collaboration History Profile Values Lookup Type Lookup Code Description EnableDefining Lookup Values for Collaboration Lookup TypesSetting up the Final Collaboration Event Setting Up Collaboration EventsChecking Status of Agent Listeners Setting Up Bill Summary UIDefining Bill Summary UI Profile Options Bill Summary UI Profiles Values Providing Access and Enabling the Bill Summary UIProfile Option Value Personalizing Oracle Contact Center for TBI Loading Bill Summary Data Accessing the Bill Summary UI from Oracle Contact CenterIntegration with Order Management Workflow Processes Workflow Process for Publishing Account Information Workflow Process for Publishing Sales Order Information Defining Sales Order Line Profile OptionCreating the Workflow Function Setting Up and Running the Item Publish Concurrent ProgramItem Batch Export Profile Values Item Batch Export Profile ValuesSeeded Values for Item Batch Export Concurrent Program Name ValueSubmitting the Item Publish Request Subscribing to Account Update EventsEvent Name Event Display Name Description Supported EventsConfiguring the Middleware Page Oracle Applications InterConnect Overview Configuring Oracle Applications InterConnectTo stop the repository service, use the following command Setting Up OAI HubSetting up OAI Adapter for Advanced Queues Dropping the Hub Schema Importing OAI Maps to the Repository Page APIs in Telecommunications Billing Integrator Procedure InsertrowbatchBill Summary Bulk Insert APIs Procedure Insertrowbatch Procedure UpdaterowbatchParameter Name /Out Data Type Description Specifications for Billsummariestable Procedure UpdaterowbatchBill Summary Public Table Type Billsummariestable Bill Summary Public Record Type BillsummariesrecAttribute Name Data Type Description Mandatory attributes Specifications for BillsummariesrecOptional Attributes Attribute Name Data Type Description Page Maps and DTDs Overview Message Maps and DTDs for XML GatewayMaps in XML Gateway Maps in XML GatewayOpen Applications Group OAG Conforming DTDs DTDs in XML GatewayDTDs in XML Gateway Root ElementLoading and Deleting DTDs Loading and Deleting MapsPage XML Message Overview XML Messages in TBIXML Message Format Outbound and Inbound BODOutbound Messages JMS Message StructureJMS Message Structure JMS Message Header Properties for CbodFields in the Advanced Queue Message Inbound MessagesField Value XML Messages in TBI D-5 Cntrolarea BSR Structure of the Cbod XML MessageMessage Specifications for Account Message Specifications for Account InformationSeeded 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 LineTopmodelline 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 Following table lists the specifications for product Message Specifications for Product/ItemMessage Specifications for Product Message Specifications for Group Sales Order Line Message Specifications For Group Sales Order LineSoldtoaccoun 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 Workflow Function TransactionXML Gateway XML PayloadIndex-1 Index