Fields, 107
| Id | Name | Type | Versions | Obsolete | |||
|---|---|---|---|---|---|---|---|
| 1 | No. | Code[20] | 17-28 | - | |||
| 2 | Search Description | Code[100] | 17-28 | - | |||
| 3 | Description | Text[100] | 17-28 | - | |||
| 4 | Description 2 | Text[50] | 17-28 | - | |||
| 5 | Bill-to Customer No. | Code[20] | 17-28 | - | |||
| 12 | Creation Date | Date | 17-28 | - | |||
| 13 | Starting Date | Date | 17-28 | - | |||
| 14 | Ending Date | Date | 17-28 | - | |||
| 19 | Status | Enum Job Status | 17-28 | - | |||
| 20 | Person Responsible | Code[20] | 17-28 | - | |||
| 21 | Global Dimension 1 Code | Code[20] | 17-28 | - | |||
| 22 | Global Dimension 2 Code | Code[20] | 17-28 | - | |||
| 23 | Job Posting Group | Code[20] | 17-28 | - | |||
| 24 | Blocked | Enum Job Blocked | 17-28 | - | |||
| 29 | Last Date Modified | Date | 17-28 | - | |||
| 30 | Comment | Boolean | 17-28 | - | |||
| 31 | Customer Disc. Group | Code[20] | 17-28 | - | |||
| 32 | Customer Price Group | Code[10] | 17-28 | - | |||
| 35 | Location Code | Code[10] | 24-28 | - | |||
| 36 | Bin Code | Code[20] | 24-28 | - | |||
| 41 | Language Code | Code[10] | 17-28 | - | |||
| 49 | Scheduled Res. Qty. | Decimal | 17-28 | - | |||
| 50 | Resource Filter | Code[20] | 17-28 | - | |||
| 51 | Posting Date Filter | Date | 17-28 | - | |||
| 55 | Resource Gr. Filter | Code[20] | 17-28 | - | |||
| 56 | Scheduled Res. Gr. Qty. | Decimal | 17-28 | - | |||
| 57 | Picture | Blob | 17-25, gone | Removed 18.0 | |||
| Replaced by Image field | |||||||
| 58 | Bill-to Name | Text[100] | 17-28 | - | |||
| 59 | Bill-to Address | Text[100] | 17-28 | - | |||
| 60 | Bill-to Address 2 | Text[50] | 17-28 | - | |||
| 61 | Bill-to City | Text[30] | 17-28 | - | |||
| 63 | Bill-to County | Text[30] | 17-28 | - | |||
| 64 | Bill-to Post Code | Code[20] | 17-28 | - | |||
| 66 | No. Series | Code[20] | 17-28 | - | |||
| 67 | Bill-to Country/Region Code | Code[10] | 17-28 | - | |||
| 68 | Bill-to Name 2 | Text[50] | 17-28 | - | |||
| 80 | Task Billing Method | Enum Task Billing Method | 24-28 | - | |||
| 117 | Reserve | Enum Reserve Method | 17-28 | - | |||
| 140 | Image | Media | 17-28 | - | |||
| 210 | Ship-to Phone No. | Text[30] | 25-28 | - | |||
| 1000 | WIP Method | Code[20] | 17-28 | - | |||
| 1001 | Currency Code | Code[10] | 17-28 | - | |||
| 1002 | Bill-to Contact No. | Code[20] | 17-28 | - | |||
| 1003 | Bill-to Contact | Text[100] | 17-28 | - | |||
| 1004 | Planning Date Filter | Date | 17-28 | - | |||
| 1005 | Total WIP Cost Amount | Decimal | 17-28 | - | |||
| 1006 | Total WIP Cost G/L Amount | Decimal | 17-28 | - | |||
| 1007 | WIP Entries Exist | Boolean | 17-28 | - | |||
| 1008 | WIP Posting Date | Date | 17-28 | - | |||
| 1009 | WIP G/L Posting Date | Date | 17-28 | - | |||
| 1011 | Invoice Currency Code | Code[10] | 17-28 | - | |||
| 1012 | Exch. Calculation (Cost) | Option | 17-28 | - | |||
| 1013 | Exch. Calculation (Price) | Option | 17-28 | - | |||
| 1014 | Allow Schedule/Contract Lines | Boolean | 17-28 | - | |||
| 1015 | Complete | Boolean | 17-28 | - | |||
| 1017 | Recog. Sales Amount | Decimal | 17-28 | - | |||
| 1018 | Recog. Sales G/L Amount | Decimal | 17-28 | - | |||
| 1019 | Recog. Costs Amount | Decimal | 17-28 | - | |||
| 1020 | Recog. Costs G/L Amount | Decimal | 17-28 | - | |||
| 1021 | Total WIP Sales Amount | Decimal | 17-28 | - | |||
| 1022 | Total WIP Sales G/L Amount | Decimal | 17-28 | - | |||
| 1023 | WIP Completion Calculated | Boolean | 17-28 | - | |||
| 1024 | Next Invoice Date | Date | 17-28 | - | |||
| 1025 | Apply Usage Link | Boolean | 17-28 | - | |||
| 1026 | WIP Warnings | Boolean | 17-28 | - | |||
| 1027 | WIP Posting Method | Option | 17-28 | - | |||
| 1028 | Applied Costs G/L Amount | Decimal | 17-28 | - | |||
| 1029 | Applied Sales G/L Amount | Decimal | 17-28 | - | |||
| 1030 | Calc. Recog. Sales Amount | Decimal | 17-28 | - | |||
| 1031 | Calc. Recog. Costs Amount | Decimal | 17-28 | - | |||
| 1032 | Calc. Recog. Sales G/L Amount | Decimal | 17-28 | - | |||
| 1033 | Calc. Recog. Costs G/L Amount | Decimal | 17-28 | - | |||
| 1034 | WIP Completion Posted | Boolean | 17-28 | - | |||
| 1035 | Over Budget | Boolean | 17-28 | - | |||
| 1036 | Project Manager | Code[50] | 17-28 | - | |||
| 2000 | Sell-to Customer No. | Code[20] | 20-28 | - | |||
| 2001 | Sell-to Customer Name | Text[100] | 20-28 | - | |||
| 2002 | Sell-to Customer Name 2 | Text[50] | 20-28 | - | |||
| 2003 | Sell-to Address | Text[100] | 20-28 | - | |||
| 2004 | Sell-to Address 2 | Text[50] | 20-28 | - | |||
| 2005 | Sell-to City | Text[30] | 20-28 | - | |||
| 2006 | Sell-to Contact | Text[100] | 20-28 | - | |||
| 2007 | Sell-to Post Code | Code[20] | 20-28 | - | |||
| 2008 | Sell-to County | Text[30] | 20-28 | - | |||
| 2009 | Sell-to Country/Region Code | Code[10] | 20-28 | - | |||
| 2010 | Sell-to Phone No. | Text[30] | 20-28 | - | |||
| 2011 | Sell-to E-Mail | Text[80] | 20-28 | - | |||
| 2012 | Sell-to Contact No. | Code[20] | 20-28 | - | |||
| 3000 | Ship-to Code | Code[10] | 20-28 | - | |||
| 3001 | Ship-to Name | Text[100] | 20-28 | - | |||
| 3002 | Ship-to Name 2 | Text[50] | 20-28 | - | |||
| 3003 | Ship-to Address | Text[100] | 20-28 | - | |||
| 3004 | Ship-to Address 2 | Text[50] | 20-28 | - | |||
| 3005 | Ship-to City | Text[30] | 20-28 | - | |||
| 3006 | Ship-to Contact | Text[100] | 20-28 | - | |||
| 3007 | Ship-to Post Code | Code[20] | 20-28 | - | |||
| 3008 | Ship-to County | Text[30] | 20-28 | - | |||
| 3009 | Ship-to Country/Region Code | Code[10] | 20-28 | - | |||
| 3997 | No. of Archived Versions | Integer | 24-28 | - | |||
| 4000 | External Document No. | Code[35] | 20-28 | - | |||
| 4001 | Payment Method Code | Code[10] | 20-28 | - | |||
| 4002 | Payment Terms Code | Code[10] | 20-28 | - | |||
| 4003 | Your Reference | Text[35] | 20-28 | - | |||
| 7000 | Price Calculation Method | Enum Price Calculation Method | 17-28 | - | |||
| 7001 | Cost Calculation Method | Enum Price Calculation Method | 17-28 | - | |||
| 7300 | Completely Picked | Boolean | 20-28 | - | |||
| 8000 | Id | Guid | 17-25, gone | Removed 22.0 | |||
| This functionality will be replaced by the systemID field | |||||||