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: %-30c
VDFAX  String*30  Fax Number  Mask: %-30c
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=*
2=/
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: %-30c
VDFAXC  String*30  Contact Fax  Mask: %-30c
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=*
2=/
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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.