Table 47. Siebel Order ASI Fields
|
|
|
|
|
Attributes |
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Attribute Id |
AttributeId |
DTYPE_ID |
NA |
No |
Data Type |
DataType |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Hidden |
Hidden |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
LOV Type |
ListOfValueType |
DTYPE_TEXT |
30 |
No |
Name |
Name |
DTYPE_TEXT |
75 |
No |
Object Id |
ObjectId |
DTYPE_ID |
NA |
No |
Read Only |
ReadOnly |
DTYPE_TEXT |
NA |
No |
Required |
Required |
DTYPE_TEXT |
NA |
No |
Sequence |
Sequence |
DTYPE_NUMBER |
NA |
No |
Validation |
Validation |
DTYPE_TEXT |
250 |
No |
Value |
Value |
DTYPE_TEXT |
100 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Line Items |
Action Code |
ActionCode |
DTYPE_TEXT |
30 |
No |
Asset Id |
AssetId |
DTYPE_ID |
NA |
No |
Asset Integration Id |
AssetIntegrationId |
DTYPE_TEXT |
30 |
No |
Asset Number |
AssetNumber |
DTYPE_TEXT |
NA |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
NA |
No |
Available Quantity |
AvailableQuantity |
DTYPE_NUMBER |
NA |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Base Price |
BasePrice |
DTYPE_TEXT |
NA |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
NA |
No |
Billing Account Id |
BillingAccountId |
DTYPE_ID |
NA |
No |
Cancelled Quantity |
CancelledQuantity |
DTYPE_NUMBER |
NA |
No |
Carrier Priority |
CarrierPriority |
DTYPE_TEXT |
30 |
No |
Covered Product Unit Price |
CoveredProductUnitPrice |
DTYPE_TEXT |
NA |
No |
Delivery Status |
DeliveryStatus |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
NA |
No |
Destination Inventory Location |
DestinationInventoryLocation |
DTYPE_TEXT |
100 |
No |
Destination Inventory Location Id |
DestinationInventoryLocationId |
DTYPE_ID |
NA |
No |
Destination Inventory Location Integration Id |
DestinationInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Discount Amount |
DiscountAmount |
DTYPE_TEXT |
NA |
No |
Extended Quantity |
ExtendedQuantity |
DTYPE_NUMBER |
NA |
No |
Freight Amount |
FreightAmount |
DTYPE_TEXT |
NA |
No |
Has Children |
HasChildren |
DTYPE_TEXT |
NA |
No |
Hold Flag |
HoldFlag |
DTYPE_TEXT |
NA |
No |
Hold Reason |
HoldReason |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Integration Status |
IntegrationStatus |
DTYPE_TEXT |
30 |
No |
Integration Status As Of Date |
IntegrationStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Invoiced Quantity |
InvoicedQuantity |
DTYPE_NUMBER |
NA |
No |
IsComplexProduct |
IsComplexProduct |
DTYPE_TEXT |
NA |
No |
Item Price |
ItemPrice |
DTYPE_TEXT |
NA |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Loaner Flag |
LoanerFlag |
DTYPE_TEXT |
NA |
No |
Net Price |
NetPrice |
DTYPE_TEXT |
NA |
No |
Note |
Note |
DTYPE_TEXT |
1,500 |
No |
Order Header Id |
OrderHeaderId |
DTYPE_ID |
NA |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Package Name (Inbound) |
PackageNameInbound |
DTYPE_TEXT |
50 |
No |
Package Name (Outbound) |
PackageNameOutbound |
DTYPE_TEXT |
NA |
No |
Parent Order Item Id |
ParentOrderItemId |
DTYPE_ID |
NA |
No |
Parent Order Item Number |
ParentOrderItemNumber |
DTYPE_NUMBER |
NA |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Partial Ship |
PartialShip |
DTYPE_TEXT |
NA |
No |
Product |
Product |
DTYPE_TEXT |
100 |
No |
Product Global Identifier |
ProductGlobalIdentifier |
DTYPE_TEXT |
50 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Port Id |
ProductPortId |
DTYPE_ID |
15 |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
NA |
No |
Return To Account DUNS Number |
ReturnToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Return To Account Id |
ReturnToAccountId |
DTYPE_ID |
NA |
No |
Return To Account Integration Id |
ReturnToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Account Name |
ReturnToAccountName |
DTYPE_TEXT |
100 |
No |
Return To Account Site |
ReturnToAccountSite |
DTYPE_TEXT |
50 |
No |
Return To Address Id |
ReturnToAddressId |
DTYPE_ID |
NA |
No |
Return To Address Integration Id |
ReturnToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact Id |
ReturnToContactId |
DTYPE_ID |
NA |
No |
Return To Contact Integration Id |
ReturnToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To First Name |
ReturnToFirstName |
DTYPE_TEXT |
50 |
No |
Return To Last Name |
ReturnToLastName |
DTYPE_TEXT |
50 |
No |
Rollup Item Price |
RollupItemPrice |
DTYPE_TEXT |
NA |
No |
Root Order Item Id |
RootOrderItemId |
DTYPE_ID |
NA |
No |
Sales Unit of Measure |
SalesUnitofMeasure |
DTYPE_TEXT |
30 |
No |
Ship Complete |
ShipComplete |
DTYPE_TEXT |
NA |
No |
Ship Date |
ShipDate |
DTYPE_DATETIME |
NA |
No |
Ship Instruction |
ShipInstruction |
DTYPE_TEXT |
250 |
No |
Ship Quantity |
ShipQuantity |
DTYPE_NUMBER |
NA |
No |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Ship To Account DUNS Number |
ShipToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
NA |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
50 |
No |
Ship To Address 2 |
ShipToAddress2 |
DTYPE_TEXT |
50 |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
NA |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
30 |
No |
Ship To Contact - First Name |
ShipToContact-FirstName |
DTYPE_TEXT |
50 |
No |
Ship To Contact - Last Name |
ShipToContact-LastName |
DTYPE_TEXT |
50 |
No |
Ship To Contact Id |
ShipToContactId |
DTYPE_ID |
NA |
No |
Ship To Contact Integration Id |
ShipToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
15 |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
15 |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
15 |
No |
Ship to Address Integration Id |
ShiptoAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Shipping Carrier |
ShippingCarrier |
DTYPE_TEXT |
30 |
No |
Shipping Charges |
ShippingCharges |
DTYPE_TEXT |
NA |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
30 |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
30 |
No |
Single Source |
SingleSource |
DTYPE_TEXT |
NA |
No |
Smart Part Number |
SmartPartNumber |
DTYPE_TEXT |
250 |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Start Price |
StartPrice |
DTYPE_TEXT |
NA |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Status As Of Date |
StatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Tax Amount |
TaxAmount |
DTYPE_TEXT |
NA |
No |
Unit Price |
UnitPrice |
DTYPE_TEXT |
NA |
No |
Unit of Measure |
UnitofMeasure |
DTYPE_TEXT |
30 |
No |
Volume |
Volume |
DTYPE_NUMBER |
NA |
No |
Volume Unit of Measure |
VolumeUnitofMeasure |
DTYPE_TEXT |
30 |
No |
Weight |
Weight |
DTYPE_NUMBER |
NA |
No |
Weight Unit of Measure |
WeightUnitofMeasure |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Orders |
Account |
Account |
DTYPE_TEXT |
100 |
No |
Account DUNS Number |
AccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Account Id |
AccountId |
DTYPE_ID |
NA |
No |
Account Integration Id |
AccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Account Site |
AccountSite |
DTYPE_TEXT |
100 |
No |
Active |
Active |
DTYPE_TEXT |
NA |
No |
Approved |
Approved |
DTYPE_TEXT |
NA |
No |
Approved By |
ApprovedBy |
DTYPE_TEXT |
NA |
No |
Approved By Date |
ApprovedByDate |
DTYPE_TEXT |
NA |
No |
Available Date |
AvailableDate |
DTYPE_TEXT |
NA |
No |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Bill To - First Name |
BillTo-FirstName |
DTYPE_TEXT |
50 |
No |
Bill To - Last Name |
BillTo-LastName |
DTYPE_TEXT |
50 |
No |
Bill To Account |
BillToAccount |
DTYPE_TEXT |
100 |
No |
Bill To Account DUNS Number |
BillToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Bill To Account Id |
BillToAccountId |
DTYPE_ID |
NA |
No |
Bill To Account Integration Id |
BillToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To Account Site |
BillToAccountSite |
DTYPE_TEXT |
50 |
No |
Bill To Address |
BillToAddress |
DTYPE_TEXT |
50 |
No |
Bill To Address 2 |
BillToAddress2 |
DTYPE_TEXT |
50 |
No |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
NA |
No |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To City |
BillToCity |
DTYPE_TEXT |
30 |
No |
Bill To Contact Id |
BillToContactId |
DTYPE_ID |
NA |
No |
Bill To Contact Integration Id |
BillToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Bill To Country |
BillToCountry |
DTYPE_TEXT |
15 |
No |
Bill To State |
BillToState |
DTYPE_TEXT |
30 |
No |
Bill To Zip |
BillToZip |
DTYPE_TEXT |
15 |
No |
Billable Flag |
BillableFlag |
DTYPE_TEXT |
NA |
No |
Billing Block |
BillingBlock |
DTYPE_TEXT |
30 |
No |
Campaign Id |
CampaignId |
DTYPE_ID |
NA |
No |
Campaign Integration Id |
CampaignIntegrationId |
DTYPE_TEXT |
30 |
No |
Campaign Name |
CampaignName |
DTYPE_TEXT |
100 |
No |
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Carrier Priority |
CarrierPriority |
DTYPE_TEXT |
30 |
No |
Comments |
Comments |
DTYPE_TEXT |
250 |
No |
Contact First Name |
ContactFirstName |
DTYPE_TEXT |
50 |
No |
Contact Id |
ContactId |
DTYPE_ID |
NA |
No |
Contact Integration Id |
ContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Contact Last Name |
ContactLastName |
DTYPE_TEXT |
50 |
No |
Contract Id |
ContractId |
DTYPE_ID |
NA |
No |
Contract Integration Id |
ContractIntegrationId |
DTYPE_TEXT |
30 |
No |
Contract Name |
ContractName |
DTYPE_TEXT |
50 |
No |
Credit Status |
CreditStatus |
DTYPE_TEXT |
NA |
No |
Currency Code |
CurrencyCode |
DTYPE_TEXT |
20 |
No |
Delivery Status |
DeliveryStatus |
DTYPE_TEXT |
30 |
No |
Description |
Description |
DTYPE_TEXT |
255 |
No |
Destination Inventory Id |
DestinationInventoryLocationId |
DTYPE_ID |
NA |
No |
Destination Inventory Location |
DestinationInventoryLocation |
DTYPE_TEXT |
100 |
No |
Destination Inventory Location Integration Id |
DestinationInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Discount Amount |
DiscountAmount |
DTYPE_TEXT |
NA |
No |
Entitlement Id |
EntitlementId |
DTYPE_ID |
NA |
No |
Entitlement Name |
EntitlementName |
DTYPE_TEXT |
50 |
No |
External Order Number |
ExternalOrderNumber |
DTYPE_TEXT |
NA |
No |
Hold Flag |
HoldFlag |
DTYPE_TEXT |
NA |
No |
Hold Reason |
HoldReason |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Integration Message |
IntegrationMessage |
DTYPE_TEXT |
2,000 |
No |
Integration Status |
IntegrationStatus |
DTYPE_TEXT |
30 |
No |
Integration Status As Of Date |
IntegrationStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Opportunity Id |
OpportunityId |
DTYPE_ID |
NA |
No |
Opportunity Integration Id |
OpportunityIntegrationId |
DTYPE_TEXT |
30 |
No |
Opportunity Name |
OpportunityName |
DTYPE_TEXT |
100 |
No |
Order Date |
OrderDate |
DTYPE_TEXT |
NA |
No |
Order Number |
OrderNumber |
DTYPE_TEXT |
30 |
No |
Order Priority |
OrderPriority |
DTYPE_TEXT |
30 |
No |
Order Type |
OrderType |
DTYPE_TEXT |
30 |
No |
Order Type Id |
OrderTypeId |
DTYPE_ID |
NA |
No |
Organization DUNS Number |
OrganizationDUNSNumber |
DTYPE_TEXT |
9 |
No |
Parent Order Id |
ParentOrderId |
DTYPE_ID |
NA |
No |
Partial Ship |
PartialShip |
DTYPE_TEXT |
NA |
No |
Pay To Account |
PayToAccount |
DTYPE_TEXT |
100 |
No |
Pay To Account DUNS Number |
PayToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Pay To Account Id |
PayToAccountId |
DTYPE_ID |
NA |
No |
Pay To Account Integration Id |
PayToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Account Site |
PayToAccountSite |
DTYPE_TEXT |
50 |
No |
Pay To Address Id |
PayToAddressId |
DTYPE_ID |
NA |
No |
Pay To Address Integration Id |
PayToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Contact First Name |
PayToContactFirstName |
DTYPE_TEXT |
50 |
No |
Pay To Contact Id |
PayToContactId |
DTYPE_ID |
NA |
No |
Pay To Contact Integration Id |
PayToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Pay To Contact Last Name |
PayToContactLastName |
DTYPE_TEXT |
50 |
No |
Payment Term |
PaymentTerm |
DTYPE_TEXT |
50 |
No |
Payment Term Id |
PaymentTermId |
DTYPE_ID |
NA |
No |
Payment Term Integration Id |
PaymentTermIntegrationId |
DTYPE_TEXT |
30 |
No |
Price List |
PriceList |
DTYPE_TEXT |
50 |
No |
Price List Id |
PriceListId |
DTYPE_ID |
NA |
No |
Price List Integration Id |
PriceListIntegrationId |
DTYPE_TEXT |
30 |
No |
Pricing Date |
PricingDate |
DTYPE_TEXT |
NA |
No |
Primary Organization |
PrimaryOrganization |
DTYPE_TEXT |
100 |
No |
Primary Organization Id |
PrimaryOrganizationId |
DTYPE_ID |
NA |
No |
Project Id |
ProjectId |
DTYPE_ID |
NA |
No |
Project Integration Id |
ProjectIntegrationId |
DTYPE_TEXT |
30 |
No |
Project Name |
ProjectName |
DTYPE_TEXT |
100 |
No |
Promotion Id |
PromotionId |
DTYPE_ID |
NA |
No |
Purchase Order Number |
PurchaseOrderNumber |
DTYPE_TEXT |
50 |
No |
Quote Id |
QuoteId |
DTYPE_ID |
NA |
No |
Quote Integration Id |
QuoteIntegrationId |
DTYPE_TEXT |
30 |
No |
Quote Number |
QuoteNumber |
DTYPE_TEXT |
30 |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Return Reason |
ReturnReason |
DTYPE_TEXT |
30 |
No |
Return To Account |
ReturnToAccount |
DTYPE_TEXT |
100 |
No |
Return To Account DUNS Number |
ReturnToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Return To Account Id |
ReturnToAccountId |
DTYPE_ID |
NA |
No |
Return To Account Integration Id |
ReturnToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Account Site |
ReturnToAccountSite |
DTYPE_TEXT |
50 |
No |
Return To Address Id |
ReturnToAddressId |
DTYPE_ID |
NA |
No |
Return To Address Integration Id |
ReturnToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact First Name |
ReturnToContactFirstName |
DTYPE_TEXT |
50 |
No |
Return To Contact Id |
ReturnToContactId |
DTYPE_ID |
NA |
No |
Return To Contact Integration Id |
ReturnToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Return To Contact Last Name |
ReturnToContactLastName |
DTYPE_TEXT |
50 |
No |
Revision |
Revision |
DTYPE_NUMBER |
NA |
No |
Service Request Id |
ServiceRequestId |
DTYPE_ID |
NA |
No |
Service Request Number |
ServiceRequestNumber |
DTYPE_TEXT |
NA |
No |
Ship Complete |
ShipComplete |
DTYPE_TEXT |
NA |
No |
Ship Instructions |
ShipInstructions |
DTYPE_TEXT |
250 |
No |
Ship To - First Name |
ShipTo-FirstName |
DTYPE_TEXT |
50 |
No |
Ship To - Last Name |
ShipTo-LastName |
DTYPE_TEXT |
50 |
No |
Ship To Account |
ShipToAccount |
DTYPE_TEXT |
100 |
No |
Ship To Account DUNS Number |
ShipToAccountDUNSNumber |
DTYPE_TEXT |
9 |
No |
Ship To Account Id |
ShipToAccountId |
DTYPE_ID |
NA |
No |
Ship To Account Integration Id |
ShipToAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Account Site |
ShipToAccountSite |
DTYPE_TEXT |
50 |
No |
Ship To Address |
ShipToAddress |
DTYPE_TEXT |
50 |
No |
Ship To Address 2 |
ShipToAddress2 |
DTYPE_TEXT |
50 |
No |
Ship To Address Id |
ShipToAddressId |
DTYPE_ID |
NA |
No |
Ship To Address Integration Id |
ShipToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To City |
ShipToCity |
DTYPE_TEXT |
30 |
No |
Ship To Contact Id |
ShipToContactId |
DTYPE_ID |
NA |
No |
Ship To Contact Integration Id |
ShipToContactIntegrationId |
DTYPE_TEXT |
30 |
No |
Ship To Country |
ShipToCountry |
DTYPE_TEXT |
15 |
No |
Ship To State |
ShipToState |
DTYPE_TEXT |
30 |
No |
Ship To Zip |
ShipToZip |
DTYPE_TEXT |
15 |
No |
Shipping Charges |
ShippingCharges |
DTYPE_TEXT |
NA |
No |
Shipping Method |
ShippingMethod |
DTYPE_TEXT |
30 |
No |
Shipping Terms |
ShippingTerms |
DTYPE_TEXT |
30 |
No |
Shipping Terms Info |
FreightTermsInfo |
DTYPE_TEXT |
100 |
No |
Source Inventory Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Loc Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Status |
Status |
DTYPE_TEXT |
30 |
No |
Status As Of Date |
StatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Submit Date |
SubmitDate |
DTYPE_TEXT |
NA |
No |
Tax Amount |
TaxAmount |
DTYPE_TEXT |
NA |
No |
Tax Exempt |
TaxExempt |
DTYPE_TEXT |
NA |
No |
Tax Exempt Code |
TaxExemptCode |
DTYPE_TEXT |
80 |
No |
Tax Exempt Id |
TaxExemptId |
DTYPE_TEXT |
30 |
No |
Tax Rate |
TaxRate |
DTYPE_NUMBER |
NA |
No |
Total Volume |
TotalVolume |
DTYPE_NUMBER |
NA |
No |
Total Volume UoM |
TotalVolumeUoM |
DTYPE_TEXT |
30 |
No |
Total Weight |
TotalWeight |
DTYPE_NUMBER |
NA |
No |
Total Weight UoM |
TotalWeightUoM |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Payments |
Account Number |
AccountNumber |
DTYPE_TEXT |
50 |
No |
Authorization Code |
AuthorizationCode |
DTYPE_TEXT |
40 |
No |
Bill To Address Id |
BillToAddressId |
DTYPE_ID |
NA |
No |
Bill To Address Integration Id |
BillToAddressIntegrationId |
DTYPE_TEXT |
30 |
No |
Card Holder |
CardHolder |
DTYPE_TEXT |
50 |
No |
Credit Card Expiration Month |
CreditCardExpirationMonth |
DTYPE_TEXT |
30 |
No |
Credit Card Expiration Year |
CreditCardExpirationYear |
DTYPE_TEXT |
30 |
No |
Credit Check Message |
CreditCheckMessage |
DTYPE_TEXT |
250 |
No |
Credit Check Status |
CreditCheckStatus |
DTYPE_TEXT |
30 |
No |
Credit Check Status As Of Date |
CreditCheckStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Encryption Key |
EncryptionKey |
DTYPE_TEXT |
30 |
No |
Encryption Key Reference |
EncryptionKeyReference |
DTYPE_TEXT |
30 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Issuing Bank Customer Id |
IssuingBankCustomerId |
DTYPE_TEXT |
30 |
No |
Issuing Bank Name |
IssuingBankName |
DTYPE_TEXT |
30 |
No |
Issuing Bank Phone Number |
IssuingBankPhoneNumber |
DTYPE_TEXT |
40 |
No |
Merchant Id |
MerchantId |
DTYPE_TEXT |
30 |
No |
Payment # |
Payment |
DTYPE_TEXT |
30 |
No |
Payment Account Id |
PaymentAccountId |
DTYPE_ID |
NA |
No |
Payment Account Integration Id |
PaymentAccountIntegrationId |
DTYPE_TEXT |
30 |
No |
Payment Account Name |
PaymentAccountName |
DTYPE_TEXT |
100 |
No |
Payment Account Site |
PaymentAccountSite |
DTYPE_TEXT |
50 |
No |
Payment Method |
PaymentMethod |
DTYPE_TEXT |
30 |
No |
Payment Status |
PaymentStatus |
DTYPE_TEXT |
30 |
No |
Payment Status As Of Date |
PaymentStatusAsOfDate |
DTYPE_DATETIME |
NA |
No |
Payment Type |
PaymentType |
DTYPE_TEXT |
30 |
No |
Transaction Amount |
TransactionAmount |
DTYPE_TEXT |
NA |
No |
Transaction Id |
TransactionId |
DTYPE_TEXT |
30 |
No |
Transaction Time |
TransactionTime |
DTYPE_TEXT |
30 |
No |
Verification Number |
VerificationNumber |
DTYPE_TEXT |
10 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Promised Schedule Lines |
Available Status |
AvailableStatus |
DTYPE_TEXT |
30 |
No |
Available Status As Of Date |
AvailableStatusAsOfDate |
DTYPE_TEXT |
NA |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Item Action Number |
LineItemActionNumber |
DTYPE_TEXT |
NA |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Order Item Integration Id |
OrderItemIntegrationId |
DTYPE_TEXT |
30 |
No |
Part Number |
PartNumber |
DTYPE_TEXT |
50 |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Product Integration Id |
ProductIntegrationId |
DTYPE_TEXT |
30 |
No |
Product Name |
ProductName |
DTYPE_TEXT |
100 |
No |
Promised Date |
PromisedDate |
DTYPE_TEXT |
NA |
No |
Promised Quantity |
PromisedQuantity |
DTYPE_NUMBER |
NA |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Organization |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Organization |
Organization |
DTYPE_TEXT |
50 |
No |
Organization Id |
OrganizationId |
DTYPE_ID |
NA |
No |
Related Sales Rep |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
IsPrimaryMVG |
IsPrimaryMVG |
DTYPE_TEXT |
1 |
No |
Login |
Login |
DTYPE_TEXT |
50 |
No |
Position |
Position |
DTYPE_TEXT |
50 |
No |
Requested Schedule Lines |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Line Number |
LineNumber |
DTYPE_NUMBER |
NA |
No |
Order Item Id |
OrderItemId |
DTYPE_ID |
NA |
No |
Requested Date |
RequestedDate |
DTYPE_TEXT |
NA |
No |
Requested Quantity |
RequestedQuantity |
DTYPE_NUMBER |
NA |
No |
Source Inventory Location |
SourceInventoryLocation |
DTYPE_TEXT |
100 |
No |
Source Inventory Location Id |
SourceInventoryLocationId |
DTYPE_ID |
NA |
No |
Source Inventory Location Integration Id |
SourceInventoryLocationIntegrationId |
DTYPE_TEXT |
30 |
No |
operation |
operation |
DTYPE_TEXT |
30 |
No |
Related Shipment |
Carrier |
Carrier |
DTYPE_TEXT |
30 |
No |
Destination Inventory Location Id |
DestinationInventoryId |
DTYPE_ID |
15 |
No |
Id |
Id |
DTYPE_ID |
30 |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
30 |
No |
Shipment Number |
ShipmentNumber |
DTYPE_TEXT |
30 |
No |
Source Inventory Location Id |
SourceInventoryId |
DTYPE_ID |
15 |
No |
Waybill Number |
WaybillNumber |
DTYPE_TEXT |
50 |
No |
operation |
operation |
DTYPE_TEXT |
NA |
No |
Shipment Item |
Confirmed Qty |
ConfirmedQty |
DTYPE_NUMBER |
NA |
No |
Delivery Date |
DeliveryDate |
DTYPE_DATETIME |
NA |
No |
Delivery Qty |
DeliveryQty |
DTYPE_NUMBER |
NA |
No |
Id |
Id |
DTYPE_ID |
NA |
No |
Integration Id |
IntegrationId |
DTYPE_TEXT |
NA |
No |
Order Line Id |
OrderLineId |
DTYPE_ID |
NA |
No |
Product Id |
ProductId |
DTYPE_ID |
NA |
No |
Shipment Date |
ShipmentDate |
DTYPE_DATETIME |
NA |
No |
Shipment Line Number |
ShipmentLineNumber |
DTYPE_TEXT |
NA |
No |
Shipment Qty |
ShipmentQty |
DTYPE_NUMBER |
NA |
No |
operation |
operation |
DTYPE_TEXT |
NA |
No |
