View: Return Lines

RotoID: PO0735
Table: PORETL
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:PORETL

Compositions: 8

RotoID Tables Title DLL
PO0731 PORETH1PORETH2 Returns PORETH
PO0729 PORETC Return Comments PORETC
PO0730 Return Functions PORETG
PO0732 PORETI Return Postings PORETI
PO0736 PORETM Return Posting Lines PORETM
PO0739 PORETLO Return Detail Optional Fields PORETLO
PO0799 PORETLL Return Line Lots PORETLL
PO0790 PORETLS Return Line Serials PORETLS

Keys: 4

Title Fields
Detail Key RETHSEQ, RETLREV
Sequence Key RETHSEQ, RETLSEQ
Receipt Sequence Key RCPHSEQ
Detail Number RETHSEQ, DETAILNUM, RETLSEQ

Fields: 251

Field Index Type Title Attributes Presentation
RETHSEQ 1 BCD*10.0 Return Sequence Key E A K R 
RETLREV 2 BCD*10.0 Line Number E A K R 
RETLSEQ 3 BCD*10.0 Return Line Sequence E A X 
RETCSEQ 4 BCD*10.0 Return Comment Sequence A X 
OEONUMBER 5 String*22 Order Number A X  Mask: %-22C
INDBTABLE 6 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
POSTEDTOIC 7 Boolean Posted to I/C A C X  List:2 entries
0 = No
1 = Yes
COMPLETION 8 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 9 Date Date Completed A X 
RCPHSEQ 10 BCD*10.0 Receipt Sequence Key A X 
RCPLSEQ 11 BCD*10.0 Receipt Line Sequence A X 
ITEMEXISTS 12 Boolean Item Exists A C X  List:2 entries
0 = No
1 = Yes
ITEMNO 13 String*24 Item Number A P X  Mask: %-24C
LOCATION 14 String*6 Location A X  Mask: %-6N
ITEMDESC 15 String*60 Item Description A X 
VENDITEMNO 16 String*24 Vendor Item Number A X 
HASCOMMENT 17 Boolean Comments A X  List:2 entries
0 = No
1 = Yes
RETUNIT 18 String*10 Unit of Measure A X  Mask: %-10c
RETCONV 19 BCD*10.6 Returning Conversion Factor A C X 
RETDECML 20 Integer Returning Unit Decimals A C X 
STOCKDECML 21 Integer Stock Unit Decimals A C X 
RQRECEIVED 22 BCD*10.4 Quantity Received A C X 
SQRECEIVED 23 BCD*10.4 Stocking Quantity Received A C X 
SCRECEIVED 24 BCD*10.3 Extended Cost A C X 
RQPREVRETN 25 BCD*10.4 Quantity Previously Returned A C X 
RQRETURNED 26 BCD*10.4 Quantity Returned A X 
SQRETURNED 27 BCD*10.4 Stocking Quantity Returned A C X 
UNITWEIGHT 28 BCD*10.4 Unit Weight A X 
EXTWEIGHT 29 BCD*10.4 Extended Weight A X 
UNITCOST 30 BCD*10.6 Unit Cost A X 
EXTENDED 31 BCD*10.3 Return Cost A X 
TAXBASE1 32 BCD*10.3 Tax Base 1 A X 
TAXBASE2 33 BCD*10.3 Tax Base 2 A X 
TAXBASE3 34 BCD*10.3 Tax Base 3 A X 
TAXBASE4 35 BCD*10.3 Tax Base 4 A X 
TAXBASE5 36 BCD*10.3 Tax Base 5 A X 
TAXCLASS1 37 Integer Tax Class 1 A X 
TAXCLASS2 38 Integer Tax Class 2 A X 
TAXCLASS3 39 Integer Tax Class 3 A X 
TAXCLASS4 40 Integer Tax Class 4 A X 
TAXCLASS5 41 Integer Tax Class 5 A X 
TAXRATE1 42 BCD*8.5 Tax Rate 1 A X 
TAXRATE2 43 BCD*8.5 Tax Rate 2 A X 
TAXRATE3 44 BCD*8.5 Tax Rate 3 A X 
TAXRATE4 45 BCD*8.5 Tax Rate 4 A X 
TAXRATE5 46 BCD*8.5 Tax Rate 5 A X 
TAXINCLUD1 47 Boolean Tax Includable 1 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 48 Boolean Tax Includable 2 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 49 Boolean Tax Includable 3 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 50 Boolean Tax Includable 4 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 51 Boolean Tax Includable 5 A X  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 52 BCD*10.3 Tax Amount 1 A X 
TAXAMOUNT2 53 BCD*10.3 Tax Amount 2 A X 
TAXAMOUNT3 54 BCD*10.3 Tax Amount 3 A X 
TAXAMOUNT4 55 BCD*10.3 Tax Amount 4 A X 
TAXAMOUNT5 56 BCD*10.3 Tax Amount 5 A X 
TXALLOAMT1 57 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 58 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 59 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 60 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 61 BCD*10.3 Tax Allocated Amount 5 A X 
TXRECVAMT1 62 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 63 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 64 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 65 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 66 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 67 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 68 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 69 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 70 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 71 BCD*10.3 Tax Expense Amount 5 A X 
TXBASEALLO 72 BCD*10.3 Net of Tax A X 
TXINCLUDED 73 BCD*10.3 Tax Included A C X 
TXEXCLUDED 74 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 75 BCD*10.3 Total Tax A C X 
TXRECVAMT 76 BCD*10.3 Recoverable Tax A X 
TXEXPSAMT 77 BCD*10.3 Expensed Tax A X 
TXALLOAMT 78 BCD*10.3 Allocated Tax A X 
TFBASEALLO 79 BCD*10.3 Func. Net of Tax A C X 
TFINCLUDE1 80 BCD*10.3 Func. Tax Included Amount 1 A C X 
TFINCLUDE2 81 BCD*10.3 Func. Tax Included Amount 2 A C X 
TFINCLUDE3 82 BCD*10.3 Func. Tax Included Amount 3 A C X 
TFINCLUDE4 83 BCD*10.3 Func. Tax Included Amount 4 A C X 
TFINCLUDE5 84 BCD*10.3 Func. Tax Included Amount 5 A C X 
TFALLOAMT1 85 BCD*10.3 Func. Tax Allocated Amount 1 A C X 
TFALLOAMT2 86 BCD*10.3 Func. Tax Allocated Amount 2 A C X 
TFALLOAMT3 87 BCD*10.3 Func. Tax Allocated Amount 3 A C X 
TFALLOAMT4 88 BCD*10.3 Func. Tax Allocated Amount 4 A C X 
TFALLOAMT5 89 BCD*10.3 Func. Tax Allocated Amount 5 A C X 
TFRECVAMT1 90 BCD*10.3 Func. Tax Recoverable Amount 1 A C X 
TFRECVAMT2 91 BCD*10.3 Func. Tax Recoverable Amount 2 A C X 
TFRECVAMT3 92 BCD*10.3 Func. Tax Recoverable Amount 3 A C X 
TFRECVAMT4 93 BCD*10.3 Func. Tax Recoverable Amount 4 A C X 
TFRECVAMT5 94 BCD*10.3 Func. Tax Recoverable Amount 5 A C X 
TFEXPSAMT1 95 BCD*10.3 Func. Tax Expense Amount 1 A C X 
TFEXPSAMT2 96 BCD*10.3 Func. Tax Expense Amount 2 A C X 
TFEXPSAMT3 97 BCD*10.3 Func. Tax Expense Amount 3 A C X 
TFEXPSAMT4 98 BCD*10.3 Func. Tax Expense Amount 4 A C X 
TFEXPSAMT5 99 BCD*10.3 Func. Tax Expense Amount 5 A C X 
GLACEXPENS 100 String*45 Expense Account A X  Mask: %-45C
STOCKITEM 101 Boolean Stock Item A C X  List:2 entries
0 = No
1 = Yes
PORHSEQ 102 BCD*10.0 Purchase Order Sequence Key A X 
PORLSEQ 103 BCD*10.0 Purchase Order Line Sequence A X 
PONUMBER 104 String*22 Purchase Order Number A X  Mask: %-22C
GLNONSTKCR 105 String*45 Non-Stock Clearing Account A X  Mask: %-45C
MANITEMNO 106 String*24 Manufacturer's Item Number A X  Mask: %-24C
SCDISCRCVD 107 BCD*10.3 Discount Received A C X 
DISCPCT 108 BCD*5.5 Discount Percentage A X 
DISCOUNT 109 BCD*10.3 Discount Amount A X 
DISCOUNTF 110 BCD*10.3 Func. Discount Amount A X 
VALUES 111 Long Optional Fields A C X 
CONTRACT 112 String*16 Contract A X  Mask: %-16C
PROJECT 113 String*16 Project A X  Mask: %-16N
CCATEGORY 114 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 115 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 116 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 117 BCD*10.6 Billing Rate A X 
BILLCURR 118 String*3 Billing Currency A C X  Mask: %-3N
ARITEMNO 119 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 120 String*10 A/R Unit of Measure A X  Mask: %-10C
RTGPERCENT 121 BCD*5.5 Retainage Percentage A X 
RTGDAYS 122 Integer Retention Period A X 
RTGAMOUNT 123 BCD*10.3 Retainage Amount A X 
RTGAMTOVER 124 Boolean Retainage Amount Overridden A C X  List:2 entries
0 = No
1 = Yes
TAXCLASS1D 141 String*60 Tax Class 1 Description A C X 
TAXCLASS2D 142 String*60 Tax Class 2 Description A C X 
TAXCLASS3D 143 String*60 Tax Class 3 Description A C X 
TAXCLASS4D 144 String*60 Tax Class 4 Description A C X 
TAXCLASS5D 145 String*60 Tax Class 5 Description A C X 
GLACEXPNSD 146 String*60 Expense Account Description A C X 
TXINCLUDE1 147 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 148 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 149 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 150 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 151 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 152 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 153 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 154 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 155 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 156 BCD*10.3 Excluded Tax Amount 5 A X 
ISCOMPLETE 157 Boolean Completed A X  List:2 entries
0 = No
1 = Yes
EXTRANEOUS 158 Long Extraneous Line Count A X 
TAXLINE 159 Long Lines Tax Calculation Sees A X 
LINECMPL 160 Long Lines Complete A X 
LINE 161 Long Line A X 
EXSTDCOST 162 BCD*10.3 Extended Std. Cost in Src Curr A C X 
EXMRCOST 163 BCD*10.3 Extended MR Cost in Src Curr A C X 
EXALT1COST 164 BCD*10.3 Extended Cost 1 in Src Curr A C X 
EXALT2COST 165 BCD*10.3 Extended Cost 2 in Src Curr A C X 
GLNONSTKCD 166 String*60 Non-Stock Clearing Account Desc. A C X 
IPCID 167 Long Inter-process Comm. ID A X 
FORCEPOPSN 168 Boolean Force Pop-up SN A X  List:2 entries
0 = No
1 = Yes
POPUPSN 169 Integer Pop-up SN A X  List:2 entries
0 = No
1 = Yes
CLOSESN 170 Boolean Close SN A X  List:2 entries
0 = No
1 = Yes
LTSETID 171 Long LT Set ID A X 
FORCEPOPLT 172 Boolean Force Pop-up LT A X  List:2 entries
0 = No
1 = Yes
POPUPLT 173 Integer Pop-up LT A X  List:2 entries
0 = No
1 = Yes
CLOSELT 174 Boolean Close LT A X  List:2 entries
0 = No
1 = Yes
MAPMANITEM 175 Boolean Map Manufacturer's Item Number E A  List:2 entries
0 = No
1 = Yes
NETXTENDED 176 BCD*10.3 Net Return Cost A X 
RCPLREV 177 BCD*10.0 Line Number A C X 
PROCESSCMD 178 Integer Command A C X  List:18 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
6 = Insert Item Serial Optional Fields
7 = Insert Item Lot Optional Fields
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create Serials/Lots List
31 = Post Serials/Lots to IC Inventory
CONTSTYLE 179 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 180 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 181 Integer Accounting Method A C X  List:9 entries
0 =
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
7 = Completed Contract
8 = Accrual-Basis
UFMTCONTNO 182 String*16 Unformatted Contract Code A C X  Mask: %-16C
TARAMOUNT1 183 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 184 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 185 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 186 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 187 BCD*10.3 Tax Reporting Amount 5 A X 
TRALLOAMT1 188 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 189 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 190 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 191 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 192 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
TRRECVAMT1 193 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 194 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 195 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 196 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 197 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 198 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 199 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 200 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 201 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 202 BCD*10.3 Tax Reporting Expense Amount 5 A X 
TRINCLUDE1 203 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 204 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 205 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 206 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 207 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 208 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 209 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 210 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 211 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 212 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TARAMOUNT 213 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 214 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 215 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 216 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 217 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 218 BCD*10.3 Tax Reporting Allocated Amount A X 
RAXBASE1 219 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 220 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 221 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 222 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 223 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 224 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 225 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 226 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 227 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 228 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 229 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 230 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 231 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 232 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 233 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 234 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 235 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 236 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 237 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 238 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 239 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 240 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 241 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 242 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 243 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RAXAMOUNT 244 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 245 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 246 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 247 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 248 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 249 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 
UCISMANUAL 250 Boolean Unit Cost is Manual A X  List:2 entries
0 = No
1 = Yes
WEIGHTUNIT 251 String*10 Weight Unit of Measure A X 
WEIGHTCONV 252 BCD*10.6 Weight Conversion A C X 
DEFUWEIGHT 253 BCD*10.4 Default Unit Weight A C X 
DEFEXTWGHT 254 BCD*10.4 Default Extended Weight A C X 
BILLRATECV 255 BCD*10.6 Billing Rate Conversion Factor A C X 
UNITBILLSR 256 BCD*10.6 Unit Billing Amount A C X 
EXTBILLSR 257 BCD*10.3 Extended Billing Amount A X 
XGENALCQTY 258 BCD*10.4 Serial/Lot Quantity to Process A C X 
XLOTMAKQTY 259 BCD*10.4 Number of Lots to Generate A C X 
XPERLOTQTY 260 BCD*10.4 Quantity per Lot A C X 
SALLOCFROM 261 String*40 Allocate from Serial A C X 
LALLOCFROM 262 String*40 Allocate from Lot A C X 
METERHWND 263 Long Serial/Lot Window Handle A C X 
SERIALQTY 264 Long Serial Quantity A C X 
LOTQTY 265 BCD*10.4 Lot Quantity A C X 
SLITEM 266 Integer Item Serialized/Lotted? A C P X  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
DETAILNUM 267 Integer Detail Number A C X 

This page was generated on 2021-Nov-24

© 2021 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).