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