SO_SalesJournalWrk SO Sales Journal Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_SalesJournalWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 GroupField. . . . . . . . . . 2 SNN Group Field . . . . . . . . . . 3 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM 4 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . . Mask:000000 FmtType:ZEROFILL Notes: {SO_18$(8,2)} 5 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM 6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 7 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . . Valid:CM,DM,IN,AD,FC,CA,XD Notes: CM=Credit Memo, DM=Debit Memo, IN=Invoice, AD=Adjustment., FC=Finance Charge, CA=Cash, XD=Deleted 8 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 9 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . . FmtType:CHARNUM ValGroup:Cust omerRequired Notes: (For CM & Dm Types) {SO5$(470,7)} 10 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL DepVal:REQUIRED 11 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . .DESCRIPTION 12 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO DepVal:REQUIRED 13 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 14 TermsCode . . . . . . . . . . 2 SNY AR Terms Code . . . . . . . . .ARTERMS FmtType:ZEROFILL Notes: {ARF$(1,2)} 15 CreditHold. . . . . . . . . . 1 SYN Credit Hold . . . . . . . . . .YESNO DfltVal:N 16 CreditLimitExceeded . . . . . 1 SYN Credit Limit Exceeded . . . . .YESNO DfltVal:N 17 WithinCreditMargin. . . . . . 1 SYN Within Credit Margin. . . . . .YESNO DfltVal:N Valid:Y,N 18 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:ALPHANUM 19 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE Notes: {SY_03$(1,15)} 20 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO DfltVal:N 21 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:ALPHANUM 22 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:ALPHANUM 23 JobDesc . . . . . . . . . . . 30 SNN Job Description . . . . . . . .DESCRIPTION 24 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:ALPHANUM 25 Overridden. . . . . . . . . . 1 SNN Overridden. . . . . . . . . . . 26 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 27 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00 28 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- 29 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- 30 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . . Mask:##,###,###.00- 31 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . . Mask:###,###,###.00- 32 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00