# 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 Pct |
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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.