Objects/Tables/Table 5109 Purchase Header Archive
Table 5109 Purchase Header Archive in 22
Jonas Paprotka, Base Application 22.5.59966.64723, checked
- App
- Base Application
Fields, 147Keys, 3Procedures, 2Events, 1
Versions171819202122232425262728latest
Source29
Fields, 147
| Id | Name | Type | Obsolete |
|---|
| 1 | Document Type | Enum Purchase Document Type | - |
| 2 | Buy-from Vendor No. | Code[20] | - |
| 3 | No. | Code[20] | - |
| 4 | Pay-to Vendor No. | Code[20] | - |
| 5 | Pay-to Name | Text[100] | - |
| 6 | Pay-to Name 2 | Text[50] | - |
| 7 | Pay-to Address | Text[100] | - |
| 8 | Pay-to Address 2 | Text[50] | - |
| 9 | Pay-to City | Text[30] | - |
| 10 | Pay-to Contact | Text[100] | - |
| 11 | Your Reference | Text[35] | - |
| 12 | Ship-to Code | Code[10] | - |
| 13 | Ship-to Name | Text[100] | - |
| 14 | Ship-to Name 2 | Text[50] | - |
| 15 | Ship-to Address | Text[100] | - |
| 16 | Ship-to Address 2 | Text[50] | - |
| 17 | Ship-to City | Text[30] | - |
| 18 | Ship-to Contact | Text[100] | - |
| 19 | Order Date | Date | - |
| 20 | Posting Date | Date | - |
| 21 | Expected Receipt Date | Date | - |
| 22 | Posting Description | Text[100] | - |
| 23 | Payment Terms Code | Code[10] | - |
| 24 | Due Date | Date | - |
| 25 | Payment Discount % | Decimal | - |
| 26 | Pmt. Discount Date | Date | - |
| 27 | Shipment Method Code | Code[10] | - |
| 28 | Location Code | Code[10] | - |
| 29 | Shortcut Dimension 1 Code | Code[20] | - |
| 30 | Shortcut Dimension 2 Code | Code[20] | - |
| 31 | Vendor Posting Group | Code[20] | - |
| 32 | Currency Code | Code[10] | - |
| 33 | Currency Factor | Decimal | - |
| 35 | Prices Including VAT | Boolean | - |
| 37 | Invoice Disc. Code | Code[20] | - |
| 41 | Language Code | Code[10] | - |
| 43 | Purchaser Code | Code[20] | - |
| 45 | Order Class | Code[10] | - |
| 46 | Comment | Boolean | - |
| 47 | No. Printed | Integer | - |
| 51 | On Hold | Code[3] | - |
| 52 | Applies-to Doc. Type | Enum Gen. Journal Document Type | - |
| 53 | Applies-to Doc. No. | Code[20] | - |
| 55 | Bal. Account No. | Code[20] | - |
| 57 | Receive | Boolean | - |
| 58 | Invoice | Boolean | - |
| 60 | Amount | Decimal | - |
| 61 | Amount Including VAT | Decimal | - |
| 62 | Receiving No. | Code[20] | - |
| 63 | Posting No. | Code[20] | - |
| 64 | Last Receiving No. | Code[20] | - |
| 65 | Last Posting No. | Code[20] | - |
| 66 | Vendor Order No. | Code[35] | - |
| 67 | Vendor Shipment No. | Code[35] | - |
| 68 | Vendor Invoice No. | Code[35] | - |
| 69 | Vendor Cr. Memo No. | Code[35] | - |
| 70 | VAT Registration No. | Text[20] | - |
| 72 | Sell-to Customer No. | Code[20] | - |
| 73 | Reason Code | Code[10] | - |
| 74 | Gen. Bus. Posting Group | Code[20] | - |
| 76 | Transaction Type | Code[10] | - |
| 77 | Transport Method | Code[10] | - |
| 78 | VAT Country/Region Code | Code[10] | - |
| 79 | Buy-from Vendor Name | Text[100] | - |
| 80 | Buy-from Vendor Name 2 | Text[50] | - |
| 81 | Buy-from Address | Text[100] | - |
| 82 | Buy-from Address 2 | Text[50] | - |
| 83 | Buy-from City | Text[30] | - |
| 84 | Buy-from Contact | Text[100] | - |
| 85 | Pay-to Post Code | Code[20] | - |
| 86 | Pay-to County | Text[30] | - |
| 87 | Pay-to Country/Region Code | Code[10] | - |
| 88 | Buy-from Post Code | Code[20] | - |
| 89 | Buy-from County | Text[30] | - |
| 90 | Buy-from Country/Region Code | Code[10] | - |
| 91 | Ship-to Post Code | Code[20] | - |
| 92 | Ship-to County | Text[30] | - |
| 93 | Ship-to Country/Region Code | Code[10] | - |
| 94 | Bal. Account Type | Enum Payment Balance Account Type | - |
| 95 | Order Address Code | Code[10] | - |
| 97 | Entry Point | Code[10] | - |
| 98 | Correction | Boolean | - |
| 99 | Document Date | Date | - |
| 101 | Area | Code[10] | - |
| 102 | Transaction Specification | Code[10] | - |
| 104 | Payment Method Code | Code[10] | - |
| 107 | No. Series | Code[20] | - |
| 108 | Posting No. Series | Code[20] | - |
| 109 | Receiving No. Series | Code[20] | - |
| 114 | Tax Area Code | Code[20] | - |
| 115 | Tax Liable | Boolean | - |
| 116 | VAT Bus. Posting Group | Code[20] | - |
| 118 | Applies-to ID | Code[50] | - |
| 119 | VAT Base Discount % | Decimal | - |
| 120 | Status | Option | - |
| 121 | Invoice Discount Calculation | Option | - |
| 122 | Invoice Discount Value | Decimal | - |
| 123 | Send IC Document | Boolean | - |
| 124 | IC Status | Enum Purchase Document IC Status | - |
| 125 | Buy-from IC Partner Code | Code[20] | - |
| 126 | Pay-to IC Partner Code | Code[20] | - |
| 127 | IC Reference Document No. | Code[20] | - |
| 129 | IC Direction | Enum IC Direction Type | - |
| 130 | Prepayment No. | Code[20] | - |
| 131 | Last Prepayment No. | Code[20] | - |
| 132 | Prepmt. Cr. Memo No. | Code[20] | - |
| 133 | Last Prepmt. Cr. Memo No. | Code[20] | - |
| 134 | Prepayment % | Decimal | - |
| 135 | Prepayment No. Series | Code[20] | - |
| 136 | Compress Prepayment | Boolean | - |
| 137 | Prepayment Due Date | Date | - |
| 138 | Prepmt. Cr. Memo No. Series | Code[20] | - |
| 139 | Prepmt. Posting Description | Text[100] | - |
| 142 | Prepmt. Pmt. Discount Date | Date | - |
| 143 | Prepmt. Payment Terms Code | Code[10] | - |
| 144 | Prepmt. Payment Discount % | Decimal | - |
| 145 | No. of Archived Versions | Integer | - |
| 151 | Purchase Quote No. | Code[20] | - |
| 179 | VAT Reporting Date | Date | - |
| 480 | Dimension Set ID | Integer | - |
| 3998 | Source Doc. Exists | Boolean | - |
| 3999 | Last Archived Date | DateTime | - |
| 5043 | Interaction Exist | Boolean | - |
| 5044 | Time Archived | Time | - |
| 5045 | Date Archived | Date | - |
| 5046 | Archived By | Code[50] | - |
| 5047 | Version No. | Integer | - |
| 5048 | Doc. No. Occurrence | Integer | - |
| 5050 | Campaign No. | Code[20] | - |
| 5052 | Buy-from Contact No. | Code[20] | - |
| 5053 | Pay-to Contact No. | Code[20] | - |
| 5700 | Responsibility Center | Code[10] | - |
| 5752 | Completely Received | Boolean | - |
| 5753 | Posting from Whse. Ref. | Integer | - |
| 5754 | Location Filter | Code[10] | - |
| 5790 | Requested Receipt Date | Date | - |
| 5791 | Promised Receipt Date | Date | - |
| 5792 | Lead Time Calculation | DateFormula | - |
| 5793 | Inbound Whse. Handling Time | DateFormula | - |
| 5796 | Date Filter | Date | - |
| 5800 | Vendor Authorization No. | Code[35] | - |
| 5801 | Return Shipment No. | Code[20] | - |
| 5802 | Return Shipment No. Series | Code[20] | - |
| 5803 | Ship | Boolean | - |
| 5804 | Last Return Shipment No. | Code[20] | - |
| 7000 | Price Calculation Method | Enum Price Calculation Method | - |
| 9000 | Assigned User ID | Code[50] | - |
Keys, 3
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Document Type, No., Doc. No. Occurrence, Version No. | - |
| Key2 | Document Type, Buy-from Vendor No. | - |
| Key3 | Document Type, Pay-to Vendor No. | - |
Procedures, 2
| Name | Parameters | Returns | Access | Obsolete |
|---|
| ShowDimensions | () | | public | - |
| SetSecurityFilterOnRespCenter | () | | public | - |
Events, 1
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeSetSecurityFilterOnRespCenter | (var Record Purchase Header Archive, var Boolean) | - |