     AR_TransactionPosting                  AR Transaction Posting         Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_SalesJournal_upd,SO_SalesJournal_upd,AR_CommissionEditRegister_upd
     SQL Def: N  SysDB: N                                 "MAS_"+%C$+"/AR"+%C$+"/AR_TransactionPosting.M4T"

     KPRIMARY: InvoiceNo
     KBATCH: BatchNo+InvoiceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {SO5$(1,7)}
       2  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {SO5$(8,6)}
       3  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
                                                    {SO5$(14,1)}
       4  SalesOrderNo. . . . . . . . .     7 SYN  Sales Order Number. . . . . . .SALESORDERNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED Notes: {SO5$(15,7)}
       5  OrderType . . . . . . . . . .     1 SYN  Order Type. . . . . . . . . . .
                                                    Valid:B,S,1 Notes: B=Backorde
                                                    r, S=Standard,1=One Step
                                                    {SO5$(428,1)}
       6  OrderDate . . . . . . . . . .     8 SNN  Order Date. . . . . . . . . . .DATE
                                                    Notes: {SO5$(430,6)}
       7  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    DepVal:REQUIRED Notes:
                                                    {SO5$(22,2)}
       8  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC DepVal:REQ
                                                    UIRED Notes: {SO5$(24,7)}
       9  BillToName. . . . . . . . . .    30 SNN  Bill-To Name. . . . . . . . . .NAME
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(31,30)}
      10  BillToAddress1. . . . . . . .    30 SNN  Bill-To Address 1 . . . . . . .ADDRESSLINE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(61,30)}
      11  BillToAddress2. . . . . . . .    30 SNN  Bill-To Address 2 . . . . . . .ADDRESSLINE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(91,30)}
      12  BillToAddress3. . . . . . . .    30 SNN  Bill-To Address 3 . . . . . . .ADDRESSLINE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(558,30)}
      13  BillToCity. . . . . . . . . .    20 SNN  Bill-To City. . . . . . . . . .CITY
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(121,20)}
      14  BillToState . . . . . . . . .     2 SYN  Bill-To State . . . . . . . . .STATE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(141,2)}
      15  BillToZipCode . . . . . . . .    10 SYN  Bill-To Zip Code. . . . . . . .ZIPCODE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(143,10)}
      16  BillToCountryCode . . . . . .     3 SYN  Bill-To Country Code. . . . . .COUNTRY
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(588,3)}
      17  ShipToCode. . . . . . . . . .     4 SYN  Ship-To Code. . . . . . . . . .SHIPTO
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(153,4)}
      18  ShipToName. . . . . . . . . .    30 SNN  Ship-To Name. . . . . . . . . .NAME
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(157,30)}
      19  ShipToAddress1. . . . . . . .    30 SNN  Ship-To Address 1 . . . . . . .ADDRESSLINE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(187,30)}
      20  ShipToAddress2. . . . . . . .    30 SNN  Ship-To Address 2 . . . . . . .ADDRESSLINE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(217,30)}
      21  ShipToAddress3. . . . . . . .    30 SNN  Ship-To Address 3 . . . . . . .ADDRESSLINE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(608,30)}
      22  ShipToCity. . . . . . . . . .    20 SNN  Ship-To City. . . . . . . . . .CITY
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(247,20)}
      23  ShipToState . . . . . . . . .     2 SYN  Ship-To State . . . . . . . . .STATE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(267,2)}
      24  ShipToZipCode . . . . . . . .    10 SYN  Ship-To Zip Code. . . . . . . .ZIPCODE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(269,10)}
      25  ShipToCountryCode . . . . . .     3 SYN  Ship-To Country Code. . . . . .COUNTRY
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(638,3)}
      26  ShipDate. . . . . . . . . . .     8 SNN  Ship Date . . . . . . . . . . .DATE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(280,6)}
      27  ShipVia . . . . . . . . . . .    15 SYN  Ship Via. . . . . . . . . . . .SHIPCODE
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(301,15)}
      28  ShipZone. . . . . . . . . . .     5 SYN  Ship Zone . . . . . . . . . . .SHIPZONE
                                                    ValGroup:CustomerRequired
                                                    Notes: (Maintained)
                                                    {SO5$(444,5)}
      29  ShipWeight. . . . . . . . . .     5 SYN  Ship Weight . . . . . . . . . .
                                                    Mask:00000 FmtType:CHARNUM
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(449,5)}
      30  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(286,15)}
      31  FOB . . . . . . . . . . . . .    15 SNN  F.O.B.. . . . . . . . . . . . .
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(316,15)}
      32  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:Mult
                                                    iWarehouse Notes: {SO5$(331,
                                                    3)}
      33  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(334,30)}
      34  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
                                                    Notes: {SO5$(364,30)}
      35  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    FmtType:CHARNUM ValGroup:Cust
                                                    omerRequired,ARSalesTax
                                                    Notes: {SO5$(394,9)}
      36  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .ARTERMS
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5$(403,2)}
      37  TaxExemptNo . . . . . . . . .    15 SNN  Tax Exempt Number . . . . . . .
                                                    ValGroup:CustomerRequired,
                                                    ARSalesTax Notes: (Only If
                                                    Sales Tax Reporting = Yes)
                                                    {SO5$(409,15)}
      38  CustomerType. . . . . . . . .     4 SYN  Customer Type . . . . . . . . .
                                                    ValGroup:CustomerRequired
                                                    Notes: (From Update)
                                                    {SO5$(436,4)}
      39  CheckNoForDeposit . . . . . .    10 SNN  Check Number For Deposit. . . .CHECKNO
                                                    FmtType:ZEROFILL Notes:
                                                    {SO5$(464,6)}
      40  ApplyToInvoiceNo. . . . . . .     7 SYN  Apply To Invoice Number . . . .
                                                    FmtType:CHARNUM ValGroup:Cust
                                                    omerRequired Notes: (For CM
                                                    & Dm Types) {SO5$(470,7)}
      41  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:CustomerRequired,
                                                    SalespersonReporting
      42  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM ValGroup:Sale
                                                    spersonReporting Notes:
                                                    {SO5$(405,4)}
      43  SplitCommissions. . . . . . .     1 SYN  Split Commissions . . . . . . .
                                                    Valid:Y,N,O ValGroup:SplitCom
                                                    mission,SalespersonRequired
                                                    Notes: Y=Yes, N=No,
                                                    O=Override {SO5$(478,1)}
      44  SalespersonDivisionNo2. . . .     2 SNN  Salesperson Division Number 2 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(479,2)}
      45  SalespersonNo2. . . . . . . .     4 SYN  Salesperson Number 2. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM DepVal:Requir
                                                    ed ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(481,4)}
      46  SalespersonDivisionNo3. . . .     2 SNN  Salesperson Division Number 3 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(492,2)}
      47  SalespersonNo3. . . . . . . .     4 SYN  Salesperson Number 3. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM DepVal:Requir
                                                    ed ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(494,4)}
      48  SalespersonDivisionNo4. . . .     2 SNN  Salesperson Division Number 4 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(505,2)}
      49  SalespersonNo4. . . . . . . .     4 SYN  Salesperson Number 4. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM DepVal:Requir
                                                    ed ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(507,4)}
      50  SalespersonDivisionNo5. . . .     2 SNN  Salesperson Division Number 5 .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(518,2)}
      51  SalespersonNo5. . . . . . . .     4 SYN  Salesperson Number 5. . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM DepVal:Requir
                                                    ed ValGroup:SplitCommission,
                                                    SalespersonRequired Notes:
                                                    {SO5$(520,4)}
      52  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                    Notes: {SO5$(531,6)}
      53  DiscountDueDate . . . . . . .     8 SNN  Discount Due Date . . . . . . .DATE
                                                    Notes: {SO5$(537,6)}
      54  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                    FmtType:ALPHANUM Notes:
                                                    {SO5$(553,5)}
      55  EBMSubmissionType . . . . . .     1 SYN  e-Business Manager Submission T
                                                    Read Only:Y Valid:M,A Notes:
                                                    M=Manual, A=Auto {SO5$(591,
                                                    1)}
      56  EBMUserIDSubmittingThisOrder.    15 SYN  e-Business Manager User ID Subm
                                                    Read Only:Y Notes: {SO5$(592,
                                                    15)}
      57  EBMUserType . . . . . . . . .     1 SYN  e-Business Manager User Type. .
                                                    Read Only:Y Valid:1,2 Notes:
                                                    1=bus., 2=consumer {SO5$(443,
                                                    1)}
      58  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                    Notes: {SO5$(641,17)}
      59  BatchFax. . . . . . . . . . .     1 SYN  Batch Fax . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {SO5$(441,1)}
      60  PaymentType . . . . . . . . .     5 SYN  Payment Type. . . . . . . . . .PAYMENTTYPE
                                                    Notes: {SO5$(658,5)}
      61  PaymentTypeCategory . . . . .     1 SYN  Payment Type Category . . . . .
                                                    Valid:P,D Notes: P=Payment,
                                                    D=Deposit {SO5$(836,1)}
      62  OtherPaymentTypeRefNo . . . .    24 SNN  Other Payment Type Reference Nu
                                                    Notes: {SO5$(663,24)}
      63  CorporateCustIDPurchOrder . .    25 SNN  Corporate Customer ID Purchase
      64  CorporateTaxOverrd. . . . . .     1 SYN  Corporate Tax Override. . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      65  DepositCorporateTaxOverrd . .     1 SYN  Deposit Corporate Tax Override.YESNO
                                                    DfltVal:N Valid:Y,N
      66  CardholderName. . . . . . . .    30 SNN  Cardholder Name . . . . . . . .NAME
                                                    Notes: {SO5$(687,30)}
      67  ExpirationDateYear. . . . . .     4 SNN  Expiration Date Year. . . . . .YEAR2
                                                    Notes: {SO5$(717,2)}
      68  ExpirationDateMonth . . . . .     2 SNN  Expiration Date Month . . . . .MONTH
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {SO5$(719,2)}
      69  EncryptedCreditCardNo . . . .    24 SNN  Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
                                                    Notes: {SO5$(739,24)}
      70  Last4UnencryptedCreditCardNos     4 SNN  Last 4 Unencrypted Credit Card
                                                    Notes: {SO5$(767,4)}
      71  CreditCardAuthorizationNo . .    16 SNN  Credit Card Authorization Numbe
                                                    Notes: {SO5$(771,16)}
      72  AuthorizationCodeForDeposit .    16 SNN  Authorization Code For Deposit.
                                                    DepVal:REQUIRED Notes:
                                                    {SO5$(810,16)}
      73  CreditCardTransactionID . . .    10 SNN  Credit Card Transaction ID. . .
                                                    Notes: {SO5$(787,10)}
      74  CreditCardTransactionIDForDep    10 SNN  Credit Card Transaction ID for
                                                    Notes: {SO5$(826,10)}
      75  ShipperID . . . . . . . . . .     3 SYN  Shipper ID. . . . . . . . . . .
                                                    Notes: {SO5$(848,3)}
      76  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM ValGroup:JCIn
                                                    tegrated
      77  RMANo . . . . . . . . . . . .     7 SYN  RMA Number. . . . . . . . . . .RMANO
                                                    FmtType:CHARNUM Notes:
                                                    {SO5$(721,7)}
      78  Adjustment. . . . . . . . . .     1 SYN  Adjustment Valid. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      79  RepetitiveInvoiceRefNo. . . .     4 SNN  Repetitive Invoice Reference Nu
      80  ResidentialAddress. . . . . .     1 SYY  Residential Address . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      81  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .EMAILADDRESS
      82  CRMCompanyID. . . . . . . . .    11 SNN  CRM Company ID. . . . . . . . .
      83  CRMOpportunityID. . . . . . .    11 SNN  CRM Opportunity ID. . . . . . .
      84  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
      85  CRMPersonID . . . . . . . . .    11 SNN  CRM Person ID . . . . . . . . .
      86  TaxableSubjectToDiscount. . . 13.2  NNN  Taxable Subject To Discount . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {SO5[1]}
      87  NonTaxableSubjectToDiscount . 13.2  NNN  Non-Taxable Subject To DiscountAMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {SO5[2]}
      88  TaxSubjToDiscPrcntOfTotSubjTo  8.2  NNN  Tax SubjectTo Disc % Of Total S
                                                    Mask:#,###.00- Notes:
                                                    {SO5[3]}
      89  DiscountRate. . . . . . . . .  9.3  NNN  Discount Rate . . . . . . . . .
                                                    Mask:#,###.000 ValGroup:Custo
                                                    merRequired Notes: {SO5[4]}
      90  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5[6]}
      91  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5[7]}
      92  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
                                                    ValGroup:CustomerRequired,
                                                    ARSalesTax Notes: {SO5[8]}
      93  DiscountAmt . . . . . . . . . 12.2  NNN  Discount Amount . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
                                                    ValGroup:CustomerRequired
                                                    Notes: {SO5[5]}
      94  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .
                                                    Mask:###,###,###.00
      95  TotalSubjectToComm. . . . . . 13.2  NNN  Total Subject To Commission . .AMOUNT
                                                    Mask:###,###,###.00
                                                    ValGroup:CustomerRequired
                                                    Notes: (Calc @ Pre-Update)
                                                    {SO5[9]}
      96  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                    Mask:###0.000 ValGroup:Custom
                                                    erRequired,SalespersonReporti
                                                    ng,SalespersonRequired
                                                    Notes: {SO5[10]}
      97  CommissionAmt . . . . . . . . 12.2  NNN  Commission Amount . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    (Calc @ Pre-Update) {SO5[11]}
      98  SplitCommRate2. . . . . . . .  9.3  NNN  Split Commission Rate 2 . . . .
                                                    Mask:###0.000 ValGroup:SplitC
                                                    ommission,SalespersonRequired
                                                     Notes: {SO5$(485,7)}
      99  SplitCommRate3. . . . . . . .  9.3  NNN  Split Commission Rate 3 . . . .
                                                    Mask:###0.000 ValGroup:SplitC
                                                    ommission,SalespersonRequired
                                                     Notes: {SO5$(498,7)}
     100  SplitCommRate4. . . . . . . .  9.3  NNN  Split Commission Rate 4 . . . .
                                                    Mask:###0.000 ValGroup:SplitC
                                                    ommission,SalespersonRequired
                                                     Notes: {SO5$(511,7)}
     101  SplitCommRate5. . . . . . . .  9.3  NNN  Split Commission Rate 5 . . . .
                                                    Mask:###0.000 ValGroup:SplitC
                                                    ommission,SalespersonRequired
                                                     Notes: {SO5$(524,7)}
     102  OverrideCommAmt . . . . . . . 12.2  NNN  Override Commissn Amount. . . .
                                                    Mask:##,###,###.00- Notes:
                                                    {SO5$(543,10)}
     103  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .
                                                    Mask:##,###,###.00- Notes:
                                                    {SO5[12]}
     104  CostOfGoodsSoldAmt. . . . . . 13.2  NNN  Cost Of Goods Sold  Amount. . .
                                                    Mask:###,###,###.00- Notes:
                                                    (Calc @ Pre-Update) {SO5[13]}
     105  CostOfGoodsSoldSubjToComm . . 13.2  NNN  Cost of Goods Sold Subject To C
                                                    Mask:###,###,###.00- Notes:
                                                    Calc @ Pre-Update) {SO5[14]}
     106  DepositAmt. . . . . . . . . . 13.2  NNN  Deposit Amount. . . . . . . . .
                                                    Mask:###,###,###.00- Notes:
                                                    {SO5[15]}
     107  Weight. . . . . . . . . . . . 12.2  NNN  Weight. . . . . . . . . . . . .
                                                    Mask:##,###,###.00- Notes:
                                                    {SO5[16]}
     108  CreditCardPreAuthorizationAmt 13.2  NNN  Credit Card Pre-Authorization A
                                                    Mask:###,###,###.00- Notes:
                                                    {SO5[17]}
     109  CreditCardPaymentBalanceAmt . 13.2  NNN  Credit Card Payment / Balance A
                                                    Mask:###,###,###.00- Notes:
                                                    {SO5[18]}
     110  NumberofPackages. . . . . . .  4.0  NNN  Number of Packages. . . . . . .
                                                    Mask:0000 Notes: {SO5$(853,
                                                    4)}
     111  DepositCorporateSalesTax. . . 12.2  NNN  Deposit Corporate Sales Tax . .MISCAMOUNT
                                                    Mask:##,###,###.00-
     112  CorporateSalesTax . . . . . . 12.2  NNN  Corporate Sales Tax . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00-
     113  UserCreatedKey. . . . . . . .    10 SYY  User Created Key. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
     114  UserUpdatedKey. . . . . . . .    10 SNN  User. . . . . . . . . . . . . .USER
                                                    Read Only:Y Mask:0000000000