Table: Invoices

Table: POINVH2
View: PO0420
Record Length: 2371

Flags: A R 

Keys: 1

Title Flags Fields
Master Key INVHSEQ

Fields: 91

Field Type Title Presentation
INVHSEQ BCD*10.0 Invoice 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
RTCODE String*6 Remit-To Location Mask: %-6N
RTDESC String*60 Remit-To Location Description
RTADDRESS1 String*60 Remit-To Address 1
RTADDRESS2 String*60 Remit-To Address 2
RTADDRESS3 String*60 Remit-To Address 3
RTADDRESS4 String*60 Remit-To Address 4
RTCITY String*30 Remit-To City
RTSTATE String*30 Remit-To State/Province
RTZIP String*20 Remit-To Zip/Postal Code
RTCOUNTRY String*30 Remit-To Country
RTPHONE String*30 Remit-To Phone Number Mask: (%-3C) %-3C-%-24C
RTFAX String*30 Remit-To Fax Number Mask: (%-3C) %-3C-%-24C
RTCONTACT String*60 Remit-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
RTEMAIL String*50 Remit-To E-mail
RTPHONEC String*30 Remit-To Contact Phone Mask: (%-3C) %-3C-%-24C
RTFAXC String*30 Remit-To Contact Fax Mask: (%-3C) %-3C-%-24C
RTEMAILC String*50 Remit-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
IDN String*30 Import Declaration Number
CAXBASE1 BCD*10.3 Reverse Charges Base 1
CAXBASE2 BCD*10.3 Reverse Charges Base 2
CAXBASE3 BCD*10.3 Reverse Charges Base 3
CAXBASE4 BCD*10.3 Reverse Charges Base 4
CAXBASE5 BCD*10.3 Reverse Charges Base 5
CAXDTAMT1 BCD*10.3 Reverse Charges Detail Amount 1
CAXDTAMT2 BCD*10.3 Reverse Charges Detail Amount 2
CAXDTAMT3 BCD*10.3 Reverse Charges Detail Amount 3
CAXDTAMT4 BCD*10.3 Reverse Charges Detail Amount 4
CAXDTAMT5 BCD*10.3 Reverse Charges Detail Amount 5
CAXAPPLY1 Boolean Reverse Charges Applied 1 List:2 entries
0 = No
1 = Yes
CAXAPPLY2 Boolean Reverse Charges Applied 2 List:2 entries
0 = No
1 = Yes
CAXAPPLY3 Boolean Reverse Charges Applied 3 List:2 entries
0 = No
1 = Yes
CAXAPPLY4 Boolean Reverse Charges Applied 4 List:2 entries
0 = No
1 = Yes
CAXAPPLY5 Boolean Reverse Charges Applied 5 List:2 entries
0 = No
1 = Yes
CAXAMOUNT1 BCD*10.3 Reverse Charges Amount 1
CAXAMOUNT2 BCD*10.3 Reverse Charges Amount 2
CAXAMOUNT3 BCD*10.3 Reverse Charges Amount 3
CAXAMOUNT4 BCD*10.3 Reverse Charges Amount 4
CAXAMOUNT5 BCD*10.3 Reverse Charges Amount 5

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