View: CR/DR Note Additional Costs

RotoID: PO0320
Table: POCRNS
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: POCRNS

Compositions: 7

RotoID  Tables  Title  DLL 

PO0311  POCRNH1POCRNH2  Credit/Debit Notes  POCRNH
PO0310    Credit/Debit Note Functions  POCRNG
PO0312  POCRNI  Credit/Debit Note Postings  POCRNI
PO0321  POCRNT  CR/DR Note Posting Add. Costs  POCRNT
PO0325  POCRNS  CR/DR Add. Costs Superview  POCRNW
PO0323  POCRNSO  CR/DR Note Add. Cost Opt. Fields  POCRNSO
PO0326  POCRND  CR/DR Note Cost Distributions  POCRND

Keys: 3

Title  Fields

Master Key  CRNHSEQ, CRNSREV
Second Key  CRNHSEQ, CRNSSEQ
Detail Locator Key  CRNSSEQ, CRNHSEQ

Fields: 212

Field  Index  Type  Title  Attributes  Presentation

CRNHSEQ  BCD*10.0  Credit/Debit Note Sequence Key  E A K R   
CRNSREV  BCD*10.0  Line Number  E A K R   
CRNSSEQ  BCD*10.0  Credit/Debit Note Cost Sequence  E A   
COMPLETION  Integer  Completion Status  A X  List: 3 entries
1=No
2=Yes
3=Yes
DTCOMPLETE  Date  Date Completed  A X   
INDBTABLE  Boolean  Stored in Database Table  A C X  List: 2 entries
0=No
1=Yes
RCPHSEQ  BCD*10.0  Receipt Sequence Key  A X   
RCPSSEQ  BCD*10.0  Receipt Cost Sequence  A X   
INVHSEQ  BCD*10.0  Invoice Sequence Key  A X   
INVSSEQ  10  BCD*10.0  Invoice Cost Sequence  A X   
ADDCOST  11  String*6  Additional Cost  E A X  Mask: %-6N
GLEXPACCT  12  String*45  Expense Account  A X  Mask: %-45C
GLRETACCT  13  String*45  Return Account  A X  Mask: %-45C
AMOUNT  14  BCD*10.3  Amount  E A X   
PRORMETHOD  15  Integer  Proration Method  E A P X  List: 1 entries
1=No Proration
REPRORATE  16  Integer  Reproration Method  A P X  List: 3 entries
1=Leave
2=Prorate
3=Expense
DESCRIPTIO  17  String*60  Description  E A X   
REFERENCE  18  String*60  Reference  E A X   
COMMENT  19  String*250  Comment  E A X   
TAXICLASS1  20  Integer  Cost Tax Class 1  E A X   
TAXICLASS2  21  Integer  Cost Tax Class 2  E A X   
TAXICLASS3  22  Integer  Cost Tax Class 3  E A X   
TAXICLASS4  23  Integer  Cost Tax Class 4  E A X   
TAXICLASS5  24  Integer  Cost Tax Class 5  E A X   
TAXBASE1  25  BCD*10.3  Tax Base 1  A X   
TAXBASE2  26  BCD*10.3  Tax Base 2  A X   
TAXBASE3  27  BCD*10.3  Tax Base 3  A X   
TAXBASE4  28  BCD*10.3  Tax Base 4  A X   
TAXBASE5  29  BCD*10.3  Tax Base 5  A X   
TAXRATE1  30  BCD*8.5  Tax Rate 1  A X   
TAXRATE2  31  BCD*8.5  Tax Rate 2  A X   
TAXRATE3  32  BCD*8.5  Tax Rate 3  A X   
TAXRATE4  33  BCD*8.5  Tax Rate 4  A X   
TAXRATE5  34  BCD*8.5  Tax Rate 5  A X   
TAXAMOUNT1  35  BCD*10.3  Tax Amount 1  A X   
TAXAMOUNT2  36  BCD*10.3  Tax Amount 2  A X   
TAXAMOUNT3  37  BCD*10.3  Tax Amount 3  A X   
TAXAMOUNT4  38  BCD*10.3  Tax Amount 4  A X   
TAXAMOUNT5  39  BCD*10.3  Tax Amount 5  A X   
TAXINCLUD1  40  Boolean  Tax Includable 1  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD2  41  Boolean  Tax Includable 2  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD3  42  Boolean  Tax Includable 3  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD4  43  Boolean  Tax Includable 4  E A X  List: 2 entries
0=No
1=Yes
TAXINCLUD5  44  Boolean  Tax Includable 5  E A X  List: 2 entries
0=No
1=Yes
TXALLOAMT1  45  BCD*10.3  Tax Allocated Amount 1  A X   
TXALLOAMT2  46  BCD*10.3  Tax Allocated Amount 2  A X   
TXALLOAMT3  47  BCD*10.3  Tax Allocated Amount 3  A X   
TXALLOAMT4  48  BCD*10.3  Tax Allocated Amount 4  A X   
TXALLOAMT5  49  BCD*10.3  Tax Allocated Amount 5  A X   
TXRECVAMT1  50  BCD*10.3  Tax Recoverable Amount 1  A X   
TXRECVAMT2  51  BCD*10.3  Tax Recoverable Amount 2  A X   
TXRECVAMT3  52  BCD*10.3  Tax Recoverable Amount 3  A X   
TXRECVAMT4  53  BCD*10.3  Tax Recoverable Amount 4  A X   
TXRECVAMT5  54  BCD*10.3  Tax Recoverable Amount 5  A X   
TXEXPSAMT1  55  BCD*10.3  Tax Expense Amount 1  A X   
TXEXPSAMT2  56  BCD*10.3  Tax Expense Amount 2  A X   
TXEXPSAMT3  57  BCD*10.3  Tax Expense Amount 3  A X   
TXEXPSAMT4  58  BCD*10.3  Tax Expense Amount 4  A X   
TXEXPSAMT5  59  BCD*10.3  Tax Expense Amount 5  A X   
TXBASEALLO  60  BCD*10.3  Net of Tax  A X   
TXINCLUDED  61  BCD*10.3  Tax Included  A C X   
TXEXCLUDED  62  BCD*10.3  Tax Excluded  A C X   
TAXAMOUNT  63  BCD*10.3  Total Tax  A C X   
TXRECVAMT  64  BCD*10.3  Total Tax Recoverable  A X   
TXEXPSAMT  65  BCD*10.3  Total Tax Expensed  A X   
TXALLOAMT  66  BCD*10.3  Total Tax Allocated  A X   
TFBASEALLO  67  BCD*10.3  Func. Net of Tax  A C X   
TFINCLUDE1  68  BCD*10.3  Func. Tax Included Amount 1  A C X   
TFINCLUDE2  69  BCD*10.3  Func. Tax Included Amount 2  A C X   
TFINCLUDE3  70  BCD*10.3  Func. Tax Included Amount 3  A C X   
TFINCLUDE4  71  BCD*10.3  Func. Tax Included Amount 4  A C X   
TFINCLUDE5  72  BCD*10.3  Func. Tax Included Amount 5  A C X   
TFALLOAMT1  73  BCD*10.3  Func. Tax Allocated Amount 1  A C X   
TFALLOAMT2  74  BCD*10.3  Func. Tax Allocated Amount 2  A C X   
TFALLOAMT3  75  BCD*10.3  Func. Tax Allocated Amount 3  A C X   
TFALLOAMT4  76  BCD*10.3  Func. Tax Allocated Amount 4  A C X   
TFALLOAMT5  77  BCD*10.3  Func. Tax Allocated Amount 5  A C X   
TFRECVAMT1  78  BCD*10.3  Func. Tax Recoverable Amount 1  A C X   
TFRECVAMT2  79  BCD*10.3  Func. Tax Recoverable Amount 2  A C X   
TFRECVAMT3  80  BCD*10.3  Func. Tax Recoverable Amount 3  A C X   
TFRECVAMT4  81  BCD*10.3  Func. Tax Recoverable Amount 4  A C X   
TFRECVAMT5  82  BCD*10.3  Func. Tax Recoverable Amount 5  A C X   
TFEXPSAMT1  83  BCD*10.3  Func. Tax Expense Amount 1  A C X   
TFEXPSAMT2  84  BCD*10.3  Func. Tax Expense Amount 2  A C X   
TFEXPSAMT3  85  BCD*10.3  Func. Tax Expense Amount 3  A C X   
TFEXPSAMT4  86  BCD*10.3  Func. Tax Expense Amount 4  A C X   
TFEXPSAMT5  87  BCD*10.3  Func. Tax Expense Amount 5  A C X   
RCPNUMBER  88  String*22  Receipt Number  A X  Mask: %-22C
RCPHSEQA  89  BCD*10.0  Apply To Receipt Sequence Key  A X   
RCPNUMBERA  90  String*22  Apply To Receipt Number  A X  Mask: %-22C
INVSSEQG  91  BCD*10.0  Invoice Cost Group Sequence  A X   
VALUES  92  Long  Optional Fields  E A C X   
CONTRACT  93  String*16  Contract  A X  Mask: %-16C
PROJECT  94  String*16  Project  A X  Mask: %-16N
CCATEGORY  95  String*16  (Cost) Category  A X  Mask: %-16N
COSTCLASS  96  Integer  Cost Class  A C X  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  97  String*24  Resource  A P X  Mask: %-16N
BILLTYPE  98  Integer  Billing Type  A P X  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
BILLRATE  99  BCD*10.6  Billing Rate  A X   
BILLCURR  100  String*3  Billing Currency  A C X  Mask: %-3N
ARITEMNO  101  String*16  A/R Item Number  A X  Mask: %-16C
ARUNIT  102  String*10  A/R Unit of Measure  A X  Mask: %-10C
CALCOVRHD  103  Boolean  Calculate Overhead  A X  List: 2 entries
0=No
1=Yes
CALCLABOR  104  Boolean  Calculate Labor  A X  List: 2 entries
0=No
1=Yes
RTGPERCENT  105  BCD*5.5  Retainage Percentage  A X   
RTGDAYS  106  Integer  Retention Period  A X   
RTGAMOUNT  107  BCD*10.3  Retainage Amount  A X   
RTGDATEDUE  108  Date  Retainage Due Date  A X   
RTGAMTOVER  109  Boolean  Retainage Amount Overridden  A C X  List: 2 entries
0=No
1=Yes
RTGDDTOVER  110  Boolean  Retainage Due Date Overridden  A C X  List: 2 entries
0=No
1=Yes
COSTDISTS  111  Long  Cost Distributions  E A C X   
MANDISTS  112  Long  Manual Cost Distributions  E A C X   
EXTDISTS  113  Long  Extraneous Cost Distributions  E A C X   
TARAMOUNT1  114  BCD*10.3  Tax Reporting Amount 1  A X   
TARAMOUNT2  115  BCD*10.3  Tax Reporting Amount 2  A X   
TARAMOUNT3  116  BCD*10.3  Tax Reporting Amount 3  A X   
TARAMOUNT4  117  BCD*10.3  Tax Reporting Amount 4  A X   
TARAMOUNT5  118  BCD*10.3  Tax Reporting Amount 5  A X   
TRALLOAMT1  119  BCD*10.3  Tax Reporting Allocated Amount 1  A X   
TRALLOAMT2  120  BCD*10.3  Tax Reporting Allocated Amount 2  A X   
TRALLOAMT3  121  BCD*10.3  Tax Reporting Allocated Amount 3  A X   
TRALLOAMT4  122  BCD*10.3  Tax Reporting Allocated Amount 4  A X   
TRALLOAMT5  123  BCD*10.3  Tax Reporting Allocated Amount 5  A X   
TRRECVAMT1  124  BCD*10.3  Tax Reporting Recoverable Amt. 1  A X   
TRRECVAMT2  125  BCD*10.3  Tax Reporting Recoverable Amt. 2  A X   
TRRECVAMT3  126  BCD*10.3  Tax Reporting Recoverable Amt. 3  A X   
TRRECVAMT4  127  BCD*10.3  Tax Reporting Recoverable Amt. 4  A X   
TRRECVAMT5  128  BCD*10.3  Tax Reporting Recoverable Amt. 5  A X   
TREXPSAMT1  129  BCD*10.3  Tax Reporting Expense Amount 1  A X   
TREXPSAMT2  130  BCD*10.3  Tax Reporting Expense Amount 2  A X   
TREXPSAMT3  131  BCD*10.3  Tax Reporting Expense Amount 3  A X   
TREXPSAMT4  132  BCD*10.3  Tax Reporting Expense Amount 4  A X   
TREXPSAMT5  133  BCD*10.3  Tax Reporting Expense Amount 5  A X   
GLEXPACCTD  141  String*60  Expense Account Description  A C X   
GLRETACCTD  142  String*60  Return Expense Account Desc.  A C X   
TXICLASS1D  143  String*60  Tax Class 1 Description  A C X   
TXICLASS2D  144  String*60  Tax Class 2 Description  A C X   
TXICLASS3D  145  String*60  Tax Class 3 Description  A C X   
TXICLASS4D  146  String*60  Tax Class 4 Description  A C X   
TXICLASS5D  147  String*60  Tax Class 5 Description  A C X   
TXINCLUDE1  148  BCD*10.3  Included Tax Amount 1  A X   
TXINCLUDE2  149  BCD*10.3  Included Tax Amount 2  A X   
TXINCLUDE3  150  BCD*10.3  Included Tax Amount 3  A X   
TXINCLUDE4  151  BCD*10.3  Included Tax Amount 4  A X   
TXINCLUDE5  152  BCD*10.3  Included Tax Amount 5  A X   
TXEXCLUDE1  153  BCD*10.3  Excluded Tax Amount 1  A X   
TXEXCLUDE2  154  BCD*10.3  Excluded Tax Amount 2  A X   
TXEXCLUDE3  155  BCD*10.3  Excluded Tax Amount 3  A X   
TXEXCLUDE4  156  BCD*10.3  Excluded Tax Amount 4  A X   
TXEXCLUDE5  157  BCD*10.3  Excluded Tax Amount 5  A X   
MTOPRORATE  158  BCD*10.3  Manual To Prorate  A C X   
ISCOMPLETE  159  Boolean  Completed  E A X  List: 2 entries
0=No
1=Yes
TAXLINE  160  Long  Lines Tax Calculation Sees  A X   
COSTCMPL  161  Long  Costs Complete  A X   
COST  162  Long  Costs  A X   
INVSREV  163  BCD*10.0  Line Number  A C X   
RCPSREV  164  BCD*10.0  Line Number  A C X   
PROCESSCMD  165  Integer  Command  E A C X  List: 18 entries
0=Nothing to Process
1=Insert Optional Fields
2=Default and Tranfer Optional Fields
3=Default Opt. Fields During Record Generation
4=Remove Optional Fields
5=Transfer Opt. Fields from Standing Document
6=Insert Item Serial Optional Fields
7=Insert Item Lot Optional Fields
21=Auto-generate Serials
22=Auto-generate Lots
23=Auto-allocate Serials
24=Auto-allocate Lots
25=Clear Serials
26=Clear Lots
27=Auto-assign Serials
28=Auto-assign Lots
29=Create Serials/Lots List
31=Post Serials/Lots to IC Inventory
JOBCOST  166  Long  Job Related Cost  A X   
AMOUNTC  167  BCD*10.3  Amount Distribution Sum  E A C X   
BILLRATEC  168  BCD*10.6  Billing Rate Distribution Sum  E A C X   
CONTSTYLE  169  Integer  Project Style  A C X  List: 3 entries
0=
1=Standard
2=Basic
PROJTYPE  170  Integer  Project Type  A C X  List: 4 entries
0=
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  171  Integer  Accounting Method  A C X  List: 9 entries
0=
1=Completed Project
2=Total Cost Percentage Complete
3=Labor Hours Percentage Complete
4=Billings and Costs
5=Project Percentage Complete
6=Category Percentage Complete
7=Completed Contract
8=Accrual-Basis
UFMTCONTNO  172  String*16  Unformatted Contract Code  A C X  Mask: %-16C
TRINCLUDE1  173  BCD*10.3  Tax Reporting Included Amount 1  A X   
TRINCLUDE2  174  BCD*10.3  Tax Reporting Included Amount 2  A X   
TRINCLUDE3  175  BCD*10.3  Tax Reporting Included Amount 3  A X   
TRINCLUDE4  176  BCD*10.3  Tax Reporting Included Amount 4  A X   
TRINCLUDE5  177  BCD*10.3  Tax Reporting Included Amount 5  A X   
TREXCLUDE1  178  BCD*10.3  Tax Reporting Excluded Amount 1  A X   
TREXCLUDE2  179  BCD*10.3  Tax Reporting Excluded Amount 2  A X   
TREXCLUDE3  180  BCD*10.3  Tax Reporting Excluded Amount 3  A X   
TREXCLUDE4  181  BCD*10.3  Tax Reporting Excluded Amount 4  A X   
TREXCLUDE5  182  BCD*10.3  Tax Reporting Excluded Amount 5  A X   
TARAMOUNT  183  BCD*10.3  Tax Reporting Total Amount  A X   
TRINCLUDED  184  BCD*10.3  Tax Reporting Included Amount  A X   
TREXCLUDED  185  BCD*10.3  Tax Reporting Excluded Amount  A X   
TRRECVAMT  186  BCD*10.3  Tax Reporting Recoverable Amount  A X   
TREXPSAMT  187  BCD*10.3  Tax Reporting Expensed Amount  A X   
TRALLOAMT  188  BCD*10.3  Tax Reporting Allocated Amount  A X   
RAXBASE1  189  BCD*10.3  Retainage Tax Base 1  A X   
RAXBASE2  190  BCD*10.3  Retainage Tax Base 2  A X   
RAXBASE3  191  BCD*10.3  Retainage Tax Base 3  A X   
RAXBASE4  192  BCD*10.3  Retainage Tax Base 4  A X   
RAXBASE5  193  BCD*10.3  Retainage Tax Base 5  A X   
RAXAMOUNT1  194  BCD*10.3  Retainage Tax Amount 1  A X   
RAXAMOUNT2  195  BCD*10.3  Retainage Tax Amount 2  A X   
RAXAMOUNT3  196  BCD*10.3  Retainage Tax Amount 3  A X   
RAXAMOUNT4  197  BCD*10.3  Retainage Tax Amount 4  A X   
RAXAMOUNT5  198  BCD*10.3  Retainage Tax Amount 5  A X   
RXRECVAMT1  201  BCD*10.3  Retainage Tax Recoverable Amt. 1  A X   
RXRECVAMT2  202  BCD*10.3  Retainage Tax Recoverable Amt. 2  A X   
RXRECVAMT3  203  BCD*10.3  Retainage Tax Recoverable Amt. 3  A X   
RXRECVAMT4  204  BCD*10.3  Retainage Tax Recoverable Amt. 4  A X   
RXRECVAMT5  205  BCD*10.3  Retainage Tax Recoverable Amt. 5  A X   
RXEXPSAMT1  206  BCD*10.3  Retainage Tax Expense Amount 1  A X   
RXEXPSAMT2  207  BCD*10.3  Retainage Tax Expense Amount 2  A X   
RXEXPSAMT3  208  BCD*10.3  Retainage Tax Expense Amount 3  A X   
RXEXPSAMT4  209  BCD*10.3  Retainage Tax Expense Amount 4  A X   
RXEXPSAMT5  210  BCD*10.3  Retainage Tax Expense Amount 5  A X   
RXALLOAMT1  211  BCD*10.3  Retainage Tax Allocated Amount 1  A X   
RXALLOAMT2  212  BCD*10.3  Retainage Tax Allocated Amount 2  A X   
RXALLOAMT3  213  BCD*10.3  Retainage Tax Allocated Amount 3  A X   
RXALLOAMT4  214  BCD*10.3  Retainage Tax Allocated Amount 4  A X   
RXALLOAMT5  215  BCD*10.3  Retainage Tax Allocated Amount 5  A X   
RAXAMOUNT  216  BCD*10.3  Retainage Tax Total Amount  A X   
TXRXAMT1  217  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 1  A X   
TXRXAMT2  218  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 2  A X   
TXRXAMT3  219  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 3  A X   
TXRXAMT4  220  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 4  A X   
TXRXAMT5  221  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 5  A X   

This page was generated on 2009-Nov-19

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