Sonic Alert B31540-02 manual Parentrelatio Relationshipinf Hzrelationship

Page 78

PARENT_RELATIO

RELATIONSHIP_INF

HZ_RELATIONSHIP

Either a forward or a

NSHIP_TYPE

O

S.

backward

 

 

RELATIONSHIP_CO

relationship code

 

 

DE

 

DATETIME

RELATIONSHIP_INF

HZ_RELATIONSHIP

Date relationship

 

O

S.END_DATE

ends

CUSTOMER_CONT

CUSTOMER_INFO

Customer Contact

-

ACT_INFO

 

Information

 

CONTACT_POINT_I

CUSTOMER_CONT

HZ_CONTACT_POI

Identifier for the

D

ACT

NTS.CONTACT_POI

customer contact

 

_INFO

NT_TYPE

point.

 

 

 

CONTACT_POINT_T

CUSTOMER_CONT

HZ_CONTACT_POI

Lookup:

YPE

ACT

NTS.CONTACT_POI

CONTACT_POINT_T

 

_INFO

NT_TYPE

YPE of phone, fax,

 

 

e-mail, web, telex, or

 

 

 

 

 

 

EDI

PRIMARY

CUSTOMER_CONT

HZ_CONTACT_POI

Flag to Identify the

 

ACT

NTS.PRIMARY_FLA

Primary Contact

 

_INFO

G

Information.

 

 

 

EDI_TRANSACTION

CUSTOMER_CONT

HZ_CONTACT_POI

ANSI standard code

_HANDLING

ACT

NTS.EDI_TRANSAC

for EDI transaction

 

TION_HANDLING

type

 

_INFO

 

 

 

EDI_ID_NUMBER

CUSTOMER_CONT

HZ_CONTACT_POI

EDI trading partner

 

ACT

NTS.EDI_ID_NUMBE

number for the

 

_INFO

R

supplier site

 

 

 

EDI_PAYMENT_ME CUSTOMER_CONT

THOD

ACT

 

_INFO

HZ_CONTACT_POI

Indicates how a

NTS.EDI_PAYMENT

payment is to be

_METHOD

made through EDI.

 

Valid methods are

 

ACH and BOP.

D-14Oracle Telecommunications Billing Integrator Implementation Guide

Image 78
Contents Oracle Telecommunications Billing Integrator Part No. B31540-02Government 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 Guides Related to All Products Related Information SourcesIntegration Repository 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 Account Update Details Publishing Information to the Billing ApplicationsPublishing New Account Details Publishing Item/Product Details Publishing Sales Order DetailsProducts 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 Obsoleted Billing Preference Events Enhancements to Account MessageEnhancements to Sales Order Message Obsoleted Billing Preference InformationUptake 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 TasksSetting Up XML Gateway Defining XML Gateway Profile ValuesDefining Utlfiledir Parameters Defining Hub Users Defining XML StandardsDefining a Hub Standard Type Enter XMLDefining 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 Group Sales Order Outbound External Transactions for Sales Order OutboundInternal Transactions for Group Sales Order Outbound Internal Transacations for Inventory Item OutboundExternal 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 PartnersDefining Lookup Values for Collaboration Lookup Type Lookup Code Description EnableDefining Collaboration History Profile Values Lookup TypesSetting Up Collaboration Events Setting up the Final Collaboration EventSetting 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 InformationSetting Up and Running the Item Publish Concurrent Program Creating the Workflow FunctionSeeded Values for Item Batch Export Concurrent Program Item Batch Export Profile ValuesItem Batch Export Profile Values 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 Procedure Insertrowbatch APIs in Telecommunications Billing IntegratorBill Summary Bulk Insert APIs Procedure Updaterowbatch Procedure InsertrowbatchParameter Name /Out Data Type Description Bill Summary Public Table Type Billsummariestable Procedure UpdaterowbatchSpecifications for Billsummariestable Bill Summary Public Record Type BillsummariesrecSpecifications for Billsummariesrec Attribute Name Data Type Description Mandatory attributesOptional Attributes Attribute Name Data Type Description Page Maps in XML Gateway Message Maps and DTDs for XML GatewayMaps and DTDs Overview Maps in XML GatewayDTDs in XML Gateway DTDs in XML GatewayOpen Applications Group OAG Conforming DTDs Root ElementLoading and Deleting Maps Loading and Deleting DTDsPage XML Messages in TBI XML Message OverviewOutbound Messages Outbound and Inbound BODXML Message Format JMS Message StructureJMS Message Header Properties for Cbod JMS Message StructureInbound Messages Fields in the Advanced Queue MessageField Value XML Messages in TBI D-5 Structure of the Cbod XML Message Cntrolarea BSRMessage 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 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 XML Gateway TransactionWorkflow Function XML PayloadIndex Index-1