TABLE DETAIL REFERENCE: Bill
(USA VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | |
| TxnNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| VendorRefListID | 12 | VARCHAR | 36 | True | True | True | True | %s | Yes |
| VendorRefFullName | 12 | VARCHAR | 41 | True | True | True | True | %s | Yes |
| VendorAddressAddr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressAddr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | |
| VendorAddressCity | 12 | VARCHAR | 31 | True | True | True | False | %s | |
| VendorAddressState | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| VendorAddressPostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | |
| APAccountRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| APAccountRefFullName | 12 | VARCHAR | 159 | True | True | True | False | %s | Yes |
| TxnDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| TxnDateMacro | 12 | VARCHAR | 23 | True | False | False | False | All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear | |
| DueDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| AmountDue | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 159 | True | False | False | False | %s | Yes |
| ExchangeRate | 3 | DECIMAL | 17 | True | True | True | False | %6.8f | |
| AmountDueInHomeCurrency | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| RefNumber | 12 | VARCHAR | 20 | True | True | True | False | %s | |
| TermsRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TermsRefFullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Yes |
| Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| IsTaxIncluded | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| SalesTaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| SalesTaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 3 | True | False | False | False | %s | Yes |
| LinkToTxnID1 | 12 | VARCHAR | 36 | True | False | True | False | %s | |
| IsPaid | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| Tax1Total | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| Tax2Total | 3 | DECIMAL | 17 | True | False | False | False | %10.2f | |
| OpenAmount | 3 | DECIMAL | 18 | True | False | False | False | %10.2f | |
| AmountIncludesVAT | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| CustomFieldBillALU | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillALU2 | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillApproved | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillColor | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillCompletedby | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillCustomer | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillInspectedBy | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillOrdered | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillPulled | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillPulledby | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillQtyPriceBreak | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillRequiredDate | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillStartDate | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillStyle | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupALU | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupALU2 | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupApproved | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupColor | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupCompletedby | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupCustomer | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupInspectedBy | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupOrdered | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupPulled | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupPulledby | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupQtyPriceBreak | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupRequiredDate | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupStartDate | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupStyle | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineALU | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineALU2 | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineApproved | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineColor | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineCompletedby | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineCustomer | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineInspectedBy | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineOrdered | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLinePulled | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLinePulledby | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineQtyPriceBreak | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineRequiredDate | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineStartDate | 12 | VARCHAR | 30 | True | False | True | False | %s | |
| CustomFieldBillGroupLineStyle | 12 | VARCHAR | 30 | True | False | True | False | %s |