Table: Invoices

Table: POINVH2
View: PO0420
Record length: 2160
Flags: A R 

Keys: 1

Title  Flags  Fields

Master Key   INVHSEQ

Fields: 66

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=*
2=/
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=*
2=/
PDRATERCOV  Boolean  Pred. Tax Reporting Rate Overrd.  List: 2 entries
0=No
1=Yes

This page was generated on 2008-Apr-11

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