Table: Returns

Table: PORETH2
View: PO0731
Record Length: 1485

Flags: A R 

Keys: 1

Title Flags Fields
Master Key RETHSEQ

Fields: 53

Field Type Title Presentation
RETHSEQ BCD*10.0 Return Sequence Key
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
BTCODE String*6 Bill-To Location Mask: %-6N
BTDESC String*60 Bill-To Location Description
BTADDRESS1 String*60 Bill-To Address 1
BTADDRESS2 String*60 Bill-To Address 2
BTADDRESS3 String*60 Bill-To Address 3
BTADDRESS4 String*60 Bill-To Address 4
BTCITY String*30 Bill-To City
BTSTATE String*30 Bill-To State/Province
BTZIP String*20 Bill-To Zip/Postal Code
BTCOUNTRY String*30 Bill-To Country
BTPHONE String*30 Bill-To Phone Number Mask: (%-3C) %-3C-%-24C
BTFAX String*30 Bill-To Fax Number Mask: (%-3C) %-3C-%-24C
BTCONTACT String*60 Bill-To Contact
STCODE String*6 Ship-To Location Mask: %-6N
STDESC String*60 Ship-To Location Description
STADDRESS1 String*60 Ship-To Address 1
STADDRESS2 String*60 Ship-To Address 2
STADDRESS3 String*60 Ship-To Address 3
STADDRESS4 String*60 Ship-To Address 4
STCITY String*30 Ship-To City
STSTATE String*30 Ship-To State/Province
STZIP String*20 Ship-To Zip/Postal Code
STCOUNTRY String*30 Ship-To Country
STPHONE String*30 Ship-To Phone Number Mask: (%-3C) %-3C-%-24C
STFAX String*30 Ship-To Fax Number Mask: (%-3C) %-3C-%-24C
STCONTACT String*60 Ship-To Contact
PDRATE BCD*8.7 Predecessor's Exchange Rate
PDRATETYPE String*2 Predecessor's Rate Type Mask: %-2N
PDRATEDATE Date Predecessor's Rate Date
PDRATEOPER Integer Predecessor's Rate Operation List:2 entries
1 = Multiply
2 = Divide
PDRATEOVER Boolean Predecessor's Rate Overridden List:2 entries
0 = No
1 = Yes
BTEMAIL String*50 Bill-To E-mail
BTPHONEC String*30 Bill-To Contact Phone Mask: (%-3C) %-3C-%-24C
BTFAXC String*30 Bill-To Contact Fax Mask: (%-3C) %-3C-%-24C
BTEMAILC String*50 Bill-To Contact E-mail
STEMAIL String*50 Ship-To E-mail
STPHONEC String*30 Ship-To Contact Phone Mask: (%-3C) %-3C-%-24C
STFAXC String*30 Ship-To Contact Fax Mask: (%-3C) %-3C-%-24C
STEMAILC String*50 Ship-To Contact E-mail
PDRATERC BCD*8.7 Pred. Tax Reporting Exch. Rate
PDRATTYPRC String*2 Pred. Tax Reporting Rate Type Mask: %-2N
PDRATEDTRC Date Pred. Tax Reporting Rate Date
PDRATEOPRC Integer Pred. Tax Reporting Rate Oper. List:2 entries
1 = Multiply
2 = Divide
PDRATERCOV Boolean Pred. Tax Reporting Rate Overrd. List:2 entries
0 = No
1 = Yes
VDACCTSET String*6 Vendor Account Set Mask: %-6N
DATEBUS Date Posting Date
ENTEREDBY String*8 Entered By
DETAILNEXT Integer Next Detail Number

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