Bookshelf v8.1/8.2: Siebel Invoice

The Siebel Invoice ASI enables the implementation of replication of invoices from back-office accounting systems to the Siebel application, which allows sales professionals, call center agents, partners, as well as the customer, to access invoice information in the Siebel application for related inquiries. A typical process involves the creation of the invoice in the back-end system after the fulfillment of an order, which is then followed by the replication of this invoice (as well as all of its updates) in the front-end systems. The Siebel Invoice ASI enables the creation, update, deletion and queries of invoice information for inbound and outbound directions in Siebel applications.

The Siebel Invoice ASI uses the same user keys as the FS Invoice integration component. You can use the fields for the integration, which means that values for each of these fields may be written to an XML file for transport. Table 33 lists the fields and their attributes.

Table 33. Siebel Invoice ASI Fields
Name	XML Tag	Data Type	Length	Req.	Note
FS Invoice
Account Id	AccountId	DTYPE_ID	15	No	Used for picking from Picklist Account. User key field.
Account Integration Id	AccountIntegrationId	DTYPE_TEXT	30	No	Used for picking from Picklist Account. User key field.
Account Location	AccountLocation	DTYPE_TEXT	30	No	Used for picking from Picklist Account.
Account Name	AccountName	DTYPE_TEXT	50	No	Used for picking from Picklist Account.
Account Organization Name	AccountOrganizationName	DTYPE_TEXT	100	No	Used for picking from Picklist Account.
Activity Id	ActivityId	DTYPE_ID	15	No	Used for picking from FS Activity Pick List.
Activity User Defined Unique Id	ActivityUserDefinedUniqueId	DTYPE_TEXT	30	No	Used for picking from FS Activity Pick List.
Amount Paid	AmountPaid	DTYPE_CURRENCY	22	No	None
Balance Forward	BalanceForward	DTYPE_CURRENCY	22	No	None
Contract Id	ContractId	DTYPE_ID	15	No	Used for picking from Service Agreement.
Contract Integration Id	ContractIntegrationId	DTYPE_TEXT	30	No	Used for picking from Service Agreement.
Contract Name	ContractName	DTYPE_TEXT	50	No	Used for picking from Service Agreement.
Contract Organization Name	ContractOrganizationName	DTYPE_TEXT	100	No	Used for picking from Service Agreement.
Contract Revision Number	ContractRevisionNumber	DTYPE_NUMBER	22	No	Used for picking from Service Agreement.
Currency Code	CurrencyCode	DTYPE_TEXT	20	Yes	Used for picking from Picklist Currency.
Delinquent Flag	DelinquentFlag	DTYPE_BOOL	1	No	None
Document Date	DocumentDate	DTYPE_UTCDATETIME	7	No	None
Document Description	DocumentDescription	DTYPE_TEXT	250	No	None
Document Number	DocumentNumber	DTYPE_TEXT	50	Yes	User key field for Invoice.
Document Period Id	DocumentPeriodId	DTYPE_ID	15	No	Used for picking from Picklist Period.
Document Period Name	DocumentPeriodName	DTYPE_TEXT	50	No	Used for picking from Picklist Period.
Document Period Organization Name	DocumentPeriodOrganizationName	DTYPE_TEXT	100	No	Used for picking from Picklist Period.
Document Revision Number	DocumentRevisionNumber	DTYPE_NUMBER	15	No	None
Document Status	DocumentStatus	DTYPE_TEXT	30	No	Bound by FS_INVOICE_TYPE LOV.
Document Sub Type	DocumentSubType	DTYPE_TEXT	30	No	Bound by FS_INVOICE_CODE LOV.
Document Type	DocumentType	DTYPE_TEXT	30	No	Bound by FS_INVOICE_TYPE LOV. User key field.
Id	Id	DTYPE_ID	30	No	None
Integration Id	IntegrationId	DTYPE_TEXT	30	No	None
Order Id	OrderId	DTYPE_ID	15	No	Used for picking from Order Entry Picklist.
Order Integration Id	OrderIntegrationId	DTYPE_TEXT	30	No	Used for picking from Order Entry Picklist.
Order Number	OrderNumber	DTYPE_TEXT	30	No	Used for picking from Order Entry Picklist.
Order Organization Name	OrderOrganizationName	DTYPE_TEXT	100	No	Used for picking from Order Entry Picklist.
Order Type	OrderType	DTYPE_TEXT	50	No	Used for picking from Order Entry Picklist.
Payment Term	PaymentTerm	DTYPE_TEXT	50	No	Used for picking from Picklist Payment Term.
Payment Term Id	PaymentTermId	DTYPE_ID	15	No	Used for picking from Picklist Payment Term.
Project Id	ProjectId	DTYPE_ID	15	No	Used for picking from Picklist Project.
Project Integration Id	ProjectIntegrationId	DTYPE_TEXT	30	No	Used for picking from Picklist Project.
Project Number	ProjectNumber	DTYPE_TEXT	30	No	Used for picking from Picklist Project.
Project Organization Name	ProjectOrganizationName	DTYPE_TEXT	100	No	Used for picking from Picklist Project.
STORED Adjustment Amount	STOREDAdjustmentAmount	DTYPE_CURRENCY	22	No	None
STORED Discount Amount	STOREDDiscountAmount	DTYPE_CURRENCY	22	No	None
STORED Gross Amount	STOREDGrossAmount	DTYPE_CURRENCY	22	No	None
STORED Surcharge Amount	STOREDSurchargeAmount	DTYPE_CURRENCY	22	No	None
STORED Tax Amount	STOREDTaxAmount	DTYPE_CURRENCY	22	No	None
Service Request Id	ServiceRequestId	DTYPE_ID	15	No	Used for picking from Service Request Picklist.
Service Request Number	ServiceRequestNumber	DTYPE_TEXT	64	No	Used for picking from Service Request Picklist.
Service Request Organization Name	ServiceRequestOrganizationName	DTYPE_TEXT	100	No	Used for picking from Service Request Picklist.
FS Invoice Line Items
Activity Id	ActivityId	DTYPE_ID	15	No	Used for picking from FS Activity Picklist.
Activity User Defined Unique Id	ActivityUserDefinedUniqueId	DTYPE_TEXT	30	No	Used for picking from FS Activity Picklist.
Contract Id	ContractId	DTYPE_ID	15	No	Used for picking from FS PickList Agreement Item - All.
Contract Integration Id	ContractIntegrationId	DTYPE_TEXT	30	No	Used for picking from FS PickList Agreement Item - All.
Contract Line Id	ContractLineId	DTYPE_ID	15	No	Used for picking from FS PickList Agreement Item - All.
Contract Name	ContractName	DTYPE_TEXT	50	No	Used for picking from FS PickList Agreement Item - All.
Contract Organization Name	ContractOrganizationName	DTYPE_TEXT	100	No	Used for picking from FS PickList Agreement Item - All.
Contract Revision Number	ContractRevisionNumber	DTYPE_NUMBER	22	No	Used for picking from FS PickList Agreement Item - All.
CurrencyCode	CurrencyCode	DTYPE_TEXT	20	Yes	Used for picking from Picklist Currency.
Description	Description	DTYPE_TEXT	250	No	None
Discount Amount	DiscountAmount	DTYPE_CURRENCY	22	No	None
Gross Amount	GrossAmount	DTYPE_CURRENCY	22	No	None
Id	Id	DTYPE_ID	30	No	User key field for Line Item.
Integration Id	IntegrationId	DTYPE_TEXT	30	No	User key field for Line Item.
Line Number	LineNumber	DTYPE_NUMBER	22	Yes	User key field for Line Item.
Line Quantity	LineQuantity	DTYPE_NUMBER	22	Yes	None
Line Type	LineType	DTYPE_TEXT	30	No	Used for picking from FS Invoice Line Item Type Picklist.
Order Id	OrderId	DTYPE_ID	15	No	Used for picking from Order Entry Picklist.
Order Integration Id	OrderIntegrationId	DTYPE_TEXT	30	No	Used for picking from Order Entry Picklist.
Order Item Id	OrderItemId	DTYPE_ID	15	No	Used for picking from Order Entry - Line Item Picklist.
Order Item Integration Id	OrderItemIntegrationId	DTYPE_TEXT	30	No	Used for picking from Order Entry - Line Item Picklist.
Order Line Number	OrderLineNumber	DTYPE_NUMBER	22	No	Used for picking from Order Entry - Line Item Picklist.
Order Number	OrderNumber	DTYPE_TEXT	30	No	Used for picking from Order Entry - Line Item Picklist.
Order Organization Name	OrderOrganizationName	DTYPE_TEXT	100	No	Used for picking from Order Entry - Line Item Picklist.
Order Type	OrderType	DTYPE_TEXT	50	No	Used for picking from Order Entry - Line Item Picklist.
Person Id	PersonId	DTYPE_ID	15	No	Used for picking from PS PickList Project Resource.
Product Id	ProductId	DTYPE_ID	15	No	Used for picking from Order Entry - Product PickList.
Product Integration Id	ProductIntegrationId	DTYPE_TEXT	30	No	Used for picking from Order Entry - Product PickList.
Product Name	ProductName	DTYPE_TEXT	100	No	Used for picking from Order Entry - Product PickList.
Product Organization Name	ProductOrganizationName	DTYPE_TEXT	100	No	Used for picking from Order Entry - Product PickList.
Product Vendor Organization Name	ProductVendorOrganizationName	DTYPE_TEXT	100	No	Used for picking from Order Entry - Product PickList.
Project Id	ProjectId	DTYPE_ID	15	No	Used for picking from Picklist Project.
Project Integration Id	ProjectIntegrationId	DTYPE_TEXT	30	No	Used for picking from Picklist Project.
Project Item Id	ProjectItemId	DTYPE_ID	15	No	Used for picking from Project Item PickList.
Project Item Number	ProjectItemNumber	DTYPE_TEXT	30	No	Used for picking from Project Item PickList.
Project Number	ProjectNumber	DTYPE_TEXT	30	No	Used for picking from Picklist Project.
Project Organization Name	ProjectOrganizationName	DTYPE_TEXT	100	No	Used for picking from Picklist Project.
Project Resource Id	ProjectResourceId	DTYPE_ID	15	No	Used for picking from PS PickList Project Resource.
Project Resource Number	ProjectResourceNumber	DTYPE_TEXT	30	No	Used for picking from PS PickList Project Resource.
Service Request Id	ServiceRequestId	DTYPE_ID	15	No	Used for picking from Service Request Picklist.
Service Request Number	ServiceRequestNumber	DTYPE_TEXT	64	No	Used for picking from Service Request Picklist.
Service Request Organization Name	ServiceRequestOrganizationName	DTYPE_TEXT	100	No	Used for picking from Service Request Picklist.
Surcharge Amount	SurchargeAmount	DTYPE_CURRENCY	22	No	None
Tax Amount	TaxAmount	DTYPE_CURRENCY	22	No	None
Unit of Measure	UnitofMeasure	DTYPE_TEXT	30	Yes	Bound by UNIT_OF_MEASURE LOV.

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