# View: Credit/Debit Details

RotoID: OE0220
Tables: OECRDD
DLL: OECRDD

## Compositions: 4

RotoID | Title | Tables | DLL
--- | --- | --- | ---
OE0240 | Credit/Debit Notes | OECRDH | OECRDH
OE0221 | Credit/Debit Detail Opt. Fields | OECRDDO | OECRDDO
OE0223 | Credit/Debit BOM Details | OECRDDB | OECRDDB
OE0222 | Credit/Debit Kitting Details | OECRDDD | OECRDDD

## Keys: 1

Title | Fields
--- | ---
Number/Line Number | CRDUNIQ, LINENUM

## Fields: 144

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 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 | Order Unit | 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 |
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 |
EXTWEIGHT | 44 | BCD*10.4 | Extended Weight | A |
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 |
MISCACCT | 76 | String*45 | Misc. Charges G/L Account | A | Mask: %-45C
DETAILNUM | 77 | Integer | Detail Number | E A |
HAVESERIAL | 78 | Boolean | Have Serial Numbers for Item | A X | List: 2 entries
0 | = | No
1 | = | Yes
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 Avergae 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 |
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: 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
NEXTCMPNUM | 143 | Long | Next Component Number | A |
EPOSPROMID | 144 | Integer | ePOS Promotion ID | A |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.