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. |