View: Generic Line Data

RotoID: PO0520
Table: POLINEZ
Protocol: Flat
DLL:POLINEZ

Keys: 6

Title Fields
Detail Key PRORSEQ, LINESEQ
Account Sets LINESEQ
Account Sets CRNLSEQ
Account Sets INVLSEQ
Account Sets RCPLSEQ
Account Sets RETLSEQ

Fields: 48

Field Index Type Title Attributes Presentation
PRORSEQ 1 BCD*10.0 Prorate Sequence E A K R 
LINESEQ 2 BCD*10.0 Line Sequence E A K R 
TRANSTYPE 3 Integer Transaction Type E A 
RCPLSEQ 4 BCD*10.0 Receipt Line Sequence E A 
INVLSEQ 5 BCD*10.0 Invoice Line Sequence E A 
RETLSEQ 6 BCD*10.0 Return Line Sequence E A 
CRNLSEQ 7 BCD*10.0 Credit/Debit Note Line Sequence E A 
OEONUMBER 8 String*22 Order Number E A 
ITEMEXISTS 9 Boolean Item Exists E A 
ITEMNO 10 String*24 Item Number E A 
LOCATION 11 String*6 Location E A 
ITEMDESC 12 String*60 Item Description E A 
TAXCLASS1 13 Integer Tax Class 1 E A 
TAXCLASS2 14 Integer Tax Class 2 E A 
TAXCLASS3 15 Integer Tax Class 3 E A 
TAXCLASS4 16 Integer Tax Class 4 E A 
TAXCLASS5 17 Integer Tax Class 5 E A 
RCPUNIT 18 String*10 Unit of Measure E A 
CONVERSION 19 BCD*10.6 Conversion Factor to Stocking E A 
STOCKUNIT 20 String*10 Unit of Measure E A 
UNITCOST 21 BCD*10.6 Unit Cost E A 
TAXINCLUD1 22 Boolean Tax Includable 1 E A 
TAXINCLUD2 23 Boolean Tax Includable 2 E A 
TAXINCLUD3 24 Boolean Tax Includable 3 E A 
TAXINCLUD4 25 Boolean Tax Includable 4 E A 
TAXINCLUD5 26 Boolean Tax Includable 5 E A 
GLACEXPENS 27 String*45 Expense Account E A 
GLISPOSTED 28 Boolean G/L data to be posted? E A 
MPRORATED 29 BCD*10.3 Manual Proration E A 
LASTLOADED 30 BCD*10.6 Last Loaded Cost E A 
TRANSDATE 31 Date Transaction Date E A 
COSTSEQNUM 32 Long Cost Sequence Number E A 
STOCKITEM 33 Boolean Stock Item E A 
GLNONSTKCR 34 String*45 Non-Stock Clearing Account E A 
DISCPCT 35 BCD*5.5 Discount Percentage E A 
COMMENT 36 String*250 Comment E A 
CONTRACT 37 String*16 Contract E A 
PROJECT 38 String*16 Project E A 
CCATEGORY 39 String*16 (Cost) Category E A 
COSTCLASS 40 Integer Cost Class E A 
BILLTYPE 41 Integer Billing Type E A 
BILLRATE 42 BCD*10.6 Billing Rate E A 
BILLCURR 43 String*3 Billing Currency E A 
ARITEMNO 44 String*16 A/R Item Number E A 
ARUNIT 45 String*10 A/R Unit of Measure E A 
RTGPERCENT 46 BCD*5.5 Retainage Percentage E A 
RTGDAYS 47 Integer Retention Period E A 
PMTRANSNUM 48 Long PJC Transaction Number E A 

This page was generated on 2022-Aug-18

© 2021 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).