Sonic Alert B31540-02 manual Invoicetoorgi Shiptoorgid Orderlineinfo Oeorderlines

Page 99

INVOICE_TO_ORG_I

ORDER_LINE_INFO OE_ORDER_LINES_

Invoice To

D

 

ALL.

Organization ID

 

 

INVOICE_TO_ORG_I

 

 

 

D

 

SHIP_TO_ORG_ID

ORDER_LINE_INFO OE_ORDER_LINES_

Ship To Organization

 

 

ALL.

ID

 

 

SHIP_TO_ORG_ID

 

ACTION

ORDER_LINE_INFO

OE_TRANSACTION

Type of Service

 

 

_TYPES_TL.ACTION

performed on the

 

 

 

Order

CURRENCY_CODE

ORDER_LINE_INFO QP_LIST_HEADERS_

Currency Code

 

 

VL.CURRENCY_CO

 

 

 

DE

 

CHARGE_PERIODIC ORDER_LINE_INFO OE_ORDER_LINES_

Charge Periodicity

ITY_CODE

 

ALL.CHARGE_PERI

Code

 

 

ODICITY_CODE

 

CHARGE_PERIODIC ORDER_LINE_INFO MTL_UOM_CONVE

Charge Periodicity

ITY_CODE_DESC

 

RSIONS.UNIT_OF_M

Code Description

 

 

EASURE

 

ADDRESS

ORDER_LINE_INFO OE_ORDER_LINES_

Ship To Address

 

 

ALL

 

 

 

.SHIP_TO_ORG_ID

 

ADDRLINE

ADDRESS

CONCAT(

Ship 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

 

 

 

 

 

XML Messages in TBI D-35

Page 98 Page 100
Image 99
Page 98 Page 100
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 Guides Related to This Product Related Information SourcesIntegration Repository Guides Related to All ProductsXii 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 Obsoleted Billing Preference Information Enhancements to Account MessageEnhancements to Sales Order Message Obsoleted Billing Preference EventsUptake 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 Standard Type Enter XML Defining XML StandardsDefining a Hub Defining Hub UsersDefining 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 Transacations for Inventory Item Outbound External Transactions for Sales Order OutboundInternal Transactions for Group Sales Order Outbound External Transactions for Group Sales Order 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 HistoryLookup Types Lookup Type Lookup Code Description EnableDefining Collaboration History Profile Values Defining Lookup Values for CollaborationSetting 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 ProgramName Value Item Batch Export Profile ValuesItem Batch Export Profile Values Seeded Values for Item Batch Export Concurrent ProgramSubmitting 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 Bill Summary Public Record Type Billsummariesrec Procedure UpdaterowbatchSpecifications for Billsummariestable Bill Summary Public Table Type BillsummariestableSpecifications 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 GatewayRoot Element DTDs in XML GatewayOpen Applications Group OAG Conforming DTDs DTDs in XML GatewayLoading and Deleting DTDs Loading and Deleting MapsPage XML Message Overview XML Messages in TBIJMS Message Structure Outbound and Inbound BODXML Message Format Outbound MessagesJMS 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 XML Payload TransactionWorkflow Function XML GatewayIndex-1 Index
Top Page Image Contents