View: Generic Cost Data

RotoID: PO0295
Table: POCOSTZ
Protocol: Flat
DLL:POCOSTZ

Keys: 6

Title Fields
Detail Key PRORSEQ, COSTSEQ
Account Sets COSTSEQ
Account Sets CRNSSEQ
Account Sets INVSSEQ
Account Sets RCPSSEQ
Account Sets RETSSEQ

Fields: 77

Field Index Type Title Attributes Presentation
PRORSEQ 1 BCD*10.0 Prorate Sequence E A K R 
COSTSEQ 2 BCD*10.0 Cost Sequence E A K R 
TRANSTYPE 3 Integer Transaction Type E A 
RCPSSEQ 4 BCD*10.0 Receipt Cost Sequence E A 
INVSSEQ 5 BCD*10.0 Invoice Cost Sequence E A 
RETSSEQ 6 BCD*10.0 Return Cost Sequence E A 
CRNSSEQ 7 BCD*10.0 Credit/Debit Note Cost Sequence E A 
PONUMBER 8 String*22 Purchase Order Number E A 
RCPNUMBER 9 String*22 Receipt Number E A 
RETNUMBER 10 String*22 Return Number E A 
INVNUMBER 11 String*22 Invoice Number E A 
CRNNUMBER 12 String*22 Credit/Debit Note Number E A 
ADDCOST 13 String*6 Additional Cost E A 
DESCRIPTIO 14 String*60 Description E A 
PRORMETHOD 15 Integer Proration Method E A 
REPRORATE 16 Integer Reproration Method E A 
MTOPRORATE 17 BCD*10.3 Manual To Prorate E A 
VENDOR 18 String*12 Vendor E A 
VENDORNAME 19 String*60 Name E A 
FORPRIMARY 20 Integer Primary Vendor E A 
TAXGROUP 21 String*12 Tax Group E A 
TAXAUTH1 22 String*12 Tax Authority 1 E A 
TAXAUTH2 23 String*12 Tax Authority 2 E A 
TAXAUTH3 24 String*12 Tax Authority 3 E A 
TAXAUTH4 25 String*12 Tax Authority 4 E A 
TAXAUTH5 26 String*12 Tax Authority 5 E A 
TAXVCLASS1 27 Integer Vendor Tax Class 1 E A 
TAXVCLASS2 28 Integer Vendor Tax Class 2 E A 
TAXVCLASS3 29 Integer Vendor Tax Class 3 E A 
TAXVCLASS4 30 Integer Vendor Tax Class 4 E A 
TAXVCLASS5 31 Integer Vendor Tax Class 5 E A 
TAXICLASS1 32 Integer Cost Tax Class 1 E A 
TAXICLASS2 33 Integer Cost Tax Class 2 E A 
TAXICLASS3 34 Integer Cost Tax Class 3 E A 
TAXICLASS4 35 Integer Cost Tax Class 4 E A 
TAXICLASS5 36 Integer Cost Tax Class 5 E A 
CURRENCY 37 String*3 Currency E A 
EXRATE 38 BCD*8.7 Exchange Rate E A 
RATEDATE 39 Date Rate Date E A 
RATETYPE 40 String*2 Rate Type E A 
RATEOPER 41 Integer Rate Operation E A 
RATEOVER 42 Boolean Rate Overridden E A 
SCURNDECML 43 Integer Decimal Places E A 
GLEXPACCT 44 String*45 Expense Account E A 
GLRETACCT 45 String*45 Return Account E A 
TAXINCLUD1 46 Boolean Tax Includable 1 E A 
TAXINCLUD2 47 Boolean Tax Includable 2 E A 
TAXINCLUD3 48 Boolean Tax Includable 3 E A 
TAXINCLUD4 49 Boolean Tax Includable 4 E A 
TAXINCLUD5 50 Boolean Tax Includable 5 E A 
INVSSEQG 51 BCD*10.0 Invoice Cost Group Sequence E A 
NOPRORTOGL 52 Boolean Exp. Add'l Cost G/L data posted? E A 
COMMENT 53 String*250 Comment E A 
CONTRACT 54 String*16 Contract E A 
PROJECT 55 String*16 Project E A 
CCATEGORY 56 String*16 (Cost) Category E A 
COSTCLASS 57 Integer Cost Class E A 
RESOURCE 58 String*24 Resource E A 
BILLTYPE 59 Integer Billing Type E A 
BILLCURR 60 String*3 Billing Currency E A 
BCRATEDATE 61 Date Billing Currency Conv. Rate Date E A 
ARITEMNO 62 String*16 A/R Item Number E A 
ARUNIT 63 String*10 A/R Unit of Measure E A 
CALCOVRHD 64 Boolean Calculate Overhead E A 
CALCLABOR 65 Boolean Calculate Labor E A 
HASRTG 66 Boolean Has Retainage E A 
RTGRATE 67 Integer Retainage Exchange Rate E A 
RTGPERCENT 68 BCD*5.5 Retainage Percentage E A 
RTGDAYS 69 Integer Retention Period E A 
PMTRANSNUM 70 Long PJC Transaction Number E A 
TRCURRENCY 71 String*3 Tax Reporting Currency E A 
EXRATERC 72 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 73 Date Tax Reporting Rate Date E A 
RATETYPERC 74 String*2 Tax Reporting Rate Type E A 
RATEOPERRC 75 Integer Tax Reporting Rate Operation E A 
RATERCOVER 76 Boolean Tax Reporting Rate Overridden E A 
RCURNDECML 77 Integer Tax Reporting Decimal Places E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).