PO_ReceiptHeader                       PO Receipt Header              Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: PO_Receipt_bus,BC_CommonImport
 SQL Def: Y  SysDB: N                                      "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHeader.M4T"

 KPRIMARY: ReceiptType+ReceiptNo
 KPONUMBER: PurchaseOrderNo+ReceiptType+ReceiptNo
 KBATCH: BatchNo+ReceiptType+ReceiptNo
 KINVOICE: InvoiceNo+ReceiptType+ReceiptNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ReceiptType . . . . . . . . .     1 SYY  Receipt Type. . . . . . . . . .
                                                Valid:G,I Notes: {PO5$(1,
                                                1)}(Goods,Invoice)
   2  ReceiptNo . . . . . . . . . .     6 SYY  Receipt Number. . . . . . . . .RECEIPTNO
                                                FmtType:CHARNUM Next:ReceiptT
                                                ype$+SEP+ReceiptNo$ Notes:
                                                {PO5$(2,6)}
   3  ReceiptDate . . . . . . . . .     8 SNY  Receipt Date. . . . . . . . . .DATE
                                                Notes: {PO5$(8,6)}
   4  PurchaseOrderNo . . . . . . .     7 SYN  Purchase Order Number . . . . .PURCHASEORDERNO
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED Notes: {PO5$(15,7)}
   5  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                DepVal:REQUIRED ValGroup:PO_I
                                                nvoiceNoRequired Notes:
                                                {PO5$(22,2)}
   6  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                FmtType:MASTERNUM DepVal:REQU
                                                IRED ValGroup:PO_InvoiceNoReq
                                                uired ChngTag:Replace1/APDivi
                                                sionNo$ Notes: {PO5$(24,7)}
   7  PurchaseName. . . . . . . . .    30 SNN  Purchase Name . . . . . . . . .NAME
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(31,30)}
   8  PurchaseAddress1. . . . . . .    30 SNN  Purchase Address 1. . . . . . .ADDRESSLINE
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(61,30)}
   9  PurchaseAddress2. . . . . . .    30 SNN  Purchase Address 2. . . . . . .ADDRESSLINE
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(91,30)}
  10  PurchaseAddress3. . . . . . .    30 SNN  Purchase Address 3. . . . . . .ADDRESSLINE
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(501,30)}
  11  PurchaseCity. . . . . . . . .    20 SNN  Purchase City . . . . . . . . .CITY
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(121,20)}
  12  PurchaseState . . . . . . . .     2 SYN  Purchase State. . . . . . . . .STATE
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(141,2)}
  13  PurchaseZipCode . . . . . . .    10 SYN  Purchase Zip Code . . . . . . .ZIPCODE
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(143,10)}
  14  PurchaseCountryCode . . . . .     3 SYN  Purchase Country Code . . . . .COUNTRY
                                                ValGroup:VendorRequired
                                                Notes: {PO5$(531,3)}
  15  PurchaseAddressCode . . . . .     4 SYN  Purchase Address Code . . . . .PURCHASEADDRCODE
                                                DepVal:REQUIRED ValGroup:Vend
                                                orRequired Notes: {PO5$(286,
                                                4)}
  16  ShipToCode. . . . . . . . . .     4 SYN  Ship To Code. . . . . . . . . .SHIPTO
                                                Notes: {PO5$(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: {PO5$(157,30)}
  18  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .ADDRESSLINE
                                                Notes: {PO5$(187,30)}
  19  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .ADDRESSLINE
                                                Notes: {PO5$(217,30)}
  20  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .ADDRESSLINE
                                                Notes: {PO5$(551,30)}
  21  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .CITY
                                                Notes: {PO5$(247,20)}
  22  ShipToState . . . . . . . . .     2 SYN  Ship To State . . . . . . . . .STATE
                                                Notes: {PO5$(267,2)}
  23  ShipToZipCode . . . . . . . .    10 SYN  Ship To Zip Code. . . . . . . .ZIPCODE
                                                Notes: {PO5$(269,10)}
  24  ShipToCountryCode . . . . . .     3 SYN  Ship To Country Code. . . . . .COUNTRY
                                                Notes: {PO5$(581,3)}
  25  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .EMAILADDRESS
  26  OrderStatus . . . . . . . . .     1 SYN  Order Status. . . . . . . . . .
                                                Read Only:Y Valid:N,O,B,C,X
                                                Notes: {PO5$(279,1)}(N=New,
                                                O=Open, B=Backordered,
                                                C=Change, X=complete)
  27  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
                                                Notes: {PO5$(280,6)}
  28  UseTax. . . . . . . . . . . .     1 SYN  Use Tax . . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:APSalesTax Notes:
                                                {PO5$(290,1)}
  29  ShipVia . . . . . . . . . . .    15 SYN  Ship Via. . . . . . . . . . . .SHIPCODE
                                                Notes: {PO5$(301,15)}
  30  FOB . . . . . . . . . . . . .    15 SNN  F.O.B.. . . . . . . . . . . . .
                                                Notes: {PO5$(316,15)}
  31  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:MultiWarehouse
                                                Notes: {PO5$(331,3)}
  32  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
                                                Notes: {PO5$(334,30)}
  33  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
                                                Notes: {PO5$(364,30)}
  34  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 ValGroup:DropShip
                                                Notes: {PO5$(394,2)}(If Drop
                                                Ship)
  35  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
                                                ValGroup:DropShip Notes:
                                                {PO5$(396,7)} (If Drop Ship)
  36  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .APTERMS
                                                Mask:00 FmtType:ZEROFILL
                                                Notes: {PO5$(403,2)}
  37  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                DepVal:REQUIRED Notes:
                                                {PO5$(405,6)}
  38  InvoiceNo . . . . . . . . . .    10 SNN  AP Invoice Number . . . . . . .APINVOICE
                                                DepVal:REQUIRED ValGroup:PORe
                                                quired Notes: {PO5$(411,10)}
  39  Form1099. . . . . . . . . . .     1 SYN  1099 Form . . . . . . . . . . .FORM1099
                                                DfltVal:N Valid:N,M,I,D
                                                DepVal:REQUIRED ValGroup:Ten9
                                                9 Notes: {PO5$(421,1)}
                                                N=None, M=Miscellaneous,
                                                I=Interest, D=Dividend
  40  Box1099 . . . . . . . . . . .     3 SNN  1099 Box. . . . . . . . . . . .BOX1099
                                                ValGroup:Ten99 Notes:
                                                {PO5$(422,2)}
  41  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:JCIntegrated
                                                Notes: {PO5$(424,7)}
  42  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
                                                Read Only:Y Notes: {PO5$(431,
                                                6)}
  43  LastReceiptNo . . . . . . . .     7 SNN  Last Receipt Number . . . . . .RECEIPTNO
                                                Read Only:Y Notes: {PO5$(437,
                                                7)}
  44  CODCheckNo. . . . . . . . . .    10 SYN  COD Check Number. . . . . . . .APCHECKNO
                                                DepVal:REQUIRED Notes:
                                                {PO5$(444,6)}
  45  BankCode. . . . . . . . . . .     1 SYN  Bank Code . . . . . . . . . . .BANKCODE
                                                Notes: {PO5$(450,1)}
  46  SecondReceiptForThisPO. . . .     1 SYN  Second Receipt For This Po. . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {PO5$(451,1)}
  47  PurchaseOrderType . . . . . .     1 SYN  Purchase Order Type . . . . . .
                                                Read Only:Y Valid:S,D Notes:
                                                {PO5$(459,1)} (S=Standard,
                                                D=Drop Ship)
  48  PurchaseOrderDate . . . . . .     8 SNN  Purchase Order Date . . . . . .DATE
                                                Read Only:Y Notes: {PO5$(460,
                                                6)}
  49  PrepaidCheckNo. . . . . . . .    10 SYN  Prepaid AP Check Number . . . .APCHECKNO
                                                Notes: {PO5$(466,6)}
  50  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                Notes: {PO5$(472,6)}
  51  DiscountDueDate . . . . . . .     8 SNN  Discount Due Date . . . . . . .DATE
                                                Notes: {PO5$(478,6)}
  52  HoldPayment . . . . . . . . .     1 SYN  Hold Payment. . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {PO5$(484,1)}
  53  CODNo . . . . . . . . . . . .    10 SNN  C.O.D. Number . . . . . . . . .
                                                DepVal:REQUIRED Notes:
                                                {PO5$(485,10)}
  54  LotSerialLinesExist . . . . .     1 SYN  Lot/Serial Lines Exist. . . . .YESNO
                                                Read Only:Y DfltVal:N
                                                Valid:Y,N Notes: {PO5$(495,
                                                1)}
  55  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                Notes: {PO5$(496,5)}
  56  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                DepVal:REQUIRED ValGroup:APSa
                                                lesTax Notes: {PO5$(584,9)}
  57  InvalidTaxCalc. . . . . . . .     1 SYN  Invalid Tax Calculation . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:APSalesTax Notes:
                                                {PO5$(593,1)}
  58  UpdateSeqNo . . . . . . . . .     3 SNN  Update Sequence Number. . . . .
                                                Mask:000 Notes: {PO5$(604,
                                                3)}(Calced At Update Time)
  59  PrepaidAmt. . . . . . . . . . 13.2  NNN  Prepaid Amount. . . . . . . . .AMOUNT
                                                Mask:###,###,###.00-
                                                DepVal:REQUIRED Notes:
                                                {PO5[1]}
  60  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                Read Only:Y Mask:###,###,
                                                ###.00- Notes: {PO5[2]}
  61  NontaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                Read Only:Y Mask:###,###,
                                                ###.00- Notes: {PO5[3]}
  62  SalesTaxAmt . . . . . . . . . 13.2  NNN  Sales Tax Amount. . . . . . . .AMOUNT
                                                Read Only:Y Mask:###,###,
                                                ###.00- Notes: {PO5[5]}
  63  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .MISCAMOUNT
                                                Mask:##,###,###.00- Notes:
                                                {PO5[6]}
  64  PrepaidFreightAmt . . . . . . 12.2  NNN  Prepaid Freight Amount. . . . .MISCAMOUNT
                                                Mask:##,###,###.00- Notes:
                                                {PO5[11]}
  65  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .MISCAMOUNT
                                                Mask:##,###,###.00- Notes:
                                                {PO5[7]}
  66  TotalMiscChargeAmt. . . . . . 13.2  NNN  Total Miscellaneous Charge AmouAMOUNT
                                                Read Only:Y Mask:###,###,
                                                ###.00- Notes: {PO5[8]}
  67  TotalCostForFreightAllocation 13.2  NNN  Total Cost For Freight AllocatiAMOUNT
                                                Read Only:Y Mask:###,###,
                                                ###.00- Notes: {PO5[10]}
  68  CODAmt. . . . . . . . . . . . 13.2  NNN  COD Amount. . . . . . . . . . .AMOUNT
                                                Mask:###,###,###.00-
                                                DepVal:REQUIRED Notes:
                                                {PO5[12]}
  69  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  70  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  71  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
  72  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  73  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  74  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000