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