PO_ReceiptHistoryWrk PO Receipt History Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptHistoryReport_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHistoryWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 30 SNN Group Field . . . . . . . . . . 3 PurchaseOrderNo . . . . . . . 7 SNN Purchase Order Number . . . . . 4 ReceiptType . . . . . . . . . 1 SNN Receipt Type. . . . . . . . . . 5 ReceiptNo . . . . . . . . . . 6 SNN Receipt Number. . . . . . . . . 6 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 7 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE 8 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . . 9 APDivisionDesc. . . . . . . . 30 SNN AP Division Description . . . . 10 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . 11 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . . 12 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . . 13 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . . 14 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . . 15 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . . 16 PurchaseState . . . . . . . . 2 SNN Purchase State. . . . . . . . . 17 PurchaseZipCode . . . . . . . 10 SNN Purchase Zip Code . . . . . . . 18 PurchaseCountryCode . . . . . 3 SNN Purchase Country Code . . . . . 19 PurchaseCountryName . . . . . 30 SNN Purchase Country Name . . . . . 20 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . . 21 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . . 22 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . . 23 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . . 24 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . . 25 ShipToState . . . . . . . . . 2 SNN Ship To State . . . . . . . . . 26 ShipToZipCode . . . . . . . . 10 SNN Ship To Zip Code. . . . . . . . 27 ShipToCountryCode . . . . . . 3 SNN Ship To Country Code. . . . . . 28 ShipToCountryName . . . . . . 30 SNN Ship To Country Name. . . . . . 29 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE 30 InvoiceNo . . . . . . . . . . 10 SNN Invoice Number. . . . . . . . . 31 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 32 ShipVia . . . . . . . . . . . 15 SNN Ship Via. . . . . . . . . . . . 33 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 34 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 35 PrepaidCheckNo. . . . . . . . 10 SNN Prepaid AP Check Number . . . . 36 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . 37 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 38 ReturnAuthorizationNo . . . . 15 SNN Return Authorization Number . . 39 ScheduleSeqNo . . . . . . . . 6 SNN Schedule Sequence Number. . . . 40 TaxCode . . . . . . . . . . . 15 SNN Tax Code. . . . . . . . . . . . 41 LineKey . . . . . . . . . . . 6 SNN Line Key. . . . . . . . . . . . 42 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 43 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 44 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . . 45 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 46 UseTax. . . . . . . . . . . . 1 SNN Use Tax . . . . . . . . . . . . 47 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . . 48 WarehouseCode . . . . . . . . 3 SNN Warehouse Code. . . . . . . . . 49 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . . 50 CODNo . . . . . . . . . . . . 10 SNN COD Number. . . . . . . . . . . 51 CODCheckNo. . . . . . . . . . 10 SNN COD AP Check Number . . . . . . 52 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 53 LandedCostType. . . . . . . . 5 SNN Landed Cost Type. . . . . . . . 54 WorkOrderNo . . . . . . . . . 7 SNN Work Order Number . . . . . . . 55 WorkOrderDesc . . . . . . . . 30 SNN Work Order Description. . . . . 56 StepNo. . . . . . . . . . . . 4 SNN Step Number . . . . . . . . . . 57 SubStepPrefix . . . . . . . . 1 SNN Sub-Step Prefix . . . . . . . . 58 SubStepSuffix . . . . . . . . 4 SNN Sub-Step Suffix . . . . . . . . 59 WorkOrderType . . . . . . . . 1 SNN Work Order Type . . . . . . . . 60 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . . 61 JobDesc . . . . . . . . . . . 30 SNN Job Description . . . . . . . . 62 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . . 63 CostCodeFormatted . . . . . . 11 SNN Cost Code Formatted . . . . . . 64 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 65 LotSerialNo . . . . . . . . . 15 SNN Lot Serial Number . . . . . . . 66 TierType. . . . . . . . . . . 1 SNN Tier Type . . . . . . . . . . . 67 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . . 68 OrderTotal. . . . . . . . . . 13.2 NNN Order Total . . . . . . . . . . 69 DaysOrdered . . . . . . . . . 6.0 NNN Days Ordered. . . . . . . . . . 70 ReceiptAmt. . . . . . . . . . 13.3 NNN Receipt Amount. . . . . . . . . 71 InvoiceAmt. . . . . . . . . . 13.3 NNN Invoice Amount. . . . . . . . . 72 PrepaidAmt. . . . . . . . . . 12.2 NNN Prepaid Amount. . . . . . . . . 73 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . . 74 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . . 75 SalesTaxAmt . . . . . . . . . 13.2 NNN Sales Tax Amount. . . . . . . . 76 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . 77 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . . 78 CODAmt. . . . . . . . . . . . 13.2 NNN COD Amount. . . . . . . . . . . 79 LandedCostAmt . . . . . . . . 16.6 NNN Landed Cost Amount. . . . . . . 80 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . . 81 QuantityReceived. . . . . . . 16.6 NNN Quantity Received . . . . . . . 82 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . . 83 LotSerialQuantityReceived . . 16.6 NNN Lot Serial Quantity Reveived. . 84 UseTaxAmt . . . . . . . . . . 12.2 NNN Use Tax Amount. . . . . . . . . 85 TaxAmt. . . . . . . . . . . . 12.2 NNN Tax Amount. . . . . . . . . . .