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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.