Sonic Alert B31540-02 manual Billtoownerf Billtopartyin HZPARTIES.BILLT

Page 104

BILL_TO_OWNER_F

BILL_TO_PARTY_IN

HZ_PARTIES.BILL_T

Bill To Owner Flag

LAG

FO

O_OWNER_FLAG

 

PRIMARY_BILL_TO_

BILL_TO_PARTY_IN

HZ_PARTIES.PRIMA

Primary Bill To Flag

FLAG

FO

RY_BILL_TO_FLAG

 

BILL_TO_PARTY_N

BILL_TO_PARTY_IN

HZ_PARTIES.PARTY

Unique Identifier of

UMBER

FO

_NUMBER

the Customer

BILL_TO_PARTY_N

BILL_TO_PARTY_IN

HZ_PARTIES.PARTY

Customer Name

AME

FO

_NAME

 

BILL_TO_ACCOUNT

BILL_TO_PARTY_IN

HZ_CUST_ACCOUN

Unique Identifier of

_NUMBER

FO

TS.

the Account

 

 

ACCOUNT_NUMBE

 

 

 

R

 

BILL_TO_ACCOUNT

BILL_TO_PARTY_IN

HZ_CUST_ACCOUN

Account Name

_NAME

FO

TS.

 

 

 

ACCOUNT_NAME

 

ADDRESS

BILL_TO_PARTY_IN

Bill To Address

-

 

FO

 

 

ADDRLINE

ADDRESS

CONCAT(

Bill To Address Line

 

 

HZ_LOCATIONS.AD

of the Account

 

 

 

 

 

DRESS1;HZ_LOCATI

 

 

 

ONS.ADDRESS2;HZ_

 

 

 

LOCATIONS.ADDRE

 

 

 

SS3;HZ_LOCATIONS

 

 

 

.

 

 

 

ADDRESS4)

 

CITY

ADDRESS

HZ_LOCATIONS.CI

City

 

 

TY

 

COUNTRY

ADDRESS

HZ_LOCATIONS.CO

Country

 

 

UNTRY

 

COUNTY

ADDRESS

HZ_LOCATIONS.CO

County

 

 

UNTY

 

 

 

 

 

D-40Oracle Telecommunications Billing Integrator Implementation Guide

Image 104
Contents Oracle Telecommunications Billing Integrator Part No. B31540-02Government Rights Contents Configuring Oracle Applications InterConnect Message Maps and DTDs for XML Gateway Page Vii Send Us Your CommentsPart No. B31540-02 Page Intended Audience TTY Access to Oracle Support ServicesPreface Structure Documentation AccessibilityAccessibility of Code Examples in Documentation Related Information Sources Integration RepositoryGuides Related to All Products Guides Related to This ProductInstallation and System Administration XiiOther Implementation Documentation XiiiXiv Introduction to Telecommunications Billing Integrator Telecommunications Billing Integrator OverviewTelecommunications Billing Integrator Features Publishing New Account Details Publishing Account Update DetailsPublishing Information to the Billing Applications Publishing Item/Product Details Publishing Sales Order DetailsPublishing Group Sales Order Message Details Products Used in TBIEnhancements Publish Bill To Accounts for a Sales Order Additional TCA Events for Account Update MessageGrouped Sales Order Message Enhancements to Account Message Enhancements to Sales Order MessageObsoleted Billing Preference Events Obsoleted Billing Preference InformationUptake of JMS Compliant Queues in XML Gateway TBI with TSO Implementing Telecommunications Billing IntegratorImplementation Considerations Middleware in TBI External Billing ApplicationsPage Setting up Profile Values Implementation TasksDefining Utlfiledir Parameters Setting Up XML GatewayDefining XML Gateway Profile Values Defining XML Standards Defining a HubDefining Hub Users Standard Type Enter XMLStandard Code Select OAG Defining TransactionsInternal and External Transactions in XML Gateway Internal Transaction for Sales Order Outbound Account Outbound Internal TransactionExternal Transactions for Account 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 OutboundExternal Transactions for Confirm BOD Inbound External Transactions for Inventory Item OutboundInternal Transaction for Confirm BOD Inbound External Transactions for Confirm BOD Inbound Transactions Enabled for TBITransactions Enabled for TBI Setting Up Oracle Collaboration History Defining Trading PartnersLookup Type Lookup Code Description Enable Defining Collaboration History Profile ValuesDefining Lookup Values for Collaboration Lookup TypesSetting Up Collaboration Events Setting up the Final Collaboration EventDefining Bill Summary UI Profile Options Setting Up Bill Summary UIChecking Status of Agent Listeners Profile Option Value Providing Access and Enabling the Bill Summary UIBill Summary UI Profiles Values Personalizing Oracle Contact Center for TBI Integration with Order Management Workflow Processes Accessing the Bill Summary UI from Oracle Contact CenterLoading Bill Summary Data Workflow Process for Publishing Account Information Defining Sales Order Line Profile Option Workflow Process for Publishing Sales Order InformationSetting Up and Running the Item Publish Concurrent Program Creating the Workflow FunctionItem Batch Export Profile Values Item Batch Export Profile ValuesSeeded Values for Item Batch Export Concurrent Program Name ValueSubscribing to Account Update Events Submitting the Item Publish RequestSupported Events Event Name Event Display Name DescriptionConfiguring the Middleware Page Configuring Oracle Applications InterConnect Oracle Applications InterConnect OverviewSetting Up OAI Hub To stop the repository service, use the following commandSetting up OAI Adapter for Advanced Queues Dropping the Hub Schema Importing OAI Maps to the Repository Page Bill Summary Bulk Insert APIs Procedure InsertrowbatchAPIs in Telecommunications Billing Integrator Parameter Name /Out Data Type Description Procedure UpdaterowbatchProcedure Insertrowbatch Procedure Updaterowbatch Specifications for BillsummariestableBill Summary Public Table Type Billsummariestable Bill Summary Public Record Type BillsummariesrecOptional Attributes Specifications for BillsummariesrecAttribute Name Data Type Description Mandatory attributes Attribute Name Data Type Description Page Message Maps and DTDs for XML Gateway Maps and DTDs OverviewMaps in XML Gateway Maps in XML GatewayDTDs in XML Gateway Open Applications Group OAG Conforming DTDsDTDs in XML Gateway Root ElementLoading and Deleting Maps Loading and Deleting DTDsPage XML Messages in TBI XML Message OverviewOutbound and Inbound BOD XML Message FormatOutbound Messages JMS Message StructureJMS Message Header Properties for Cbod JMS Message StructureField Value Inbound MessagesFields in the Advanced Queue Message XML Messages in TBI D-5 Structure of the Cbod XML Message Cntrolarea BSRSeeded XML Messages Message Specifications for Account InformationMessage Specifications for Account 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 Message Specifications for Product/Item Following table lists the specifications for productMessage 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 Transaction Workflow FunctionXML Gateway XML PayloadIndex Index-1