Table: Credit/Debit Notes

Table: OECRDH
View: OE0240
Record Length: 3123

Flags: A R 

Keys: 8

Title Flags Fields
CN Uniquifier CRDUNIQ
Credit/Debit Note Number CRDNUMBER
Order No/Credit/Debit Note No ORDNUMBER, CRDNUMBER
Invoice No/Credit/Debit Note No INVNUMBER, CRDNUMBER
I/C Day End Trans. Number DAYENDNUM
Customer Number D M  CUSTOMER
Reference/Credit/Debit Note No M  REFERENCE, CRDNUMBER
Customer No/Credit/Debit Note No D M  CUSTOMER, CRDNUMBER

Fields: 203

Field Type Title Presentation
CRDUNIQ BCD*10.0 CN Uniquifier
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
ORDNUMBER String*22 Order Number Mask: %-22C
INVNUMBER String*22 Invoice Number Mask: %-22C
CRDNUMBER String*22 Credit/Debit Note Number Mask: %-22C
DAYENDNUM BCD*10.0 I/C Day End Trans. Number
CUSTOMER String*12 Customer Number Mask: %-12C
BILNAME String*60 Bill To
BILADDR1 String*60 Bill-To Address 1
BILADDR2 String*60 Bill-To Address 2
BILADDR3 String*60 Bill-To Address 3
BILADDR4 String*60 Bill-To Address 4
BILCITY String*30 Bill-To City
BILSTATE String*30 Bill-To State
BILZIP String*20 Bill-To Zip Code
BILCOUNTRY String*30 Bill-To Country
BILPHONE String*30 Bill-To Phone Mask: (%-3C) %-3C-%-24C
BILFAX String*30 Bill-To Fax Mask: (%-3C) %-3C-%-24C
BILCONTACT String*60 Bill-To Contact
CUSTDISC Integer Customer Discount Level List:6 entries
0 = Base
1 = A
2 = B
3 = C
4 = D
5 = E
PRICELIST String*6 Default Price List Code Mask: %-6N
PONUMBER String*22 Purchase Order Number Mask: %-22C
TERRITORY String*6 Territory Mask: %-6N
REFERENCE String*60 Reference
ORDDATE Date Order Date
FOB String*60 Free On Board Point
TEMPLATE String*6 Template Code Mask: %-6N
LOCATION String*6 Default Location Code Mask: %-6N
DESC String*60 Description
COMMENT String*250 Comment
SHIPDATE Date Shipment Date
INVDATE Date Invoice Date
INVFISCYR String*4 Invoice Fiscal Year Mask: %-4d
INVFISCPER Integer Invoice Fiscal Period
INHOMECURR String*3 Invoice Home Currency Mask: %-3N
INRATETYPE String*2 Invoice Rate Type Mask: %-2N
INSOURCURR String*3 Invoice Source Currency Mask: %-3N
INRATEDATE Date Invoice Rate Date
INRATE BCD*8.7 Invoice Rate
INSPREAD BCD*8.7 Invoice Spread
INDATEMTCH Integer Invoice Rate Date Matching
INRATEREP Integer Invoice Rate Operator
INRATEOVER Boolean Invoice Rate Override Flag
CRDTOTAL BCD*10.3 CR Item Subtotal
CRDMTOTAL BCD*10.3 CR Misc. Charges Subtotal
RETDATE Date Return Date
CRDDATE Date Credit/Debit Note Date
CRDFISCYR String*4 Credit/Debit Note Fiscal Year Mask: %-4d
CRDFISCPER Integer Credit/Debit Note Fiscal Period List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
CRDLINES Integer No of Lines in Credit/Debit Note
CRDWEIGHT BCD*10.4 Credit/Debit Note Tot Est Weight
NEXTDTLNUM Integer Next Detail Number
CRDSTATUS Integer Credit/Debit Note Status List:2 entries
1 = Document shipped not costed
2 = Document costed
CRDPRINTED Boolean Credit/Debit Note Printed List:2 entries
0 = No
1 = Yes
CDISONMISC Boolean CN/DN Discount on Misc. Charges
POSTDATE Date Posting Date
COMPDATE Date Completion Date
CRDNETNOTX BCD*10.3 Credit/Debit Note Tot Before Tax
CRDITAXTOT BCD*10.3 CN/DN Included Tax Total Amt
CRDITMTOT BCD*10.3 Credit/Debit Note Item Total Amt
CRDDISCBAS BCD*10.3 Credit/Debit Note Discount Base
CRDDISCPER BCD*5.5 Credit/Debit Note Discount Percentage
CRDDISCAMT BCD*10.3 Credit/Debit Note Discount Amt
CRDMISC BCD*10.3 CN/DN Total Misc Charges
CRDSUBTOT BCD*10.3 Credit/Debit Note Subtotal Amt
CRDNET BCD*10.3 CN/DN Total With CN Discount
CRDETAXTOT BCD*10.3 CN/DN Excluded Tax Total Amount
CRDNETWTX BCD*10.3 Credit/Debit Note Total
CRHOMECURR String*3 Credit/Debit Note Home Currency Mask: %-3N
CRRATETYPE String*2 Credit/Debit Note Rate Type Mask: %-2N
CRSOURCURR String*3 Credit/Debit Note Source Curr Mask: %-3N
CRRATEDATE Date Credit/Debit Note Rate Date
CRRATE BCD*8.7 Credit/Debit Note Rate
CRSPREAD BCD*8.7 Credit/Debit Note Spread
CRDATEMTCH Integer CN/DN Rate Date Matching
CRRATEREP Integer Credit/Debit Note Rate Operator
CRRATEOVER Boolean CN/DN Rate Override Flag
SALESPER1 String*8 Salesperson 1 Mask: %-8N
SALESPER2 String*8 Salesperson 2 Mask: %-8N
SALESPER3 String*8 Salesperson 3 Mask: %-8N
SALESPER4 String*8 Salesperson 4 Mask: %-8N
SALESPER5 String*8 Salesperson 5 Mask: %-8N
SALESPLT1 BCD*5.5 Sales Percentage 1
SALESPLT2 BCD*5.5 Sales Percentage 2
SALESPLT3 BCD*5.5 Sales Percentage 3
SALESPLT4 BCD*5.5 Sales Percentage 4
SALESPLT5 BCD*5.5 Sales Percentage 5
RECALCTAX Boolean Recalculate Tax
TAXOVERRD Boolean Tax Overridden
TAXGROUP String*12 Tax Group Mask: %-12N
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
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
TEAMOUNT1 BCD*10.3 Excluded Tax Amount 1
TEAMOUNT2 BCD*10.3 Excluded Tax Amount 2
TEAMOUNT3 BCD*10.3 Excluded Tax Amount 3
TEAMOUNT4 BCD*10.3 Excluded Tax Amount 4
TEAMOUNT5 BCD*10.3 Excluded Tax Amount 5
TIAMOUNT1 BCD*10.3 Included Tax Amount 1
TIAMOUNT2 BCD*10.3 Included Tax Amount 2
TIAMOUNT3 BCD*10.3 Included Tax Amount 3
TIAMOUNT4 BCD*10.3 Included Tax Amount 4
TIAMOUNT5 BCD*10.3 Included Tax Amount 5
TEXEMPT1 String*20 Registration 1
TEXEMPT2 String*20 Registration 2
TEXEMPT3 String*20 Registration 3
TEXEMPT4 String*20 Registration 4
TEXEMPT5 String*20 Registration 5
AUTOTAXCAL Boolean Auto-Tax Calculation Status
BILEMAIL String*50 Bill-To E-mail
BILPHONEC String*30 Bill-To Contact Phone Mask: (%-3C) %-3C-%-24C
BILFAXC String*30 Bill-To Contact Fax Mask: (%-3C) %-3C-%-24C
BILEMAILC String*50 Bill-To Contact E-mail
ADJTYPE Integer Type List:2 entries
1 = Credit Note
2 = Debit Note
SHIPTRACK String*36 Shipment Tracking Number
SHIPVIA String*6 Ship-Via Code Mask: %-6N
VIADESC String*60 Ship-Via Code Description
SHIPTO String*6 Ship-To Location Code Mask: %-6C
SHPNAME String*60 Ship-To Name
SHPADDR1 String*60 Ship-To Address Line 1
SHPADDR2 String*60 Ship-To Address Line 2
SHPADDR3 String*60 Ship-To Address Line 3
SHPADDR4 String*60 Ship-To Address Line 4
SHPCITY String*30 Ship-To City
SHPSTATE String*30 Ship-To State/Province
SHPZIP String*20 Ship-To Zip/Postal Code
SHPCOUNTRY String*30 Ship-To Country
SHPPHONE String*30 Ship-To Phone Number Mask: (%-3C) %-3C-%-24C
SHPFAX String*30 Ship-To Fax Number Mask: (%-3C) %-3C-%-24C
SHPCONTACT String*60 Ship-To Contact
SHPEMAIL String*50 Ship-To E-mail
SHPPHONEC String*30 Ship-To Contact Phone Mask: (%-3C) %-3C-%-24C
SHPFAXC String*30 Ship-To Contact Fax Mask: (%-3C) %-3C-%-24C
SHPEMAILC String*50 Ship-To Contact E-mail
VALUES Long Optional Fields
INVUNIQ BCD*10.0 Invoice Uniquifier
OVERCREDIT Boolean Over Credit Limit
APPROVELMT BCD*10.3 Approved Limit
APPROVEBY String*8 Authorizing User ID Mask: %-8N
ITEMDISTOT BCD*10.3 Item Detail Discount Total
MISCDISTOT BCD*10.3 Misc. Charge Detail Discount Tot
CTRMETHOD Integer Auto-Calc. Tax Reporting Amounts
CTRCURRNCY String*3 Tax Reporting (TR) Currency Mask: %-3N
CTRRATTYPE String*2 TR Rate Type Mask: %-2N
CTRRATDATE Date TR Rate Date
CTRRATE BCD*8.7 TR Rate
CTRSPREAD BCD*8.7 TR Spread
CTRDATMTCH Integer TR Rate Date Matching
CTRRATEOP Integer TR Rate Operator
CTRRATOVER Boolean TR Rate Override Flag
CTREAMNT1 BCD*10.3 TR Excluded Tax Amount 1
CTREAMNT2 BCD*10.3 TR Excluded Tax Amount 2
CTREAMNT3 BCD*10.3 TR Excluded Tax Amount 3
CTREAMNT4 BCD*10.3 TR Excluded Tax Amount 4
CTREAMNT5 BCD*10.3 TR Excluded Tax Amount 5
CTRIAMNT1 BCD*10.3 TR Included Tax Amount 1
CTRIAMNT2 BCD*10.3 TR Included Tax Amount 2
CTRIAMNT3 BCD*10.3 TR Included Tax Amount 3
CTRIAMNT4 BCD*10.3 TR Included Tax Amount 4
CTRIAMNT5 BCD*10.3 TR Included Tax Amount 5
ITRCURRNCY String*3 Tax Reporting Invoice (TR) Curr Mask: %-3N
ITRRATTYPE String*2 TR Invoice Rate Type Mask: %-2N
ITRRATDATE Date TR Invoice Rate Date
ITRRATE BCD*8.7 TR Invoice Rate
ITRSPREAD BCD*8.7 TR Invoice Spread
ITRDATMTCH Integer TR Invoice Rate Date Matching
ITRRATEOP Integer TR Invoice Rate Operator
ITRRATOVER Boolean TR Invoice Rate Override Flag
TAXVERSION Long Tax Version
DISAMTOVER Boolean CN/DN Discount Amount Override
JOBLINES Long Job Related Detail Lines
HASRTG Boolean Has Retainage List:2 entries
0 = No
1 = Yes
RTGAMOUNT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percent
RTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
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
CUSACCTSET String*6 Customer Account Set Mask: %-6N
ENTEREDBY String*8 Entered By Mask: %-8N
DATEBUS Date Posting Date

This page was generated on 2023-Aug-31

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