Table: Invoice Details

Table: OEINVD
View: OE0400
Record length: 1536
Flags: A R 

Keys: 4

Title  Flags  Fields
Invoice/Line Number  INVUNIQ, LINENUM
Invoice/Detail Number  INVUNIQ, DETAILNUM
Shipment/Shp Dtl/Inv/Inv Dtl  SHINUMBER, SHIDTLNUM, INVUNIQ, DETAILNUM
Order/Ord Dtl/Invoice/Dtl  M  ORDNUMBER, ORDDTLNUM, INVUNIQ, DETAILNUM

Fields: 161

Field  Type  Title  Presentation 
INVUNIQ  BCD*10.0  Invoice Uniquifier   
LINENUM  Integer  Line Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
LINETYPE  Integer  Line Type  List: 2 entries
1=Item
2=Miscellaneous
ITEM  String*24  Item  Mask: %-24C
MISCCHARGE  String*6  Miscellaneous Charges Code  Mask: %-6N
DESC  String*60  Description   
ACCTSET  String*6  Item Account Set  Mask: %-6N
USERCOSTMD  Boolean  User-Specified Costing Method   
PRICELIST  String*6  Price List  Mask: %-6N
CATEGORY  String*6  Category  Mask: %-6N
LOCATION  String*6  Location  Mask: %-6N
PICKSEQ  String*10  Picking Sequence   
EXPDATE  Date  Shipment Date   
STOCKITEM  Boolean  Stock Item   
QTYORDERED  BCD*10.4  Current Quantity Outstanding   
QTYSHIPPED  BCD*10.4  Quantity Shipped   
QTYBACKORD  BCD*10.4  Quantity Backordered   
INVUNIT  String*10  Item Unit  Mask: %-10c
UNITCONV  BCD*10.6  Unit Conversion   
UNITPRICE  BCD*10.6  Unit Price   
PRICEOVER  Boolean  Price Override   
UNITCOST  BCD*10.6  Unit Cost   
MOSTREC  BCD*10.6  Most Recent Unit Cost   
STDCOST  BCD*10.6  Standard Unit Cost   
COST1  BCD*10.6  Alternate Unit Cost 1   
COST2  BCD*10.6  Alternate Unit Cost 2   
UNITPRCDEC  Integer  Unit Price No. of Decimals   
PRICEUNIT  String*10  Pricing Unit  Mask: %-10c
PRIUNTPRC  BCD*10.6  Pricing Unit Price   
PRIUNTCONV  BCD*10.6  Pricing Unit Conversion   
PRIPERCENT  BCD*5.5  Price Discount Percentage   
PRIAMOUNT  BCD*10.3  Price Discount Amount   
BASEUNIT  String*10  Pricing Base Unit  Mask: %-10c
PRIBASPRC  BCD*10.6  Pricing Base Unit Price   
PRIBASCONV  BCD*10.6  Pricing Base Unit Conversion   
COSTUNIT  String*10  Costing Unit  Mask: %-10c
COSUNTCST  BCD*10.6  Costing Unit Cost   
COSUNTCONV  BCD*10.6  Costing Unit Conversion   
EXTICOST  BCD*10.3  Extended Detail Cost   
EXTINVMISC  BCD*10.3  Extended Shipped Price/Misc. Charges Amount   
INVDISC  BCD*10.3  Invoice Discount Amount   
EXTOVER  Boolean  Extended Amount Override   
UNITWEIGHT  BCD*10.4  Unit Weight   
EXTWEIGHT  BCD*10.4  Extended Weight   
TAUTH1  String*12  Tax Authority 1  Mask: %-12N
TAUTH2  String*12  Tax Authority 2  Mask: %-12N
TAUTH3  String*12  Tax Authority 3  Mask: %-12N
TAUTH4  String*12  Tax Authority 4  Mask: %-12N
TAUTH5  String*12  Tax Authority 5  Mask: %-12N
TCLASS1  Integer  Tax Class 1   
TCLASS2  Integer  Tax Class 2   
TCLASS3  Integer  Tax Class 3   
TCLASS4  Integer  Tax Class 4   
TCLASS5  Integer  Tax Class 5   
TINCLUDED1  Boolean  Tax Included 1   
TINCLUDED2  Boolean  Tax Included 2   
TINCLUDED3  Boolean  Tax Included 3   
TINCLUDED4  Boolean  Tax Included 4   
TINCLUDED5  Boolean  Tax Included 5   
TBASE1  BCD*10.3  Tax Base 1   
TBASE2  BCD*10.3  Tax Base 2   
TBASE3  BCD*10.3  Tax Base 3   
TBASE4  BCD*10.3  Tax Base 4   
TBASE5  BCD*10.3  Tax Base 5   
TAMOUNT1  BCD*10.3  Tax Amount 1   
TAMOUNT2  BCD*10.3  Tax Amount 2   
TAMOUNT3  BCD*10.3  Tax Amount 3   
TAMOUNT4  BCD*10.3  Tax Amount 4   
TAMOUNT5  BCD*10.3  Tax Amount 5   
TRATE1  BCD*8.5  Tax Rate 1   
TRATE2  BCD*8.5  Tax Rate 2   
TRATE3  BCD*8.5  Tax Rate 3   
TRATE4  BCD*8.5  Tax Rate 4   
TRATE5  BCD*8.5  Tax Rate 5   
DETAILNUM  Integer  Detail Number   
HAVESERIAL  Boolean  Have Serial Numbers for Item  List: 2 entries
0=No
1=Yes
COMMINST  Boolean  Have Comments/Instructions  List: 2 entries
0=No
1=Yes
GLNONSTKCR  String*45  Non-stock Clearing Account  Mask: %-45C
AVGCOST  BCD*10.6  Average Unit Cost   
LASTCOST  BCD*10.6  Last Unit Cost   
SHINUMBER  String*22  Shipment Number  Mask: %-22C
SHIDTLNUM  Integer  Shipment Detail Line Number   
SHIPTRACK  String*36  Shipment Tracking Number   
SHIPVIA  String*6  Ship-Via Code  Mask: %-6N
VIADESC  String*60  Ship-Via Code Description   
DISCPER  BCD*5.5  Discount Percent   
ORDQTYORD  BCD*10.4  Order Quantity Ordered   
ORDQTYBKOR  BCD*10.4  Order Quantity Backordered   
ORDQTYCOMM  BCD*10.4  Order Quantity Committed   
ORDQTYTCOM  BCD*10.4  Order Quantity True Committed   
ORDQTYSTD  BCD*10.4  Order Quantity Shipped-to-date   
ORDUNIT  String*10  Order Unit of Measure   
ORDUNITCON  BCD*10.6  Order Unit Conversion   
MANITEMNO  String*24  Manufacturer's Item Number  Mask: %-24C
CUSTITEMNO  String*24  Customer Item Number  Mask: %-24C
QTYCOMMIT  BCD*10.4  Quantity Committed   
QTYTRUECOM  BCD*10.4  Quantity True Committed   
ORDNUMBER  String*22  Order Number  Mask: %-22C
ORDDTLNUM  Integer  Order Detail Number   
REFRESH  Boolean  Refresh Order Qty. at Update  List: 2 entries
0=No
1=Yes
ORIGQTYSHP  BCD*10.4  Original Quantity shipped   
VALUES  Long  Optional Fields   
DDTLTYPE  Integer  Kitting/BOM  List: 3 entries
0=None
1=Kitting
2=BOM
DDTLNO  String*6  Kit/BOM Number  Mask: %-6N
BUILDQTY  BCD*10.4  BOM Build Qty.   
BUILDUNIT  String*10  BOM Build Unit  Mask: %-10c
BLDUNTCONV  BCD*10.6  BOM Build Unit Conversion   
EPOSPROMID  Integer  ePOS Promotion ID   
TERMDISCBL  Integer  Subject to Payment Discount  List: 2 entries
0=No
1=Yes
BASEWUNIT  String*10  Pricing Base Weight Unit   
WEIGHTUNIT  String*10  Weight Unit of Measure   
WEIGHTCONV  BCD*10.6  Weight Conversion Factor   
PRWGHTUNIT  String*10  Pricing Weight UOM   
PRWGHTCONV  BCD*10.6  Pricing Weight Conversion Factor   
PRIBASWCNV  BCD*10.6  Pricing Base Weight Conv. Factor   
DEFUWEIGHT  BCD*10.4  Def. Weight UOM Unit Weight   
DEFEXTWGHT  BCD*10.4  Def. Weight UOM Ext. Unit Weight   
PRPRICEBY  Integer  Price By  List: 2 entries
1=Quantity
2=Weight
NEEDPCHECK  Boolean  Price Check Pending   
CAPPROVEBY  String*8  Price Approved By  Mask: %-8N
HDRDISC  BCD*10.3  Header Discount   
ITRAMOUNT1  BCD*10.3  TR Tax Amount 1   
ITRAMOUNT2  BCD*10.3  TR Tax Amount 2   
ITRAMOUNT3  BCD*10.3  TR Tax Amount 3   
ITRAMOUNT4  BCD*10.3  TR Tax Amount 4   
ITRAMOUNT5  BCD*10.3  TR Tax Amount 5   
COG  BCD*10.3  Cost of Goods   
COSTED  Boolean  Record Costed  List: 2 entries
0=No
1=Yes
JOBRELATED  Boolean  Job Related   
CONTRACT  String*16  Contract Code  Mask: %-16C
PROJECT  String*16  Project Code  Mask: %-16N
CCATEGORY  String*16  Category Code  Mask: %-16N
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
PROJSTYLE  Integer  Project Style  List: 3 entries
0=
1=Standard
2=Basic
PROJTYPE  Integer  Project Type  List: 4 entries
0=
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  Integer  Accounting Method  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
BILLTYPE  Integer  Billing Type  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
REVBILL  String*45  Revenue/Billing Account  Mask: %-45C
COGSWIP  String*45  COGS/WIP Account  Mask: %-45C
RTGAMOUNT  BCD*10.3  Retainage Amount   
RTGPERCENT  BCD*5.5  Retainage Percent   
RTGDAYS  Integer  Retainage Days   
RTGDATEDUE  Date  Retainage Due Date   
RTGDDTOVR  Boolean  Retainage Due Date Override   
RTGAMTOVR  Boolean  Retainage Amount Override   
RTGTXBASE1  BCD*10.3  Retainage Tax Base 1   
RTGTXBASE2  BCD*10.3  Retainage Tax Base 2   
RTGTXBASE3  BCD*10.3  Retainage Tax Base 3   
RTGTXBASE4  BCD*10.3  Retainage Tax Base 4   
RTGTXBASE5  BCD*10.3  Retainage Tax Base 5   
RTGTXAMT1  BCD*10.3  Retainage Tax Amount 1   
RTGTXAMT2  BCD*10.3  Retainage Tax Amount 2   
RTGTXAMT3  BCD*10.3  Retainage Tax Amount 3   
RTGTXAMT4  BCD*10.3  Retainage Tax Amount 4   
RTGTXAMT5  BCD*10.3  Retainage Tax Amount 5   
PRICEOPT  Integer  Default O/E Price  List: 4 entries
0=
1=Billing Rate
2=Use Customer Price List
3=Use Specified Price List
PAYMNTDIST  BCD*10.3  Prepayment Distributed   

This page was generated on 2008-May-01

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