Table: Purchase Order Posting Lines

Table: POPORM
View: PO0631
Record Length: 1338

Flags: A R 

Keys: 1

Title Flags Fields
Detail Key PORISEQ, PORHSEQ, PORLSEQ

Fields: 137

Field Type Title Presentation
PORISEQ BCD*10.0 Purchase Order Sequence Key
PORHSEQ BCD*10.0 Purchase Order Sequence Key
PORLSEQ BCD*10.0 Purchase Order Line Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
OPERATION Integer Operation To Post
RQNHSEQ BCD*10.0 Requisition Sequence Key
RQNLSEQ BCD*10.0 Requisition Line Sequence
AGENTLSEQ BCD*10.0 Agent Line Sequence
ISCOMPLETE Boolean Completed
ISRECEIVED Boolean Received
TOPOSTTOIC Boolean To Post to I/C
ITEMEXISTS Boolean Item Exists
ITEMNO String*24 Item Number
LOCATION String*6 Location
ITEMDESC String*60 Item Description
STOCKITEM Boolean Stock Item
ORDERUNIT String*10 Unit of Measure
ORDERCONV BCD*10.6 Order Unit Conversion
ORDERDECML Integer Order Unit Decimals
STOCKUNIT String*10 Unit of Measure
SQORDERED BCD*10.4 Stocking Quantity Ordered
SQRECEIVED BCD*10.4 Stocking Quantity Received
SQCANCELED BCD*10.4 Stocking Quantity Canceled
SQOUTSTAND BCD*10.4 Stocking Quantity Outstanding
OQORDERED BCD*10.4 Ordered Quantity Ordered
OQRECEIVED BCD*10.4 Ordered Quantity Received
OQCANCELED BCD*10.4 Ordered Quantity Canceled
OQOUTSTAND BCD*10.4 Ordered Quantity Outstanding
UNITWEIGHT BCD*10.4 Unit Weight
EXTWEIGHT BCD*10.4 Extended Weight
UNITCOST BCD*10.6 Unit Cost
EXTENDED BCD*10.3 Extended Cost
TAXBASE1 BCD*10.3 Tax Base 1
TAXBASE2 BCD*10.3 Tax Base 2
TAXBASE3 BCD*10.3 Tax Base 3
TAXBASE4 BCD*10.3 Tax Base 4
TAXBASE5 BCD*10.3 Tax Base 5
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
TAXRATE1 BCD*8.5 Tax Rate 1
TAXRATE2 BCD*8.5 Tax Rate 2
TAXRATE3 BCD*8.5 Tax Rate 3
TAXRATE4 BCD*8.5 Tax Rate 4
TAXRATE5 BCD*8.5 Tax Rate 5
TAXINCLUD1 Boolean Tax Includable 1
TAXINCLUD2 Boolean Tax Includable 2
TAXINCLUD3 Boolean Tax Includable 3
TAXINCLUD4 Boolean Tax Includable 4
TAXINCLUD5 Boolean Tax Includable 5
TXBASEALLO BCD*10.3 Net of Tax
TXINCLUDE1 BCD*10.3 Included Tax Amount 1
TXINCLUDE2 BCD*10.3 Included Tax Amount 2
TXINCLUDE3 BCD*10.3 Included Tax Amount 3
TXINCLUDE4 BCD*10.3 Included Tax Amount 4
TXINCLUDE5 BCD*10.3 Included Tax Amount 5
TXRECVAMT1 BCD*10.3 Tax Recoverable Amount 1
TXRECVAMT2 BCD*10.3 Tax Recoverable Amount 2
TXRECVAMT3 BCD*10.3 Tax Recoverable Amount 3
TXRECVAMT4 BCD*10.3 Tax Recoverable Amount 4
TXRECVAMT5 BCD*10.3 Tax Recoverable Amount 5
TXEXPSAMT1 BCD*10.3 Tax Expense Amount 1
TXEXPSAMT2 BCD*10.3 Tax Expense Amount 2
TXEXPSAMT3 BCD*10.3 Tax Expense Amount 3
TXEXPSAMT4 BCD*10.3 Tax Expense Amount 4
TXEXPSAMT5 BCD*10.3 Tax Expense Amount 5
TXALLOAMT1 BCD*10.3 Tax Allocated Amount 1
TXALLOAMT2 BCD*10.3 Tax Allocated Amount 2
TXALLOAMT3 BCD*10.3 Tax Allocated Amount 3
TXALLOAMT4 BCD*10.3 Tax Allocated Amount 4
TXALLOAMT5 BCD*10.3 Tax Allocated Amount 5
TFBASEALLO BCD*10.3 Func. Net of Tax
TFINCLUDE1 BCD*10.3 Func. Tax Included Amount 1
TFINCLUDE2 BCD*10.3 Func. Tax Included Amount 2
TFINCLUDE3 BCD*10.3 Func. Tax Included Amount 3
TFINCLUDE4 BCD*10.3 Func. Tax Included Amount 4
TFINCLUDE5 BCD*10.3 Func. Tax Included Amount 5
TFALLOAMT1 BCD*10.3 Func. Tax Allocated Amount 1
TFALLOAMT2 BCD*10.3 Func. Tax Allocated Amount 2
TFALLOAMT3 BCD*10.3 Func. Tax Allocated Amount 3
TFALLOAMT4 BCD*10.3 Func. Tax Allocated Amount 4
TFALLOAMT5 BCD*10.3 Func. Tax Allocated Amount 5
TFRECVAMT1 BCD*10.3 Func. Tax Recoverable Amount 1
TFRECVAMT2 BCD*10.3 Func. Tax Recoverable Amount 2
TFRECVAMT3 BCD*10.3 Func. Tax Recoverable Amount 3
TFRECVAMT4 BCD*10.3 Func. Tax Recoverable Amount 4
TFRECVAMT5 BCD*10.3 Func. Tax Recoverable Amount 5
TFEXPSAMT1 BCD*10.3 Func. Tax Expense Amount 1
TFEXPSAMT2 BCD*10.3 Func. Tax Expense Amount 2
TFEXPSAMT3 BCD*10.3 Func. Tax Expense Amount 3
TFEXPSAMT4 BCD*10.3 Func. Tax Expense Amount 4
TFEXPSAMT5 BCD*10.3 Func. Tax Expense Amount 5
GLACEXPENS String*45 Expense Account
GLNONSTKCR String*45 Non-Stock Clearing Account
DISCPCT BCD*5.5 Discount Percentage
DISCOUNT BCD*10.3 Discount Amount
DISCOUNTF BCD*10.3 Func. Discount Amount
OEONUMBER String*22 Order Number
CONTRACT String*16 Contract
PROJECT String*16 Project
CCATEGORY String*16 (Cost) Category
COSTCLASS Integer Cost Class
BILLTYPE Integer Billing Type
BILLRATE BCD*10.6 Billing Rate
BILLCURR String*3 Billing Currency
ARITEMNO String*16 A/R Item Number
ARUNIT String*10 A/R Unit of Measure
TRINCLUDE1 BCD*10.3 Tax Reporting Included Amount 1
TRINCLUDE2 BCD*10.3 Tax Reporting Included Amount 2
TRINCLUDE3 BCD*10.3 Tax Reporting Included Amount 3
TRINCLUDE4 BCD*10.3 Tax Reporting Included Amount 4
TRINCLUDE5 BCD*10.3 Tax Reporting Included Amount 5
TRRECVAMT1 BCD*10.3 Tax Reporting Recoverable Amt. 1
TRRECVAMT2 BCD*10.3 Tax Reporting Recoverable Amt. 2
TRRECVAMT3 BCD*10.3 Tax Reporting Recoverable Amt. 3
TRRECVAMT4 BCD*10.3 Tax Reporting Recoverable Amt. 4
TRRECVAMT5 BCD*10.3 Tax Reporting Recoverable Amt. 5
TREXPSAMT1 BCD*10.3 Tax Reporting Expense Amount 1
TREXPSAMT2 BCD*10.3 Tax Reporting Expense Amount 2
TREXPSAMT3 BCD*10.3 Tax Reporting Expense Amount 3
TREXPSAMT4 BCD*10.3 Tax Reporting Expense Amount 4
TREXPSAMT5 BCD*10.3 Tax Reporting Expense Amount 5
TRALLOAMT1 BCD*10.3 Tax Reporting Allocated Amount 1
TRALLOAMT2 BCD*10.3 Tax Reporting Allocated Amount 2
TRALLOAMT3 BCD*10.3 Tax Reporting Allocated Amount 3
TRALLOAMT4 BCD*10.3 Tax Reporting Allocated Amount 4
TRALLOAMT5 BCD*10.3 Tax Reporting Allocated Amount 5
WEIGHTUNIT String*10 Weight Unit of Measure
WEIGHTCONV BCD*10.6 Weight Conversion
DEFUWEIGHT BCD*10.4 Default Unit Weight
DEFEXTWGHT BCD*10.4 Default Extended Weight
QTYPOSTED Boolean Is Quantity Posted?

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