View: Purchase Order Lines

RotoID: PO0630
Table: POPORL
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: POPORL

Compositions: 6

RotoID  Tables  Title  DLL 
PO0620  POPORH1, POPORH2  Purchase Orders  POPORH
PO0610  POPORC  Purchase Order Comments  POPORC
PO0619    Purchase Order Functions  POPORG
PO0621  POPORI  Purchase Order Postings  POPORI
PO0631  POPORM  Purchase Order Posting Lines  POPORM
PO0633  POPORLO  Purchase Order Det. Opt. Fields  POPORLO

Keys: 10

Title  Fields
Detail Key  PORHSEQ, PORLREV
Sequence Key  PORHSEQ, PORLSEQ
Order Number Key  OEONUMBER, PORHSEQ, PORLSEQ
Item/Exp. Arrival Key  ITEMNO, EXPARRIVAL, PORHSEQ, PORLSEQ
Exp. Arrival/Qty. Ordered Key  EXPARRIVAL, OQORDERED, ITEMNO, LOCATION
Exp. Arrival/Item No./Completion  EXPARRIVAL, ITEMNO, COMPLETION
Exp. Arrival/Qty. Outstanding  EXPARRIVAL, OQOUTSTAND, ITEMNO
Item/ExpArrival/Loc./Completion  ITEMNO, EXPARRIVAL, LOCATION, COMPLETION
Detail Number  PORHSEQ, DETAILNUM, PORLSEQ
Item/ExpArrival/Loc./Completion  PORHSEQ, EXPARRIVAL, LOCATION, COMPLETION

Fields: 236

