Table: Returns

Table: PORETH1
View: PO0731
Record Length: 2568

Flags: A R 

Keys: 5

Title Flags Fields
Master Key RETHSEQ
Returns RETNUMBER
Vendor M  VDCODE, RETHSEQ
Receipt Sequence D  RCPHSEQ
Vendor Document Number M  VDCODE, RETNUMBER

Fields: 195

Field Type Title Presentation
RETHSEQ BCD*10.0 Return Sequence Key
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
NEXTLSEQ BCD*10.0 Next Line Sequence
LINES Long Lines
LINESCMPL Long Lines Complete
TAXLINES Long Lines Tax Calculation Sees
EXTRANEOUS Long Extraneous Line Count
TAXAUTOCAL Boolean Auto. tax calculation on save List:2 entries
0 = No
1 = Yes
ISPRINTED Boolean Printed List:2 entries
0 = No
1 = Yes
ISCREDITED Boolean Is Credited List:2 entries
0 = No
1 = Yes
ISCOMPLETE Boolean Completed List:2 entries
0 = No
1 = Yes
DTCOMPLETE Date Date Completed
POSTDATE Date Last Posting Date
LABELPRINT Boolean Labels Printed List:2 entries
0 = No
1 = Yes
LABELCOUNT Integer Number of Labels
DATE Date Return Date
FISCYEAR String*4 Fiscal Year Mask: %4D
FISCPERIOD Integer Fiscal Period List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
RETNUMBER String*22 Return Number Mask: %-22C
TEMPLATE String*6 Template Code Mask: %-6N
VDCODE String*12 Vendor Mask: %-12C
VDEXISTS Boolean Vendor Exists List:2 entries
0 = No
1 = Yes
VDNAME String*60 Name
VDADDRESS1 String*60 Address 1
VDADDRESS2 String*60 Address 2
VDADDRESS3 String*60 Address 3
VDADDRESS4 String*60 Address 4
VDCITY String*30 City
VDSTATE String*30 State/Province
VDZIP String*20 Zip/Postal Code
VDCOUNTRY String*30 Country
VDPHONE String*30 Phone Number Mask: (%-3C) %-3C-%-24C
VDFAX String*30 Fax Number Mask: (%-3C) %-3C-%-24C
VDCONTACT String*60 Contact
RCPHSEQ BCD*10.0 Receipt Sequence Key
RCPNUMBER String*22 Receipt Number Mask: %-22C
RCPDATE Date Receipt Date
PORHSEQ BCD*10.0 Purchase Order Sequence Key
PONUMBER String*22 Purchase Order Number Mask: %-22C
PORDATE Date Purchase Order Date
DESCRIPTIO String*60 Description
REFERENCE String*60 Reference
COMMENT String*250 Comment
VIACODE String*6 Ship-Via Mask: %-6N
VIANAME String*60 Ship-Via Name
CURRENCY String*3 Currency Mask: %-3N
RATE BCD*8.7 Exchange Rate
SPREAD BCD*8.7 Rate Spread
RATETYPE String*2 Rate Type Mask: %-2N
RATEMATCH Integer Rate Match Type
RATEDATE Date Rate Date
RATEOPER Integer Rate Operation List:2 entries
1 = Multiply
2 = Divide
RATEOVER Boolean Rate Overridden List:2 entries
0 = No
1 = Yes
SCURNDECML Integer Decimal Places
EXTWEIGHT BCD*10.4 Extended Weight
EXTENDED BCD*10.3 Return Cost
DOCTOTAL BCD*10.3 Total
AMOUNT BCD*10.3 Amount
RQRETURNED BCD*10.4 Quantity Returned
TAXGROUP String*12 Tax Group Mask: %-12N
TAXAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAXAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAXAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAXAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAXAUTH5 String*12 Tax Authority 5 Mask: %-12N
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
TAXBASE1 BCD*10.3 Tax Base 1
TAXBASE2 BCD*10.3 Tax Base 2
TAXBASE3 BCD*10.3 Tax Base 3
TAXBASE4 BCD*10.3 Tax Base 4
TAXBASE5 BCD*10.3 Tax Base 5
TXINCLUDE1 BCD*10.3 Included Tax Amount 1
TXINCLUDE2 BCD*10.3 Included Tax Amount 2
TXINCLUDE3 BCD*10.3 Included Tax Amount 3
TXINCLUDE4 BCD*10.3 Included Tax Amount 4
TXINCLUDE5 BCD*10.3 Included Tax Amount 5
TXEXCLUDE1 BCD*10.3 Excluded Tax Amount 1
TXEXCLUDE2 BCD*10.3 Excluded Tax Amount 2
TXEXCLUDE3 BCD*10.3 Excluded Tax Amount 3
TXEXCLUDE4 BCD*10.3 Excluded Tax Amount 4
TXEXCLUDE5 BCD*10.3 Excluded Tax Amount 5
TAXAMOUNT1 BCD*10.3 Tax Amount 1
TAXAMOUNT2 BCD*10.3 Tax Amount 2
TAXAMOUNT3 BCD*10.3 Tax Amount 3
TAXAMOUNT4 BCD*10.3 Tax Amount 4
TAXAMOUNT5 BCD*10.3 Tax Amount 5
TXRECVAMT1 BCD*10.3 Tax Recoverable Amount 1
TXRECVAMT2 BCD*10.3 Tax Recoverable Amount 2
TXRECVAMT3 BCD*10.3 Tax Recoverable Amount 3
TXRECVAMT4 BCD*10.3 Tax Recoverable Amount 4
TXRECVAMT5 BCD*10.3 Tax Recoverable Amount 5
TXEXPSAMT1 BCD*10.3 Tax Expense Amount 1
TXEXPSAMT2 BCD*10.3 Tax Expense Amount 2
TXEXPSAMT3 BCD*10.3 Tax Expense Amount 3
TXEXPSAMT4 BCD*10.3 Tax Expense Amount 4
TXEXPSAMT5 BCD*10.3 Tax Expense Amount 5
TXALLOAMT1 BCD*10.3 Tax Allocated Amount 1
TXALLOAMT2 BCD*10.3 Tax Allocated Amount 2
TXALLOAMT3 BCD*10.3 Tax Allocated Amount 3
TXALLOAMT4 BCD*10.3 Tax Allocated Amount 4
TXALLOAMT5 BCD*10.3 Tax Allocated Amount 5
TXBASEALLO BCD*10.3 Net of Tax
TXINCLUDED BCD*10.3 Tax Included
TXEXCLUDED BCD*10.3 Tax Excluded
TAXAMOUNT BCD*10.3 Total Tax
TXRECVAMT BCD*10.3 Total Tax Recoverable
TXEXPSAMT BCD*10.3 Total Tax Expensed
TXALLOAMT BCD*10.3 Total Tax Allocated
SCAMOUNT BCD*10.3 Conversion Source Amount
FCAMOUNT BCD*10.3 Conversion Functional Amount
VDEMAIL String*50 E-mail
VDPHONEC String*30 Contact Phone Mask: (%-3C) %-3C-%-24C
VDFAXC String*30 Contact Fax Mask: (%-3C) %-3C-%-24C
VDEMAILC String*50 Contact E-mail
DISCPCT BCD*5.5 Discount Percentage
DISCOUNT BCD*10.3 Discount Amount
VALUES Long Optional Fields
VERPRORATE Integer Proration Version List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG Boolean Has Retainage List:2 entries
0 = No
1 = Yes
RTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE Integer Retainage Base List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
RTGAMOUNT BCD*10.3 Retainage Amount
JOBLINES Long Job Related Lines
TRCURRENCY String*3 Tax Reporting Currency Mask: %-3N
RATERC BCD*8.7 Tax Reporting Exchange Rate
SPREADRC BCD*8.7 Tax Reporting Rate Spread
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEMTCHRC Integer Tax Reporting Rate Match Type
RATEDATERC Date Tax Reporting Rate Date
RATEOPERRC Integer Tax Reporting Rate Operation List:2 entries
1 = Multiply
2 = Divide
RATERCOVER Boolean Tax Reporting Rate Overridden List:2 entries
0 = No
1 = Yes
RCURNDECML Integer Tax Reporting Decimal Places
TARAMOUNT1 BCD*10.3 Tax Reporting Amount 1
TARAMOUNT2 BCD*10.3 Tax Reporting Amount 2
TARAMOUNT3 BCD*10.3 Tax Reporting Amount 3
TARAMOUNT4 BCD*10.3 Tax Reporting Amount 4
TARAMOUNT5 BCD*10.3 Tax Reporting Amount 5
TRINCLUDE1 BCD*10.3 Tax Reporting Included Amount 1
TRINCLUDE2 BCD*10.3 Tax Reporting Included Amount 2
TRINCLUDE3 BCD*10.3 Tax Reporting Included Amount 3
TRINCLUDE4 BCD*10.3 Tax Reporting Included Amount 4
TRINCLUDE5 BCD*10.3 Tax Reporting Included Amount 5
TREXCLUDE1 BCD*10.3 Tax Reporting Excluded Amount 1
TREXCLUDE2 BCD*10.3 Tax Reporting Excluded Amount 2
TREXCLUDE3 BCD*10.3 Tax Reporting Excluded Amount 3
TREXCLUDE4 BCD*10.3 Tax Reporting Excluded Amount 4
TREXCLUDE5 BCD*10.3 Tax Reporting Excluded Amount 5
TRRECVAMT1 BCD*10.3 Tax Reporting Recoverable Amt. 1
TRRECVAMT2 BCD*10.3 Tax Reporting Recoverable Amt. 2
TRRECVAMT3 BCD*10.3 Tax Reporting Recoverable Amt. 3
TRRECVAMT4 BCD*10.3 Tax Reporting Recoverable Amt. 4
TRRECVAMT5 BCD*10.3 Tax Reporting Recoverable Amt. 5
TREXPSAMT1 BCD*10.3 Tax Reporting Expense Amount 1
TREXPSAMT2 BCD*10.3 Tax Reporting Expense Amount 2
TREXPSAMT3 BCD*10.3 Tax Reporting Expense Amount 3
TREXPSAMT4 BCD*10.3 Tax Reporting Expense Amount 4
TREXPSAMT5 BCD*10.3 Tax Reporting Expense Amount 5
TRALLOAMT1 BCD*10.3 Tax Reporting Allocated Amount 1
TRALLOAMT2 BCD*10.3 Tax Reporting Allocated Amount 2
TRALLOAMT3 BCD*10.3 Tax Reporting Allocated Amount 3
TRALLOAMT4 BCD*10.3 Tax Reporting Allocated Amount 4
TRALLOAMT5 BCD*10.3 Tax Reporting Allocated Amount 5
RTGTAXREP Integer Report Retainage Tax List:2 entries
0 = At Time of Original Document
1 = As Per Tax Authority
RAXBASE1 BCD*10.3 Retainage Tax Base 1
RAXBASE2 BCD*10.3 Retainage Tax Base 2
RAXBASE3 BCD*10.3 Retainage Tax Base 3
RAXBASE4 BCD*10.3 Retainage Tax Base 4
RAXBASE5 BCD*10.3 Retainage Tax Base 5
RAXAMOUNT1 BCD*10.3 Retainage Tax Amount 1
RAXAMOUNT2 BCD*10.3 Retainage Tax Amount 2
RAXAMOUNT3 BCD*10.3 Retainage Tax Amount 3
RAXAMOUNT4 BCD*10.3 Retainage Tax Amount 4
RAXAMOUNT5 BCD*10.3 Retainage Tax Amount 5
RXRECVAMT1 BCD*10.3 Retainage Tax Recoverable Amt. 1
RXRECVAMT2 BCD*10.3 Retainage Tax Recoverable Amt. 2
RXRECVAMT3 BCD*10.3 Retainage Tax Recoverable Amt. 3
RXRECVAMT4 BCD*10.3 Retainage Tax Recoverable Amt. 4
RXRECVAMT5 BCD*10.3 Retainage Tax Recoverable Amt. 5
RXEXPSAMT1 BCD*10.3 Retainage Tax Expense Amount 1
RXEXPSAMT2 BCD*10.3 Retainage Tax Expense Amount 2
RXEXPSAMT3 BCD*10.3 Retainage Tax Expense Amount 3
RXEXPSAMT4 BCD*10.3 Retainage Tax Expense Amount 4
RXEXPSAMT5 BCD*10.3 Retainage Tax Expense Amount 5
RXALLOAMT1 BCD*10.3 Retainage Tax Allocated Amount 1
RXALLOAMT2 BCD*10.3 Retainage Tax Allocated Amount 2
RXALLOAMT3 BCD*10.3 Retainage Tax Allocated Amount 3
RXALLOAMT4 BCD*10.3 Retainage Tax Allocated Amount 4
RXALLOAMT5 BCD*10.3 Retainage Tax Allocated Amount 5

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