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