View: Credit/Debit Details

RotoID: OE0220
Table: OECRDD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:OECRDD

Compositions: 6

RotoID Tables Title DLL
OE0240 OECRDH Credit/Debit Notes OECRDH
OE0221 OECRDDO Credit/Debit Detail Opt. Fields OECRDDO
OE0223 OECRDDB Credit/Debit BOM Details OECRDDB
OE0222 OECRDDD Credit/Debit Kitting Details OECRDDD
OE0227 OECRDDS Credit/Debit Detail Serial Nos OECRDDS
OE0226 OECRDDL Credit/Debit Detail Lot Numbers OECRDDL

Keys: 2

Title Fields
Number/Line Number CRDUNIQ, LINENUM
Number/Detail Number CRDUNIQ, DETAILNUM

Fields: 210

Field Index Type Title Attributes Presentation
CRDUNIQ 1 BCD*10.0 CN Uniquifier E A K R 
LINENUM 2 Integer Line Number E A K R 
LINETYPE 3 Integer Line Type E A P  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 A X  Mask: %-6N
DESC 6 String*60 Description A X 
ACCTSET 7 String*6 Item Account Set A X  Mask: %-6N
USERCOSTMD 8 Boolean User-Specified Costing Method A X 
PRICELIST 9 String*6 Price List A X  Mask: %-6N
CATEGORY 10 String*6 Category A X  Mask: %-6N
LOCATION 11 String*6 Location A X  Mask: %-6N
PICKSEQ 12 String*10 Picking Sequence A X 
STOCKITEM 13 Boolean Stock Item A X 
QTYRETURN 14 BCD*10.4 Quantity Returned A X 
QTYSHIPPED 15 BCD*10.4 Quantity Shipped A 
QTYBACKORD 16 BCD*10.4 Quantity Backordered A 
CRDUNIT 17 String*10 Credit/Debit Note UOM A X  Mask: %-10c
UNITCONV 18 BCD*10.6 Unit Conversion A 
UNITPRICE 19 BCD*10.6 Unit Price A 
PRICEOVER 20 Boolean Price Override A 
UNITCOST 21 BCD*10.6 Unit Cost A 
MOSTREC 22 BCD*10.6 Most Recent Unit Cost A 
STDCOST 23 BCD*10.6 Standard Unit Cost A 
COST1 24 BCD*10.6 Alternate Unit Cost 1 A 
COST2 25 BCD*10.6 Alternate Unit Cost 2 A 
UNITPRCDEC 26 Integer Unit Price No. of Decimals A 
PRICEUNIT 27 String*10 Pricing Unit A  Mask: %-10c
PRIUNTPRC 28 BCD*10.6 Pricing Unit Price A X 
PRIUNTCONV 29 BCD*10.6 Pricing Unit Conversion A 
PRIPERCENT 30 BCD*5.5 Price Discount Percentage A 
PRIAMOUNT 31 BCD*10.3 Price Discount Amount A 
BASEUNIT 32 String*10 Pricing Base Unit A  Mask: %-10c
PRIBASPRC 33 BCD*10.6 Pricing Base Unit Price A 
PRIBASCONV 34 BCD*10.6 Pricing Base Unit Conversion A 
COSTUNIT 35 String*10 Costing Unit A  Mask: %-10c
COSUNTCST 36 BCD*10.6 Costing Unit Cost A X 
COSUNTCONV 37 BCD*10.6 Costing Unit Conversion A 
EXTCCOST 38 BCD*10.3 Extended Detail Cost A X 
EXTCRDMISC 39 BCD*10.3 Extended Amount/Misc. Charge A X 
CRDDISC 40 BCD*10.3 Credit Note Discount Amount A X 
EXTOVER 41 Boolean Extended Amount Override A 
EXTICOST 42 BCD*10.3 Invoice Extended Cost A 
UNITWEIGHT 43 BCD*10.4 Unit Weight A X 
EXTWEIGHT 44 BCD*10.4 Extended Weight A X 
RETURNTYPE 45 Integer Return Type E A P X  List:3 entries
1 = Items Returned to Inventory
2 = Damaged Items
3 = Price Adjustment
TAUTH1 46 String*12 Tax Authority 1 A  Mask: %-12N
TAUTH2 47 String*12 Tax Authority 2 A  Mask: %-12N
TAUTH3 48 String*12 Tax Authority 3 A  Mask: %-12N
TAUTH4 49 String*12 Tax Authority 4 A  Mask: %-12N
TAUTH5 50 String*12 Tax Authority 5 A  Mask: %-12N
TCLASS1 51 Integer Tax Class 1 A X 
TCLASS2 52 Integer Tax Class 2 A X 
TCLASS3 53 Integer Tax Class 3 A X 
TCLASS4 54 Integer Tax Class 4 A X 
TCLASS5 55 Integer Tax Class 5 A X 
TINCLUDED1 56 Boolean Tax Included 1 A X 
TINCLUDED2 57 Boolean Tax Included 2 A X 
TINCLUDED3 58 Boolean Tax Included 3 A X 
TINCLUDED4 59 Boolean Tax Included 4 A X 
TINCLUDED5 60 Boolean Tax Included 5 A X 
TBASE1 61 BCD*10.3 Tax Base 1 A X 
TBASE2 62 BCD*10.3 Tax Base 2 A X 
TBASE3 63 BCD*10.3 Tax Base 3 A X 
TBASE4 64 BCD*10.3 Tax Base 4 A X 
TBASE5 65 BCD*10.3 Tax Base 5 A X 
TAMOUNT1 66 BCD*10.3 Tax Amount 1 A X 
TAMOUNT2 67 BCD*10.3 Tax Amount 2 A X 
TAMOUNT3 68 BCD*10.3 Tax Amount 3 A X 
TAMOUNT4 69 BCD*10.3 Tax Amount 4 A X 
TAMOUNT5 70 BCD*10.3 Tax Amount 5 A X 
TRATE1 71 BCD*8.5 Tax Rate 1 A 
TRATE2 72 BCD*8.5 Tax Rate 2 A 
TRATE3 73 BCD*8.5 Tax Rate 3 A 
TRATE4 74 BCD*8.5 Tax Rate 4 A 
TRATE5 75 BCD*8.5 Tax Rate 5 A 
DETAILNUM 77 Integer Detail Number E A 
COMMINST 79 Boolean Have Comments/Instructions A X  List:2 entries
0 = No
1 = Yes
EXTCMOSTRE 80 BCD*10.3 Total CR Most Recent Cost A 
EXTCSTDCOS 81 BCD*10.3 Total CR Standard Cost A 
EXTCCOST1 82 BCD*10.3 Total CR Cost 1 A 
EXTCCOST2 83 BCD*10.3 Total CR Cost 2 A 
PCODDESC 84 String*60 Price List Description A 
CATGDESC 85 String*60 Category Description A 
LOCDESC 86 String*60 Location Description A 
TAUTH1DESC 87 String*60 Tax Authority 1 Description A 
TAUTH2DESC 88 String*60 Tax Authority 2 Description A 
TAUTH3DESC 89 String*60 Tax Authority 3 Description A 
TAUTH4DESC 90 String*60 Tax Authority 4 Description A 
TAUTH5DESC 91 String*60 Tax Authority 5 Description A 
TCLAS1DESC 92 String*60 Tax Class 1 Description A 
TCLAS2DESC 93 String*60 Tax Class 2 Description A 
TCLAS3DESC 94 String*60 Tax Class 3 Description A 
TCLAS4DESC 95 String*60 Tax Class 4 Description A 
TCLAS5DESC 96 String*60 Tax Class 5 Description A 
DRIVENBYUI 97 Boolean Driven by UI E A 
NEGINVENT 98 Boolean Found Negative Inventory A 
GLNONSTKCR 99 String*45 Non-stock Clearing Account A X  Mask: %-45C
GLNONSTKCD 100 String*60 Non-stock Clearing Acct. Desc. A 
IPCID 101 Long Inter-process Comm. ID A 
FORCEPOPSN 102 Boolean Force Pop-up SN A  List:2 entries
0 = No
1 = Yes
POPUPSN 103 Integer Pop-up SN A  List:2 entries
0 = No
1 = Yes
CLOSESN 104 Boolean Close SN A  List:2 entries
0 = No
1 = Yes
LTSETID 105 Long LT Set ID A 
FORCEPOPLT 106 Boolean Force Pop-up LT A  List:2 entries
0 = No
1 = Yes
POPUPLT 107 Integer Pop-up LT A  List:2 entries
0 = No
1 = Yes
CLOSELT 108 Boolean Close LT A  List:2 entries
0 = No
1 = Yes
AVGCOST 109 BCD*10.6 Average Unit Cost A 
LASTCOST 110 BCD*10.6 Last Unit Cost A 
EXTCAVGCST 111 BCD*10.3 Total CR Average Cost A 
EXTCLSTCST 112 BCD*10.3 Total CR Last Cost A 
SHIPTRACK 113 String*36 Shipment Tracking Number A X 
SHIPVIA 114 String*6 Ship-Via Code A X  Mask: %-6N
VIADESC 115 String*60 Ship-Via Code Description A X 
DISCPER 116 BCD*5.5 Discount Percent A X 
EDCCRDMISC 117 BCD*10.3 Extended Discounted Price A 
EXPDATE 118 Date Shipment Date A 
QTYORDERED 119 BCD*10.4 Invoice Current Qty. Outstanding A 
INVUNIT 120 String*10 Invoice Unit of Measure A 
INVUNITCON 121 BCD*10.6 Invoice Unit Conversion A 
ORDQTYORD 122 BCD*10.4 Order Quantity Ordered A 
ORDQTYBKOR 123 BCD*10.4 Order Quantity Backordered A 
ORDQTYCOMM 124 BCD*10.4 Order Quantity Committed A 
ORDQTYSTD 125 BCD*10.4 Order Quantity Shipped-to-date A 
ORDUNIT 126 String*10 Order Unit of Measure A 
ORDUNITCON 127 BCD*10.6 Order Unit Conversion A 
MANITEMNO 128 String*24 Manufacturer's Item Number A X  Mask: %-24C
CUSTITEMNO 129 String*24 Customer Item Number A X  Mask: %-24C
SHINUMBER 130 String*22 Invoice's Shipment Number A 
SHIDTLNUM 131 Integer Invoice's Shipment Detail Number A 
VALUES 132 Long Optional Fields A 
DDTLTYPE 133 Integer Kitting/BOM A  List:3 entries
0 = None
1 = Kitting
2 = BOM
DDTLNO 134 String*6 Kit/BOM Number A X  Mask: %-6N
BUILDQTY 135 BCD*10.4 BOM Build Qty. A 
BUILDUNIT 136 String*10 BOM Build Unit A  Mask: %-10c
BLDUNTCONV 137 BCD*10.6 BOM Build Unit Conversion A 
UNFMTITEM 138 String*24 Unformatted Item Number A  Mask: %-24C
INVNUMBER 139 String*22 Invoice Number A  Mask: %-22C
INVUNIQ 140 BCD*10.0 Invoice Uniquifier A 
INVLINENUM 141 Integer Invoice Line Number A 
PROCESSCMD 142 Integer Process Command A  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
NEXTCMPNUM 143 Long Next Component Number E A C 
EPOSPROMID 144 Integer ePOS Promotion ID A 
BASEWUNIT 145 String*10 Pricing Base Weight Unit A 
WEIGHTUNIT 146 String*10 Weight Unit of Measure A X 
WEIGHTCONV 147 BCD*10.6 Weight Conversion Factor A 
PRWGHTUNIT 148 String*10 Pricing Weight UOM A X 
PRWGHTCONV 149 BCD*10.6 Pricing Weight Conversion Factor A 
PRIBASWCNV 150 BCD*10.6 Pricing Base Weight Conv. Factor A 
DEFUWEIGHT 151 BCD*10.4 Def. Weight UOM Unit Weight A 
DEFEXTWGHT 152 BCD*10.4 Def. Weight UOM Ext. Unit Weight A 
PRPRICEBY 153 Integer Price By A  List:2 entries
1 = Quantity
2 = Weight
NEEDPCHECK 154 Boolean Price Check Pending A X 
CAPPROVEBY 155 String*8 Price Approved By A X  Mask: %-8N
CAPPRPWORD 156 String*64 Approving User's Password A X 
NEEDCAPP 157 Boolean Price Approval Needed A  List:2 entries
0 = No
1 = Yes
WUOMDESC 158 String*60 Weight UOM Description A 
HDRDISC 159 BCD*10.3 Header Discount A 
CTRAMOUNT1 160 BCD*10.3 TR Tax Amount 1 A X 
CTRAMOUNT2 161 BCD*10.3 TR Tax Amount 2 A X 
CTRAMOUNT3 162 BCD*10.3 TR Tax Amount 3 A X 
CTRAMOUNT4 163 BCD*10.3 TR Tax Amount 4 A X 
CTRAMOUNT5 164 BCD*10.3 TR Tax Amount 5 A X 
EXTNETPRI 165 BCD*10.3 Extended Amount Net of Tax A 
DISCRDMISC 166 BCD*10.3 Discounted Extended Amount A 
TAXTOTAL 167 BCD*10.3 Tax Total A 
CTRTOTAL 168 BCD*10.3 TR Tax Total A 
COG 169 BCD*10.3 Cost of Goods A 
COSTED 170 Boolean Record Costed A  List:2 entries
0 = No
1 = Yes
JOBRELATED 171 Boolean Job Related A 
CONTRACT 172 String*16 Contract Code A X  Mask: %-16C
PROJECT 173 String*16 Project Code A X  Mask: %-16N
CCATEGORY 174 String*16 Category Code A X  Mask: %-16N
COSTCLASS 175 Integer Cost Class A X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE 176 Integer Project Style A  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 177 Integer Project Type A  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 178 Integer Accounting Method 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 179 Integer Billing Type A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
REVBILL 180 String*45 Revenue/Billing Account A X  Mask: %-45C
COGSWIP 181 String*45 COGS/WIP Account A X  Mask: %-45C
RTGAMOUNT 182 BCD*10.3 Retainage Amount A X 
RTGPERCENT 183 BCD*5.5 Retainage Percent A X 
RTGDAYS 184 Integer Retainage Days A X 
RTGDATEDUE 185 Date Retainage Due Date A X 
RTGDDTOVR 186 Boolean Retainage Due Date Override A X 
RTGAMTOVR 187 Boolean Retainage Amount Override A X 
RTGTXBASE1 188 BCD*10.3 Retainage Tax Base 1 A 
RTGTXBASE2 189 BCD*10.3 Retainage Tax Base 2 A 
RTGTXBASE3 190 BCD*10.3 Retainage Tax Base 3 A 
RTGTXBASE4 191 BCD*10.3 Retainage Tax Base 4 A 
RTGTXBASE5 192 BCD*10.3 Retainage Tax Base 5 A 
RTGTXAMT1 193 BCD*10.3 Retainage Tax Amount 1 A 
RTGTXAMT2 194 BCD*10.3 Retainage Tax Amount 2 A 
RTGTXAMT3 195 BCD*10.3 Retainage Tax Amount 3 A 
RTGTXAMT4 196 BCD*10.3 Retainage Tax Amount 4 A 
RTGTXAMT5 197 BCD*10.3 Retainage Tax Amount 5 A 
PRICEOPT 198 Integer Default O/E Price A  List:4 entries
0 =
1 = Billing Rate
2 = Use Customer Price List
3 = Use Specified Price List
LVL1NAME 199 String*30 Level 1 Name A 
LVL2NAME 200 String*30 Level 2 Name A 
LVL3NAME 201 String*30 Level 3 Name A 
UFMTCONTNO 202 String*16 Unformatted Contract Code A  Mask: %-16C
SERIALQTY 203 Long Serial Quantity E A C X 
LOTQTY 204 BCD*10.4 Lot Quantity E A C X 
XGENALCQTY 205 BCD*10.4 Serial/Lot Quantity to Process A 
XLOTMAKQTY 206 BCD*10.4 Number of Lots to Generate A 
XPERLOTQTY 207 BCD*10.4 Quantity per Lot A 
SALLOCFROM 208 String*40 Allocate from Serial A 
LALLOCFROM 209 String*40 Allocate from Lot A 
SLITEM 210 Integer Item Serialized/Lotted? A  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
METERHWND 211 Long Serial/Lot Window Handle A 
SETCAPPR 212 Boolean Non-interactive Price Approval A X  List:2 entries
0 = No
1 = Yes

This page was generated on 2021-Nov-24

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