View: Invoice Details

RotoID: OE0400
Table: OEINVD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:OEINVD

Compositions: 6

RotoID Tables 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
OE0407 OEINVDS Invoice Detail Serial Numbers OEINVDS
OE0406 OEINVDL Invoice Detail Lot Numbers OEINVDL

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

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 P X  Mask: %-24C
MISCCHARGE 5 String*6 Miscellaneous Charges Code E A X  Mask: %-6N
DESC 6 String*60 Description E A X 
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 Invoice Unit of Measure 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 X 
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 C X 
EXTINVMISC 40 BCD*10.3 Extended Shipped Price/Misc. Charges Amount 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 
DETAILNUM 76 Integer Detail Number E A 
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 C 
TAUTH2DESC 83 String*60 Tax Authority 2 Description E A C 
TAUTH3DESC 84 String*60 Tax Authority 3 Description E A C 
TAUTH4DESC 85 String*60 Tax Authority 4 Description E A C 
TAUTH5DESC 86 String*60 Tax Authority 5 Description E A C 
TCLAS1DESC 87 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 88 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 89 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 90 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 91 String*60 Tax Class 5 Description E A C 
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  Mask: %-24C
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:17 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
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 List of Existing Serials/Lots
31 = Post Serials/Lots to IC Inventory
32 = Verify Serials/Lots
EPOSPROMID 139 Integer ePOS Promotion ID E A 
TERMDISCBL 140 Integer Subject to Payment Discount 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 Tax 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 
COG 167 BCD*10.3 Cost of Goods E A C 
COSTED 168 Boolean Record Costed E A C  List:2 entries
0 = No
1 = Yes
JOBRELATED 169 Boolean Job Related E A C 
CONTRACT 170 String*16 Contract Code E A X  Mask: %-16C
PROJECT 171 String*16 Project Code E A X  Mask: %-16N
CCATEGORY 172 String*16 Category Code E A X  Mask: %-16N
COSTCLASS 173 Integer Cost Class E A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE 174 Integer Project Style E A  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 175 Integer Project Type E A  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 176 Integer Accounting Method E A  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 177 Integer Billing Type E A P  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
REVBILL 178 String*45 Revenue/Billing Account E A X  Mask: %-45C
COGSWIP 179 String*45 COGS/WIP Account E A X  Mask: %-45C
RTGAMOUNT 180 BCD*10.3 Retainage Amount E A C X 
RTGPERCENT 181 BCD*5.5 Retainage Percent E A X 
RTGDAYS 182 Integer Retainage Days E A X 
RTGDATEDUE 183 Date Retainage Due Date E A X 
RTGDDTOVR 184 Boolean Retainage Due Date Override E A C X 
RTGAMTOVR 185 Boolean Retainage Amount Override E A C X 
RTGTXBASE1 186 BCD*10.3 Retainage Tax Base 1 E A 
RTGTXBASE2 187 BCD*10.3 Retainage Tax Base 2 E A 
RTGTXBASE3 188 BCD*10.3 Retainage Tax Base 3 E A 
RTGTXBASE4 189 BCD*10.3 Retainage Tax Base 4 E A 
RTGTXBASE5 190 BCD*10.3 Retainage Tax Base 5 E A 
RTGTXAMT1 191 BCD*10.3 Retainage Tax Amount 1 E A 
RTGTXAMT2 192 BCD*10.3 Retainage Tax Amount 2 E A 
RTGTXAMT3 193 BCD*10.3 Retainage Tax Amount 3 E A 
RTGTXAMT4 194 BCD*10.3 Retainage Tax Amount 4 E A 
RTGTXAMT5 195 BCD*10.3 Retainage Tax Amount 5 E A 
PRICEOPT 196 Integer Default O/E Price E A  List:4 entries
0 =
1 = Billing Rate
2 = Use Customer Price List
3 = Use Specified Price List
LVL1NAME 197 String*30 Level 1 Name A C 
LVL2NAME 198 String*30 Level 2 Name A C 
LVL3NAME 199 String*30 Level 3 Name A C 
UFMTCONTNO 200 String*16 Unformatted Contract Code A C  Mask: %-16C
PAYMNTDIST 201 BCD*10.3 Prepayment Distributed E A X 
NETPRIWTX 202 BCD*10.3 Ext. Price Net of Disc. Inc. Tax E A C 
INVDUE 203 BCD*10.3 Detail Amount Due A C 
SERIALQTY 204 Long Serial Quantity E A C X 
LOTQTY 205 BCD*10.4 Lot Quantity E A C X 
XGENALCQTY 206 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 207 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 208 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 209 String*40 Allocate from Serial E A C 
LALLOCFROM 210 String*40 Allocate from Lot E A C 
SLITEM 211 Integer Item Serialized/Lotted? E A C P  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
METERHWND 212 Long Serial/Lot Window Handle E A C 
COMPANYID 213 Long Sage CRM Company ID E A 
OPPOID 214 Long Sage CRM Opportunity ID E A 
SETCAPPR 215 Boolean Non-interactive Price Approval E A X  List:2 entries
0 = No
1 = Yes
EDN 216 String*30 Export Declaration Number E A X 

This page was generated on 2022-Aug-18

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