Report Desk: Column Formats
|
Format |
Description |
|
AcctNo |
Display a 24-digit account number based on Company setup. For example, if the company uses 4-digit main account and 2-digit profit center, then the value 000012340000005600000000 would be displayed as 1234-56. |
|
AcctMain |
Display just the main part of the account number, based on Company setup. |
|
Accum |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for accumulated totals. |
|
AccumZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for accumulated totals, except that a value of zero will not display. |
|
C |
Display using default currency format; negative numbers in parentheses. |
|
C0 to C6 |
Display in currency format with the specified number of decimals. |
|
Cost |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for cost fields. |
|
CostZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for cost fields, except that a value of zero will not display. |
|
CustNo |
Display as a customer number – right-justified and zero filled if numeric; otherwise left-justified. |
|
Bool |
Display as Y or N, depending on whether the value is True or False |
|
D |
Display in default digits format, using numeric digits only. |
|
D1 to D9 |
Display in digits format, showing the specified number of digits. |
|
Date-6 |
Display a date in MM/DD/YY format. |
|
Date-8 |
Display a date in MM/DD/YYYY format. |
|
DocNo |
Display as a document number – right-justified and zero filled if numeric; otherwise left-justified. |
|
|
Display left justified, removing any left- or right-brackets ( [ or ] ). |
|
FedID |
Display in federal identification number format: nn-nnnnnnn. |
|
File |
Display without any formatting. |
|
GLEntity |
Display the last two parts of an account number, separated by a dash. |
|
GLEntityZ |
Display the last two parts of an account number, separated by a dash, except that nothing is displayed if the last two parts of the account number are zeroes or spaces. |
|
ItemNo |
Display as an item number – left-justified. |
|
N |
Display in default number format, using thousands separator and decimal point. |
|
N0 to N6 |
Display in number format, using thousands separator and decimal point, with the specified number of decimals. |
|
PONo |
Display as a two-part purchase order number, separated by a dash. |
|
PO25 |
Display left-justified with no additional formatting. |
|
Price |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for price fields. |
|
PriceZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for price fields, except that a value of zero will not display. |
|
Quantity or Qty |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for quantity fields. |
|
QuantityZ or QtyZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for quantity fields, except that a value of zero will not display. |
|
SlmNo |
Display as a salesperson number – right-justified and zero filled if numeric; otherwise left-justified. |
|
SSN |
Display in Social Security number format: nn-nn-nnnn. |
|
String |
Display without any formatting. |
|
Time-4 |
Display the hours and minutes as HH:MM. |
|
Time-6 |
Display the hours, minutes and seconds as HH:MM:SS. |
|
TrackNo |
Display as a tracking number – left-justified. |
|
UDR |
Display without any formatting. |
|
UPC |
Display as a UPC number – left-justified. |
|
VendNo |
Display as a vendor number – right-justified and zero filled if numeric; otherwise left-justified. |
|
Z |
Display in default number format, with thousands separator and decimal point, except that a value of zero will not display. |
|
Z0 to Z6 |
Display in number format, with thousands separator and the specified number of decimals, except that a value of zero will not display. |
|
ZipCd |
Display left-justified, removing any left- or right-brackets ( [ or ] ). |
|
$ |
Display in default currency format, except that a value of zero will not display. |
|
$0 to $6 |
Display in currency format, showing the specified number of decimals, except that a value of zero will not display. |