Table 33. Siebel Invoice ASI Fields
|
|
|
|
|
|
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. |