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