AR_TrialBalanceWrk AR Trial Balance Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_TrialBalance_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_TrialBalanceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SYY Sort Field. . . . . . . . . . . 2 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 3 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . . 4 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO 5 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 6 InvoiceNo . . . . . . . . . . 7 SYN Invoice Number. . . . . . . . .INVOICE 7 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . . 8 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL 9 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 10 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE 11 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE 12 TransactionType . . . . . . . 1 SYN Transaction Type. . . . . . . . 13 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 14 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . .CHECKNO 15 PaymentReference. . . . . . . 10 SNN Payment Reference . . . . . . . 16 PaymentDate . . . . . . . . . 8 SNN Payment Date. . . . . . . . . .DATE 17 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . . 18 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . . 19 CreditLimitExceeded . . . . . 1 SYN Credit Limit Exceeded . . . . .YESNO DfltVal:N Valid:Y,N 20 CreditHold. . . . . . . . . . 1 SNN Credit Hold . . . . . . . . . . 21 InvoiceAmt. . . . . . . . . . 14.2 NNN Invoice Amount. . . . . . . . . 22 DiscountAmt . . . . . . . . . 14.2 NNN Discount Amount . . . . . . . . 23 Balance . . . . . . . . . . . 14.2 NNN Balance . . . . . . . . . . . . 24 RetentionBalance. . . . . . . 14.2 NNN Retention Balance . . . . . . . 25 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . .TRANSACTIONAMT Mask:###,###,###.00-