# Table: Credit/Debit Details

Table: OECRDD
View: OE0220
Record length: 1257
Flags: A R

## Keys: 1

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

## Fields: 128

Field | Type | Title | Presentation
--- | --- | --- | ---
CRDUNIQ | BCD*10.0 | CN Uniquifier |
LINENUM | Integer | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
LINETYPE | Integer | Line Type | List: 2 entries
1 | = | Item
2 | = | Miscellaneous
ITEM | String*24 | Item | Mask: %-24C
MISCCHARGE | String*6 | Miscellaneous Charges Code | Mask: %-6N
DESC | String*60 | Description |
ACCTSET | String*6 | Item Account Set | Mask: %-6N
USERCOSTMD | Boolean | User-Specified Costing Method? |
PRICELIST | String*6 | Price List | Mask: %-6N
CATEGORY | String*6 | Category | Mask: %-6N
LOCATION | String*6 | Location | Mask: %-6N
PICKSEQ | String*10 | Picking Sequence |
STOCKITEM | Boolean | Stock Item |
QTYRETURN | BCD*10.4 | Quantity Returned |
QTYSHIPPED | BCD*10.4 | Quantity Shipped |
QTYBACKORD | BCD*10.4 | Quantity Backordered |
CRDUNIT | String*10 | Order Unit | Mask: %-10c
UNITCONV | BCD*10.6 | Unit Conversion |
UNITPRICE | BCD*10.6 | Unit Price |
PRICEOVER | Boolean | Price Override |
UNITCOST | BCD*10.6 | Unit Cost |
MOSTREC | BCD*10.6 | Most Recent Unit Cost |
STDCOST | BCD*10.6 | Standard Unit Cost |
COST1 | BCD*10.6 | Alternate Unit Cost 1 |
COST2 | BCD*10.6 | Alternate Unit Cost 2 |
UNITPRCDEC | Integer | Unit Price No. of Decimals |
PRICEUNIT | String*10 | Pricing Unit | Mask: %-10c
PRIUNTPRC | BCD*10.6 | Pricing Unit Price |
PRIUNTCONV | BCD*10.6 | Pricing Unit Conversion |
PRIPERCENT | BCD*5.5 | Price Discount Percentage |
PRIAMOUNT | BCD*10.3 | Price Discount Amount |
BASEUNIT | String*10 | Pricing Base Unit | Mask: %-10c
PRIBASPRC | BCD*10.6 | Pricing Base Unit Price |
PRIBASCONV | BCD*10.6 | Pricing Base Unit Conversion |
COSTUNIT | String*10 | Costing Unit | Mask: %-10c
COSUNTCST | BCD*10.6 | Costing Unit Cost |
COSUNTCONV | BCD*10.6 | Costing Unit Conversion |
EXTCCOST | BCD*10.3 | Extended Detail Cost |
EXTCRDMISC | BCD*10.3 | Extended Amount/Misc. Charge |
CRDDISC | BCD*10.3 | Credit Note Discount Amount |
EXTOVER | Boolean | Extended Amount Override |
EXTICOST | BCD*10.3 | Invoice Extended Cost |
UNITWEIGHT | BCD*10.4 | Unit Weight |
EXTWEIGHT | BCD*10.4 | Extended Weight |
RETURNTYPE | Integer | Return Type | List: 3 entries
1 | = | Items Returned to Inventory
2 | = | Damaged Items
3 | = | Price Adjustment
TAUTH1 | String*12 | Tax Authority 1 | Mask: %-12N
TAUTH2 | String*12 | Tax Authority 2 | Mask: %-12N
TAUTH3 | String*12 | Tax Authority 3 | Mask: %-12N
TAUTH4 | String*12 | Tax Authority 4 | Mask: %-12N
TAUTH5 | String*12 | Tax Authority 5 | Mask: %-12N
TCLASS1 | Integer | Tax Class 1 |
TCLASS2 | Integer | Tax Class 2 |
TCLASS3 | Integer | Tax Class 3 |
TCLASS4 | Integer | Tax Class 4 |
TCLASS5 | Integer | Tax Class 5 |
TINCLUDED1 | Boolean | Tax Included 1 |
TINCLUDED2 | Boolean | Tax Included 2 |
TINCLUDED3 | Boolean | Tax Included 3 |
TINCLUDED4 | Boolean | Tax Included 4 |
TINCLUDED5 | Boolean | Tax Included 5 |
TBASE1 | BCD*10.3 | Tax Base 1 |
TBASE2 | BCD*10.3 | Tax Base 2 |
TBASE3 | BCD*10.3 | Tax Base 3 |
TBASE4 | BCD*10.3 | Tax Base 4 |
TBASE5 | BCD*10.3 | Tax Base 5 |
TAMOUNT1 | BCD*10.3 | Tax Amount 1 |
TAMOUNT2 | BCD*10.3 | Tax Amount 2 |
TAMOUNT3 | BCD*10.3 | Tax Amount 3 |
TAMOUNT4 | BCD*10.3 | Tax Amount 4 |
TAMOUNT5 | BCD*10.3 | Tax Amount 5 |
TRATE1 | BCD*8.5 | Tax Rate 1 |
TRATE2 | BCD*8.5 | Tax Rate 2 |
TRATE3 | BCD*8.5 | Tax Rate 3 |
TRATE4 | BCD*8.5 | Tax Rate 4 |
TRATE5 | BCD*8.5 | Tax Rate 5 |
MISCACCT | String*45 | Misc. Charges G/L Account | Mask: %-45C
DETAILNUM | Integer | Detail Number |
HAVESERIAL | Boolean | Have Serial Numbers for Item | List: 2 entries
0 | = | No
1 | = | Yes
COMMINST | Boolean | Have Comments/Instructions | List: 2 entries
0 | = | No
1 | = | Yes
GLNONSTKCR | String*45 | Non-stock Clearing Account | Mask: %-45C
AVGCOST | BCD*10.6 | Average Unit Cost |
LASTCOST | BCD*10.6 | Last Unit Cost |
SHIPTRACK | String*36 | Shipment Tracking Number |
SHIPVIA | String*6 | Ship-Via Code | Mask: %-6N
VIADESC | String*60 | Ship-Via Code Description |
DISCPER | BCD*5.5 | Discount Percent |
EXPDATE | Date | Shipment Date |
QTYORDERED | BCD*10.4 | Invoice Current Qty. Outstanding |
INVUNIT | String*10 | Invoice Unit of Measure |
INVUNITCON | BCD*10.6 | Invoice Unit Conversion |
ORDQTYORD | BCD*10.4 | Order Quantity Ordered |
ORDQTYBKOR | BCD*10.4 | Order Quantity Backordered |
ORDQTYCOMM | BCD*10.4 | Order Quantity Committed |
ORDQTYSTD | BCD*10.4 | Order Quantity Shipped-to-date |
ORDUNIT | String*10 | Order Unit of Measure |
ORDUNITCON | BCD*10.6 | Order Unit Conversion |
MANITEMNO | String*24 | Manufacturer's Item Number | Mask: %-24C
CUSTITEMNO | String*24 | Customer Item Number |
VALUES | Long | Optional Fields |
DDTLTYPE | Integer | Kitting/BOM | List: 3 entries
0 | = | None
1 | = | Kitting
2 | = | BOM
DDTLNO | String*6 | Kit/BOM Number | Mask: %-6N
BUILDQTY | BCD*10.4 | BOM Build Qty. |
BUILDUNIT | String*10 | BOM Build Unit | Mask: %-10c
BLDUNTCONV | BCD*10.6 | BOM Build Unit Conversion |
INVNUMBER | String*22 | Invoice Number | Mask: %-22C
NEXTCMPNUM | Long | Next Component Number |
EPOSPROMID | Integer | ePOS Promotion ID |
BASEWUNIT | String*10 | Pricing Base Weight Unit |
WEIGHTUNIT | String*10 | Weight Unit of Measure |
WEIGHTCONV | BCD*10.6 | Weight Conversion Factor |
PRWGHTUNIT | String*10 | Pricing Weight UOM |
PRWGHTCONV | BCD*10.6 | Pricing Weight Conversion Factor |
PRIBASWCNV | BCD*10.6 | Pricing Base Weight Conv. Factor |
DEFUWEIGHT | BCD*10.4 | Def. Weight UOM Unit Weight |
DEFEXTWGHT | BCD*10.4 | Def. Weight UOM Ext. Unit Weight |
PRPRICEBY | Integer | Price By | List: 2 entries
1 | = | Quantity
2 | = | Weight
NEEDPCHECK | Boolean | Price Check Pending |
CAPPROVEBY | String*8 | Price Approved By | Mask: %-8N
HDRDISC | BCD*10.3 | Header Discount |
CTRAMOUNT1 | BCD*10.3 | TR Tax Amount 1 |
CTRAMOUNT2 | BCD*10.3 | TR Tax Amount 2 |
CTRAMOUNT3 | BCD*10.3 | TR Tax Amount 3 |
CTRAMOUNT4 | BCD*10.3 | TR Tax Amount 4 |
CTRAMOUNT5 | BCD*10.3 | TR Tax Amount 5 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.