| Internal ID | Type | nlapiSubmitField | Label | Required | Help |
|---|---|---|---|---|---|
| alternatesourceitem | text | false | Alternate Source Item | false | |
| analysisduration | integer | false | Historical Analysis Duration | false | |
| customform | select | false | Custom Form | false | |
| demandplancalendartype | select | false | View | false | |
| enddate | date | false | End Date | false | |
| externalid | text | false | ExternalId | false | |
| item | select | false | Item | true | |
| location | select | false | Location | true | |
| memo | text | false | Memo | false | |
| month | select | false | Month | false | |
| projectionduration | integer | false | Projection Duration | false | |
| projectioninterval | text | false | Projection Interval | false | |
| projectionmethod | text | false | Projection Method | false | |
| projectionstartdate | date | false | Projection Start Date | false | |
| startdate | date | false | Start Date | false | |
| subsidiary | select | false | Subsidiary | true | |
| units | select | false | Unit of Measure | false | |
| year | year | false | Year | false |
| Internal ID | Type | Label | Required |
|---|---|---|---|
| enddate | date | End Date | false |
| quantity_1_ | posfloat | Quantity | false |
| startdate | date | Start Date | false |
| systemcalculated | float | Monthly Calculated | false |
| Name | Label |
|---|---|
| demand | Demand |
| workflow | Workflow |
| Join ID | Join Description | Actual Join Name |
|---|---|---|
| location | Location | Location |
| Internal ID | Type | Label |
|---|---|---|
| alternatesourceitem | select | Last Alternate Source Item |
| analysisduration | integer | Last Historical Analysis Duration |
| demanddate | date | Demand Date |
| externalid | select | External ID |
| externalidstring | text | External ID (Text) |
| formuladate | date | Formula (Date) |
| formulanumeric | float | Formula (Numeric) |
| formulatext | text | Formula (Text) |
| internalid | select | Internal ID |
| internalidnumber | integer | Internal ID (Number) |
| item | select | Item |
| lastmodifieddate | datetime | Last Plan Modified |
| location | select | Location |
| memo | text | Memo |
| projectionduration | integer | Last Projection Duration |
| projectioninterval | select | Last Projection Interval |
| projectionmethod | select | Last Projection Method |
| projectionstartdate | date | Last Projection Start Date |
| quantity | float | Quantity |
| subsidiary | select | Subsidiary |
| units | select | Units |
| Internal ID | Type | Label |
|---|---|---|
| alternatesourceitem | select | Last Alternate Source Item |
| analysisduration | integer | Last Historical Analysis Duration |
| demanddate | date | Demand Date |
| externalid | select | External ID |
| formulacurrency | currency | Formula (Currency) |
| formuladate | date | Formula (Date) |
| formuladatetime | datetime | Formula (Date/Time) |
| formulanumeric | float | Formula (Numeric) |
| formulapercent | percent | Formula (Percent) |
| formulatext | text | Formula (Text) |
| internalid | select | Internal ID |
| item | select | Item |
| lastmodifieddate | datetime | Last Plan Modified |
| location | select | Location |
| memo | text | Memo |
| projectionduration | integer | Last Projection Duration |
| projectioninterval | text | Last Projection Interval |
| projectionmethod | text | Last Projection Method |
| projectionstartdate | date | Last Projection Start Date |
| quantity | float | Quantity |
| quantityuom | float | Quantity in Demand Plan Units |
| subsidiary | select | Subsidiary |
| units | select | Units |