PO_ReceiptHistoryHeader PO Receipt History Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptRegister_upd,PO_ReceiptHistory_bus,PO_ReturnRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReceiptHistoryHeader.M4T"
KPRIMARY: PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo KVENDOR: APDivisionNo+VendorNo+PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo KNAME: PurchaseName+PurchaseOrderNo+ReceiptType+ReceiptNo+HeaderSeqNo KRECEIPT: ReceiptType+ReceiptNo+HeaderSeqNo+PurchaseOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 PurchaseOrderNo . . . . . . . 7 SYN Purchase Order Number . . . . .PURCHASEORDERNO Mask:0000000 FmtType:CHARNUM Notes: {POP$(1,7)} 2 ReceiptType . . . . . . . . . 1 SYY Receipt Type. . . . . . . . . . Valid:R,I,G Notes: {POP$(8, 1)} R=Return, G=Goods , I=Invoice 3 ReceiptNo . . . . . . . . . . 6 SYY Receipt Number. . . . . . . . .RECEIPTNO Notes: {POP$(9,6)} 4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . . 5 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE Notes: {POP$(15,6)} 6 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {POP$(21,2)} 7 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {POP$(23,7)} 8 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME Notes: {POP$(30,30)} 9 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE Notes: {POP$(60,30)} 10 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE Notes: {POP$(90,30)} 11 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE Notes: {POP$(465,30)} 12 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY Notes: {POP$(120,20)} 13 PurchaseState . . . . . . . . 2 SYN Purchase State. . . . . . . . .STATE Notes: {POP$(140,2)} 14 PurchaseZipCode . . . . . . . 10 SYN Purchase Zip Code . . . . . . .ZIPCODE Notes: {POP$(142,10)} 15 PurchaseCountryCode . . . . . 3 SYN Purchase Country Code . . . . .COUNTRY Notes: {POP$(495,3)} 16 PurchaseAddressCode . . . . . 4 SYN Purchase Address Code . . . . . Notes: {POP$(284,4)} 17 ShipToCode. . . . . . . . . . 4 SYN Ship To Code. . . . . . . . . . Notes: {POP$(152,4)} This is a dual purpose field and could hold either the PO Ship To Code or SO Ship To Code. 18 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {POP$(156,30)} 19 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {POP$(186,30)} 20 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {POP$(216,30)} 21 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {POP$(515,30)} 22 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {POP$(246,20)} 23 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE Notes: {POP$(266,2)} 24 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {POP$(268,10)} 25 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY Notes: {POP$(545,3)} 26 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 27 OrderType . . . . . . . . . . 1 SNN Order Type. . . . . . . . . . . Valid:S,D,M,R,X Notes: {POP$(422,1)}(S=Standard, D=Drop Ship, M=Master, R=Repeating, X= Material Requisition) 28 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE Notes: {POP$(423,6)} 29 RequiredDate. . . . . . . . . 8 SNN Required Date . . . . . . . . .DATE Notes: {POP$(278,6)} 30 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POP$(288,1)} 31 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {POP$(289,15)} 32 FOB . . . . . . . . . . . . . 15 SNN Fob . . . . . . . . . . . . . . Notes: {POP$(304,15)} 33 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {POP$(319,3)} 34 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . . Notes: {POP$(322,30)} 35 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {POP$(352,30)} 36 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 Notes: {POP$(382,2)} If Drop Ship P/O 37 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO ChngTag:Replace1/ARDivisionNo $ Notes: {POP$(384,7)} If Drop Ship P/O 38 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .APTERMS Mask:00 Notes: {POP$(391,2)} 39 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE Notes: {POP$(393,6)} 40 InvoiceNo . . . . . . . . . . 10 SYN Invoice Number. . . . . . . . . Notes: {POP$(399,10)} 41 LastReceiptDate . . . . . . . 8 SNN Last Receipt Date . . . . . . .DATE Notes: {POP$(409,6)} 42 LastReceiptNo . . . . . . . . 7 SYN Last Receipt Number . . . . . . Notes: {POP$(415,7)} 43 PrepaidCheckNo. . . . . . . . 10 SNN Prepaid AP Check Number . . . .APCHECKNO Notes: {POP$(429,6)} 44 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {POP$(435,6)} 45 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE Notes: {POP$(441,6)} 46 HoldPayment . . . . . . . . . 1 SYN Hold Payment. . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {POP$(447,1)} 47 CODNo . . . . . . . . . . . . 10 SYN COD Number. . . . . . . . . . . Notes: {POP$(448,10)} 48 CODCheckNo. . . . . . . . . . 10 SNN COD AP Check Number . . . . . .APCHECKNO Notes: {POP$(458,6)} 49 BankCode. . . . . . . . . . . 1 SYN Bank Code . . . . . . . . . . .BANKCODE Notes: {POP$(464,1)} 50 SourceJournal . . . . . . . . 2 SYN Source Journal. . . . . . . . .SOURCEJOURNAL Notes: {POP$(565,2)} 51 SourceJournalBatchNo. . . . . 6 SNN Source Journal Batch No.. . . . Mask:000000 Notes: {POP$(567, 4)} 52 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {POP$(571,6)} 53 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE Notes: {POP$(580,9)} 54 ReturnAuthorizationNo . . . . 15 SNN Return Authorization Number . . 55 ReceiptAmt. . . . . . . . . . 13.3 NNN Receipt Amount. . . . . . . . . Mask:#######0.000 Notes: {POP[0]} 56 InvoiceAmt. . . . . . . . . . 13.3 NNN Invoice Amount. . . . . . . . . Mask:#######0.000 Notes: {POP[1]} 57 PrepaidAmt. . . . . . . . . . 13.2 NNN Prepaid Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {POP[2]} 58 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {POP[3]} 59 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00- Notes: {POP[4]} 60 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POP[6]} 61 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POP[7]} 62 PrepaidFreightAmt . . . . . . 12.2 NNN Prepaid Freight Amount. . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POP[11]} 63 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {POP[8]} 64 TaxableMiscChrgAmt. . . . . . 13.2 NNN Total Miscellaneous Charge AmouAMOUNT Mask:###,###,###.00- Notes: {POP[9]} 65 CODAmt. . . . . . . . . . . . 13.2 NNN COD Amount. . . . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {POP[12]} 66 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 67 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 68 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000