View: Invoice Posting Cost Lines

RotoID: PO0441
Table: POINVT
Protocol: Detail, Ordered revisions
DLL: POINVT

Compositions: 7

RotoID  Tables  Title  DLL 

PO0421  POINVI  Invoice Postings  POINVI
PO0420  POINVH1POINVH2  Invoices  POINVH
PO0440  POINVS  Invoice Additional Costs  POINVS
PO0700  PORCPH1PORCPH2  Receipts  PORCPH
PO0718  PORCPV  Receipt Vendors  PORCPV
PO0714  PORCPS  Receipt Additional Costs  PORCPS
PO0419    Invoice Functions  POINVG

Keys: 1

Title  Fields

Master Key  INVISEQ, INVHSEQ, INVSSEQ

Fields: 119

Field  Index  Type  Title  Attributes  Presentation

INVISEQ  BCD*10.0  Invoice Sequence Key  E A K R   
INVHSEQ  BCD*10.0  Invoice Sequence Key  E A K R   
INVSSEQ  BCD*10.0  Invoice Cost Sequence  E A K R   
OPERATION  Integer  Operation To Post  E A   
RCPHSEQ  BCD*10.0  Receipt Sequence Key  E A   
RCPSSEQ  BCD*10.0  Receipt Cost Sequence  E A   
ADDCOST  String*6  Additional Cost  E A  Mask: %-6N
DESCRIPTIO  String*60  Description  E A   
GLEXPACCT  String*45  Expense Account  E A  Mask: %-45C
GLRETACCT  10  String*45  Return Account  E A  Mask: %-45C
AMOUNT  11  BCD*10.3  Amount  E A   
PRORMETHOD  12  Integer  Proration Method  E A  List: 5 entries
1=No Proration
2=Prorate by Quantity
3=Prorate by Cost
4=Prorate by Weight
5=Prorate Manually
REPRORATE  13  Integer  Reproration Method  E A   
TAXICLASS1  14  Integer  Cost Tax Class 1  E A   
TAXICLASS2  15  Integer  Cost Tax Class 2  E A   
TAXICLASS3  16  Integer  Cost Tax Class 3  E A   
TAXICLASS4  17  Integer  Cost Tax Class 4  E A   
TAXICLASS5  18  Integer  Cost Tax Class 5  E A   
TAXBASE1  19  BCD*10.3  Tax Base 1  E A   
TAXBASE2  20  BCD*10.3  Tax Base 2  E A   
TAXBASE3  21  BCD*10.3  Tax Base 3  E A   
TAXBASE4  22  BCD*10.3  Tax Base 4  E A   
TAXBASE5  23  BCD*10.3  Tax Base 5  E A   
TAXINCLUD1  24  Boolean  Tax Includable 1  E A  List: 2 entries
0=No
1=Yes
TAXINCLUD2  25  Boolean  Tax Includable 2  E A  List: 2 entries
0=No
1=Yes
TAXINCLUD3  26  Boolean  Tax Includable 3  E A  List: 2 entries
0=No
1=Yes
TAXINCLUD4  27  Boolean  Tax Includable 4  E A  List: 2 entries
0=No
1=Yes
TAXINCLUD5  28  Boolean  Tax Includable 5  E A  List: 2 entries
0=No
1=Yes
TXINCLUDE1  29  BCD*10.3  Included Tax Amount 1  E A   
TXINCLUDE2  30  BCD*10.3  Included Tax Amount 2  E A   
TXINCLUDE3  31  BCD*10.3  Included Tax Amount 3  E A   
TXINCLUDE4  32  BCD*10.3  Included Tax Amount 4  E A   
TXINCLUDE5  33  BCD*10.3  Included Tax Amount 5  E A   
TXRECVAMT1  34  BCD*10.3  Tax Recoverable Amount 1  E A   
TXRECVAMT2  35  BCD*10.3  Tax Recoverable Amount 2  E A   
TXRECVAMT3  36  BCD*10.3  Tax Recoverable Amount 3  E A   
TXRECVAMT4  37  BCD*10.3  Tax Recoverable Amount 4  E A   
TXRECVAMT5  38  BCD*10.3  Tax Recoverable Amount 5  E A   
TXEXPSAMT1  39  BCD*10.3  Tax Expense Amount 1  E A   
TXEXPSAMT2  40  BCD*10.3  Tax Expense Amount 2  E A   
TXEXPSAMT3  41  BCD*10.3  Tax Expense Amount 3  E A   
TXEXPSAMT4  42  BCD*10.3  Tax Expense Amount 4  E A   
TXEXPSAMT5  43  BCD*10.3  Tax Expense Amount 5  E A   
TXALLOAMT1  44  BCD*10.3  Tax Allocated Amount 1  E A   
TXALLOAMT2  45  BCD*10.3  Tax Allocated Amount 2  E A   
TXALLOAMT3  46  BCD*10.3  Tax Allocated Amount 3  E A   
TXALLOAMT4  47  BCD*10.3  Tax Allocated Amount 4  E A   
TXALLOAMT5  48  BCD*10.3  Tax Allocated Amount 5  E A   
TXBASEALLO  49  BCD*10.3  Net of Tax  E A   
TFBASEALLO  50  BCD*10.3  Func. Net of Tax  A C   
TFINCLUDE1  51  BCD*10.3  Func. Tax Included Amount 1  A C   
TFINCLUDE2  52  BCD*10.3  Func. Tax Included Amount 2  A C   
TFINCLUDE3  53  BCD*10.3  Func. Tax Included Amount 3  A C   
TFINCLUDE4  54  BCD*10.3  Func. Tax Included Amount 4  A C   
TFINCLUDE5  55  BCD*10.3  Func. Tax Included Amount 5  A C   
TFALLOAMT1  56  BCD*10.3  Func. Tax Allocated Amount 1  A C   
TFALLOAMT2  57  BCD*10.3  Func. Tax Allocated Amount 2  A C   
TFALLOAMT3  58  BCD*10.3  Func. Tax Allocated Amount 3  A C   
TFALLOAMT4  59  BCD*10.3  Func. Tax Allocated Amount 4  A C   
TFALLOAMT5  60  BCD*10.3  Func. Tax Allocated Amount 5  A C   
TFRECVAMT1  61  BCD*10.3  Func. Tax Recoverable Amount 1  A C   
TFRECVAMT2  62  BCD*10.3  Func. Tax Recoverable Amount 2  A C   
TFRECVAMT3  63  BCD*10.3  Func. Tax Recoverable Amount 3  A C   
TFRECVAMT4  64  BCD*10.3  Func. Tax Recoverable Amount 4  A C   
TFRECVAMT5  65  BCD*10.3  Func. Tax Recoverable Amount 5  A C   
TFEXPSAMT1  66  BCD*10.3  Func. Tax Expense Amount 1  A C   
TFEXPSAMT2  67  BCD*10.3  Func. Tax Expense Amount 2  A C   
TFEXPSAMT3  68  BCD*10.3  Func. Tax Expense Amount 3  A C   
TFEXPSAMT4  69  BCD*10.3  Func. Tax Expense Amount 4  A C   
TFEXPSAMT5  70  BCD*10.3  Func. Tax Expense Amount 5  A C   
MTOPRORATE  71  BCD*10.3  Manual To Prorate  A C   
RCPHSEQC  72  BCD*10.0  Receipt/Apply To Receipt Seq Key  E A   
BILLRATE  73  BCD*10.6  Billing Rate  E A   
RTGPERCENT  74  BCD*5.5  Retainage Percentage  E A   
RTGDAYS  75  Integer  Retention Period  E A   
RTGAMOUNT  76  BCD*10.3  Retainage Amount  E A   
RTGDATEDUE  77  Date  Retainage Due Date  E A   
RTGAMTOVER  78  Boolean  Retainage Amount Overridden  E A   
RTGDDTOVER  79  Boolean  Retainage Due Date Overridden  E A   
TRINCLUDE1  80  BCD*10.3  Tax Reporting Included Amount 1  E A   
TRINCLUDE2  81  BCD*10.3  Tax Reporting Included Amount 2  E A   
TRINCLUDE3  82  BCD*10.3  Tax Reporting Included Amount 3  E A   
TRINCLUDE4  83  BCD*10.3  Tax Reporting Included Amount 4  E A   
TRINCLUDE5  84  BCD*10.3  Tax Reporting Included Amount 5  E A   
TRRECVAMT1  85  BCD*10.3  Tax Reporting Recoverable Amt. 1  E A   
TRRECVAMT2  86  BCD*10.3  Tax Reporting Recoverable Amt. 2  E A   
TRRECVAMT3  87  BCD*10.3  Tax Reporting Recoverable Amt. 3  E A   
TRRECVAMT4  88  BCD*10.3  Tax Reporting Recoverable Amt. 4  E A   
TRRECVAMT5  89  BCD*10.3  Tax Reporting Recoverable Amt. 5  E A   
TREXPSAMT1  90  BCD*10.3  Tax Reporting Expense Amount 1  E A   
TREXPSAMT2  91  BCD*10.3  Tax Reporting Expense Amount 2  E A   
TREXPSAMT3  92  BCD*10.3  Tax Reporting Expense Amount 3  E A   
TREXPSAMT4  93  BCD*10.3  Tax Reporting Expense Amount 4  E A   
TREXPSAMT5  94  BCD*10.3  Tax Reporting Expense Amount 5  E A   
TRALLOAMT1  95  BCD*10.3  Tax Reporting Allocated Amount 1  E A   
TRALLOAMT2  96  BCD*10.3  Tax Reporting Allocated Amount 2  E A   
TRALLOAMT3  97  BCD*10.3  Tax Reporting Allocated Amount 3  E A   
TRALLOAMT4  98  BCD*10.3  Tax Reporting Allocated Amount 4  E A   
TRALLOAMT5  99  BCD*10.3  Tax Reporting Allocated Amount 5  E A   
RAXBASE1  100  BCD*10.3  Retainage Tax Base 1  E A   
RAXBASE2  101  BCD*10.3  Retainage Tax Base 2  E A   
RAXBASE3  102  BCD*10.3  Retainage Tax Base 3  E A   
RAXBASE4  103  BCD*10.3  Retainage Tax Base 4  E A   
RAXBASE5  104  BCD*10.3  Retainage Tax Base 5  E A   
RXRECVAMT1  105  BCD*10.3  Retainage Tax Recoverable Amt. 1  E A   
RXRECVAMT2  106  BCD*10.3  Retainage Tax Recoverable Amt. 2  E A   
RXRECVAMT3  107  BCD*10.3  Retainage Tax Recoverable Amt. 3  E A   
RXRECVAMT4  108  BCD*10.3  Retainage Tax Recoverable Amt. 4  E A   
RXRECVAMT5  109  BCD*10.3  Retainage Tax Recoverable Amt. 5  E A   
RXEXPSAMT1  110  BCD*10.3  Retainage Tax Expense Amount 1  E A   
RXEXPSAMT2  111  BCD*10.3  Retainage Tax Expense Amount 2  E A   
RXEXPSAMT3  112  BCD*10.3  Retainage Tax Expense Amount 3  E A   
RXEXPSAMT4  113  BCD*10.3  Retainage Tax Expense Amount 4  E A   
RXEXPSAMT5  114  BCD*10.3  Retainage Tax Expense Amount 5  E A   
RXALLOAMT1  115  BCD*10.3  Retainage Tax Allocated Amount 1  E A   
RXALLOAMT2  116  BCD*10.3  Retainage Tax Allocated Amount 2  E A   
RXALLOAMT3  117  BCD*10.3  Retainage Tax Allocated Amount 3  E A   
RXALLOAMT4  118  BCD*10.3  Retainage Tax Allocated Amount 4  E A   
RXALLOAMT5  119  BCD*10.3  Retainage Tax Allocated Amount 5  E A   

This page was generated on 2009-Nov-19

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