Bookshelf v8.1/8.2: Siebel Invoice

The Siebel Invoice ASI is used by multiple Business Integration Processes, including Sync Invoice Header, Query Invoice Details, and Request Duplicate Invoice. The ASI has four types of fields associated with it, a different subset of which is used by each calling Business Integration Process to access information in an external billing system.

Table 76. Siebel Invoice ASI Fields
Name	XML Tag	Data Type	Length	Req.
Invoice
Account Id	AccountId	DTYPE_ID	Not applicable	No
Account Integration Id	AccountIntegrationId	DTYPE_TEXT	30	No
Account Location	AccountLocation	DTYPE_TEXT	30	No
Account Name	AccountName	DTYPE_TEXT	50	No
Account Organization Name	AccountOrganizationName	DTYPE_TEXT	100	No
Activity Id	ActivityId	DTYPE_ID	Not applicable	No
Activity User Defined Unique Id	ActivityUserDefinedUniqueId	DTYPE_TEXT	30	No
Amount Paid	AmountPaid	DTYPE_TEXT	Not applicable	No
Balance Forward	BalanceForward	DTYPE_TEXT	Not applicable	No
Bill To Person Id	BillToPersonId	DTYPE_TEXT	30	No
Billing End Date	BillingEndDate	DTYPE_TEXT	Not applicable	No
Billing Start Date	BillingStartDate	DTYPE_TEXT	Not applicable	No
Contract Id	ContractId	DTYPE_ID	Not applicable	No
Contract Integration Id	ContractIntegrationId	DTYPE_TEXT	30	No
Contract Name	ContractName	DTYPE_TEXT	50	No
Contract Organization Name	ContractOrganizationName	DTYPE_TEXT	100	No
Contract Revision Number	ContractRevisionNumber	DTYPE_NUMBER	Not applicable	No
Currency Code	CurrencyCode	DTYPE_TEXT	20	No
Delinquent Flag	DelinquentFlag	DTYPE_TEXT	Not applicable	No
Document Date	DocumentDate	DTYPE_TEXT	Not applicable	No
Document Description	DocumentDescription	DTYPE_TEXT	250	No
Document Number	DocumentNumber	DTYPE_TEXT	50	No
Document Period Id	DocumentPeriodId	DTYPE_ID	Not applicable	No
Document Period Name	DocumentPeriodName	DTYPE_TEXT	50	No
Document Period Organization Name	DocumentPeriodOrganizationName	DTYPE_TEXT	100	No
Document Revision Number	DocumentRevisionNumber	DTYPE_NUMBER	Not applicable	No
Document Status	DocumentStatus	DTYPE_TEXT	30	No
Document Sub Type	DocumentSubType	DTYPE_TEXT	30	No
Document Type	DocumentType	DTYPE_TEXT	30	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Order Id	OrderId	DTYPE_ID		No
Order Integration Id	OrderIntegrationId	DTYPE_TEXT	30	No
Order Number	OrderNumber	DTYPE_TEXT	30	No
Order Organization Name	OrderOrganizationName	DTYPE_TEXT	100	No
Order Type	OrderType	DTYPE_TEXT	50	No
Payment Term	PaymentTerm	DTYPE_TEXT	50	No
Payment Term Due Date	PaymentTermDueDate	DTYPE_DATETIME	Not applicable	No
Payment Term Id	PaymentTermId	DTYPE_ID	Not applicable	No
Payment Term Net Days	PaymentTermNetDays	DTYPE_NUMBER	Not applicable	No
Project Id	ProjectId	DTYPE_ID	Not applicable	No
Project Integration Id	ProjectIntegrationId	DTYPE_TEXT	30	No
Project Number	ProjectNumber	DTYPE_TEXT	30	No
Project Organization Name	ProjectOrganizationName	DTYPE_TEXT	100	No
STORED Adjustment Amount	STOREDAdjustmentAmount	DTYPE_TEXT	Not applicable	No
STORED Discount Amount	STOREDDiscountAmount	DTYPE_TEXT	Not applicable	No
STORED Gross Amount	STOREDGrossAmount	DTYPE_TEXT	Not applicable	No
STORED Surcharge Amount	STOREDSurchargeAmount	DTYPE_TEXT	Not applicable	No
STORED Tax Amount	STOREDTaxAmount	DTYPE_TEXT	Not applicable	No
Service Request Id	ServiceRequestId	DTYPE_ID	Not applicable	No
Service Request Number	ServiceRequestNumber	DTYPE_TEXT	64	No
Service Request Organization Name	ServiceRequestOrganizationName	DTYPE_TEXT	100	No
Status	Status	DTYPE_TEXT	30	No
Total Amount	TotalAmount	DTYPE_TEXT	Not applicable	No
Type Code	TypeCode	DTYPE_TEXT	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
Invoice Line Items
Activity Id	ActivityId	DTYPE_ID	Not applicable	No
Activity User Defined Unique Id	ActivityUserDefinedUniqueId	DTYPE_TEXT	30	No
Contract Id	ContractId	DTYPE_ID	Not applicable	No
Contract Integration Id	ContractIntegrationId	DTYPE_TEXT	30	No
Contract Line Id	ContractLineId	DTYPE_ID	Not applicable	No
Contract Name	ContractName	DTYPE_TEXT	50	No
Contract Organization Name	ContractOrganizationName	DTYPE_TEXT	100	No
Contract Revision Number	ContractRevisionNumber	DTYPE_NUMBER	Not applicable	No
Currency Code	CurrencyCode	DTYPE_TEXT	20	No
Description	Description	DTYPE_TEXT	250	No
Discount Amount	DiscountAmount	DTYPE_TEXT	Not applicable	No
Gross Amount	GrossAmount	DTYPE_TEXT	Not applicable	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Line Number	LineNumber	DTYPE_NUMBER	Not applicable	No
Line Quantity	LineQuantity	DTYPE_NUMBER	Not applicable	No
Line Type	LineType	DTYPE_TEXT	30	No
Order Id	OrderId	DTYPE_ID	Not applicable	No
Order Integration Id	OrderIntegrationId	DTYPE_TEXT	30	No
Order Item Id	OrderItemId	DTYPE_ID	Not applicable	No
Order Item Integration Id	OrderItemIntegrationId	DTYPE_TEXT	30	No
Order Line Number	OrderLineNumber	DTYPE_NUMBER	Not applicable	No
Order Number	OrderNumber	DTYPE_TEXT	30	No
Order Organization Name	OrderOrganizationName	DTYPE_TEXT	100	No
Order Type	OrderType	DTYPE_TEXT	50	No
Person Id	PersonId	DTYPE_ID	Not applicable	No
Product Id	ProductId	DTYPE_ID	Not applicable	No
Product Integration Id	ProductIntegrationId	DTYPE_TEXT	30	No
Product Name	ProductName	DTYPE_TEXT	100	No
Product Organization Name	ProductOrganizationName	DTYPE_TEXT	100	No
Product Vendor Organization Name	ProductVendorOrganizationName	DTYPE_TEXT	100	No
Project Id	ProjectId	DTYPE_ID	Not applicable	No
Project Integration Id	ProjectIntegrationId	DTYPE_TEXT	30	No
Project Item Id	ProjectItemId	DTYPE_ID	Not applicable	No
Project Item Number	ProjectItemNumber	DTYPE_TEXT	30	No
Project Number	ProjectNumber	DTYPE_TEXT	30	No
Project Organization Name	ProjectOrganizationName	DTYPE_TEXT	100	No
Project Resource Id	ProjectResourceId	DTYPE_ID	Not applicable	No
Project Resource Number	ProjectResourceNumber	DTYPE_TEXT	30	No
Service Request Id	ServiceRequestId	DTYPE_ID	Not applicable	No
Service Request Number	ServiceRequestNumber	DTYPE_TEXT	64	No
Service Request Organization Name	ServiceRequestOrganizationName	DTYPE_TEXT	100	No
Surcharge Amount	SurchargeAmount	DTYPE_TEXT	Not applicable	No
Tax Amount	TaxAmount	DTYPE_TEXT	Not applicable	No
Unit of Measure	UnitofMeasure	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
CME Invoice Details
Amount	Amount2	DTYPE_TEXT	Not applicable	No
Call Type	CallType	DTYPE_TEXT	Not applicable	No
Currency	Currency	DTYPE_TEXT	Not applicable	No
Date/Time	DateTime	DTYPE_TEXT	Not applicable	No
Duration	Duration	DTYPE_TEXT	Not applicable	No
Id	Id	DTYPE_ID	30	No
Invoice Header Id	InvoiceHeaderId	DTYPE_TEXT	Not applicable	No
Line Number	LineNumber	DTYPE_TEXT	Not applicable	No
Location	Location	DTYPE_TEXT	Not applicable	No
Number Called	NumberCalled	DTYPE_TEXT	Not applicable	No
Originating Number	OriginatingNumber	DTYPE_TEXT	Not applicable	No
Period	Period	DTYPE_TEXT	Not applicable	No
Rate	Rate	DTYPE_TEXT	Not applicable	No
Segment	Segment	DTYPE_TEXT	Not applicable	No
Service	Service	DTYPE_TEXT	Not applicable	No
Vid	Vid	DTYPE_ID	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
CME Invoice Duplicate Request
Copies	Copies	DTYPE_NUMBER	Not applicable	No
Id	Id	DTYPE_ID	30	No
operation	operation	DTYPE_TEXT	30	No

Siebel Application Services Interface Reference		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.