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