Field  Index  Type  Title  Attributes  Presentation
PORHSEQ  1  BCD*10.0  Purchase Order Sequence Key  E A K R   
PORLREV  2  BCD*10.0  Line Number  E A K R   
PORLSEQ  3  BCD*10.0  Purchase Order Line Sequence  E A X   
PORCSEQ  4  BCD*10.0  Purchase Order Comment Sequence  A X   
INDBTABLE  5  Boolean  Stored in Database Table  A C X  List: 2 entries
0=No
1=Yes
CONSOLSEQ  6  BCD*10.0  Consolidated to line  A C X   
RQNHSEQ  7  BCD*10.0  Requisition Sequence Key  A X   
RQNLSEQ  8  BCD*10.0  Requisition Line Sequence  A X   
OEONUMBER  9  String*22  Order Number  A X  Mask: %-22C
POSTEDTOIC  10  Boolean  Posted to I/C  A C X  List: 2 entries
0=No
1=Yes
TOPOSTTOIC  11  Boolean  To Post to I/C  A C X  List: 2 entries
0=No
1=Yes
STPRINT  12  Boolean  Print Status  A X  List: 2 entries
0=No
1=Yes
COMPLETION  13  Integer  Completion Status  A X  List: 3 entries
1=No
2=Yes
3=Yes
DTCOMPLETE  14  Date  Date Completed  A X   
ITEMEXISTS  15  Boolean  Item Exists  A C X  List: 2 entries
0=No
1=Yes
ITEMNO  16  String*24  Item Number  A P X  Mask: %-24C
LOCATION  17  String*6  Location  A X  Mask: %-6N
ITEMDESC  18  String*60  Item Description  A X   
EXPARRIVAL  19  Date  Expected Arrival Date  A X   
VENDITEMNO  20  String*24  Vendor Item Number  A X   
HASCOMMENT  21  Boolean  Comments/Instructions  A X  List: 2 entries
0=No
1=Yes
ORDERUNIT  22  String*10  Unit of Measure  A X  Mask: %-10c
ORDERCONV  23  BCD*10.6  Order Unit Conversion  A C X   
ORDERDECML  24  Integer  Order Unit Decimals  A C X   
STOCKDECML  25  Integer  Stock Unit Decimals  A C X   
OQORDERED  26  BCD*10.4  Quantity Ordered  A X   
OQRECEIVED  27  BCD*10.4  Quantity Received  A C X   
OQCANCELED  28  BCD*10.4  Quantity Canceled  A X   
OQRCPEXTRA  29  BCD*10.4  Received Extra  A C X   
OQOUTSTAND  30  BCD*10.4  Quantity Outstanding  A X   
SQORDERED  31  BCD*10.4  Stocking Quantity Ordered  A C X   
SQRECEIVED  32  BCD*10.4  Stocking Quantity Received  A C X   
SQCANCELED  33  BCD*10.4  Stocking Quantity Canceled  A C X   
SQRCPEXTRA  34  BCD*10.4  Stocking Quantity Received Extra  A C X   
SQSETTLED  35  BCD*10.4  Stocking Quantity Settled  A C X   
SQOUTSTAND  36  BCD*10.4  Stocking Quantity Outstanding  A C X   
UNITWEIGHT  37  BCD*10.4  Unit Weight  A X   
EXTWEIGHT  38  BCD*10.4  Extended Weight  A X   
OQRCPDAYS  39  BCD*10.4  Days * Quantity Received  A C X   
EXTRECEIVE  40  BCD*10.3  Extended Received Amount  A C X   
EXTCANCEL  41  BCD*10.3  Extended Canceled Amount  A C X   
SRRECEIVED  42  BCD*10.3  Amount Received To Date  A X   
UNITCOST  43  BCD*10.6  Unit Cost  A X   
EXTENDED  44  BCD*10.3  Extended Cost  A X   
TAXBASE1  45  BCD*10.3  Tax Base 1  A X   
TAXBASE2  46  BCD*10.3  Tax Base 2  A X   
TAXBASE3  47  BCD*10.3  Tax Base 3  A X   
TAXBASE4  48  BCD*10.3  Tax Base 4  A X   
TAXBASE5  49  BCD*10.3  Tax Base 5  A X   
TAXCLASS1  50  Integer  Tax Class 1  A X   
TAXCLASS2  51  Integer  Tax Class 2  A X   
TAXCLASS3  52  Integer  Tax Class 3  A X   
TAXCLASS4  53  Integer  Tax Class 4  A X   
TAXCLASS5  54  Integer  Tax Class 5  A X   
TAXRATE1  55  BCD*8.5  Tax Rate 1  A X   
TAXRATE2  56  BCD*8.5  Tax Rate 2  A X   
TAXRATE3  57  BCD*8.5  Tax Rate 3  A X   
TAXRATE4  58  BCD*8.5  Tax Rate 4  A X   
TAXRATE5  59  BCD*8.5  Tax Rate 5  A X   
TAXINCLUD1  60  Boolean  Tax Includable 1  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD2  61  Boolean  Tax Includable 2  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD3  62  Boolean  Tax Includable 3  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD4  63  Boolean  Tax Includable 4  A X  List: 2 entries
0=No
1=Yes
TAXINCLUD5  64  Boolean  Tax Includable 5  A X  List: 2 entries
0=No
1=Yes
TAXAMOUNT1  65  BCD*10.3  Tax Amount 1  A X   
TAXAMOUNT2  66  BCD*10.3  Tax Amount 2  A X   
TAXAMOUNT3  67  BCD*10.3  Tax Amount 3  A X   
TAXAMOUNT4  68  BCD*10.3  Tax Amount 4  A X   
TAXAMOUNT5  69  BCD*10.3  Tax Amount 5  A X   
TXALLOAMT1  70  BCD*10.3  Tax Allocated Amount 1  A X   
TXALLOAMT2  71  BCD*10.3  Tax Allocated Amount 2  A X   
TXALLOAMT3  72  BCD*10.3  Tax Allocated Amount 3  A X   
TXALLOAMT4  73  BCD*10.3  Tax Allocated Amount 4  A X   
TXALLOAMT5  74  BCD*10.3  Tax Allocated Amount 5  A X   
TXRECVAMT1  75  BCD*10.3  Tax Recoverable Amount 1  A X   
TXRECVAMT2  76  BCD*10.3  Tax Recoverable Amount 2  A X   
TXRECVAMT3  77  BCD*10.3  Tax Recoverable Amount 3  A X   
TXRECVAMT4  78  BCD*10.3  Tax Recoverable Amount 4  A X   
TXRECVAMT5  79  BCD*10.3  Tax Recoverable Amount 5  A X   
TXEXPSAMT1  80  BCD*10.3  Tax Expense Amount 1  A X   
TXEXPSAMT2  81  BCD*10.3  Tax Expense Amount 2  A X   
TXEXPSAMT3  82  BCD*10.3  Tax Expense Amount 3  A X   
TXEXPSAMT4  83  BCD*10.3  Tax Expense Amount 4  A X   
TXEXPSAMT5  84  BCD*10.3  Tax Expense Amount 5  A X   
TXBASEALLO  85  BCD*10.3  Net of Tax  A X   
TXINCLUDED  86  BCD*10.3  Tax Included  A C X   
TXEXCLUDED  87  BCD*10.3  Tax Excluded  A C X   
TAXAMOUNT  88  BCD*10.3  Total Tax  A C X   
TXRECVAMT  89  BCD*10.3  Recoverable Tax  A X   
TXEXPSAMT  90  BCD*10.3  Expensed Tax  A X   
TXALLOAMT  91  BCD*10.3  Allocated Tax  A X   
FCEXTENDED  92  BCD*10.3  Rcp. Ext. Amt.  A X   
GLACEXPENS  93  String*45  Expense Account  A X  Mask: %-45C
HASDROPSHI  94  Boolean  Drop-Ship  A X  List: 2 entries
0=No
1=Yes
DROPTYPE  95  Integer  Drop-Ship Type  A P X  List: 4 entries
2=Address Entered
3=Inventory Location Address
4=Customer Address
5=Customer Ship-To Address
IDCUST  96  String*12  Drop-Ship Customer  A X  Mask: %-12C
IDCUSTSHPT  97  String*6  Customer Ship-To Address  A X  Mask: %-6C
DLOCATION  98  String*6  Drop-Ship Location  A X  Mask: %-6N
DESC  99  String*60  Drop-Ship Description  A X   
ADDRESS1  100  String*60  Drop-Ship Address 1  A X   
ADDRESS2  101  String*60  Drop-Ship Address 2  A X   
ADDRESS3  102  String*60  Drop-Ship Address 3  A X   
ADDRESS4  103  String*60  Drop-Ship Address 4  A X   
CITY  104  String*30  Drop-Ship City  A X   
STATE  105  String*30  Drop-Ship State/Province  A X   
ZIP  106  String*20  Drop-Ship Zip/Postal Code  A X   
COUNTRY  107  String*30  Drop-Ship Country  A X   
PHONE  108  String*30  Drop-Ship Phone Number  A X  Mask: %-30c
FAX  109  String*30  Drop-Ship Fax Number  A X  Mask: %-30c
CONTACT  110  String*60  Drop-Ship Contact  A X   
STOCKITEM  111  Boolean  Stock Item  A C X  List: 2 entries
0=No
1=Yes
EMAIL  112  String*50  Drop-Ship E-mail  A X   
PHONEC  113  String*30  Drop-Ship Contact Phone  A X  Mask: %-30c
FAXC  114  String*30  Drop-Ship Contact Fax  A X  Mask: %-30c
EMAILC  115  String*50  Drop-Ship Contact E-mail  A X   
GLNONSTKCR  116  String*45  Non-Stock Clearing Account  A X  Mask: %-45C
MANITEMNO  117  String*24  Manufacturer's Item Number  A X  Mask: %-24C
DISCPCT  118  BCD*5.5  Discount Percentage  A X   
DISCOUNT  119  BCD*10.3  Discount Amount  A X   
VALUES  120  Long  Optional Fields  A C X   
DISCOUNTF  121  BCD*10.3  Func. Discount Amount  A X   
ISRECEIVED  122  Boolean  Received  A X  List: 2 entries
0=No
1=Yes
AGENTLSEQ  123  BCD*10.0  Agent Line Sequence  A X   
CONTRACT  124  String*16  Contract  A X  Mask: %-16C
PROJECT  125  String*16  Project  A X  Mask: %-16N
CCATEGORY  126  String*16  (Cost) Category  A X  Mask: %-16N
COSTCLASS  127  Integer  Cost Class  A C X  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
BILLTYPE  128  Integer  Billing Type  A P X  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
BILLRATE  129  BCD*10.6  Billing Rate  A X   
BILLCURR  130  String*3  Billing Currency  A C X  Mask: %-3N
ARITEMNO  131  String*16  A/R Item Number  A X  Mask: %-16C
ARUNIT  132  String*10  A/R Unit of Measure  A X  Mask: %-10C
TAXCLASS1D  141  String*60  Tax Class 1 Description  A C X   
TAXCLASS2D  142  String*60  Tax Class 2 Description  A C X   
TAXCLASS3D  143  String*60  Tax Class 3 Description  A C X   
TAXCLASS4D  144  String*60  Tax Class 4 Description  A C X   
TAXCLASS5D  145  String*60  Tax Class 5 Description  A C X   
GLACEXPNSD  146  String*60  Expense Account Description  A C X   
TXINCLUDE1  147  BCD*10.3  Included Tax Amount 1  A X   
TXINCLUDE2  148  BCD*10.3  Included Tax Amount 2  A X   
TXINCLUDE3  149  BCD*10.3  Included Tax Amount 3  A X   
TXINCLUDE4  150  BCD*10.3  Included Tax Amount 4  A X   
TXINCLUDE5  151  BCD*10.3  Included Tax Amount 5  A X   
TXEXCLUDE1  152  BCD*10.3  Excluded Tax Amount 1  A X   
TXEXCLUDE2  153  BCD*10.3  Excluded Tax Amount 2  A X   
TXEXCLUDE3  154  BCD*10.3  Excluded Tax Amount 3  A X   
TXEXCLUDE4  155  BCD*10.3  Excluded Tax Amount 4  A X   
TXEXCLUDE5  156  BCD*10.3  Excluded Tax Amount 5  A X   
SREXTORDER  157  BCD*10.3  Extended Order Amount  A C X   
ISCOMPLETE  158  Boolean  Completed  A X  List: 2 entries
0=No
1=Yes
ISACTIVE  159  Boolean  Is Record Active  A C X  List: 2 entries
0=No
1=Yes
TAXLINE  160  Long  Lines Tax Calculation Sees  A X   
LINECMPL  161  Long  Lines Complete  A X   
LINE  162  Long  Line  A X   
EXSTDCOST  163  BCD*10.3  Extended Std. Cost in Src Curr  A C X   
EXMRCOST  164  BCD*10.3  Extended MR Cost in Src Curr  A C X   
EXALT1COST  165  BCD*10.3  Extended Cost 1 in Src Curr  A C X   
EXALT2COST  166  BCD*10.3  Extended Cost 2 in Src Curr  A C X   
GLNONSTKCD  167  String*60  Non-Stock Clearing Account Desc.  A C X   
MAPMANITEM  168  Boolean  Map Manufacturer's Item Number  E A  List: 2 entries
0=No
1=Yes
NETXTENDED  169  BCD*10.3  Net Extended Cost  A X   
OOVERSEQ  170  BCD*10.0  Process Command Sequence Number  A C X   
OOVERLSEQ  171  BCD*10.0  Process Command Line Sequence  A C X   
RQNLREV  172  BCD*10.0  Line Number  A C X   
PROCESSCMD  173  Integer  Command  A C X  List: 18 entries
0=Nothing to Process
1=Insert Optional Fields
2=Default and Tranfer Optional Fields
3=Default Opt. Fields During Record Generation
4=Remove Optional Fields
5=Transfer Opt. Fields from Standing Document
6=Insert Item Serial Optional Fields
7=Insert Item Lot Optional Fields
21=Auto-generate Serials
22=Auto-generate Lots
23=Auto-allocate Serials
24=Auto-allocate Lots
25=Clear Serials
26=Clear Lots
27=Auto-assign Serials
28=Auto-assign Lots
29=Create Serials/Lots List
31=Post Serials/Lots to IC Inventory
TFBASEALLO  174  BCD*10.3  Func. Net of Tax  A C X   
TFINCLUDE1  175  BCD*10.3  Func. Tax Included Amount 1  A C X   
TFINCLUDE2  176  BCD*10.3  Func. Tax Included Amount 2  A C X   
TFINCLUDE3  177  BCD*10.3  Func. Tax Included Amount 3  A C X   
TFINCLUDE4  178  BCD*10.3  Func. Tax Included Amount 4  A C X   
TFINCLUDE5  179  BCD*10.3  Func. Tax Included Amount 5  A C X   
TFALLOAMT1  180  BCD*10.3  Func. Tax Allocated Amount 1  A C X   
TFALLOAMT2  181  BCD*10.3  Func. Tax Allocated Amount 2  A C X   
TFALLOAMT3  182  BCD*10.3  Func. Tax Allocated Amount 3  A C X   
TFALLOAMT4  183  BCD*10.3  Func. Tax Allocated Amount 4  A C X   
TFALLOAMT5  184  BCD*10.3  Func. Tax Allocated Amount 5  A C X   
TFRECVAMT1  185  BCD*10.3  Func. Tax Recoverable Amount 1  A C X   
TFRECVAMT2  186  BCD*10.3  Func. Tax Recoverable Amount 2  A C X   
TFRECVAMT3  187  BCD*10.3  Func. Tax Recoverable Amount 3  A C X   
TFRECVAMT4  188  BCD*10.3  Func. Tax Recoverable Amount 4  A C X   
TFRECVAMT5  189  BCD*10.3  Func. Tax Recoverable Amount 5  A C X   
TFEXPSAMT1  190  BCD*10.3  Func. Tax Expense Amount 1  A C X   
TFEXPSAMT2  191  BCD*10.3  Func. Tax Expense Amount 2  A C X   
TFEXPSAMT3  192  BCD*10.3  Func. Tax Expense Amount 3  A C X   
TFEXPSAMT4  193  BCD*10.3  Func. Tax Expense Amount 4  A C X   
TFEXPSAMT5  194  BCD*10.3  Func. Tax Expense Amount 5  A C X   
CONTSTYLE  195  Integer  Project Style  A C X  List: 3 entries
0=
1=Standard
2=Basic
PROJTYPE  196  Integer  Project Type  A C X  List: 4 entries
0=
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  197  Integer  Accounting Method  A C X  List: 9 entries
0=
1=Completed Project
2=Total Cost Percentage Complete
3=Labor Hours Percentage Complete
4=Billings and Costs
5=Project Percentage Complete
6=Category Percentage Complete
7=Completed Contract
8=Accrual-Basis
UFMTCONTNO  198  String*16  Unformatted Contract Code  A C X  Mask: %-16C
TARAMOUNT1  199  BCD*10.3  Tax Reporting Amount 1  A X   
TARAMOUNT2  200  BCD*10.3  Tax Reporting Amount 2  A X   
TARAMOUNT3  201  BCD*10.3  Tax Reporting Amount 3  A X   
TARAMOUNT4  202  BCD*10.3  Tax Reporting Amount 4  A X   
TARAMOUNT5  203  BCD*10.3  Tax Reporting Amount 5  A X   
TRALLOAMT1  204  BCD*10.3  Tax Reporting Allocated Amount 1  A X   
TRALLOAMT2  205  BCD*10.3  Tax Reporting Allocated Amount 2  A X   
TRALLOAMT3  206  BCD*10.3  Tax Reporting Allocated Amount 3  A X   
TRALLOAMT4  207  BCD*10.3  Tax Reporting Allocated Amount 4  A X   
TRALLOAMT5  208  BCD*10.3  Tax Reporting Allocated Amount 5  A X   
TRRECVAMT1  209  BCD*10.3  Tax Reporting Recoverable Amt. 1  A X   
TRRECVAMT2  210  BCD*10.3  Tax Reporting Recoverable Amt. 2  A X   
TRRECVAMT3  211  BCD*10.3  Tax Reporting Recoverable Amt. 3  A X   
TRRECVAMT4  212  BCD*10.3  Tax Reporting Recoverable Amt. 4  A X   
TRRECVAMT5  213  BCD*10.3  Tax Reporting Recoverable Amt. 5  A X   
TREXPSAMT1  214  BCD*10.3  Tax Reporting Expense Amount 1  A X   
TREXPSAMT2  215  BCD*10.3  Tax Reporting Expense Amount 2  A X   
TREXPSAMT3  216  BCD*10.3  Tax Reporting Expense Amount 3  A X   
TREXPSAMT4  217  BCD*10.3  Tax Reporting Expense Amount 4  A X   
TREXPSAMT5  218  BCD*10.3  Tax Reporting Expense Amount 5  A X   
TRINCLUDE1  219  BCD*10.3  Tax Reporting Included Amount 1  A X   
TRINCLUDE2  220  BCD*10.3  Tax Reporting Included Amount 2  A X   
TRINCLUDE3  221  BCD*10.3  Tax Reporting Included Amount 3  A X   
TRINCLUDE4  222  BCD*10.3  Tax Reporting Included Amount 4  A X   
TRINCLUDE5  223  BCD*10.3  Tax Reporting Included Amount 5  A X   
TREXCLUDE1  224  BCD*10.3  Tax Reporting Excluded Amount 1  A X   
TREXCLUDE2  225  BCD*10.3  Tax Reporting Excluded Amount 2  A X   
TREXCLUDE3  226  BCD*10.3  Tax Reporting Excluded Amount 3  A X   
TREXCLUDE4  227  BCD*10.3  Tax Reporting Excluded Amount 4  A X   
TREXCLUDE5  228  BCD*10.3  Tax Reporting Excluded Amount 5  A X   
TARAMOUNT  229  BCD*10.3  Tax Reporting Total Amount  A X   
TRINCLUDED  230  BCD*10.3  Tax Reporting Included Amount  A X   
TREXCLUDED  231  BCD*10.3  Tax Reporting Excluded Amount  A X   
TRRECVAMT  232  BCD*10.3  Tax Reporting Recoverable Amount  A X   
TREXPSAMT  233  BCD*10.3  Tax Reporting Expensed Amount  A X   
TRALLOAMT  234  BCD*10.3  Tax Reporting Allocated Amount  A X   
UCISMANUAL  235  Boolean  Unit Cost is Manual  A X  List: 2 entries
0=No
1=Yes
WEIGHTUNIT  236  String*10  Weight Unit of Measure  A X   
WEIGHTCONV  237  BCD*10.6  Weight Conversion  A C X   
DEFUWEIGHT  238  BCD*10.4  Default Unit Weight  A C X   
DEFEXTWGHT  239  BCD*10.4  Default Extended Weight  A C X   
BILLRATECV  240  BCD*10.6  Billing Rate Conversion Factor  A C X   
UNITBILLSR  241  BCD*10.6  Unit Billing Amount  A C X   
EXTBILLSR  242  BCD*10.3  Extended Billing Amount  A X   
COPYDETAIL  243  Boolean  Copy This Detail Line?  A X  List: 2 entries
0=No
1=Yes
DETAILNUM  244  Integer  Detail Number  A C X   

This page was generated on 2009-Nov-19

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