Cantara Table Object
Fields
|
Name |
Alias |
Type |
|---|---|---|
|
EdiTransactNumber |
EDTN |
STRING |
|
EdiUserId |
EDUS |
STRING |
|
EdiSuccessfullyProcess |
EDSP |
CHARACTER |
|
DataItem |
DTAI |
STRING |
|
ActionCode2 |
ACTN |
CHARACTER |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
|
OrderType |
DCTO |
UDC |
|
CompanyKeyOrderNo |
KCOO |
COMPANY |
|
CostCenter |
MCU |
BUSINESSUNIT |
|
Company |
CO |
COMPANY |
|
CompanyKeyRelated |
RKCO |
COMPANY |
|
RelatedPoSoNumber |
RORN |
STRING |
|
RelatedOrderType |
RCTO |
UDC |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
|
AddressNumberShipTo |
SHAN |
ADDRESSNUMBER |
|
AddressNumberDeliveredTo |
DVAN |
ADDRESSNUMBER |
|
AddressNumberParent |
PA8 |
ADDRESSNUMBER |
|
AddressNumberPaidBy |
PBAN |
INTEGER |
|
AddressNumberInvoicedTo |
ITAN |
INTEGER |
|
AddressNumberForwardedTo |
FTAN |
INTEGER |
|
Reference1 |
54RREF1 |
STRING |
|
Reference2 |
54RREF2 |
STRING |
|
BillingFrequencyCode |
BLFC |
CHARACTER |
|
ContractStatus |
54RCNTST |
UDC |
|
DateTransaction |
54RCTJ |
DATE |
|
TimeTransaction |
54RCTT |
INTEGER |
|
DateStart |
54RCSD |
DATE |
|
TimeStart |
54RCST |
INTEGER |
|
DateDelivery |
54RCDD |
DATE |
|
TimeDelivery |
54RCDT |
INTEGER |
|
DateDeliveryActual |
54RCDAD |
DATE |
|
TimeDeliveryActual |
54RCDAT |
INTEGER |
|
DateInstall |
54RCID |
DATE |
|
TimeInstall |
54RCIT |
INTEGER |
|
DateProjectedEnd |
54RCPED |
DATE |
|
TimeProjectedEnd |
54RCPET |
INTEGER |
|
DateActualEnd |
54RCAED |
DATE |
|
TimeActualEnd |
54RCAET |
INTEGER |
|
DateBillingStart |
54RCBSD |
DATE |
|
TimeBillingStart |
54RCBST |
INTEGER |
|
DateBillingEnd |
54RCBED |
DATE |
|
TimeBillingEnd |
54RCBET |
INTEGER |
|
DateLastInvoiceJulian |
DLIJ |
DATE |
|
Reference11 |
VR01 |
STRING |
|
Reference2Vendor |
VR02 |
STRING |
|
ReferenceUCISNo |
VR03 |
STRING |
|
DeliveryInstructLine1 |
DEL1 |
STRING |
|
DeliveryInstructLine2 |
DEL2 |
STRING |
|
ReservationContract |
54RARSVD |
CHARACTER |
|
DateReservation |
54RCRD |
DATE |
|
TimeReservation |
54RCRT |
INTEGER |
|
DateReservationCancellation |
54RCRCD |
DATE |
|
TimeReservationCancellation |
54RCRCT |
INTEGER |
|
ContractMessage |
54RMSTRC |
UDC |
|
PaymentTermsCode01 |
PTC |
STRING |
|
PaymentInstrumentA |
RYIN |
UDC |
|
PriceAdjustmentScheduleN |
ASN |
UDC |
|
PricingGroup |
PRGP |
UDC |
|
DiscountTrade |
TRDC |
FLOAT |
|
TaxExplanationCode1 |
EXR1 |
UDC |
|
TaxArea1 |
TXA1 |
STRING |
|
CertificateTaxExempt |
TXCT |
STRING |
|
HoldOrdersCode |
HOLD |
UDC |
|
NatureOfTransaction |
NTR |
UDC |
|
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 |
|
AcctNoCrBank |
CACT |
STRING |
|
DateExpired |
CEXP |
DATE |
|
CurrencyMode |
CRRM |
UDC |
|
CurrencyCodeFrom |
CRCD |
STRING |
|
CurrencyConverRateOv |
CRR |
FLOAT |
|
CurrencyCodeBase |
BCRC |
STRING |
|
DateExchangeRate |
ERDT |
DATE |
|
BilledCurrencyCode |
BILLCRCD |
STRING |
|
OrderedBy |
ORBY |
STRING |
|
OrderTakenBy |
TKBY |
STRING |
|
DateUpdated |
UPMJ |
DATE |
|
DateEntered1 |
ENTJ |
DATE |
|
UserId |
USER |
STRING |
|
ProgramId |
PID |
STRING |
|
TimeLastUpdated |
UPMT |
INTEGER |
|
WorkStationId |
JOBN |
STRING |
|
MachineKey |
MKEY |
STRING |
|
TransactionOriginator |
TORG |
STRING |
|
UserReservedCode |
URCD |
STRING |
|
UserReservedDate |
URDT |
DATE |
|
UserReservedAmount |
URAT |
FLOAT |
|
UserReservedNumber |
URAB |
INTEGER |
|
UserReservedReference |
URRF |
STRING |
|
TimeEnteredProg |
TENT |
INTEGER |
|
InsuranceType |
54RIT |
UDC |
|
InsurancePolicy |
54RIP |
STRING |
|
ExchRateFixedVar |
54RXRFV |
CHARACTER |
|
RentToOwn |
54RRTO |
CHARACTER |
|
DateUserDefined1 |
54RUSRD1 |
DATE |
|
DateUserDefined2 |
54RUSRD2 |
DATE |
|
DateUserDefined3 |
54RUSRD3 |
DATE |
|
TimeUserDefined1 |
54RUSRT1 |
INTEGER |
|
TimeUserDefined2 |
54RUSRT2 |
INTEGER |
|
TimeUserDefined3 |
54RUSRT3 |
INTEGER |
|
NumberUserDefined1 |
54RUSNB1 |
INTEGER |
|
NumberUserDefined2 |
54RUSNB2 |
INTEGER |
|
NumberUserDefined3 |
54RUSNB3 |
INTEGER |
|
TemplateContract |
54RTEMPL |
CHARACTER |
|
DetailBilling |
54RDBILL |
CHARACTER |
|
LeaseFlag |
54RLEASE |
CHARACTER |
|
LeaseType |
54RLSTY |
UDC |
|
CategoryCodeCostCt001 |
RP01 |
UDC |
|
CategoryCodeCostCt002 |
RP02 |
UDC |
|
CategoryCodeCostCt003 |
RP03 |
UDC |
|
CategoryCodeCostCt004 |
RP04 |
UDC |
|
CategoryCodeCostCt005 |
RP05 |
UDC |
|
CategoryCodeCostCt006 |
RP06 |
UDC |
|
CategoryCodeCostCt007 |
RP07 |
UDC |
|
CategoryCodeCostCt008 |
RP08 |
UDC |
|
CategoryCodeCostCt009 |
RP09 |
UDC |
|
CategoryCodeCostCt010 |
RP10 |
UDC |
|
CategoryCodeCostCt011 |
RP11 |
UDC |
|
CategoryCodeCostCt012 |
RP12 |
UDC |
|
CategoryCodeCostCt013 |
RP13 |
UDC |
|
CategoryCodeCostCt014 |
RP14 |
UDC |
|
CategoryCodeCostCt015 |
RP15 |
UDC |
|
CategoryCodeCostCt016 |
RP16 |
UDC |
|
CategoryCodeCostCt017 |
RP17 |
UDC |
|
CategoryCodeCostCt018 |
RP18 |
UDC |
|
CategoryCodeCostCt019 |
RP19 |
UDC |
|
CategoryCodeCostCt020 |
RP20 |
UDC |
|
ContractSalesman1 |
54RSALE1 |
INTEGER |
|
ContractSalesman2 |
54RSALE2 |
INTEGER |
|
AuthorizationNumber |
54RAUTN |
STRING |
|
RentalContractLanguage |
54RLNGP |
UDC |
|
RequestedBillingDay |
54RRQSB |
INTEGER |
|
UserDefinedCarrier |
54RDEF01 |
CHARACTER |
|
UserDefinedMOT |
54RDEF02 |
CHARACTER |
|
UserDefinedFreightHandling |
54RDEF03 |
CHARACTER |
|
BillingExchangeRate |
54RBCRR |
FLOAT |