Cantara Table Object
Fields
|
Name |
Alias |
Type |
|---|---|---|
|
EdiTransactNumber |
EDTN |
STRING |
|
EdiUserId |
EDUS |
STRING |
|
EdiSuccessfullyProcess |
EDSP |
CHARACTER |
|
DataItem |
DTAI |
STRING |
|
CompanyKeyOrderNo |
KCOO |
COMPANY |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
|
OrderType |
DCTO |
UDC |
|
OrderSuffix |
SFXO |
STRING |
|
CostCenter |
MCU |
BUSINESSUNIT |
|
CompanyKeyOriginal |
OKCO |
COMPANY |
|
OriginalPoSoNumber |
OORN |
STRING |
|
OriginalOrderType |
OCTO |
UDC |
|
CompanyKeyRelated |
RKCO |
COMPANY |
|
RelatedPoSoNumber |
RORN |
STRING |
|
RelatedOrderType |
RCTO |
UDC |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
|
AddressNumberShipTo |
SHAN |
ADDRESSNUMBER |
|
DateRequestedJulian |
DRQJ |
DATE |
|
DateTransactionJulian |
TRDJ |
DATE |
|
ScheduledPickDate |
PDDJ |
DATE |
|
CancelDate |
CNDJ |
DATE |
|
Reference1 |
VR01 |
STRING |
|
Reference2Vendor |
VR02 |
STRING |
|
DeliveryInstructLine1 |
DEL1 |
STRING |
|
DeliveryInstructLine2 |
DEL2 |
STRING |
|
PrintMessage1 |
INMG |
UDC |
|
PricingGroup |
PRGP |
UDC |
|
PaymentTermsCode01 |
PTC |
STRING |
|
TaxExplanationCode1 |
EXR1 |
UDC |
|
TaxArea1 |
TXA1 |
STRING |
|
CertificateTaxExempt |
TXCT |
STRING |
|
AssociatedText |
ATXT |
CHARACTER |
|
HoldOrdersCode |
HOLD |
UDC |
|
FreightHandlingCode |
FRTH |
UDC |
|
BuyerNumber |
ANBY |
ADDRESSNUMBER |
|
CarrierNumber |
ANCR |
ADDRESSNUMBER |
|
CodeAutomaticVoucher |
AVCH |
UDC |
|
CorrespondenceMethod |
CRMD |
UDC |
|
PurchasingReportCode5 |
PRP5 |
UDC |
|
RoutingApproval |
ARTG |
STRING |
|
CurrencyMode |
CRRM |
UDC |
|
CurrencyCodeFrom |
CRCD |
STRING |
|
CurrencyConverRateOv |
CRR |
FLOAT |
|
OrderedBy |
ORBY |
STRING |
|
OrderTakenBy |
TKBY |
STRING |
|
PercentRetainage1 |
PCRT |
FLOAT |
|
Description |
DESC |
STRING |
|
NameRemark |
RMK |
STRING |
|
DatePriceEffectiveDate |
PEFJ |
DATE |
|
ApplyFreight |
FUF1 |
UDC |
|
UserReservedDate |
URDT |
DATE |
|
UserReservedAmount |
URAT |
FLOAT |
|
UserReservedCode |
URCD |
STRING |
|
UserReservedReference |
URRF |
STRING |
|
UserReservedNumber |
URAB |
INTEGER |
|
PurchaseOrderAddressBook01 |
POHAB01 |
ADDRESSNUMBER |
|
PurchaseOrderAddressBook02 |
POHAB02 |
ADDRESSNUMBER |
|
PurchaseOrderCode01 |
POHC01 |
UDC |
|
UserId |
USER |
STRING |
|
ProgramId |
PID |
STRING |
|
WorkStationId |
JOBN |
STRING |
|
DateUpdated |
UPMJ |
DATE |
|
TimeLastUpdated |
UPMT |
INTEGER |