Table 311 Sales & Receivables Setup in 17
- App
- Base Application
Fields, 78Keys, 1Procedures, 3
Versions171819202122232425262728latest
Source29
Fields, 78
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | Primary Key | Code[10] | - | ||||
| 2 | Discount Posting | Option | - | ||||
| 4 | Credit Warnings | Option | - | ||||
| 5 | Stockout Warning | Boolean | - | ||||
| 6 | Shipment on Invoice | Boolean | - | ||||
| 7 | Invoice Rounding | Boolean | - | ||||
| 8 | Ext. Doc. No. Mandatory | Boolean | - | ||||
| 9 | Customer Nos. | Code[20] | - | ||||
| 10 | Quote Nos. | Code[20] | - | ||||
| 11 | Order Nos. | Code[20] | - | ||||
| 12 | Invoice Nos. | Code[20] | - | ||||
| 13 | Posted Invoice Nos. | Code[20] | - | ||||
| 14 | Credit Memo Nos. | Code[20] | - | ||||
| 15 | Posted Credit Memo Nos. | Code[20] | - | ||||
| 16 | Posted Shipment Nos. | Code[20] | - | ||||
| 17 | Reminder Nos. | Code[20] | - | ||||
| 18 | Issued Reminder Nos. | Code[20] | - | ||||
| 19 | Fin. Chrg. Memo Nos. | Code[20] | - | ||||
| 20 | Issued Fin. Chrg. M. Nos. | Code[20] | - | ||||
| 21 | Posted Prepmt. Inv. Nos. | Code[20] | - | ||||
| 22 | Posted Prepmt. Cr. Memo Nos. | Code[20] | - | ||||
| 23 | Blanket Order Nos. | Code[20] | - | ||||
| 24 | Calc. Inv. Discount | Boolean | - | ||||
| 25 | Appln. between Currencies | Option | - | ||||
| 26 | Copy Comments Blanket to Order | Boolean | - | ||||
| 27 | Copy Comments Order to Invoice | Boolean | - | ||||
| 28 | Copy Comments Order to Shpt. | Boolean | - | ||||
| 29 | Allow VAT Difference | Boolean | - | ||||
| 30 | Calc. Inv. Disc. per VAT ID | Boolean | - | ||||
| 31 | Logo Position on Documents | Option | - | ||||
| 32 | Check Prepmt. when Posting | Boolean | - | ||||
| 33 | Prepmt. Auto Update Frequency | Option | - | ||||
| 35 | Default Posting Date | Enum Default Posting Date | - | ||||
| 36 | Default Quantity to Ship | Option | - | ||||
| 37 | Archive Quotes and Orders | Boolean | Pending 15.0 | ||||
| Replaced by new fields Archive Quotes and Archive Orders | |||||||
| 38 | Post with Job Queue | Boolean | - | ||||
| 39 | Job Queue Category Code | Code[10] | - | ||||
| 40 | Job Queue Priority for Post | Integer | - | ||||
| 41 | Post & Print with Job Queue | Boolean | - | ||||
| 42 | Job Q. Prio. for Post & Print | Integer | - | ||||
| 43 | Notify On Success | Boolean | - | ||||
| 44 | VAT Bus. Posting Gr. (Price) | Code[20] | - | ||||
| 45 | Direct Debit Mandate Nos. | Code[20] | - | ||||
| 46 | Allow Document Deletion Before | Date | - | ||||
| 47 | Report Output Type | Option | - | ||||
| 50 | Default Item Quantity | Boolean | - | ||||
| 51 | Create Item from Description | Boolean | - | ||||
| 52 | Archive Quotes | Option | - | ||||
| 53 | Archive Orders | Boolean | - | ||||
| 54 | Archive Blanket Orders | Boolean | - | ||||
| 55 | Archive Return Orders | Boolean | - | ||||
| 57 | Create Item from Item No. | Boolean | - | ||||
| 58 | Copy Customer Name to Entries | Boolean | - | ||||
| 60 | Batch Archiving Quotes | Boolean | - | ||||
| 61 | Ignore Updated Addresses | Boolean | - | ||||
| 65 | Skip Manual Reservation | Boolean | - | ||||
| 170 | Insert Std. Sales Lines Mode | Option | Pending 15.0 | ||||
| Not needed after refactoring | |||||||
| 171 | Insert Std. Lines on Quotes | Boolean | Pending 15.0 | ||||
| Not needed after refactoring | |||||||
| 172 | Insert Std. Lines on Orders | Boolean | Pending 15.0 | ||||
| Not needed after refactoring | |||||||
| 173 | Insert Std. Lines on Invoices | Boolean | Pending 15.0 | ||||
| Not needed after refactoring | |||||||
| 174 | Insert Std. Lines on Cr. Memos | Boolean | Pending 15.0 | ||||
| Not needed after refactoring | |||||||
| 200 | Quote Validity Calculation | DateFormula | - | ||||
| 210 | Copy Line Descr. to G/L Entry | Boolean | - | ||||
| 393 | Canceled Issued Reminder Nos. | Code[20] | - | ||||
| 395 | Canc. Iss. Fin. Ch. Mem. Nos. | Code[20] | - | ||||
| 5329 | Write-in Product Type | Option | - | ||||
| 5330 | Write-in Product No. | Code[20] | - | ||||
| 5800 | Posted Return Receipt Nos. | Code[20] | - | ||||
| 5801 | Copy Cmts Ret.Ord. to Ret.Rcpt | Boolean | - | ||||
| 5802 | Copy Cmts Ret.Ord. to Cr. Memo | Boolean | - | ||||
| 6600 | Return Order Nos. | Code[20] | - | ||||
| 6601 | Return Receipt on Credit Memo | Boolean | - | ||||
| 6602 | Exact Cost Reversing Mandatory | Boolean | - | ||||
| 7000 | Price Calculation Method | Enum Price Calculation Method | - | ||||
| 7001 | Price List Nos. | Code[20] | - | ||||
| 7101 | Customer Group Dimension Code | Code[20] | - | ||||
| 7102 | Salesperson Dimension Code | Code[20] | - | ||||
| 7103 | Freight G/L Acc. No. | Code[20] | - | ||||
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Primary Key | - |
Procedures, 3
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| GetRecordOnce | () | public | - | |
| GetLegalStatement | () | Text | public | - |
| JobQueueActive | () | Boolean | public | - |