Cantara Table Object
Fields
|
Name |
Alias |
Type |
|---|---|---|
|
EdiUserId |
EDUS |
STRING |
|
EdiTransactNumber |
EDTN |
STRING |
|
EdiSuccessfullyProcess |
EDSP |
CHARACTER |
|
DataItem |
DTAI |
STRING |
|
CompanyKeyOrderNo |
KCOO |
COMPANY |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
|
OrderType |
DCTO |
UDC |
|
OrderSuffix |
SFXO |
STRING |
|
CostCenter |
MCU |
BUSINESSUNIT |
|
Company |
CO |
COMPANY |
|
CompanyKeyOriginal |
OKCO |
COMPANY |
|
OriginalPoSoNumber |
OORN |
STRING |
|
OriginalOrderType |
OCTO |
UDC |
|
CompanyKeyRelated |
RKCO |
COMPANY |
|
RelatedPoSoNumber |
RORN |
STRING |
|
RelatedOrderType |
RCTO |
UDC |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
|
AddressNumberShipTo |
SHAN |
ADDRESSNUMBER |
|
AddressNumberParent |
PA8 |
ADDRESSNUMBER |
|
DateRequestedJulian |
DRQJ |
DATE |
|
DateTransactionJulian |
TRDJ |
DATE |
|
ScheduledPickDate |
PDDJ |
DATE |
|
DateOriginalPromisde |
OPDJ |
DATE |
|
ActualShipDate |
ADDJ |
DATE |
|
CancelDate |
CNDJ |
DATE |
|
DatePriceEffectiveDate |
PEFJ |
DATE |
|
DatePromisedShipJu |
PPDJ |
DATE |
|
Reference1 |
VR01 |
STRING |
|
Reference2Vendor |
VR02 |
STRING |
|
DeliveryInstructLine1 |
DEL1 |
STRING |
|
DeliveryInstructLine2 |
DEL2 |
STRING |
|
PrintMessage1 |
INMG |
UDC |
|
PaymentTermsCode01 |
PTC |
STRING |
|
PaymentInstrumentA |
RYIN |
UDC |
|
PriceAdjustmentScheduleN |
ASN |
UDC |
|
PricingGroup |
PRGP |
UDC |
|
DiscountTrade |
TRDC |
FLOAT |
|
PercentRetainage1 |
PCRT |
FLOAT |
|
TaxArea1 |
TXA1 |
STRING |
|
TaxExplanationCode1 |
EXR1 |
UDC |
|
CertificateTaxExempt |
TXCT |
STRING |
|
AssociatedText |
ATXT |
CHARACTER |
|
PriorityProcessing |
PRIO |
UDC |
|
BackordersAllowedYN |
BACK |
CHARACTER |
|
SubstitutesAllowedYN |
SBAL |
CHARACTER |
|
NatureOfTransaction |
NTR |
UDC |
|
BuyerNumber |
ANBY |
ADDRESSNUMBER |
|
Carrier |
CARS |
ADDRESSNUMBER |
|
ModeOfTransport |
MOT |
UDC |
|
ConditionsOfTransport |
COT |
UDC |
|
RouteCode |
ROUT |
UDC |
|
StopCode |
STOP |
UDC |
|
ZoneNumber |
ZON |
UDC |
|
ContainerID |
CNID |
STRING |
|
FreightHandlingCode |
FRTH |
UDC |
|
ApplyFreightYN |
AFT |
CHARACTER |
|
ReasonCode |
RCD |
UDC |
|
AmountOrderGross |
OTOT |
FLOAT |
|
AmountTotalCost |
TOTC |
FLOAT |
|
UnitOfMeasureWhtDisp |
WUMD |
UDC |
|
UnitOfMeasureVolDisp |
VUMD |
UDC |
|
AuthorizationNoCredit |
AUTN |
STRING |
|
AcctNoCrBank |
CACT |
STRING |
|
DateExpired |
CEXP |
DATE |
|
CorrespondenceMethod |
CRMD |
UDC |
|
CurrencyMode |
CRRM |
UDC |
|
CurrencyCodeFrom |
CRCD |
STRING |
|
CurrencyConverRateOv |
CRR |
FLOAT |
|
LanguagePreference |
LNGP |
UDC |
|
AmountForeignOpen |
FAP |
FLOAT |
|
AmountForeignTotalC |
FCST |
FLOAT |
|
OrderedBy |
ORBY |
STRING |
|
OrderTakenBy |
TKBY |
STRING |
|
UserReservedCode |
URCD |
STRING |
|
UserReservedDate |
URDT |
DATE |
|
UserReservedAmount |
URAT |
FLOAT |
|
UserReservedNumber |
URAB |
INTEGER |
|
UserReservedReference |
URRF |
STRING |
|
TransactionOriginator |
TORG |
STRING |
|
UserId |
USER |
STRING |
|
ProgramId |
PID |
STRING |
|
WorkStationId |
JOBN |
STRING |
|
DateUpdated |
UPMJ |
DATE |
|
TimeOfDay |
TDAY |
INTEGER |
|
IntegrationReference01 |
IR01 |
STRING |
|
IntegrationReference02 |
IR02 |
STRING |
|
IntegrationReference03 |
IR03 |
STRING |
|
IntegrationReference04 |
IR04 |
STRING |
|
IntegrationReference05 |
IR05 |
STRING |
|
ReferenceUCISNo |
VR03 |
STRING |
|
SourceOfOrder |
SOOR |
INTEGER |
|
ScheduledShipmentTime |
PMDT |
INTEGER |
|
PromisedDeliveryTime |
RSDT |
INTEGER |
|
DateRequestedShip |
RQSJ |
DATE |
|
TimeFuture2 |
PSTM |
INTEGER |
|
PromisedPickTime |
PDTT |
INTEGER |
|
TimeOriginalPromised |
OPTT |
INTEGER |
|
RequestedDeliveryTime |
DRQT |
INTEGER |
|
ActualShipmentTime |
ADTM |
INTEGER |
|
DateActualDelivery |
ADLJ |
DATE |
|
AddressNumberPaidBy |
PBAN |
INTEGER |
|
AddressNumberInvoicedTo |
ITAN |
INTEGER |
|
AddressNumberForwardedTo |
FTAN |
INTEGER |
|
AddressNumberDeliveredTo |
DVAN |
ADDRESSNUMBER |
|
DocumentOrderInvoi |
DOC1 |
INTEGER |
|
DoctType |
DCT4 |
UDC |
|
NumberChangeOrder |
CORD |
INTEGER |
|
BuyingSegmentCode |
BSC |
UDC |
|
CurrencyCodeBase |
BCRC |
STRING |
|
HoldOrdersCode |
HOLD |
UDC |
|
ApplyFreight |
FUF1 |
UDC |
|
AddressNumberForTax |
AUFT |
UDC |
|
AddressNumberForTransportation |
AUFI |
UDC |
|
OPBusinessObjective |
OPBO |
UDC |
|
OPTotalCost |
OPTC |
FLOAT |
|
OPLatestLineDate |
OPLD |
DATE |
|
OPNumberofBackorders |
OPBK |
INTEGER |
|
OPNumberofSubstitutes |
OPSB |
INTEGER |
|
OPPromisedStatus |
OPPS |
STRING |
|
OPPartialOrderShipment |
OPPL |
CHARACTER |
|
OPAllowMultiSource |
OPMS |
CHARACTER |
|
OPAllowSubstitutes |
OPSS |
CHARACTER |
|
OPAllowBackorders |
OPBA |
CHARACTER |
|
OPPartialShipLineItems |
OPLL |
CHARACTER |
|
PartnerAddressNumber |
PRAN8 |
INTEGER |
|
PartnerContactLineNumID |
PRCIDLN |
INTEGER |
|
OpportunityId |
OPPID |
INTEGER |
|
CustomerContactLineNumberID |
CCIDLN |
INTEGER |
|
SoldToAttention |
SDATTN |
STRING |
|
ShipToCusContactLineNumID |
SHCCIDLN |
INTEGER |
|
ShipToAttention |
SPATTN |
STRING |
|
OrderTypeIndicator |
OTIND |
CHARACTER |