View: Purchase Order Posting Lines

RotoID: PO0631
Table: POPORM
Protocol: Detail, Ordered revisions
DLL:POPORM

Compositions: 6

RotoID Tables Title DLL
PO0621 POPORI Purchase Order Postings POPORI
PO0619 Purchase Order Functions POPORG
PO0620 POPORH1POPORH2 Purchase Orders POPORH
PO0630 POPORL Purchase Order Lines POPORL
PO0760 PORQNH1PORQNH2 Requisitions PORQNH
PO0770 PORQNL Requisition Lines PORQNL

Keys: 1

Title Fields
Detail Key PORISEQ, PORHSEQ, PORLSEQ

Fields: 134

Field Index Type Title Attributes Presentation
PORISEQ 1 BCD*10.0 Purchase Order Sequence Key E A K R 
PORHSEQ 2 BCD*10.0 Purchase Order Sequence Key E A K R 
PORLSEQ 3 BCD*10.0 Purchase Order Line Sequence E A K R 
OPERATION 4 Integer Operation To Post E A 
RQNHSEQ 5 BCD*10.0 Requisition Sequence Key E A 
RQNLSEQ 6 BCD*10.0 Requisition Line Sequence E A 
AGENTLSEQ 7 BCD*10.0 Agent Line Sequence E A 
ISCOMPLETE 8 Boolean Completed E A 
ISRECEIVED 9 Boolean Received E A 
TOPOSTTOIC 10 Boolean To Post to I/C E A 
ITEMEXISTS 11 Boolean Item Exists E A 
ITEMNO 12 String*24 Item Number E A 
LOCATION 13 String*6 Location E A 
ITEMDESC 14 String*60 Item Description E A 
STOCKITEM 15 Boolean Stock Item E A 
ORDERUNIT 16 String*10 Unit of Measure E A 
ORDERCONV 17 BCD*10.6 Order Unit Conversion E A 
ORDERDECML 18 Integer Order Unit Decimals E A 
STOCKUNIT 19 String*10 Unit of Measure E A 
SQORDERED 20 BCD*10.4 Stocking Quantity Ordered E A 
SQRECEIVED 21 BCD*10.4 Stocking Quantity Received E A 
SQCANCELED 22 BCD*10.4 Stocking Quantity Canceled E A 
SQOUTSTAND 23 BCD*10.4 Stocking Quantity Outstanding E A 
OQORDERED 24 BCD*10.4 Ordered Quantity Ordered E A 
OQRECEIVED 25 BCD*10.4 Ordered Quantity Received E A 
OQCANCELED 26 BCD*10.4 Ordered Quantity Canceled E A 
OQOUTSTAND 27 BCD*10.4 Ordered Quantity Outstanding E A 
UNITWEIGHT 28 BCD*10.4 Unit Weight E A 
EXTWEIGHT 29 BCD*10.4 Extended Weight E A 
UNITCOST 30 BCD*10.6 Unit Cost E A 
EXTENDED 31 BCD*10.3 Extended Cost E A 
TAXBASE1 32 BCD*10.3 Tax Base 1 E A 
TAXBASE2 33 BCD*10.3 Tax Base 2 E A 
TAXBASE3 34 BCD*10.3 Tax Base 3 E A 
TAXBASE4 35 BCD*10.3 Tax Base 4 E A 
TAXBASE5 36 BCD*10.3 Tax Base 5 E A 
TAXCLASS1 37 Integer Tax Class 1 E A 
TAXCLASS2 38 Integer Tax Class 2 E A 
TAXCLASS3 39 Integer Tax Class 3 E A 
TAXCLASS4 40 Integer Tax Class 4 E A 
TAXCLASS5 41 Integer Tax Class 5 E A 
TAXRATE1 42 BCD*8.5 Tax Rate 1 E A 
TAXRATE2 43 BCD*8.5 Tax Rate 2 E A 
TAXRATE3 44 BCD*8.5 Tax Rate 3 E A 
TAXRATE4 45 BCD*8.5 Tax Rate 4 E A 
TAXRATE5 46 BCD*8.5 Tax Rate 5 E A 
TAXINCLUD1 47 Boolean Tax Includable 1 E A 
TAXINCLUD2 48 Boolean Tax Includable 2 E A 
TAXINCLUD3 49 Boolean Tax Includable 3 E A 
TAXINCLUD4 50 Boolean Tax Includable 4 E A 
TAXINCLUD5 51 Boolean Tax Includable 5 E A 
TXBASEALLO 52 BCD*10.3 Net of Tax E A 
TXINCLUDE1 53 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 54 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 55 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 56 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 57 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 58 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 59 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 60 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 61 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 62 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 63 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 64 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 65 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 66 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 67 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 68 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 69 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 70 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 71 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 72 BCD*10.3 Tax Allocated Amount 5 E A 
TFBASEALLO 73 BCD*10.3 Func. Net of Tax E A 
TFINCLUDE1 74 BCD*10.3 Func. Tax Included Amount 1 E A 
TFINCLUDE2 75 BCD*10.3 Func. Tax Included Amount 2 E A 
TFINCLUDE3 76 BCD*10.3 Func. Tax Included Amount 3 E A 
TFINCLUDE4 77 BCD*10.3 Func. Tax Included Amount 4 E A 
TFINCLUDE5 78 BCD*10.3 Func. Tax Included Amount 5 E A 
TFALLOAMT1 79 BCD*10.3 Func. Tax Allocated Amount 1 E A 
TFALLOAMT2 80 BCD*10.3 Func. Tax Allocated Amount 2 E A 
TFALLOAMT3 81 BCD*10.3 Func. Tax Allocated Amount 3 E A 
TFALLOAMT4 82 BCD*10.3 Func. Tax Allocated Amount 4 E A 
TFALLOAMT5 83 BCD*10.3 Func. Tax Allocated Amount 5 E A 
TFRECVAMT1 84 BCD*10.3 Func. Tax Recoverable Amount 1 E A 
TFRECVAMT2 85 BCD*10.3 Func. Tax Recoverable Amount 2 E A 
TFRECVAMT3 86 BCD*10.3 Func. Tax Recoverable Amount 3 E A 
TFRECVAMT4 87 BCD*10.3 Func. Tax Recoverable Amount 4 E A 
TFRECVAMT5 88 BCD*10.3 Func. Tax Recoverable Amount 5 E A 
TFEXPSAMT1 89 BCD*10.3 Func. Tax Expense Amount 1 E A 
TFEXPSAMT2 90 BCD*10.3 Func. Tax Expense Amount 2 E A 
TFEXPSAMT3 91 BCD*10.3 Func. Tax Expense Amount 3 E A 
TFEXPSAMT4 92 BCD*10.3 Func. Tax Expense Amount 4 E A 
TFEXPSAMT5 93 BCD*10.3 Func. Tax Expense Amount 5 E A 
GLACEXPENS 94 String*45 Expense Account E A 
GLNONSTKCR 95 String*45 Non-Stock Clearing Account E A 
DISCPCT 96 BCD*5.5 Discount Percentage E A 
DISCOUNT 97 BCD*10.3 Discount Amount E A 
DISCOUNTF 98 BCD*10.3 Func. Discount Amount E A 
OEONUMBER 99 String*22 Order Number E A 
CONTRACT 100 String*16 Contract E A 
PROJECT 101 String*16 Project E A 
CCATEGORY 102 String*16 (Cost) Category E A 
COSTCLASS 103 Integer Cost Class E A 
BILLTYPE 104 Integer Billing Type E A 
BILLRATE 105 BCD*10.6 Billing Rate E A 
BILLCURR 106 String*3 Billing Currency E A 
ARITEMNO 107 String*16 A/R Item Number E A 
ARUNIT 108 String*10 A/R Unit of Measure E A 
TRINCLUDE1 109 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 110 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 111 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 112 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 113 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 114 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 115 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 116 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 117 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 118 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 119 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 120 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 121 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 122 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 123 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 124 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 125 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 126 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 127 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 128 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
WEIGHTUNIT 129 String*10 Weight Unit of Measure E A 
WEIGHTCONV 130 BCD*10.6 Weight Conversion E A 
DEFUWEIGHT 131 BCD*10.4 Default Unit Weight E A 
DEFEXTWGHT 132 BCD*10.4 Default Extended Weight E A 
QTYPOSTED 133 Boolean Is Quantity Posted? E A 
LAST 150 Boolean Last 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).