# Table: Invoice Details

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

## Keys: 4

Title | Flags | Fields
--- | --- | ---
|  | INVUNIQ, LINENUM
|  | INVUNIQ, DETAILNUM
|  | SHINUMBER, SHIDTLNUM, INVUNIQ, DETAILNUM
| M | ORDNUMBER, ORDDTLNUM, INVUNIQ, DETAILNUM

## Fields: 163

Field | Type | Title | Presentation
--- | --- | --- | ---
INVUNIQ | BCD*10.0 |  |
LINENUM | Integer |  |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
LINETYPE | Integer |  |
ITEM | String*24 |  |
MISCCHARGE | String*6 |  |
DESC | String*60 |  |
ACCTSET | String*6 |  |
USERCOSTMD | Boolean |  |
PRICELIST | String*6 |  |
CATEGORY | String*6 |  |
LOCATION | String*6 |  |
PICKSEQ | String*10 |  |
EXPDATE | Date |  |
STOCKITEM | Boolean |  |
QTYORDERED | BCD*10.4 |  |
QTYSHIPPED | BCD*10.4 |  |
QTYBACKORD | BCD*10.4 |  |
INVUNIT | String*10 |  |
UNITCONV | BCD*10.6 |  |
UNITPRICE | BCD*10.6 |  |
PRICEOVER | Boolean |  |
UNITCOST | BCD*10.6 |  |
MOSTREC | BCD*10.6 |  |
STDCOST | BCD*10.6 |  |
COST1 | BCD*10.6 |  |
COST2 | BCD*10.6 |  |
UNITPRCDEC | Integer |  |
PRICEUNIT | String*10 |  |
PRIUNTPRC | BCD*10.6 |  |
PRIUNTCONV | BCD*10.6 |  |
PRIPERCENT | BCD*5.5 |  |
PRIAMOUNT | BCD*10.3 |  |
BASEUNIT | String*10 |  |
PRIBASPRC | BCD*10.6 |  |
PRIBASCONV | BCD*10.6 |  |
COSTUNIT | String*10 |  |
COSUNTCST | BCD*10.6 |  |
COSUNTCONV | BCD*10.6 |  |
EXTICOST | BCD*10.3 |  |
EXTINVMISC | BCD*10.3 |  |
INVDISC | BCD*10.3 |  |
EXTOVER | Boolean |  |
UNITWEIGHT | BCD*10.4 |  |
EXTWEIGHT | BCD*10.4 |  |
TAUTH1 | String*12 |  |
TAUTH2 | String*12 |  |
TAUTH3 | String*12 |  |
TAUTH4 | String*12 |  |
TAUTH5 | String*12 |  |
TCLASS1 | Integer |  |
TCLASS2 | Integer |  |
TCLASS3 | Integer |  |
TCLASS4 | Integer |  |
TCLASS5 | Integer |  |
TINCLUDED1 | Boolean |  |
TINCLUDED2 | Boolean |  |
TINCLUDED3 | Boolean |  |
TINCLUDED4 | Boolean |  |
TINCLUDED5 | Boolean |  |
TBASE1 | BCD*10.3 |  |
TBASE2 | BCD*10.3 |  |
TBASE3 | BCD*10.3 |  |
TBASE4 | BCD*10.3 |  |
TBASE5 | BCD*10.3 |  |
TAMOUNT1 | BCD*10.3 |  |
TAMOUNT2 | BCD*10.3 |  |
TAMOUNT3 | BCD*10.3 |  |
TAMOUNT4 | BCD*10.3 |  |
TAMOUNT5 | BCD*10.3 |  |
TRATE1 | BCD*8.5 |  |
TRATE2 | BCD*8.5 |  |
TRATE3 | BCD*8.5 |  |
TRATE4 | BCD*8.5 |  |
TRATE5 | BCD*8.5 |  |
DETAILNUM | Integer |  |
COMMINST | Boolean |  |
GLNONSTKCR | String*45 |  |
AVGCOST | BCD*10.6 |  |
LASTCOST | BCD*10.6 |  |
SHINUMBER | String*22 |  |
SHIDTLNUM | Integer |  |
SHIPTRACK | String*36 |  |
SHIPVIA | String*6 |  |
VIADESC | String*60 |  |
DISCPER | BCD*5.5 |  |
ORDQTYORD | BCD*10.4 |  |
ORDQTYBKOR | BCD*10.4 |  |
ORDQTYCOMM | BCD*10.4 |  |
ORDQTYTCOM | BCD*10.4 |  |
ORDQTYSTD | BCD*10.4 |  |
ORDUNIT | String*10 |  |
ORDUNITCON | BCD*10.6 |  |
MANITEMNO | String*24 |  |
CUSTITEMNO | String*24 |  |
QTYCOMMIT | BCD*10.4 |  |
QTYTRUECOM | BCD*10.4 |  |
ORDNUMBER | String*22 |  |
ORDDTLNUM | Integer |  |
REFRESH | Boolean |  |
ORIGQTYSHP | BCD*10.4 |  |
VALUES | Long |  |
DDTLTYPE | Integer |  |
DDTLNO | String*6 |  |
BUILDQTY | BCD*10.4 |  |
BUILDUNIT | String*10 |  |
BLDUNTCONV | BCD*10.6 |  |
EPOSPROMID | Integer |  |
TERMDISCBL | Integer |  |
BASEWUNIT | String*10 |  |
WEIGHTUNIT | String*10 |  |
WEIGHTCONV | BCD*10.6 |  |
PRWGHTUNIT | String*10 |  |
PRWGHTCONV | BCD*10.6 |  |
PRIBASWCNV | BCD*10.6 |  |
DEFUWEIGHT | BCD*10.4 |  |
DEFEXTWGHT | BCD*10.4 |  |
PRPRICEBY | Integer |  |
NEEDPCHECK | Boolean |  |
CAPPROVEBY | String*8 |  |
HDRDISC | BCD*10.3 |  |
ITRAMOUNT1 | BCD*10.3 |  |
ITRAMOUNT2 | BCD*10.3 |  |
ITRAMOUNT3 | BCD*10.3 |  |
ITRAMOUNT4 | BCD*10.3 |  |
ITRAMOUNT5 | BCD*10.3 |  |
COG | BCD*10.3 |  |
COSTED | Boolean |  |
JOBRELATED | Boolean |  |
CONTRACT | String*16 |  |
PROJECT | String*16 |  |
CCATEGORY | String*16 |  |
COSTCLASS | Integer |  |
PROJSTYLE | Integer |  |
PROJTYPE | Integer |  |
REVREC | Integer |  |
BILLTYPE | Integer |  |
REVBILL | String*45 |  |
COGSWIP | String*45 |  |
RTGAMOUNT | BCD*10.3 |  |
RTGPERCENT | BCD*5.5 |  |
RTGDAYS | Integer |  |
RTGDATEDUE | Date |  |
RTGDDTOVR | Boolean |  |
RTGAMTOVR | Boolean |  |
RTGTXBASE1 | BCD*10.3 |  |
RTGTXBASE2 | BCD*10.3 |  |
RTGTXBASE3 | BCD*10.3 |  |
RTGTXBASE4 | BCD*10.3 |  |
RTGTXBASE5 | BCD*10.3 |  |
RTGTXAMT1 | BCD*10.3 |  |
RTGTXAMT2 | BCD*10.3 |  |
RTGTXAMT3 | BCD*10.3 |  |
RTGTXAMT4 | BCD*10.3 |  |
RTGTXAMT5 | BCD*10.3 |  |
PRICEOPT | Integer |  |
PAYMNTDIST | BCD*10.3 |  |
SERIALQTY | Long |  |
LOTQTY | BCD*10.4 |  |
SLITEM | Integer |  |

This page was generated on 2009-Nov-19

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