Cantara Table Object
Fields
|
Name |
Alias |
Type |
|---|---|---|
|
EdiTransactNumber |
EDTN |
STRING |
|
EdiUserId |
EDUS |
STRING |
|
EdiLineNumber |
EDLN |
FLOAT |
|
EdiSuccessfullyProcess |
EDSP |
CHARACTER |
|
DataItem |
DTAI |
STRING |
|
ActionCode2 |
ACTN |
CHARACTER |
|
CompanyKeyOrderNo |
KCOO |
COMPANY |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
|
OrderType |
DCTO |
UDC |
|
OrderSuffix |
SFXO |
STRING |
|
LineNumber |
LNID |
FLOAT |
|
CostCenter |
MCU |
BUSINESSUNIT |
|
CompanyKeyOriginal |
OKCO |
COMPANY |
|
OriginalPoSoNumber |
OORN |
STRING |
|
OriginalOrderType |
OCTO |
UDC |
|
OriginalLineNumber |
OGNO |
FLOAT |
|
CompanyKeyRelated |
RKCO |
COMPANY |
|
RelatedPoSoNumber |
RORN |
STRING |
|
RelatedOrderType |
RCTO |
UDC |
|
RelatedPoSoLineNo |
RLLN |
FLOAT |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
|
AddressNumberShipTo |
SHAN |
ADDRESSNUMBER |
|
DateRequestedJulian |
DRQJ |
DATE |
|
DateTransactionJulian |
TRDJ |
DATE |
|
ScheduledPickDate |
PDDJ |
DATE |
|
CancelDate |
CNDJ |
DATE |
|
DtForGLAndVouch1 |
DGL |
DATE |
|
UnitsTransactionQty |
UORG |
INTEGER |
|
PurchasingUnitPrice |
PRRC |
FLOAT |
|
AmountExtendedPrice |
AEXP |
FLOAT |
|
LineType |
LNTY |
STRING |
|
DescriptionLine1 |
DSC1 |
STRING |
|
DescriptionLine2 |
DSC2 |
STRING |
|
SerialTagNumber |
ASID |
STRING |
|
Location |
LOCN |
LOCATION |
|
Lot |
LOTN |
STRING |
|
UnitOfMeasureAsInput |
UOM |
UDC |
|
UnitOfMeasurePurchas |
UOM3 |
UDC |
|
StatusCodeLast |
LTTR |
UDC |
|
StatusCodeNext |
NXTR |
UDC |
|
AcctNoInputMode |
ANI |
STRING |
|
Subledger |
SBL |
STRING |
|
SubledgerType |
SBLT |
UDC |
|
DiscountFactor |
DSPR |
FLOAT |
|
CatalogName |
CATN |
UDC |
|
PricingCategory |
PRGR |
UDC |
|
PricingCategoryLevel1 |
CLVL |
STRING |
|
PrintMessage1 |
INMG |
UDC |
|
TaxableYN1 |
TX |
UDC |
|
TaxExplanationCode1 |
EXR1 |
UDC |
|
TaxArea1 |
TXA1 |
STRING |
|
GlClass |
GLC |
STRING |
|
BuyerNumber |
ANBY |
ADDRESSNUMBER |
|
CarrierNumber |
ANCR |
ADDRESSNUMBER |
|
ReportCode1Purchasing |
PDP1 |
UDC |
|
ReportCode2Purchasing |
PDP2 |
UDC |
|
ReportCode3Purchasing |
PDP3 |
UDC |
|
ReportCode4Purchasing |
PDP4 |
UDC |
|
ReportCode5Purchasing |
PDP5 |
UDC |
|
AmountUnitWeight |
ITWT |
FLOAT |
|
WeightUnitOfMeasure |
WTUM |
UDC |
|
AmountUnitVolume |
ITVL |
FLOAT |
|
VolumeUnitOfMeasure |
VLUM |
UDC |
|
Reference1 |
VR01 |
STRING |
|
Reference2Vendor |
VR02 |
STRING |
|
CorrespondenceMethod |
CRMD |
UDC |
|
WoOrderFreezeCode |
UNCD |
UDC |
|
CodeAutomaticVoucher |
AVCH |
UDC |
|
CurrencyCodeFrom |
CRCD |
STRING |
|
UserReservedCode |
URCD |
STRING |
|
UserReservedDate |
URDT |
DATE |
|
UserReservedAmount |
URAT |
FLOAT |
|
UserReservedNumber |
URAB |
INTEGER |
|
UserReservedReference |
URRF |
STRING |
|
ContractNumberDistributi |
DMCT |
STRING |
|
ContractSupplementDistri |
DMCS |
INTEGER |
|
DatePriceEffectiveDate |
PEFJ |
DATE |
|
PurchasingCostCenter |
OMCU |
BUSINESSUNIT |
|
ObjectAccount |
OBJ |
STRING |
|
Subsidiary |
SUB |
STRING |
|
PurchaseLineCode01 |
PODC01 |
UDC |
|
PurchaseLineCode02 |
PODC02 |
UDC |
|
PurchaseLineCode03 |
PODC03 |
UDC |
|
PurchaseLineCode04 |
PODC04 |
UDC |
|
UnitsQuantityService |
SRQTY |
FLOAT |
|
UnitOfMeasureService |
SRUOM |
UDC |
|
ProductionNumber |
PMPN |
STRING |
|
ProductionNumberShort |
PNS |
INTEGER |
|
UserId |
USER |
STRING |
|
ProgramId |
PID |
STRING |
|
WorkStationId |
JOBN |
STRING |
|
DateUpdated |
UPMJ |
DATE |
|
TimeLastUpdated |
UPMT |
INTEGER |
|
Identifier2ndItem |
LITM |
STRING |
|
IdentifierShortItem |
ITM |
SHORTITEM |
|
PriceOverrideCode |
PROV |
CHARACTER |