Table: Invoice Postings

Table: POINVI
View: PO0421
Record length: 142
Flags: A R 

Keys: 2

Title  Flags  Fields

Master Key  INVISEQ
Invoices  D  INVHSEQ

Fields: 24

Field  Type  Title  Presentation 

INVISEQ  BCD*10.0  Invoice Sequence Key   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
OPERATION  Integer  Operation To Post   
POSTDATE  Date  Last Posting Date   
ISCOMPLETE  Boolean  Completed  List: 2 entries
0=No
1=Yes
DTCOMPLETE  Date  Date Completed   
INVHSEQ  BCD*10.0  Invoice Sequence Key   
RCPHSEQ  BCD*10.0  Receipt Sequence Key   
RETHSEQ  BCD*10.0  Return Sequence Key   
PORHSEQ  BCD*10.0  Purchase Order Sequence Key   
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   
SCAMOUNT  BCD*10.3  Conversion Source Amount   
FCAMOUNT  BCD*10.3  Conversion Functional Amount   
SCDOCTOTAL  BCD*10.3  Source Document Total   
HASRTG  Boolean  Has Retainage  List: 2 entries
0=No
1=Yes
RTGRATE  Integer  Retainage Exchange Rate   
SCRTGAMT  BCD*10.3  Retainage Amount   

This page was generated on 2009-Nov-19

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