View: Return Posting Lines

RotoID: PO0736
Table: PORETM
Protocol: Detail, Ordered revisions
DLL:PORETM

Compositions: 15

RotoID Tables Title DLL
PO0732 PORETI Return Postings PORETI
PO0731 PORETH1PORETH2 Returns PORETH
PO0735 PORETL Return Lines PORETL
PO0695 PORCPC Receipt Comments PORCPC
PO0699 Receipt Functions PORCPG
PO0700 PORCPH1PORCPH2 Receipts PORCPH
PO0710 PORCPL Receipt Lines PORCPL
PO0714 PORCPS Receipt Additional Costs PORCPS
PO0718 PORCPV Receipt Vendors PORCPV
PO0696 PORCPD Receipt Cost Distributions PORCPD
PO0703 PORCPHO Receipt Optional Fields PORCPHO
PO0717 PORCPLO Receipt Detail Optional Fields PORCPLO
PO0705 PORCPR Receipt Purchase Orders PORCPR
PO0719 PORCPSO Receipt Add. Cost Opt. Field PORCPSO
PO0721 PORCPVO Receipt Vendors Optional Fields PORCPVO

Keys: 1

Title Fields
Detail Key RETISEQ, RETHSEQ, RETLSEQ

Fields: 135

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

This page was generated on 2022-Aug-18

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