Table 53. Siebel Order/External Order ASI Fields
Name
|
XML Tag
|
Data Type
|
Length
|
Req.
|
Notes
|
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
|
|
Lines
|
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
|
UAN: Added for UAN 3.0
|
Covered Product Unit Price
|
CoveredProductUnitPrice
|
DTYPE_TEXT
|
|
N
|
UAN: Added for UAN 1.0
|
Delivery Status
|
DeliveryStatus
|
DTYPE_TEXT
|
30
|
N
|
UAN: 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
|
UAN: Added for UAN 3.0
|
Freight Amount
|
FreightAmount
|
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 Status
|
IntegrationStatus
|
DTYPE_TEXT
|
30
|
N
|
|
Integration Status As Of Date
|
IntegrationStatusAsOfDate
|
DTYPE_TEXT
|
|
N
|
|
Invoiced Quantity
|
InvoicedQuantity
|
DTYPE_NUMBER
|
|
N
|
|
Item Price
|
ItemPrice
|
DTYPE_TEXT
|
|
N
|
UAN: Added for UAN 3.0
|
Line Number
|
LineNumber
|
DTYPE_NUMBER
|
|
N
|
|
Loaner Flag
|
LoanerFlag
|
DTYPE_TEXT
|
|
N
|
|
Net Price
|
NetPrice
|
DTYPE_TEXT
|
|
N
|
UAN: 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
|
UAN: 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
|
UAN: Added for UAN 1.0
|
Product Id
|
ProductId
|
DTYPE_ID
|
|
N
|
|
Product Integration Id
|
ProductIntegrationId
|
DTYPE_TEXT
|
30
|
N
|
|
Requested Date
|
RequestedDate
|
DTYPE_TEXT
|
|
N
|
|
Requested Quantity
|
RequestedQuantity
|
DTYPE_NUMBER
|
|
N
|
|
Return To Account DUNS Number
|
ReturnToAccountDUNSNumber
|
DTYPE_TEXT
|
9
|
N
|
UAN: 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
|
UAN: 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
|
UAN: 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
|
UAN: Added for UAN 1.0
|
Ship To Address 2
|
ShipToAddress2
|
DTYPE_TEXT
|
50
|
N
|
UAN: Added for UAN 1.0
|
Ship To Address Id
|
ShipToAddressId
|
DTYPE_ID
|
|
N
|
|
Ship To City
|
ShipToCity
|
DTYPE_TEXT
|
30
|
N
|
UAN: 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
|
UAN: Added for UAN 1.0
|
Ship To State
|
ShipToState
|
DTYPE_TEXT
|
15
|
N
|
UAN: Added for UAN 1.0
|
Ship To Zip
|
ShipToZip
|
DTYPE_TEXT
|
15
|
N
|
UAN: 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
|
UAN: 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
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
Bill To Address 2
|
BillToAddress2
|
DTYPE_TEXT
|
50
|
N
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
Bill To State
|
BillToState
|
DTYPE_TEXT
|
30
|
N
|
UAN: Added for UAN 1.0
|
Bill To Zip
|
BillToZip
|
DTYPE_TEXT
|
15
|
N
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
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
|
UAN: 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 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
|
UAN: 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
|
UAN: Added for UAN 1.0
|
Ship To Address 2
|
ShipToAddress2
|
DTYPE_TEXT
|
50
|
N
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
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
|
UAN: Added for UAN 1.0
|
Ship To State
|
ShipToState
|
DTYPE_TEXT
|
30
|
N
|
UAN: Added for UAN 1.0
|
Ship To Zip
|
ShipToZip
|
DTYPE_TEXT
|
15
|
N
|
UAN: Added for UAN 1.0
|
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 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
|
UAN: Added for UAN 1.0
|
Destination Inventory Location Id
|
DestinationInventoryId
|
DTYPE_ID
|
15
|
N
|
UAN: 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
|
UAN: Added for UAN 1.0
|
Waybill Number
|
WaybillNumber
|
DTYPE_TEXT
|
50
|
N
|
UAN: Added for UAN 1.0
|
operation
|
operation
|
DTYPE_TEXT
|
|
N
|
|
Shipment Line
|
Confirmed Qty
|
ConfirmedQty
|
DTYPE_NUMBER
|
|
N
|
UAN: Added for UAN 1.0
|
Delivery Date
|
DeliveryDate
|
DTYPE_DATETIME
|
|
N
|
UAN: Added for UAN 1.0
|
Delivery Qty
|
DeliveryQty
|
DTYPE_NUMBER
|
|
N
|
UAN: Added for UAN 1.0
|
Id
|
Id
|
DTYPE_ID
|
|
N
|
UAN: Added for UAN 1.0
|
Integration Id
|
IntegrationId
|
DTYPE_TEXT
|
|
N
|
UAN: Added for UAN 1.0
|
Order Line Id
|
OrderLineId
|
DTYPE_ID
|
|
N
|
UAN: Added for UAN 1.0
|
Product Id
|
ProductId
|
DTYPE_ID
|
|
N
|
UAN: Added for UAN 3.0
|
Shipment Date
|
ShipmentDate
|
DTYPE_DATETIME
|
|
N
|
UAN: Added for UAN 1.0
|
Shipment Line Number
|
ShipmentLineNumber
|
DTYPE_TEXT
|
|
N
|
UAN: Added for UAN 1.0
|
Shipment Qty
|
ShipmentQty
|
DTYPE_NUMBER
|
|
N
|
UAN: Added for UAN 1.0
|
operation
|
operation
|
DTYPE_TEXT
|
|
N
|
|
