View: Return Day-end Lines

RotoID: PO0734
Table: PORETN
Protocol: Flat
DLL:PORETN

Keys: 1

Title Fields
Detail Key RETHSEQ, RETLSEQ

Fields: 120

Field Index Type Title Attributes Presentation
RETHSEQ 1 BCD*10.0 Return Sequence Key E A K R 
RETLSEQ 2 BCD*10.0 Return Line Sequence E A K R 
ITEMDESC 3 String*60 Item Description E A 
STOCKUNIT 4 String*10 Unit of Measure E A 
RETUNIT 5 String*10 Unit of Measure E A 
RETCONV 6 BCD*10.6 Returning Conversion Factor E A 
RETDECML 7 Integer Returning Unit Decimals E A 
RQRETURNED 8 BCD*10.4 Quantity Returned E A 
SQRETURNED 9 BCD*10.4 Stocking Quantity Returned E A 
RQUSTOCKED 10 BCD*10.4 Receiving Unstocked E A 
SQUSTOCKED 11 BCD*10.4 Stocking Unstocked E A 
UNITWEIGHT 12 BCD*10.4 Unit Weight E A 
EXTWEIGHT 13 BCD*10.4 Extended Weight E A 
UNITCOST 14 BCD*10.6 Unit Cost E A 
EXTENDED 15 BCD*10.3 Return Cost E A 
PRUNITCOST 16 BCD*10.6 Unit Cost E A 
TAXBASE1 17 BCD*10.3 Tax Base 1 E A 
TAXBASE2 18 BCD*10.3 Tax Base 2 E A 
TAXBASE3 19 BCD*10.3 Tax Base 3 E A 
TAXBASE4 20 BCD*10.3 Tax Base 4 E A 
TAXBASE5 21 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 22 Integer Tax Includable 1 E A 
TAXINCLUD2 23 Integer Tax Includable 2 E A 
TAXINCLUD3 24 Integer Tax Includable 3 E A 
TAXINCLUD4 25 Integer Tax Includable 4 E A 
TAXINCLUD5 26 Integer Tax Includable 5 E A 
TXBASEALLO 27 BCD*10.3 Net of Tax E A 
TXINCLUDE1 28 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 29 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 30 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 31 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 32 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 33 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 34 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 35 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 36 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 37 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 38 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 39 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 40 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 41 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 42 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 43 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 44 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 45 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 46 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 47 BCD*10.3 Tax Allocated Amount 5 E A 
TFBASEALLO 48 BCD*10.3 Func. Net of Tax E A 
TFINCLUDE1 49 BCD*10.3 Func. Tax Included Amount 1 E A 
TFINCLUDE2 50 BCD*10.3 Func. Tax Included Amount 2 E A 
TFINCLUDE3 51 BCD*10.3 Func. Tax Included Amount 3 E A 
TFINCLUDE4 52 BCD*10.3 Func. Tax Included Amount 4 E A 
TFINCLUDE5 53 BCD*10.3 Func. Tax Included Amount 5 E A 
TFALLOAMT1 54 BCD*10.3 Func. Tax Allocated Amount 1 E A 
TFALLOAMT2 55 BCD*10.3 Func. Tax Allocated Amount 2 E A 
TFALLOAMT3 56 BCD*10.3 Func. Tax Allocated Amount 3 E A 
TFALLOAMT4 57 BCD*10.3 Func. Tax Allocated Amount 4 E A 
TFALLOAMT5 58 BCD*10.3 Func. Tax Allocated Amount 5 E A 
TFRECVAMT1 59 BCD*10.3 Func. Tax Recoverable Amount 1 E A 
TFRECVAMT2 60 BCD*10.3 Func. Tax Recoverable Amount 2 E A 
TFRECVAMT3 61 BCD*10.3 Func. Tax Recoverable Amount 3 E A 
TFRECVAMT4 62 BCD*10.3 Func. Tax Recoverable Amount 4 E A 
TFRECVAMT5 63 BCD*10.3 Func. Tax Recoverable Amount 5 E A 
TFEXPSAMT1 64 BCD*10.3 Func. Tax Expense Amount 1 E A 
TFEXPSAMT2 65 BCD*10.3 Func. Tax Expense Amount 2 E A 
TFEXPSAMT3 66 BCD*10.3 Func. Tax Expense Amount 3 E A 
TFEXPSAMT4 67 BCD*10.3 Func. Tax Expense Amount 4 E A 
TFEXPSAMT5 68 BCD*10.3 Func. Tax Expense Amount 5 E A 
DISCPCT 69 BCD*5.5 Discount Percentage E A 
DISCOUNT 70 BCD*10.3 Discount Amount E A 
DISCOUNTF 71 BCD*10.3 Func. Discount Amount E A 
BILLRATE 72 BCD*10.6 Billing Rate E A 
RTGPERCENT 73 BCD*5.5 Retainage Percentage E A 
RTGDAYS 74 Integer Retention Period E A 
RTGAMOUNT 75 BCD*10.3 Retainage Amount E A 
RTGAMTOVER 76 Boolean Retainage Amount Overridden E A 
TRINCLUDE1 77 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 78 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 79 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 80 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 81 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 82 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 83 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 84 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 85 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 86 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 87 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 88 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 89 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 90 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 91 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 92 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 93 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 94 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 95 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 96 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 97 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 98 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 99 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 100 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 101 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 102 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 103 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 104 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 105 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 106 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 107 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 108 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 109 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 110 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 111 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 112 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 113 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 114 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 115 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 116 BCD*10.3 Retainage Tax Allocated Amount 5 E A 
WEIGHTUNIT 117 String*10 Weight Unit of Measure E A 
WEIGHTCONV 118 BCD*10.6 Weight Conversion E A 
DEFUWEIGHT 119 BCD*10.4 Default Unit Weight E A 
DEFEXTWGHT 120 BCD*10.4 Default Extended Weight E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).