CreditMemo Table
Column | Data type | Data type name | Length | Can be queried? | Can be updated? | Can be inserted? | Mandatory when inserting? | Format | Refers To | Version introduced in | Edition available in |
---|---|---|---|---|---|---|---|---|---|---|---|
TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | 1.0 | US, CA, UK | |
TimeCreated | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | 1.0 | US, CA, UK | |
TimeModified | 93 | TIMESTAMP | 23 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | 1.0 | US, CA, UK | |
EditSequence | 12 | VARCHAR | 16 | True | False | False | False | %s | 1.0 | US, CA, UK | |
TxnNumber | 4 | INTEGER | 9 | True | False | False | False | %11.0f | 1.0 | US, CA, UK | |
CustomerRef_ListID | 12 | VARCHAR | 36 | True | True | True | True | %s | ListID | 1.0 | US, CA, UK |
CustomerRef_FullName | 12 | VARCHAR | 209 | True | True | True | True | %s | FullName | 1.0 | US, CA, UK |
ClassRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
ClassRef_FullName | 12 | VARCHAR | 159 | True | True | True | False | %s | FullName | 1.0 | US, CA, UK |
ARAccountRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
ARAccountRef_FullName | 12 | VARCHAR | 159 | True | True | True | False | %s | FullName | 1.0 | US, CA, UK |
TemplateRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 3.0 | US, CA, UK |
TemplateRef_FullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Name | 3.0 | US, CA, UK |
TxnDate | 91 | DATE | 10 | True | True | True | False | CCCC-MM-DD | 1.0 | US, CA, UK | |
TxnDateMacro | 12 | VARCHAR | 25 | 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 | 1.0 | US, CA, UK | |
RefNumber | 12 | VARCHAR | 11 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_Addr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_Addr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_Addr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_Addr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | 2.0 | US, CA, UK | |
BillAddress_Addr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | 6.0 | US, CA, UK | |
BillAddress_City | 12 | VARCHAR | 31 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_State | 12 | VARCHAR | 21 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_PostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_Country | 12 | VARCHAR | 31 | True | True | True | False | %s | 1.0 | US, CA, UK | |
BillAddress_Note | 12 | VARCHAR | 41 | True | True | True | False | %s | 6.0 | US, CA, UK | |
BillAddressBlock_Addr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
BillAddressBlock_Addr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
BillAddressBlock_Addr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
BillAddressBlock_Addr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
BillAddressBlock_Addr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
ShipAddress_Addr1 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_Addr2 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_Addr3 | 12 | VARCHAR | 41 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_Addr4 | 12 | VARCHAR | 41 | True | True | True | False | %s | 2.0 | US, CA, UK | |
ShipAddress_Addr5 | 12 | VARCHAR | 41 | True | True | True | False | %s | 6.0 | US, CA, UK | |
ShipAddress_City | 12 | VARCHAR | 31 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_State | 12 | VARCHAR | 21 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_PostalCode | 12 | VARCHAR | 13 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_Country | 12 | VARCHAR | 31 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipAddress_Note | 12 | VARCHAR | 41 | True | True | True | False | %s | 6.0 | US, CA, UK | |
ShipAddressBlock_Addr1 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
ShipAddressBlock_Addr2 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
ShipAddressBlock_Addr3 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
ShipAddressBlock_Addr4 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
ShipAddressBlock_Addr5 | 12 | VARCHAR | 41 | True | False | False | False | %s | 6.0 | US, CA, UK | |
IsPending | -7 | BIT | 2 | True | True | True | False | 1 0 true false | 1.0 | US, CA, UK | |
PONumber | 12 | VARCHAR | 25 | True | True | True | False | %s | 1.0 | US, CA, UK | |
TermsRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
TermsRef_FullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Name | 1.0 | US, CA, UK |
DueDate | 91 | DATE | 10 | True | True | True | False | CCCC-MM-DD | 1.0 | US, CA, UK | |
SalesRepRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
SalesRepRef_FullName | 12 | VARCHAR | 5 | True | True | True | False | %s | Initial | 1.0 | US, CA, UK |
FOB | 12 | VARCHAR | 13 | True | True | True | False | %s | 1.0 | US, CA, UK | |
ShipDate | 91 | DATE | 10 | True | True | True | False | CCCC-MM-DD | 1.0 | US, CA, UK | |
ShipMethodRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
ShipMethodRef_FullName | 12 | VARCHAR | 15 | True | True | True | False | %s | Name | 1.0 | US, CA, UK |
Subtotal | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 1.0 | US, CA, UK | |
ItemSalesTaxRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
ItemSalesTaxRef_FullName | 12 | VARCHAR | 31 | True | True | True | False | %s | Name | 1.0 | US, CA, UK |
SalesTaxPercentage | 2 | NUMERIC | 18 | True | False | False | False | %10.5f | 1.0 | US, CA, UK | |
SalesTaxTotal | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 1.0 | US, CA, UK | |
TotalAmount | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 1.0 | US, CA, UK | |
CreditRemaining | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 2.0 | US, CA, UK | |
CreditRemainingInHomeCurrency | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 8.0 | US, CA, UK | |
CurrencyRef_ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | ListID | 8.0 | US, CA, UK |
CurrencyRef_FullName | 12 | VARCHAR | 64 | True | False | False | False | %s | name | 8.0 | US, CA, UK |
ExchangeRate | 2 | NUMERIC | 15 | True | True | True | False | %6.6f | 8.0 | US, CA, UK | |
Memo | 12 | VARCHAR | 4095 | True | True | True | False | %s | 1.0 | US, CA, UK | |
CustomerMsgRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
CustomerMsgRef_FullName | 12 | VARCHAR | 101 | True | True | True | False | %s | Name | 1.0 | US, CA, UK |
IsToBePrinted | -7 | BIT | 2 | True | True | True | False | 1 0 true false | 1.0 | US, CA, UK | |
IsToBeEmailed | -7 | BIT | 2 | True | True | True | False | 1 0 true false | 6.0 | US, CA, UK | |
CustomerSalesTaxCodeRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
CustomerSalesTaxCodeRef_FullName | 12 | VARCHAR | 3 | True | True | True | False | %s | Name | 1.0 | US, CA, UK |
CustomerTaxCodeRef_ListID | 12 | VARCHAR | 36 | True | True | True | False | %s | ListID | 1.0 | US, CA, UK |
Other | 12 | VARCHAR | 29 | True | True | True | False | %s | 6.0 | US, CA, UK | |
ExternalGUID | 12 | VARCHAR | 40 | 9.0 | US, CA, UK |