Sonic Alert B31540-02 manual ATTRIBUTE15 Shiptocontact Orderline

Page 105

STATEPROVN

ADDRESS

HZ_LOCATIONS.ST

State

 

 

ATE

 

POSTALCODE

ADDRESS

HZ_LOCATIONS.

Postalcode

 

 

POSTAL_CODE

 

PARTY_EXT_ATTRI

BILL_TO_PARTY_IN

Party Extended

-

BUTES

FO

Attributes

 

ATTRIBUTE1 to

PARTY_EXT_ATTRI

HZ_PARTIES.ATTRI

Descriptive Flexfield

ATTRIBUTE15

BUTES

BUTE1 to

segment for

 

 

HZ_PARTIES.ATTRI

Customer

 

 

BUTE15

 

ACCOUNT_EXT_AT

BILL_TO_PARTY_IN

Account Extended

-

TRIBUTES

FO

Attributes

 

ATTRIBUTE1 to

ACCOUNT_EXT_AT

HZ_CUST_ACCOUN

Descriptive Flexfield

ATTRIBUTE15

TRIBUTES

TS.

segment for Account

 

 

ATTRIBUTE1 to

 

 

 

ATTRIBUTE15

 

SHIP_TO_CONTACT

ORDER_LINE

Ship to Contact

-

_INFO

 

Information

 

CONTACT_NAME

SHIP_TO_CONTACT

Ship to Contact Name

-

 

_INFO

 

 

PERSON_IDENTIFIE

CONTACT_NAME

HZ_PARTIES.PERSO

Person Identifier

R

 

N_IDENTIFIER

 

PERSON_TITLE

CONTACT_NAME

HZ_PARTIES.PERSO

Title

 

 

N_TITLE

 

PERSON_PRE_NAM

CONTACT_NAME

HZ_PARTIES.PERSO

Pre Name Adjunct

E_ADJUNCT

 

N_PRE_NAME_ADJ

 

 

 

UNCT

 

PERSON_MIDDLE_

CONTACT_NAME

HZ_PARTIES.PERSO

Middle Name

NAME

 

N_MIDDLE_NAME

 

PERSON_LAST_NA

CONTACT_NAME

HZ_PARTIES.PERSO

Last Name

ME

 

N_LAST_NAME

 

 

 

 

 

XML Messages in TBI D-41

Image 105
Contents Part No. B31540-02 Oracle Telecommunications Billing IntegratorGovernment 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 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 Account Update Details Publishing Information to the Billing ApplicationsPublishing New Account Details Publishing Sales Order Details Publishing Item/Product 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 Enhancements to Sales Order Message Enhancements to Account MessageObsoleted Billing Preference Events Obsoleted Billing Preference InformationUptake of JMS Compliant Queues in XML Gateway Implementing Telecommunications Billing Integrator Implementation ConsiderationsTBI with TSO External Billing Applications Middleware in TBIPage Implementation Tasks Setting up Profile ValuesSetting Up XML Gateway Defining XML Gateway Profile ValuesDefining Utlfiledir Parameters Defining a Hub Defining XML StandardsDefining Hub Users 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 Internal Transactions for Group Sales Order Outbound External Transactions for Sales Order OutboundExternal 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 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 EventsSetting 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 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 Procedure Insertrowbatch APIs in Telecommunications Billing IntegratorBill Summary Bulk Insert APIs Procedure Updaterowbatch Procedure InsertrowbatchParameter Name /Out Data Type Description Specifications for Billsummariestable Procedure UpdaterowbatchBill Summary Public Table Type Billsummariestable Bill Summary Public Record Type BillsummariesrecSpecifications for Billsummariesrec Attribute Name Data Type Description Mandatory attributesOptional 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 CbodInbound Messages Fields in the Advanced Queue MessageField Value XML Messages in TBI D-5 Cntrolarea BSR Structure of the Cbod XML MessageMessage 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 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