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 following image shows the structure of the Siebel Invoice ASI, which contains the following components: FS Invoice and FS Invoice Line Item.
The following table lists the integration components of this ASI.
| Integration Component | XML Tag | User Keys |
|---|---|---|
FS Invoice (primary) |
Invoice |
|
FS Invoice Line Items |
FSInvoiceLineItems |
|
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.
FS Invoice Fields in Siebel Invoice ASI
The following table lists the FS Invoice (primary) fields and their attributes in Siebel Invoice ASI.
| Name | XML Tag | Data Type | Length | Req. | Note |
|---|---|---|---|---|---|
Account Id |
AccountId |
DTYPE_ID |
15 |
No |
User key field. Used to pick from Picklist Account. |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
User key field. Used to pick from Picklist Account. |
Account Location |
AccountLocation |
DTYPE_TEXT |
30 |
No |
Used to pick from Picklist Account. |
Account Name |
AccountName |
DTYPE_TEXT |
50 |
No |
Used to pick from Picklist Account. |
Account Organization Name |
AccountOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from Picklist Account. |
Activity Id |
ActivityId |
DTYPE_ID |
15 |
No |
Used to pick from FS Activity Pick List. |
Activity User Defined Unique Id |
ActivityUserDefinedUniqueId |
DTYPE_TEXT |
30 |
No |
Used to pick 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 to pick from Service Agreement. |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick from Service Agreement. |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Used to pick from Service Agreement. |
Contract Organization Name |
ContractOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from Service Agreement. |
Contract Revision Number |
ContractRevisionNumber |
DTYPE_NUMBER |
22 |
No |
Used to pick from Service Agreement. |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
Yes |
Used to pick 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 to pick 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 to pick 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 |
User key field. Bound by FS_INVOICE_TYPE LOV. |
Id |
Id |
DTYPE_ID |
30 |
No |
None |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
None |
Order Id |
OrderId |
DTYPE_ID |
15 |
No |
Used to pick from Order Entry Picklist. |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick from Order Entry Picklist. |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Used to pick from Order Entry Picklist. |
Order Organization Name |
OrderOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick 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 to pick from Picklist Payment Term. |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
15 |
No |
Used to pick from Picklist Payment Term. |
Project Id |
ProjectId |
DTYPE_ID |
15 |
No |
Used to pick 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 to pick from Picklist Project. |
Project Organization Name |
ProjectOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick 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 to pick from Service Request Picklist. |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
64 |
No |
Used to pick from Service Request Picklist. |
Service Request Organization Name |
ServiceRequestOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from Service Request Picklist. |
FS Invoice Line Items Fields in Siebel Invoice ASI
The following table lists the FS Invoice Line Items fields and their attributes in Siebel Invoice ASI.
| Name | XML Tag | Data Type | Length | Req. | Note |
|---|---|---|---|---|---|
Activity Id |
ActivityId |
DTYPE_ID |
15 |
No |
Used to pick from FS Activity Picklist. |
Activity User Defined Unique Id |
ActivityUserDefinedUniqueId |
DTYPE_TEXT |
30 |
No |
Used to pick from FS Activity Picklist. |
Contract Id |
ContractId |
DTYPE_ID |
15 |
No |
Used to pick from FS PickList Agreement Item - All. |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick from FS PickList Agreement Item - All. |
Contract Line Id |
ContractLineId |
DTYPE_ID |
15 |
No |
Used to pick from FS PickList Agreement Item - All. |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Used to pick from FS PickList Agreement Item - All. |
Contract Organization Name |
ContractOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from FS PickList Agreement Item - All. |
Contract Revision Number |
ContractRevisionNumber |
DTYPE_NUMBER |
22 |
No |
Used to pick from FS PickList Agreement Item - All. |
CurrencyCode |
CurrencyCode |
DTYPE_TEXT |
20 |
Yes |
Used to pick 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 to pick from FS Invoice Line Item Type Picklist. |
Order Id |
OrderId |
DTYPE_ID |
15 |
No |
Used to pick from Order Entry Picklist. |
Order Integration Id |
OrderIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick from Order Entry Picklist. |
Order Item Id |
OrderItemId |
DTYPE_ID |
15 |
No |
Used to pick from Order Entry - Line Item Picklist. |
Order Item Integration Id |
OrderItemIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick 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 to pick 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 to pick from Order Entry - Line Item Picklist. |
Person Id |
PersonId |
DTYPE_ID |
15 |
No |
Used to pick from PS PickList Project Resource. |
Product Id |
ProductId |
DTYPE_ID |
15 |
No |
Used to pick from Order Entry - Product PickList. |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick from Order Entry - Product PickList. |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Used to pick from Order Entry - Product PickList. |
Product Organization Name |
ProductOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from Order Entry - Product PickList. |
Product Vendor Organization Name |
ProductVendorOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from Order Entry - Product PickList. |
Project Id |
ProjectId |
DTYPE_ID |
15 |
No |
Used to pick from Picklist Project. |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Used to pick from Picklist Project. |
Project Item Id |
ProjectItemId |
DTYPE_ID |
15 |
No |
Used to pick 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 to pick from Picklist Project. |
Project Organization Name |
ProjectOrganizationName |
DTYPE_TEXT |
100 |
No |
Used to pick from Picklist Project. |
Project Resource Id |
ProjectResourceId |
DTYPE_ID |
15 |
No |
Used to pick from PS PickList Project Resource. |
Project Resource Number |
ProjectResourceNumber |
DTYPE_TEXT |
30 |
No |
Used to pick from PS PickList Project Resource. |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
15 |
No |
Used to pick 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 to pick 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. |