# View: Invoice Details

RotoID: OE0400
Table: OEINVD
DLL: OEINVD

## Compositions: 4

RotoID | Table | Title | DLL
--- | --- | --- | ---
OE0420 | OEINVH | Invoices | OEINVH
OE0401 | OEINVDO | Invoice Detail Optional Fields | OEINVDO
OE0403 | OEINVDB | Invoice BOM Details | OEINVDB
OE0402 | OEINVDD | Invoice Kitting Details | OEINVDD

## Keys: 4

Title | 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 | ORDNUMBER, ORDDTLNUM, INVUNIQ, DETAILNUM

## Fields: 166

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
INVUNIQ | 1 | BCD*10.0 | Invoice Uniquifier | E A K R |
LINENUM | 2 | Integer | Line Uniquifier | E A K R |
LINETYPE | 3 | Integer | Line Type | E A X | List: 2 entries
1 | = | Item
2 | = | Miscellaneous
ITEM | 4 | String*24 | Item | E A | Mask: %-24C
MISCCHARGE | 5 | String*6 | Miscellaneous Charges Code | E A X | Mask: %-6N
DESC | 6 | String*60 | Description | E A |
ACCTSET | 7 | String*6 | Item Account Set | E A | Mask: %-6N
USERCOSTMD | 8 | Boolean | User-Specified Costing Method? | E A |
PRICELIST | 9 | String*6 | Price List | E A | Mask: %-6N
CATEGORY | 10 | String*6 | Category | E A | Mask: %-6N
LOCATION | 11 | String*6 | Location | E A | Mask: %-6N
PICKSEQ | 12 | String*10 | Picking Sequence | E A |
EXPDATE | 13 | Date | Shipment Date | E A |
STOCKITEM | 14 | Boolean | Stock Item | E A |
QTYORDERED | 15 | BCD*10.4 | Current Quantity Outstanding | E A |
QTYSHIPPED | 16 | BCD*10.4 | Quantity Shipped | E A X |
QTYBACKORD | 17 | BCD*10.4 | Quantity Backordered | E A |
INVUNIT | 18 | String*10 | Item Unit | E A | Mask: %-10c
UNITCONV | 19 | BCD*10.6 | Unit Conversion | E A |
UNITPRICE | 20 | BCD*10.6 | Unit Price | E A |
PRICEOVER | 21 | Boolean | Price Override | E A |
UNITCOST | 22 | BCD*10.6 | Unit Cost | E A |
MOSTREC | 23 | BCD*10.6 | Most Recent Unit Cost | E A |
STDCOST | 24 | BCD*10.6 | Standard Unit Cost | E A |
COST1 | 25 | BCD*10.6 | Alternate Unit Cost 1 | E A |
COST2 | 26 | BCD*10.6 | Alternate Unit Cost 2 | E A |
UNITPRCDEC | 27 | Integer | Unit Price No. of Decimals | E A |
PRICEUNIT | 28 | String*10 | Pricing Unit | E A | Mask: %-10c
PRIUNTPRC | 29 | BCD*10.6 | Pricing Unit Price | E A |
PRIUNTCONV | 30 | BCD*10.6 | Pricing Unit Conversion | E A |
PRIPERCENT | 31 | BCD*5.5 | Price Discount Percentage | E A |
PRIAMOUNT | 32 | BCD*10.3 | Price Discount Amount | E A |
BASEUNIT | 33 | String*10 | Pricing Base Unit | E A | Mask: %-10c
PRIBASPRC | 34 | BCD*10.6 | Pricing Base Unit Price | E A |
PRIBASCONV | 35 | BCD*10.6 | Pricing Base Unit Conversion | E A |
COSTUNIT | 36 | String*10 | Costing Unit | E A | Mask: %-10c
COSUNTCST | 37 | BCD*10.6 | Costing Unit Cost | E A X |
COSUNTCONV | 38 | BCD*10.6 | Costing Unit Conversion | E A |
EXTICOST | 39 | BCD*10.3 | Extended Detail Cost | E A |
EXTINVMISC | 40 | BCD*10.3 | Extended Shipped Price/Misc. Cha | E A X |
INVDISC | 41 | BCD*10.3 | Invoice Discount Amount | E A X |
EXTOVER | 42 | Boolean | Extended Amount Override | E A |
UNITWEIGHT | 43 | BCD*10.4 | Unit Weight | E A X |
EXTWEIGHT | 44 | BCD*10.4 | Extended Weight | E A X |
TAUTH1 | 45 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAUTH2 | 46 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAUTH3 | 47 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAUTH4 | 48 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAUTH5 | 49 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TCLASS1 | 50 | Integer | Tax Class 1 | E A X |
TCLASS2 | 51 | Integer | Tax Class 2 | E A X |
TCLASS3 | 52 | Integer | Tax Class 3 | E A X |
TCLASS4 | 53 | Integer | Tax Class 4 | E A X |
TCLASS5 | 54 | Integer | Tax Class 5 | E A X |
TINCLUDED1 | 55 | Boolean | Tax Included 1 | E A X |
TINCLUDED2 | 56 | Boolean | Tax Included 2 | E A X |
TINCLUDED3 | 57 | Boolean | Tax Included 3 | E A X |
TINCLUDED4 | 58 | Boolean | Tax Included 4 | E A X |
TINCLUDED5 | 59 | Boolean | Tax Included 5 | E A X |
TBASE1 | 60 | BCD*10.3 | Tax Base 1 | E A X |
TBASE2 | 61 | BCD*10.3 | Tax Base 2 | E A X |
TBASE3 | 62 | BCD*10.3 | Tax Base 3 | E A X |
TBASE4 | 63 | BCD*10.3 | Tax Base 4 | E A X |
TBASE5 | 64 | BCD*10.3 | Tax Base 5 | E A X |
TAMOUNT1 | 65 | BCD*10.3 | Tax Amount 1 | E A X |
TAMOUNT2 | 66 | BCD*10.3 | Tax Amount 2 | E A X |
TAMOUNT3 | 67 | BCD*10.3 | Tax Amount 3 | E A X |
TAMOUNT4 | 68 | BCD*10.3 | Tax Amount 4 | E A X |
TAMOUNT5 | 69 | BCD*10.3 | Tax Amount 5 | E A X |
TRATE1 | 70 | BCD*8.5 | Tax Rate 1 | E A |
TRATE2 | 71 | BCD*8.5 | Tax Rate 2 | E A |
TRATE3 | 72 | BCD*8.5 | Tax Rate 3 | E A |
TRATE4 | 73 | BCD*8.5 | Tax Rate 4 | E A |
TRATE5 | 74 | BCD*8.5 | Tax Rate 5 | E A |
MISCACCT | 75 | String*45 | Misc. Charges G/L Account | E A | Mask: %-45C
DETAILNUM | 76 | Integer | Detail Number | E A |
HAVESERIAL | 77 | Boolean | Have Serial Numbers for Item | E A X | List: 2 entries
0 | = | No
1 | = | Yes
COMMINST | 78 | Boolean | Have Comments/Instructions | E A X | List: 2 entries
0 | = | No
1 | = | Yes
PCODDESC | 79 | String*60 | Price List Description | E A |
CATGDESC | 80 | String*60 | Category Description | E A |
LOCDESC | 81 | String*60 | Location Description | E A |
TAUTH1DESC | 82 | String*60 | Tax Authority 1 Description | E A |
TAUTH2DESC | 83 | String*60 | Tax Authority 2 Description | E A |
TAUTH3DESC | 84 | String*60 | Tax Authority 3 Description | E A |
TAUTH4DESC | 85 | String*60 | Tax Authority 4 Description | E A |
TAUTH5DESC | 86 | String*60 | Tax Authority 5 Description | E A |
TCLAS1DESC | 87 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 88 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 89 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 90 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 91 | String*60 | Tax Class 5 Description | E A |
GLNONSTKCR | 92 | String*45 | Non-stock Clearing Account | E A X | Mask: %-45C
GLNONSTKCD | 93 | String*60 | Non-stock Clearing Acct. Desc. | E A |
AVGCOST | 94 | BCD*10.6 | Average Unit Cost | E A C |
LASTCOST | 95 | BCD*10.6 | Last Unit Cost | E A C |
SHINUMBER | 96 | String*22 | Shipment Number | E A | Mask: %-22C
SHIDTLNUM | 97 | Integer | Shipment Detail Line Number | E A |
EXTIMOSTRE | 98 | BCD*10.3 | Total Most Recent Cost | A C |
EXTISTDCOS | 99 | BCD*10.3 | Total Standard Cost | A C |
EXTICOST1 | 100 | BCD*10.3 | Total Alternate Cost 1 | A C |
EXTICOST2 | 101 | BCD*10.3 | Total Alternate Cost 2 | A C |
EXTIAVGCST | 102 | BCD*10.3 | Total Average Cost | A C |
EXTILSTCST | 103 | BCD*10.3 | Total Last Cost | A C |
SHIPTRACK | 104 | String*36 | Shipment Tracking Number | E A X |
SHIPVIA | 105 | String*6 | Ship-Via Code | E A X | Mask: %-6N
VIADESC | 106 | String*60 | Ship-Via Code Description | E A X |
DISCPER | 107 | BCD*5.5 | Discount Percent | E A X |
EDCINVMISC | 108 | BCD*10.3 | Extended Discounted Price | A C |
ORDQTYORD | 109 | BCD*10.4 | Order Quantity Ordered | E A C |
ORDQTYBKOR | 110 | BCD*10.4 | Order Quantity Backordered | E A C |
ORDQTYCOMM | 111 | BCD*10.4 | Order Quantity Committed | E A C |
ORDQTYTCOM | 112 | BCD*10.4 | Order Quantity True Committed | E A C |
ORDQTYSTD | 113 | BCD*10.4 | Order Quantity Shipped-to-date | E A C |
ORDUNIT | 114 | String*10 | Order Unit of Measure | E A C |
ORDUNITCON | 115 | BCD*10.6 | Order Unit Conversion | E A C |
MANITEMNO | 116 | String*24 | Manufacturer's Item Number | E A X | Mask: %-24C
CUSTITEMNO | 117 | String*24 | Customer Item Number | E A X |
QTYCOMMIT | 118 | BCD*10.4 | Quantity Committed | E A C |
QTYTRUECOM | 119 | BCD*10.4 | Quantity True Committed | E A |
ORDNUMBER | 120 | String*22 | Order Number | E A | Mask: %-22C
ORDDTLNUM | 121 | Integer | Order Detail Number | E A |
REFRESH | 122 | Boolean | Refresh Order Qty. at Update | E A C | List: 2 entries
0 | = | No
1 | = | Yes
ORIGQTYSHP | 123 | BCD*10.4 | Original Quantity shipped | E A |
DRIVENBYUI | 124 | Boolean | Driven by UI? | E A |
NEGINVENT | 125 | Boolean | Found Negative Inventory? | E A |
ACTION | 126 | Integer | Action | E A |
SHIUNIQ | 127 | BCD*10.0 | Shipment Uniquifier | E A |
ORDDATE | 128 | Date | Order Date | E A |
SHIDATE | 129 | Date | Shipment Date | E A |
VALUES | 130 | Long | Optional Fields | E A C |
DDTLTYPE | 131 | Integer | Kitting/BOM | E A C | List: 3 entries
0 | = | None
1 | = | Kitting
2 | = | BOM
DDTLNO | 132 | String*6 | Kit/BOM Number | E A | Mask: %-6N
BUILDQTY | 133 | BCD*10.4 | BOM Build Qty. | E A C |
BUILDUNIT | 134 | String*10 | BOM Build Unit | E A C | Mask: %-10c
BLDUNTCONV | 135 | BCD*10.6 | BOM Build Unit Conversion | E A C |
UNFMTITEM | 136 | String*24 | Unformatted item number | E A | Mask: %-24C
SHILINENUM | 137 | Integer | Shipment Line Number | E A |
PROCESSCMD | 138 | Integer | Process Command | E A C | List: 6 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
EPOSPROMID | 139 | Integer | ePOS Promotion ID | E A |
TERMDISCBL | 140 | Integer | Detail subject to Payment Discou | E A X | List: 2 entries
0 | = | No
1 | = | Yes
TERMDBWT | 141 | BCD*10.3 | Payment Discount Base With Tax | E A |
TERMDBNT | 142 | BCD*10.3 | Payment Discount Base Without Ta | E A |
BASEWUNIT | 143 | String*10 | Pricing Base Weight Unit | E A C |
WEIGHTUNIT | 144 | String*10 | Weight Unit of Measure | E A X |
WEIGHTCONV | 145 | BCD*10.6 | Weight Conversion Factor | E A C |
PRWGHTUNIT | 146 | String*10 | Pricing Weight UOM | E A X |
PRWGHTCONV | 147 | BCD*10.6 | Pricing Weight Conversion Factor | E A C |
PRIBASWCNV | 148 | BCD*10.6 | Pricing Base Weight Conv. Factor | E A C |
DEFUWEIGHT | 149 | BCD*10.4 | Def. Weight UOM Unit Weight | E A C |
DEFEXTWGHT | 150 | BCD*10.4 | Def. Weight UOM Ext. Unit Weight | E A C |
PRPRICEBY | 151 | Integer | Price By | E A C | List: 2 entries
1 | = | Quantity
2 | = | Weight
NEEDPCHECK | 152 | Boolean | Price Check Pending | E A X |
CAPPROVEBY | 153 | String*8 | Price Approved By | E A X | Mask: %-8N
CAPPRPWORD | 154 | String*64 | Approving User's Password | E A X |
NEEDCAPP | 155 | Boolean | Price Approval Needed | A C | List: 2 entries
0 | = | No
1 | = | Yes
WUOMDESC | 156 | String*60 | Weight UOM Description | A C |
HDRDISC | 157 | BCD*10.3 | Header Discount | E A |
ITRAMOUNT1 | 158 | BCD*10.3 | TR Tax Amount 1 | E A X |
ITRAMOUNT2 | 159 | BCD*10.3 | TR Tax Amount 2 | E A X |
ITRAMOUNT3 | 160 | BCD*10.3 | TR Tax Amount 3 | E A X |
ITRAMOUNT4 | 161 | BCD*10.3 | TR Tax Amount 4 | E A X |
ITRAMOUNT5 | 162 | BCD*10.3 | TR Tax Amount 5 | E A X |
EXTNETPRI | 163 | BCD*10.3 | Extended Amount Net of Tax | E A C |
DISINVMISC | 164 | BCD*10.3 | Discounted Extended Amount | A C |
TAXTOTAL | 165 | BCD*10.3 | Tax Total | E A C |
ITRTOTAL | 166 | BCD*10.3 | TR Tax Total | E A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.