Table: Credit/Debit Notes

Table: OECRDH
View: OE0240
Record length: 2981
Flags: A R 

Keys: 7

Title  Flags  Fields

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

Fields: 185

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  Number of Lines in Credit/Debit   
CRDWEIGHT  BCD*10.4  Credit/Debit Note Total Estimate   
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  Credit/Debit Note Discount on Mi   
POSTDATE  Date  Posting Date   
COMPDATE  Date  Completion Date   
CRDNETNOTX  BCD*10.3  Credit/Debit Note Total Before T   
CRDITAXTOT  BCD*10.3  Credit/Debit Note Included Tax T   
CRDITMTOT  BCD*10.3  Credit/Debit Note Item Total Amo   
CRDDISCBAS  BCD*10.3  Credit/Debit Note Discount Base   
CRDDISCPER  BCD*5.5  Credit/Debit Note Discount Perce   
CRDDISCAMT  BCD*10.3  Credit/Debit Note Discount Amoun   
CRDMISC  BCD*10.3  Credit/Debit Note Total Miscella   
CRDSUBTOT  BCD*10.3  Credit/Debit Note Subtotal Amoun   
CRDNET  BCD*10.3  Credit/Debit Note Total With CN   
CRDETAXTOT  BCD*10.3  Credit/Debit Note Excluded Tax T   
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 Currenc  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  Credit/Debit Note Rate Date Matc   
CRRATEREP  Integer  Credit/Debit Note Rate Operator   
CRRATEOVER  Boolean  Credit/Debit Note Rate Override   
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) Curre  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  Credit/Debit Note Discount Amoun   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.