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: %-30c
BILFAX  String*30  Bill-To Fax  Mask: %-30c
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: %-30c
BILFAXC  String*30  Bill-To Contact Fax  Mask: %-30c
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: %-30c
SHPFAX  String*30  Ship-To Fax Number  Mask: %-30c
SHPCONTACT  String*60  Ship-To Contact   
SHPEMAIL  String*50  Ship-To E-mail   
SHPPHONEC  String*30  Ship-To Contact Phone  Mask: %-30c
SHPFAXC  String*30  Ship-To Contact Fax  Mask: %-30c
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 2009-Nov-19

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