PO_ReturnHeader PO Return Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_Return_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReturnHeader.M4T"
KPRIMARY: ReturnType+ReturnNo KPONUMBER: PurchaseOrderNo+ReturnType+ReturnNo KBATCH: BatchNo+ReturnType+ReturnNo
Fld Column Name M/L TUR Description/Notes Class
1 ReturnType. . . . . . . . . . 1 SYY Return Type . . . . . . . . . . DfltVal:R Valid:R Notes: {POE$(1,1)} 2 ReturnNo. . . . . . . . . . . 6 SYY Return Number . . . . . . . . .RETURNNO Mask:000000 FmtType:CHARNUM Next:ReturnNo$ Notes: {POE$(2,6)} 3 ReturnDate. . . . . . . . . . 8 SNN Return Date . . . . . . . . . .DATE Notes: {POE$(8,6)} 4 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO Mask:0000000 FmtType:CHARNUM Notes: {POE$(15,7)} 5 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL DepVal:REQUIRED Notes: {POE$(22,2)} 6 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM DepVal:REQU IRED ChngTag:Replace1/APDivis ionNo$ Notes: {POE$(24,7)} 7 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME Notes: {POE$(31,30)} 8 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE Notes: {POE$(61,30)} 9 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE Notes: {POE$(91,30)} 10 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE Notes: {POE$(490,30)} 11 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY Notes: {POE$(121,20)} 12 PurchaseState . . . . . . . . 2 SYN Purchase State. . . . . . . . .STATE Notes: {POE$(141,2)} 13 PurchaseZipCode . . . . . . . 10 SYN Purchase Zip Code . . . . . . .ZIPCODE Notes: {POE$(143,10)} 14 PurchaseCountryCode . . . . . 3 SYN Purchase Country Code . . . . .COUNTRY Notes: {POE$(520,3)} 15 PurchaseAddressCode . . . . . 4 SYN Purchase Address Code . . . . .PURCHASEADDRCODE DepVal:REQUIRED ValGroup:Vend orReq Notes: {POE$(286,4)} 16 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . . Notes: {POE$(153,4)} This is a dual purpose field and could hold either the PO Ship To Code or SO Ship To Code. 17 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {POE$(157,30)} 18 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {POE$(187,30)} 19 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {POE$(217,30)} 20 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {POE$(540,30)} 21 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {POE$(247,20)} 22 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE Notes: {POE$(267,2)} 23 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {POE$(269,10)} 24 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY Notes: {POE$(570,3)} 25 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 26 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . . Valid:N,O,B,C,X Notes: {POE$(279,1)}(N=New, O=Open, B=Backordered, C=Change, X=complete) 27 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:S,D,M,R,X Notes: {POE$(459,1)}(S=Standard, D=Drop Ship, M=Master, R=Repeating, X= Material Requisition) 28 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE Notes: {POE$(460,6)} 29 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE Notes: {POE$(280,6)} 30 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POE$(290,1)} 31 PrintReturnOrder. . . . . . . 1 SYN Print Return Order. . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POE$(291,1)} 32 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {POE$(301,15)} 33 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {POE$(316,15)} 34 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:MultiWarehouse Notes: {POE$(331,3)} 35 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . Notes: {POE$(334,30)} 36 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {POE$(364,30)} 37 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .APTERMS Mask:00 FmtType:ZEROFILL Notes: {POE$(403,2)} 38 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE DepVal:REQUIRED Notes: {POE$(405,6)} 39 InvoiceNo . . . . . . . . . . 10 SNN AP Invoice Number . . . . . . .APINVOICE DepVal:REQUIRED Notes: {POE$(411,10)} 40 Form1099. . . . . . . . . . . 1 SYN 1099 Form . . . . . . . . . . . DfltVal:N Valid:N,M,I,D Notes: {POE$(421,1)} 41 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . . Notes: {POE$(422,2)} 42 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {POE$(424,7)} 43 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE Read Only:Y Notes: {POE$(431, 6)} 44 LastReceiptNo . . . . . . . . 7 SNN Last Receipt Number . . . . . .RECEIPTNO Read Only:Y Notes: {POE$(437, 7)} 45 ReturnAuthorizationNo . . . . 15 SNN Return Authorization Number . . Notes: {POE$(444,15)} 46 ReturnedDepRef. . . . . . . . 10 SYN Returned Deposit Reference. . .APCHECKNO Mask:000000 DepVal:REQUIRED Notes: {POE$(466,6)} 47 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {POE$(472,6)} 48 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE Notes: {POE$(478,6)} 49 VendorsHoldPayment. . . . . . 1 SYN Vendors Hold Payment. . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POE$(484,1)} 50 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO Notes: {POE$(485,5)} 51 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE DepVal:REQUIRED Notes: {POE$(593,9)} 52 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO DfltVal:N Valid:Y,N Notes: {POE$(602,1)} 53 ReturnedDepositAmt. . . . . . 13.2 NNN Returned Deposit Amount . . . .AMOUNT Mask:###,###,###.00- DepVal:REQUIRED Notes: {POE[1]} 54 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- Notes: {POE[2]} 55 NontaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Read Only:Y Mask:###,###, ###.00- Notes: {POE[3]} 56 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- Notes: {POE[5]} 57 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POE[6]} 58 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POE[11]} 59 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POE[7]} 60 TotalMiscChargeAmt. . . . . . 13.2 NNN Total Miscellaneous Charge AmouAMOUNT Mask:###,###,###.00- Notes: {POE[8]} 61 TotalCostForFreightAllocation 13.2 NNN Total Cost For Freight AllocatiAMOUNT Mask:###,###,###.00- Notes: {POE[10]} 62 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 63 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 64 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 65 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 66 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 67 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000