Label | ID | Type | UI Workbook | SuiteScript / SuiteTalk REST Web Services | Connect |
---|---|---|---|---|---|
Amount Due | amountdue | currency | Yes | Yes | Yes |
Amount Paid | amountpaid | currency | Yes | Yes | Yes |
Bill To Select | billaddresslist | select | Yes | Yes | Yes |
Currency | currency | select | Yes | Yes | Yes |
Customer | customer | select | Yes | Yes | Yes |
Customer Name | customername | select | Yes | Yes | Yes |
Date | trandate | date | Yes | Yes | Yes |
Discount Total | discounttotal | currency | Yes | Yes | Yes |
Due Date | duedate | date | Yes | Yes | Yes |
ExternalId | externalid | text | Yes | Yes | Yes |
Grouped By PO # | groupedbypo | checkbox | Yes | Yes | Yes |
Handling Cost | handlingcost | currency | Yes | Yes | Yes |
ID | id | integer | Yes | Yes | Yes |
Invoice Group Number | invoicegroupnumber | text | Yes | Yes | Yes |
Last Modified | lastmodifieddate | datetime | Yes | Yes | Yes |
Memo | memo | text | Yes | Yes | Yes |
Modified By | lastmodifiedby | select | Yes | Yes | Yes |
-No label- | datedriven | radio | Yes | Yes | Yes |
-No label- | dayofmonthnetdue | integer | Yes | Yes | Yes |
-No label- | daysuntilnetdue | integer | Yes | Yes | Yes |
-No label- | duenextmonthifwithindays | integer | Yes | Yes | Yes |
PO # | ponumber | text | Yes | Yes | Yes |
Shipping Cost | shippingcost | currency | Yes | Yes | Yes |
Status | status | select | Yes | Yes | Yes |
Subsidiary | subsidiary | select | Yes | Yes | Yes |
Tax | taxtotal | currency | Yes | Yes | Yes |
Terms | terms | select | Yes | Yes | Yes |
Total | total | currency | Yes | Yes | Yes |
Join | Target Record | UI Workbook | SuiteScript / SuiteTalk REST Web Services | Connect |
---|---|---|---|---|
Invoice Group to Address (entityAddressbook.internalid) | invoice group (invoicegroup, invoicegroup.billaddresslist) | No | Yes | Yes |
Invoice Group to Currency (currency.id) | invoice group (invoicegroup, invoicegroup.currency) | No | Yes | Yes |
Invoice Group to Customer (customer.id) | invoice group (invoicegroup, invoicegroup.customer) | No | Yes | Yes |
Invoice Group to Entity (entity.id) | invoice group (invoicegroup, invoicegroup.lastmodifiedby) | No | Yes | Yes |
Invoice Group to Subsidiary (subsidiary.id) | invoice group (invoicegroup, invoicegroup.subsidiary) | No | Yes | Yes |
Invoice Group to Terms (term.id) | invoice group (invoicegroup, invoicegroup.terms) | No | Yes | Yes |