View: Receipt Additional Costs

RotoID: PO0714
Table: PORCPS
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: PORCPS

Compositions: 7

RotoID  Tables  Title  DLL 

PO0718  PORCPV  Receipt Vendors  PORCPV
PO0699    Receipt Functions  PORCPG
PO0700  PORCPH1PORCPH2  Receipts  PORCPH
PO0701  PORCPI  Receipt Postings  PORCPI
PO0715  PORCPT  Receipt Posting Additional Costs  PORCPT
PO0719  PORCPSO  Receipt Add. Cost Opt. Field  PORCPSO
PO0696  PORCPD  Receipt Cost Distributions  PORCPD

Keys: 4

Title  Fields

Detail Key  RCPHSEQ, VDCODE, RCPSREV
Sequence Key  RCPHSEQ, RCPSSEQ
Vendor Sequence Key  RCPHSEQ, VDCODE, RCPSSEQ
Detail Locator Key  RCPSSEQ, RCPHSEQ

Fields: 203

Field  Index  Type  Title  Attributes  Presentation

RCPHSEQ  BCD*10.0  Receipt Sequence Key  E A K R   
VDCODE  String*12  Vendor  E A K R  Mask: %-12C
RCPSREV  BCD*10.0  Line Number  E A K R   
RCPSSEQ  BCD*10.0  Receipt 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
ADDCOST  String*6  Additional Cost  A X  Mask: %-6N
GLEXPACCT  String*45  Expense Account  A X  Mask: %-45C
GLRETACCT  10  String*45  Return Account  A X  Mask: %-45C
AMOUNT  11  BCD*10.3  Amount  A X   
PRORMETHOD  12  Integer  Proration Method  A P X  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  A P X  List: 3 entries
1=Leave
2=Prorate
3=Expense
DESCRIPTIO  14  String*60  Description  A X   
REFERENCE  15  String*60  Reference  A X   
COMMENT  16  String*250  Comment  A X   
TAXICLASS1  17  Integer  Cost Tax Class 1  A X   
TAXICLASS2  18  Integer  Cost Tax Class 2  A X   
TAXICLASS3  19  Integer  Cost Tax Class 3  A X   
TAXICLASS4  20  Integer  Cost Tax Class 4  A X   
TAXICLASS5  21  Integer  Cost Tax Class 5  A X   
TAXBASE1  22  BCD*10.3  Tax Base 1  A X   
TAXBASE2  23  BCD*10.3  Tax Base 2  A X   
TAXBASE3  24  BCD*10.3  Tax Base 3  A X   
TAXBASE4  25  BCD*10.3  Tax Base 4  A X   
TAXBASE5  26  BCD*10.3  Tax Base 5  A X   
TAXRATE1  27  BCD*8.5  Tax Rate 1  A X   
TAXRATE2  28  BCD*8.5  Tax Rate 2  A X   
TAXRATE3  29  BCD*8.5  Tax Rate 3  A X   
TAXRATE4  30  BCD*8.5  Tax Rate 4  A X   
TAXRATE5  31  BCD*8.5  Tax Rate 5  A X   
TAXAMOUNT1  32  BCD*10.3  Tax Amount 1  A X   
TAXAMOUNT2  33  BCD*10.3  Tax Amount 2  A X   
TAXAMOUNT3  34  BCD*10.3  Tax Amount 3  A X   
TAXAMOUNT4  35  BCD*10.3  Tax Amount 4  A X   
TAXAMOUNT5  36  BCD*10.3  Tax Amount 5  A X   
TAXINCLUD1  37  Boolean  Tax Includable 1  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD2  38  Boolean  Tax Includable 2  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD3  39  Boolean  Tax Includable 3  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD4  40  Boolean  Tax Includable 4  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD5  41  Boolean  Tax Includable 5  A X  List: 2 entries
0=No
1=Yes
TXALLOAMT1  42  BCD*10.3  Tax Allocated Amount 1  A X   
TXALLOAMT2  43  BCD*10.3  Tax Allocated Amount 2  A X   
TXALLOAMT3  44  BCD*10.3  Tax Allocated Amount 3  A X   
TXALLOAMT4  45  BCD*10.3  Tax Allocated Amount 4  A X   
TXALLOAMT5  46  BCD*10.3  Tax Allocated Amount 5  A X   
TXRECVAMT1  47  BCD*10.3  Tax Recoverable Amount 1  A X   
TXRECVAMT2  48  BCD*10.3  Tax Recoverable Amount 2  A X   
TXRECVAMT3  49  BCD*10.3  Tax Recoverable Amount 3  A X   
TXRECVAMT4  50  BCD*10.3  Tax Recoverable Amount 4  A X   
TXRECVAMT5  51  BCD*10.3  Tax Recoverable Amount 5  A X   
TXEXPSAMT1  52  BCD*10.3  Tax Expense Amount 1  A X   
TXEXPSAMT2  53  BCD*10.3  Tax Expense Amount 2  A X   
TXEXPSAMT3  54  BCD*10.3  Tax Expense Amount 3  A X   
TXEXPSAMT4  55  BCD*10.3  Tax Expense Amount 4  A X   
TXEXPSAMT5  56  BCD*10.3  Tax Expense Amount 5  A X   
TXBASEALLO  57  BCD*10.3  Net of Tax  A X   
TXINCLUDED  58  BCD*10.3  Tax Included  A C X   
TXEXCLUDED  59  BCD*10.3  Tax Excluded  A C X   
TAXAMOUNT  60  BCD*10.3  Total Tax  A C X   
TXRECVAMT  61  BCD*10.3  Total Tax Recoverable  A X   
TXEXPSAMT  62  BCD*10.3  Total Tax Expensed  A X   
TXALLOAMT  63  BCD*10.3  Total Tax Allocated  A X   
TFBASEALLO  64  BCD*10.3  Func. Net of Tax  A C X   
TFINCLUDE1  65  BCD*10.3  Func. Tax Included Amount 1  A C X   
TFINCLUDE2  66  BCD*10.3  Func. Tax Included Amount 2  A C X   
TFINCLUDE3  67  BCD*10.3  Func. Tax Included Amount 3  A C X   
TFINCLUDE4  68  BCD*10.3  Func. Tax Included Amount 4  A C X   
TFINCLUDE5  69  BCD*10.3  Func. Tax Included Amount 5  A C X   
TFALLOAMT1  70  BCD*10.3  Func. Tax Allocated Amount 1  A C X   
TFALLOAMT2  71  BCD*10.3  Func. Tax Allocated Amount 2  A C X   
TFALLOAMT3  72  BCD*10.3  Func. Tax Allocated Amount 3  A C X   
TFALLOAMT4  73  BCD*10.3  Func. Tax Allocated Amount 4  A C X   
TFALLOAMT5  74  BCD*10.3  Func. Tax Allocated Amount 5  A C X   
TFRECVAMT1  75  BCD*10.3  Func. Tax Recoverable Amount 1  A C X   
TFRECVAMT2  76  BCD*10.3  Func. Tax Recoverable Amount 2  A C X   
TFRECVAMT3  77  BCD*10.3  Func. Tax Recoverable Amount 3  A C X   
TFRECVAMT4  78  BCD*10.3  Func. Tax Recoverable Amount 4  A C X   
TFRECVAMT5  79  BCD*10.3  Func. Tax Recoverable Amount 5  A C X   
TFEXPSAMT1  80  BCD*10.3  Func. Tax Expense Amount 1  A C X   
TFEXPSAMT2  81  BCD*10.3  Func. Tax Expense Amount 2  A C X   
TFEXPSAMT3  82  BCD*10.3  Func. Tax Expense Amount 3  A C X   
TFEXPSAMT4  83  BCD*10.3  Func. Tax Expense Amount 4  A C X   
TFEXPSAMT5  84  BCD*10.3  Func. Tax Expense Amount 5  A C X   
VALUES  85  Long  Optional Fields  A C X   
CONTRACT  86  String*16  Contract  A X  Mask: %-16C
PROJECT  87  String*16  Project  A X  Mask: %-16N
CCATEGORY  88  String*16  (Cost) Category  A X  Mask: %-16N
COSTCLASS  89  Integer  Cost Class  A C X  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  90  String*24  Resource  A P X  Mask: %-16N
BILLTYPE  91  Integer  Billing Type  A P X  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
BILLRATE  92  BCD*10.6  Billing Rate  A X   
BILLCURR  93  String*3  Billing Currency  A C X  Mask: %-3N
ARITEMNO  94  String*16  A/R Item Number  A X  Mask: %-16C
ARUNIT  95  String*10  A/R Unit of Measure  A X  Mask: %-10C
CALCOVRHD  96  Boolean  Calculate Overhead  A X  List: 2 entries
0=No
1=Yes
CALCLABOR  97  Boolean  Calculate Labor  A X  List: 2 entries
0=No
1=Yes
RTGPERCENT  98  BCD*5.5  Retainage Percentage  A X   
RTGDAYS  99  Integer  Retention Period  A X   
COSTDISTS  100  Long  Cost Distributions  A C X   
MANDISTS  101  Long  Manual Cost Distributions  A C X   
EXTDISTS  102  Long  Extraneous Cost Distributions  A C X   
RTGAMOUNT  103  BCD*10.3  Retainage Amount  A X   
RTGAMTOVER  104  Boolean  Retainage Amount Overridden  A C X  List: 2 entries
0=No
1=Yes
TARAMOUNT1  105  BCD*10.3  Tax Reporting Amount 1  A X   
TARAMOUNT2  106  BCD*10.3  Tax Reporting Amount 2  A X   
TARAMOUNT3  107  BCD*10.3  Tax Reporting Amount 3  A X   
TARAMOUNT4  108  BCD*10.3  Tax Reporting Amount 4  A X   
TARAMOUNT5  109  BCD*10.3  Tax Reporting Amount 5  A X   
TRALLOAMT1  110  BCD*10.3  Tax Reporting Allocated Amount 1  A X   
TRALLOAMT2  111  BCD*10.3  Tax Reporting Allocated Amount 2  A X   
TRALLOAMT3  112  BCD*10.3  Tax Reporting Allocated Amount 3  A X   
TRALLOAMT4  113  BCD*10.3  Tax Reporting Allocated Amount 4  A X   
TRALLOAMT5  114  BCD*10.3  Tax Reporting Allocated Amount 5  A X   
TRRECVAMT1  115  BCD*10.3  Tax Reporting Recoverable Amt. 1  A X   
TRRECVAMT2  116  BCD*10.3  Tax Reporting Recoverable Amt. 2  A X   
TRRECVAMT3  117  BCD*10.3  Tax Reporting Recoverable Amt. 3  A X   
TRRECVAMT4  118  BCD*10.3  Tax Reporting Recoverable Amt. 4  A X   
TRRECVAMT5  119  BCD*10.3  Tax Reporting Recoverable Amt. 5  A X   
TREXPSAMT1  120  BCD*10.3  Tax Reporting Expense Amount 1  A X   
TREXPSAMT2  121  BCD*10.3  Tax Reporting Expense Amount 2  A X   
TREXPSAMT3  122  BCD*10.3  Tax Reporting Expense Amount 3  A X   
TREXPSAMT4  123  BCD*10.3  Tax Reporting Expense Amount 4  A X   
TREXPSAMT5  124  BCD*10.3  Tax Reporting Expense Amount 5  A X   
TXICLASS1D  141  String*60  Tax Class 1 Description  A C X   
TXICLASS2D  142  String*60  Tax Class 2 Description  A C X   
TXICLASS3D  143  String*60  Tax Class 3 Description  A C X   
TXICLASS4D  144  String*60  Tax Class 4 Description  A C X   
TXICLASS5D  145  String*60  Tax Class 5 Description  A C X   
GLEXPACCTD  146  String*60  Expense Account Description  A C X   
GLRETACCTD  147  String*60  Return Expense Account Desc.  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  A X  List: 2 entries
0=No
1=Yes
TAXLINE  160  Long  Lines Tax Calculation Sees  A X   
COSTPRORAT  161  Long  Number of Costs Prorated  A X   
COSTCMPL  162  Long  Costs Complete  A X   
COST  163  Long  Costs  A X   
PROCESSCMD  164  Integer  Command  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  165  Long  Job Related Cost  A X   
COSTBLPROR  166  Long  Cost Billing Rates Prorated  A X   
AMOUNTC  167  BCD*10.3  Amount Distribution Sum  A C X   
BILLRATEC  168  BCD*10.6  Billing Rate Distribution Sum  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  199  BCD*10.3  Retainage Tax Recoverable Amt. 1  A X   
RXRECVAMT2  200  BCD*10.3  Retainage Tax Recoverable Amt. 2  A X   
RXRECVAMT3  201  BCD*10.3  Retainage Tax Recoverable Amt. 3  A X   
RXRECVAMT4  202  BCD*10.3  Retainage Tax Recoverable Amt. 4  A X   
RXRECVAMT5  203  BCD*10.3  Retainage Tax Recoverable Amt. 5  A X   
RXEXPSAMT1  204  BCD*10.3  Retainage Tax Expense Amount 1  A X   
RXEXPSAMT2  205  BCD*10.3  Retainage Tax Expense Amount 2  A X   
RXEXPSAMT3  206  BCD*10.3  Retainage Tax Expense Amount 3  A X   
RXEXPSAMT4  207  BCD*10.3  Retainage Tax Expense Amount 4  A X   
RXEXPSAMT5  208  BCD*10.3  Retainage Tax Expense Amount 5  A X   
RXALLOAMT1  209  BCD*10.3  Retainage Tax Allocated Amount 1  A X   
RXALLOAMT2  210  BCD*10.3  Retainage Tax Allocated Amount 2  A X   
RXALLOAMT3  211  BCD*10.3  Retainage Tax Allocated Amount 3  A X   
RXALLOAMT4  212  BCD*10.3  Retainage Tax Allocated Amount 4  A X   
RXALLOAMT5  213  BCD*10.3  Retainage Tax Allocated Amount 5  A X   
RAXAMOUNT  214  BCD*10.3  Retainage Tax Total Amount  A X   
TXRXAMT1  215  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 1  A X   
TXRXAMT2  216  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 2  A X   
TXRXAMT3  217  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 3  A X   
TXRXAMT4  218  BCD*10.3  Tax Amount Plus Rtg. Tax Amt. 4  A X   
TXRXAMT5  219  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.