AR0 A/R Parameters (AR0_Parameters) Level: 4.40
Record Type: 1 A/R Parameter Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"A/R" . . . . . . . . . . . . . . . . . ARConstant. . . . . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
New System? (Y/N) . . . . . . . . . . . NewSystem . . . . . . . . . . Yes/No (7,1)
Divisions? (Y/N). . . . . . . . . . . . Divisions . . . . . . . . . . Yes/No (8,1)
Sales And Cash Receipts By Division?. . SalesAndCashRcptsByDivision . Yes/No (9,1)
G/L Segment To Use For A/R Sales PostingGLSegToUseForARSalesPo. . . . String (10,1)
Customer Credit Limits? (Y/N) . . . . . CustomerCreditLimits. . . . . Yes/No (11,1)
Customer Statements? (Y/N). . . . . . . CustomerStatements. . . . . . Yes/No (12,1)
Print Invoices? (Y/N) . . . . . . . . . PrintInvoices . . . . . . . . Yes/No (13,1)
Next Automatic Invoice Number . . . . . NextAutomaticInvoiceNumber. . String (14,7)
Open Item Or B/F Receivable (O,B,M) . . OpenItemBalForwardReceivable. String (21,1)
Age Invoice Report By Day Or Month. . . AgeInvoiceReportByDayOrMonth. String (22,1)
Aging Category 1. . . . . . . . . . . . AgingCategory1. . . . . . . . String (23,3)
Aging Category 2. . . . . . . . . . . . AgingCategory2. . . . . . . . String (26,3)
Aging Category 3. . . . . . . . . . . . AgingCategory3. . . . . . . . String (29,3)
Aging Category 4. . . . . . . . . . . . AgingCategory4. . . . . . . . String (32,3)
Salesperson And Commission Reporting. . SalespersonCommissionRpting . Yes/No (35,1)
Pay Commission On Paid Invoices . . . . PayCommissionOnPaidInvoices . Yes/No (36,1)
Calculate Commission On Net Or G/P. . . CalcCommissionNetOrGrossProf. String (37,1)
Finance Charge Computation Method . . . FinChargeComputationMethod. . String (38,1)
F/C Based On What Aging Category. . . . FCBasedOnWhatAgingCategory. . String (39,1)
Exclude Unpaid F/C From F/C Calculation ExcludeUnpaidFCFromFCCalc . . Yes/No (40,1)
Track Retention Recvbl? (If J/C Exists) TrackRetentionReceivable. . . Yes/No (41,1)
Post Cost Of Sales To G/L?. . . . . . . PostCostOfSalesToGL . . . . . Yes/No (42,1)
Current A/R Fiscal Year . . . . . . . . CurrentARFiscalYr . . . . . . Packed Year (43,2)
Retain Dep Trans Hist (N/C/R/O/A) . . . RetainDepositTransHist. . . . Uppercase (45,1)
Number Of Days Before Cr Card Exp . . . NoOfDaysBeforeCrdtCardExp . . Zero-Filled (46,3)
Print Tax Detail On Journals? . . . . . PrintTaxDetailOnJournals. . . Yes/No (49,1)
Print Tax Journals In Detail? . . . . . PrintTaxJournalsInDetail. . . Yes/No (50,1)
Display Partial Credit Card . . . . . . DisplayPartialCreditCard. . . Yes/No (51,1)
Period End Code . . . . . . . . . . . . PeriodEndCode . . . . . . . . String (52,1)
Segment # For F/C . . . . . . . . . . . SegmentNumberForFC. . . . . . String (53,4)
# Of Days To Retain Zero Bal Invoices . NoDaysToRetainZeroBalInvc . . Zero-Filled (57,3)
Age Invoices By Invoic Or Due Date (I,D)AgeInvoicesInvoiceOrDueDate . String (60,1)
# Of Days Past Due For F/C Calculation. NoOfDaysPastDueForFCCalc. . . Zero-Filled (61,3)
Current A/R Period. . . . . . . . . . . CurrentArPeriod . . . . . . . Zero-Filled (64,2)
Password Commssn/Cred Lmt Ovrride . . . PasswrdCommCrdtLimitOverride. Uppercase (66,7)
Require Sales Tax Rep?. . . . . . . . . RequireSalesTaxReporting. . . Yes/No (73,1)
Retain Detailed Invc Hist? (Y/N/S). . . RetainDetailedInvoiceHistory. Uppercase (74,1)
Post Sales To G/L In Detail? (Y/N). . . PostSalesToGLInDetail . . . . Yes/No (75,1)
Post Csh Recpts To G/L In Detl?(Y/N . . PostCashRcptsToGLInDetail . . Yes/No (76,1)
Includ Tax&Frght In Cust Sales Hist . . InclTaxFrghtInCustSalesHist . Yes/No (77,1)
Next Automatic Deposit Number . . . . . NextAutomaticDepNumber. . . . Zero-Filled (78,5)
Interfaced To Bank Rec? (Y/N) . . . . . InterfacedToBankRec . . . . . Yes/No (83,1)
Interfaced To Job Cost? (Y/N) . . . . . InterfacedToJobCost . . . . . Yes/No (84,1)
Track Deleted Invcs In Hist? (Y/N). . . TrackDelInvoicesInHistory . . Yes/No (85,1)
Track Comment Lines In Hist? (Y/N). . . TrackCommentLinesInHistory. . Yes/No (86,1)
Statements - Deflt Minimum Balance. . . StmntDefaultMinimumBalance. . String (87,12)
Statements - Deflt Zero Bal Cust? . . . StmntDefaultZeroBalanceCust . Yes/No (99,1)
Statements - Deflt Print Crdit Bal? . . StmntDefaultPrintCrditBal . . Uppercase (100,1)
Statements - Deflt Aging Category . . . StmntDefaultAgingCategory . . Uppercase (101,1)
Statements - Deflt Incld Temporary? . . StmntDefaultIncludeTemp . . . Uppercase (102,1)
Current A/R Calendar Year . . . . . . . CurrentArCalendarYr . . . . . Packed Year (103,2)
Min. F/C Amt Applied. . . . . . . . . . MinimumFCAmountApplied. . . . String (105,10)
Uses A Mask Of 6.2- . . . . . . . . . . . . . . . . . . . . . . . . Memo
Page Break C/R Journal By Dep.No. . . . PageBreakCRjrnlByDepNo. . . . Yes/No (115,1)
Statements - Deflt Zero Bal Inv?. . . . StmntDefaultZeroBalInvoice. . Yes/No (116,1)
Statements - Deflt Forms Code . . . . . StmntDefaultFormsCode . . . . Uppercase (117,2)
Allow Batch Entry for Invoices. . . . . AllowBatchEntryInvoices . . . Yes/No (119,1)
Password For Invoice Batch Entry. . . . PsswrdInvoiceBatchEntry . . . String (120,6)
Next Invoice Batch Number . . . . . . . NextInvoiceBatchNumber. . . . Uppercase (126,5)
Track Chgs To Cust Master File? . . . . TrackChngToCustomerMasterFile Uppercase (131,1)
(Y/N/D/A/C) . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Track Adds In Summ Or Dtl? (S/D). . . . TrackAddtnsInSummaryOrDetail. Uppercase (132,1)
Req Slspsn Comm Update To Oth Mods? . . SlsPrsnCommUpdateToOtherMod . Yes/No (133,1)
Retain Temp Customers with Paid InvoicesRetainTempCustsWithPaidInvcs. Yes/No (134,1)
Default Invoice Inquiry (A/D/I) . . . . DefaultInvoiceInquiry . . . . Uppercase (135,1)
Allow Credit Card Cash Receipts . . . . AllowCreditCardCashReceipts . Yes/No (136,1)
Customer Mask . . . . . . . . . . . . . CustomerMask. . . . . . . . . String (1,6)
Std. F/C Monthly Rate /Fixed Amt. . . . StdFinChrgRateFixedAmount . . Number [0] 9.2
Min. F/C Amt To Apply To Cust. Bal. . . MinFCAmountApplyToCustBal . . Number [1] 9.2
________
Total Bytes 173
AR0 A/R Parameters (AR0_Parameters) Level: 4.40
Record Type: 9 A/R Global Parameters 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"A/R" . . . . . . . . . . . . . . . . . ARConstant. . . . . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
"9" . . . . . . . . . . . . . . . . . . RecordNo. . . . . . . . . . . String *(7,1)
Application Interfacd To G/L? (Y/N) . . ApplicationInterfacedToGl . . Yes/No (8,1)
Allow Memo Inquiry-Data Ent?(Y/N/M) . . MemoInquiryDataEntry. . . . . Uppercase (9,1)
Allow Purge Option In G/L Recap Rpt . . AllowPurgeOptionInGLRecap . . Yes/No (10,1)
Default Bank Code . . . . . . . . . . . DefaultBankCode . . . . . . . String (11,1)
Allow Batch Entry for Cash Recpts . . . BatchEntryCashRecpt . . . . . Yes/No (12,1)
Password for CR Batch Entry . . . . . . PsswrdCashRecptEntry. . . . . String (13,6)
Next CR Batch Number. . . . . . . . . . NextCashRecptBatchNo. . . . . Uppercase (19,5)
Use GUI Invoices. . . . . . . . . . . . UseGUIInvoices. . . . . . . . Yes/No (24,1)
Use GUI Customer Statements . . . . . . UseGUICustomerStatements. . . Yes/No (25,1)
Use GUI Customer Mailing Labels . . . . UseGUICustMailingLabels . . . Yes/No (26,1)
Purge Cash Receipts at Period End . . . PurgeCashReceiptsAtPeriodEnd. Yes/No (27,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (28,73)
________
Total Bytes 102
AR0 A/R Parameters (AR0_Parameters) Level: 4.40
Record Type: B Batch Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Batch Record. . . . . . . . . . . . . . BatchRecord . . . . . . . . . String (1,128)
( 1, 1) "h". . . . . . . . . . . . . . . . . . . . . . . . . . Memo
( 2, 3) FID(0) Terminal ID . . . . . . . . . . . . . . . . . . Memo
( 5, 3) Application Code (A/A) . . . . . . . . . . . . . . . . Memo
( 8, 5) Batch Number . . . . . . . . . . . . . . . . . . . . . Memo
(13,116) Open String . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 130
AR0 A/R Parameters (AR0_Parameters) Level: 4.40
Record Type: Q 'Q' - Keys Of Quick Print - Invoices 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"Q" . . . . . . . . . . . . . . . . . . RecordNo. . . . . . . . . . . String *(1,1)
Terminal Id (Fid(0)). . . . . . . . . . TerminalID. . . . . . . . . . String *(2,3)
"A/R" . . . . . . . . . . . . . . . . . ApplicationCode . . . . . . . String *(5,3)
Program Name ('Arzrha'/'Arzrra'). . . . ProgramName . . . . . . . . . String (8,6)
Name Of Selection Screen Of Print . . . . . . . . . . . . . . . . . Memo
Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Key Of Record Quick Printing. . . . . . KeyOfRecordQuickPrint . . . . String (14,10)
Ar7$(1,9) Or Arn$(1,10) . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (24,77)
________
Total Bytes 102
AR0 A/R Parameters (AR0_Parameters) Level: 4.40
Record Type: v Version Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"v" Record. . . . . . . . . . . . . . . VRecord . . . . . . . . . . . String *(1,1)
Application Code. . . . . . . . . . . . ApplicationCode . . . . . . . String *(2,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3)
Version No. . . . . . . . . . . . . . . VersionNo . . . . . . . . . . String (8,10)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (18,83)
________
Total Bytes 102