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