Personalization, Customization and Productivity Tools

[TomBaker]

This cross reference is missing from the File Layouts and Program Information.  Does anyone have this?  Thanks

[khmackall]

Greetings,

There is no Old Field to New Field cross reference for PO_PurchaseOrderDetail and that should have been noted in the list of tables with no mappings.  Here is the table information for Po_PurchaseOrderDetail for 4.40. 

Table: [PO_PurchaseOrderDetail]

Fields:

PurchaseOrderNo
LineKey

LineSeqNo

ItemCode

ExtendedDescriptionKey

ItemType

ItemCodeDesc

UseTax

RequiredDate

VendorPriceCode

PurchasesAcctKey

Valuation

UnitOfMeasure

WarehouseCode

ProductLine

MasterLineKey

Reschedule

JobNo

CostCode

CostType

ReceiptOfGoodsUpdated

WorkOrderNo

StepNo

SubStepPrefix

SubStepSuffix

WorkOrderType

AllocateLandedCost

VendorAliasItemNo

TaxClass

CommentText

AssetAccount

AssetTemplate

WeightReference

Weight

QuantityOrdered

QuantityReceived

QuantityBackordered 

MasterOriginalQty
MasterQtyBalance 
MasterQtyOrderedToDate 
QuantityInvoiced 
UnitCost 
OriginalUnitCost 
ExtensionAmt 
ReceivedAmt 
InvoicedAmt 
UnitOfMeasureConvFactor 
ReceivedAllocatedAmt 
InvoicedAllocatedAmt 

[TomBaker]

I appreciate the response but, I guess what I'm asking is in the "Purchase Order Schema: Old vs New Names", table PO2_PurchaseOrderEntryLine is now PO_PurchaseOrderDetail.  Correct?  If so, I don't see what happened to the fields in PO2_PurchaseOrderEntryLine.

As an example.   I do not see where the field "SpecialMiscItemDescription" in PO2_PurchaseOrderEntryLine can be found now.

[bethbowers]

That particular one is ItemCodeDesc.  You might check the sales order files - they woudl be very similar and could probably give you a good enough idea.

[khmackall · Accepted solution]

Tom,

PO2 is now PO_PurchaseOrderDetail.  PO2_PurchaseOrderEntryLine is the Crystal ODBC Definition table name.  For special and Miscellaneous items, the value from the SpecialMiscItemDescription field in PO2 is converted into the ItemCodeDesc$ column in PO_PurchaseOrderDetail.

Thanks,

Kent