Table: Invoice Details

Table: OEINVD
View: OE0400
Record Length: 1588

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: 166

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 Invoice Unit of Measure 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
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
SERIALQTY Long Serial Quantity
LOTQTY BCD*10.4 Lot Quantity
SLITEM Integer Item Serialized/Lotted? List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
COMPANYID Long Sage CRM Company ID
OPPOID Long Sage CRM Opportunity ID
EDN String*30 Export Declaration Number

This page was generated on 2023-Aug-31

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