| Internal ID | Type | nlapiSubmitField | Label | Required | Help |
|---|---|---|---|---|---|
| customform | select | false | Custom Form | false | |
| externalid | text | false | ExternalId | false | |
| item | select | false | Item | true | |
| location | select | false | Location | true | |
| memo | text | false | Memo | false | |
| subsidiary | select | false | Subsidiary | true | |
| units | select | false | Unit of Measure | false |
| Internal ID | Type | Label | Required |
|---|---|---|---|
| orderdate | date | Order Date | true |
| ordertype | select | Order Type | true |
| quantity | posfloat | Quantity | true |
| receiptdate | date | Receipt Date | true |
| Name | Label |
|---|---|
| orders | Orders |
| workflow | Workflow |
| Join ID | Join Description | Actual Join Name |
|---|---|---|
| location | Location | Location |
| Internal ID | Type | Label |
|---|---|---|
| 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 |
| ordercreated | checkbox | Order Created |
| orderdate | date | Order Date |
| ordertype | select | Order Type |
| quantity | float | Quantity |
| receiptdate | date | Receipt Date |
| subsidiary | select | Subsidiary |
| units | select | Units |
| Internal ID | Type | Label |
|---|---|---|
| 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 |
| ordercreated | checkbox | Order Created |
| orderdate | date | Order Date |
| ordertype | select | Order Type |
| quantity | float | Quantity |
| quantityuom | float | Quantity in Supply Plan Units |
| receiptdate | date | Receipt Date |
| subsidiary | select | Subsidiary |
| units | select | Units |