Table: Credit/Debit Details

Table: OECRDD
View: OE0220
Record Length: 1516

Flags: A R 

Keys: 2

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

Fields: 159

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 Credit/Debit Note UOM 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
DETAILNUM Integer Detail Number
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 Mask: %-24C
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
COG BCD*10.3 Cost of Goods
COSTED Boolean Record Costed List:2 entries
0 = No
1 = Yes
JOBRELATED Boolean Job Related
CONTRACT String*16 Contract Code Mask: %-16C
PROJECT String*16 Project Code Mask: %-16N
CCATEGORY String*16 Category Code Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE Integer Project Style List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE Integer Project Type List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC Integer Accounting Method 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 Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
REVBILL String*45 Revenue/Billing Account Mask: %-45C
COGSWIP String*45 COGS/WIP Account Mask: %-45C
RTGAMOUNT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percent
RTGDAYS Integer Retainage Days
RTGDATEDUE Date Retainage Due Date
RTGDDTOVR Boolean Retainage Due Date Override
RTGAMTOVR Boolean Retainage Amount Override
RTGTXBASE1 BCD*10.3 Retainage Tax Base 1
RTGTXBASE2 BCD*10.3 Retainage Tax Base 2
RTGTXBASE3 BCD*10.3 Retainage Tax Base 3
RTGTXBASE4 BCD*10.3 Retainage Tax Base 4
RTGTXBASE5 BCD*10.3 Retainage Tax Base 5
RTGTXAMT1 BCD*10.3 Retainage Tax Amount 1
RTGTXAMT2 BCD*10.3 Retainage Tax Amount 2
RTGTXAMT3 BCD*10.3 Retainage Tax Amount 3
RTGTXAMT4 BCD*10.3 Retainage Tax Amount 4
RTGTXAMT5 BCD*10.3 Retainage Tax Amount 5
PRICEOPT Integer Default O/E Price List:4 entries
0 =
1 = Billing Rate
2 = Use Customer Price List
3 = Use Specified Price List
SERIALQTY Long Serial Quantity
LOTQTY BCD*10.4 Lot Quantity
SLITEM Integer Item Serialized/Lotted? List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both

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