|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Sales Order - Document Reference Information
Table Name: RDR21
Table Description: Sales Order - Document Reference Information
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | - | 17 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| RefType | Reference Types | VarChar | 1 | - | S | S | System Document |
| Â | Â | Â | Â | Â | Â | E | External Document |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| RefDocEntr | Referenced Internal Number | Int | 11 | - | Â | Â | Â |
| RefDocNum | Referenced Document Number | Int | 11 | - | Â | Â | Â |
| ExtDocNum | External Referenced Document Number | nVarChar | 100 | - | Â | Â | Â |
| RefObjType | Referenced Object Type | nVarChar | 20 | - | Â | 23 | Sales Quotation |
| Â | Â | Â | Â | Â | Â | 17 | Sales Order |
| Â | Â | Â | Â | Â | Â | 15 | Delivery Notes |
| Â | Â | Â | Â | Â | Â | 234000031 | Return Request |
| Â | Â | Â | Â | Â | Â | 16 | Return |
| Â | Â | Â | Â | Â | Â | 203 | A/R Down Payment |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 165 | A/R Correction Invoice |
| Â | Â | Â | Â | Â | Â | 280 | A/R Tax Invoice |
| Â | Â | Â | Â | Â | Â | 1470000113 | Purchase Request |
| Â | Â | Â | Â | Â | Â | 540000006 | Purchase Quotation |
| Â | Â | Â | Â | Â | Â | 22 | Purchase Order |
| Â | Â | Â | Â | Â | Â | 20 | Goods Receipt PO |
| Â | Â | Â | Â | Â | Â | 234000032 | Goods Return Request |
| Â | Â | Â | Â | Â | Â | 21 | Goods Return |
| Â | Â | Â | Â | Â | Â | 204 | A/P Down Payment |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 163 | A/P Correction Invoice |
| Â | Â | Â | Â | Â | Â | 281 | A/P Tax Invoice |
| Â | Â | Â | Â | Â | Â | 69 | Landed Costs |
| Â | Â | Â | Â | Â | Â | 24 | Incoming Payments |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payments |
| Â | Â | Â | Â | Â | Â | 57 | Checks for Payment |
| Â | Â | Â | Â | Â | Â | 321 | Internal Reconciliation |
| Â | Â | Â | Â | Â | Â | 34 | Recurring Posting |
| Â | Â | Â | Â | Â | Â | 30 | Journal Entry |
| Â | Â | Â | Â | Â | Â | 59 | Goods Receipt |
| Â | Â | Â | Â | Â | Â | 60 | Goods Issue |
| Â | Â | Â | Â | Â | Â | 162 | Inventory Revaluation |
| Â | Â | Â | Â | Â | Â | 1470000065 | Inventory Counting |
| Â | Â | Â | Â | Â | Â | 10000071 | Inventory Posting |
| Â | Â | Â | Â | Â | Â | 1250000001 | Inventory Transfer Request |
| Â | Â | Â | Â | Â | Â | 67 | Inventory Transfer |
| Â | Â | Â | Â | Â | Â | 202 | Production Order |
| Â | Â | Â | Â | Â | Â | 13001 | Original Invoice |
| Â | Â | Â | Â | Â | Â | -1 | External Document |
| Â | Â | Â | Â | Â | Â | 20301 | Original Down Payment Invoice |
| AccessKey | Access Key | nVarChar | 100 | - | Â | Â | Â |
| IssueDate | Date of Issue | Date | 8 | - | Â | Â | Â |
| IssuerCNPJ | Issuer CNPJ | nVarChar | 100 | - | Â | Â | Â |
| IssuerCode | Fiscal Document Issuer UF Code | nVarChar | 10 | - | Â | Â | Â |
| Model | Fiscal Document Model | nVarChar | 6 | - | Â | Â | Â |
| Series | Fiscal Document Series | nVarChar | 3 | - | Â | Â | Â |
| Number | Fiscal Document Number | Int | 11 | - | Â | Â | Â |
| RefAccKey | Referenced CT-e Access Key | nVarChar | 100 | - | Â | Â | Â |
| RefAmount | Referenced Amount | Num | 19.6 | - | Â | Â | Â |
| SubSeries | Fiscal Document Subseries | nVarChar | 3 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 254 | - | Â | Â | Â |
| LinkRefTyp | Link Reference Type | nVarChar | 20 | - | 00 | 00 | Â |
|  |  |  |  |  |  | 01 | Nota de cr�dito de los documentos relacionados |
|  |  |  |  |  |  | 02 | Nota de d�bito de los documentos relacionados |
|  |  |  |  |  |  | 03 | Devoluci�n de mercanc�a sobre facturas o traslados previos |
|  |  |  |  |  |  | 04 | Sustituci�n de los CFDI previos |
| Â | Â | Â | Â | Â | Â | 05 | Traslados de mercancias facturados previamente |
| Â | Â | Â | Â | Â | Â | 06 | Factura generada por los traslados previos |
|  |  |  |  |  |  | 07 | CFDI por aplicaci�n de anticipo |
| Â | Â | Â | Â | Â | Â | 08 | Customs |
| Â | Â | Â | Â | Â | Â | MX_08 | Factura generada por pagos en parcialidades |
| Â | Â | Â | Â | Â | Â | 09 | Factura generada por pagos diferidos |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| Â | Â | RefType |
| DOC_ENTRY | No | DocEntry |