JCA J/C Job Type Master File (JCA_JobTypMasterfile) Level: 4.40 Record Type: 1 Job Type Masterfile 08/28/2009 File Type: Direct Key Size: 3 Rec Len: 328 Min Len: 296 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase *(1,3) Job Type Description. . . . . . . . . . Description . . . . . . . . . String (4,30) Accnt Method (P=% Cmplt, C=Cmplt Cntrct)AcctMethod. . . . . . . . . . Uppercase (34,1) Bill Method (None, Fix, Time & Mat) . . BillMethod. . . . . . . . . . Uppercase (35,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (36,1) Retain Jtd Cost Detail? (Y/N) . . . . . RetainJtdCostDetail . . . . . Yes/No (37,1) Description Of Units Per Job. . . . . . DescriptionOfUnitsPerJob. . . String (38,10) G/L Revenue Account . . . . . . . . . . GLRevenueAcctNumber . . . . . G/L Account (48,9) Cost Types Maintained . . . . . . . . . CostTypesMaintained . . . . . String (57,12) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (69,3) Cost Type 1 Work In Process Account . . WipAcct1. . . . . . . . . . . G/L Account (72,9) Cost Type 1 Cost Of Sales Account . . . CosAcct1. . . . . . . . . . . G/L Account (81,9) Cost Type 2 Wip Account . . . . . . . . WipAcct2. . . . . . . . . . . G/L Account (90,9) Cost Type 2 Cos Account . . . . . . . . CosAcct2. . . . . . . . . . . G/L Account (99,9) Cost Type 3 Wip Account . . . . . . . . WipAcct3. . . . . . . . . . . G/L Account (108,9) Cost Type 3 Cos Account . . . . . . . . CosAcct3. . . . . . . . . . . G/L Account (117,9) Cost Type 4 Wip Account . . . . . . . . WipAcct4. . . . . . . . . . . G/L Account (126,9) Cost Type 4 Cos Account . . . . . . . . CosAcct4. . . . . . . . . . . G/L Account (135,9) Cost Type 5 Wip Account . . . . . . . . WipAcct5. . . . . . . . . . . G/L Account (144,9) Cost Type 5 Cos Account . . . . . . . . CosAcct5. . . . . . . . . . . G/L Account (153,9) Cost Type 6 Wip Account . . . . . . . . WipAcct6. . . . . . . . . . . G/L Account (162,9) Cost Ttpe 6 Cos Account . . . . . . . . CosAcct6. . . . . . . . . . . G/L Account (171,9) Cost Type 7 Wip Account . . . . . . . . WipAcct7. . . . . . . . . . . G/L Account (180,9) Cost Type 7 Cos Account . . . . . . . . CosAcct7. . . . . . . . . . . G/L Account (189,9) Cost Type 8 Wip Account . . . . . . . . WipAcct8. . . . . . . . . . . G/L Account (198,9) Cost Type 8 Cos Account . . . . . . . . CosAcct8. . . . . . . . . . . G/L Account (207,9) Cost Type 9 Wip Account . . . . . . . . WipAcct9. . . . . . . . . . . G/L Account (216,9) Cost Type 9 Cos Account . . . . . . . . CosAcct9. . . . . . . . . . . G/L Account (225,9) Cost Type 10 Wip Account. . . . . . . . WipAcct10 . . . . . . . . . . G/L Account (234,9) Cost Type 10 Cos Account. . . . . . . . CosAcct10 . . . . . . . . . . G/L Account (243,9) Cost Type 11 Wip Account. . . . . . . . WipAcct11 . . . . . . . . . . G/L Account (252,9) Cost Type 11 Cos Account. . . . . . . . CosAcct11 . . . . . . . . . . G/L Account (261,9) Cost Type 12 Wip Account. . . . . . . . WipAcct12 . . . . . . . . . . G/L Account (270,9) Cost Type 12 Cos Account. . . . . . . . CosAcct12 . . . . . . . . . . G/L Account (279,9) Deferred Revenue Account. . . . . . . . DeferredRevenueAcct . . . . . G/L Account (288,9) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (297,21) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. ________ Total Bytes 320