Table: Purchase Order Posting Lines

Table: POPORM
View: PO0631
Record Length: 1338

Flags: A R 

Keys: 1

Title Flags Fields

Detail Key PORISEQPORHSEQPORLSEQ

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?