AR_InvoiceWrk AR Invoice Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_InvoicePrinting_rpt,AR_InvoiceHistoryPrinting_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 GroupField. . . . . . . . . . 15 SNN Group Field . . . . . . . . . .
3 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .
4 HeaderSeqNo . . . . . . . . . 6 SNN Header Sequence Number. . . . .
5 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . .
DfltVal:IN
6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
7 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
8 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE
9 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .
10 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .
11 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . .
12 SoldTo. . . . . . . . . . . . 30 SNN Sold To Name. . . . . . . . . .
13 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .
14 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .
15 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . .
16 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .
17 State . . . . . . . . . . . . 3 SNN State . . . . . . . . . . . . .
18 ZipCode . . . . . . . . . . . 10 SNN Zip Code. . . . . . . . . . . .
19 CountryCode . . . . . . . . . 3 SNN Country Code. . . . . . . . . .
20 CountryName . . . . . . . . . 30 SNN Country Name. . . . . . . . . .
21 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .
22 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .
23 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
24 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .
25 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .
26 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . .
27 ShipMethod. . . . . . . . . . 15 SNN Ship Method . . . . . . . . . .
28 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .
29 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .
30 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . .
31 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .
32 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . .
33 InvalidTaxCalc. . . . . . . . 1 SNN Invalid Tax Calculation . . . .
34 TaxCode1. . . . . . . . . . . 15 SNN Tax Code 1. . . . . . . . . . .
35 TaxCode2. . . . . . . . . . . 15 SNN Tax Code 2. . . . . . . . . . .
36 TaxCode3. . . . . . . . . . . 15 SNN Tax Code 3. . . . . . . . . . .
37 TaxCode4. . . . . . . . . . . 15 SNN Tax Code 4. . . . . . . . . . .
38 TaxCode1Desc. . . . . . . . . 30 SNN Tax Code 1 Description. . . . .
39 TaxCode2Desc. . . . . . . . . 30 SNN Tax Code 2 Description. . . . .
40 TaxCode3Desc. . . . . . . . . 30 SNN Tax Code 3 Description. . . . .
41 TaxCode4Desc. . . . . . . . . 30 SNN Tax Code 4 Description. . . . .
42 ExemptionNo1. . . . . . . . . 20 SNN Exemption Number 1. . . . . . .
43 ExemptionNo2. . . . . . . . . 20 SNN Exemption Number 2. . . . . . .
44 ExemptionNo3. . . . . . . . . 20 SNN Exemption Number 3. . . . . . .
45 ExemptionNo4. . . . . . . . . 20 SNN Exemption Number 4. . . . . . .
46 RegistrationNo1 . . . . . . . 20 SNN Registration Number 1 . . . . .
47 RegistrationNo2 . . . . . . . 20 SNN Registration Number 2 . . . . .
48 RegistrationNo3 . . . . . . . 20 SNN Registration Number 3 . . . . .
49 RegistrationNo4 . . . . . . . 20 SNN Registration Number 4 . . . . .
50 JobNo . . . . . . . . . . . . 7 SNN Job Number. . . . . . . . . . .
51 LineNumber. . . . . . . . . . 6 SNN Line Number . . . . . . . . . .
52 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . .
53 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
54 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .
55 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . .
56 SalesAcctKey. . . . . . . . . 9 SNN Sales Account Key . . . . . . .
57 SalesAccount. . . . . . . . . 41 SNN Fully Formatted Sales Acccount.
58 CostOfGoodsSoldAcctKey. . . . 9 SNN Cost of Goods Sold Account Key.
59 CostOfGoodsSoldAccount. . . . 41 SNN Fully Formatted Cost of Goods S
60 InventoryAcctKey. . . . . . . 9 SNN Inventory Account Key . . . . .
61 InventoryAccount. . . . . . . 41 SNN Fully Formatted Inventory Accou
62 TaxClass. . . . . . . . . . . 2 SNN Tax Class . . . . . . . . . . .
63 CommentText . . . . . . . . . 2048 SNN Comment Text. . . . . . . . . .
64 SubjectToExemption. . . . . . 1 SNN Subject To Exemption. . . . . .
65 MessageLine1. . . . . . . . . 50 SNN Message Line 1. . . . . . . . .
66 MessageLine2. . . . . . . . . 50 SNN Message Line 2. . . . . . . . .
67 FaxSendToCompany. . . . . . . 30 SNN Fax Send To Company . . . . . .
68 FaxSendToName . . . . . . . . 30 SNN Fax Send To Name. . . . . . . .
69 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
70 PLPrint . . . . . . . . . . . 1 SYN Paperless Office Print CustomerYESNO
DfltVal:N Valid:Y,N
71 PLEmail . . . . . . . . . . . 1 SYN Paperless Office E-Mail CustomeYESNO
DfltVal:N Valid:Y,N
72 PLFax . . . . . . . . . . . . 1 SYN Paperless Office Fax Customer .YESNO
DfltVal:N Valid:Y,N
73 PLPDF . . . . . . . . . . . . 1 SYN Paperless Office Create PDF . .YESNO
DfltVal:N Valid:Y,N
74 Quantity. . . . . . . . . . . 12.3 NNN Quantity. . . . . . . . . . . .
75 Price . . . . . . . . . . . . 12.3 NNN Price . . . . . . . . . . . . .
76 Cost. . . . . . . . . . . . . 12.3 NNN Cost. . . . . . . . . . . . . .
77 ExtensionAmt. . . . . . . . . 12.2 NNN Extension Amount. . . . . . . .
78 TaxableSalesAmt . . . . . . . 14.2 NNN Taxable Sales Amount. . . . . .
79 NonTaxableSalesAmt. . . . . . 14.2 NNN Non Taxable Sales Amount. . . .
80 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .
81 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .
82 SalesTaxAmt1. . . . . . . . . 12.2 NNN Sales Tax Amount 1. . . . . . .
83 SalesTaxAmt2. . . . . . . . . 12.2 NNN Sales Tax Amount 2. . . . . . .
84 SalesTaxAmt3. . . . . . . . . 12.2 NNN Sales Tax Amount 3. . . . . . .
85 SalesTaxAmt4. . . . . . . . . 12.2 NNN Sales Tax Amount 4. . . . . . .
86 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . .
87 CurrentBalance. . . . . . . . 14.2 NNN Current Balance . . . . . . . .
88 AgingCategory1. . . . . . . . 14.2 NNN Aging Category 1. . . . . . . .
89 AgingCategory2. . . . . . . . 14.2 NNN Aging Category 2. . . . . . . .
90 AgingCategory3. . . . . . . . 14.2 NNN Aging Category 3. . . . . . . .
91 AgingCategory4. . . . . . . . 14.2 NNN Aging Category 4. . . . . . . .